Udhaar Khata Register Format — Free Excel and App
An udhaar khata register records goods or money given on credit to each customer and the payments received back.
Dukandars use a khata to keep track of who owes what. A clear format shows each customer's running balance at a glance.
Udhaar Khata Register format preview
| Date | Customer name | Phone | Items / reason | Credit given | Payment received | Balance due | Due date |
|---|---|---|---|---|---|---|---|
| 12-Nov-2026 | Anita Sharma | 98XXXXXX10 | Groceries | ₹1,250 | ₹500 | ₹750 | 30-Nov-2026 |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Customer name
Example: Anita Sharma
Phone
Example: 98XXXXXX10
Items / reason
Example: Groceries
Credit given
Example: ₹1,250
Payment received
Example: ₹500
Balance due
Example: ₹750
Due date
Example: 30-Nov-2026
Udhaar Khata Register FAQs
What is an udhaar khata?
A ledger of credit given to customers and the repayments received.
How do I track customer balances?
Keep one row per transaction and a balance column equal to credit given minus payment received, then total per customer.
Can I send reminders?
You can keep due dates in the register and use them to follow up with customers by call or message.
Is a digital khata safe?
Recordbook uses role-based permissions so only people you choose can view or edit your khata.
Related registers
Running a retail & inventory business? See Recordbook for retail & inventory · Recordbook vs Excel