Catch-weight invoice reconciliation for restaurants: pay for the weight received

Variable-measure purchasing is a data problem before it is a maths problem. The order may say cases while the invoice says kilograms. The receiving team may record a weighed amount that differs from a nominal pack description. A supplier’s item master may carry a trade-item identifier, while a local system uses an internal code. Those records can be linked, but they should not be flattened into one number. GS1’s GDSN Trade Item Implementation Guide, Release 35, includes guidance for variable measure and net-content data. GS1’s meat and poultry traceability guidance describes identifying products and batches and connecting information across trading partners, while also directing users to country-level and trading-partner requirements. Use these references to structure your data, then apply the agreement and procedures that govern your operation.

Start with the order unit and the invoice unit

Open the purchase order, delivery record, product specification, and invoice together. Capture the order quantity and unit exactly as issued: cases, trays, cartons, bags, pieces, or another unit. At receiving, record what arrived physically and what was accepted. If the item is sold by actual weight, capture the weight, the UOM code or description, the measurement method, and the line reference. On the invoice, record the billed quantity, billed UOM, price per UOM, and extended line amount. This does not mean every difference is wrong. A contract may define a price basis, tolerance, minimum, or conversion. The reviewer’s job is to compare the recorded facts with that basis, not to assume that a case has a standard weight.

• Preserve the supplier’s product and pack description beside the internal product identity so a similar name cannot hide a different item.
• Use one receipt and invoice line reference across scale ticket, photograph, batch record, purchase order, and correspondence.
• Record tare, packaging, or other measurement inputs only when they are part of your approved weighing method; do not invent a correction.
• Distinguish actual received weight from an estimated weight, a nominal label value, a contract allowance, and the invoiced weight.
• Ask the local finance or procurement owner how rounding, tax, credits, and price adjustments are recorded in your system.

Reconcile weight, price basis, and traceability

Once the units are aligned, compare the actual measured quantity with the invoiced quantity in the same UOM. If the invoice is in kilograms and the scale record is in pounds, use a conversion that your operation has approved and preserve both original values. Do not turn a measurement difference into a price claim until product identity, specification, batch or lot, measurement method, and agreement are confirmed. For meat and poultry or other traceability-sensitive goods, link the relevant identifier or batch information through receiving and invoice review as your process requires. GS1’s traceability guideline explains that traceability depends on identifying items and associating critical information across the chain; it also cautions users to understand local and trading-partner requirements. Traceability and financial reconciliation support each other, but neither source decides your local legal or tax treatment.

Clearly labeled illustrative example: cases, actual weight, and invoice

A repeatable catch-weight reconciliation process

1. 1Identify the trade item. Link product identity, specification, pack or case description, order line, supplier reference, receipt, and batch or lot context before comparing quantities.
2. 2Record the physical receipt. Count cases or packages, weigh or measure according to the approved site method, record UOM and evidence, and mark accepted, held, or rejected quantity.
3. 3Read the invoice basis. Capture invoiced quantity, UOM, unit price, extension, discounts or adjustments, tax fields, and invoice line reference without converting away the source values.
4. 4Align and calculate. Use an approved conversion when needed, show original and converted units, compare actual and invoiced amounts, and explain rounding or allowance rules.
5. 5Review the exception. Assign an owner to identity, specification, measurement, price, traceability, or document questions. Link scale evidence, supplier communication, and purchase records.
6. 6Resolve and close. Record accept, correct, credit, dispute, or other local disposition, update the payable record and traceability links, and close only when evidence supports the decision.