How to Track Real Estate Agent Commission Splits in QuickBooks Online (For Teams)
If you run a real estate team, chances are you do your bookkeeping in QuickBooks Online (QBO). That makes sense: QBO is the platform most accountants know, and everyone tells you it's the one to use. But the reports you pull every month, the ones that are supposed to tell the full financial story of your business, just seem, well, off.
You stare at the P&L. Nowhere does it show your gross commission income (GCI) or your cost of sale (COS). It doesn't show your true gross profit margin or your GCI per agent. You get a general idea of your net income, but not your true net profit margin.
Your P&L will satisfy the tax man, but it can't answer a basic question: what does it cost me, in splits, fees, and referrals, to close each deal?
That's because tracking your team's commissions and cost of sale in QBO isn't intuitive. It takes a repeatable workflow and some know-how. To do it right, you need the commission statement from your brokerage. It holds the details that never show up when the deposit lands in your bank account.
This guide is for teams operating under a brokerage that want accurate, deal-level commission tracking. It is not a year-end "close the books" guide. We'll walk through the manual workflow first, then show where automation can take it off your plate.
Built from the playbook of Agent CFO.
Step 1: Understand the five buckets of every commission check
Before we build the workflow, let's look at how a commission check breaks down. Every commission falls into roughly five buckets: start with income, take out the cost of sale, and you're left with the net check.
| # | Bucket | What it is | Example QBO accounts | QBO account type |
|---|---|---|---|---|
| 1 | Gross commission (GCI) | Total commission on the deal, plus any transaction fee the client pays | Listing Income, Sales Income, Leasing Income, Client Transaction Fee Income | Income |
| 2 | Brokerage, franchise, and transaction fees | Fees the brokerage charges the team | Commission to Brokerage, Royalties Paid, Transaction Fees Paid | Cost of Goods Sold |
| 3 | Referral fees | Payments to outside referrers | Referral Fees Paid | Cost of Goods Sold |
| 4 | Team member splits | Payouts to your own agents | Buyer Splits, Listing Splits, Leasing Splits | Cost of Goods Sold |
| 5 | Net to the team | What lands in your bank account | Operating account or Undeposited Funds | Bank, or Other Current Asset |
QBO doesn't have an account type called "cost of sale." Use Cost of Goods Sold. Accounts set up that way appear above gross profit on your P&L, which is exactly where you want them.
One distinction trips people up: a transaction fee can sit in either bucket. A fee the client pays is income (bucket 1). A fee the brokerage charges you is cost of sale (bucket 2).
Clear as mud? Don't worry. These buckets are easier to see with real numbers, so let's walk through an example. We'll show it two ways: first as a traditional journal entry, then as the multi-line bank deposit most teams use.
Example deal
- Brokerage: Keller Williams
- Gross commission: $11,120.00, including a $495.00 transaction fee paid by the client
- Team agent on the deal: John Smith (buyer's agent)
- Net check: $4,745.00
As a journal entry
| Account (your names will differ) | Debit | Credit | Name |
|---|---|---|---|
| Residential sales income | 10,625.00 | Keller Williams | |
| Client transaction fee income | 495.00 | Keller Williams | |
| Buyer splits | 5,125.00 | John Smith | |
| Commissions to office | 1,250.00 | Keller Williams | |
| Bank account | 4,745.00 | ||
| Totals | 11,120.00 | 11,120.00 |
As a bank deposit
| Account (your names will differ) | Amount | Name |
|---|---|---|
| Residential sales income | 10,625.00 | Keller Williams |
| Client transaction fee income | 495.00 | Keller Williams |
| Buyer splits | -5,125.00 | John Smith |
| Commissions to office | -1,250.00 | Keller Williams |
| Total deposit | 4,745.00 |
Either way, you end up with a net deposit of $4,745.00, matching what landed in your bank account. But instead of booking that deposit as "income" and hiding the cost of sale, this entry puts every cost on your P&L where you can see and analyze it.
This deal had no outside referral. If it did, the referral fee would be one more Cost of Goods Sold line, named to the referring agent or brokerage.
So what does a manual workflow built on these buckets look like?
Step 2: Build the manual QBO workflow
- Set up your chart of accounts. Create accounts for all five buckets, plus more if you need finer detail, so every dollar of income and cost of sale has a home.
- Get the commission statement for the deal. This is your source of truth. Depending on your brokerage, it may be called a commission disbursement authorization (CDA) or disbursement authorization (DA).
- Find the matching deposit in your bank feed.
- Record the deal. Using the commission statement, create a balanced journal entry or bank deposit with the right bucket for each line.
- Match the entry to the deposit in the bank feed, so the deal is recorded once and only once.
Step 3: Track margins by agent with classes
Once your team has more than a couple of agents, the question changes from "what did we make?" to "what did we make on each agent?" QBO's class tracking answers it.
- Turn on class tracking in QBO's account settings (available on Plus and Advanced plans).
- Create one class per agent, plus one for deals the team lead closes personally.
- Tag every line of each commission entry with the class of the agent on the deal: the income, the brokerage fees, and the split.
- Run a Profit and Loss by Class report. You'll see GCI, cost of sale, and gross profit for each agent side by side.
This is where the work in Steps 1 and 2 pays off. You can see which agents are profitable on their current split and which ones aren't.
Common mistakes (especially for DIYers)
- Booking the net deposit as income. It's faster, but your GCI and cost of sale will both be wrong.
- Lumping all splits and fees into one cost of sale account. Your gross margin will be right, but you won't know what's driving it.
- Not matching the entry to the bank feed. If you create the entry and also accept the deposit from the feed, you record the income twice. That inflates revenue and leaves you with a reconciliation mess.
- Leaving the name off splits and referral fees. Without a payee on each line, you can't report on who earned what.
- Skipping class tracking as the team grows. You lose the ability to see margins by agent.
So now you have the workflow, and you can do it by hand. But is it worth your time? And how do you avoid these mistakes deal after deal?
In the age of AI, we can hand repetitive data entry to software and focus on what people do best: relationships, analysis, and creative thinking. That's why we built Dealsplit.
Where Dealsplit fits into your bookkeeping
Dealsplit, built at Agent CFO, handles the last mile of this workflow: commission PDF in, balanced journal entry out, with GCI, splits, and fees all accounted for. It replaces the slow work of keying each commission statement into QuickBooks by hand.
On dealsplit.ai, the workflow is:
- Drag and drop your commission statement PDF.
- Dealsplit extracts the GCI, agent splits, and fee lines.
- Review each line and edit anything that looks off.
- Click once to post a balanced journal entry to QBO.
You review every line before anything posts, so your books stay accurate without the manual entry.
Plans: Light $29/mo, Pro $59/mo, Elite $299/mo. Your first two deals are free.
Dealsplit currently reads Compass, eXp, and Keller Williams statements, and can be customized for most other brokerages' commission reports.
Brokerage how-tos: eXp · Keller Williams · Compass. Also: Team vs. agent bookkeeping · From commission statement to journal entry
For accountants and bookkeepers
If you keep the books for multiple teams, run them all from one firm login: statements in, clean journal entries out. Your first two client accounts and 100 deals are free, no credit card required.
FAQ
How accurate is it? Dealsplit extracts every line from the statement, and you review each one before it posts to QBO. Nothing hits your books without your sign-off. The Light plan is the easiest way to test it on your own statements.
Why journal entries? Journal entries are the most flexible building block in accounting. We wanted Dealsplit to fit every team's chart of accounts while staying reliable and easy to audit.
Is this for my brokerage's books? No. Dealsplit is built for teams operating under a brokerage. It isn't designed for brokerage, Market Center, or franchisor books, or for trust accounting.
Does this replace my CPA or bookkeeper? No. A good CPA and bookkeeper are among your team's most important partners. Dealsplit helps you, your director of operations, and your bookkeeper close the month faster, handle a high volume of closings, and report accurately on GCI and cost of sale.
Next step
See how Dealsplit handles a real commission statement: start with two free deals at dealsplit.ai, or forward this guide to your bookkeeper and ask them to try it.