How to Reconcile Supplier Statements to Your Payables

Your payables ledger shows what you think you owe. The supplier's statement shows what they think you owe. When the two differ, one of you is missing something: an invoice, a payment, a credit note or a correction. Finding that out each month keeps errors small and recent, while the people who handled the transactions still remember them.

The routine also protects the payment run. A reconciled balance means you are less likely to pay an invoice twice, pay one that is under dispute, or miss an invoice the supplier will later chase with a reminder and a strained relationship.

• ✓The supplier's statement for the month, showing opening balance, transactions and closing balance.
• ✓The party ledger from your accounting software for the same period and closing date.
• ✓Last month's signed reconciliation and its list of open items.
• ✓Bank statements or payment advices for payments made to the supplier.
• ✓Purchase orders, goods receipt notes and invoices received but not yet posted.
• ✓Any debit notes you raised and correspondence about short supply, rate differences or returns.

If a supplier does not send statements, ask for one. Prioritise high-value and high-volume parties; smaller, occasional suppliers can be reconciled on a rotating basis or quarterly, depending on what your accountant advises.

1. Check that the opening balance on the statement agrees with last month's reconciled position. If not, resolve that first.
2. Tick off invoices that appear in both records with the same number, date and amount.
3. Tick off payments, matching your bank debit to the supplier's receipt entry. Watch for TDS: you may record a net payment while the supplier shows the gross invoice cleared only after recording the deduction.
4. Tick off credit notes and debit notes that appear in both records.
5. List every unticked item on either side and classify it.
6. Build a bridge from your ledger balance to the supplier's balance using those items, and confirm it closes to zero.

Always reconcile from your ledger balance to the supplier's balance, not the other way round. That keeps the direction of each adjustment consistent and makes the reconciliation easy for a reviewer to follow.

Also look for your own errors: an invoice posted twice, posted to the wrong party, or entered with a typing mistake. These need a correction in your books, not a call to the supplier. The guide on preventing duplicate supplier invoice payments covers the checks that stop the most expensive of these.

Illustrative example only; the supplier, amounts and items are invented. Your payables ledger shows Rs 3,42,000 owed to a packaging supplier at month-end. The supplier's statement shows Rs 4,18,500.

In this example, we reverse the duplicate (our error) and post the missing invoice once it is checked. The supplier is asked to apply the unapplied payment, issue the credit note and respond on the rate dispute. For the payment run, the amount actually payable excludes the disputed Rs 18,000 and nets off the agreed credit, even though the supplier's statement still shows both.

Assign one named person in accounts as the owner of each supplier reconciliation. That person sends a single, itemised query listing each difference, the reference and what you need: a copy invoice, a credit note or confirmation that a payment has been applied. Disputes about rate, quantity or quality are best raised jointly with whoever placed the order, because accounts cannot judge those alone.

1. First query: sent as soon as the reconciliation is done, well before the payment run.
2. Follow-up: if there is no reply by the next weekly review, chase once more by email and phone.
3. Escalation: if an item is still open at the next month's reconciliation, it goes to the owner or finance head with a summary.

Escalate immediately, regardless of age, when the difference is large relative to the balance, when a supplier statement shows payments you did not make, when bank details on correspondence have changed, or when a supplier threatens to stop supply. A change of bank details should always go through the vendor bank account verification routine before any payment.

Complete reconciliations for the suppliers due in the run before approving it. Release only invoices that are matched and undisputed. Hold disputed amounts with a recorded reason, and do not pay a supplier statement balance as a lump sum without knowing which invoices it covers. The weekly supplier payment run routine and the accounts payable ageing review both work better when this step is done first.

• Comparing balances at different dates, so every timing item looks like an error.
• Posting a balancing entry to make the ledger agree with the supplier.
• Paying the statement total instead of specific, verified invoices.
• Treating an agreed credit as settled before the supplier has issued the credit note.
• Carrying timing differences forward for months without checking they cleared.
• Letting purchasing and accounts each assume the other is chasing a dispute.

This routine suits regular domestic trade suppliers. Import suppliers in foreign currency, related parties and suppliers with complex rebate or advance arrangements need extra schedules; agree the approach with your chartered accountant. Advances paid to suppliers are covered in the guide on tracking vendor advances against supplier invoices.