QuickBooks Online for Real Estate Brokerages: A Practical Guide

QuickBooks Online is the bookkeeping backbone of most independent real estate brokerages. But the default QBO setup is designed for a generic small business — not a brokerage that collects commission from closings, splits it with agents, pays E&O fees, and files 1099s for 20+ independent contractors.

Getting QBO right for a real estate brokerage requires intentional setup. Here's how to do it.

Chart of Accounts: Start Here

The chart of accounts (COA) is the foundation. If it's set up wrong, every report will be misleading. For a real estate brokerage, you need at minimum:

Income accounts:

Gross Commission Income (or "GCI") — total commission earned before any splits
Referral Income — commissions received for referring clients to other agents/brokerages
Desk Fee Income — if you charge desk fees

Cost of Revenue / Agent Payments:

Agent Commission Expense — the portion of GCI paid to agents
Referral Fee Expense — commissions paid out for referrals received

Operating Expenses:

E&O Insurance (or expense the per-deal deduction through here)
Transaction Coordinator Fees
MLS Fees
Marketing

Liability (if applicable):

Agent Commission Payable — if you hold commissions before disbursing

The critical discipline: GCI goes to income gross, and agent payouts go to expense. Do not record only the broker's net. This inflates your income reports and makes 1099 preparation far more difficult.

Invoices vs. Bills: The QBO Agent Payment Question

One of the most common QBO questions from brokerage bookkeepers: do I use invoices or bills to pay agents?

The short answer: Use bills (or write checks/direct expense) when paying agents their commission portion.

Here's why: Agents are vendors in QuickBooks. They receive payments from you. You are not issuing them an invoice (that implies they owe you money). Instead, you record:

Income: A sales receipt or invoice when the brokerage receives the commission from the closing.
Expense/Bill: A bill or check payment to the agent for their portion.

For 1099 purposes, the total paid to each agent (vendor) flows into your 1099 prep report at year end. This only works correctly if agents are set up as vendors and paid via the expense/bill workflow.

The Per-Deal Accounting Workflow

Here's the workflow for a typical deal in QBO:

Step 1 — Commission received from escrow: Record a bank deposit with income account = Gross Commission Income.

Step 2 — E&O and other deductions: If you collect E&O from the agent's portion, record this as a reduction to the agent's payout, or as a separate income line (Agent E&O Recovery). The latter keeps your E&O expense separate from the offset.

Step 3 — Agent payout: Record a bill or check to the agent (vendor) for their net commission. Account = Agent Commission Expense.

Step 4 — Reconcile: The difference between the deposit and the payout (plus any deductions) equals the broker's net — your actual brokerage revenue from the deal.

Done correctly, this means every closing appears as a complete, traceable event in QBO with no manual journal entries required.

Setting Up Agents as Vendors

Go to the Vendors section in QBO and create a profile for each agent. The critical fields:

Track payments for 1099: Yes — check this box for every agent who is an independent contractor.
Tax ID: Collect W-9s from every agent. Enter their SSN or EIN here.
Payment method: Set up direct deposit (ACH) if possible to streamline disbursement.

At year end, QBO will generate 1099-NEC forms for every agent paid more than $600. This only works if agents are properly set up as 1099-eligible vendors and all payments flow through their vendor record.

The Problem with Manual QBO Entry

Every deal requires three to five QBO entries (deposit, splits, deductions, agent payment). For a brokerage closing 10 deals a month, that's 30–50 manual QBO transactions. For a 30-agent brokerage doing 80 deals a month, it's 240–400 transactions.

At that volume, the bottleneck isn't whether your bookkeeper knows QBO — it's the sheer number of manual entries and the likelihood of errors. A deal entered with the wrong split, a deduction applied twice, or an agent payment posted to the wrong account can cascade into reconciliation headaches that take hours to untangle.

Syncing Commission Software to QBO

The cleanest approach is to calculate commissions in a purpose-built tool and sync transactions to QBO automatically. A good sync should:

Create the deposit/income entry automatically
Create the agent bill/expense automatically
Apply the correct account codes based on deal type
Be previewable before execution (dry run)
Be reversible if there's an error

When commission calculations and QBO entries happen in the same workflow, you eliminate the translation step — the manual re-entry of a number calculated elsewhere. That translation step is where most errors originate.

A Note on QBO Versions

SplitRE integrates with QuickBooks Online (not Desktop). It's compatible with QBO Simple Start, Essentials, Plus, and Advanced. The Advanced plan (or the Accountant version) gives you the most flexibility in chart of accounts customization, but QBO Essentials is sufficient for most brokerages under 30 agents.

If you're currently on QuickBooks Desktop and considering a move, QBO is worth it for the API integrations alone — the ability to sync commission tools, payroll systems, and bank feeds in real time is a major operational upgrade.

Getting Started

If you're setting up QBO from scratch for your brokerage, spend an afternoon getting the chart of accounts right before you enter a single transaction. Every shortcut you take in setup creates debt you'll pay in reconciliation time later. Set up agents as 1099 vendors, use the income/expense split correctly, and make sure your bank feeds are reconciling monthly.

Then, once the structure is right, explore syncing your commission calculations to QBO directly. The time savings are real and the error reduction is significant.