Skip to content
CRYSTAL ITIT Solutions
Insurance

Reconciling accounts with insurers: an end to painful account settlements

July 24, 20267 min read
Reconciling accounts with insurers: an end to painful account settlements

It is a ritual every Moroccan insurance intermediary knows: the insurer sends its account statement, and a painstaking effort begins to confront it with the firm's figures. Deals the insurer has recorded and the firm has not, receipts the firm has settled and the insurer is still claiming, commissions calculated differently on each side, premium refunds posted twice or never… When the firm's data lives in spreadsheets, the account settlement becomes a negotiation where whoever holds the most solid figures imposes their version. This article details a method for regaining the upper hand: structuring your production, importing the statements, automating the matching and handling discrepancies one by one — with the support of software built for the purpose, such as CRYSTAL ASSUR IA (Crystal Assur, the insurance broker software).

Why accounts diverge between firm and insurer

Discrepancies between an intermediary's accounts and its insurer's almost never stem from bad faith: they arise mechanically from double entry. The same deal lives twice — once in the insurer's system, once in the firm's — and those two lives are not synchronised. An endorsement recorded here and not yet there, a cancellation sent but not processed, a receipt collected by the firm but not declared, a commission at a revised rate on one side only: every timing gap or difference of interpretation becomes a discrepancy.

Volume makes everything worse. An active firm handles hundreds of movements per insurer every month: new business, renewals, endorsements, cancellations, premium refunds, settled claims. At that scale, exhaustive manual matching is an illusion — you check by sampling, you let things slide, and unresolved discrepancies accumulate from one settlement to the next until they form disputed balances whose origin nobody remembers. The cost is real: management time swallowed up, strained relations with partners, and sometimes sums abandoned for want of being able to substantiate them.

The prerequisite: impeccable production on the firm's side

You only reconcile well what is well kept. The first step is therefore not technical but organisational: the firm must have a complete, up-to-date production base — every policy, endorsement, receipt, collection and premium refund recorded as it happens, with its insurer references. It is this discipline that changes the balance of power: faced with an insurer's statement, the firm can put forward its own technical accounting, dated and documented.

Business software makes this discipline natural because it stops being extra work: production is entered once in the course of business, and the reconciliation base builds itself. The insurer's references — policy, endorsement and receipt numbers — are kept on every movement, which will later allow automatic matching to pair the lines unambiguously. On that foundation, reconciliation changes in nature: it is no longer a reconstruction, it is a comparison (Premium receipts and collections).

Automating the tick-off: statement import and line matching

The heart of the method is automatic matching. The insurer's statement is imported into the software, which pairs each statement line with the movements recorded by the firm — by policy number, receipt number, amount and date. Matching lines tick themselves off; only the discrepancies remain on screen, classified by nature: present at the insurer and absent at mine, present at mine and absent at theirs, present on both sides but with different amounts.

This triage changes the economics of the work: instead of checking a thousand lines to find thirty anomalies, the handler deals only with the thirty anomalies. CRYSTAL ASSUR IA offers for this an insurer-connections add-on providing automatic import and reconciliation of statements. Every discrepancy handled is documented — cause identified, correction posted, supporting document attached — and the settlement balance is built line by line instead of being discovered wholesale at year end.

  • Import of the insurer's statements and schedules into the software, with no re-entry.
  • Automatic tick-off of matching lines by references, amounts and dates.
  • Discrepancies isolated and classified by nature: missing deal, divergent amount, untransmitted movement.
  • Documented handling of each discrepancy, with a trace of the cause and the correction.
  • A settlement balance substantiated line by line, usable as evidence in the discussion with the insurer.

From endured reconciliation to a mastered partnership

A firm that reconciles fast and accurately changes its relationship with the insurers. Account settlements stop being ordeals: the figures are ready, the discrepancies documented, the discussions short and factual. The credibility gained spills over into everything else — negotiating commission terms (Commissions and premium refunds), handling sensitive files, responsiveness on claims. Being a partner whose accounts are reliable is a commercial asset in its own right.

The benefit is also internal: remittances to insurers are calculated on sound bases, cash flow is anticipated, and the firm's results reflect reality. This rigour meets ACAPS's expectations on the keeping of operations: an intermediary able to substantiate every movement with its insurers is, by construction, an intermediary in good order with its regulator. To place this worksite within the overall digitalisation of a firm, see our roadmap (Digitalising an insurance agency in Morocco: where to start?).

Reconciliation with the insurers is not an accounting chore: it is the moment of truth where part of the firm's margin and credibility is at stake. The method rests on three pillars — production kept as it happens with insurer references, automatic import and matching of statements, documented handling of discrepancies only — and turns the account settlement into a formality. CRYSTAL ASSUR IA, the first insurance application in Morocco published by CRYSTAL IT since 2014 and deployed in more than 500 firms and companies, integrates this setup with its insurer-connections add-on for automatic statement import and reconciliation. Request a free demonstration and arrive at your next account settlement with unassailable figures.

Have a project or a question? Let's talk with a CRYSTAL IT expert.

Request a demo