How I Track Every Dollar in My Real Estate Business in 10 Minutes a Week

Here is a number that should bother every agent: most real estate professionals find out how much they actually earned exactly once a year — in April, sitting across from a tax preparer, squinting at a spreadsheet they barely recognize. That single annual reckoning is where profit leaks get discovered months too late to do anything about them. The fix is not a fancy accounting degree or an expensive bookkeeper hired on day one. The fix is a ten-minute weekly habit that keeps you honest about the only scoreboard that matters in a commission business: what lands in your pocket after the checks clear and the tax man is paid.

Real estate is unusual because roughly 87% of REALTORS operate as independent contractors. That freedom is the entire appeal — you set your schedule, you build your brand, you keep your commissions. But it also means you, and only you, are responsible for setting aside money for taxes, tracking deductible expenses, and knowing whether a busy month was actually a profitable one. When you are paid in lumps separated by unpredictable gaps, it is dangerously easy to confuse "money in the bank" with "profit." This post walks through the exact system I use to track every dollar in about ten minutes a week, including the spreadsheet template you can copy today.

Why Agents Lose Track of Their Money

The structure of the business works against casual tracking. According to the NAR 2024 Member Profile, the median REALTOR gross income was about $58,100 in 2024, the typical agent closes around 10 transactions a year, and annual business expenses run roughly $8,450. Those are medians, which means half of agents sit below that line and half above — but the pattern is identical regardless of where you land: a handful of large commission deposits, a steady drip of smaller expenses, and a tax bill that arrives with a thud four times a year.

Because income arrives in bursts, agents tend to feel wealthy right after a closing and anxious right before one. Without a running ledger, you cannot tell the difference between a month that looked busy and a month that was genuinely profitable. Expenses hide in plain sight — a tank of gas here, a software subscription there, a coaching payment you meant to expense but forgot. Over a full year, those small leaks quietly erase a meaningful slice of your take-home, and you only notice when it is too late to course-correct.

The second reason agents lose track is psychological. Money that sits in your checking account feels like "yours" even when a quarter of it belongs to the IRS. Independent contractors do not have an employer withholding taxes on their behalf, so the responsibility to set aside and remit those funds falls entirely on the individual. Out of sight, out of mind — until the quarterly deadline arrives.

The 10-Minute System at a Glance

The entire system runs on four columns. Everything you do each week feeds one of these four buckets:

| Column | What goes here | Question it answers | |--------|----------------|---------------------| | Income | Gross commission received | How much came in? | | Expenses | Categorized business spend | What did I spend to earn it? | | Tax set-aside | Money moved to a separate tax account | Am I protected at tax time? | | Profit | What's left after the above | Am I actually making money? |

That is the whole framework. Four columns, one weekly touchpoint, zero accounting jargon. The magic is not in complexity — it is in consistency. A simple system you actually use every week beats a sophisticated system you abandon by February.

Step 1 — Log Commissions at Close

The moment a transaction closes, open your tracker and record the commission. Capture two numbers, not one: the gross commission (the full fee before anyone takes a cut) and the net (what actually lands in your account after broker splits, franchise fees, and transaction fees). Agents who only track net lose sight of how much of their production is disappearing to splits and fees — and that blind spot is exactly where renegotiating your commission plan or cutting a redundant fee pays off.

Log the closing date, the property address, the gross, the net, and a one-line note on the split. Do this while the transaction is fresh. Future-you, three weeks later, will not remember whether that was a 70/30 split or an 80/20, and guessing defeats the purpose. The note also becomes valuable evidence when you review your effective take rate at year-end.

Step 2 — Categorize Every Expense

Once income is logged, record the week's spending across five fixed categories. Keeping categories consistent month over month is what lets you spot trends and control leak:

• Marketing — paid ads, mailers, signage, photography, open-house costs, lead-gen tools
• MLS/dues — board dues, MLS fees, association membership, license renewal
• Mileage — business driving, tracked by miles (valuable at tax time)
• Software — CRM, e-signature, transaction management, design and scheduling tools
• Coaching — masterminds, courses, mentoring, conferences, books

The goal is not to judge the spend in the moment. The goal is to make the spend visible. When marketing is its own line item, you can finally answer the question "is my lead-gen actually returning more than it costs?" — which is the single most important profitability question in this business. Most agents never answer it because they never isolate the number.

Step 3 — The Tax Set-Aside Rule

This is the step agents skip and then regret. Because you are an independent contractor, no one withholds taxes for you. The IRS charges a 15.3% self-employment tax on top of your regular income tax, and that figure surprises people who are used to a W-2 where withholding happened automatically behind the scenes.

My rule: the day a commission clears, move 25–30% of the net into a separate savings account you do not touch for anything else. That buffer covers both the self-employment tax and your income tax bracket. Then, four times a year, use those set-aside funds to pay your quarterly estimated tax payments. The account is not savings — it is a bill you are prepaying. Treat it that way and you will never face a spring surprise, and you will never accidentally spend money that was never really yours.

