Skip to product information
1 of 8

InkSheet Studio

Real Estate Agent Tracker Spreadsheet | Commission Calculator, Transaction Tracker, Closing Checklist, Pipeline

Real Estate Agent Tracker Spreadsheet | Commission Calculator, Transaction Tracker, Closing Checklist, Pipeline

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.

Done paying a monthly CRM subscription just to watch your own pipeline? Listings in one place, buyer searches in another, commission math on a sticky note, closing dates in your head. This tracker puts your whole business in one Google Sheet: every listing and buyer deal by stage, every commission figured the same way every time — including what happens when you hit your brokerage cap — your contract-to-close deadlines, your expenses and miles, your marketing spend, and every follow-up with a next step and a due date.

This is an organization and calculator tool. It tracks what you enter and calculates commissions from the percentages, fees and cap you type in. It does not find clients, and it makes no promise about sales or income — the commission math is arithmetic on your own numbers, nothing more.

A DIFFERENT TOOL, A DIFFERENT JOB — This is not our Real Estate Transaction Tracker, and it does a different job. That tracker follows a single transaction — its paperwork and closing costs from contract to close. This one follows you: your whole pipeline, your splits and referral fees, your cap, your net on every deal, your goals and your follow-ups. Some agents run both.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 10 TABS
• Start Here — plain-English quick start, the commission method in full, and your settings: the mileage rate used on the Expenses tab, your annual net commission goal, your annual closed-deals goal, and your tax set-aside %
• Dashboard — pipeline counts and list volume by stage, closed volume, net commission received, expected commission from pending deals, goal progress against the annual goals you set, your tax set-aside figure at your own percentage, this month's expenses and mileage, and open follow-ups — all formula-driven
• Listings & Pipeline — one row per listing or buyer search: address, city, side (Seller or Buyer), stage (Active, Under Contract, Pending Close, Closed, Expired), list date, list price, contract date, expected close and actual close
• Commission Log — the record of what each deal actually paid: sale price, gross commission %, that deal's own agent split % and the fees taken out of your share. Gross commission, your share and net to agent figure themselves out; mark each deal Paid or Pending
• Expenses & Mileage — log what you spend and the miles you drive; mileage value uses your rate from Start Here, and the monthly summary totals each month by itself
• Contacts & Follow-Up — one row per person: name, type (past client, seller lead, buyer lead, referral partner, vendor), last contact, next step, due date and status (Open or Done)
• Settings — your commission plan, set once: your agent split %, your brokerage cap $, the franchise fee %, and the flat transaction fee $. Every Waterfall figure reads these four cells
• Commission Waterfall — every deal stepped through your Settings plan in order: gross commission, franchise fee, referral fee, split, transaction fee, tax reserve, net to you — with a running brokerage total that stops at your cap (explained below)
• Deadlines & Closing Checklist — one row per deal under contract: contract date, inspection due, appraisal due, closing date, a days-to-closing countdown that figures itself against today, and an OVERDUE / DUE SOON / On Track flag
• Marketing ROI — one row per channel: what you spent, the leads it brought, the closings you credit to it, and its cost per lead and cost per closing, figured for you

THE CAP MATH — EXPLAINED PLAINLY
Most commission sheets stop at "gross × split − fees." Real plans have a cap: your brokerage keeps its split only until its share adds up to the cap $, and after that the split stops. The Waterfall does that running total for you, deal by deal. On each deal it takes the franchise fee and any referral fee out of the gross first; what is left is split between you and the brokerage — but the brokerage never takes more than the room left under your cap. On the deal where the cap is reached, the brokerage takes only that leftover room, and you keep the rest. On every deal after that, the brokerage takes nothing and the full amount (before the transaction fee and your tax reserve) is yours. In the sample plan — 80% split, $15,000 cap, 6% franchise fee, $395 transaction fee — the cap is reached partway through the fourth sample deal: its brokerage share is $2,317.30 instead of the uncapped $2,984.50, and the two sample deals after it show a brokerage share of $0. Change any of the four Settings numbers and every deal re-figures itself.

HOW COMMISSION IS FIGURED — ONE METHOD, NO HIDDEN MATH
Commission Log: Gross Commission = Sale Price × Gross Commission %. Agent Share = Gross Commission × Agent Split %. Net to Agent = Agent Share − Fees, where the Fees column is every amount taken out of your share on that deal: the brokerage / transaction fee and any referral fee you paid on it. Worked sample in the sheet: a $678,000 sale at 2.50% is $16,950 gross; at an 80% split your share is $13,560; less $495 in fees, net is $13,065.
Commission Waterfall: the same deals run through your one Settings plan instead of each deal's own split — Gross, less franchise % and the referral fee you enter, split at your Settings %, capped as explained above, less the flat transaction fee, less a tax reserve at your Start Here %. The Log is the record; the Waterfall is the plan. The two nets can differ, and both tabs say so.

GOALS AND TAX SET-ASIDE
Set an annual net commission goal and an annual closed-deals goal on Start Here (samples: $150,000 and 12) and the Dashboard shows what percentage of each your Paid deals have reached — the samples sit at 41.9% of the net goal. The Dashboard and the Waterfall also show a tax set-aside / tax reserve figure: your net times a percentage you choose (sample: 25%). It is a simple planning percentage, not a tax calculation, and this sheet is not tax or financial advice — for anything tax-related, ask your accountant.

THE SAMPLE DATA
It comes loaded with fictional samples — 12 invented listings, the same 6 commission deals in both the Commission Log and the Waterfall, a sample commission plan on Settings (80% split, $15,000 cap), 4 contract-to-close deadline rows matching the pipeline addresses, 5 marketing channels, a September–October expense and mileage log, and 10 contacts with fictional 555 phone numbers — so you can watch every formula work, including the cap stopping mid-stream, before you delete the samples and type your own. Formulas are pre-filled down the columns — 30 pipeline rows, 20 commission rows, 20 waterfall rows, 20 deadline rows, 20 expense rows and 20 contact rows, ready to go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it works on your phone or computer.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.

View full details