RefinePoint

Blog · · 7 min read

Vendor statement reconciliation: matching a supplier's ledger to yours

How to reconcile a supplier's statement of account with your purchase ledger: signs, document numbers, on-account payments, TDS and balance confirmation.

A supplier sends a statement of account showing you owe ₹4,86,300. Your purchase ledger says ₹3,92,140. Someone has to explain the ₹94,160 before the supplier's collections team calls again, and before the auditor's balance confirmation letters go out. Vendor statement reconciliation is that explanation. It is one of the most useful reconciliations an accounts payable team can run regularly, because the supplier's records are an independent check on your own. This post covers how to do it well.

Get the two documents into the same shape

The supplier's statement is a copy of your account in their books. Your purchase ledger is their account in yours. They describe the same transactions from opposite ends, which causes most of the confusion.

Flip the signs on one side

In the supplier's books, an invoice to you is a debit (you owe them more) and your payment is a credit. In your books, their invoice is a credit to their ledger and your payment is a debit. Before comparing anything, pick one point of view and convert both files to it. A simple convention: from your side, invoices positive (you owe more), payments and credit notes negative.

Keep the document type

Bring a column for the document type on both sides: invoice, credit note, debit note, payment, TDS, opening balance. It makes the leftover items much easier to read, and it lets you sort the differences by kind.

Agree the period and the opening balance

Ask for the statement for a specific period, say 1 April 2026 to 31 October 2026, and compare it with your ledger for the same period. If the opening balances differ, the difference belongs to an earlier period and should be investigated separately, or you will chase it in every month's reconciliation.

Match on the supplier's document number first

The supplier's invoice number is the best key, because it is on both sides: they issued it, and your team should have typed it into the bill or purchase voucher. The trouble is that it is rarely typed the same way. INV/2026/0042, INV-2026-42 and inv 2026 0042 are the same invoice. Normalise the numbers before comparing: drop separators, case and leading zeros in each segment.

Allow a small tolerance on the amount, around ₹1, for rounding. GST invoices are often rounded to the rupee by the supplier but not by your system, or the other way round.

Also compare the document date on matched pairs. A date difference does not stop the match, but it can explain an ageing dispute: the supplier ages from their invoice date, you may be ageing from the date you booked it.

Then handle payments, which rarely carry an invoice number

Payments are where references fall apart. You pay ₹1,50,000 by NEFT against three invoices. The supplier receives it and records one receipt. On your side you may have one payment voucher, or three bills knocked off.

  • One payment on their side, several entries on yours. Look for a group of your entries for the same supplier whose total equals their receipt, within about ten days.
  • Several entries on their side, one on yours. The reverse: they split your payment across invoices; you booked one payment.
  • Same supplier, same amount, a few days apart. A last pass for anything without a reference. Have a person confirm these.

Always restrict payment matching to the same supplier. Without that, a ₹50,000 payment to one vendor can pair with a ₹50,000 receipt in another vendor's statement.

The usual reasons a vendor statement disagrees

After matching, the leftover items fall into a small number of groups. Label each one.

Reason What you see Usual action
Invoice not yet booked by you On their statement only Find the invoice; it may be with the purchase team waiting for GRN or approval
Goods returned, credit note not issued Debit note on your side only Ask the supplier for the credit note
Credit note not booked by you On their statement only Book it, with the GST reversal
Payment in transit On your side only, last days of the period Will clear next month
TDS deducted by you Your payment is net; they show the gross invoice as open They must account for TDS; you must show it was deposited and reported in your TDS return
Price or quantity difference Same invoice, different amount Raise with the supplier; check the PO and GRN
Duplicate entry Same invoice twice in your ledger Reverse one, and check that it was not paid twice

TDS deserves a note. If you deducted 2% TDS on a contractor's invoice of ₹1,18,000 (₹1,00,000 plus 18% GST, with TDS on the value excluding GST), you paid ₹1,16,000 and deposited ₹2,000 with the government. (CBDT's Circular 23/2017 says TDS is not deducted on the GST component when the invoice shows it separately.) The supplier's statement often shows ₹2,000 still due until they take credit for the TDS after it reflects against their PAN. That difference is legitimate but has a time limit in practice: if it stays open for long, check that your TDS return was filed and the deduction appears in their records.

A worked example

An illustrative reconciliation of Shree Ganesh Polymers' statement with your purchase ledger as on 31 October 2026, from your point of view (positive means you owe more).

Item On their statement (₹) In your ledger (₹) Difference (₹)
Invoices matched by number (42 invoices) 18,64,500 18,64,500 0
Payments matched (6 payments) (14,20,000) (14,20,000) 0
INV/2026/0388 dated 29 Oct, not booked by you 82,600 82,600
Credit note CN/2026/014 for returned drums, not booked by you (11,800) (11,800)
Your NEFT of 31 Oct, received by them on 3 Nov (35,000) 35,000
TDS on INV/2026/0301, not yet credited by them 2,000 2,000
INV/2026/0356 booked twice in your ledger 13,640 (13,640)
Opening balance (agreed) (31,000) (31,000) 0
Closing balance 4,86,300 3,92,140 94,160

The ₹94,160 is fully explained. Of it, two items need entries on your side (book INV/2026/0388 after checking the receipt of goods, book the credit note), one needs a correction (reverse the duplicate, and check whether it was paid twice), one is timing (the 31 October payment), and one needs a conversation (TDS).

The duplicate is the most important finding of the exercise. A bill booked twice is one step away from a bill paid twice.

Make it routine

  • Reconcile your top suppliers every month, by value, and the rest each quarter. Ask for statements in Excel or CSV, not PDF.
  • Age the open items. Use 30, 60, 90 and 180 day buckets. Anything over 90 days on either side is either a dispute or an error.
  • Compare the balance per supplier, not just the transactions. If you reconcile ten suppliers in one file, a total that agrees can hide two suppliers that disagree in opposite directions.
  • Check for duplicates in your own ledger every time: same supplier, same document number, same amount.
  • Keep the GST view in mind. An invoice on the supplier's statement that is missing from your books is also likely to be in your GSTR-2B with no matching entry in your purchase register. The two reconciliations confirm each other.

How RefinePoint does it

RefinePoint's built-in Vendor statement reconciliation template has two sides, Vendor statement and Purchase ledger, and expects amounts from your side's point of view on both: invoices positive, payments and credit notes negative. It matches in four passes: document number and amount (within ₹1, with the document date compared), a payment against several invoices of the same supplier (groups of up to eight, within ten days), several entries against one, and same supplier with the same amount within five days, which is proposed for a person to confirm. Document numbers are cleaned before comparing, so INV/0042 and inv-42 are treated as the same. Its checks require document numbers and amounts, flag duplicate documents in the ledger, compare the balance per supplier within ₹1 and age the open items in 30, 60, 90 and 180 day bands. Reason codes can label the recurring causes such as TDS and payments in transit.

To try it with a real supplier statement, request a demo at refinepoint.com or start free at app.refinepoint.com.

Sources

Filed under Vendor reconciliation, Accounts payable

Reconcile it in RefinePoint

Templates for bank, vendor, GST, payroll, card and payment reconciliations. Upload two files and see the matches, the differences and why.

Request a demoStart free