Supplier Statement Reconciliation: Find Vendor Ledger Differences

A supplier sends a statement showing ₹1,50,000 due, while your ledger shows ₹1,20,000. Neither total should be accepted without checking. Missing bills, payment timing, unapplied advances and credit notes can all explain the difference.

Agree the basis before comparing

Check the supplier’s legal entity, account reference and period. Establish whether figures include tax, whether multiple branches are combined, and whether advances are shown separately. Use the statement’s closing balance and detailed transactions, not only an email demanding payment.

A fictional ₹30,000 difference

The supplier’s statement is ₹1,50,000 and your books show ₹1,20,000. Investigation finds a valid ₹18,000 invoice absent from your books and a ₹12,000 payment already posted in your books but not credited by the supplier. Assume both amounts use the same tax and currency basis.

You record the missing invoice once and ask the supplier to apply the payment. You do not record the ₹12,000 payment again. The fact that the totals reconcile does not by itself decide whether the invoice is an expense, inventory or an asset, or whether any input tax credit is eligible.

Review four document streams

• Invoices: match the order, receipt or service evidence, price and duplicate references.
• Returns and credit notes: identify the reason, agreement and whether both parties recorded them.
• Payments: match date, amount, bank reference and allocation.
• Advances: identify which delivery or invoice the amount is intended to settle.

Do not let disputed deductions disappear

You may believe a short delivery supports a deduction, while the supplier has not accepted it. Show the disputed amount explicitly and retain the evidence. Do not quietly remove the payable or assume a self-created debit note settles every legal and tax consequence. Agreed credits, disputed claims and unallocated payments are different situations.

Use reconciliation as a payment control

Before a significant payment, check whether the invoice number appears more than once, whether a bank import duplicated the original entry, and whether an advance already covers part of the amount. Changes to supplier bank details need independent verification through a trusted contact route, with approval appropriate to the business. A reconciliation is most valuable before an avoidable duplicate or incorrect payment occurs.

Questions that often come up

Can I rely on a supplier balance confirmation alone? It is useful evidence, but individual invoices and payment differences may still need examination.

What if the supplier never sends a statement? Reconcile your document records and seek confirmation of significant or uncertain balances. Keep an evidence trail of your review.

Should every missing bill be posted immediately? First establish that it belongs to the business and period, is not duplicated, and has the appropriate supporting evidence and classification.

Your next practical step

Reconcile the largest suppliers before the next major payment run. Keep agreed balances and unresolved disputes separate. Include the resulting actions in your month-end closing process.

Opens a short definition