Reconcile Supplier Invoice Lines with What the Business Actually Received

A supplier invoice is not proof that the right quantity of goods arrived. It records what the supplier seeks to charge, while a purchase order records the buyer's accepted commitment and the warehouse receipt describes goods physically observed. Reconciliation becomes important when these three records diverge: an invoice charges twelve cases but only eleven were received; a supplier prices items individually while the buyer ordered multipacks; or a substituted model appears on an invoice without agreed approval. For a UK trading SME, a reliable process matches the documents at line level before paying or changing stock values.

This guide distinguishes commercial, physical and tax evidence. HMRC publishes requirements for VAT invoices and records, while GS1 standards help distinguish trade-item and packaging identities. Neither determines the facts of an individual shipment. The business must preserve its original orders, supplier communications and actual receiving records. The objective is a clear exception that someone can investigate, not an automatic adjustment that forces three numbers to agree.

Establish the three records and their owners

Start with the accepted purchase order, the actual warehouse receipt and the supplier invoice. Link all three using stable references and product lines. The purchasing team owns the commercial order, receiving records physical events, and finance assesses the invoice and relevant tax treatment. One employee may cover several functions in a small firm, but the underlying evidence remains distinct.

The purchase order should identify supplier, item, variant, ordering unit, quantity, agreed price and relevant terms. The receipt should show what arrived, including actual pack level, condition and any restricted stock. The invoice should state what is being charged and point to the relevant purchase or shipment. An invoice can be formatted correctly yet contain a product or quantity discrepancy requiring commercial review.

Do not rewrite the accepted PO to match a surprise invoice. Historical truth matters when a supplier disputes the price or the warehouse later finds missing goods. Record an amendment as an approved new event, with its source and date, rather than erasing the first agreement.

Match exact product identities rather than similar descriptions

A supplier may use a manufacturer code different from the business's internal SKU. Maintain an approved mapping and compare the precise variant, revision and package. Two cables described as compatible with one device family may differ in length, electrical capability or included accessory. A supplier's replacement model is not automatically the product the buyer agreed to receive.

Check any trade-item identifiers at the correct physical level. GS1's GTIN guidance describes product and packaging identities. A case code and an individual-unit code are not interchangeable solely because the same brand appears on the label. The invoice's supplier reference needs a documented relationship with the PO line and physical receipt.

When a discrepancy is material, hold that line for review. Other independently correct invoice lines may continue through an authorised process, depending on the company's controls. Do not allow pressure to settle the entire invoice to disguise a wrong-model delivery.

Convert cases, packs and individual items carefully

Quantity mismatches are often unit mismatches. One supplier case may contain four inner packs of six individual items. An order for two such verified cases equals forty-eight individual pieces. But if an invoice line says '48' without a unit, it cannot be assumed to mean forty-eight cases or forty-eight eaches. Identify the quoted and invoiced levels and their actual conversion from source evidence.

For mixed cartons, list the composition by individual SKU. A box containing assorted colours cannot be posted entirely against one variant. A case with incomplete contents needs an actual receipt count and shortage record, not a full expected increment followed by an arbitrary stock reduction.

Keep conversion versions where suppliers revise packaging. A shipment under an older case specification may coexist with a newer purchase agreement. Recalculating old receipts using the latest conversion can create a fictitious imbalance. Preserve which physical pack and quantity applied to the actual transaction.

Examine partial deliveries without inventing shortages

An invoice may cover the whole accepted order while goods arrive in two instalments. Alternatively, the supplier may issue separate invoices as each shipment leaves. Match dispatch references and goods-received events before classifying a missing balance. A carrier's delivered status does not prove all cartons were included or that every item was released for sale.

For example, if an order requests one hundred pieces and sixty verified pieces arrive first, record the sixty actually received and the outstanding forty under the applicable supplier agreement. Do not create the remaining forty as stock because the invoice charges one hundred. If a second delivery later arrives, receive it under its own reference and link it to the original order.

Where goods are damaged or quarantined, physical presence and unrestricted availability are different. The warehouse can record received units while restricting their use. Finance must not assume that a supplier allowance automatically resolves the physical disposition.

Compare the invoiced commercial terms with the approved offer

Reconcile unit price, currency, quantity discount, freight, relevant charges and applicable tax information. An apparently lower price may apply to a different quantity or delivery arrangement. A supplier may add a surcharge not present on the accepted quotation. Do not settle a difference solely by changing an internal product cost to the supplier's latest list price.

Record whether terms were actually amended and by whom. A purchasing colleague's request for a discount does not establish the supplier agreed it; a supplier quotation does not automatically amend an issued PO. The invoice comparison should point to the relevant accepted agreement.

Where accounting or tax treatment is uncertain, escalate to an appropriately competent finance reviewer. The GOV.UK invoice guidance describes information invoices must contain; it is not an instruction to approve any amount appearing on a correctly formatted document.

Keep VAT evidence and stock transactions separate

HMRC's VAT record-keeping guidance provides relevant UK record context, while the actual transaction and current law determine what documentation or adjustments are appropriate. A credit note may correct commercial value without any new physical stock movement. Conversely, a shortage identified during receiving does not by itself demonstrate that the supplier has issued an agreed credit.

Reconcile a credit against the original invoice and affected line. Record a supplier claim, issued credit and actual financial posting as separate stages. If products were returned, link a genuine warehouse dispatch and any carrier evidence. If the supplier allowed a lower price for goods retained, do not invent a return transaction simply to balance the invoice.

Keep the units and value visible side by side. One problem can require both a stock correction and a financial adjustment, but these should follow their own evidence and authority. A system that automatically reduces stock every time a credit is posted can produce serious errors.

Design exceptions with a usable next decision

Useful mismatch categories include wrong SKU, unexpected substitution, quantity difference, pack conversion, invoice price, freight or tax discrepancy, duplicate invoice and unexplained credit. The category should lead to a named owner and an answerable question. 'Invoice does not match' alone is insufficient for a supplier enquiry.

For every affected line preserve original PO value, invoice value, receipt value, discrepancy, current evidence, proposed resolution and approval status. An unresolved invoice can remain pending without implying the supplier is necessarily at fault. The buyer's incorrect order, missing receipt event or misconfigured conversion may explain the issue.

Protect against duplicate processing following an integration timeout. Before resubmitting an invoice or adjusting stock, inspect actual prior postings using stable references. A timeout on the screen does not establish that the original transaction failed.

Close the case when each system reflects the real event

After investigation, confirm the actual product and quantity, agreed price and terms, appropriate tax documents and stock disposition. If a correction is required, record who authorised it and which original transaction it changes. Avoid changing earlier records in ways that hide the difference between what happened and what was later agreed.

Use representative sample cases to test the workflow: an ordinary matched order, a partial delivery, a changed case pack, a wrong variant and an invoice with an unauthorised surcharge. Staff should be able to reconstruct the events without relying on private email recollection.

A good reconciliation is not a demand that every number be identical. It explains why the purchase commitment, physical receipt and invoice either agree or differ, and it records the appropriate response. Start with one disputed supplier line, identify its exact item and unit, then trace the approved commercial and physical facts before posting an adjustment.