Skip to content
TrueBind
How it worksSample reportPricingSecurity
Sign in
Sample Health Check

This is what you get back.

We generated a 502-row claims bordereau, planted 15 problems in it, and ran it through TrueBind exactly as a customer file would be. Everything below, and every file you can download, is that run’s real output.

Bordereau Health Check · Sample_Bordereau.xlsx · 502 claim rows
Fix before submitting12 errors on 11 rows must be fixed before this file is sent.
Errors12must be fixed
Warnings5unusual, or not in a checkable form
Couldn’t check0every check ran

Top 5 fixes

  1. 1
    Error · CriticalRequired data missing2 findings
    Claims!C416: Required data missing: insured name is missing.Money on these rows: £106,647Fix: Ask the sender for the missing value.
  2. 2
    Error · HighIncurred exceeds the policy limit1 finding
    Claims!M22: Incurred exceeds the policy limit: total incurred 150,000.00 is above the policy limit 100,000.00.Money on these rows: £150,000Fix: Total incurred is above the policy limit: a possible overpayment or a wrong limit. Check both.
  3. 3
    Error · HighTotal incurred does not reconcile2 findings
    Claims!M458: Total incurred does not reconcile: total incurred=58,702.08 but paid to date 26,451.11 + reserve 36,367.57 = 62,818.68 (no fee columns in this file: checked as nil fees; if the total includes fees the difference may be fees).Money on these rows: £88,638 · US$58,702Fix: Total incurred should equal paid plus reserve (plus fees). Ask the sender which figure is right.
  4. 4
    Error · HighExact duplicate1 finding
    Claims!A409: Exact duplicate: claim reference 'CLM-102842' is repeated with identical amounts and status in the same sheet 'Claims' (no reporting period present).Money on these rows: £59,495Fix: The same claim was sent twice with identical figures. Ask the sender to withdraw one.
  5. 5
    Error · HighCurrency code not recognised1 finding
    Claims!J107: Currency code not recognised: 'XXX' is not a valid ISO 4217 code.Money on these rows: ¤56,621Fix: Use a valid ISO currency code (EUR, GBP, USD...). Confirm which currency the amounts are in.

Not claims, so left out (and shown, never hidden): “Summary”, “Notes”, “Summary”.

Download the files

The file as receivedA synthetic 500-row monthly claims bordereau with problems planted in it. No real data.Sample_Bordereau.xlsxAnnotated workbookThe same file, every claim cell coloured, a Review notes column, hover notes with the fix, and an Issues sheet with links to each cell.Sample_Bordereau_REVIEWED.xlsxCorrected copyOnly the safe fixes applied, each listed on the Change Log sheet.Sample_Bordereau_CORRECTED.xlsx

The query letter

Only what the sender must fix, grouped by issue, each with its cell. Ready to paste into an email.

Try it on one of your own files

Founding pilot: your first file is free. We return the annotated workbook, the corrected copy and the query letter.

Prefer to talk?truebind@truebind.ieBook a call
TrueBind
SecurityLloyd’s CRS v5.2Privacyhello@truebind.ie© 2026 TrueBind