Real Estate Brokerage CDA Commission Reconciliation Workflow

A Commission Disbursement Authorization is the brokerage's written instruction to the title or escrow company specifying how to split and disburse the closing commission. Every closed transaction produces one. It tells title who gets paid, how much, and where to send it, and it carries the designated or sponsoring broker's signature authorizing the release of funds.

Real estate brokerage CDA commission reconciliation is the control that closes each of those transactions in the brokerage's books. In practice it means matching the CDA's line items against the title company's wire or check and against the agent's commission split sheet — a three-way match that confirms gross commission, brokerage retention, and net agent payout all agree before the transaction is closed in the brokerage ledger. A clerk at a 20–500-agent shop is doing this dozens of times a week, and the rest of the article works through the workflow at that operator's level.

What a CDA Contains Before Reconciliation

Before the match can run, the operator has to know how to read the document. CDAs vary in layout — some are PDF forms, some are letter-style memos on letterhead, some are platform-generated PDFs out of Brokermint, Lone Wolf Back Office, SkySlope, or Paperless Pipeline — but the structural sequence is consistent enough that it can be read as a single mental schema.

Header block. Transaction identifiers anchor the document to a specific closing: title file number (the most reliable join key downstream), property address, closing date, listing and selling agents, sponsoring or designated brokers on each side, and MLS numbers. Anything missing here will surface later as a join failure when the wire arrives.

Gross commission. Stated both in dollars and as a percentage of sales price. This figure ties back to the ALTA Settlement Statement / Closing Disclosure, which is the upstream document of record. When a CDA's gross commission looks wrong, the ALTA is the cross-check — and walking through extracting the ALTA Settlement Statement that backs the CDA's commission line is the way to verify it at scale rather than transaction by transaction.

Listing-side and buyer-side allocation. The gross splits into a listing-side figure and a buyer-side figure. Post-Settlement, the buyer-side line increasingly appears as a separately negotiated figure rather than a fixed percentage drawn from a unilateral MLS offer, and the structure of how that line is funded (seller concession, buyer-paid, or a combination) varies deal by deal. The NAR settlement section below covers what changed and how to reconcile the new shape.

Broker-side deductions. The brokerage's costs come out next: E&O insurance contribution per closing, transaction coordinator (TC) fee if borne by the brokerage, franchise royalty for franchised offices, and any marketing or compliance fees the brokerage's policy applies. Which of these land on the CDA itself versus inside the brokerage's internal split sheet varies by brokerage; the reconciliation workflow has to know which is which for every agent and every transaction type.

Agent-side deductions. Where the brokerage's policy puts agent-side deductions on the CDA itself rather than on the internal split sheet, this is where they sit: referral fees out (often the largest agent-side item and a recurring source of exceptions), mentor split for agents under a mentor agreement, team-lead split for agents on a team, broker administrative fee. Some brokerages keep all of these off the CDA and apply them on the split sheet alone; others itemize everything on the CDA so title disburses directly to each party.

Disbursement instruction block. A line per payee with name, amount, and either wire instructions or a check mailing address. This is what title actually executes from. Any payee here who isn't matched to an internal record (an agent, the brokerage, an outbound referral broker, the franchisor) is a flag.

Signature block. The designated or sponsoring broker signs to authorize title to release funds per the disbursement block. Without that signature, title doesn't fund.

No two brokerages produce CDAs that look identical, and a single brokerage's own layout can change across closings depending on which agent or coordinator drafted the document and which platform it came out of. The reconciliation that follows has to extract commission disbursement authorization line items reliably from any of those formats and match them to the wire and the split sheet without depending on a single layout.

The Three-Way Match: CDA, Title Wire, and Agent Split Sheet

