Bookkeeping, payroll, and tax services for small businesses across the Valley of the Sun.

Call or Text: (602) 730-4560

How should a real estate brokerage track individual agent commissions and 1099 reporting?

The goal is to set up QuickBooks Online so every dollar flows through with a clear connection to the individual agent. Without that structure, you end up with a lump sum of commission payments and no way to see what each agent generated or what the brokerage actually retained. The concept is similar to construction job costing in Phoenix where you need profitability visibility per project. For a brokerage, the “project” is each agent.

In QBO, the two common approaches are classes and sub-customers. Classes let you tag every transaction with the agent’s name so you can run profit and loss reports filtered by agent. Sub-customers work by creating a parent customer called something like “Commissions” and adding each agent underneath. Either method gets the job done. Classes tend to be simpler if you want brokerage-wide financials with an easy per-agent breakdown. Sub-customers work better if you also want to use invoicing or statements tied to each agent.

For every closed transaction, record three things: the gross commission the brokerage received, the agent’s split paid out, and the brokerage retention. If a deal generates a $12,000 commission and the agent is on a 70/30 split, you record the $12,000 as income, $8,400 as a commission expense tagged to that agent, and the remaining $3,600 stays as brokerage revenue. This gives you a clear picture of what each agent costs and contributes over time.

Many brokerages also charge desk fees, technology fees, E&O insurance contributions, or marketing chargebacks. These should be tracked per agent as well. You can record them as offsets to the commission payment or as separate income line items. Keeping them separated on the books makes it easier to see your actual revenue sources and gives you better data when evaluating your fee structure.

The 1099-NEC side starts before you ever pay an agent. Collect a W-9 from every agent during onboarding, before the first commission check goes out. Store these securely because you will need them at year end. Any agent who receives $600 or more in total payments during the calendar year gets a 1099-NEC filed by January 31. QBO can generate these if your vendor records are set up properly with each agent’s tax ID and their contractor status flagged.

The most common mistake real estate brokerages make is not setting this up from day one. They start paying agents and figure they will sort out the tracking later. Later usually means a painful cleanup before tax season where someone has to go transaction by transaction to figure out who got paid what. Getting the structure right in QBO upfront takes a few hours. Reconstructing a year of sloppy records takes significantly longer and costs a lot more.

Your Valley of the Sun Bookkeeper

The Next Step:
A Quick Conversation

Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.

More Questions

What are the trust accounting requirements for property managers in Arizona?

Arizona requires property managers to hold tenant deposits and collected rents in a separate trust account, never commingled with operating funds. A monthly 3-way reconciliation of the bank statement, trust ledger, and individual tenant ledgers is required, and violations can result in license revocation.

Read answer

How do I handle progress billing for large residential trade jobs?

Define clear milestones in your contract, invoice as each milestone is completed, and track your costs against each phase. Progress billing protects your cash flow so you're not financing a customer's project out of your own pocket.

Read answer

What are the accounting requirements for Medicaid managed care contracts versus fee-for-service?

Fee-for-service revenue is booked per claim at the Medicaid fee schedule rate, while managed care capitation is booked as a flat monthly per-member-per-month payment regardless of services delivered. Each model creates different cash flow patterns that require their own forecasting approach.

Read answer

How do I account for service agreements and maintenance contracts in my HVAC business?

Record the payment as deferred revenue when collected, then recognize it as earned revenue when each service visit is performed. This prevents your P&L from overstating income in the months you collect and understating it in the months you do the work.

Read answer

Can I deduct hand tools and power tools as a self-employed electrician or do I depreciate them?

Most hand tools and power tools under $2,500 can be deducted immediately using the IRS de minimis safe harbor election. Tools over $2,500 can be fully deducted through Section 179 or depreciated over 5 to 7 years. Either way, keep every receipt because tool deductions are a common audit flag for trades.

Read answer

What bookkeeping system should I use to track insurance reimbursements by payer for my medical practice?

Use your practice management system for claims and aging, then reconcile monthly into QuickBooks Online. Set up each insurance payer as a customer in QBO so you can track payments, denials, and adjustments by payer.

Read answer

Phoenix-based bookkeeping firm serving small businesses across the Valley of the Sun. We provide bookkeeping, payroll, tax preparation, and fractional CFO support with transparent pricing and no upselling. Owned and operated by David Morrow, a former COO with 20+ years of business experience.

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • QuickBooks Online Payroll Certification badge

© 2026 2Morrow Bookkeeping LLC