To reconcile commission statements from several insurers automatically, you need a system that reads each insurer's statement in its own format, turns every line into the same shape, and matches it to two things: the deposit in your bank account and the commission you expected on that policy. Anything that doesn't match goes to a person to review. The output is a reconciled ledger and a report your accountant can use without rebuilding it. Start with one insurer, prove the matching works, then add the rest.
What does manual commission reconciliation involve?
In a life risk or general insurance advice practice, it usually looks something like this.
Statements arrive from each insurer as PDFs, CSV files or spreadsheets downloaded from a portal. Each has its own layout, its own way of writing policy numbers and client names, and its own statement period.
Each statement mixes different kinds of lines:
- upfront commission on new policies
- renewal or ongoing commission on policies already in force
- clawbacks, where commission is taken back because a policy lapsed or was reduced
- adjustments for premium changes, backdated alterations and corrections
Then someone matches it to the bank. One deposit might cover hundreds of lines, or arrive net of clawbacks, or land a few days after the statement date. Finally the commission is split between advisers, and sometimes a referral partner, according to whatever arrangement applies to each client.
Usually one person does all of this in a spreadsheet, ticking lines off and chasing the ones that don't add up.
Why is it so error-prone?
Because every step involves retyping or eyeballing, and the inputs keep changing.
- Formats change without warning. An insurer moves a column or changes its PDF layout and the spreadsheet formulas quietly break.
- Netted deposits hide detail. If clawbacks are deducted before payment, the bank line looks short and the reason sits several pages into a PDF.
- Missing payments are invisible. A statement only shows what the insurer paid. It doesn't list the renewal commission it forgot to pay. You only find that by comparing against what you expected per policy, a step that is easy to skip when it's done by hand.
- Splits are applied by memory. When adviser splits live in someone's head or an old email, the same policy can be split differently from one month to the next.
In our post on what admin costs your business, we used this exact task as the worked example: someone spending about an hour a day reconciling statements, on $95,000, costs $12,500 a year in wages before you count any commission that was short-paid and never chased.
How do clawbacks work under the Life Insurance Framework?
For life insurance, commission caps and clawback are set by ASIC Corporations (Life Insurance Commissions) Instrument 2017/510. According to ASIC, the instrument:
- caps commission at 60% of the premium in the first year of the policy from 1 January 2020, with ongoing commission capped at 20% of the premium in all later years
- requires 100% of the commission to be clawed back if the policy lapses in the first year, and 60% if it lapses in the second year
- treats a lapse as the policy being cancelled or not continued, or the policy cost being reduced
- sets out formulae for working out the clawback amount depending on when the lapse occurs
The Federal Register of Legislation lists the instrument as in force and due to sunset on 1 October 2027, so check whether it has been remade or replaced before relying on these figures.
For reconciliation, this means the system needs each policy's start date, first-year commission and premium history. With those, it can work out whether a policy is still inside the two-year clawback period, calculate what a clawback should be, and flag any clawback line that differs from that figure, rather than accepting whatever the statement says. A premium reduction can trigger a clawback too, so changes in premium need to be tracked, not just cancellations.
If you also write general insurance, these caps and clawback rules don't set your terms there. Write down each insurer's commission and refund terms from your agreement with them, so the system can check against those instead.
How does automated reconciliation work, step by step?
- Ingest each provider's statement. Statements come in by email or upload. Each insurer gets its own reader: CSV and spreadsheet files are read directly, and PDFs are read with document extraction. Every statement is checked on the way in: the lines extracted must add up to the statement's own total. If they don't, the statement is flagged before anything else happens.
- Normalise every line. Each line becomes one record in the same format, whatever the insurer: provider, policy number, client, product, line type (upfront, renewal, clawback or adjustment), premium, commission, period and adviser. Policy numbers are cleaned so the same policy matches across sources.
- Match to the bank feed. Lines are grouped by provider and payment date and matched to deposits from your bank feed. The system allows for deposits paid net of clawbacks and for timing gaps between statement and payment.
- Match to expected commission per policy. Using your policy register or CRM, the system works out what each policy should have paid this period and compares it with what arrived. This is what catches missing payments, wrong rates and policies the insurer has paid on that aren't in your records.
- Flag mismatches for a person to review. Only the exceptions reach a person: short payments, missing payments, unexpected clawbacks, unknown policies, deposits with no statement. The reviewer resolves each one with a note, and the system remembers decisions such as two policy number formats referring to the same policy.
- Apply adviser splits and produce the report. Splits are applied from written rules, not memory. The report shows received against expected by provider and adviser, clawbacks, and anything still outstanding, exported in a form your accountant can use directly.
The person's job shifts from doing the reconciliation to checking the exceptions. Nothing is marked as reconciled without a clean match or a person's decision.
Should you use an off-the-shelf tool or a custom build?
Look at existing tools first. Ask:
- Does it read statements from every insurer you deal with, in the formats they actually send?
- Does it match to your bank feed, or only import statements?
- Does it compare against expected commission per policy, or only record what was paid?
- Does it treat clawbacks as their own line type, linked to the original policy?
- Can it apply your adviser splits as they really work?
- What happens when an insurer changes its statement format, and who fixes it?
- Where is the data stored, and who can see it?
- Will it export something your accountant can use?
If a tool answers yes for your insurers and your splits, use it. It will usually cost less than a build.
A custom build makes sense when your insurers, products or split arrangements don't fit the tool, when the tool still needs manual work behind it, or when you want reconciliation tied into your CRM and policy records. We built a commissions engine for an insurance practice where a paid tool still needed manual work behind it. Provider statements are ingested automatically and matched line by line to the bank, and anything that doesn't match is flagged for review.
How should commission data be kept secure?
Commission statements hold client names, policy numbers and premiums, and the bank feed holds your financial data. Treat it as sensitive.
If the Privacy Act applies to your practice, Australian Privacy Principle 11 requires you to take reasonable steps to protect personal information from misuse, interference and loss, and from unauthorised access, modification or disclosure. In practice, ask any tool or builder:
- where the data is stored and processed, and which third-party services touch it
- whether bank data comes through a read-only feed rather than shared logins
- who has access, and whether there's a record of who changed what
- whether your data is used to train AI models
Our own position: data we host is stored and processed in Australia, every provider that touches client data is named in the proposal, and client data is never used to train models.
How do you start small?
Pick one insurer. Choose the one with the most lines or the most awkward format, because that's where the time goes.
Build the reading, matching and exception review for that insurer only. Run it alongside your manual process for a couple of cycles and compare the results line by line. Once it agrees with you, or catches what you missed, add the next insurer.
This follows our general advice in which admin to automate first: one task, about three hours a week saved for one person, with a result a person can check. Commission reconciliation usually fits that test well. If you want help scoping it, our AI automation work starts with a fixed price and date agreed in writing before any code is written.
Frequently asked questions
Can software read commission statements that arrive as PDFs?
Yes. Document extraction can pull lines out of PDF statements, including layouts that vary. Each statement should be checked against its own total so a misread line is caught straight away.
What happens when an insurer changes its statement format?
A well-built system notices, because the extracted lines no longer add up to the statement total or expected fields are missing. The statement is flagged and the reader for that insurer is updated, which is why ongoing support matters.
How does an automated system handle clawbacks?
It records clawbacks as their own line type, links each one to the original policy, and compares the amount with what the applicable rules say it should be. Clawbacks that don't match, or that arrive for policies outside the clawback period, are flagged for review.
Can it handle different adviser splits?
Yes, once the split rules are written down per adviser, client or policy. The system applies them the same way every time and shows the split on the report.
Do we still need a person to check the reconciliation?
Yes. The system does the matching and finds the exceptions, but a person decides what to do about each one and signs off the report before it goes to the accountant.
If commission reconciliation is taking hours in your practice, book a free 30-minute chat and we'll tell you whether an existing tool will do it or a build is worth it.
This article is general information, not financial or tax advice.