The short version
- An agency's commission is set by its agreement with each insurer and for each product, so the only way to check it is to compare what should arrive with what did.
- A production report says what was recorded under the agency; a commission statement says what was paid. A gap between the two is the first sign of a problem.
- Most gaps repeat: cancellations and offsets, a policy moved to another agent, a wrong rate, a policy missing from the report, and timing lag.
- A short, fixed monthly routine with one owner finds gaps while the insurer can still be asked to fix them, not six months later.
- A spreadsheet is enough at the start. With several insurers and several staff, the matching belongs next to the client and policy record rather than in a separate file.
In many agencies commission income is the number everyone can read and almost nobody checks. The money lands in the account, the insurer sends a statement, and accounting closes the month. But the statement shows what the insurer chose to pay, not necessarily what the agency is owed. To know whether there is a gap you must know in advance what should arrive, and compare. This article shows how to do that in an orderly way without overcomplicating it: terms, the structure of a report, matching steps, common gaps and a monthly routine.
Before you start
Commission rates, payment terms and offset rules are set in each agency's agreement with each insurer and by the regulations that apply to the product, and they change over time. This article shows no rates or amounts, and it does not replace reading your agreement or taking professional advice.
Why check at all: the report is the insurer's point of view#
A statement from an insurer summarises what the insurer's system recorded. If a policy was recorded under another agent, a rate was set wrongly, or a deal was not captured on time, the report simply leaves it out, and nothing in it signals that something is missing. A real check starts on your side: the list of policies the agency holds, and the commission each should produce under the agreement.
There is also a management reason. An agency that sees commissions only as a monthly total does not know which product, insurer or employee produces income, and cannot decide where time is worth spending. Orderly matching produces an important by-product: a picture of income by insurer, product and employee.
Terms worth defining across the team#
Misunderstood terms cause as many gaps as the reports do. Everyone in the agency should use the same definitions, written from the agreement rather than from memory. The table summarises common terms. Exact names and meanings can differ between insurers and products.
| Term | What it usually means | What to confirm |
|---|---|---|
| Up-front (volume) commission | A commission paid after a sale or enrolment, usually as a share of the product sold. | For which product, at what stage it is paid, and when it may come back if the policy is cancelled. |
| Trail (ongoing) commission | A recurring commission paid over time while the customer stays in the product. | What it is calculated on, how often, and what happens after a transfer or cancellation. |
| Production report | A list of what was recorded under the agency in the period: new business, changes and cancellations. | Whether it includes every policy you expect, and in which format it arrives. |
| Commission statement | A breakdown of what the insurer actually paid, by policy or by commission type. | Whether each line can be matched to a specific policy. |
| Offset or clawback | A deduction from a future payment because of a cancellation, a correction or an earlier error. | On which policy and in which month it arose, and whether it matches the agreement. |
| Agent transfer | A customer or policy moving from one agent to another. | From when the commission moves, and what is owed for the period before the move. |
- Up-front (volume) commission
What it usually means
A commission paid after a sale or enrolment, usually as a share of the product sold.
What to confirm
For which product, at what stage it is paid, and when it may come back if the policy is cancelled.
- Trail (ongoing) commission
What it usually means
A recurring commission paid over time while the customer stays in the product.
What to confirm
What it is calculated on, how often, and what happens after a transfer or cancellation.
- Production report
What it usually means
A list of what was recorded under the agency in the period: new business, changes and cancellations.
What to confirm
Whether it includes every policy you expect, and in which format it arrives.
- Commission statement
What it usually means
A breakdown of what the insurer actually paid, by policy or by commission type.
What to confirm
Whether each line can be matched to a specific policy.
- Offset or clawback
What it usually means
A deduction from a future payment because of a cancellation, a correction or an earlier error.
What to confirm
On which policy and in which month it arose, and whether it matches the agreement.
- Agent transfer
What it usually means
A customer or policy moving from one agent to another.
What to confirm
From when the commission moves, and what is owed for the period before the move.
What each report contains and what it leaves out#
A production report and a commission file usually come from the same insurer but answer different questions. The first answers what was recorded, the second what was paid. To match them you need a shared key: a policy number, a customer number or an ID number, depending on what the insurer provides. If the report has no such key, matching is manual and slow, and it is worth asking the insurer for a format that includes one.
- Format: some insurers send a spreadsheet, some a document, some offer a download from a portal. A different format per insurer is the usual reason matching slips from month to month.
- Period: confirm whether the report refers to the payment period or the recording period. A one-month shift between them creates false gaps.
- Level of detail: a summary report gives a total per insurer, a detailed one gives a line per policy. Only the second allows real matching.
- Missing fields: the customer name, product type or commission rate are not always present. What the report lacks must come from the agency's own records.
A simple request that saves hours
Ask each insurer for a detailed report by policy, in the same format every month, with a clear policy number. Consistency of format matters more than any tool you use afterwards.
How to match: six steps#
Collect the reports on a fixed date
Set a day each month when all reports and files are gathered into one folder, and name who is responsible. A report that did not arrive is already the first gap, and worth recording.
Unify them into one format
Copy the data into a table with the same columns for every insurer: policy number, customer, product, commission type, amount and period. This is where most of the effort goes, so fix the columns once and do not keep changing them.
Compare against the agency's policy list
For each active policy that should produce a commission, check whether a matching line exists. Direction matters: start from your list, not from the report, because that is how missing policies are found.
Check each line against the agreement
For lines that were found, check that the commission type and amount are plausible under the agreement. You do not have to recalculate everything: pick a fixed sample of lines from each insurer every month.
Flag and classify the gaps
Give each gap a likely cause: missing from the report, different rate, offset, agent transfer, delay. The classification shows whether a problem is one-off or a recurring pattern.
Raise it with the insurer and follow to closure
Each gap becomes a request with the policy details and the period, and you note when it was sent and what the answer was. A gap that is not closed moves to next month; it does not disappear.
Gaps that recur in almost every agency#
You do not need an elaborate list. Most gaps fall into a few fixed categories, and knowing them shortens the time it takes to find a cause. The table below is a starting point for a team conversation, not an exhaustive list.
| Type of gap | Possible cause | What to do |
|---|---|---|
| Policy missing from the report | The deal was not captured, was recorded under another agent, or appears in another period's report. | Check period and attribution, and if needed ask the insurer with the policy details. |
| Amount differs from expected | A rate other than the one in the agreement, a product classified differently, or a change in the policy terms. | Compare to the agreement and ask for a written explanation of the calculation. |
| Offset | A cancelled policy or a correction to an earlier payment. | Find the original policy and check that the offset matches the agreement. |
| Agent transfer | The customer moved to another agent or came back to you. | Check the transfer date and the commission for the periods before and after. |
| Late payment | A time difference between recording and payment. | Mark it as an open gap and check next month, without concluding at once that it is an error. |
- Policy missing from the report
Possible cause
The deal was not captured, was recorded under another agent, or appears in another period's report.
What to do
Check period and attribution, and if needed ask the insurer with the policy details.
- Amount differs from expected
Possible cause
A rate other than the one in the agreement, a product classified differently, or a change in the policy terms.
What to do
Compare to the agreement and ask for a written explanation of the calculation.
- Offset
Possible cause
A cancelled policy or a correction to an earlier payment.
What to do
Find the original policy and check that the offset matches the agreement.
- Agent transfer
Possible cause
The customer moved to another agent or came back to you.
What to do
Check the transfer date and the commission for the periods before and after.
- Late payment
Possible cause
A time difference between recording and payment.
What to do
Mark it as an open gap and check next month, without concluding at once that it is an error.
A short monthly routine you can sustain#
Matching only works if it happens every month. An excellent tool used once a quarter gives less than a plain table updated on time. So define a small routine, with one owner and one backup.
Monthly matching routine
0 of 7 checked
What to measure#
You do not need a dashboard with twenty metrics. A few simple, well-defined numbers measured the same way every month are enough. They show whether the process works, not just how much money came in.
- Share of matched lines: how many report lines were successfully tied to a specific policy. A drop points to a problem with the format or the key.
- Open gaps per insurer: shows which insurer the work is piling up against.
- Age of the oldest gap: a gap open for many months is harder to fix, and some insurers limit the period in which you can raise it. Check your agreement.
- Income by insurer, product and employee: the most valuable output of matching, and the basis for decisions about sales effort.
Spreadsheet or system: when to move#
A separate spreadsheet
- Quick to start, no cost and no rollout.
- Fits a few insurers, a few hundred policies and one person doing the work.
- The file lives on its own: anyone who updates a customer or policy elsewhere creates a gap between the lists.
- Commission is hard to see next to the client record, so questions like who is this customer and what do they produce take a search.
Commission tracking next to the client record
- Policies, customers and commissions live in one place, so the reference list does not go stale.
- Fits a team where several people touch policies and need to see them the same way.
- Permissions can be set so only those who need it see income data.
- In a demo, ask which files can be uploaded and what is automatic versus manual, rather than assuming.
In Financi, commission tracking is part of the agency's CRM, alongside leads, customers, policies, processes and role-based permissions. For the exact details of what can be uploaded and matched, it is best to see it in a demo on your own data and insurers.
Mistakes to avoid#
- Assuming the report is right. The report reflects the insurer's records. Without an independent list there is nothing to compare it with.
- Checking only the total. A total that looks reasonable can hide a missing policy and a policy paid more than expected.
- Waiting until year end. The older the gap, the harder it is to document and raise.
- No owner. When responsibility is shared between several people, each assumes someone else is checking.
- Changing definitions midway. Changing columns or the table structure without a note breaks comparison with earlier months.
Questions to ask a vendor before deciding#
If you are evaluating a system that manages commissions
0 of 6 checked
Frequently asked questions
Want to see commissions and policies on the same client card?
Book a demo and we will show what commission tracking looks like in the CRM, including what Financi does automatically and what stays manual.
Book a demoThe information in this article is general only and is not financial, pension, legal or tax advice, nor a substitute for personal advice. Demos and calculators are illustrative models: your numbers will differ.
