Invoice reconciliation means putting every transaction on your business account next to the document that explains it, and every invoice next to the payment that settled it. Work from the bank account, not the inbox: the account knows how many documents are missing, the inbox only shows what has arrived. Four statuses, five matching keys and one rule per edge case turn this into a weekly routine.
What invoice reconciliation means – in both directions
Invoice reconciliation – often called bank reconciliation or payment matching in accounting software – links each account movement to its proof: invoice, receipt, credit note or settlement report. It runs in two directions:
- Payment without a document: money left the account, the invoice is missing. This is the expensive case: no invoice, no input VAT deduction, and a shaky business expense.
- Document without a payment: an invoice with no matching movement. It is still open, was paid with another payment method, is a duplicate – or isn't yours.
The account leads because it is complete: every debit is on it. Your inbox only holds what someone sent – not the invoice sitting in a supplier portal, sent as a link or never issued. Count from the account instead: 140 debits this month, 126 with a document, 14 open cases.
Four statuses for every transaction
Every transaction gets exactly one status:
- Open: nothing matched yet – acceptable only for transactions newer than your last reconciliation.
- Document attached: linked and checked; differences are explained.
- Requested / waiting: you have asked for it, or it isn't issued yet, such as a monthly invoice. Note since when and from whom.
- No invoice, with a reason: there is no supplier invoice, but there is other proof.
| No-invoice transaction | Proof |
|---|---|
| Transfer between your own accounts | The matching entry on the other account |
| Owner withdrawal or contribution | Bank statement with a note |
| Tax payment | Tax assessment or tax return |
| Salaries | Payslip |
| Monthly credit card settlement | Card statement; the receipts belong to the individual card transactions |
“No invoice” doesn't mean “no document”: Germany's GoBD bookkeeping rules list tax assessments, business bank statements and payslips as vouchers too (margin no. 62). Attach the reason to the transaction.
Matching keys, in this order
A match is only safe when the amount fits and at least one identity key agrees: counterparty or invoice number. Check them in this order:
| Key | What it catches | Where it fails |
|---|---|---|
| 1. Amount, to the cent | Most standard cases | Discounts, partial payments, batch transfers, deducted fees, foreign currency, tips; subscriptions with the same price every month |
| 2. Date window | Same amount, different month | Payment terms, late payments, prepayments; subscription and card invoices often arrive after the debit |
| 3. Currency | USD or GBP invoices debited in euros | The bank's rate differs, so the euro amount never fits to the cent |
| 4. Counterparty | Equal amounts from different suppliers | Payment providers in the bank text; brand instead of legal name |
| 5. Reference / invoice number | Unambiguous matches, even in batch transfers | Missing on card payments and many direct debits |
If two candidates with the same amount fall in the date window, don't guess – the invoice number or service period decides. And if the payment reference shows a different invoice number, it's not a match, however well the amount fits.
The GoBD back this order: with a high volume of documents, dates, statement numbers or names are usually not a suitable matching key because they aren't unique (margin no. 73), while the supplier's invoice number may be used if it allows an unambiguous match (margin no. 77). Put it in the booking text.
Edge cases and the rule for each
Most open items aren't missing documents but amounts that don't fit to the cent for a known reason:
- Partial payments and instalments. Attach the same invoice to each instalment and note “2 of 3”. The invoice stays open until the payments reach its total.
- Down payment and final invoice. The down payment gets the down-payment invoice, the remainder the final invoice. German VAT law has the final invoice deduct earlier payments and their VAT (Section 14(5) UStG), so the last payment matches the balance, not the total.
- One payment for several invoices. Attach all invoices to the one transaction. The sum must work out to the cent; any difference is a discount, an offset credit note or a fee. When several documents belong to one booking, the GoBD require additional matching keys (margin no. 71) – list the invoice numbers.
- Payment provider payouts. Stripe, PayPal, card terminals and marketplaces pay out batched sales minus fees. The settlement report is the document; book the gross sales and the fee as a separate expense – a split booking. For card terminal payouts see Kartenzahlungen zuordnen (in German).
- Foreign currency. The invoice says USD 49.00, the debit EUR 45.87. Check the original amount and sanity-check the rate; the exchange difference is not a missing document. The GoBD count “currency and exchange rate” as document content (margin no. 77).
- Refunds and credit notes. Money back from a supplier needs the credit note or corrected invoice, linked to the original. The input VAT is corrected accordingly (Section 17 UStG).
- Returned direct debit. Link the debit and its return as a pair – reversals must be traceable to the original booking (margin no. 64). The invoice goes with the payment that finally clears.
- Early-payment discount. You pay 2% less than the total. The invoice with the discount terms is the document; book the difference as a discount and reduce the input VAT proportionally.
- Credit card statement. One debit, thirty purchases behind it. The debit gets “no invoice – card statement”; the receipts go on the individual card transactions. Treat the card as an account of its own.
- Tips. The card payment is higher than the restaurant bill. The difference is the tip; note it on the receipt.
The reconciliation workflow, step by step
- Pull all transactions. Current accounts, credit cards, PayPal and payment providers, by bank connection or CSV export.
- Mark no-invoice transactions first. Transfers, taxes, salaries, owner withdrawals, card settlements: set status and reason.
- Tick off clear cases. Exact amount, counterparty in the bank text, date in the window, only one candidate.
- Resolve ambiguous cases. Invoice number and service period decide.
- Apply the edge-case rules.
- Chase missing documents in a fixed order. Mailbox including archive and spam (see automating Gmail invoice collection), supplier portal, a request to the supplier, and only then a self-issued substitute receipt. For link-only invoices, see invoice only available as a download link.
- Check the other direction. Invoices without payment are not yet due, paid from another account or duplicates – see preventing duplicate invoices.
- Update the exception list: next step, owner, date.
- Hand over documents, statuses and reasons in one package: organize invoices for your accountant.
Cadence, exception list and two KPIs
Weekly beats monthly beats year-end. After a week you still know what the EUR 23.80 at an unknown merchant was, and the supplier still replies. After eleven months you are digging through an old archive.
The GoBD ask for timely records too: every transaction is to be recorded as soon as possible after it occurs, and collecting receipts only to book them much later contradicts proper bookkeeping (margin no. 46). Recording non-cash transactions within ten days is considered unobjectionable (margin no. 47) – a weekly reconciliation fits comfortably.
Keep an exception list of everything not yet attached or justified – date, amount, counterparty, status, next step, owner, due date – and track two KPIs:
- Document rate: the share of transactions with a document or a justified “no invoice”. Aim for 100% before handover.
- Age of open cases: how many are past 30 days, how many past 90? Anything past 30 days needs a next step; follow up on requests after a week.
Why the payment–invoice link must be traceable
If you keep books in Germany, reconciliation isn't optional. Section 145(1) AO, the German Fiscal Code, requires that business transactions can be traced in their origin and their settlement: the invoice documents the origin, the payment the settlement, and reconciliation is the link. Section 146(1) AO adds that entries must be individual, complete, correct, timely and orderly. The GoBD, the finance ministry's rules for proper digital bookkeeping (in German), make this concrete:
- Voucher principle (margin no. 30): every entry must be backed by a document, or it must be possible to provide one.
- Voucher function (margin no. 61): every transaction needs a document; without a third-party document, a self-issued one must be created.
- Auditability (margin nos. 32–33): an auditor must be able to trace each transaction from document to tax return and back, throughout the retention period.
- Matching keys (margin nos. 71–74): links need unique identifiers such as a document ID; a bank statement number without page and line number is not enough.
Invoices and other accounting vouchers are kept for eight years, books and records for ten (Section 147(3) AO), and the audit trail must survive that whole period (margin no. 35). A match that only lives in your head doesn't. Outside Germany, check your local rules: the principle is common, the details differ.
Tools: spreadsheet, accounting software, AI agent
Bank CSV and a spreadsheet
Export your transactions as CSV into a “Transactions” sheet (date, amount, counterparty, reference, status, file name, reason) and list documents in an “Invoices” sheet (date, amount, supplier, invoice number). A helper column with =COUNTIFS(Invoices!B:B, ABS(B2)) counts invoices with the same amount (ABS because debits are negative in the CSV): 0 means missing, 1 means check the candidate, 2 or more means ambiguous. The limits: you still find every document yourself, partial payments, batch transfers, foreign currency and tips break the formula, and the link to the PDF is just a file name.
Accounting software
Most accounting software matches transactions to documents and open items already recorded and suggests matches. If the invoice isn't in the system, the transaction stays open.
AI agent
An agent such as belege.ai treats your bank transactions as the to-do list and looks for each payment's invoice in connected mailboxes and supplier portals. Clear cases – amount exact to the cent, booking within a few days, vendor name in the bank text, only one candidate – are matched directly. Everything else goes to an AI comparison with a wider date window, up to about a year back for late payments when amount or vendor match exactly. It verifies before assigning: the amount must appear in the document, foreign-currency amounts must fall within a tolerance around the ECB rate, restaurant tips are accepted, and a different invoice number in the reference means no match.
It handles down payments and final invoices, partial invoices, one invoice paid in several payments, several invoices paid in one payment, recurring invoices and gross-minus-fee settlements; Stripe, Mollie, Shopify and PayPal payouts are reconciled separately. When no document turns up in uploads, the vendor's history, mail, links or portals, it asks you in Telegram – telling paper and digital receipts apart and bundling small, old items into one question. If an invoice simply isn't issued yet, it waits. A substitute receipt is only created with your explicit OK.
Checked matches need no mandatory approval step, and the export shows a status for every transaction. It isn't 100% automatic, but only the cases it can't close on its own reach you. More on matching receipts to transactions and the proactive agent.
Common mistakes
- Working from the inbox instead of the account – documents that never came by email stay invisible.
- Matching on amount alone – with same-price subscriptions, invoices land on the wrong month.
- Smoothing over differences instead of naming them: discount, exchange rate, tip, fee.
- Reaching for a substitute receipt too early – it costs the input VAT deduction; search and ask first.
Checklist for every reconciliation
- All accounts and payment methods are imported.
- Every transaction has one of the four statuses; every “no invoice” has a reason and proof.
- Matched documents add up to the payment; differences are explained.
- Open cases older than 30 days have a next step; duplicates are marked.
- The current state is with your bookkeeper or tax advisor.