Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyHome Buying & SellingReal Estate Commission Tracker

SpreadsheetHome Buying & SellingFree

Real Estate Commission Tracker

Every deal with sale price, commission rate, referral fee, brokerage split and transaction fee, showing gross commission and net to agent.

Shown with sample data

Colour

Real Estate Commission Tracker

Every deal with sale price, commission rate, referral fee, brokerage split and transaction fee, showing gross commission and net to agent.

Closed volume
$3,194,500
GCI closed
$87,319
Net to agent (closed)
$60,968
Pending net
$14,896
Not yet closed
Company dollar
$24,257
Brokerage share plus fees
Net to agent by lead source
  • Past client$18,847.50
  • Sphere$18,280.63
  • Sign call$14,365
  • Online lead$10,203.50
  • Open house$10,165
  • Referral$4,001.88
Share of net to agent by lead source
  • Past client$18,847.5025%
  • Sphere$18,280.6324%
  • Sign call$14,36519%
  • Online lead$10,203.5013%
  • Open house$10,16513%
  • Referral$4,001.885%

How to use it

  1. 1Add every deal when it goes under contract and set Status to Pending.
  2. 2Enter the sale price, your side’s commission rate, any referral percentage and your split.
  3. 3Add the brokerage transaction or E&O fee charged per deal.
  4. 4Change Status to Closed on closing day, or Cancelled if it falls through.
  5. 5Review the Summary by lead source each quarter and put your marketing where the net income comes from.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Gross commission income is not what an agent takes home. Enter each deal’s sale price, commission rate, any referral fee, your split with the brokerage and the transaction fee; the tracker calculates gross commission, the referral paid out, net to agent and what the brokerage keeps, and totals closed volume, GCI and net income, with pending deals shown separately and a summary by lead source so you know which sources pay.

Who it’s for

  • Agents tracking income and goals
  • Teams splitting commissions
  • Estimating tax set-asides from net commission
  • Comparing lead sources by real income

What’s included

  • Deals sheet: One row per deal with commission, referral, split and net.
  • Summary by Lead source sheet: Net to agent and Gross commission and the number of entries for each lead source, calculated from the Deals sheet.

How to use it

  1. 1Add every deal when it goes under contract and set Status to Pending.
  2. 2Enter the sale price, your side’s commission rate, any referral percentage and your split.
  3. 3Add the brokerage transaction or E&O fee charged per deal.
  4. 4Change Status to Closed on closing day, or Cancelled if it falls through.
  5. 5Review the Summary by lead source each quarter and put your marketing where the net income comes from.

Tips

  • Set aside 25–35% of net commission for income and self-employment tax; your accountant can refine this.
  • If your brokerage has a cap, change Agent split to 100% for deals after you reach it.
  • Commission rates are negotiable and, after the 2024 US NAR settlement, buyer-agent compensation is agreed in writing with the buyer. Record the rate actually agreed for each side.

Questions

How is net to agent calculated?

Gross commission = sale price × commission rate. Referral paid = gross × referral %. Net to agent = (gross − referral) × agent split − transaction fee.

What is GCI?

Gross commission income: the total commission earned on your side of each deal before referral fees, brokerage splits and fees.

What is company dollar?

What the brokerage keeps from each deal: its share of the split plus transaction fees. It appears here as a key figure.

Related searchesreal estate commission trackerrealtor commission spreadsheetagent commission calculatorcommission split calculatorgci trackerreal estate agent income tracker

Details

Format
Spreadsheet
Category
Home Buying & Selling
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHome Buying & SellingFree

Real Estate Commission Tracker

Every deal with sale price, commission rate, referral fee, brokerage split and transaction fee, showing gross commission and net to agent.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Home Buying & Selling
Sheets
2
Setup
15 min
Level
Beginner
Price
Free

Your copy is private to you.

More home buying & selling templates

View all
Comparative Market Analysis (CMA)2 sheets

Suggested value

$465,000

Low

$450,000

High

$477,000

ABCD
1AddressStatusSale or list datePrice
218 Willow DriveSoldSep 18$462,000
37 Aspen CourtSoldAug 30$489,000
433 Willow DriveSoldOct 5$445,000
5102 Cedar LaneSoldJul 22$471,000
Comparables
SpreadsheetHome Buying & Selling

Comparative Market Analysis (CMA)

Price a home from recent comparable sales, with adjustments, price per square foot and a value range.

10 min setupPreview
House Hunting Comparison2 sheets

Homes viewed

4

Best score

4.2

Lowest price / sq ft

$219

ABCD
1AddressAsking priceBedsSq ft
214 Maple Drive$425,00031,650
32 Harbour View$465,00031,500
488 Birch Lane$398,00041,820
55 Cedar Close$449,00031,700
Homes
SpreadsheetHome Buying & Selling

House Hunting Comparison

Compare homes on price, size, commute and must-haves with a weighted score.

10 min setupPreview
Real Estate Agent Listing Tracker2 sheets

Active listings

2

Pending commission

$22,075

Closed commission

$9,875

ABCD
1AddressSellerStageList price
214 Maple DriveWilsonListed$425,000
32 Harbour ViewNgUnder offer$465,000
431 Spruce WayGarciaSold$389,000
59 Willow RdBrownAppointment$510,000
Listings
SpreadsheetHome Buying & Selling

Real Estate Agent Listing Tracker

Track listings from appointment to close with price, days on market and commission.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