It is part of insurance brokerage statement to reconciliation records. Use it after you know the agency's systems and before you decide whether to introduce its principal.
Scoring rules
- Score each check 2 for pass, 1 for partial and 0 for fail, out of 10.
- Record the accounting manager's own words beside each score.
- Where carriers or legacy agencies differ, score the weakest large part of the book and note the spread.
- Mark "don't know" as unknown and leave it out of the total. An unknown is a question for SourceX, not a fail.
The score describes the trail. It does not decide demand, rights or any offer, and partners never ask for statements, trackers or ledger extracts to fill it in.
Five checks for a commission trail
| Check | How to check it at metadata level | Pass (2) | Partial (1) | Fail (0) |
|---|---|---|---|---|
| Coverage | Ask since when the agency management system, the tracker and the ledger each hold commission history | All three cover the same three or more years | One system starts later, after a merger or migration | Only the agency system has history |
| Linkage | Ask which carriers send statements without policy numbers, and whether statements were associated with journal entries | Policy number on nearly every line; statements tied to ledger entries in the agency system | Most carriers print it; association used sometimes | Name-only statements common; no association |
| Timestamps | Ask whether the tracker keeps the statement date or the day a row was pasted | Statement, cancellation and posting dates all kept | Some dates are entry dates | Rows dated only by entry |
| Outcomes | Ask whether net commission per policy can be read from the ledger or the tracker | Net per policy derivable | Derivable only through the agency system | Ledger lump sums only, no tracker detail |
| Late-cancellation gaps | Ask what happens to a return commission when the original item is already closed | Reopened or referenced, with a note | Parked on an unmatched tab, cleared later | Posted to suspense with no trace |
Where the agency runs Applied Epic, two documented features decide how the linkage and late-cancellation checks come out:
- Statement status and association. A direct bill commission statement passes through Suspended, Finalized and Approved, and before approval it can be tied to a receipt, disbursement or journal entry already in the system. An agency that used that tie scores higher on linkage, because the ledger side is reachable without the spreadsheet.
- Final payment. Marking an item as finally paid removes it from later reconciliations, so nothing more can be applied to it. Any commission clawed back after that point must be parked somewhere, and the last check asks where.
Version: the check hidden inside timestamps
Add one follow-up under timestamps: could the agency open the tracker exactly as it stood at last March's close? Microsoft 365 keeps earlier versions only for files held in OneDrive or SharePoint, so a workbook overwritten monthly on a local or network drive holds nothing but its current state. An answer like "on a file server until 2019" scores partial; write down the year the workbooks moved.
A scored agency (Illustrative)
A fictional 230-person agency group, formed when two regional agencies merged, with one agency management system since 2014, trackers on SharePoint since 2019 and a new ERP since 2021.
| Check | Accounting manager's answer | Score |
|---|---|---|
| Coverage | Agency system since 2014; trackers since 2019; ERP since 2021 | Partial (1) |
| Linkage | Two regional carriers send name-only statements; others print policy numbers | Partial (1) |
| Timestamps | Statement date column kept; earlier tracker versions on SharePoint | Pass (2) |
| Outcomes | Net per policy readable from the agency system and the tracker, not the ledger | Partial (1) |
| Late-cancellation gaps | Return commissions parked on an unmatched tab, cleared monthly with a note | Partial (1) |
| Total | Sum of the five checks | 6 of 10 |
Illustrative. All answers are invented.
Stress test: a name-only clawback months after the original payment
Walk the accounting manager through this case and ask which of the five checks it would trip. The figures are fictional, and this case is different from the one on the record chain page: the carrier statement carries no policy number, and the insured holds two policies with the same carrier.
| When | Record | What happens | Checks it tests |
|---|---|---|---|
| March | Commercial auto policy, effective March 1 | Expected commission $7,200 set up in the agency system | Coverage |
| April | Regional carrier statement | $7,200 paid; the line shows the insured's name only; matched by hand | Linkage |
| April | ERP | One commission entry for the whole carrier statement | Outcomes |
| September | Cancellation effective September 30 | 7 of 12 months earned | Timestamps |
| November | Same carrier's statement | Return commission of $3,000, again name only | Linkage, late-cancellation gaps |
| November | Tracker | Matched by name to the insured's other policy, a general liability renewal | Late-cancellation gaps |
| November | ERP | A negative amount inside one carrier total | Outcomes |
The agency keeps $4,200 on the auto policy, and the totals still balance, so nothing looks wrong. The error is a wrong match, not a missing one: the general liability policy now shows a clawback it never had. An agency whose answer is "for name-only carriers we confirm the policy with the carrier before matching, and note it on the row" turns this from a hidden error into a labeled exception, the kind of record described under reconciliation exception data. How each system reads a trail on its own is in what an Epic-only export leaves out, and the field-by-field keys are in the record chain.
After the score: sponsor, rights and unknowns
The accounting manager answers the scorecard; the CEO, usually the agency principal in an owner-run agency, or the platform CEO in a private-equity-backed group, authorizes a licensing discussion. Confirm 50+ full-time employees at peak (contractors excluded), 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.
Unknown until SourceX reviews it: carrier agreement limits, de-identification of client and premium details, export formats and any offer. Fractional CFOs often run this kind of check already; see the fractional CFO for insurance agencies guide and the insurance agency M&A advisor page. More record locations are in the systems hub.
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 an agency can answer all five checks and explain where its late return commissions go, register as a partner, check it against who qualifies, and read the program terms before introducing its principal.