Commission Clarity logo
    Commission Clarity

    Example scenarios: what commission checking actually finds

    Five concrete situations insurance advisors and small agencies recognise, and what Commission Clarity shows in each one. Every scenario can be reproduced in the free demo on sample data.

    These are illustrative scenarios, not customer testimonials. No provider is named and no figures are presented as results a specific user achieved — each example describes what the app calculates and displays, which you can verify yourself in the demo.

    Scenario 1

    Three policies that were sold but never paid

    Self-employed advisor, around 180 active policies, records kept in Google Sheets

    The situation

    Commission arrives monthly as a single transfer with a statement attached. The total always looks plausible, so individual lines are never compared with the policies that were sold.

    What the app shows

    • Every policy gets an expected commission for its current policy year, calculated from the advisor's own rules.
    • Safe Mode lists policies with no matching paid line at all — including three that were signed but never issued by the provider.
    • Each line shows the expected amount, the amount actually paid and the difference, so a query can be raised with a reference rather than a suspicion.

    What changes

    The advisor has a short list of specific policy numbers to ask about, instead of a feeling that something is missing.

    Open Safe Mode in the demo

    Scenario 2

    A clawback deducted twice

    Advisor with a mixed life and property book

    The situation

    A client cancelled in the third month, so the first-year commission was reclaimed. The deduction appeared on two consecutive statements.

    What the app shows

    • Cancelled policies are held against what was actually paid, not only against what is currently active.
    • The second deduction shows up as a negative difference on a policy that has already been settled.
    • Unmatched Commissions collects any payment or deduction that cannot be placed against a policy in the records.

    What changes

    Deductions get the same scrutiny as payments, which rarely happens when statements are only checked at the total.

    Open Unmatched Commissions

    Scenario 3

    Renewal commission that quietly stopped

    Advisor five years into a book, with a growing share of income from renewals

    The situation

    Renewal commission is small per policy and easy to overlook. When it stops for a handful of policies, the monthly total barely changes.

    What the app shows

    • Realization compares expected against paid commission by month and by provider, so a downward drift becomes visible as a pattern.
    • Policies in their renewal years are calculated with their own rate, not with the first-year rate.
    • The provider breakdown shows whether the gap is one provider or the whole book.

    What changes

    A gradual loss that no single statement would reveal becomes a chart with a specific month where it started.

    Open Realization

    Scenario 4

    An agency settlement that took an hour instead of an afternoon

    Three-advisor agency with different splits per product

    The situation

    Each month the agency owner rebuilt a spreadsheet to work out what each advisor was owed, applying a different percentage per commission rule and a mentor share for one advisor.

    What the app shows

    • Splits are defined per commission rule, with advisor, mentor and agency shares that must add up to 100%.
    • The agency view shows the whole team or one selected advisor, while each advisor sees only their own book.
    • The settlement can be exported as a CSV once the figures are agreed.

    What changes

    The calculation stops being rebuilt by hand every month, and the advisor can check the same figures the agency used.

    Open the agency demo

    Scenario 5

    Keeping the spreadsheet, adding the checking

    Advisor who has refined a personal spreadsheet over years and does not want to leave it

    The situation

    Every commission tool encountered so far required moving the data into someone else's system, with a migration and a new way of working.

    What the app shows

    • The app reads the existing Google Sheet rather than replacing it; the sheet remains the advisor's own file.
    • Rules, policies and statements are read from the columns already in use, with a demo available first on sample data.
    • Access can be withdrawn at any time, and the records stay where they were.

    What changes

    The verification work becomes automatic without giving up the record-keeping that already works.

    See how the tracking works

    See which of these applies to you

    The quiz takes about two minutes and points at the specific gaps in how your commission is currently checked. The demo shows the same views these scenarios describe, on sample data.

    Frequently asked questions

    Are these real customer stories?

    No. They are illustrative scenarios built from the situations the app is designed for, and each one can be reproduced in the free demo on sample data. We do not publish invented testimonials or customer names.

    Can I reproduce these examples myself?

    Yes. The demo runs on sample policies, statements and commission rules with no sign-up, and every scenario links to the view where it appears.

    Which scenario applies to most advisors?

    Missing or stopped payments. A policy that is never issued, or a renewal that quietly ends, changes a monthly total so little that it is almost never noticed without a per-policy expected amount.

    How would I know which of these applies to me?

    The free quiz walks through how you currently keep and check records and points at the specific gaps, or you can connect your own Google Sheet and look at Safe Mode directly.