How to check whether your insurance provider paid you every commission you're owed

Commission is the only income for most insurance agents and brokers. Yet the vast majority treat it as a fact that lands in their account, not as a line item that needs verifying. The reason is understandable: provider statements are large, formatted differently by each provider, and often arrive in a form that isn't meant for quick review.

That's exactly where the problem lies. When there's no oversight, errors go unnoticed. And errors do happen — not because providers intentionally withhold payments, but because these are large systems where data about policies, premium payments, clawbacks, changes in coverage amounts, and portfolio transfers between agents all intersect.

With a portfolio of three hundred active policies, it only takes one percent of line items to go wrong for several hundred euros of unpaid commission to add up over a year.

Checking commissions isn't a sign of distrust. It's just as standard a business practice as checking an invoice or an expense statement. An agent who knows how much commission to expect and when can talk to their provider with facts, not feelings.

What systematic oversight gets you

• Reliable income. You catch missing payments in the month they happen, not a year later.
• Better planning. Once you know your expected commission for coming months, it's easier to plan tax obligations and investments in your business.
• A stronger negotiating position. Knowing your numbers makes it easier to negotiate terms of cooperation.
• Less stress. The uncertainty about whether a payment is correct disappears.

Before you start checking, it helps to know where discrepancies actually arise. In practice it's almost always one of the following situations.

1. The policy wasn't attributed to the right agent

The most common cause. When a policy is entered, the agent code gets mixed up, especially for policies sold at a branch office or through a colleague. The commission is paid, but to someone else, or it sits in a shared cost center.

2. The premium wasn't paid

Most providers only pay commission after the premium is paid. If a client pays late, the commission is delayed. That's not an error, but it is a reason not to write the policy off as lost.

3. Clawback on cancellation

When a policy is cancelled during the clawback period, the provider deducts the already-paid commission from the next statement. If you don't track this, a statement can look too low when it's actually a deduction tied to a different policy.

4. The wrong calculation basis

Commission can be calculated on gross premium, on premium net of insurance tax, or on the annual premium even though the client pays in installments. The difference between these bases can be more than ten percent.

5. The wrong commission rate

Rates vary by provider, product, and sometimes by policy duration or the insured's age. For a product you sell rarely, an error is most likely — and least noticeable.

6. Payment delay

Commission for a policy sold at the end of the month often only appears in the statement two months later. Anyone comparing policies sold with commission received in the same month will always see a "shortfall" that isn't real.

7. Renewals and additional commission

For life insurance and long-term property products, there's often a renewal commission in addition to the upfront commission. This is frequently paid on a different schedule and is the easiest thing to overlook.

Commission oversight isn't possible without three interconnected data sets. If one is missing, checking becomes guesswork.

First source: your list of sold policies

This is your portfolio — every policy you've sold, with the following data: policy number, provider, product, client name, sale date, coverage start date, premium, payment method, and duration. This list must be your own, independent of the provider, since it's the only basis against which you can check a statement.

Second source: provider statements

Every provider sends a commission statement, usually monthly. From it you need: policy number, payment date, calculation basis, rate applied, amount, and line item type (upfront commission, renewal commission, clawback).

Third source: payout rules

This is the written record of the agreement between you and the provider: which product is paid at which rate, on which basis, when it's paid, and how clawbacks are handled. Rules change over time, so it's important to also track the effective date of each version.

Rules without an effective date are a trap. If you change the rate today for a product you sold last year, your past figures will change on paper — and you'll lose comparability.

How to link the data

The link between sources is the policy number. In practice this is the weakest link, since the same policy is often recorded differently in your records and in the statement: with spaces, hyphens, leading zeros, or a provider prefix. That's why normalization is essential before every comparison: strip out any characters that aren't letters or numbers, and convert everything to a consistent case. Only then compare.

The process below is designed to be done in under half an hour a month once your data is set up.

1. Gather statements. Save all statements for the period in one place, ideally in an electronic format that can be read in a spreadsheet.
2. Normalize policy numbers. In your own list of policies and in the statements, create an extra column with the cleaned-up policy number.
3. Match line items. Link each statement line item to a policy in your portfolio. Handle unmatched items separately — these could be a colleague's policies, foreign codes, or mistyped numbers.
4. Calculate expected commission. For each policy, apply the rule that applied on the date of sale: basis multiplied by rate.
5. Compare and sort. Put each policy into one of these categories: paid correctly, underpaid, overpaid, not yet due, or clawed back.
6. Check for delay. Exclude policies sold in the last month or two from the "missing" category — payment isn't due yet for those.
7. Prepare a claim list. What's left is a short list of items with an actual difference. This is the basis for your conversation with the provider.

What counts as a discrepancy

Because of rounding, the calculation and the payment will almost never match to the cent. It makes sense to apply a tolerance of about EUR 0.50 per line item: ignore smaller differences, check larger ones. Without a tolerance, you'll be dealing with dozens of false discrepancies every month and will give up on the process.

The basic calculation is simple; the choice of basis and timing make it more complex.

Basic formula

Expected commission = basis × commission rate

The basis can be:

