Free template

Free Khata Template (Excel + Printable PDF)

Download our free khata template in Excel to keep udhaar records with automatic customer balances, or print the PDF khata page for your counter. Headings are in English and Urdu.

From PKR 2,500/mo · USD $10/mo

Download the khata template

Khata template (Excel, .xlsx)

Customers sheet with balances and credit limits, plus a ledger with a customer drop-down.

Printable khata page (PDF)

A clean one-page khata sheet to print and keep at the counter.

Qist calculator

Working out an installment plan? Use the free calculator.

What is inside the Excel file

Customers: name, phone, area and credit limit. Total credit, total paid and balance fill in automatically; balances over the limit turn red.
Ledger: one row per entry with date, customer (pick from a list), details, credit given and payment received. A running balance shows each customer’s position after every entry.
How to use: short instructions in English and Urdu.

Sample rows are included so you can see how it works; delete them before you start.

Excel + PDF

Customer list

Automatic balances

Credit limit alerts

Customer drop-down

English + Urdu headings

Print-ready

Tips for keeping a clean khata

One entry per transaction. Write each credit sale and each payment on its own line with the date.
Set a credit limit for each customer and stick to it.
Ask for a signature on the printed page for large amounts.
Review weekly. Sort by balance and follow up politely; see how to recover udhaar.
Back up the file to Google Drive or email so you do not lose it.

When credit customers grow, typing each sale twice gets tiring. In theDukanPOS, khata is built into billing: choose the customer on the bill and the balance updates by itself. You can also read how to keep shop accounts, or browse more free templates.

Frequently asked questions

Does the khata template work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Formulas and the drop-down work there too.

How many customers can it hold?

The Customers sheet is set up for 200 customers and the Ledger for 1,000 entries; you can extend the formulas further.

Is the template free?

Yes, free to download and use in your business.

Can I write in Urdu in the file?

Yes. You can type customer names and details in Urdu.

Ready to run your business on theDukanPOS?

Try every feature free for 15 days. Questions? Call or WhatsApp 0312 7032292 and talk to a real person.