Business

Vendor ledger meaning: one page for everything with a supplier

A vendor ledger is one page listing every bill and payment for a single supplier with a running balance. See a three-month example and how to check it.

Editorial illustration for Vendor ledger meaning: one page for everything with a supplier

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.

DateEntryReferenceBilled (₹)Paid (₹)Balance owed (₹)
5 JanBillBill 11824,000-24,000
18 JanBillBill 13112,500-36,500
20 JanPaymentUPI-24,00012,500
9 FebBillBill 15218,300-30,800
15 FebPaymentNEFT-20,00010,800
2 MarBillBill 1879,200-20,000
10 MarPaymentUPI-10,00010,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.

  1. Tick off each of your lines against theirs, bill number to bill number.
  2. List what is on their statement but not on yours (a bill you never booked).
  3. List what is on yours but not theirs (a payment that has not reached them, or was credited to another bill).
  4. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports