Bank reconciliation: an age-old problem
Bank reconciliation — the systematic comparison between bank account movements and accounting records — is one of the most time-consuming processes for any administrative department. In Switzerland, where the economic fabric largely consists of SMEs and fiduciary firms managing dozens of mandates, the operational burden of manual reconciliation is even more significant.
Until a few years ago, payment slips (BVR) with reference numbers allowed semi-automatic matching, but the process remained prone to typing errors, partial payments, and credit delays. With the introduction of the QR invoice on 30 June 2020 and the definitive phase-out of BVR slips on 30 September 2022, Switzerland adopted a standard that makes fully automatic reconciliation possible.
In this guide, we analyse how automatic matching based on the QR invoice works, what problems it solves compared to the manual method, and how to integrate the end-to-end flow into your accounting software to permanently eliminate manual reconciliation.
QR invoice: overview and Swiss standard
The QR invoice (QR-Rechnung) is the standardised invoicing format introduced by SIX Group in Switzerland. At its core is the Swiss QR Code, a matrix code containing all the information needed for payment and subsequent reconciliation.
Structured Swiss QR Code
The QR code contains in machine-readable format: creditor's IBAN, amount, currency (CHF/EUR), structured reference, and debtor data. The standard is defined in SIX's Implementation Guidelines (version 2.3).
Unique structured reference
Each QR invoice includes a QR Reference (compatible with the legacy ESR) or a Creditor Reference (ISO 11649). This unique reference is the key that enables automatic matching between issued invoice and received payment.
eBill compatibility
QR invoices can also be sent via eBill, the electronic invoicing system integrated into Swiss e-banking. In this case, the payment is pre-filled and matching is native.
pain.001 format for payment orders
Accounting software can generate pain.001 files (ISO 20022) for bulk submission of payment orders to the bank, automatically including the QR references for each invoice.
CAMT.054 credit notifications
Swiss banks send CAMT.054 (Credit Notification) for every received credit, containing the structured reference from the QR invoice. This XML file is the basis for automatic matching on the accounting software side.
The problems of manual reconciliation
Manual bank reconciliation entails a series of operational and financial issues that amplify as transaction volume grows:
Unproductive time
An experienced accountant spends on average 2–4 minutes to manually reconcile a single transaction. For a company with 500 monthly invoices, this means 20–30 hours per month dedicated solely to manual matching between bank statements and the accounts receivable ledger.
Transcription errors
Manual entry of reference numbers is prone to transposition errors (digit reversal, character omission). A 1–2% error rate on 500 transactions produces 5–10 incorrect reconciliations per month, impacting accounts receivable accuracy.
Partial and grouped payments
When a debtor partially pays an invoice or groups multiple invoices into a single bank transfer, manual reconciliation becomes particularly complex, requiring analysis of the transfer's 'communication' field, which is often incomplete.
Delayed credit visibility
Without real-time reconciliation, the CFO lacks up-to-date visibility on actual collections. Ageing reports are already outdated at the time of generation, compromising cash-flow management decisions.
Opportunity cost for fiduciary firms
Swiss fiduciary firms managing accounting on behalf of clients dedicate up to 15–20% of operational time to manual bank reconciliation of mandates. These are low-value-added hours that erode service margins.
Non-compliance risk
Incorrect matching between payment and invoice can generate accounting discrepancies that, during audits or tax inspections, require costly reconstructions. The traceability required by Art. 957a CO is compromised.
Automatic matching: how it works
Automatic matching leverages the QR invoice's structured reference and CAMT.054 bank notifications to link each payment to the corresponding invoice without human intervention. Here is the 5-step process:
QR invoice issuance with unique reference
The accounting software generates the QR invoice with a QR Reference (26 numeric digits + check digit) or a Creditor Reference (ISO 11649). This reference is stored in the local database alongside the invoice data (amount, due date, debtor).
Payment by the debtor
The debtor scans the QR code via their e-banking app or manually enters the reference. The banking system transmits the payment including the structured reference in the SEPA/SIC transaction metadata.
CAMT.054 notification reception
The creditor's bank generates a CAMT.054 notification (XML ISO 20022) for each received credit. The file contains: credited amount, value date, structured reference, debtor's IBAN, and additional information.
Multi-criteria matching algorithm
The accounting software compares each CAMT.054 notification against open invoices in the receivables ledger. The algorithm checks in order: (1) exact structured reference match, (2) amount match, (3) partial payment tolerance, (4) fuzzy matching on free-text communication for payments without a reference.
Reconciliation and automatic posting
When matching is confirmed (typically with confidence ≥ 95%), the system automatically closes the invoice in the receivables ledger, generates the accounting entry (debit: bank, credit: accounts receivable), and updates ageing reports in real time.
End-to-end flow: from invoice to balance
Full integration between QR invoice, banking system, and accounting software creates a closed-loop flow that eliminates all manual intervention:
The flow begins with invoice creation in the management system and ends with automatic closure of the accounting position. Every step is tracked and auditable, ensuring compliance with Art. 957a CO on traceability.
In case of exceptions (partial payment, wrong amount, missing reference), the system generates an alert for manual review, limiting human intervention to anomalous cases only — typically 3–5% of transactions.
Benefits of automatic reconciliation
Automating bank reconciliation via QR invoice and CAMT.054 delivers measurable benefits across multiple dimensions:
95% reduction in operational time
Automatic matching reduces reconciliation time from 2–4 minutes per transaction to a few seconds. For a company with 500 invoices/month, the saving exceeds 25 hours monthly.
Near-zero error rate
Eliminating manual data entry reduces the reconciliation error rate from 1–2% to below 0.1%, limited to payments without a structured reference.
Real-time visibility
With automatic processing of CAMT.054 notifications, the receivables balance is updated in real time. Ageing reports reflect the actual situation, improving cash-flow management decisions.
Scalability at no extra cost
Transaction volume can grow without needing additional reconciliation staff. The marginal cost per additional transaction is virtually zero.
Native compliance
Every match is logged with timestamp, reference, and criterion used. The invoice → payment → posting chain is reconstructible at any time, meeting the audit trail requirements of the CO.
Higher margins for fiduciary firms
Fiduciary firms adopting automatic reconciliation can reallocate the 15–20% of saved operational time towards higher-value advisory activities, improving mandate profitability.
Integration with accounting software
The effectiveness of automatic reconciliation depends on correct integration between accounting software, the banking system, and ISO 20022 flows. Here are the key points:
Native ISO 20022 support
The accounting software must natively support pain.001 (payment orders), CAMT.053 (account statements), and CAMT.054 (credit notifications) formats. Most Swiss management systems (Abacus, Bexio, Klara, Banana, Accountex) offer this support.
Automatic bank connection
Integration via EBICS (Electronic Banking Internet Communication Standard) or banking APIs enables automatic download of CAMT files without manual e-banking access. Polling can be configured hourly or daily.
Exception handling
A good reconciliation system must include an exception queue for non-automatically matched payments: payments without reference, mismatched amounts, duplicate payments. The interface should allow quick manual resolution with automatic suggestions.
Multi-bank and multi-currency reconciliation
For companies with accounts at multiple institutions or invoicing in both CHF and EUR, the system must aggregate CAMT.054 notifications from all banks and handle cross-currency matching using the exchange rate on the value date.
Practical implementation tips
- Always use the QR Reference (not free-text communication) for every issued invoice: it is the only field that guarantees 100% automatic matching.
- Activate CAMT.054 notifications with your bank — not all banks enable them by default. Check with your banking adviser about availability and delivery frequency.
- Configure your accounting software for automatic CAMT file download via EBICS or API. Manual polling negates most of the automation benefits.
- Define tolerance rules for partial payments: for example, automatically accept differences below CHF 1.00 as rounding and close the invoice.
- Monitor the automatic matching rate: a value below 90% indicates that many clients are not using the structured reference. In this case, consider sending via eBill to increase compliance.
- For fiduciary firms: configure separate reconciliation per mandate, with distinct IBANs and charts of accounts. Multi-mandate automation is the true efficiency multiplier.
- Run a full reconciliation test before go-live: generate 10–20 test QR invoices, execute the payments, and verify that the CAMT.054 matching works correctly end-to-end.
Simplify your Swiss accounting
AccountEX handles VAT, QR-invoices and bookings with AI. Start for free.
Start Free