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 operational discipline 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 discipline at that operator's level.

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. Section 4 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 discipline 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:

1. 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.
2. 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.
3. Closing date. A secondary key that pairs with property address or with the listing/selling agent identifiers.
4. 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.
5. 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 doesn't, the discrepancy lives in one of three places.

Discrepancy resolution

The wire is short of the CDA. Title disbursed less than the CDA instructed. Contact title for a corrected wire or supplemental disbursement, but before doing that check whether a referral fee on the CDA was paid directly by title to the receiving broker rather than wired to the brokerage. That's the most common false alarm: the brokerage's net is short by exactly the referral amount because the referral went out the side door at title and never passed through the brokerage's wire.

The wire matches the CDA but the agent split sheet doesn't tie. The three-way match fails on the agent side. Almost always the wrong split tier was applied (a cap rollover wasn't honored, or a new-agent tier wasn't stepped down at the right transaction count) or an agent-side deduction was mis-staged. Section 3 walks through the tier rules; the resolution here is to recalculate the agent's net and stage either a chargeback against the next pay cycle or a supplemental payout in this one.

The CDA matches the wire but no CDA was on file at receipt. A wire arrived for a closing the brokerage didn't authorize a CDA for. In most cases this is a workflow gap rather than a fraud signal — usually the agent or transaction coordinator hasn't sent the CDA to the broker for signature — but it's always a flag. The wire holds as unmatched cash receipts in the brokerage ledger until the CDA arrives, and the three-way match runs retroactively.

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. Calculating the agent payout is where most policy lives in writing and ambiguity lives in execution. The split sheet is the operator's worksheet for that calculation, and the rules below are what trip clerks up week after week.

Cap status and the rollover transaction

Most agent splits run on a cap model. The agent pays the brokerage a percentage of each commission until annual company dollar contributions reach a defined cap, then takes a higher split (often 100% net of fees) for the rest of the cap year. Cap years run from the agent's anniversary date or from January 1, depending on the brokerage; mixing those two conventions across an agent roster is its own source of error.

The transaction that crosses the cap mid-deal is the recurring trap. The standard policy is to take the brokerage's normal split up to the agent's remaining cap balance and apply the post-cap split to the rest of the same transaction, so a single CDA produces a partial pre-cap calculation and a partial post-cap calculation that have to land on the dollar. Brokerages handle this differently — some round to the nearest hundred, some apply the full pre-cap split and roll the cap forward, some prorate based on closing date — and the policy has to match the agent's contract, not the back-office system's default.

The mentor split

Agents under a mentor agreement pay a mentor split out of their commission, typically for a defined number of deals (often three to ten) or until a revenue threshold the mentor agreement specifies. The deduction shows on the agent's split sheet rather than the CDA in most brokerages, which means it doesn't appear when title funds and only surfaces when the operator runs the agent's net.

Three things to verify on every mentee transaction: which deal number the agent is on (if it's the mentor's last covered deal, the next one isn't), whether the mentor split applies to gross commission or to the agent's post-cap share, and what fraction the policy assigns. The mentor's payment also has to be staged — either as a payout from the brokerage to the mentor or as a chargeback against the mentee's net that the brokerage retains and then pays out separately.

The team-lead split

On a team, the team lead typically receives a split of every team member's commission, often only on buyer-side deals or only on leads sourced through the team's lead pipeline. The team's specific policy controls: some teams take a flat percentage on every commission, some take a higher percentage on team-sourced leads and zero on the agent's self-sourced leads, some take an override only on transactions above a price threshold.

Like the mentor split, the team-lead split lives on the agent's split sheet rather than the CDA. The operator has to know, for every transaction, whether the agent is on a team, whether this transaction qualifies under the team's policy, and what fraction the lead is owed. Disputes over team splits are among the most visible exceptions because they're paid agent-to-agent inside the brokerage's ledger.

New-agent tiers

Many brokerages run a graduated split for the first N transactions or first $X of company dollar, stepping the agent up to the standard split once they clear the threshold. The transition transaction has the same structure as the cap rollover: a portion at the new-agent tier, the rest at the standard tier, the calculation hitting the dollar.

The variable that breaks this most often is transaction count. New-agent tiers usually count closed transactions, but cancelled deals that were briefly under contract and then fell through don't always update the count consistently across systems, and a clerk pulling the agent's status from the wrong source can apply the wrong tier.

Referral-fee withholding on the agent side

When a referral fee out is paid by the brokerage on the CDA, the question is who absorbs it. Most brokerages share the cost with the agent on a defined basis — a 50/50 split, a prorated share, or a flat percentage off the agent's gross before the agent's split is calculated. The policy has to be applied before the agent's net is calculated, not after, because applying it after produces a different number whenever the brokerage's split percentage isn't 100%.

The recurring exception: a referral fee gets added to the CDA late (the receiving broker's referral agreement comes in close to closing), title pays the referral, and the agent's split sheet was generated before the referral landed. The agent's net comes out at the un-withheld figure and has to be corrected before payout.

Other agent-side deductions

The brokerage's policy decides which of these land on the CDA and which on the split sheet, but the operator has to apply each one on every relevant transaction:

• E&O contribution per closing. Often a flat figure ($25–$95 is typical) or stepped by sale price.
• Transaction coordinator fee. Whether this is borne by the agent, the brokerage, or split varies by office.
• Broker administrative fee. A per-closing or per-side flat fee in some brokerages.
• Franchise royalty pass-through. For franchised offices, the agent sometimes shares the royalty cost.
• Outstanding chargebacks. Refunded commissions on a cancelled or rescinded deal, or corrections from earlier transactions where the agent was overpaid, applied against the next payout.

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, and a clerk who can name the pattern can resolve it without re-deriving the cause from scratch. The list below is what week-after-week brokerage back-office CDA workflow surfaces, with the upstream source and the resolution path for each.

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.

The discipline of cataloging exceptions parallels what other commission-receiving operators face — the hotel OTA commission reconciliation as an adjacent statement-to-payout match shows the same exception-pattern shape applied to a hotel's payouts from booking platforms, with the same logic of naming the pattern, identifying the upstream source, and routing to a resolution. A brokerage building a stable exception catalog can borrow from the discipline rather than reinvent it.

Month-End Rollup and the Commission GL Entry

The brokerage month-end commission close aggregates the period's reconciled CDAs into a defensible commission revenue figure, an agent payout register, and the exception lists that go into the controller's package. The discipline at this level is straightforward when the per-transaction work has been clean, and it's where the cost of skipped reconciliations comes due when it hasn't.

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.

The year-end extension

Each agent's annual payout register is the basis for their 1099-NEC. Brokerages report agent commissions on 1099-NEC rather than on W-2 because agents are independent contractors, and the year-end filing is essentially a sum of the monthly agent payout registers across the calendar year, reconciled against the agent's own records when discrepancies surface. The cleaner the monthly registers, the cleaner the year-end filing — year-end 1099-NEC extraction for agent payout reporting is the next discipline downstream of the month-end commission close, and a brokerage that runs a tight CDA reconciliation through the year arrives at January with the 1099 data already in hand.