Bill-wise outstanding vs running balance: knowing who owes what, and since when
A ledger balance tells you how much a customer owes. Bill-wise outstanding tells you which bills, how old, and which payment was for what. Why the second one is the one that gets money collected.
A customer's ledger ends in one figure: ₹3,80,000 debit. That is the running balance. It is correct and it is not enough, because it cannot answer the question a trader actually asks — which bills is this, and how late are they?
The same customer, bill by bill
| Bill | Date | Amount | Received | Pending | Days |
|---|---|---|---|---|---|
| S-104 | 12 June | 1,60,000 | 1,60,000 | 0 | — |
| S-131 | 3 July | 1,40,000 | 60,000 | 80,000 | 90 |
| S-162 | 20 August | 1,80,000 | 0 | 1,80,000 | 42 |
| S-188 | 18 September | 1,20,000 | 0 | 1,20,000 | 13 |
Now there is something to say on the phone: ₹80,000 of the July bill is 90 days old. The balance alone would have sent a reminder for ₹3,80,000, most of which is not even due.
What bill-wise accounting needs from you
- Each receipt is set against the bill it pays — fully, or in part.
- A payment that names no bill is kept "on account" and adjusted later, not left floating.
- Returns, rate differences and discounts are set against the bill they belong to, through a credit note.
- Credit days are recorded per party, so "overdue" means something.
Ageing — the report a bank also asks for
The pending bills are grouped by age: up to 30 days, 31 to 60, 61 to 90, and beyond. A business with ₹40 lakh of debtors where ₹15 lakh is past 90 days does not have ₹40 lakh of good debtors. Banks know this, and many do not count debtors older than 90 days when they work out a limit.
On the supplier side too
The same list, turned around, tells you which bills fall due this week — so that payments are made in the order they are owed, and an early-payment discount is not lost because nobody saw the date. Payments to small suppliers registered as MSMEs carry a legal time limit, and a bill-wise list is how you see it coming.
When the two disagree
The total of pending bills should equal the ledger balance. When it does not, it is almost always an on-account receipt nobody set against a bill, or a journal entry passed straight to the party without a bill reference. Find it — a difference left alone grows every month.
In the cloth trade, terms are part of the price: so many days of credit, with a discount if paid early. Software that tracks only a running balance cannot tell you whether a customer is taking the discount AND the full credit period. Bill-wise can.