# Commissions and Production Reports in an Insurance Agency: Checking You Get What You Are Owed

> What a production report and a commission statement contain, how to match them to your policy list, which gaps recur every month, and a simple monthly routine.

- Published: 2026-10-25 · Updated: 2026-10-25
- Running an agency · 10 min read · The Financi team
- Canonical page: https://www.financi.co.il/en/articles/commissions-and-production-reports

## 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.

*Common terms in commission reporting. The binding definition is the one in your agreement with the insurer.*

| 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. |

## 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

1. **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.
2. **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.
3. **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.
4. **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.
5. **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.
6. **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.

*An example classification of gaps. Each insurer and product may behave differently.*

| 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. |

## 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**

- [ ] All reports and files from every insurer were collected by the set date, and anything missing was flagged.
- [ ] The data was copied into a unified table, with a policy number on every line.
- [ ] The active policy list was compared to the reports, and missing policies were flagged.
- [ ] A fixed sample of lines from each insurer was checked against the agreement.
- [ ] Every gap was classified and given an owner and a target date.
- [ ] Open requests from previous months were checked and updated.
- [ ] A short summary went to management: what was found, what was closed and what is still open.

## 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**

- [ ] Which commission types can be defined, and how do I set up a separate agreement per insurer and product?
- [ ] How are insurer reports loaded, in which formats, and what stays manual?
- [ ] How does the system flag a policy missing from the report, not just a line missing from the matching?
- [ ] Can I see income by insurer, product and employee, and who is allowed to see it?
- [ ] What happens to the data when a customer moves between employees or agencies?
- [ ] Can I export the data at any time, in a format I can open without the system?

## Frequently asked questions

### What is the difference between a production report and a commission statement?

A production report summarises what was recorded under the agency in the period, such as new business, changes and cancellations. A commission statement itemises what was actually paid. To check that you receive what you are owed, compare the two, and both against the agency's own policy list.

### How often should I match?

Once a month, close to when the reports arrive. More frequent matching lets you approach the insurer while the details are fresh, and usually shortens the work too.

### Can this be done in a spreadsheet?

Yes, especially in a small agency with a few insurers. A spreadsheet's weakness is that it is separate from customer and policy data, so the reference list can go stale. With several staff and several insurers, consider keeping the data next to the client record.

### What commission rate am I owed?

It is set in the agency's agreement with each insurer and for each product, and may change. This article shows no rates. Check your agreement, and if in doubt, ask the insurer in writing.

### What if the insurer disagrees that there is a gap?

Record the request, the insurer's reply and the relevant agreement, and check whether the agreement sets a procedure for resolving disputes. For a material dispute, consult a lawyer.

> **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 demo](https://www.financi.co.il/en#contact)

---

*The 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.*