Bank Reconciliation: How to Match Payments Received With Invoices

Bank reconciliation means matching payments received with issued invoices, so you know exactly what has been paid — without manually ticking off invoice after invoice. It’s one of the most time-consuming activities, and one of the easiest to automate.

From statement to paid invoices

The flow is simple:

1. You import the bank statement — from a CSV file (exported from internet banking) or from a standard bank format (MT940, CAMT.053).
2. The app reads the incoming transactions.
3. It automatically matches them with unpaid issued invoices.
4. Matching invoices are marked as paid.

Anything that doesn’t match automatically stays highlighted for a quick review.

Why it matters

• You see correctly what’s outstanding — the basis for the outstanding-balance report and for tracking collections.
• You avoid errors — you no longer mark things manually, where mistakes are easy.
• You save time — especially with large volumes of invoices.

CSV, MT940, CAMT.053 — in brief

• CSV — the simple export from internet banking; the most accessible.
• MT940 — a classic bank format for statements.
• CAMT.053 — a modern XML format (ISO 20022) for statements.

You don’t need a live bank connection (open banking): reconciliation works based on the statement file.

How it works in facturifirma

In facturifirma, for reconciliation you choose the file (CSV/MT940/CAMT.053), the app imports the transactions and automatically matches them with issued invoices, marking what has been collected. You can configure the columns for different CSVs. The result is reflected immediately in the invoices’ status and in reports (e.g. outstanding balance by age).