Step 4 — Arrive at Your Real Profit Number

Profit is what remains after income, expenses, and tax set-aside are all accounted for. This is the number to obsess over, not gross commission. A $20,000 closing that required $4,000 in marketing and $5,500 in taxes is a very different animal from one that required $500 in marketing and the same tax hit. Tracking profit weekly trains your brain to think like a business owner instead of a commission collector, and it changes how you price your services and choose your lead sources.

The Exact Spreadsheet Template

Here is the structure I use. You can build this in Google Sheets or Excel in about five minutes:

| Date | Source / Description | Income (gross) | Income (net) | Expense category | Expense amount | Tax set-aside (28%) | Profit (running) | |------|----------------------|----------------|--------------|------------------|----------------|---------------------|------------------| | 07/12 | 123 Maple St — closing | 18,000 | 12,600 | — | — | 3,528 | =running | | 07/14 | Facebook ads | — | — | Marketing | 400 | — | =prev−400 |

The formula. Keep a running profit cell. For any given row, profit for that row = net income − expense amount − tax set-aside. Your running total at the bottom of the Profit column is a SUM of all row profits. The tax set-aside cell for a commission row is simply = net income cell * 0.28 (use 0.25–0.30 depending on your bracket). Expense rows have zero income, so the same formula naturally yields a negative contribution to profit, which is exactly what you want to see. The running total carries forward row to row: each new row's running profit equals the previous running total plus that row's net minus its expense minus its set-aside.

A Cleaner Way to Think About the Formula

If you prefer, separate the math into three helper columns — Income Net, Expense, Set-Aside — and let a fourth column compute =SUM(income net range) − SUM(expense range) − SUM(set-aside range). Either approach works; the point is that the template does the arithmetic so you only ever enter real-world facts.

Your Sunday 10-Minute Routine Checklist

Block ten minutes every Sunday. Run this list:

1. Open the tracker.
2. Log any commissions that closed in the past week (gross + net + split note).
3. Categorize every expense from the week's receipts and card statements.
4. Transfer 25–30% of new net income to the tax account.
5. Glance at the running profit total and note it in a "monthly snapshot" tab.
6. Close the sheet. Done.

That is the whole ritual. Ten minutes, once a week, no exceptions. The compounding effect over a year is a complete, defensible picture of your business that you could hand to any accountant without a panic search for missing receipts.

When to Graduate to Software or a Bookkeeper

The spreadsheet is perfect from zero up to roughly the point where you can no longer remember every transaction without help — for most agents that is somewhere between 15 and 30 closings a year, or the moment you hire a transaction coordinator or assistant. Signs you have outgrown the sheet: you are missing log entries, your tax account math feels shaky, or you want automated profit-and-loss statements for lending or investing. At that stage, graduate to dedicated bookkeeping software or a part-time bookkeeper who works from your same four-column logic. The system does not change — only the tool does.

How WinningRealtors Lowers Your Biggest Cost — and Lifts Profit

Marketing and lead generation are usually the largest variable expense for an agent, and the category most likely to leak. WinningRealtors helps you cut that leak at the source: instead of paying for scattered ad campaigns and duplicate content vendors, the platform gives you AI-generated market reports, a branded agent website, and content tools that do the heavy lifting of staying visible in your farm area. Lower marketing cost per deal means a higher profit number in that fourth column — and because the platform produces the materials you would otherwise pay outside vendors for, it directly improves the bottom line you tracked in Step 4. Explore the toolkit at https://winningrealtors.com.

FAQ

Do I really need to track mileage separately? Yes. Mileage is one of the most commonly missed deductions for agents who drive constantly between showings, inspections, and closings. Logging it in its own category ensures you capture it accurately at tax time instead of estimating from memory.

What if my commission splits change mid-year? Log each closing with its actual split at the time. The tracker is a record of reality, not a forecast. Over the year you will see your effective take rate, which is useful ammunition when reviewing your brokerage agreement.

Is 28% enough for taxes? For many agents, moving 25–30% covers the 15.3% self-employment tax plus a reasonable income tax buffer. If you have other income or live in a high-tax state, lean toward 30% or ask a tax professional for your specific rate.

Can I do this on my phone? Absolutely. A mobile-friendly sheet or a notes app with the same four columns works perfectly. The discipline is the weekly ten minutes, not the device you use.

What if I forgot to track a few months? Start today with what you can reconstruct, and move forward consistently. A partially complete year is still far better than no record, and next year will be clean from the first week.

CTA

Want the exact spreadsheet I described, pre-formatted with the formulas and the Sunday checklist baked in? Comment MONEY and I'll send you the template so you can start tracking this week. Related:

• A Month of Website Content in One Sitting
• How to Automate Weekly Seller Updates That Build Trust