Skip to content

Reconcile bank statements

Updated:

Match movements to invoices and memorials.

Open Bank & payments in Fiatto
In this article

Under Bank & payments → Worklist & reconciliation → Statements (/dashboard/bank/afschriften) and Worklist you match bank movements to open items.

Steps

  1. 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.
  2. 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.
  3. 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.
  4. 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.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.