In this guide
- Automate the tasks that repeat on a schedule and fail silently — renewals and commission checking come first.
- Anything that depends on judgement or a relationship should stay with a person.
- Workflow only works when the underlying policy and client records are complete.
- Four weekly numbers tell an agency more than a long report: realisation, renewals due, open variances, new policies.
- Automate one task, measure it for a month, then add the next.
Contents
Start with tasks that fail silently
The best automation candidates share three properties: they repeat, they follow a rule, and when they are skipped nothing visible happens.
That last property is the important one. A missed client call gets a complaint. A missed renewal or an underpaid commission line produces silence, and silence is what automation is good at breaking.
In priority order for a small agency:
- Renewal flags — every policy due within a fixed notice period, on someone's list.
- Commission checking — expected against paid per policy, per period.
- Unmatched statement lines — payments that belong to no policy.
- Task follow-ups — anything promised to a client with a date attached.
- Weekly reporting — the same four numbers, produced without anyone assembling them.
What to leave to people
Automating the wrong thing costs more than doing it by hand, because it removes judgement from a place that needed it.
- Advice and product selection.
- The renewal conversation itself, once the flag has been raised.
- Anything a client would notice as impersonal, especially after a claim.
- Decisions about commission disputes — the tool should surface the discrepancy, a person should decide whether to chase it.
Useful rule: automate the detection, keep the decision.
Workflow only works on complete records
Every automation depends on the same foundation: one row per policy with premium, dates, product, insurer and owner, and one client record holding all of a client's policies.
If that foundation has gaps, automation propagates them faster. Before buying workflow software, fix:
- duplicate client records;
- inconsistent policy number formats;
- missing renewal dates;
- advisor names written differently in different files.
Practical guidance on getting that right is in policy record keeping and keeping client records in Google Sheets.
Four numbers to watch weekly
Small agencies drown in optional reports. These four are enough to run the week:
- Realisation — commission paid against commission expected.
- Renewals due — policies inside the notice period, by owner.
- Open variances — commission discrepancies not yet explained, and their value.
- New policies — count and premium, by advisor.
Reviewed weekly, they show direction rather than volume, which is what a manager actually needs. Commission Clarity produces the first and third in the Commission Monitor, and the per-advisor view in the agency overview.
Where several people share income from the same policy, the split rules matter as much as the totals — see agency commission splits.
A realistic sequence
Automate one thing at a time and keep the previous step running.
- Week 1: one complete policy list with renewal dates and owners.
- Week 2: renewal flags with a fixed notice period.
- Month 2: expected commission calculated per policy from your own rules.
- Month 3: statement matching, with variances and unmatched lines listed.
- Month 4: the weekly four numbers, produced automatically.
Each step should reduce a specific manual routine. If a step adds work without removing any, stop and fix the previous one rather than adding software on top. You can see the finished shape of this with sample data in the free demo.
Frequently asked questions
What should a small insurance agency automate first?
Renewal flags and commission checking. Both repeat on a schedule, both follow rules you already have, and both fail without any visible signal when they are skipped.
Do we need workflow software to automate anything?
Not for the first steps. A complete policy list with renewal dates and owners already removes most of the risk. Software becomes worthwhile when the list is too large to scan or several people work from it.
Which numbers should an agency review each week?
Realisation, renewals due inside the notice period, open commission variances, and new policies with premium by advisor. Four numbers reviewed weekly beat a long monthly report.
Does automation replace agency staff?
It replaces remembering, not judgement. Detection, matching and reporting can run automatically; advice, renewal conversations and decisions about disputes should stay with people.
Try Commission Clarity on your own data
Client records, policy portfolio and commission control in one place. Your data stays in your own Google Sheets — Commission Clarity reads it live and highlights the discrepancies.



