To reconcile a supplier statement, put the supplier's closing balance next to the closing balance in your own supplier ledger, then tick off every line on both sides. Whatever is left unticked is the difference, and each leftover line usually falls into one of three buckets: a bill you have not recorded, a payment the supplier has not credited, or a return that only one side has booked.
What do you need in front of you?
- The statement the supplier sent, covering the same period as your ledger (ask for it up to a date you both agree on, such as the last day of the month).
- Your own ledger page for that supplier: every purchase bill, payment and return, with dates and reference numbers.
- Your bank statement for the month, so that you can confirm a payment really left your account and on which date.
- The physical or PDF bills, in case a line needs checking against the paper.
How do you tick off the lines?
- Write down both closing balances and the gap between them. This is the number you are trying to explain.
- Go through the supplier's statement top to bottom. For each bill, find the same bill number in your ledger and put a tick on both. Do the same for each payment, matching on amount and date.
- Underline anything on the statement that has no tick. Then underline anything in your ledger that has no tick.
- For each underlined line, write one reason beside it and one action. Do not move to the next supplier until every underlined line has both.
- Re-add the figures after allowing for the differences. The two balances should now agree. If they do not, a line has been missed or an amount typed wrongly, so check digits first.
What kinds of difference will you find?
| Difference | Which side is behind | Usual action |
|---|---|---|
| Bill on statement, not in your ledger | Your ledger | Find the bill; if it is genuine and goods arrived, record it |
| Payment in your ledger, not on statement | Supplier's books | Send the bank proof and the date; ask them to credit it |
| Goods returned, not on statement | Supplier's books | Ask for the credit note, quoting the return date |
| Credit note on statement, not in your ledger | Your ledger | Record the return or discount so both agree |
| Same bill appears twice | Either side | Ask which entry is the duplicate and have one removed |
| Amounts differ slightly on one bill | Either side | Compare with the paper bill and fix the wrong figure |
A worked example with two differences
Say the supplier's statement shows a closing balance of ₹94,500, while your ledger shows ₹71,000. The gap is ₹23,500. Ticking line by line leaves two unmatched entries.
- A bill dated the 30th for ₹18,500 is on the statement, but you booked the goods on the 2nd of the next month, so your ledger does not have it yet.
- A UPI payment of ₹5,000 on the 29th is in your ledger and your bank statement, but the supplier has not credited it.
Now adjust. Your ledger ₹71,000 plus the missing bill ₹18,500 gives ₹89,500. The supplier's ₹94,500 less the uncredited payment ₹5,000 also gives ₹89,500. Both sides agree, and the ₹23,500 gap is fully explained: 18,500 plus 5,000.
How do you settle the differences?
For the missing bill, record it in your ledger on the date you accept it, with a note that it was found during reconciliation. For the uncredited payment, send the supplier the date, amount and the reference shown on your bank statement and ask for written confirmation once they credit it. Keep that confirmation with the statement. If a difference cannot be explained at all, ask the supplier to send their ledger lines for the period rather than arguing over totals.
How often should you do it?
Monthly for suppliers you buy from every week, and at least at the end of each quarter for others. Small differences left alone for a year turn into long arguments about bills nobody remembers. If you pay suppliers from several accounts, a tool that keeps each transaction with its account helps: SpendixAI lets you import a bank statement and pick the account first, so you can check the payment line quickly before replying to the supplier.
A short checklist to keep
- Statement date and the date you reconciled it.
- Both closing balances and the gap.
- One line per difference: reason, action, who is following up.
- Supplier's written confirmation of anything they agreed to correct.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