• annual premium – most common for life insurance and annual property policies,
• premium paid in the period – for installment payments, commission is calculated as you go,
• premium net of tax – for products where insurance premium tax is excluded from the basis,
• fixed amount – for some products, where commission is a set euro amount per policy sold.

Example calculation

Take a property policy with an annual premium of EUR 480, sold on March 12, with an agreed rate of 12% of the annual premium, paid in the second month after the sale.

• Expected commission: 480 × 0.12 = EUR 57.60
• Expected payment month: May
• If the May statement doesn't include a line item for this policy, that's a discrepancy worth checking.

Example with installment payments

The same policy, paid monthly at EUR 40, with commission based on the premium paid:

• Expected monthly commission: 40 × 0.12 = EUR 4.80
• Total over twelve months: EUR 57.60, but spread across the year.

The only difference is timing, but timing causes the most unnecessary claims. So always record the payment method in your own records too.

Renewal commission

For long-term policies, a lower renewal rate typically applies after the first year. If your contract specifies this, it must be recorded separately from the upfront commission, otherwise you'll compare the wrong numbers every year.

A claim that says "I think a commission is missing" will sit unanswered. A claim with concrete data gets handled, because the person reviewing it can check it directly in the system.

What it must include

• the policy number in the format used by the provider,
• the policyholder's name and sale date,
• the premium and payment method,
• the commission rate you're claiming, referencing the contract or rate schedule,
• your calculation of expected commission,
• the actual amount paid and the statement period,
• the difference in euros.

Message template

Dear [Provider], while reviewing the commission statement for May 2026, I found a discrepancy on policy no. 1234567890 (policyholder John Smith, sold 3/12/2026, annual premium EUR 480.00). At the agreed rate of 12%, the expected commission is EUR 57.60, but the statement shows EUR 43.20. The difference is EUR 14.40. Please clarify or correct this in the next statement.

When to file a claim

As soon as possible. Internal deadlines for correcting statements are limited, and some providers only allow retroactive corrections within the current business year. That makes monthly review sensible from a practical standpoint too.

What if you were overpaid

This happens too, and it's worth knowing about. Overpaid commission is sooner or later offset in later statements. If you expect this, the deduction won't catch you off guard when planning cash flow.

The examples below are illustrative: they're built from typical situations agents describe in practice, with simplified numbers for clarity. They are not descriptions of a specific client or provider.

Case 1: The wrong agent code on branch-office policies

Starting point. An agent with around 280 active policies noticed monthly commission dropping over the last quarter, even though the number of new sales stayed the same.

What the review found. Comparing the policy list against the statements showed that eleven policies sold at a branch office, with a colleague present, didn't appear on the statement at all. Commission for them had been paid, but attributed to the wrong agent code.

Process. For each policy, the agent prepared a row with the basis, rate applied, expected and paid amounts, and the difference. The claim was sent as one document, not eleven separate messages.

Outcome. The provider corrected the attribution and settled the difference in the next statement. More importantly, the agent introduced a rule to flag and check any policy sold outside their usual process within the first month.

Takeaway: the error wasn't in the rate, but in the fact that the policy wasn't on the statement at all. That's why a review can't be done by looking at the statement alone — you need your own policy list for comparison.

Case 2: A payment delay that looked like missing commission

Starting point. A broker found fifteen policies with no commission paid during a review and prepared an extensive claim.

What the review found. For twelve of the fifteen policies, the premium hadn't been paid within the statement period, or had been paid right at the end of the period. Commission was owed, but only in the next statement. Only three policies were actually disputed.

Process. She introduced a status distinction: *expected* (deadline not yet passed), *overdue* (deadline passed by more than a month), and *disputed* (payment differs from the calculation). She only filed a claim for the third group.

Outcome. The provider's response was faster because the claim was short and well-supported. The broker also stopped wasting time on items that would resolve themselves.

Takeaway: without distinguishing delay from error, oversight turns into unnecessary correspondence that weakens the credibility of future claims.

Checking in a spreadsheet is perfectly adequate as long as you have a relatively small portfolio and one or two providers. The point where this approach breaks down is, in practice, surprisingly low.

Signs you've outgrown a manual approach

• You work with more than three providers, each with a different statement format.
• Your portfolio exceeds two hundred active policies.
• You have products with different rates and different calculation bases.
• Matching increasingly turns up policies that don't line up because the number is recorded differently.
• You keep putting off checking because it takes more than an hour.

What automation gets you

A system that reads your data and statements can normalize, match, and calculate in seconds. Instead of a whole statement, you get just a list of items that don't line up. Your job becomes judgment — the part a computer can't do.

Commission Clarity is built exactly for this step. It reads your data directly from your Google Sheets, so your portfolio data stays with you, while the calculation is based on rules you set yourself — by provider, product, and effective date. The result is an overview where every policy is flagged as paid correctly, underpaid, not yet due, or clawed back.

Commission oversight isn't a one-off task, it's a habit. Once it becomes a monthly routine, the question "did I get everything I'm owed" simply stops coming up.

The first step you can take today

Take the latest statement from a single provider and compare it against your policy list. Not for the whole year — just for the last month. If you find even one discrepancy, the review paid off — and you'll have a good reason to repeat the process next month too.