The udhaar book has run Indian retail for generations. A kirana in Indore, a medical store in Lucknow and a hardware counter in Coimbatore all keep one: a long notebook with a page per customer, entries in pen, and a running balance the owner can usually recite from memory.
It works well until it does not. The book gets wet, a page goes missing, a son and father write entries in different styles, or a customer disputes a figure from four months ago. And the book cannot answer the question the owner most needs answered: how much is out in total today, and with whom?
A customer ledger answers it. It keeps everything the udhaar book does, and adds totals, dates and a clear history.
01What a customer ledger holds
For each customer, a ledger shows every transaction in date order, with a running balance:
| Date | Detail | Udhaar (given) | Received | Balance |
|---|---|---|---|---|
| 2 Oct | Bill 1043, rice, oil, sugar | ₹2,340 | ₹2,340 | |
| 9 Oct | Bill 1077, groceries | ₹1,180 | ₹3,520 | |
| 12 Oct | UPI received | ₹2,000 | ₹1,520 | |
| 20 Oct | Bill 1102, groceries | ₹960 | ₹2,480 |
This is the same as the udhaar page, with three improvements: each entry links to a bill, each payment says how it came (cash, UPI or bank), and the balance is worked out for you.
02Why move off paper
- Totals
- You can see that 140 customers owe you ₹3,85,000 in all, and that 12 of them owe more than half of it.
- Age of the dues
- A ledger knows when each entry was made, so you can see who has not paid for 60 days.
- No disputes over arithmetic
- Running balances are added up correctly every time.
- More than one person can use it
- The counter staff, the owner and the owner's son see the same figure.
- It survives
- A phone or a laptop can be replaced. A notebook that falls in a bucket cannot.
03How to make the move without losing anything
Do not try to copy years of old entries. Carry forward balances and start fresh.
1. Pick a cut-off date
The first of a month is easiest, such as 1 November. Everything before that date stays in the old book.
2. Write down every customer's balance on that date
Go page by page through the udhaar book and list each customer's name, phone number and balance. Check the total twice. This list is your opening balances.
3. Agree balances with your larger customers
For the 20 or 30 customers who owe the most, confirm the figure with them, in person or on WhatsApp: "As per our book, your balance on 31 October is ₹8,450." Most agree straight away. Sort out disagreements now, while the old book is at hand.
4. Enter the opening balances
Add each customer with their opening balance as on the cut-off date. Use the phone number as the main way to find a customer, since names repeat. A town can have six the owners.
5. From the cut-off date, record everything in the ledger
Every credit sale is a bill against the customer. Every payment is recorded against them, with the mode. Do not keep both systems running for long. Two weeks of overlap is plenty.
04Habits that keep the ledger right
- Record payments the same day
- A UPI payment noticed three days later is a payment someone forgot.
- One bill per sale
- A credit sale with no bill is an entry nobody can trace later.
- Ask for the customer's phone number
- when you open the account, and check it is correct.
- Share the balance when asked
- A customer who can see their own statement pays with fewer arguments.
- Close the day with a quick check
- Total credit given today, total received today.
05What changes for a bigger store
A small grocery may have 50 credit customers. A wholesale grocer in a mandi town or a building materials dealer may have 500, with balances of several lakh each. For them, the ledger also needs:
- Credit limits
- for each customer. See setting credit limits.
- Ageing
- dues grouped into 0 to 30, 31 to 60 and over 60 days.
- Salesperson or route
- against each customer, so collection can be split.
- Statements
- sent at month end.
06An example: a medical store in Lucknow
Say a chemist with two counters has about 90 regular credit customers, mostly families and two small clinics. The udhaar book shows balances, but the owner cannot say what the total is without an evening of adding up.
On the cut-off date the list of balances comes to ₹2,64,000. Eleven customers owe ₹1,40,000 of it, including one clinic at ₹38,000 that has not paid for three months. Nobody noticed, because the clinic's page is near the back of the book. With the list in front of him, the owner can call the clinic the next morning and agree a payment plan.
From then on, the counter staff record each credit bill and each payment against the customer, and the owner checks the total each night on his phone.
07A note on cash
Many udhaar customers pay in cash. Cash payments should be recorded the moment they are received and the cash counted at day end against the total. Cash receipts of ₹2 lakh or more from one person in a day are not allowed under income-tax law as of October 2026, so large dues should be collected by UPI, cheque or bank transfer. Ask your CA about the limits that apply to your business.
In MatruOS, each customer has a record page with their balance, payments and a timeline, and you can type "who owes me?" in the Ask box to see every open balance.