# Brokerage statement to reconciliation records | SourceX

Canonical: https://refer.sourcex.si/guides/chain-brokerage-statement-to-reconciliation
Last updated: 2026-11-04

A referral partner can describe an insurance brokerage's statement-to-reconciliation history from metadata alone: which system records the placement and expected commission, how insurer statements arrive and where they are reconciled, whether a spreadsheet sits between the agency system and the ledger, how far back each goes, which identifier links a statement line to a policy, and who owns each step. Nobody opens a statement. The case to test is a cancellation that shows up on a later statement than the original commission.

## The business task: agreeing what the insurer owes

A brokerage places a policy and expects a commission. The insurer reports what it actually pays on a statement, often weeks later and sometimes with differences: a changed premium, a mid-term endorsement, a cancellation. Someone in accounting compares expected with paid, chases the differences and books an adjustment. Each accepted adjustment is a recorded judgment about which side was right and why.

In a typical mid-size agency the steps are split three ways. The agency management system, such as Applied Epic, holds the policy, the expected commission and the direct bill statements. In Epic, a direct bill commission statement moves through Suspended, Finalized and Approved statuses, and a suspended or finalized statement can be associated with an existing receipt, disbursement or journal entry. An Excel workbook often tracks the month's open differences. The ERP or general ledger holds the consolidated entries, especially after an acquisition brings several agencies together.

## What metadata can a referral partner collect about brokerage-statement-to-reconciliation without reading private content?

Use five dimensions: what, how much, how long, which system, who owns it. An insurance accountant or fractional CFO can fill these in from the reconciliation routine they already know. The values below are Illustrative, for a fictional 220-person commercial lines brokerage.

| Dimension | Applied Epic | Excel reconciliation workbook | ERP |
|---|---|---|---|
| What | Policies, direct bill statements, cancellations, endorsements | Monthly tracker of open differences by carrier | Commission journals and month-end entries |
| How much | About 9,000 active commercial policies; roughly 4,000 statement lines a month at peak | One workbook a month, about 30 carrier tabs | One consolidated ledger for three legacy agencies |
| How long | Since 2014 | On SharePoint since 2019, a file server before that | Since 2020, after a merger |
| Link to the next step | Policy number on statement lines: most carriers, not all | Statement number typed per row | Journal reference to the Epic statement |
| Who owns it | Accounting manager | Accounting manager | Controller or fractional CFO |

Add two flags beside the table. First, does every carrier put a policy number on its statement lines, or do some only give an insured name? Second, do last year's monthly workbooks still exist, and where? Those two answers decide most of the joined history's usable range. Microsoft's documentation notes that version history in Microsoft 365 works only for files stored in OneDrive or SharePoint, so a workbook kept on a file server before 2019 may survive only as its last saved state.

Write counts as the client gives them and mark guesses as guesses. Amounts never go in the packet. For the system itself, see [Applied Epic agency histories](/systems/applied-epic-data-export) and [who owns agency management system data](/systems/agency-management-system-data-ownership).

## When a cancellation lands on a later statement

This is the case the packet should be able to describe. It is Illustrative and matches the graphic above.

A commercial package policy pays a $5,400 commission on the February insurer statement. The accounting team matches it, finalizes the statement and closes the month. The policy cancels on April 30. The insurer takes back $3,825 of unearned commission on the June statement, as a single debit line. Nothing on that line points back to February, so the brokerage kept $1,575 net, and the only way to see that is to join two statements four months apart through the policy number.

If the policy number is on both lines, the join is easy. If one carrier reports the debit under the insured's name only, someone has to match it by hand, and whether they recorded that match is a fact worth one line in the packet: "late cancellations matched manually in the workbook, notes kept since 2021" or "not tracked". The partner records the habit, not the amounts.

Fractional CFOs often see this pattern first, which is why the [fractional CFO for insurance agencies guide](/guides/fractional-cfo-for-insurance-agencies) is a useful companion.

## Who can authorize a licensing discussion, and what stays unknown?

Commission records reveal carrier relationships and client premiums, so the decision sits with the CEO, usually the agency principal in an owner-run agency; the CFO, or in a private-equity-backed platform the platform CFO, often sponsors the introduction. An accounting manager can describe the records but cannot authorize licensing them.

Before introducing, confirm:

- 50+ full-time employees at peak, contractors excluded, and a documented operating history.
- Rights to license: carrier agency agreements and client confidentiality terms may limit reuse; note them for SourceX's review rather than judging them.
- A named decision-maker who will take a first call.
- 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 never ask for or handle statements, workbooks or ledger exports. What stays unknown until SourceX reviews it: whether client and carrier details can be de-identified to a buyer's standard, which years a buyer would want, what carrier contracts permit, and what the agency would be paid. The [insurance operations screening worksheet](/resources/a-referral-screening-worksheet-for-insurance-operations-businesses) covers wider fit, [selling an insurance agency](/guides/selling-an-insurance-agency) covers timing around a sale, and the [systems hub](/systems) lists other record locations.

## Go deeper on brokerage-statement-to-reconciliation records

- [How placement, statement and ledger records link](/guides/brokerage-statement-to-reconciliation-record-linkage): a record-chain table of each step, its record, its key and its system.
- [Brokerage-statement-to-reconciliation completeness checklist](/resources/brokerage-statement-to-reconciliation-completeness-checklist): a pass, partial or fail scorecard for judging whether the records are complete enough to discuss.
- [What an Epic-only export of a commission leaves out](/guides/brokerage-statement-to-reconciliation-missing-context): one Illustrative policy read before and after its surrounding context is added.

## 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 agency can say since when its statement lines carry policy numbers and its monthly workbooks survive, [register as a partner](/register), check it against [who qualifies](/who-qualifies), and introduce the principal under the [program terms](/terms).

## Sources

- https://refer.sourcex.si/terms
- https://help.appliedsystems.com/Help/Epic/2023.2en-US/General_Ledger/Reconciliations/Recs_Associate_GL_Item.htm
- https://support.microsoft.com/en-us/office/collab-files/view-previous-versions-of-office-files
