Commission statement tracking spreadsheet

Five ready-to-use tabs: your rate schedules, statements and lines, with discrepancies calculated automatically.

What it contains

  • Instructions

    What it can and cannot do.

  • Rate schedules

    Your rates by insurer and class.

  • Statements

    One per statement received, with a total check.

  • Lines

    One per entry, with automatic discrepancy and explanation.

  • Summary

    What each insurer owes you and how reliably it pays.

Why the total is not enough

The instructions include a worked example: three lines on a statement whose total matches to the cent. Yet CHF 191.08 is missing because one line was paid at 5% rather than the agreed 7%. Only a line-by-line check finds it.

What it cannot do

  • It cannot find the policy behind a line: Swiss statements do not include policy numbers. You must make the match.
  • It cannot calculate pro rata: a policy starting partway through the year does not earn a full year’s commission.
  • It does not learn: you will repeat the same work on the next statement.

These three limits take hours per statement. That is why most brokers check only the total.

The file stays with you: nothing you enter is sent to us.

Receive the spreadsheet