Commission tracking at a brokerage is never one number per deal. It is the sale price and the commission, the deductions off the top, the agent's split, where that agent stands against their cap, the transaction fee and any monthly fee, and then a statement the agent can check. A spreadsheet holds all of that until a split changes in the middle of the year, an agent crosses their cap, or somebody asks why last year's totals moved.

Plans written out in plain words

Plans holds the office's commission plans: a standard split until the cap, a fee-only plan where the agent keeps the commission, and a tiered plan whose split changes as the agent's cap contribution climbs. Flat monthly fees are kept on the same screen, apart from the plans. The editor shows a worked example beside the form, so the broker sees what a plan pays before an agent is put on it. Each agent's own plan is on their Pay screen.

Caps that count in the right year

Caps run on each agent's anniversary year, not the calendar year. Before a closing is paid, its cap year shows what the agent had already paid toward the cap, what this closing adds and what is left. Agents see their own cap progress and the day their next cap year opens, so the question of how close they are to cap is answered on their own phone.

The closing's cap year in Deskwork: what the agent had paid toward their cap, what this closing adds, and what is left
A closing's cap year: what the agent had paid, what this closing adds, what is left.

From the closing sheet to the statement

Closing is where the figures are typed: the final sale price, the commission as a percent or a flat amount, the deductions, the loan type, the closing date and the split. Close transaction keeps those figures as typed, so a file paid on another day is paid on the price it actually closed at, not the contract price. Pay & archive works them out again through the same rules, asks first, and issues each agent's statement.

On a file where one agent represents both sides, the closing holds two commissions, the listing side and the buyer side, priced in that order. The transaction fee is charged once per side, and year-end totals say how many files were counted on both sides.

The agent's commission statement in Deskwork: the sale, the office's share and the fee, what they are paid, and where it leaves their cap
The agent's statement: the sale, the office's share, the fee and the cap line.

Totals you can stand behind

Each closing keeps the plan it was paid on. Change a plan on a copy and the closings already paid stay as they were. Every save records who changed what and keeps the version it replaced. Referral fees are counted apart from closings. At year-end the annual report gives every agent's closings to the cent, as one CSV.

Bringing in the tracker you keep today

Open your commission workbook (.xlsx) on Tracker, dropped in or chosen from Google Drive. Deskwork shows its rows beside the desk's own figures and lists the past closings it has no file for. You see them first, and nothing is created until the broker-owner says so. If your office would rather keep its Google Sheet in use, see how Deskwork works with Google Sheets.

Questions brokers ask

Does Deskwork pay our agents?

No. You pay agents the way you do today. Deskwork works out each share, writes the statement and emails it. No money or bank details pass through Deskwork.

Can we change an agent's split partway through the year?

Yes. Put the agent on another plan, or change a plan on a copy. Closings already paid keep the plan they were paid on, so their statements and totals do not move.

What does an agent see?

Their own statements, their pay this year, their cap progress and the day their next cap year opens. They do not see the office's figures. Teammates see each other's pay unless you make that team's pay private on the roster.

Try it on your own office

Set up a plan, file a deal and close it 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

More from Deskwork