Brokerage & Commission Tracker (Excel)

Every deal, what it should pay, what actually arrived, and what is still outstanding — plus a month-by-month income view.

PropVid-Brokerage-Commission-Tracker.xlsx Excel (.xlsx) · free · no email required · updated 29 August 2026

Download the sheet ↓

Property income is unpredictable, which is exactly why it needs to be written down. The fear that drives agents into bad listings and desperate deals is usually worse than the actual numbers — because the actual numbers are vague.

This tracks every deal from agreed to received: what the brokerage should be, what has come in, what is outstanding, and how long it has been outstanding. It also splits income by month so a good quarter and a bad one stop feeling like the same uncertainty.

The outstanding column is the one that pays for itself. Most agents have money owed they have half-forgotten about.

What is in the file

A Deals sheet: property, client, deal value, brokerage rate, brokerage due, received, outstanding and days outstanding — all calculated
Support for a split rate where both sides are represented, and for a shared fee with another agent
A By month sheet totalling received income per month so the year is visible at a glance
A Pipeline value figure — brokerage on deals agreed but not yet received
A note sheet on when to trade a fee concession rather than simply cutting it

Log the deal when it is agreed, not when it is paid

The gap between those two dates is where the money gets forgotten. The Days outstanding column exists to make that gap uncomfortable to look at.

Chase on a schedule, not on a feeling

Filter to anything outstanding beyond thirty days and send one message a week. Not an apologetic one — an invoice reference and a date.

If a client asks you to cut the fee

Do not defend the percentage. Describe the work: the enquiries you handled, the buyers you filtered out, the document problem you caught in April. Most clients genuinely do not know what happened, because you shielded them from it.

Then trade rather than cut — an exclusive mandate, a second property, a written testimonial and two referrals. A concession in exchange for value is a negotiation. A concession for nothing tells the client the original number was invented.

Ready to use it?PropVid-Brokerage-Commission-Tracker.xlsx · Excel (.xlsx)

Download free ↓

Questions

Should I record the fee before it is confirmed in writing?

Record it, and use the notes column to flag that it is unconfirmed. An unconfirmed fee is the one most likely to be negotiated at closing, from your weakest possible position.

How do I handle a fee split with another agent?

There is a split percentage column. Set it to 100 when the fee is entirely yours and to your share otherwise — the net brokerage column follows automatically.

Does this handle GST or TDS?

It tracks gross and received amounts only. Tax treatment of brokerage varies by registration status and turnover — take that to a chartered accountant rather than a spreadsheet.

This is a working template, not legal, tax or financial advice. Requirements differ by state and by transaction — have a lawyer and a chartered accountant confirm anything that matters before you or a client rely on it.