Reconcile bank statements
Updated:
Match movements to invoices and memorials.
Open Bank & payments in FiattoIn this article
Under Bank & payments → Worklist & reconciliation → Statements (/dashboard/bank/afschriften) and Worklist you match bank movements to open items.
Steps
- Bring statements in: drop a file in the Import statement block on the Bank & payments start page (
/dashboard/bank) and click Import. CAMT.053, MT940 and CSV are recognised (Belgian CODA files too) and duplicate files are skipped; if a CSV deviates, use Map columns manually. Or let statements arrive automatically via Bank feeds. - Open Statements (paginated with Previous/Next; choose 25, 50 or 100 under Per page). A notice at the top warns if a statement does not balance or does not connect to the previous one. Clear-cut cases are quicker on the worklist.
- Click View movements on a statement and Reconcile on a line: choose an invoice under Match to invoice, spread the line over several invoices with Split / partial payment, or post it under Or: book to a ledger account. A collective debit from a payment or direct debit batch is matched in one go with Reconcile whole batch; a returned collection or payment is handled with Reverse collection or Reverse payment.
- If a customer pays slightly too little, write off the difference within the tolerance (Match and write off …) or turn it into a dispute (Match with a deduction of …). A wrong match is fixed with Undo.
Tips
- The tolerance and account for payment differences are set under Settings → Bank & payments, block Payment differences.
- For a direct-debit return, start the reason with the bank code (e.g. AM04 or MD06): a final code revokes the mandate, a temporary one reopens the invoice for one more presentation.
- New/changed IBANs trigger extra checks — see IBAN fraud. Cash belongs in the cash book, not here.
- How much is matched automatically or by hand is shown under match origin.