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
How do I set up QuickBooks for a medical practice with multiple revenue streams?
Create classes for each revenue stream and use sub-accounts under income for every payer category. Then reconcile QuickBooks to your practice management system monthly so the two always agree.
Read answerHow do I properly allocate shared costs between program services and administration on Form 990?
Pick a reasonable allocation method like time spent, square footage, or direct benefit and apply it consistently. Document your methodology thoroughly because the IRS and donors both scrutinize how much of your spending goes to programs versus overhead.
Read answerHow do I calculate payroll tax obligations for a small business with both W-2 and 1099 workers?
W-2 employees require federal and Arizona state tax withholding, plus employer-paid FICA, FUTA, and SUTA. 1099 contractors handle their own taxes entirely. You just need to issue a 1099-NEC for payments over $600.
Read answerHow do I track equipment costs per construction job including depreciation and fuel?
Calculate an internal equipment rate that bundles depreciation, maintenance, insurance, and fuel into a single hourly cost. Multiply that rate by the hours each piece of equipment works on a job to allocate costs accurately.
Read answerHow do I track depreciation schedules for multiple rental properties in QuickBooks?
Create a parent fixed asset account for each property with sub-accounts for building, land, and improvements. Depreciation for residential rental buildings uses 27.5 year straight-line, and land is never depreciated.
Read answerWhat insurance costs should a contractor track by job versus as overhead?
General liability and workers comp premiums tied to job payroll should be allocated per job. Builder's risk and project-specific bonds are direct job costs. General commercial policies, office insurance, and bonding capacity costs are overhead.
Read answer