Invoice reconciliation: how to reconcile supplier invoices, step by step

Most overpayments to suppliers aren't fraud. They're a bill entered twice, a price that crept up, a credit note nobody applied, or a payment the supplier never matched to the right invoice. Each one is small, and each one is easy to miss when invoices, orders and payments sit in different places.

Invoice reconciliation is how finance teams catch them. This guide explains what it is, the checks involved, how to reconcile supplier invoices step by step, and how to automate it, using one illustrative supplier statement that balances to the dollar.

What is invoice reconciliation?

Invoice reconciliation is the process of checking supplier invoices against the records that support them, and confirming that the amounts agree. Those records are the purchase order, the receipt of goods, the agreed price, the payments already made and the supplier's own statement of what you owe. Where something doesn't agree, the difference is explained, corrected and recorded before the books are closed. The same idea on the customer side is usually called billing reconciliation.

The four checks in invoice reconciliation

• Invoice to order and receipt: you're billed only for what you ordered and what actually arrived.
• Invoice to agreed price: unit prices, discounts and terms match the order or contract.
• Invoice to payment: every invoice is paid once, for the right amount, with any exchange difference or fee explained.
• Your books to the supplier's statement: what you think you owe agrees with what the supplier thinks you owe.

The first check is three-way matching, which happens before an invoice is approved. Our guide to three-way matching covers it in detail. This guide focuses on the full reconciliation, including the checks that only make sense after money has moved.

How to reconcile supplier invoices, step by step

1. 1Gather the records. Pull the supplier's open invoices from accounts payable, the payments made to them, their latest statement, and the orders and receipts behind each invoice.
2. 2Match each invoice to its order and receipt. Confirm quantity, unit price and total agree. Hold anything that doesn't.
3. 3Check prices against what was agreed. Compare each line with the order or contract price, including discounts, so price creep is caught rather than paid.
4. 4Match payments to invoices. Make sure each invoice was paid once, that the payment reference names it, and that any exchange difference or bank fee is recorded.
5. 5Compare your balance with the supplier's statement. List every line that appears on one side and not the other, or at a different amount.
6. 6Explain, correct and sign off. Record what belongs in your books, ask the supplier to fix what belongs in theirs, keep the evidence, and have someone approve the result.

A worked example: reconciling a supplier statement

The statement pictured above is from Ridgeline Supply, an illustrative supplier, at the end of October. The statement says you owe $21,750. Your accounts payable ledger says $14,600. That leaves $7,150 to explain.

1. 1A bill you haven't recorded. RS-3319 for $2,750 is on the statement but not in your books. The goods arrived at month-end and the bill hadn't reached you. It matches order PO-2112 and its receipt, so you record it.
2. 2A credit note you haven't recorded. The supplier issued CN-142 for $900 after a delivery was returned. You check it against the return and record it, which lowers what you owe.
3. 3A payment the supplier hasn't applied. RS-3298 for $5,300 still shows as open on the statement, but you paid it on 31 October. It's a timing difference on the supplier's side, so nothing changes in your books.

After the two corrections, your books show $16,450. Take the payment still in transit off the supplier's $21,750, and their figure is $16,450 too. Every dollar of the $7,150 difference is explained, and the reconciliation can be signed off.

The payment check works the same way for a single invoice. Bill #A-311 from Alder Tech GmbH was booked at $9,720, and $9,780 left the bank. The $60 difference is a $45 exchange loss and a $15 payment fee, both recorded, so the supplier's balance is $0. Our guide to transaction context follows that payment from order to close.

Common invoice discrepancies and their causes

• Duplicate invoices: the same bill sent twice, or resent with a new number, and entered both times.
• Price differences: a unit price above the order or contract, or a discount that wasn't applied.
• Quantity differences: billed for more than was delivered, often after a short or split delivery.
• Unapplied credit notes: a credit was issued but never used against a later invoice.
• Unapplied or misapplied payments: the supplier received the money but matched it to the wrong invoice, or not yet.
• Timing differences: an invoice or payment that's in transit at month-end and appears on only one side.
• Exchange rates and fees: a foreign-currency invoice settles at a different rate, or a bank fee reduces the amount received.

What to do when the numbers don't match

• Decide whose records need to change before changing anything: yours, the supplier's, or neither.
• Never post an adjustment just to force the balances to agree. An unexplained difference is a question, not an answer.
• Ask the supplier for a corrected invoice or a credit note when they billed too much.
• Record each correction with its reason and the documents behind it, so an auditor can follow it.
• Carry timing differences forward and check they clear on the next statement.

Why it matters to a CFO

• You pay each invoice once, at the price you agreed.
• The accounts payable balance in the books is right when the month closes.
• Unused credits and past overpayments are found and can be claimed back.
• Cash forecasts are built on what you really owe, not on unreconciled balances.
• Supplier relationships stay good, because disputes are settled with evidence rather than argued from memory.
• Every correction has a reason and documents behind it, ready for review or audit.

How to automate invoice reconciliation

Reconciliation is slow when someone has to collect the order from one tool, the receipt from an email, the invoice from an inbox and the payment from a bank portal. Automation works when those records are already together. When evaluating software, look for:

• Orders, receipts, invoices and payments recorded in one place, so each invoice is checked as it arrives.
• Duplicate and price checks that run before payment, not after.
• Payments matched to invoices with the exchange rate and fees recorded, so the supplier's balance clears exactly.
• Reviews of payments already made, to find duplicates and unused credits.
• Every exception shown with its evidence, its decision and who approved it.

What changes on one system

Most reconciliation work is gathering records that were split across systems. When purchasing, invoices, payments and the books run as one system, the order, receipt, agreed price and payment are already attached to each invoice, so the checks run as invoices arrive and only real differences reach a person. At month-end, the balance you compare with the supplier's statement is already right. See how it works on the Accounts Payable and Procurement pages.