Invoice ↔ Bank Reconciliation

Load Peppol invoices and CODA/CAMT bank statements. Match incoming and outgoing payments, review uncertainty, track partial settlements and prepare follow-ups locally.

Local: yes. Your input stays on your device and is not sent to an external service for this tool.

Which invoices are you checking?

Mixed mode classifies invoices only if the supplier or customer VAT matches your company. Credit notes and invalid invoices are flagged for separate review, not silently settled.

1. Invoices

Select UBL invoices or ZIP archives. Up to 500 invoices, processed only in your browser.

2. Bank statements

Choose several CODA or ISO 20022 CAMT files. Overlapping bank entries are deduplicated.

Only strong unique payment references can be allocated automatically. Amount-only and ambiguous matches require your explicit approval. Not found in these statements does not mean unpaid.

Invoice and bank data stay in your browser. Payment and reminder exports require your own review before use.

How the matching works

Load your sales invoices as UBL/Peppol XML and a bank statement as CODA or CAMT.053/054. The tool compares every incoming credit with every open invoice and adds points for each piece of evidence. The scoring is fixed and visible, not a black box:

Evidence                                           Points
Payment reference equals invoice reference (OGM/RF)   +100
Invoice reference found in the communication          +85
Exact amount                                          +45
Amount within 2% (at least € 1)                       +15
Invoice number found in the communication             +35
Customer name matches the counterparty                +20
Payment within 90 days of the invoice date            +10

Outgoing transactions are ignored. Pairs scoring below 45 are not proposed. The best pairs are assigned first, each invoice and transaction at most once.

Result categories

  • Matched (score 100 or more): a structured reference matched, typically the OGM on the invoice.
  • Probable (65 to 99): for example exact amount plus invoice number in the free text.
  • Review (45 to 64): only weaker evidence, such as an exact amount alone.
  • Paid, underpaid or overpaid: the difference between transaction and invoice amount.
  • Duplicate-looking credits: a second credit that would also fully match an invoice already paid.
  • Unmatched invoices and credits, ready for follow-up.

Edge cases

  • Partial and grouped payments. One transfer paying three invoices, or one invoice paid in instalments, cannot be split automatically; such credits end up in review or unmatched.
  • Missing OGM. Customers who type "invoice 2026-042" instead of the structured communication still match on invoice number and amount, at a lower confidence.
  • Same amount, several invoices. Exact amount alone is never enough for a match; it needs a reference, invoice number or name.

Who uses it

Small businesses and bookkeepers who issue Peppol invoices and receive CODA or CAMT statements use it to see in minutes which invoices are paid, which customers paid too little and which credits still need an owner, before chasing anyone with a reminder.

Put an OGM on every invoice with the OGM generator to make matching near-perfect. Read the statement with the CODA viewer or CAMT viewer, and audit the invoices first with the Peppol batch auditor.

Frequently asked questions

Which files can I reconcile?

Sales invoices in UBL 2.1 / Peppol BIS Billing 3.0 XML, and bank statements in CODA or CAMT.053/054 format.

How is a match decided?

Each invoice and incoming credit pair gets points for payment reference, exact or near amount, invoice number, customer name and date proximity. Pairs below 45 points are not proposed; 100 or more is a match, 65 to 99 is probable.

What if a customer pays several invoices in one transfer?

Grouped and partial payments are not split automatically. They appear as review or unmatched so you can allocate them yourself.

Why is an exact amount not enough?

Many invoices can share the same amount. An exact amount scores 45 points, which only reaches review; a reference, invoice number or name is needed for a probable or certain match.

Are my invoices and statements uploaded?

No. Matching runs in your browser and nothing is sent to gratistools.be.