Real Estate Agent Expense Tracker Spreadsheet: Commissions, Splits and Mileage

As a real estate agent, there's no payroll department withholding tax, no employer tracking your mileage, and no one but you reconciling what the brokerage actually paid out against what a closing statement said you'd earn. That's the trade-off of being a 1099 independent contractor: more upside, and every bit of the bookkeeping lands on you.

The good news is that an agent's finances split cleanly into three pieces — commissions, business expenses, and mileage — and each one fits a simple spreadsheet log with a handful of columns. Here's what each log needs, and how to keep all three current without it eating your week.

The commission log: your actual income statement

One row per deal, from the moment it goes under contract. The columns that matter: Date Closed, Property Address, Client Name, Sale Price, Commission Rate, Gross Commission, Brokerage Split, Net Commission, Status, and Notes.

Gross and net commission should never be typed in by hand — they should calculate themselves from sale price, rate, and split. Gross commission is sale price times commission rate; net commission is gross commission times one minus your brokerage split. Once those are formulas instead of numbers you retyped, correcting a sale price or catching a rate you entered wrong fixes the whole row instead of leaving a stale number sitting in your net commission column.

Status matters more than it looks. A dropdown of Under Contract, Closed, and Fell Through means your income totals can be built to count only Closed deals — so a deal that fell through in escrow doesn't quietly inflate a total you're using to plan your quarter, and a deal still under contract doesn't get counted as money you already have.

Your default split, and the deals where it's different

Most agents work under one standard brokerage split most of the time. Set that number once, as a default that pre-fills the Brokerage Split column on every new row, and you've removed the most repetitive part of the log. The deals that need attention are the ones where the split is different — a referral fee taken off the top, a team split, a cap you hit partway through the year — and for those, you simply type over the pre-filled number on that one row.

That override sits visibly in the log itself, next to the deal it applies to, instead of living in a note you have to remember to check. Six months later, when you're trying to work out why one closing's net commission looks lower than expected, the answer is right there in the row, not a mystery you have to reconstruct.

Splits are also where most agents leave money unaccounted for — not through anything dishonest, just through not checking. Run your own numbers on a deal through the real estate commission split calculator before you sign off on a closing statement, and compare it to what actually landed in your account.

Business expense categories built for how agents actually spend

A generic small-business expense list misses the categories that make up most of an agent's spending. Ten categories that cover the real pattern:

Log each expense with a Date, Category, Amount, and Notes. A single expense log across the whole year, broken out by category with a monthly trend chart, tells you two things at a glance: where your money actually goes, and whether spending is climbing or steady as your deal volume changes.

Mileage: the deduction agents most often under-claim

Showings, listing appointments, closings, inspections — an agent's job runs on driving, and mileage is one of the largest deductions available to you. It's also the one most commonly under-claimed, because it doesn't arrive as a receipt in your inbox the way software subscriptions do. If you're not logging it as it happens, you're reconstructing it from memory in April, and memory always underestimates.

A mileage log needs: Date, Purpose/Client, Start Location, End Location, and Miles Driven, with a Deductible Amount column that calculates itself from a mileage rate you set once. Because the rate lives in one place and every row references it, updating the rate for a new year updates every row's deduction automatically — you're not hunting down and correcting a year's worth of hand-typed totals.

Log the drive the same day it happens, or at worst the same week. "Showing — 482 Maple Street" takes five seconds to type when you're getting back in the car; it takes real effort to reconstruct three months later, and effort is exactly what causes mileage logs to get abandoned halfway through the year.

Seeing your real net profit

Commissions, expenses, and mileage each answer a different question on their own. Net profit needs all three in one place: net commission from Closed deals, total expenses for the period, and total mileage deduction — combined into one honest number. Rather than building fragile formulas that reach across three separate workbook files (which break the moment you rename a sheet or move a file to a new folder), a simple summary section where you type in each total by hand is more work per month but far less likely to silently go wrong.

Check that number monthly, not just at tax time. An agent who's closed four deals this quarter but spent heavily on marketing and mileage for a fifth that's still under contract can look profitable on gross commission and be running close to breakeven on net — and the only way to see that is to look at all three logs together, not at the commission log alone.

The weekly routine

Fifteen minutes a week keeps all three logs current without a backlog building up:

1. Commissions (5 min): update the status of any deal that moved — new contract, new closing, or one that fell through. Enter the sale price and split the moment a closing statement lands.
2. Expenses (5 min): log anything spent this week against its category, straight from your card statement or a photo of the receipt.
3. Mileage (5 min): catch up any drives you didn't log same-day. Purpose and locations are enough — you don't need a paragraph.

Then once a month, ten minutes with all three totals side by side: net commission, total expenses, total mileage deduction, and the net profit they add up to. That's the number that tells you whether the quarter was actually good, not just busy.

None of this is tax, legal, or licensing advice, and it doesn't sync with your MLS or brokerage systems — real estate licensing rules, brokerage requirements, and tax treatment all vary by location. What organized logs give you is complete, accurate records to bring to your CPA or broker, instead of a shoebox of closing statements and a guess at your mileage.