Bank reconciliation

Upload a bank statement CSV. luca matches transactions to receipts and tells you what's missing.

Uploading a bank statement

Open the client's page and go to Bank reconciliation. Drop in a CSV file exported from your client's online banking. luca recognises common formats from the major UK and Irish banks — date column, description column, amount column. If your bank's format is non-standard, you can map columns manually.

How auto-matching works

luca compares each bank transaction against every receipt in the client's account. A match requires:

• Amounts within 1p of each other
• Dates within a 7-day window
• No prior match for either side

Matches are scored. The highest-confidence match wins. Ambiguous cases (multiple receipts could match a single transaction) are flagged for manual review.

Reviewing matches

The reconciliation view shows three groups:

• Matched — bank transactions paired with receipts. Click any pair to verify.
• Unmatched bank transactions — money out of the account with no matching receipt. These usually mean a missing receipt — chase the client.
• Unmatched receipts — receipts with no matching bank transaction. These could be cash payments, personal cards, or duplicates.

Manual matching

If auto-matching missed a pairing, you can match manually. Click an unmatched bank transaction, then click an unmatched receipt. luca records the manual match and excludes both from future auto-matching runs.

Re-running reconciliation

Upload a new statement at any time. Existing matches are preserved. Only new bank transactions are auto-matched against unmatched receipts.