Different supplier balances need an explanation. Trace invoices, credits and existing payments before correcting your records or approving the next transfer.
Compare the same supplier, date and currency before deciding what needs attention.
Your timber supplier sends a statement showing NPR 90,000 outstanding. Your workshop’s records show NPR 78,000. Both totals look believable, but paying the higher amount or forcing your records to match would skip the question that matters: which transactions explain the difference?
Supplier statement reconciliation means comparing the supplier’s account of your transactions with your own records, then tracing the items that do not agree. The result should be a clear explanation, supported corrections where necessary and a separate decision about payment.
This guide uses a hypothetical furniture workshop in Butwal. All references, dates and amounts are illustrative. The example explains account matching, not Nepal tax treatment or statutory reporting.
Keep both source reports available while checking the account.
Start with the same supplier and cut off date
Ask for the supplier’s statement and export your supplier ledger for the same closing date. Confirm the business entity, supplier account and currency before comparing totals. A statement through 14 November and a ledger through 15 November may contain different transactions even when both are accurate.
Check whether the statement shows all activity or only outstanding items. If it contains only open invoices, request the payment and credit details needed to explain the balance. Agree the opening balance before tracing later movements.
Sage’s supplier reporting documentation distinguishes supplier transactions, statements and unallocated payments. That distinction helps you gather the right evidence instead of relying on one total.
Keep an unchanged copy of each source report. Record the date, report filters and person preparing the review so another colleague can reproduce it.
Investigate existing records before creating another transaction.
Match references before deciding what to change
Compare supplier invoice numbers, dates, amounts, payments and credits. Your internal voucher number may differ from the supplier’s bill number; keep both references in the matching sheet.
Use a short exception list rather than repeatedly searching the whole ledger:
| Difference found |
Evidence to check |
Next action |
| Invoice on statement only |
Supplier bill, order and receiving record |
Verify whether it is missing or already entered under another reference |
| Payment in your ledger only |
Payment entry, bank evidence and remittance reference |
Ask the supplier to trace the existing payment |
| Credit on statement only |
Supplier credit and linked return or agreed adjustment |
Review the missing credit entry |
| Same reference, different amount |
Original document and approved charges |
Explain the amount before correcting either record |
A difference is a question, not permission to post an adjustment. Look for an existing document before creating another one. Keep unresolved items visible with an owner and next review date.
Match the supplier bill to receiving or return evidence held by the workshop.
Check receiving and returns with the storekeeper
Accounts may see an invoice while the storekeeper holds the delivery record. Bring those records together before deciding that an invoice is missing.
For timber or fittings, check the supplier reference, item, quantity and receiving evidence. If a return is involved, retain the return reference and the supplier’s credit confirmation. Sending goods back does not, by itself, explain what the supplier has credited.
ERPNext’s Purchase Invoice guide illustrates retaining the supplier’s bill reference and linking invoices to purchase receipts. The useful connection is a traceable bill linked to evidence of what was received.
Do not create another stock receipt merely because an invoice needs recording. Check whether the goods movement already exists and let the authorised accounts reviewer decide the appropriate entry.
Explain each difference once on the side where it is missing.
Work through the difference without counting anything twice
Assume both reports close on 14 November 2026, use NPR and relate to one supplier account. The opening balance and all other transactions agree. Document amounts below are assumed verified final balance effects; no tax calculation, currency conversion, fees or discount is being added.
The review finds three differences:
| Reference |
Finding |
Effect needed for comparison |
| Invoice INV-018 |
NPR 18,000 on supplier statement, missing from workshop ledger
|
+ Add NPR 18,000 to the workshop balance after verification
|
| Credit CR-007 |
NPR 12,000 on supplier statement, missing from workshop ledger
|
− Deduct NPR 12,000 from the workshop balance after verification
|
| Payment PAY-011 |
NPR 6,000 already recorded by workshop and supported by bank evidence, absent from supplier statement
|
Trace payment: Ask supplier to locate and reflect the payment
|
Workshop balance: NPR 78,000 + NPR 18,000 − NPR 12,000 = NPR 84,000
Supplier statement: NPR 90,000 − NPR 6,000 = NPR 84,000
The payment is already included in the workshop’s NPR 78,000 starting balance. Subtracting it there again would count it twice. Similarly, the invoice and credit already appear in the supplier’s NPR 90,000, so do not add or deduct them again on that side.
NPR 84,000 is the common explained balance in this example. It is not an instruction to pay that amount immediately. Check due dates, approved disputes and the actual payment authorisation separately.
Keep payment allocation separate from money leaving the bank
An invoice may still appear unpaid when a payment has been recorded but has not been linked to it. Check available payments and allocations before initiating a replacement transfer.
ERPNext’s Payment Reconciliation documentation explains linking existing payments or credits to invoices without creating a second bank movement. Its Bank Reconciliation guide describes matching accounting transactions to the bank statement. Neither check replaces comparing your supplier account with the supplier’s statement.
If the supplier cannot trace PAY-011, send the relevant remittance details through an authorised channel. Keep the evidence and response with the exception. Do not treat a screenshot or an unexplained balancing entry as the whole investigation.
Document dates explain the comparison; the review date does not authorise backdating.
Give each unresolved item an owner
For planned WorkSphere workflows, Accounting could hold the matching review, Inventory could supply receiving and return references, and Project/Task Management could track missing documents and supplier queries. If a disputed supply affects a customer job, the responsible CRM owner could receive the confirmed delivery implication.
These connections should preserve source references and review decisions. They should not silently change stock, mark a bill settled or approve a payment because someone completed a follow-up task.
After approved corrections, rerun the ledger and obtain an updated statement or written explanation of remaining differences. Keep the original reports, exception list and reviewer sign-off together.