Written by Behdad Karimi Dermeni, CPA · Reviewed by Maryam Ajorloo, CPA
Real estate bookkeeping is the practice of recording every dollar that moves through your business as an agent: the gross commission on each closing, the split your brokerage keeps, the expenses you paid to win the deal, and the taxes you owe on what is left. Done right, it takes about 20 minutes a month.
Here is the part nobody warns you about at license school. Your income does not arrive like a paycheck. It arrives in lumps, months apart, already reduced by a split you did not process yourself, with nothing withheld for taxes. Then in April the math has to reconcile perfectly.
Most guides on this topic are written for landlords with rental portfolios, which is a completely different problem. This one is for agents.
If your current system is a bank app and a hopeful feeling, see how ReInvestWealth handles commission income.
The one rule that fixes most realtor books
Record the whole deal, then record the split.
Your books should show the full commission you earned and the piece your brokerage kept as two separate lines, not one net number that quietly appeared in your account.
That is it. Almost every messy set of realtor books traces back to skipping this one step, and almost every clean set follows it. Everything below is just applying that rule.
Why real estate bookkeeping is different
Four things make your books unlike a normal small business's.
You are a statutory nonemployee. Under IRS rules, licensed real estate agents are treated as self-employed for all federal tax purposes, including income and employment taxes, as long as substantially all your pay is tied to sales output rather than hours worked and you have a written contract saying you are not an employee. That is nearly every agent on a commission plan.
Nothing is withheld. No employer is quietly setting aside your tax money each month. That job is now yours, and it is the single biggest reason agents get an unpleasant surprise in April.
Your income is lumpy. Three closings in May and nothing in August is a normal year, not a bad one. Books built on the assumption of steady monthly revenue will not tell you anything useful.
Your revenue passes through someone else first. The brokerage takes its cut before you ever see the money, which creates the gross-versus-net trap below.
Gross vs net commission: the mistake that breaks the books
This is the one to get right, so here is a real example.
You close a $500,000 sale at a 3% commission. Your brokerage splits 70/30 in your favor and charges a $300 transaction fee.
Gross commission income: $15,000. This is your revenue.
Brokerage split (30%): $4,500. This is a business expense.
Transaction fee: $300. Also a business expense.
What hits your bank account: $10,200.
If you record $10,200 as your income and stop there, your books are wrong in three ways at once. Your revenue is understated by $4,800, you have silently thrown away $4,800 of legitimate deductions, and your profit margin per deal becomes impossible to calculate. You cannot tell whether your split is worth what your brokerage provides if the split never appears in your books.
There is also a practical reason this matters in January. Your brokerage will send you a 1099, and it may report your gross commission rather than your net split. If your books say $10,200 and your 1099 says $15,000, you get to spend a February evening figuring out which is right. Check with your brokerage which figure they report, then make sure your books match it. (Note that whichever way the 1099 reads, the split is still a deductible expense when you paid it.)
What your real estate bookkeeping spreadsheet needs
You can absolutely start in a spreadsheet, and for a first year with a handful of closings it is a reasonable choice. But most free realtor templates are just an expense list with a total at the bottom, which misses the whole point.
A spreadsheet that actually works has four tabs.
Tab 1: Closings. One row per transaction, which is where the gross-versus-net rule lives. Columns:
Close date
Property address
Sale price
Commission rate and gross commission
Brokerage split (dollar amount)
Transaction and franchise fees
Referral fee paid out, if any
Net commission received
Date the money actually landed
Tab 2: Expenses. One row per expense, dated, with a category and a note on which deal or campaign it belongs to. Categories worth separating for an agent: brokerage and desk fees, MLS and board dues, license renewal, E&O insurance, marketing and photography, staging, client gifts, CRM and software, mileage, meals, and continuing education.
Tab 3: Mileage log. Date, starting point, destination, business purpose, and miles. More on why this tab needs a twist in 2026 below.
Tab 4: Tax set-aside. Every time a commission lands, log the date, the amount received, the percentage you moved to savings, and a running balance. This tab is the difference between a calm April and a payment plan.
Then one summary cell you actually look at: gross commission, minus splits and fees, minus expenses, equals your real profit. That number is your profit and loss statement in miniature, and it is usually a lot lower than agents expect the first time they build it. Better to learn that in March than in April.
How to run your books each month
Five steps, once a month, ideally on the same day so it becomes a habit rather than a decision.
Log every closing that funded. Enter the gross commission, the split, and the fees on the Closings tab. Do this while you still remember the deal, not in December.
Categorize the month's expenses. Pull your business account and business card activity and assign a category to each line. If something looks unfamiliar, find the receipt now while the vendor name still means something.
Match receipts to expenses. Anything over a modest amount should have a receipt attached or filed. A bank line that says "SQ *STAGING" proves money left; it does not prove what you bought.
Move your tax money. Transfer your set-aside percentage on every commission received, and log it. Treat this as a bill you owe yourself.
Reconcile to your bank. Confirm your recorded net commissions and expenses agree with what the bank actually shows. If the two disagree, something is missing, and the gap is always easier to find this month than next quarter.
One thing that trips up almost everyone at step 2: paying your credit card is not an expense. The expense already happened when you bought the staging or the photography. The payment is just money moving between two of your own accounts, which bookkeepers call an interfund transfer. Recording both the purchase and the payment as expenses double-counts every dollar you spend on a card, and it is the most common way a self-taught set of books ends up overstating expenses.
Set aside tax money before you spend the commission
Because nothing is withheld, you are responsible for paying as you go.
The rule of thumb is 25% to 30% of your net commission, moved to a separate savings account the day the money arrives. That is not a tax calculation, it is a buffer, and your accountant will fine-tune it based on your actual bracket, deductions, and state.
Two numbers to know, both straight from the IRS:
Self-employment tax is 15.3% of net earnings, which breaks down as 12.4% for Social Security and 2.9% for Medicare. You file Schedule SE once your net self-employment earnings hit $400. This sits on top of your income tax, which is why 10% set-aside plans end badly.
Estimated taxes are generally due quarterly if you expect to owe $1,000 or more when you file. That threshold comes straight from the IRS guidance on estimated taxes. Miss a quarter and you can owe an underpayment penalty even if you pay the full amount in April, so it is worth knowing what a missed payment would cost before it happens.
The lumpy-income problem makes this genuinely harder than it is for a salaried person, and the honest answer is that a percentage-of-every-check habit handles it better than any forecast. You cannot predict which month closes. You can predict that 27% of whatever closes is not yours.
This is exactly the kind of running total that ReInvestWealth keeps current automatically instead of monthly, so you always know where you stand: see how it works.
The mileage log agents actually need in 2026
Agents drive. Showings, inspections, open houses, the client who wants to see it one more time at dusk. It is often the single largest deduction on the return, and it is the one most likely to be reconstructed from memory in April, which is the worst possible way to do it.
Here is the wrinkle almost every article on this topic currently gets wrong. The 2026 business standard mileage rate changed mid-year. The IRS set it at 72.5 cents per mile starting January 1, then revised it to 76 cents for miles driven on or after July 1, 2026, because of fuel prices.
For your bookkeeping that means one thing: your mileage log needs to separate miles driven before July 1 from miles driven after. One annual total multiplied by one rate will be wrong this year. If you have been logging a running total without dates, splitting it now is a 10-minute job. In April it is guesswork.
Log the date, the destination, the business purpose, and the miles, contemporaneously. For the full picture of what else an agent can deduct, our guide to tax write-offs for real estate agents covers the categories in detail.
When the spreadsheet stops working
Spreadsheets do not fail dramatically. They just quietly stop being current, usually right when you get busy, which is exactly when the records matter most.
You have outgrown yours when any of these is true:
You are entering the same recurring expenses by hand every month
You are more than one month behind, and catching up feels like a project rather than a task
You cannot answer "what did I actually earn this quarter" in under a minute
You are doing more than roughly a dozen closings a year
Your spreadsheet has developed formulas only you understand, held together by conditional formatting and hope
The alternative is not necessarily hiring a bookkeeper. Connect your business accounts and let an AI bookkeeper categorize transactions as they arrive, so your books are current on a Tuesday in July rather than assembled in April. ReInvestWealth was built by CPAs to do exactly this, and it keeps the receipt trail attached to the transactions, which is what turns a pile of expenses into a defensible deduction.
3,000+ entrepreneurs run their books on ReInvestWealth, and it holds a 4.8-star rating on Capterra. For you that means the commission-heavy, lumpy-income pattern you are dealing with is well-worn ground rather than an edge case.
One practical heads-up when you switch, because it surprises people: connecting a bank account typically pulls only the last 45 to 90 days of history. For a full year of books you upload statements for the earlier months, which is a normal part of setup rather than a problem.
Your spreadsheet did its job. It is allowed to retire.
3 habits that keep realtor books clean
Run every dollar through a dedicated business account and card. Not for tidiness, but because it makes your books nearly self-assembling and removes the "was this personal?" question entirely. One account, one card, no exceptions, starting with your next closing.
Photograph the receipt at the moment of purchase. Not tonight, not Sunday. The staging invoice, the closing gift, the parking at the inspection. A receipt captured in the moment is worth three you meant to file.
Book 20 minutes on the same day each month. Put it in your calendar like a showing. Bookkeeping that happens monthly takes minutes; bookkeeping that happens annually takes a weekend and a certain amount of regret.
Frequently asked questions
Do real estate agents need a separate business bank account?
Legally, a sole proprietor is not required to have one. Practically, it is the highest-return 20 minutes you will spend on your finances. Mixing personal and business activity in one account means every bookkeeping session starts with sorting groceries from staging costs, and it weakens your documentation if your return is ever questioned.
Should real estate agents use cash or accrual accounting?
Most agents use the cash method, recording commission when it is received and expenses when they are paid. It matches how the money actually moves and is simpler to maintain. Accrual accounting records income when it is earned, which can make sense for a larger team or a brokerage. Your accountant will confirm which fits your situation and how it interacts with your return.
What should I do if my 1099 does not match my books?
Find out which figure your brokerage reported, gross commission or your net split, then trace the difference. Nine times out of ten the gap equals your total brokerage splits and transaction fees for the year, which means your books recorded net where the 1099 recorded gross. The fix is to record the gross commission as revenue and the split as an expense, which lands you at the same taxable profit while matching the form.
How long should real estate agents keep receipts and records?
Keep supporting records for at least 3 years from the date you filed, and longer in some situations. The IRS publishes period-of-limitations guidance by scenario, and many CPAs suggest 6 to 7 years for business records as a practical default. Digital copies are acceptable, which is a good argument for photographing receipts rather than filing paper.
Can I do real estate bookkeeping in a spreadsheet, or do I need software?
A spreadsheet genuinely works for a first year with a handful of closings, provided it separates gross commission from your split. Once you are doing steady volume, the manual entry becomes the bottleneck and being behind becomes the default state. Most agents switch when the maintenance costs more time than the deals do.
Start with clean books, not a cleanup
Connect your business account and let the AI categorize your commissions and expenses as they land. Gross recorded separately from the split, receipts matched, tax set-aside visible, no April reconstruction. CPA-level clean books, and you can start free for 30 days.
A note from our CPAs: This guide is educational and covers the general rules for US real estate agents. Tax situations vary by state and by how your business is structured, so for advice on your specific circumstances, talk to your accountant. (If they use ReInvestWealth, they will already have clean books to work from.)
Written by Behdad Karimi Dermeni, CPA
> Co-founder of ReInvestWealth and a founding community builder at Stripe. Behdad built ReInvestWealth to give smart, busy entrepreneurs CPA-level accounting without the CPA-level price tag. Read more · Connect on LinkedIn
Reviewed by Maryam Ajorloo, CPA
> Maryam Ajorloo is the co-founder of ReInvestWealth and a CPA who specializes in small business tax, sales tax, and everyday bookkeeping. She helps entrepreneurs keep clean, audit-ready books and make sense of write-offs, filing deadlines, and the numbers behind their business. Read more · Connect on LinkedIn
