A real estate deal tracker for small brokerages
A real estate deal tracker for small brokerages is the list of files the office is working: who is on each one, what happens next, and, when it closes, how the commission was split.
In a small brokerage the broker is often the person who opens the file, chases the documents, reviews them and works out the commission. A deal tracker is how that person sees the week without opening twenty email threads. Call each row a file. Its type is a listing, a buyer side, or a referral. The address, or the referral partner, is the name. Everything else on the row is there to answer one question: what does the office do next?
What the list has to show
A directory of addresses is not a tracker. Each open file needs these, and no more.
- Who is on it: the agent, and anyone else the office has assigned.
- The price, and whether it is still the contract price or the price it will close at.
- The next step, in words a person can act on, not a stage code.
- The dates that can pass without anyone noticing: inspection, financing, closing.
- Where the documents stand: in, missing, or waiting for the office to review them.
Closed files leave that list. They stay in the year's record, with the commission and the statement, but they should not sit in the way of the files that still need a person. A tracker that mixes open and closed work trains people to scroll past both.
One checklist, not a folder of attachments
The documents are part of the tracker. A file with a stack of uploads and no line for each one still needs someone to remember what is missing. Put the lines on the file first. A document dropped on the file should land on its line, and anything that does not match should wait for a person rather than vanish into a folder.
A listing and a buyer side are not the same list. The listing has lines that exist before there is a contract. The buyer file starts at the contract. Which lines belong on which is in listing checklist versus a buyer file. What the office keeps after closing, and for how long, is a separate decision, covered in what to keep in a transaction file.
Dates, or the list lies
A file with no dates looks fine until the inspection period has already ended. Count the days from the contract date, write the closing date when you have it, and put inspection and financing on the file as their own dates. The transaction timeline calculator does that arithmetic from the contract date. A tracker that sorts by closing day, and that can show only this week, is the one a broker with a full Tuesday will actually open.
Who is allowed to look
A small office does not need everyone to see everything. The broker-owner sees the office. An office manager sees the files they are trusted with. An agent sees their own files, their own cap and their own statements, and should not have to ask which documents are still missing. A teammate sees another member's file only when the office has chosen that. Pay can stay private even when the files are shared.
That split is the point of a deal tracker in an office of one to twenty-five agents. The broker stops being the person everyone calls. The agent stops being the person who does not know where their own file stands.
The commission is the last column, not a second workbook
When the file closes, the tracker should already know the agent and the plan. The closing adds the price it closed at, the commission, anything off the top, and the split. The statement is issued from those figures, and the cap year moves. A second spreadsheet for pay, kept by a different person, will disagree with the file by the end of the month. Brokerage commission tracking is that last column written out: the plan, the cap and the statement, on the same file.
Referrals are files too, but they are not closings. A fee that came in with no property does not belong in the count of sides closed. Track it, and keep it out of the closing total.
When the sheet is still the right tool
A spreadsheet is enough while one person can answer, from it, what each file is waiting on and what each agent has been paid. It stops being enough when two people edit the same rows, when an agent cannot see their own cap without asking, or when changing a plan rewrites last year's lines. At that size, one to twenty-five agents, the broker is still close to every file. The tracker should match that, not a pipeline built for a hundred agents and a separate transaction desk. How an office of that size runs the day is on the small brokerage back office page.
In Deskwork
Office desk is that list: the day's counts, then Needs you, Waiting on agents and This week. New file starts a listing, a buyer side or a referral from one screen, with the agent, the address and the price. Documents dropped on the file land on their checklist lines. The broker closes the file from final review, the closing counts toward the agent's cap, and the agent gets a statement. Agents sign in and see their own files. Documents stay in the brokerage's own Google Drive once the broker-owner connects it.
Questions brokers ask
What belongs on a real estate deal tracker for a small brokerage?
Each open file, who is on it, the price, the next step, the dates, where the documents stand, and, once it closes, the commission and the statement. A list of addresses with no next step is a directory, not a tracker.
Should every agent see every file?
No. Agents should see their own files, their cap and their statements. The broker-owner and the office manager see the office. A teammate sees another member's file only when the office has said so.
When is a spreadsheet enough for a small brokerage?
While one person can still answer, from that sheet, what each file is waiting on and what each agent has been paid. It stops being enough when two people edit it, or when an agent has to ask to learn their own cap.
Try it on your own office
Open one file and take it through to a statement before you decide. A desk you set up yourself through the signup page is free. If we set up your desk with you, what your brokerage pays is set out in our written agreement with you. Read about pricing.
Sign up free Have us set it up