# Broker commission reconciliation system map | SourceX

Canonical: https://refer.sourcex.si/guides/broker-commission-reconciliation-records-across-systems
Last updated: 2026-11-04

Following one commission case across a brokerage's software takes five identifiers: the policy number with its term, the carrier's sheet and line number, the internal item ID assigned when lines are matched, the producer code, and the journal reference in the ledger. The dispute trail, where arguments about the case live, has no system key at all. When every identifier is carried forward, a reversal can be walked back to the policy it undoes; when one is dropped, it reads as a stray negative number.

This map is part of the [broker commission reconciliation guide](/guides/workflow-broker-commission-reconciliation), which covers what to inventory before an acquisition. The [worked hard case](/guides/broker-commission-reconciliation-exception-examples) tells one cancellation as a story; this page is the wiring diagram underneath it: nodes, keys, owners and the places where keys get lost.

## Five nodes, one ring of identifiers

Think of the brokerage's records as five nodes joined by identifiers. Each node answers one question about a case, and each identifier is a foreign key that lets you step to the next node. None of the nodes tells the whole story alone.

**Broker management system: what was bound.** The policy record and the matched item. Its key out is the policy number with its term dates, and an internal item or transaction ID once matching is done.

**Carrier paperwork: what the insurer said it paid.** Line by line, in the carrier's numbering. Often downloaded from carrier portals and filed as PDFs or spreadsheets on a shared drive, apart from the brokerage's own matched version. Its key out is a sheet number and line number.

**Producer pay: who got credited.** Splits and clawbacks, keyed by a producer code. Sometimes calculated inside the broker management system, sometimes in a payroll tool or a workbook.

**Ledger: how it was booked.** Income, reversals and corrections, keyed by a journal reference. Whether the memo field carries an item or sheet number decides whether the ledger can be walked back.

**Dispute trail: why anyone argued.** Email threads, a tracker or notes on the item. It has no system key at all, only whatever a person typed into the subject or body. It is the most informative node and the least structured.

## System map: record, linking key and owner

Read across a row to see what each system holds, which key leaves it and where that key lands.

| System | Record | Linking key | Points to | Owner |
|---|---|---|---|---|
| Broker management system | Placement | Policy number and effective date | Carrier statement line | Account management |
| Carrier statements | Commission or return line | Statement number and line, plus policy number | Reconciled item | Accounting team |
| Broker management system | Reconciled item and status | Item or transaction ID | Producer statement; ledger posting | Accounting team |
| Producer compensation | Split or chargeback | Producer code plus item ID or policy number | Original placement | Finance director |
| General ledger or ERP | Posting or adjustment | Journal reference with statement or item number | Reconciled item | Controller or finance director |
| Dispute log | Query, argument, decision | Policy number or item ID typed into the thread | Item and producer statement | Finance director |

Two keys are typed by people: the item reference in a ledger memo and the policy number in a dispute email. Those break first. Ask about them before anything else.

## One fully joined case (Illustrative)

Illustrative and invented for this page. A fictional 150-person commercial lines brokerage; a general liability policy cancels mid-term and the carrier returns part of the commission. Here is the case when every key holds.

| Key | Illustrative value | Held in | Joins |
|---|---|---|---|
| Policy number and term | GL-55210, Mar 1 term | Placement; both carrier statements | Placement to original and return statement lines |
| Statement and line | April statement line 14; August statement line 9 | Carrier statement PDFs | Carrier lines to the reconciled item |
| Item ID | Item 88413, reopened for the return | Broker management system | Item to producer chargeback and ledger posting |
| Producer code | P-117 | Producer statement, with item 88413 | Chargeback to original split |
| Journal reference | JE-2291, memo cites August line 9 and item 88413 | General ledger | Adjustment to the reconciliation |
| Dispute thread | Subject line cites GL-55210 | Finance mailbox | Producer's challenge and finance director's decision |

Top to bottom, the chain says: this placement was paid in April, part of it was returned in August, the same item was reopened rather than duplicated, the producer's chargeback names that item, the ledger adjustment cites the statement line, and the dispute about it names the policy. That is a complete case.

## Where the joins break

Each link has a typical failure. Knowing them lets a partner ask the right question in one sentence.

Reconciliation logic differs by product, which changes where each break shows up. In AMS360, a statement is built from eligible uncleared transactions and compared with the carrier's, and company totals should match agency totals before posting. In Applied Epic, a direct bill commission statement moves through statuses such as Suspended, Finalized and Approved, and can be associated with a receipt, disbursement or journal entry.

1. **Renewals and rewrites.** Carriers sometimes reissue policy numbers at renewal or rewrite, so the policy number alone may not distinguish terms. Ask: "How are renewals keyed: same number with a new term, or a new number?"
2. **Closed items and late returns.** Applied's training documentation describes a final-payment checkbox that removes an item from future reconciliations. When a return arrives after that, ask: "Do you reopen the original item, or book a separate line with no link back?"
3. **Reopened statements.** Applied Epic notes that reopening a finalized statement reopens others sharing the same master statement number. Ask whether the team avoids reopening and books corrections elsewhere instead, which breaks the trail.
4. **Chargebacks outside the system.** Ask: "Are chargebacks calculated in the system or a spreadsheet, and does each one name the original policy or item?"
5. **Ledger memos.** Ask: "Do adjustments carry a statement or item reference, or only free-text memos?" The [general ledger reconciliation page](/resources/mcp/mcp-general-ledger-reconciliation) covers the ledger side in more depth.
6. **Disputes in email.** Ask: "Do dispute threads name the policy or item, and are those mailboxes kept?"

Export capability varies by system, version and contract. Do not assume any export exists; the company should confirm with its own administrators what history each system can produce.

## What to note, and what stays unknown

Write one line per key: holds, partly holds, or does not hold, with years and rough volume. For example: "Return commissions matched to reopened items since 2018; chargebacks in a spreadsheet citing policy numbers; disputes in the finance mailbox." Never collect statements, producer names, client names or system access. Exception handling records of this kind are described more generally in [exception handling data for AI agents](/guides/exception-handling-ai-agents-data). If the brokerage already works with an M&A broker, [referral fee if a company already has a broker](/questions/referral-fee-if-company-already-has-broker) explains how that interacts with an introduction.

The introduced company needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English. Who can authorize the discussion is set out on [who can license broker commission reconciliation records](/questions/who-can-license-broker-commission-reconciliation-records). Whether carrier agency agreements allow licensing, what de-identification is needed and whether there is buyer interest stay unknown until SourceX reviews it.

## Next step

> **Refer a company. No cap on rewards.** Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If the finance director can confirm that most of the five keys hold across the brokerage's systems, [register as a partner](/register), check the company against [who qualifies](/who-qualifies) and read the [program terms](/terms) before you introduce them.

## Sources

- https://help.vertafore.com/ams360/content/contextsensitive/company/csdbstmtprocessing.htm
- https://help.appliedsystems.com/Help/Epic/2023.2en-US/General_Ledger/Reconciliations/Recs_Associate_GL_Item.htm
- https://www.appliedsystems.com/DOC_CENTRAL/TR-TRAINING/RECONCILINGOFAGENCYORDIRECTBILLITEMS.HTM
- https://refer.sourcex.si/terms
