Skip to content
Resources
Supplier management

Supplier statement reconciliation for restaurants: explain every open balance

A practical month-end control for comparing supplier statements with invoices, credits, payments, receipts, and unresolved disputes.

Statement reconciliation is an external-to-internal control. The supplier’s document helps identify what the supplier believes is open, while the restaurant’s ledger and receiving records show what has been received, approved, paid, credited, or disputed. Preserve both views. A matching engine can speed up obvious references, but a missing invoice number, a credit applied to the wrong document, a payment allocated to the wrong account, or an amount in another currency still needs a reasoned review. Do not change the ledger merely to make the statement total agree.

Set the scope and identity before matching lines

Check supplier legal identity, account number or reference, statement date, covered period, currency, opening balance, transaction range, and closing balance. Confirm whether the statement covers one entity, site, account, or trading relationship. Similar supplier names and consolidated statements can hide a scope error. Preserve the source file or image and record how it arrived. If the statement is incomplete or the period is unclear, mark that limitation before calculating a conclusion. Where a supplier uses credits, rebates, deposits, or multiple currencies, identify those conventions up front so an apparent difference is not assigned to the wrong category.

  • Keep statement line text, date, reference, debit or credit sign, amount, and running balance as source fields.
  • Use the restaurant’s invoice, credit, payment, receipt, contract, and dispute references as linked evidence, not replacements for the statement.
  • Check opening balance to the prior reviewed closing balance and explain any carry-forward difference before matching the current period.
  • Separate posted payment, bank-cleared payment, supplier allocation, and unapplied cash when those states differ in your process.
  • Protect account and payment data in access-controlled records and avoid copying full bank identifiers into general comments.

Explain differences instead of forcing a clean total

A difference is useful when it has a category, evidence, owner, and expected next step. A statement invoice with no ledger match may be a missing document, a wrong account, a duplicate, or a supplier error. A ledger invoice absent from the statement may reflect timing or a statement scope issue. A credit can be received but not allocated; a payment can leave the bank but remain unapplied by the supplier. For disputed quantity or price, link order and accepted receipt and keep the dispute open. For currency differences, show the source amount and the conversion basis separately. Do not label a difference as resolved because an approximate amount closes the arithmetic gap.

Clearly labeled illustrative example: a statement with reconciling items

Illustrative operator-entered supplier statement reconciliation

A restaurant enters this example to test its schedule. Every amount, date, reference, currency, status, and conclusion is illustrative and operator-entered; none is a supplier fact, payment demand, customer outcome, saving, credit guarantee, or accounting result. Replace all fields with the real statement, ledger, bank evidence, receipts, supplier documents, and local review.

Statement openingIllustrative operator-entered: statement opening balance €1,240.00 for an operator-defined period and account referenceIllustrative amount and scope; not a supplier balance
Matched invoicesIllustrative operator-entered: two statement invoices of €420.00 and €310.00 link to ledger, order, and accepted receipt recordsIllustrative matches; verify each source
Unapplied paymentIllustrative operator-entered: €250.00 payment appears in bank evidence but supplier allocation remains openIllustrative reconciling item; do not invent allocation
Credit under reviewIllustrative operator-entered: €80.00 supplier credit is present in the ledger but not on the statement and is assigned to follow-upIllustrative difference; retain the credit source
ConclusionIllustrative operator-entered: balance is not marked fully agreed; matched lines are accepted and payment or credit items remain openIllustrative status; not payment or tax approval

The illustrative operator-entered schedule keeps matched items, an unapplied payment, and a missing statement credit visible instead of forcing one total. Values, references, currency, timing, and conclusion are examples only.

A repeatable supplier statement reconciliation process

  1. 1Capture the statement. Save the source document, supplier identity, account reference, period, currency, opening balance, lines, and closing balance.
  2. 2Confirm scope and carry-forward. Check entity, site, account, covered dates, statement conventions, and the prior reviewed closing balance before current matching.
  3. 3Match source lines. Link each invoice, credit, payment, receipt, dispute, and adjustment to statement and restaurant evidence without replacing source text.
  4. 4Classify reconciling items. Label missing, duplicate, unapplied, unallocated, timing, currency, quantity, price, or scope differences and assign an owner and due date.
  5. 5Review and conclude. Have a reviewer assess evidence, access, currency, and unresolved exposure and record agree, hold, dispute, or escalation.
  6. 6Follow up and archive. Track open items to the next statement or response, preserve the reconciliation version, and document changes without deleting history.

FAQ

Does a supplier statement prove what the restaurant owes?
No. It is an important external record to compare with invoices, receipts, credits, payments, disputes, and the restaurant’s ledger. Differences need evidence and an explanation; do not copy the closing balance without review.
Should the statement total be reconciled first?
Start with identity, period, currency, opening balance, and then line-level matching. A net total can hide a duplicate, missing credit, unapplied payment, or wrong-account item. Use the total as a check after the lines are explained.
What if a payment is in the bank but not allocated by the supplier?
Keep bank evidence and supplier statement line separate, classify the amount as unapplied or in transit under your process, and ask the supplier to allocate it. Do not invent which invoice it settled or treat it as proof of a cleared payable.
How should a disputed invoice appear?
Keep it linked to order, receipt, supplier statement, and dispute correspondence with amount, reason, owner, status, and next date. A dispute may affect payment or posting, but the reconciliation should not silently remove it.
Does a reconciled statement approve tax treatment?
No. Reconciliation checks account completeness and differences. Invoice fields, credits, currency, VAT or other tax treatment, recoverability, and period remain subject to current jurisdiction-specific rules and adviser review.

Keep reading

Want to review your purchasing?

Submit the details and we will confirm which invoices are useful.

Review 3 invoices free