Skip to content

Trace unmatched premiums to their remittance lines

A broker remittance often arrives net of deductions or split across several statements. Duvo matches them line by line against the schedule and the receipt ledger, and writes a note for every difference with the source lines attached.

Book a process call

Premium reconciliation

Needs review

Batch PR-701

Receipt status
Unmatched line
Receipt
Batch total in ledger
Owner
Premium accounting

The batch total is in the ledger, but one remittance line has no policy reference and matches no amount on the premium schedule.

Next action

Request breakdown: broker operations is asked for the breakdown and the line stays unmatched until it arrives.

Keep unresolved: the line goes into the reconciliation note as an open difference with its missing reference recorded.

Finance approval

The premium accounting owner approves each broker query and each reconciliation note before it reaches the close process.

View the wider product queue

Premium reconciliation

Broker remittance with one line that has no policy reference.

Adds cases
Broker remittance statement
Processes cases
Premium reconciliation
Total

24

Pending

5

Postponed

2

In progress

4

Needs input

3

Failed

0

Completed

10

Add filter
Case
Case Status
Match exception
Scope
Decision
Exceptions
Next action
Batch PR-701
Needs Input
Policy reference missing
Monthly broker remittance
Request breakdown
1
Batch PR-702
In Progress
Instalment period differs
Renewal schedule
Check receipt period
0
Batch PR-703
Completed
Commission deduction explained
Broker fee note
Note recorded
0
Batch PR-704
Pending
Deduction unexplained
Monthly settlement
Query deduction
1
Batch PR-705
Postponed
Statement awaited
Receipt without advice
Await broker statement
0

Showing 5 of 24 cases

  1. 1

    Approval

    Exceptions pause for the named owner

    Each exception carries the source records, applied rule, recommended action, and the person authorised to decide.

  2. 2

    Match exception

    Match exception is visible before the action

    One remittance line cannot be tied to a policy on the premium schedule, so it stays unmatched instead of being fitted to the nearest amount.

From broker remittance to a reconciliation note

One broker payment covers dozens of policies, net of the broker’s commission and a few return premiums. The ledger shows a single receipt. Premium accounting has to rebuild which policies were paid, which were short and whether a missing line is late or not coming at all.

  1. 0101

    Break the remittance into policy lines

    Duvo reads the remittance statement, links each line to its policy reference and statement period, and ties the total to the receipt in the ledger export.

  2. 0202

    Explain what does not match

    Duvo checks each line against the expected premium schedule, separates period differences and commission deductions from unexplained items, and drafts a reconciliation note with the source lines.

  3. 0303

    Your team decides

    Review the note

    The premium accounting owner accepts the explanation for the close, or approves a query to broker operations for the lines still unexplained.

  4. 0404

    Record the answer

    Broker operations receives the approved query. When the breakdown arrives, Duvo attaches it and marks each line in the reconciliation register as resolved or still open.

Compare broker statements with expected receipts

Systems and control details

Premium matching needs the broker remittance, the premium schedule and the receipt ledger; a first run can use masked policy references. Matching rules for periods, references and commission deductions are agreed before any access to policy administration or accounting systems.

Broker remittance statement, Expected premium schedule, Receipt ledger export, Reconciliation register

  • Finance approval

    The premium accounting owner approves each broker query and each reconciliation note before it reaches the close process.

  • No cash or ledger changes

    Duvo does not allocate cash, post journals, write off differences, move funds or change policies.

  • Keep the original batch

    The original batch total, every source line and the reviewer’s explanation stay together. An unexplained deduction remains open until finance records its treatment.

What teams ask about Premium reconciliation

  • How does Duvo handle remittances paid net of broker commission?

    It checks each deduction against the commission rate you supply for that broker and product, and flags deductions that do not match or have no agreed rate.

  • Does Duvo allocate cash in our ledger?

    No. Duvo produces the match and the explanation. Allocation, journals and any write-off stay with premium accounting.

  • What if a broker pays before sending the statement?

    Duvo marks the receipt as awaiting its breakdown and matches the lines when the statement arrives. The receipt date and statement date stay separate.

  • What do we need to try it on one broker?

    A masked remittance batch, the expected premium schedule for the same period and the receipt ledger export.

Related processes