A supplier invoice can be arithmetically correct and still differ from the approved order or accepted receipts. The rate may have changed, the quantity may include goods already billed on an earlier invoice, or a short delivery may remain unresolved. Reconciliation makes those differences visible before the authorised payment decision.
This guide covers one narrow job after goods have been received: comparing a single invoice goods line with its approved order line and the receipts that line can still draw on. It does not cover choosing suppliers, checking goods at the door or forecasting cash. The figures are an original fictional example, not a benchmark, an acceptable variance or a payment rule.
Fix the scope before comparing anything
Write down exactly which document you are reconciling: supplier, outlet, invoice reference and date, and the as-of cutoff for the receipts you will count. Then identify the approved order line and its revision, the item and its precise specification, the unit and the currency. A revised order with a new rate is a different comparison from the original one.
Agree the price basis. This guide compares net goods value only: quantity multiplied by an effective price per unit, after any line discount that has evidence behind it. Taxes, delivery charges, packaging fees and invoice-level discounts are left out of the calculation and recorded separately with their own references. Mixing a tax-inclusive invoice price with a tax-exclusive order rate will produce a difference that says nothing about what the supplier charged for the goods.
Build the receipt pool once
The receipt pool is the quantity your team accepted against this order line up to the cutoff, less any returns that are supported by evidence. Link each receipt reference explicitly; do not assume that every delivery from the supplier that month belongs to this line.
Next, find every earlier invoice that has already drawn on the same pool, net of quantity credit notes allocated to that same pool. A credit note that only reduces money, without changing billed quantity, does not make goods available to invoice again. If earlier invoices exceed accepted receipts, stop: the pool itself needs reconciling before the current invoice can be assessed. Each receipt and each prior invoice should be counted once, in one pool only.
Worked example: one invoice line
In this fictional case, an outlet accepted 60 kg of an ingredient against one approved order line, with no evidenced returns. Earlier invoices, net of quantity credits allocated to this line, have already billed 40 kg. That leaves 20 kg available to invoice. The current invoice bills 24 kg at an effective INR 105 per kg, and states a net goods line of INR 2,520. The approved effective price is INR 100 per kg.
The reference quantity is the smaller of the invoiced quantity and the available quantity: 20 kg. At the approved price, that supports a reference goods value of INR 2,000. The stated line is INR 520 above that reference, and 4 kg of the invoiced quantity has no available receipt to match against.
| Fictional invoice line | Value | Note |
|---|---|---|
| Accepted receipt pool | 60 kg | Net of evidenced returns, to the cutoff |
| Prior invoiced quantity | 40 kg | Net of quantity credits allocated to this pool |
| Available to invoice | 60 − 40 = 20 kg | Withheld if prior exceeds accepted |
| Current invoice | 24 kg × INR 105 = INR 2,520 | Stated net goods line |
| Reference quantity | min(24, 20) = 20 kg | Unmatched quantity 4 kg |
| Reference goods value | 20 kg × INR 100 = INR 2,000 | At approved effective price |
| Stated minus reference | INR 520 | To investigate, not to deduct |
Separate price, quantity and arithmetic differences
A single total hides what went wrong. Break the INR 520 into three parts that can each be checked. The price effect is the invoiced quantity multiplied by the price difference: 24 × (105 − 100) = INR 120. The quantity effect is the unmatched quantity at the approved price: 4 × 100 = INR 400. The arithmetic difference compares the stated amount with invoiced quantity multiplied by invoiced price: 2,520 − (24 × 105) = INR 0. Together they make INR 520.
Each part points to a different conversation. A price effect asks whether the order was revised or the wrong rate was billed. A quantity effect asks whether a receipt is missing from the pool, goods were billed twice or the delivery was genuinely short. An arithmetic difference asks whether the invoice was calculated correctly. Look at each one on its own terms. If the invoiced price were below the approved price, the negative price effect would not cancel the unmatched quantity; the 4 kg would still need an explanation.
The worksheet rounds monetary results to two decimals. It also shows a rounding residual so the displayed price, quantity and arithmetic effects reconcile to stated goods amount minus reference value. That residual is zero in this example. Keep the original quantities and effective unit prices at their supported precision; use a suitable model if the documents require a different monetary precision.
What the result does not decide
None of these figures is an amount that is payable, approved, recoverable from the supplier or saved. They describe a gap between documents. The reconciliation applies no automatic tolerance, so a small difference is still shown and still needs a decision by someone with the authority to make it.
This guide also makes no claim about whether payment of any part of an invoice may lawfully be withheld. Agree with the supplier and your accounts adviser how disputed amounts are handled under your terms. Keep the original invoice exactly as received; never edit it to make a difference disappear. A corrected invoice or credit note is a new document with its own reference, linked to the original.
Duplicates, partial receipts and pending credits
Before reconciling, check whether the same invoice has already been recorded: compare supplier, invoice reference, date and amount, and look at the supporting records rather than relying on one field. Where an order line arrives in several deliveries and is billed on several invoices, include each receipt and each earlier invoice exactly once in the same pool.
Keep credits that are promised or issued against the current invoice in a separate record. Do not quietly net them into the original invoice line, because the reconciliation then shows a smaller difference than the documents actually contain. A credit that cannot be allocated to a pool, or a return the supplier disputes, needs manual investigation before it changes any quantity.
Record the resolution and the payment decision
For each open line, record the agreed resolution, its owner, the reference of the source or corrected document and how the outcome was verified. Then record the payment decision separately, with the name of the person authorised to make it. Keep the exception visible until both steps are complete; a resolved line with no recorded payment authority is still unfinished.
Review the pattern over time as well as each line. Repeated quantity effects from one supplier may point to a receiving gap; repeated price effects may mean order revisions are not reaching the person who checks invoices. Treat those as questions for the relevant process owner rather than conclusions about the supplier.
Where the principle comes from
Microsoft's accounts payable documentation describes the general practice of comparing an invoice's price with the approved purchase order and its quantity with the receipts selected for it. Only that general comparison is used here. Its software settings, tolerance policies, examples, charge and tax handling are not applied, and nothing in this guide describes a feature of any particular system.
Put it into practice
Your action checklist
Your progress saves in this browser. No sign-up needed.
0 of 9 complete
From reading to doing
Supplier invoice line reconciliation
The Invoice Reconciliation worksheet takes six numeric inputs for one invoice goods line: accepted receipt pool, prior invoiced quantity, current invoiced quantity, invoiced effective price, approved effective price and the stated net goods amount. Two Yes confirmations record that unit, currency and net-goods basis match and that supporting documents are reconciled, with document and basis references. It then shows available quantity, reference quantity, unmatched quantity, reference goods value, stated minus reference, and the price, quantity and arithmetic effects, with money rounded to two decimals and a separate rounding residual. Outputs are withheld when an input is missing, text or negative, the stated amount has more than two decimal places, the current quantity is not above zero, prior invoicing exceeds accepted receipts, a confirmation is not Yes or a reference is blank. Manual sections record scope, receipt and credit allocation, duplicate checks, resolution, verification and the authorised payment decision. It applies no tolerance and does not model taxes, charges or accounting entries.
Open the Invoice Reconciliation tab in the launch workbook. Keep a copy for your own business.
Download the free workbook See what’s inside the toolkit →Sources & further reading
- Accounts payable invoice matching overview (Microsoft Learn) ↗
Page updated 15 May 2025, retrieved 8 November 2026. Used only for the general concept of comparing invoice price with the approved order and invoiced quantity with matched receipts. Software settings, tolerance policies, source examples, charge, tax and payment rules are not applied, and no integration with any system is implied. All figures here are original fiction.
Published by Keystonne Grow. Product links connect to the Keystonne ecosystem; check the linked product or service for its current scope.