Free Real Estate Commission Calculator (Excel)
What's in the commission calculator
The Transactions sheet holds up to 100 closed deals, one row each: date, property or client, sale price, total commission rate, listing-side split percentage, and broker split percentage.
Gross commission, the listing-side and buyer-side dollar split, and each agent's net pay after the broker split all calculate automatically for every row - no separate calculator per deal.
A summary block below the table totals sale volume, gross commission, and net paid to listing agents, buyer agents, and the brokerage across the entire list.
Multi-tier splits, not a single formula
Most free real estate commission tools online are a single SUM formula or a one-off web calculator that doesn't save your history - fine for a quick estimate, but not for tracking a season of closings.
This file lets each transaction carry its own commission rate and split percentages, so a 50/50 listing split on one deal and a 60/40 split on the next both calculate correctly side by side in the same table.
Because every row is independent, you can review split structures across your whole pipeline at once instead of recalculating each closing by hand.
Who this calculator is for
Real estate agents and brokers who want to see net commission per transaction - and across a whole month or quarter - without opening a new spreadsheet for every closing.
It's a tracking and calculation tool for standard percentage splits on closed sales. It doesn't model tiered or graduated commission plans, referral fees, or team-lead overrides.
How to use it
- Enter the sale price, total commission rate, listing-side split %, and broker split % for each closed transaction.
- Gross commission and every net split calculate automatically in the row.
- Check the summary below the table for totals across every transaction you've logged.
Download the free Free Real Estate Commission Calculator (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Real Estate Investor Pack
If you also hold rental property, the paid Real Estate Investor Pack ($39) adds live cash-on-cash returns, a 360-month amortization schedule, and a full CMA workbook.
See the full versionFrequently asked questions
How is the broker split applied?
The same broker split percentage is applied to both the listing-side and buyer-side commission - it's the percentage the brokerage keeps from each agent's share, not a flat fee.
Can I use different splits for different transactions?
Yes. Commission rate, listing split % and broker split % are entered per row, so each transaction can use its own numbers.
Does this handle tiered or graduated commission plans?
No. It calculates standard percentage splits on a per-transaction basis - graduated plans, referral fees and team overrides aren't modeled.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the formulas keep working.
How many transactions can I log?
Up to 100 rows on the Transactions sheet, with a running summary of totals below the table.
What's the usage license?
Personal use or use within one brokerage. It's not meant to be resold or redistributed as a template product.