Free template · Real Estate
Real Estate Commission Tracker Template
A real estate commission tracker records each closed or pending deal with its sale price, commission rate, broker split and fees, and calculates what the agent actually takes home. It shows income by month and helps agents plan for taxes and slow periods.
Who it's for: Real estate agents and small teams who want to see their real take-home pay per deal.
Free, no email needed. Google Sheets: download the .xlsx, then File > Import > Upload.
Preview
These are the real columns with example rows. Click Try it here to type your own rows and download them.
| Deal | Side | Close date | Sale price | Commission % | Gross commission | Your split % | Fees | Net to you | Status |
|---|---|---|---|---|---|---|---|---|---|
| 14 Elm St | Listing | 2026-10-18 | 425,000 | 2.5% | 10,625 | 70% | 395 | 7,042.50 | Pending |
| The Parkers (buyers) | Buyer | 2026-09-30 | 310,000 | 2.5% | 7,750 | 70% | 395 | 5,030 | Closed |
| 8 Harbor View #2 | Both | 2026-09-12 | 289,000 | 5% | 14,450 | 70% | 395 | 9,720 | Paid |
What goes in each column
| Column | What goes in it | Example |
|---|---|---|
| Deal | Property or client | 14 Elm St |
| Side | Buyer, Listing, Both | Listing |
| Close date | Expected or actual | 2026-10-18 |
| Sale price | Contract price | 425,000 |
| Commission % | Your side's rate | 2.5% |
| Gross commission | Sale price x rate (calculated) | 10,625 |
| Your split % | Your share after the broker split | 70% |
| Fees | Transaction, referral or desk fees | 395 |
| Net to you | Gross x split minus fees (calculated) | 7,043 |
| Status | Pending, Closed, Paid | Pending |
Why these columns: Agents often track sale prices, but take-home depends on split and fees. Calculating Net to you per deal shows which deals, sources and months actually pay.
How to use it in 5 steps
- Add a row as soon as a deal goes under contract, with Status Pending.
- Enter your real split and fees, not the headline rate. Net to you is the number that matters.
- Update Status to Closed at settlement and Paid when the money lands.
- Sum Net to you by month to see your real income curve.
- Set aside a fixed share of each Paid row for taxes as it arrives.
Spreadsheet, dedicated software, or Notion?
| Option | Best for | Falls short when |
|---|---|---|
| This spreadsheet | Quick take-home calculations per deal | No link to leads, clients or listings |
| Brokerage back-office software | Compliance and brokerage accounting | Built for the broker, not your personal view |
| Notion version | Leads, clients, listings, closings and commissions connected | Needs Notion |
If the free spreadsheet does everything you need, stick with it. The Notion version is for when you want the pieces connected.
Want it connected? Real Estate Agent Pro
The spreadsheet is one table. The Notion system links it to everything around it:
- Lead pipeline, listings and deals connected to commissions
- Showings and closings tracked per client
- See which lead sources produce the most take-home pay
- Know what to chase today from one dashboard
Instant duplicate link after purchase.
Questions
How is real estate commission calculated?
Sale price times your side's commission rate gives gross commission. Your broker split and any fees then determine what you take home.
What is a broker split?
The share of commission you keep after your brokerage takes its portion, for example 70/30.
Should I track pending deals?
Yes. Pending rows show likely income for the next few months, which helps with planning.
Can I track expenses too?
Add an Expenses tab or column for marketing, mileage and fees to see profit, not just income.