Propio for Real Estate Agents & Agencies

Who this is for

This guide is for accountants and bookkeepers managing the books of a real estate agent or a small real estate agency. That includes two distinct client types:

• Independent agents — licensed agents working under a brokerage as independent contractors, earning commissions on closed deals and paying their own business expenses. Typically a sole proprietor or single-member LLC.
• Small agencies and brokerages — a brokerage owner managing 2–10 agents, earning commission splits and desk fees, and paying agents as independent contractors.

Both operate on cash-basis accounting. Where setup or workflows differ between these two client types, this guide calls it out explicitly.

Why real estate agent and agency accounting is different

• Income is lumpy and unpredictable. Commissions arrive at closing, not on a monthly schedule. A slow month followed by three closings in one week is normal, making cash flow management and accurate P&L timing critical.

• Business and personal expenses blur constantly. Agents frequently use personal cards for business purchases — marketing materials, client gifts, MLS renewals, gas. Without a dedicated business account and consistent categorization, the books become a mix of both.

• Vehicle expenses are among the largest deductions. Agents drive constantly — to showings, listings, open houses, client meetings. Gas, maintenance, and mileage-based deductions are a major part of year-end tax prep.

• For agencies: commission splits create a 1099 obligation. A brokerage paying agents $600 or more during the year must issue 1099-NEC forms — requiring year-round vendor tracking.

• For solo agents: 1099s flow the other direction. The agent receives a 1099 from their brokerage, and may need to issue one to any VA, photographer, or contractor they pay directly.

Recommended setup in Propio

1. Chart of Accounts

Income

• Commission Income (record the full gross commission before any splits — see note below)
• Referral Fee Income (inbound — fees received for sending a lead to another agent)
• Desk Fee Income (agencies only)

Expenses

• Commission Split Expense (agencies only — payouts to agents on closed deals)
• Referral Fee Expense (outbound — fees paid to another agent for sending you a lead; keep separate from commission splits to track your lead source costs)
• MLS Fees
• E&O Insurance
• Marketing & Advertising (consider subcategories for Photography, Digital Advertising, Print Materials, and Client Gifts. Precise categorization here pays off at tax time and gives the client useful data on where their marketing spend is going)
• Professional Development
• Desk Fees (solo agents only — fees paid to the brokerage for office access and affiliation)
• Professional Fees
• Software & Subscriptions
• Vehicle & Transportation (Tag the right subcategory from the start — Gas & Fuel, Parking & Tolls, or Vehicle Maintenance — so year-end reporting requires no reconstruction)
  • Gas & Fuel
  • Parking & Tolls
  • Vehicle Maintenance
  • Mileage Deduction

Liabilities

• Earnest Money Deposits (EMD) Held (agencies only — see note below)

Record gross commission, not net. For agencies, a common mistake is recording only the net commission after paying the agent split. This understates revenue and makes the P&L misleading. Record the full commission earned as income, then record the agent payout as Commission Split Expense. This gives you a clear view of gross production, total payouts, and actual net margin.

EMD is a liability, not income. If your agency client ever holds Earnest Money Deposits in escrow, categorize them under EMD Held — not as commission income. The funds belong to the buyer until conditions are met. Recording them as income creates significant tax exposure. This mirrors the security deposit treatment in property management.

Mileage deductions. Agents can deduct vehicle expenses using actual expenses (gas, maintenance — these flow through the bank account and categorize normally in Propio) or the IRS standard mileage rate (72.5 cents/mile in 2026, tracked outside Propio using a dedicated app like Everlance or MileIQ). If your client uses the standard mileage rate, record the annual calculated deduction as a manual entry under Mileage Deduction at year end.

2. Tag structure

For agencies: Tags let you track per-agent production and filter the P&L by individual agent — the equivalent of QuickBooks Class tracking.

Go to Bookkeeping → Tags → Add Tag Group, then:

• Name the group: Agents
• Enable the Exclusive toggle — each commission transaction belongs to one agent
• Add one tag per agent using their name or initials

Apply the agent tag to every commission income transaction and every commission split expense paid to that agent.

For solo agents: Tags are not essential. Skip this setup unless your client has a specific reporting need.

3. Vendors for 1099 tracking

For agencies issuing 1099s to agents: Go to Contacts and create a vendor record for each agent:

• Set Type to Vendor
• Enter their Tax ID (SSN or EIN)
• Check "1099 — Track payments for 1099 reporting"

Do this when you onboard the client — not in January. Every split payment made without a linked vendor record is a gap you'll need to reconstruct at year end.

For solo agents: Same setup applies to any VA, photographer, or contractor paid $600 or more during the year.

Key workflows

Workflow 1: Recording commission income

1. When the deposit hits the bank feed, open the transaction
2. Categorize it as Commission Income
3. Add the property address or deal name in the memo field — this makes it traceable months later
4. For agencies: apply the agent tag for the agent who closed the deal
5. If the title company already deducted the agent split before wiring, record only the net amount received — you don't need to gross it up. Only record gross when you receive the full commission and pay the split separately.

Cash-basis timing. Commission income is recorded on the date funds land in the bank account — not the contract signing date or the closing date on paper. If a closing happens December 31 but funds wire January 2, it's January income.

Workflow 2: Per-agent production tracking (agencies only)

Once agent tags are applied consistently, this is just a report:

1. Go to Reporting → Profit & Loss
2. Set your date range
3. Open the Tags filter and select one agent's tag
4. The P&L shows Commission Income and Commission Split Expense for that agent only

Run it unfiltered to see the full agency picture. Filter by agent to review individual contribution.

Workflow 3: Year-end 1099 prep

For agencies (issuing 1099s to agents):

1. Go to Reporting → 1099 Report
2. Select the full calendar year
3. Propio aggregates all payments to vendors with 1099 tracking enabled and flags anyone above the IRS threshold
4. Review the list, verify agent names match their legal names, and export to PDF or Excel

This only works cleanly if vendor records were set up with Tax IDs and 1099 tracking enabled from the start of the year (see Setup, section 3 above).

For solo agents: The agent receives a 1099-NEC from their brokerage — Propio is not involved in generating it.

Reports worth running

Tips & best practices

• Record commission income on the date funds are received, not the closing date. The wire date is what matters in cash-basis accounting — especially for deals that straddle December and January.

• One business bank account, used exclusively for business. Mixing personal and business transactions creates audit risk and makes every reconciliation harder. If a client isn't doing this yet, make it your first conversation.

• EMD held in escrow is never income. If your agency client holds earnest money, it goes to EMD Held (liability) until the deal closes or the funds are returned. Only move it to income if it's legally forfeited by the buyer.

• Separate outbound referral fees from commission splits. They represent different costs — one is the price of a lead, the other is the cost of a closed deal. Keeping them separate gives the client useful data on where their production is actually coming from.

• Set up agent vendor records before the first commission is paid. Every split paid without a vendor record is a gap to reconstruct in January.

• If your client uses the standard mileage rate, don't wait until December to reconstruct it. Recommend a mileage tracking app from day one and record the annual deduction as a single manual entry at year end.

• Reconcile monthly even in slow months. Low transaction volume is exactly when personal expenses are most likely to slip in unnoticed.