An agent year-end commission report is the list of what the brokerage paid each agent for one year. It is not a second copy of the statement for a single closing. That statement is one file. The report is every closing that belongs in the year, lined up, with totals the lines add back to. The other back-office guides are on the guides page.

Who the report is for

Write it for the broker-owner or the office manager first. They are the ones who have to stand behind the number. The agent reads their own lines and checks them against the statements they already received. Whoever prepares the tax forms reads what the brokerage actually paid, not a guess rounded to the dollar.

The report does not pay anyone, and it does not file a return. The brokerage pays agents the way it already pays them. Bank details do not belong on it. A figure that cannot be tied to a closing the office already paid is not ready to leave the office.

Which year a closing belongs to

Put each closing in one year, and say which date decided it. Deskwork's annual report counts paid files only, from January 1 through December 31, by the day the office paid. A file that closed in December and was paid in January is in January's year. Counting it in both years, or in the year it closed, is how the same commission gets reported twice or not at all.

Use that rule for every agent. A page headed with a year still has to say which twelve months are in it, and whether those months are pay days or closing dates. A reader who has to guess will guess wrong on the December closings.

A paid file with no pay day recorded is still a paid file. Place it in the year it closed, and leave the paid-date cell empty. Copying the closing date into that cell makes a missing fact look like a recorded one. An estimate, if the office uses one, has to be labeled as an estimate. It is not the same as a day someone wrote down.

One file, two commissions

A file where one agent represents the seller and the buyer is one file and two commissions. The listing side and the buyer side each have a gross, a split and a fee. If the year's volume counts the sale price once for each side, the report has to say how many files were counted that way. A volume that quietly doubles those prices will not match the closings the agent remembers, and the two agents on a shared file will not add up to the office's own count.

The closing count and the volume are not the same kind of number as what the agent was paid. You can see a closing and its price. What the agent was paid is only known when the commission was actually worked out. A file that arrived with no commission should stay in the list and stay out of the pay total. Adding an unknown into a money figure turns the year's pay into an estimate without saying so.

The lines, to the cent

Each row names the file, the side, the date it closed, the date it was paid, the sale price, the gross commission, what the agent is paid, the fees, and what the brokerage kept. Write every amount to the cent. A total in whole dollars over rows that carry cents will not add back, and that is where an accountant stops.

On each priced closing, the agent's pay and the brokerage's share use the plan that closing was paid on, and they land on the gross the split was applied to. The rows under an agent have to add to the totals printed for that agent. The agents have to add to the office. If a total is even one cent off, the report is not ready to send.

A short example, using round teaching numbers and not anyone's closing: one side has $10,000.00 of gross, $7,000.00 to the agent and $3,000.00 to the office. Three such sides are $21,000.00 and $9,000.00, and both add back to $30,000.00. Drop the cents on the total and the lines no longer prove themselves. Money the agent collected from their own client and kept is a different line. It is not what the brokerage paid, and it does not belong inside the pay figure a tax form would use.

If a statement was wrong, the year-end report uses the corrected lines. Keep the statement the agent already has. The steps after that page went out are in how to correct a commission statement. Changing the plan after the closing was paid is not how a year gets fixed. Each closing keeps the plan it was paid on. How that plan is written down is in how to set agent commission plans.

Referrals are not closings

A referral fee is money. It is not a closing, and it is not a sale. List it on the report, on its own line, and leave it out of the closing count and out of the volume. The sale-price cell stays blank. A zero reads as a property that sold for nothing, and a spreadsheet average counts that zero and drags the column down.

Do not fold the fee into a line labeled closings so the count looks larger. Referral fees the office owes, and referral fees owed to the office, are a different list from the agent's own closings. Keep them apart. A referral can still be pay. It adds to what the agent was paid when the office paid it, and it adds nothing to the year's sales.

One CSV for the year

Hand over one file for the year. A workbook per agent that someone pastes together in January is how a row gets dropped, and how two people end up describing different years. The office file is one row per agent, which is how the year's brokerage revenue is one number. The file for the agent you are checking is one row per closing, which is the list you send that person.

In Deskwork the annual report gives every agent's closings to the cent as one CSV, and referrals are counted apart from closings. The year's totals say how many files were counted on both sides. You can download the one agent you are looking at, and you can print that agent's year. A monthly fee an agent pays the brokerage is office income. It is not a closing and not part of what the agent was paid, so it stays in its own section of the office file, labeled as a monthly charge.

Each agent's line on the office table is that agent's own year, so the table and the page you open for that agent do not disagree. Deskwork does not pay the agent and does not file the tax form. The per-closing page the agent already has is the statement. What belongs on that page is in how to write an agent commission statement.

Before you send it

Read the report once as the accountant will, without the spreadsheet that produced it. On the agent's file, every closing the office paid in the year is a row, and no closing from another year is. Referrals are listed and are not in the closing count or the volume. A both-sides file is named as such. Each money column adds to the cent. An agent who left during the year is still on the report for what the office paid them before they left. Leaving them off deletes a year that already happened.

Check the cap on the closings where it stopped the office's share. The statement for that closing should show the plan and the cap as two facts, and the year-end row should use those same figures. How the cap is counted through the year is in how to track agent commission caps. If the brokerage's revenue on the agent lines does not match the office's income from closings, look for a share with no agent named, an agent who is not on the roster, or a file entered twice. Do not send a total you cannot explain in one sentence.

Dates that do not belong here

Inspection deadlines and financing deadlines do not belong on the year-end report. They belong on the file while it is still open. By the time you are adding a year, those dates have already passed, and mixing them into the pay lines makes the report harder to check. The transaction timeline calculator lists those dates from the contract date and the closing date. It is a calendar, not a report, and nothing typed into it is saved.

Questions brokers ask

Is a year-end report the same as a commission statement?

No. A commission statement is one closing. The year-end report is every closing the office paid in that year, to the cent, with referrals kept apart from closings. The lines should be the same closings the statements already covered.

Should a referral count as a closing on the year-end report?

No. A referral is pay, not a sale. List it, and leave it out of the closing count and out of the volume. A sale price of zero would read as a property that sold for nothing, so the sale-price cell stays blank.

Does the report file the agent's taxes?

No. The report is the list of what the office paid, to the cent, as one CSV. Filing a return is a separate step. Deskwork does not file it and does not pay the agent.

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