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

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

How do I track and account for medical equipment financing and lease payments?

The accounting depends on whether you have an equipment loan, capital lease, or operating lease. Recording the full monthly payment as an expense is the most common mistake. Each arrangement requires different treatment on your balance sheet and income statement.

Read answer

How do I clean up a messy QuickBooks file that hasn't been maintained properly?

Start with bank reconciliation month by month, then fix uncategorized transactions and clean up your chart of accounts. The process is methodical and every step builds on the one before it.

Read answer

Can a landscaping business deduct the cost of a trailer and mowing equipment in the first year?

Yes. Section 179 lets you deduct the full purchase price of qualifying equipment like mowers, trailers, and trucks in the year you buy them. The 2024 limit is $1,220,000, which covers most landscaping equipment purchases easily.

Read answer

What are Arizona's requirements for filing state payroll taxes and Form A-4?

Arizona uses a unique flat-percentage withholding system where employees choose their rate on Form A-4. Employers deposit withholding quarterly using Form A1-QRT and file an annual reconciliation on Form A1-R by February 28.

Read answer

How do I set up QuickBooks Online correctly for a new business from scratch?

Choose the right plan, set your fiscal year and accounting method, then customize the chart of accounts for your specific industry. The defaults QuickBooks gives you are generic and won't produce useful financial reports without modification.

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