Reconciling supplier statements

When a supplier sends you a monthly statement listing every invoice they think you owe them (and every payment they've recorded), upload it to Blankitt and let the reconciler match each line against your AP ledger. Mismatches surface as a discrepancy list.

Upload a statement

1. Go to Spending → Statements, click Upload statement.
2. Pick the supplier + statement date. Optionally set the period start/end and opening/closing balance.
3. Paste the CSV from the supplier's download. Format: date,reference,description,amount. Header row optional (the parser detects column names case-insensitively).
4. Click Parse — see a preview of the first 5 lines.
5. Click Create + auto-match — the worker creates the statement and runs the matcher immediately.

How the matcher works

For each statement line, the matcher looks for a fin_invoices row for the same supplier where:

1. Reference exact — your bill number equals the supplier's reference. Confidence 100%, match kind reference.
2. Amount + date close — amount within £0.01 AND date within ±7 days of the statement line. Confidence 70%, match kind amount_date.

Lines that don't auto-match come in with status unmatched. Resolve each manually.

Per-line actions

Action	When to use
Match to bill	The line is real and you have the bill — pick it from the dropdown
Dispute	The supplier billed something you didn't accept. Capture variance notes; pursue with the supplier
Ignore	The line isn't real on your side (e.g. an old invoice the supplier should have written off)

The variance number

The detail page's Variance stat tile sums the matched-line amounts and compares to the statement's closing balance minus opening balance. Below £0.01 = balanced. Anything bigger = some lines aren't matched yet.

Reconcile + lock

Once every line is matched, disputed, or ignored, click Reconcile + lock. The statement freezes for the audit trail. Future statement uploads from the same supplier won't change this one.

See also: Bills overview.