Commission statements & reconciliation: how it works
Insurers that bill clients directly pay your commission on a statement. Enter it by CSV or by typing the lines; each line is matched to a policy and compared with the commission still outstanding, policies missing from it are listed, and the money received is booked once.
Lesson 6 of 12 · How it works
How it works
«Enter a commission statement»: the insurer, its reference, the period and a CSV (columns found by name: policy number and commission; client and premium optional) or typed lines «policy number; client; commission».
Each line is matched to the insurer's policy by the insurer's policy number or your own number, typed any way, then marked «Matched», «Short», «Over», «Unknown policy» or «Kept on remittance» (Agency billing You invoice the client for the premium, collect it and remit it to the insurer less your commission. More words in the glossary).
«Missing from this statement» lists the insurer's direct-billed policies bound by the period end with commission outstanding and no line here — the ones to ask the insurer about.
«Record as received» with the date and bank account: matched, short and over lines count as commission received, Journal The journal is the list of every bookkeeping entry in date order. One journal entry says which accounts went up and which went down for one event, for example an invoice or a payment. More words in the glossary Dr bank, Cr 4070; a received statement can no longer be changed or deleted.
Each policy shows expected, received and outstanding commission; «Reconcile again» after fixing a policy number.
Where to find it
- Insurance policies → Commission & remittances
/admin/policies/commissions
Settings that change it
- Insurance policies → Insurers
/admin/policies/insurers
Checklist
Before you move on, check that you can:
- Open Insurance policies → Commission & remittances
- Enter a commission statement: the insurer, its reference, the period and a CSV (columns found by name:…
- Each line is matched to the insurer's policy by the insurer's policy number or your own number, typed any…
- Missing from this statement lists the insurer's direct-billed policies bound by the period end with…
- Record as received with the date and bank account: matched, short and over lines count as commission…
Tips and common mistakes
- Enter the insurer's policy number on each policy — it is what statements use.
- An «Unknown policy» line is often cover typed in under another insurer or not entered at all.
- Short and over lines still count as received; follow up the difference with the insurer.