Food traceability/Supplier cost control

Restaurant invoice reconciliation: match the receipt before the total

Compare one order, actual receipts and invoice amounts without counting freight twice.

Restaurant operator comparing two paper delivery and invoice documents beside produce crates and a receiving scale.

At a glance

Match supplier, item, unit and accepted receipts before comparing the invoice total with the agreed cost. Keep price differences separate from quantities not yet received. A discrepancy is a question to investigate, not an automatically recoverable credit or measured saving.

Build the three-document record

Collect the approved purchase order, receipt evidence and supplier invoice for the same site and item. Preserve their references, dates, base unit, currency and agreed price. An ordered quantity is not proof of delivery. Use a consistent tax basis; the fictional example below excludes tax and does not prescribe statutory accounting or payment decisions.

BCcampus · Basic Inventory Procedures · English

Example record and review decision

Fictional order PO-01 is for 10 kg at 4 monetary units per kg, plus a delivery charge of 10. Receipt REC-01 accepts 6 kg. Invoice INV-01 bills those 6 kg at 4.5 plus the full delivery charge: 6 × 4.5 + 10 = 37. Under the explicitly defined first-invoice matching basis, the expected amount is 6 × 4 + 10 = 34. The difference is 37 − 34 = +3. Record a price question for review rather than changing the received quantity to hide it.

Carry delivery charges only once

After the remaining 4 kg actually arrives as REC-02, a second invoice at the agreed price is 4 × 4 = 16, with no second delivery charge. Expected amounts total 34 + 16 = 50; invoiced amounts total 37 + 16 = 53. The combined difference remains +3. This is the current Kivloo invoice-matching basis, not a universal supplier billing rule. Receiving allocates freight per ordered unit into stock cost separately; do not substitute that landed-stock figure for this invoice comparison.

Stop a quantity mismatch first

As an alternative case, suppose an invoice claims 10 kg while only 6 kg has been received. The unmatched quantity is 4 kg. Resolve the receipt, document or billing question before treating the amounts as comparable. Kivloo blocks cumulative invoiced quantities above recorded receipts. Do not create a false receipt, duplicate the first invoice or describe unreceived stock as consumed.

Use a record that another person can reconstruct

The localized CSV includes the first invoice, the later receipt/invoice, an alternative quantity mismatch and a genuinely blank record. It stores values, not automatic formulas. Recompute after edits and keep unknown amounts blank. The quantity-mismatch row deliberately has no calculated comparable difference. Attach the evidence and assign an owner; distinguish an investigated discrepancy from an approved supplier correction.

Check Kivloo’s actual matching boundary

Kivloo’s current procurement beta uses manual web invoice review against a received approved order. It rejects duplicate references for the same supplier and displays the recorded cost difference. The full order delivery charge is included on the first invoice match only. Setup requires the web and an active connection; scanning is a separate reviewed workflow. Internal approval does not send an order to a supplier, and the tool does not promise automatic credit recovery or margin uplift.

Kivloo · Procurement beta · English

Restaurant invoice reconciliation: match the receipt before the total

Fictional worked example

InvoiceQuantity kgExpected amountInvoiced amountDifferenceReview
INV-0163437+3Investigate price
Invoice
INV-01
Quantity kg
6
Expected amount
34
Invoiced amount
37
Difference
+3
Review
Investigate price

Your record

Download the reconciliation CSV

A few useful answers

Is the +3 a saving?

No. It is a fictional amount above the agreed matching basis. Evidence, review and any supplier correction are separate.

Does the CSV recalculate?

No. It contains worked values and a blank row; recalculate and check quantity, freight and totals after editing.

Sources and further reading

Markdown

Explore starter templates

Start with a useful checklist

English