A brokerage is paid the commission. The agent is paid a share of it, under a plan the office wrote down. Tracking that is not a running total in a cell. It is a line for every closing that still makes sense months later: what came in, what came off the top, which plan was used, where the agent stood against their cap, what fees were charged, and what the agent was paid. If any of those is missing, the year-end report is a guess.

What one closing has to hold

Write these down while the file is still open. They are hard to reconstruct later.

Those lines have to add back to the commission that came in, to the cent. That check is the whole of brokerage commission tracking in one sentence. A statement the agent cannot add up is a statement they will call about.

The plan comes before the closing

Tracking fails when the plan lives in someone's head. Write each plan before anyone is put on a file: a split until a cap, a fee-only plan where the agent keeps the commission and pays fees, or tiers whose split changes as the agent climbs. Flat monthly fees belong on the same list, kept apart from the split, because a desk fee is not pay. How to set agent commission plans walks through the three kinds.

When a plan changes, change it on a copy. Each closing keeps the plan it was paid on. A spreadsheet that points every old row at the current plan will rewrite last year the day somebody edits a percent. That is the failure brokerage commission tracking is meant to prevent.

The cap year is the agent's year

A cap is a ceiling on what the brokerage takes from one agent. It usually runs on that agent's anniversary year, not from January to December, and not on a year the office picked for its own books. Before a closing is paid, the record should show what the agent had already paid toward the cap, what this closing adds, and what is left. The closing that uses up the last of the cap is a different closing from the ones after it: the brokerage's share drops to fees only, if that is what the plan says.

Count only what the plan says to count. A referral fee taken off the top is usually not company dollar, and a transaction fee often does not count toward the cap. Write the rule once and use it every time. How to track agent commission caps covers the closing that crosses the line.

A worked example, with invented numbers

Round teaching numbers, not anyone's agreement. An agent closes one side of a $400,000 sale at 2.5 percent. Nothing comes off the top. The agent is on a 70/30 plan and has $2,000 of cap left. There is no team fee and no transaction fee.

On the next closing in that cap year the brokerage takes no split, only whatever fee the plan still charges. If the sheet still applies 30 percent, the tracking is wrong even though the arithmetic looks tidy. To try the same order with a referral and a flat fee, use the agent split calculator guide.

The statement is the tracking the agent sees

The office's book and the agent's statement are the same closing written for two readers. The statement shows the gross, the split, the fees and where the cap stands after this one. The agent should be able to see why their figure is what it is without asking. How to lay that page out is in how to write an agent commission statement. If a statement was already sent and a figure was wrong, keep the one they have and issue a new one they can tell from the first.

At year-end, the report is every closing the office paid, to the cent, with referrals counted apart from closings. It is not a fresh total somebody typed. If the lines were right all year, the report is a copy of them.

Dates still belong on the file

Commission is the last step. The file still has an inspection period, a financing period and a closing day, and the commission is not known until those have passed. The transaction timeline calculator lists those dates from the contract date, so the office is not tracking pay on a file that has not closed.

In Deskwork

Deskwork keeps the plan on the agent and the plan on the closing separate. Caps run on each agent's anniversary year. Closing is where the sale price, the commission, the deductions and the split are typed, and Pay & archive works them out again through the same rules and issues each agent's statement. Deskwork does not pay agents, and no money moves through it. The brokerage pays the way it does today. The screens are on the brokerage commission tracking page.

A brokerage that already keeps this in a workbook can open that workbook in Deskwork to bring past closings in. Nothing is created until the broker-owner says so. The sheet can stay as the record of what already happened. New closings then have one place.

Questions brokers ask

What should brokerage commission tracking record on each closing?

The sale price, the commission for that side, anything taken off the top, the plan that was used, where the agent stood against their cap, the fees, and the statement the agent can check. A single company-dollar total is not enough to answer a question later.

Does a commission cap run on the calendar year?

Not unless the plan says so. Most caps run on each agent's own anniversary year. Write the start day down, and count only the closings that fall inside that year.

Can last year's figures change when a plan changes?

They should not. Each closing keeps the plan it was paid on. Change a plan on a copy, and leave the closings already paid where they are.

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

Read next