Customer Khata & Supplier Ledger Playbook: Running Balances, Ageing, MSME Rules & Udhaar Recovery

By BillAmico Accounting Specialist Desk | | 12 min read

In Indian retail and wholesale trade, more than 60% of business volume runs on trust and credit (udhaar). However, unorganized khata management causes severe cash shortages, bad debts, and family business disputes. Mastering party ledgers is the key to business longevity.

1. Anatomy of a Party Ledger: Customer vs Supplier

A Party Ledger is an individual chronological statement of accounts maintained for every customer (Debtor) and supplier (Creditor).

Customer Khata (Sundry Debtors): Debited when sales are made on credit; credited when customer pays cash, UPI, or cheque. A debit balance means "Customer se lena baaki hai".

Supplier Ledger (Sundry Creditors): Credited when inventory is purchased on credit; debited when you pay the distributor or return goods via Debit Notes. A credit balance means "Distributor ko dena baaki hai".

Maintaining accurate running balances ensures that neither party disputes the outstanding amount at month-end.

2. Receivables Ageing Analysis (The 30/60/90 Day Golden Rule)

Aging categorizes pending customer dues based on the number of days elapsed since the invoice date:

0 to 30 Days (Green / Current): Safe operating credit. Customer is within normal credit terms.

31 to 60 Days (Yellow / Watchlist): Polite reminder required. Stop offering further bulk credit until old bills clear.

61 to 90 Days (Orange / High Risk): Formal call from owner. Restrict fresh billing entirely.

90+ Days (Red / Potential Bad Debt): Urgent personal visit or legal demand notice under Section 138 (if cheque was issued).

info: Printing Balances on Thermal Bills: Automatically printing "Previous Balance: ₹X" and "Net Total Due: ₹Y" on every counter receipt reminds the customer of the amount due each time they buy.

3. Section 43B(h) MSME Mandate for Supplier Payables

Under the Income Tax Act Section 43B(h), payments to registered Micro and Small enterprises must be made within 15 days (or up to 45 days if supported by a written agreement).

If payment is delayed beyond the statutory timeline, the entire purchase amount is disallowed as a business expense and added back to your taxable net profit.

Modern accounting software flags MSME suppliers and provides an upcoming payment due schedule so you never miss a 45-day deadline.

4. Modern Udhaar Recovery Techniques (Zero Social Friction)

1-Click WhatsApp Statements: Send professional PDF ledger statements accompanied by polite, pre-formatted reminder text directly to the customer phone.

Dynamic UPI Payment Links: Embed instant UPI QR codes in payment reminders so customers can clear dues in 5 seconds via PhonePe, Google Pay, or Paytm.

Multi-Bill Payment Allocation: When a customer pays a round figure (e.g. ₹10,000 against multiple bills), clear oldest invoices first (FIFO) and carry the rest to on-account balance.

5. Risks of Loose Khata Bookkeeping

Accumulation of Unrecoverable Bad Debts: Forgotten credit accounts that shopkeepers fail to collect before customers relocate.

Staff Theft & Ledger Tampering: Cashiers accepting cash from customers and secretly deleting the invoice from the system. An audit trail of every entry created, edited or deleted exposes this.

Working Capital Stagnation: Having crores in paper sales on the ledger but zero liquid cash in the bank to pay rent, salaries, or suppliers.

Related guides