Bookkeeping pitfalls common in real estate brokerages
Brokerages and property managers run at least two sets of money, and frequently more. The operating account belongs to the firm. The trust or escrow account holds earnest money, security deposits, and rents that belong to clients. Many states require a separate trust account per property or at minimum per owner, and the broker-of-record is personally responsible for reconciling each one. Commingling, even briefly, is a license issue. The bookkeeping mirror of that requirement is a per-property trust reconciliation that ties to the bank statement and to the property ledger every month.
Agent commissions and 1099-MISC reporting are the second pressure point. Splits vary by agent, by transaction, by team, and by referral source, and the brokerage that pays a referral fee to an out-of-state agent has to capture that agent's W-9 and license information before the deal closes. Mixing 1099-NEC and 1099-MISC is a common error, since real-estate referral payments to non-employee agents generally go on 1099-NEC while certain other payments may go on 1099-MISC. Multi-entity holding company structures, where each property sits in a single-purpose LLC, multiply the chart-of-accounts complexity and the inter-company transactions that have to clear.
Section 1031 exchanges and security deposit handling are the third quiet failure mode. A 1031 requires the proceeds to flow through a qualified intermediary and the books have to reflect the deferred gain on the replacement property's basis. Security deposits are liabilities, not income, and forfeited deposits applied to damages have specific income-recognition rules. HUD-1 or Closing Disclosure detail at each closing has to be parsed into the right accounts, and a missed line item there produces a basis error that follows the property for years.
How ATCS handles it
- Multi-account reconciliation handles the operating account, each trust or escrow account, and the merchant feeds in parallel, which is the structure a broker-of-record needs for state license compliance.
- Department/location coding can be configured per property or per holding-company entity, so per-property P&L and inter-entity activity stay clean through the close.
- 1099-NEC and 1099-MISC vendor tracking with tokenized W-9 capture forces the W-9 on file before the commission check goes out, eliminating the January chase for agent and referral information.
- Per-transaction document attachments hold the HUD-1 or Closing Disclosure against the entries that come out of it, so basis questions years later are answered from the books.
- The CPA handoff bundle delivers per-entity P&Ls, registers, and document indexes together, which is what a tax preparer needs to file the related-entity returns and any 1031 deferred-gain disclosures.
FAQ
Does a brokerage have to keep a separate trust account per property?
That depends on state license law. Some states require per-property trust accounts, others permit a pooled trust account with sub-ledgers per property. In either case, ATCS supports per-property tagging within the trust account and per-property reconciliation so the broker-of-record can satisfy the state's standard.
Is a referral fee paid to another real-estate agent a 1099-NEC or 1099-MISC?
Referral fees paid to a non-employee licensed agent are generally reported on 1099-NEC. Form 1099-MISC applies to other payment categories such as rents paid to a landlord. ATCS tags each vendor with the correct form category at onboarding.
How are security deposits recorded?
Security deposits are recorded as liabilities at receipt, not income. They become income only when forfeited and applied to damages or unpaid rent under the lease and applicable state law. ATCS keeps the liability balance per tenant or per unit through location coding.
Can ATCS support a multi-entity holding company structure?
Yes. Each entity can have its own department or location code with its own P&L and balance sheet view, and the audit log preserves the inter-entity transaction trail the CPA needs at year-end.
Where to next
To size ATCS for Real estate, run the pricing calculator and the live ranges update as you set headcount, account count, and AI usage. For the engineering and infrastructure behind it, see bookkeeping & reconciliation, the AI business assistant, and the infrastructure page.