Insurance commission record chain: the keys that carry a statement line from policy to journal entry

Short answer

An agency connects its statement-to-reconciliation records by mapping which field each system uses for the same thing. The policy number is the natural key from placement to statement line. The statement number bridges the agency system and the reconciliation tracker, and the journal entry number bridges the tracker and the ERP. Most chains hold until a cancellation lands on a later statement, because the ERP rarely carries the policy number and the first reconciliation is already closed.

Visual briefFull-size diagram
A vertical chain of five records, from policy placement through the statement, tracker and ERP journal to a later return line, clicks together link by link; the link between the June return commission and the February statement line is weak and dashed, then turns green when the policy number joins them.
Illustrative chain. The policy number repairs the weak link; the ERP never carries it.

This key map is part of the statement-to-reconciliation guide for insurance agencies, which sets out the metadata packet for the whole workflow. Here the only job is to name the key on every link and show where links give way.

The example is Illustrative: a fictional 160-person commercial agency using Applied Epic, a monthly spreadsheet tracker and an ERP. One direct bill liability policy is placed in January, its $5,400 commission is paid on the February statement, and it cancels mid-term, so a $3,825 return commission appears on the June statement.

StepRecordKey that carries the linkSystem
1. PlacementPolicy and expected commissionPolicy numberApplied Epic
2. Carrier paysCommission statement linePolicy number on the line, if the carrier prints itCarrier statement, loaded to Epic
3. Line matchedStatement closedStatement numberApplied Epic
4. Month trackedTracker row marked matchedStatement number typed per row; policy number if someone keeps a columnSpreadsheet
5. Month postedCommission journalJournal entry number, associated with the statement in EpicERP
6. CancellationCancellation on the policyPolicy numberApplied Epic
7. Money taken backReturn commission on a later statementPolicy number on the line, if printedCarrier statement
8. Debit postedNegative journal in a later monthJournal entry number onlyERP

Read down the key column. The policy number runs through steps 1, 2, 6 and 7. The ERP, at steps 5 and 8, carries only its own journal number. The tracker is the only place a person can tie the two together.

The three keys and what each one joins

Policy number. Joins the policy, its cancellation and every statement line about it, as long as the carrier prints it. Some carriers list only the insured's name, which turns a recorded join into a manual match.

Statement number. Joins a statement in Epic to the tracker sheet where it was matched. Applied documents that each statement carries a status, and that reopening a closed one also reopens others sharing its master statement number. That master number is itself a link worth noting.

Journal entry number. Joins Epic to the ledger. Applied's documentation says a statement that is not yet approved can be tied to an existing receipt or journal entry. If the agency used that association, the February journal traces back to the February statement inside Epic. If it did not, the only bridge is a journal number pasted into the tracker, when someone remembered.

Field map: one concept, three systems

ConceptApplied EpicTrackerERP
PolicyPolicy number on the policy and its transactionsPolicy number column, if keptUsually absent; revenue posted by carrier
Carrier statementStatement with a statusOne sheet per carrier per monthNot held
Matching stateStatement status"Matched", "unmatched" or a cell colorNot held
Ledger linkStatement associated with a receipt, disbursement or journal entryA pasted journal number, sometimesJournal entry number
AdjustmentCancellation on the policy; return line on a later statementA new row on a later sheetA negative entry in a later month

Illustrative. Field names describe the example, not a tested export.

Five breaks explain most incomplete chains:

  1. Statement lines without policy numbers. The join from statement to policy depends on name matching for those carriers.
  2. The item closed for good. Applied's training material describes a final-payment checkbox that excludes an item from future reconciliations so no more payments can be applied to it. A return commission that arrives after that has nowhere to land, and is often posted to suspense or an "unmatched" tab.
  3. Lump-sum journals. If the ERP posts one commission entry per carrier per month, no ledger line points to a policy.
  4. A tracker without a policy column. The tracker then joins statements to journals but not to policies, so the cancellation link runs only through Epic.
  5. Overwritten workbooks. Microsoft documents that version history works only for files stored in OneDrive or SharePoint. A tracker saved over each month on a local drive keeps only its latest state, so earlier months' matching decisions are gone.

In the example, the June return commission of $3,825 against the February payment of $5,400 is the weak link. It reconnects only through the policy number on both statement lines, read in Epic. That is common, and fine to say in an introduction. What the same trail looks like with each system read on its own is in what an Epic-only export leaves out; the pass, partial or fail version is the completeness checklist.

Who can confirm the keys and who can authorize

The accounting manager can say which keys exist and since when. The CEO, usually the agency principal in an owner-run agency, can authorize a licensing discussion; the CFO, or the platform CFO in a private-equity-backed group, often sponsors it. Commission records reveal carrier relationships and client premiums, so the decision sits at that level.

Before introducing, 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: what carrier agreements permit, how client details would be de-identified, which export fields exist and any offer. Partners never ask for or handle statements, workbooks or ledger exports. This page names Applied Epic only because its documentation is public; it does not imply a SourceX connector. Related: Applied Epic agency histories, general ledger reconciliation records, who owns agency management system data and 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 say which carriers print policy numbers and whether its statements were associated with journal entries, register as a partner, check it against who qualifies, and introduce its principal under the program terms.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

What if the agency does not use Applied Epic?

The chain has the same shape in any agency management system. Ask which field holds the policy number on statement lines, whether statements can be tied to ledger entries, and where open differences are tracked.

Can a partner map these keys without seeing statements?

Yes. The accounting manager can say which carriers include policy numbers, whether the tracker has a policy column and what reference the ERP journal carries. Amounts and client names stay with the agency.

Sources

  1. help.appliedsystems.com/Help/Epic/2023.2en-US/General_Ledger/Reconci…
  2. appliedsystems.com/DOC_CENTRAL/TR-TRAINING/RECONCILINGOFAGENCYO…
  3. support.microsoft.com/en-us/office/collab-files/view-previous-vers…
  4. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment