Most invoice errors are caught by boring, consistent checks done in the same order every time.
Process every invoice through the same sequence: receive it through one channel, confirm the supplier is on the approved master file, check the invoice is valid and addressed to your entity, test for duplicates, match it to the order and receipt, code it, get approval from someone with authority, and schedule payment only to bank details already verified on the supplier master.
Before entry, check whether the same invoice has already been recorded. In an Excel invoice log with supplier in column A and invoice number in column B:
=COUNTIFS(A:A,A2,B:B,B2)>1
Exact matching misses the common variants: "INV-0123" against "123", or the same amount and date with a different number. Clean the invoice number before matching and run a second test on supplier, amount and date. Finding duplicate invoices in Excel covers the tests in detail.
Sample a few processed invoices each month and test them against every step. Where a step was skipped, find out why: usually the process is unclear or the volume is too high, and both can be fixed. Update the checklist whenever a new type of error or fraud attempt gets through.
UK teams usually say "supplier" and "purchase ledger"; US teams say "vendor" and "AP". Tax details on an invoice depend on the regime (VAT in the UK, sales and use tax in the US). Check HMRC or the relevant US state guidance for current invoice content requirements.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Supplier on the master file, correct legal entity, invoice number and date, description, amounts and tax details, a duplicate check, a match to the order and receipt, correct coding, and approval by someone with authority.
No. Pay only to bank details held on the supplier master file. Different details on an invoice are a change request that must be verified independently using a contact number you already hold.
Run a duplicate check before entry, on both the invoice number and a combination of supplier, amount and date, and review the payment run for repeated amounts before release.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.