The reconciliation is a three-way match between three documents that have to agree: the CDA (what the brokerage instructed title to do), the title or escrow wire confirmation or check (the money that actually arrived in the brokerage's operating or trust account), and the agent's commission split sheet or split agreement (the agent-side allocation the brokerage maintains). A reconciled transaction is one where all three agree on the same numbers under the same matching keys. Anything else is an exception, and exceptions don't close.

Matching keys

Operators apply the keys in roughly this order, taking the first one that produces a clean join:

Title file number. The most reliable join key when it's present on both the CDA and the wire memo line. Title companies often write the file number in the wire reference field, but not always — older title operations and some smaller escrow shops will send a wire with only the property street name as the reference.
Property address. Carries the match when the file number is missing or transposed. The risk is when the brokerage has two closings on the same street in the same period; then the closing date disambiguates.
Closing date. A secondary key that pairs with property address or with the listing/selling agent identifiers.
Listing and selling agents. Useful for resolving same-address ambiguity and for catching wires that arrive labeled to an agent rather than to a transaction.
Gross commission. The least reliable join key in isolation (multiple closings can share the same gross figure), but the right cross-check after the keys above narrow the candidate set.

Brokerage-side arithmetic

Once the documents are joined, the arithmetic has to balance to the cent. The form is straightforward:

Brokerage net wire from title = brokerage retention (broker-side fees plus net company dollar) + agent payouts staged from this CDA + outbound disbursements paid by the brokerage from this wire (referral fees out and franchise royalty when the brokerage cuts those checks rather than having title cut them directly).

When that equation balances against the wire amount, the transaction reconciles. When it does not, the mismatch usually falls into the exception patterns catalogued later: a short wire, an agent split sheet that does not tie, or a receipt that arrived before the CDA was on file.

The extraction layer is the input

None of this can run while the CDAs are PDFs. The match operates on structured rows — one row per CDA at minimum, often one row per disbursement line for brokerages that want to reconcile each payee directly against the wire's funded payees. Turning the CDA PDF into those rows is its own discipline, and brokerages that work across multiple platforms or none at all need an extraction layer that sits outside any single back-office system.

This is where automated CDA extraction and three-way commission match earns its independence from whichever back-office software the brokerage chose. The brokerage describes the fields it needs — the transaction identifiers, the commission breakdown, the broker-side and agent-side deductions, and the disbursement payee block — and gets structured rows back, with each row carrying a reference back to the source PDF and page for audit. The same description handles one CDA at the end of a closing day or a queue at month-end, which keeps the extraction step from becoming the bottleneck the rest of the workflow waits on.

That's the extraction step. The reconciled output it feeds into is what the rest of the workflow operates on: a closed transaction with a CDA marked reconciled, a wire matched to a transaction, an agent payout staged for the next pay cycle, and a brokerage retention figure ready for the GL entry the month-end rollup will compile.

Applying the Agent Split Tier

The brokerage retention from the three-way match is one half of the wire; the agent payout is the other. The split sheet is the operator's worksheet for that calculation. Before payout, it should answer these checks:

Cap status and rollover. If the transaction crosses the agent's annual company-dollar cap, apply the normal split only up to the remaining cap balance and the post-cap split to the rest, unless the agent's contract says otherwise. Cap-year convention matters: anniversary-date and calendar-year caps cannot be mixed.
Mentor split. Verify the covered deal count, whether the mentor split applies to gross commission or the agent's post-cap share, and whether the mentor is paid directly or through a chargeback against the mentee's net.
Team-lead split. Confirm whether the transaction qualifies under the team's policy, especially when the rule differs for buyer-side, team-sourced, self-sourced, or price-threshold deals.
New-agent tier. Check the agent's closed-transaction count or company-dollar threshold from the source of record. Cancelled deals and stale system status are common reasons the wrong tier gets applied.
Referral-fee withholding. If the brokerage pays a referral fee out on the CDA, apply the agent's share before calculating the agent's net, not after. Late referral agreements are a recurring source of overpayment when the split sheet was generated before the referral landed.
Other deductions. Apply the brokerage's policy for E&O contribution, transaction coordinator fee, broker administrative fee, franchise royalty pass-through, and outstanding chargebacks. The control point is whether the item belongs on the CDA, on the split sheet, or in both places with one side offsetting the other.

The operator's check

The agent's net payout reduces to a single calculation:

agent net = gross commission × side allocation × current split tier − agent-side deductions − withheld referral share − outstanding chargebacks

That figure, summed with the brokerage retention from the three-way match and any outbound disbursements, has to equal the brokerage's net wire from title. The two numbers exhaust the wire to the cent.

How the NAR Settlement Reshaped the CDA

The shift to written buyer agreements rearranged what shows up on the buyer-side of the CDA and added a fourth document to the buyer-side reconciliation. Following the NAR settlement practice changes effective August 17, 2024, MLS Participants working with buyers must obtain a written buyer agreement before touring a home, and the agreement must specify a compensation amount that is objectively ascertainable and not open-ended. Offers of compensation may no longer be communicated on the MLS.

For the operator, the consequence is structural rather than philosophical. Buyer-side compensation no longer flows from a unilateral MLS offer that the listing brokerage published and the buyer's brokerage relied on. It's now negotiated between the buyer and their broker in the buyer agreement, then communicated to the listing side as a concession on the listing-side commission, as a separate compensation line in the purchase contract, or as a buyer-paid amount that doesn't pass through closing at all. The CDA reflects whatever combination produced the buyer-side funding.

What changed on the document

The buyer-side line on the CDA is increasingly itemized as a separately negotiated figure rather than a percentage drawn from a published MLS offer. In practice, that line shows up in one of three configurations:

Seller concession. The listing-side commission funds the buyer-side compensation as a negotiated concession, and the CDA's buyer-side allocation is paid from the listing-side commission as before. From a reconciliation standpoint this looks closest to the pre-Settlement structure, but the underlying authority is the buyer agreement plus the purchase contract, not the MLS.
Buyer-paid through closing. The buyer pays the buyer-side broker compensation through closing as a credit on the settlement statement, and the CDA's buyer-side allocation is funded from that credit. The figure on the CDA must match the figure on the buyer agreement and the corresponding line on the ALTA.
Buyer-paid outside closing. The buyer pays the buyer-side broker directly outside the closing, the title wire carries no buyer-side compensation, and the brokerage receives the buyer compensation through a separate channel — a check from the buyer, an invoice paid by the buyer's employer in a relocation, a wire from a third party. The CDA's buyer-side allocation from title is zero, and the brokerage's reconciliation has to track the buyer-paid amount against the buyer agreement on a parallel ledger.

The reconciliation accommodates all three. What it can't do is assume the buyer-side line on the CDA equals a published MLS offer, because there's no MLS offer to consult.

The reconciliation keys, updated

The buyer agreement is now part of the document set the brokerage retains for every buyer-side closing. Its compensation figure has to tie to the buyer-side line on the CDA and to the corresponding compensation entry on the ALTA — the comparison runs across CDA, buyer agreement, and ALTA before the transaction's three-way match against the wire and the agent split sheet runs. A mismatch between any two of those three documents is a recurring exception in the post-Settlement period and has to be resolved before the transaction is closed.

When the buyer-side compensation flows outside title (the third configuration above), the reconciliation runs against the buyer agreement and the brokerage's separate-receipt ledger rather than the title wire. The three-way match still applies — CDA, money, agent split sheet — but the money is a check or a wire from the buyer rather than a wire from title, and the agent's split tier is applied to the buyer agreement's compensation figure rather than to the CDA's buyer-side allocation.

The shift added a buyer agreement to the document set on every buyer-side closing and made the funding source for buyer-side compensation a per-deal question rather than a default.

Recurring Exception Patterns and Discrepancy Resolution

Most CDAs reconcile cleanly. The ones that don't fall into a small number of recognizable shapes that recur across brokerages. The patterns below are the ones brokerage back offices see repeatedly, with the source of each mismatch and the usual resolution path.

Missing or incorrect E&O deduction. The CDA omits the brokerage's standard per-closing E&O contribution, or the contribution is at the wrong tier when the brokerage steps E&O by transaction price. The agent or transaction coordinator drafted the CDA from a template that didn't pick up the current rate, or the brokerage updated the rate mid-quarter and the new figure didn't propagate to every drafter. Resolution: corrected CDA from the broker before disbursement when the wire hasn't yet released, or post-close internal reclassification (debit the agent's payout, credit E&O recovery) when the wire already cleared at the wrong figure.

Wrong split tier applied. The CDA or the agent split sheet uses the prior cap-year split instead of the current one, or applies the pre-cap split on a transaction that crossed the cap mid-deal. Source: the back-office system didn't roll the agent's status forward at the cap-year boundary, or the rollover transaction wasn't pro-rated against remaining cap balance. Resolution: recalculate the agent's net at the correct tier and stage either a chargeback against the next pay cycle (when the agent was overpaid) or a supplemental payout (when the agent was underpaid).

Referral-fee under-withholding. A referral was paid by the brokerage on the CDA but the agent's split sheet didn't withhold the agent's share of the referral cost per brokerage policy. The referral fee was added to the CDA late — the receiving broker's referral agreement landed close to closing — and the split sheet was generated before the referral propagated. Resolution: reduce the agent's net payout by the agent's share of the referral, or treat the difference as a chargeback against the next deal if payout has already gone out.

Franchise royalty mis-applied. The royalty was deducted twice (once on the CDA at closing and again in the brokerage's internal split sheet) or wasn't deducted at all. Source: brokerage policy changed (a royalty rate adjustment, or a switch from CDA-level deduction to split-sheet-level deduction) and the CDA template, the split sheet template, or both didn't update. Resolution: reverse the duplicate deduction or apply the missing one, then reissue the agent's net.

Wires arriving without a CDA on file. Title wires the closing proceeds before the brokerage has uploaded or signed the CDA. In most cases this is a workflow gap rather than a fraud signal — the agent or transaction coordinator hasn't sent the CDA to the broker for signature, or the CDA was signed but never uploaded to the back-office. Resolution: hold the wire as unmatched cash receipts in the brokerage ledger until the CDA arrives, then run the three-way match retroactively. A persistent backlog of unmatched receipts is its own diagnostic — it means the upload-and-sign step in the closing workflow isn't running on the same cadence as title's funding.

CDAs closed in the period whose wires haven't cleared. The CDA is signed and the closing happened, but the wire is still in transit at month-end. Source: title's funding cycle, especially when the closing is late in the month and title funds on a T+2 basis. Resolution: book the brokerage net as a commission receivable in the month of closing and clear the receivable when the wire posts. The receivable list at month-end is one of the operator's standard exception outputs and feeds straight into the controller's review of the close.

Buyer-agreement-versus-CDA mismatch. Post-Settlement, the buyer agreement specifies a compensation figure that doesn't match the CDA's buyer-side line. The negotiated figure changed during the deal — a price reduction triggered a concession adjustment, or the buyer absorbed a portion of compensation the seller wouldn't concede — and the buyer agreement wasn't amended to reflect the final negotiated number. Resolution: amended buyer agreement or signed written confirmation that reconciles the figures, retained in the file before the transaction is closed in the ledger. Without that document the file isn't compliant with the post-Settlement record requirements, regardless of whether the math balances.

Side-door referral. The brokerage's net wire is short by exactly the referral amount because title paid the referral directly to the receiving broker rather than wiring the gross to the brokerage and having the brokerage cut the referral check. The CDA usually shows this correctly (the referral is in the disbursement block as a separate payee), but reconciliation systems that match wire-amount-to-CDA-gross flag it as a discrepancy. Resolution: configure the match to compare the wire to the brokerage's allocated portion of the CDA rather than to the gross commission, and verify the receiving broker's payment landed against the title disbursement record.

Month-End Rollup and the Commission GL Entry

The brokerage month-end commission close aggregates the period's reconciled CDAs into commission revenue, an agent payout register, and the exception lists that go into the controller's package. Clean per-transaction matches make this a rollup; skipped reconciliations turn it into a month-end investigation.

The aggregation

Three sums anchor the rollup, drawn from the period's reconciled transactions:

Brokerage retention (company dollar) summed across reconciled CDAs becomes commission revenue for the period. This is the figure that hits the income statement.
Agent payouts summed across reconciled CDAs become the agent payout register. This figure hits the balance sheet as an agent payout liability until the brokerage actually cuts the agent checks on the next pay cycle.
Outbound disbursements — referral fees out, franchise royalty when the brokerage cuts those checks rather than having title cut them at closing — sum to commission expense (or to a payable line for amounts owed but not yet paid).

Each sum is derived from CDAs that have cleared the three-way match in the period. CDAs that haven't cleared go into one of the exception lists below rather than into the rollup.

The bank cross-tie

The rollup has to tie to the brokerage's bank deposits, and the cross-tie is what catches the errors the per-transaction match missed.

Brokerage net wires received from title in the period, less wires received against prior-period closings (which were booked as commission receivable in the prior period and clear in this period), plus wires for current-period closings still in transit at month-end (commission receivable in this period), should equal commission revenue plus agent payouts plus outbound disbursements for the period.

When the cross-tie fails, the discrepancy is one of two things: a CDA that booked but whose money never arrived (a wire was lost, returned, or short-paid and no one reissued it), or a wire that posted to the bank but never matched a CDA (the unmatched-receipts list below). Either is recoverable, but neither stays hidden once the cross-tie runs.

The exception lists

The rollup produces three exception lists that travel with the close package:

Receivable list. CDAs that closed in the period whose wires hadn't cleared by month-end. Booked as commission receivable in the period of closing, cleared when the wire posts. Each row carries the title file number, closing date, gross commission, brokerage net expected, and the date the wire is expected.
Unmatched-receipts list. Wires that arrived in the period without a CDA on file. Held as unmatched cash receipts on the balance sheet, not booked as commission revenue until the CDA arrives and the three-way match runs retroactively. Persistent items here usually point to a workflow gap upstream rather than a reconciliation problem at month-end.
Discrepancy list. Transactions where the three-way match didn't balance and the resolution didn't complete in the period. Each row names the discrepancy pattern (from the catalogue in the prior section), the dollar amount in question, and the resolution path with a target close date.

The controller, broker-owner, or external accountant signing off on the close works from these three lists plus the rollup numbers. A close with a clean rollup and three short, well-explained exception lists is a defensible close; a close with a long unmatched-receipts list and no narrative on each item is the kind of close that gets reopened a month later.

The GL entry

The journal entry that books the period's commission activity has a consistent shape across brokerages, with the line names varying by chart of accounts:

Debit cash for the period's net wires received from title.
Debit commission receivable for current-period closings whose wires hadn't cleared by month-end (and credit it back when those wires post in a later period).
Credit commission revenue for the period's brokerage retention.
Credit agent payout liability for the period's agent payouts (which clears when the brokerage actually pays the agents, typically on a semi-monthly or weekly cycle).
Credit outbound disbursements payable for any unpaid referral fees out or franchise royalties owed at period end.

Brokerages that pay agents on a same-day basis from the closing wire collapse the agent payout liability step by debiting cash for the brokerage's portion only and recording the agent's portion as a pass-through, but the underlying pieces are the same.

The trust-account view

The CDA-to-wire-to-split match closes the brokerage's operating commission flow. State-compliance reconciliation runs on a parallel track — the monthly broker trust account three-way reconciliation compares the bank statement to the internal trust ledger to the sub-ledger sums on the same calendar, and both reconciliations have to clear before the books close.