Free Excel template
Khata / Udhaar Ledger
Free khata Excel sheet to track udhaar (customer credit) in Pakistan: record goods given and payments received, see each customer's balance, last payment and credit limit.
Download free Excel fileWorks in Excel and Google Sheets. Sheets inside: How to use, Customers, Khata.
How to use it
- 1Add each customer once in Customers with phone number and an optional credit limit.
- 2In Khata, add one line for each udhaar given or payment received.
- 3The balance after every line is calculated for that customer.
- 4Customers shows total udhaar, total received, balance and last payment date. Red means over the credit limit.
What it shows
- Running balance per customer
- Total owed to you
- Last payment date
- Credit limit warning
Made for: Shopkeepers, kiryana stores and traders who give goods on credit.
The few rows marked EXAMPLE show how it works. Delete them before adding your own data.
Want this sheet set up with your own data?
Send your file and we adjust the template to your business. Simple Excel changes Rs 900 per file, messy file clean-up Rs 2,000 per file.
Need more than a template? See our Financial Analysis & Reporting service.
More free templates
Daraz Seller Profit Calculator
See your real profit on every Daraz order after commission, payment fee, shipping and packing.
ViewShop Stock Register
Record stock in and out and instantly see current stock, stock value and what to reorder.
ViewPayment Recovery Tracker
See who owes you, how late each bill is and how much is stuck in each ageing group.
View