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.