Errors12must be fixed
Warnings5unusual, or not in a checkable form
Couldn’t check0every check ran
Top 5 fixes
- 1Error · CriticalRequired data missing2 findingsClaims!C416: Required data missing: insured name is missing.Money on these rows: £106,647Fix: Ask the sender for the missing value.
- 2Error · HighIncurred exceeds the policy limit1 findingClaims!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.
- 3Error · HighTotal incurred does not reconcile2 findingsClaims!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.
- 4Error · HighExact duplicate1 findingClaims!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.
- 5Error · HighCurrency code not recognised1 findingClaims!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”.