A vendor ledger is a single page that lists everything between you and one supplier: each bill they sent, each payment you made, and the balance you still owe after every line. It answers one question quickly: how much do I owe this supplier today, and why?
It differs from a general payables list, which shows one balance per supplier across the whole business. The ledger is the detail behind that one number.
What does a vendor ledger page look like?
Take a hypothetical packaging supplier, Sharma Packaging, over January to March. Bills increase what you owe; payments reduce it. The balance column is simply the previous balance plus the bill, or minus the payment.
| Date | Entry | Reference | Billed (₹) | Paid (₹) | Balance owed (₹) |
|---|---|---|---|---|---|
| 5 Jan | Bill | Bill 118 | 24,000 | - | 24,000 |
| 18 Jan | Bill | Bill 131 | 12,500 | - | 36,500 |
| 20 Jan | Payment | UPI | - | 24,000 | 12,500 |
| 9 Feb | Bill | Bill 152 | 18,300 | - | 30,800 |
| 15 Feb | Payment | NEFT | - | 20,000 | 10,800 |
| 2 Mar | Bill | Bill 187 | 9,200 | - | 20,000 |
| 10 Mar | Payment | UPI | - | 10,000 | 10,000 |
The check at the bottom: total billed is ₹64,000 (24,000 + 12,500 + 18,300 + 9,200), total paid is ₹54,000, and the difference, ₹10,000, matches the last balance. If those two numbers disagree, a line is missing or mistyped.
Which columns are worth keeping?
- Date of the bill or the payment, not the date you typed it in.
- The supplier's own bill number, so you can match it to their paperwork.
- Billed and Paid in separate columns, so a payment never gets confused with a bill.
- Balance owed, calculated, never typed by hand.
- A short note: which job, which purchase order, whether a payment was part-payment.
How do I compare it with the supplier's statement?
Many suppliers send a statement of account at month end. This is their version of the same page. Your closing balance and theirs should match; when they do not, the gap is nearly always one of a handful of causes.
- Tick off each of your lines against theirs, bill number to bill number.
- List what is on their statement but not on yours (a bill you never booked).
- List what is on yours but not theirs (a payment that has not reached them, or was credited to another bill).
- Explain the difference line by line until your adjusted balance equals theirs.
Say their statement closes at ₹21,800 while your ledger shows ₹10,000. The difference is ₹11,800. Scanning their list, you find Bill 201 dated 11 March for ₹11,800 that never reached your accounts. Book it and the two balances agree: 10,000 + 11,800 = 21,800.
What if the balances will not agree?
Work through the common causes before calling anyone. Differences of a few rupees often point to round-off on a bill. A payment that appears twice on your page may be a duplicate entry. A payment that is on your bank statement but missing from theirs may have been credited against an older bill, so ask them how they applied it.
How can I keep one for each supplier without much effort?
In a spreadsheet, keep one sheet for all suppliers with a Supplier column, then filter by name to see a single page. A running balance for a filtered list needs care; a simpler route is a SUMIFS total per supplier: =SUMIFS(D2:D500, A2:A500, "Sharma Packaging") for billed and the same on the paid column, then subtract.
If most of your payments come from a bank or card statement, the paid side is easier when each statement row is already tagged to a payee. SpendixAI can import those statements and group spending by merchant, which gives you the paid column; the bills themselves you would still note separately.
What goes wrong without a vendor ledger?
Without a page per supplier, you find out about problems late. A bill gets paid twice because nobody remembered the first payment. A supplier says you owe ₹30,000 and you cannot say whether that is right. A part-payment is forgotten, and an argument starts over something a single page would have settled.
- Double payments go unnoticed until the supplier's next statement, if at all.
- Disputes turn into your memory against theirs, with no dated record to show.
- You cannot tell which suppliers you are paying slowly, so you cannot plan cash.
- Part-payments get lost: on Sharma Packaging's page, the ₹20,000 paid on 15 February covers only part of the ₹30,800 then owed, and the page shows that at a glance.
A ledger per supplier is cheap insurance. It takes a minute per bill and answers questions in seconds.
A monthly routine
- Enter every supplier bill the day it arrives.
- Enter each payment against the bill it settles.
- On the first of the month, request or download the supplier statement and compare closing balances.
- Chase anything over a month old on either side.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
