This template is part of the broker commission reconciliation guide. Fill it after one conversation with the finance director, and mark anything you could not confirm as an estimate.
Template fields for a commission reconciliation brief
Copy the ten fields below into an email or document. Each entry should be one line a reader could check with the finance director.
| Field | What to write | Where the answer usually comes from |
|---|---|---|
| 1. Company | Brokerage type, full-time headcount at peak, country | Finance director or an org chart |
| 2. Task | The reconciliation work in one sentence | Finance director |
| 3. Record classes | Policy placements, insurer remittances, reversals, sales-staff clawbacks, a log of disagreements | Accounting manager |
| 4. Systems | Agency management system, accounting module, statement storage, dispute tracker, by type | System administrator |
| 5. Years matched | First and last year remittances were matched line by line | Finance director |
| 6. Volumes | Remittances a month, insurers paying direct, disagreements a year, as estimates | Accounting manager's month-end report |
| 7. Open question | The join or record you do not yet know exists | Your own conversation notes |
| 8. Access event | A documented conversion, license end or read-only date | Conversion plan or contract |
| 9. Owner and signer | Who holds the records and who can approve a discussion | The who-can-say-yes tree |
| 10. Not shared | What the brief deliberately leaves out | Always the same list |
Completed example: a brokerage mid-conversion (Illustrative)
The values below describe a fictional brokerage. They are Illustrative, not a real company, case or deal.
Subject: Commission reconciliation history before our system conversion (Illustrative)
- Company: commercial lines brokerage, about 140 full-time staff at peak, United States; acquired by a regional platform this spring.
- Task: reconciling carrier commission statements to placements and producer splits, including return commissions after mid-term cancellations.
- Record classes: placement records, direct bill statements with reconciliation status, return commissions, producer chargebacks, a dispute log.
- Systems: current agency management system with accounting module; statement PDFs on a shared drive; disputes in a spreadsheet and a finance inbox.
- Years matched: about eight years item by item; earlier years at statement total only (finance director's estimate).
- Volumes: roughly 90 carrier statements a month from about 30 carriers; dispute log depth unconfirmed.
- Open question: when a cancellation changed the commission after payment, is each return line matched to the original item and to the producer chargeback, and was the dispute outcome written down?
- Access event: conversion to the acquirer's system next quarter; old system read-only for 90 days afterwards.
- Owner and signer: records transferred to the acquirer at closing; the acquirer's CEO would decide, with its CFO and general counsel advising; the finance director is sponsor.
- Not shared: no statements, producer names, carrier names, exports or logins.
Notice that the example gives a statement count and a carrier count, not carrier names, and that field 5 separates item-level reconciliation from totals. Both are what a reviewer needs and neither exposes a record.
How to fill the open-question field
Field 7 is where a brief earns attention. It names the one thing that decides whether the history can be followed from a problem to an outcome. For commission work, the most useful open questions sit on three joins:
- Return line to original item. Does a negative commission on a later statement point back to the placement it reverses, or was it posted as an unmatched adjustment?
- Insurer reversal to salesperson clawback. Did the salesperson's pay statement pick up the same reversal, in the same period? If the accounting team corrected amounts by manual entry rather than at source, this link can break without anyone noticing.
- Remittance to its sign-off. Who approved each month's match, and is that approval stored with the record or in someone's email? Ask whether status history survives a system change.
Fields 5 and 6 matter just as much. Reconciliation tools are built around open items: AMS360 builds a statement of eligible uncleared transactions to compare with the carrier's statement, and Applied's training material describes a final-payment checkbox that removes an item from future reconciliations. So "years reconciled item by item" is a real, checkable fact about how the team worked, and a statement count says how much of that history exists without anyone opening a file.
Write the question, not the answer. "Unknown" is a valid entry; the system map explains how each join is usually stored.
What the finance director should strike before forwarding
Before the brief goes to the signer, ask the finance director to read it once and remove anything that identifies a counterparty or an individual.
| If the draft contains | Replace it with |
|---|---|
| A carrier's name | The number of carriers and the bill type |
| A producer's name or split | "Producer splits held per policy" |
| A disputed amount | The number of disputes a year |
| A screenshot of the reconciliation screen | The system type and module |
| A guess at value | Nothing |
For tone and disclosure of your referral relationship, use the warm introduction brief. Commission data is also examined in diligence, as described in MCP for quality of earnings, and the wider record category is on reconciliation exceptions.
Check eligibility before sending. For SourceX, an 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. Partners sign the Channel Partner Agreement first, and the first valid introduction within the 90-day window is credited when the company submits a verified application. Rights, buyer interest and any offer stay unknown until SourceX reviews the opportunity. The insurance industry page lists neighboring record types.
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.
When all ten fields are filled or marked unknown and the finance director has cleared the wording, register as a partner, confirm the brokerage on who qualifies and read the program terms before you send the brief.