How to Keep Udhaar Record of Customers: A Simple, Practical Guide

To keep udhaar records, give every customer their own page or account and start it with an opening balance you both agree on. Then write every credit sale and every payment on the same day, with the date, the amount, what was taken and a running balance, and check the totals once a month.

That is the whole method. The rest of this guide covers the details that stop arguments, catch mistakes and help you collect your money.

What every udhaar entry needs

Whether you use a register, Excel or an app, each line should answer the same questions:

  • Date: the day the goods left the shop or the money came in.
  • Customer name and phone number: write the full name, not just "Bhai jaan from the corner".
  • What was taken: a short note such as "Ghee 5 cartons" or "Atta 10kg", or the bill or challan number.
  • Amount: in rupees, written clearly.
  • Who took it: if a son, munshi or rider collected the goods, write their name.
  • Running balance: what the customer owes after this entry.

For larger amounts, get the customer's signature or thumb impression on the challan and keep your copy. A note like "Atta 10kg" settles most disputes before they start.

Step 1: One page per customer, with an opening balance

Many shops write udhaar in a daily diary, one line after another. This makes it almost impossible to know what one customer owes without going back through weeks of pages.

Instead, give each customer their own page in the register, their own sheet in Excel, or their own account in an app. At the top, write:

  • the customer's name, phone number and area
  • the opening balance: whatever they owed on the day you started this page, agreed with them
  • a credit limit: the most udhaar you will allow this customer at one time

The credit limit is your own decision. It stops one customer's balance from quietly growing until it is more than you can afford to lose.

Step 2: Separate "diya" and "mila" columns

Use two money columns: udhaar diya (you gave goods on credit) and paisay mile (you got payment). Add a third column for the balance.

  • Each credit sale goes in the "diya" column and the balance goes up.
  • Each payment or goods return goes in the "mila" column and the balance goes down.

Never overwrite a figure. If you make a mistake, draw one line through it so it can still be read, and write the correct entry below. Overwritten numbers are where most quarrels about balances begin.

A worked example

Here is March for a wholesaler's customer, Rasheed Kiryana Store. The amounts are for illustration.

Date Detail Udhaar diya (Rs) Paisay mile (Rs) Balance (Rs)
1 Mar Opening balance (agreed) 1,20,000
3 Mar Challan 214: ghee and oil 45,500 1,65,500
7 Mar Cash received 50,000 1,15,500
12 Mar Challan 231: sugar and rice 85,000 2,00,500
18 Mar Bank transfer 60,000 1,40,500
25 Mar Challan 247: mixed grocery 1,10,000 2,50,500
28 Mar Goods returned (damaged cartons) 8,000 2,42,500
31 Mar Cash received 40,000 2,02,500

Check the month: opening Rs 1,20,000 + credit sales Rs 2,40,500 − payments Rs 1,50,000 − return Rs 8,000 = Rs 2,02,500. If your running balance and this check do not match, there is an addition mistake somewhere. Find it now, not when the customer is standing at your counter.

Which part of the balance is old?

The balance alone does not tell you how worried to be. Most traders treat payments as clearing the oldest udhaar first. In this example, the Rs 1,58,000 received (payments plus the return) clears the opening Rs 1,20,000 and Rs 38,000 of the 3 March challan. What is left:

From Amount still owed (Rs)
Challan 214 (3 Mar) 7,500
Challan 231 (12 Mar) 85,000
Challan 247 (25 Mar) 1,10,000
Total 2,02,500

This customer is paying regularly and most of the balance is recent. A customer with the same Rs 2,02,500 balance, all from three months ago, needs a phone call today.

Step 3: Record payments the moment they come in

Udhaar records go wrong more often on the payment side than the sales side. A customer hands cash to your worker, the worker forgets to tell you, and next month the customer insists they paid.

  • Write every payment the same day, in the customer's own page.
  • For bank transfers, note the date and reference.
  • For cheques, write the cheque number. If a cheque bounces, add the amount back as udhaar with a note, so the history shows what happened.
  • Give the customer a receipt, even a handwritten one, for every payment.

Step 4: A monthly routine

Set aside one hour at the start of each month:

  1. Total every customer's balance. The sum is your total udhaar in the market. Compare it with last month. If it keeps rising while sales stay flat, customers are paying slower.
  2. Send statements to your bigger customers. A statement lists the opening balance, each entry and the closing balance for the month. Ask them to confirm it. Differences found after one month are easy to fix; differences found after a year are not.
  3. List balances by age. Call the oldest ones first.
  4. Stop new udhaar to anyone over their credit limit until they pay something.

Common problems with paper registers

Paper is still how most shops keep udhaar, from small kiryana stores to large wholesalers. The usual problems are well known:

  • The register gets lost, torn or soaked, and with it the record of who owes what.
  • Totals are added wrong, especially when balances are carried from page to page.
  • Customers argue about their balance, and an overwritten figure is hard to defend.
  • There is no backup. One register, one copy.

If you stay on paper, reduce the risk: photograph the pages every week, keep a separate summary of each customer's closing balance at month end, and keep finished registers somewhere safe and dry.

Paper, Excel or a khata app?

Method Good for Watch out for
Paper register Familiar, no learning needed Lost pages, adding mistakes, no backup
Excel Automatic totals, easy to sort by balance One file on one computer, formulas break, no reminders
Khata app or software Balances calculated for you, statements on demand Choose one that keeps a backup and lets you take your data out

If you move to software, check that it does more than store numbers. In Bin Amir ERP's digital khata, each customer has "you gave" and "you got" entries in one tap, balances show as "you'll get" or "you'll give", and you can send payment reminders to customers. Data is kept on cloud servers and backed up daily, and every khata entry is a proper accounting entry underneath. If the business grows and moves to the full ERP, its customers and their history are already there.

How long should you keep udhaar records?

Do not throw old registers away after a year or two. FBR's own help page says people with taxable income must keep their income tax records for six years. Credit sales and payments received are part of your sales records.

The rule comes from Section 174 of the Income Tax Ordinance, 2001. As summarised in a 2023 report of an FBR reminder, taxpayers must keep their accounts and documents in Pakistan for six years after the end of the tax year they relate to. If a case is pending before a tax authority or court, the records must be kept until it is decided. A Federal Tax Ombudsman ruling, reported by Business Recorder, said the same: if FBR sends a notice within the six years, keep the records until the case is closed.

The Ordinance also has penalties for not keeping records. Amounts can change with each Finance Act, so ask your tax adviser for the current position rather than relying on a figure you read online.

If some udhaar will never be paid, do not simply tear out the page or strike out the balance. Keep the record, write a note of what happened, and ask your tax adviser how it should be treated in your accounts.

Clean records can help you borrow

A 2020 Dawn article noted that banks avoid lending to kiryana stores partly because they have no collateral and no financial statements. It suggested that recording sales and receivables properly could support working capital loans. That article is a few years old, so treat it as background, but the point holds: a lender, partner or buyer of your business will trust a clear, dated record of who owes you what far more than a verbal estimate.

Start this week

You do not need to fix everything at once. This week, give your ten biggest udhaar customers their own pages, agree an opening balance with each, and start writing every sale and payment the same day. Next month, run the monthly routine. Within a quarter you will know exactly how much money is in the market and who is slow to pay.

If you would like to see how the digital khata in Bin Amir ERP would handle your customers' udhaar, request a demo at binamirerp.com/demo. Someone from our team will set it up for your kind of business and walk you through it.

Frequently asked questions

How do I write udhaar in a khata register?

Give each customer their own page with an agreed opening balance at the top. For every credit sale, write the date, what was taken, the amount in the "udhaar diya" column and the new balance. For every payment, write it in the "paisay mile" column and reduce the balance the same day.

How long should I keep old udhaar registers?

FBR's help page says people with taxable income must keep their records for six years, and Section 174 of the Income Tax Ordinance, 2001 is the rule behind this. If FBR has sent a notice or a case is pending, keep the records until it is decided. Check with your tax adviser for your own situation.

What should I do if a customer says their udhaar balance is wrong?

Show them a statement with the opening balance, each entry with its date and note, and the closing balance. Signed challans and payment receipts usually settle the matter. Sending statements every month stops small differences from turning into big arguments.

Should I set a udhaar limit for each customer?

Yes, it is good practice. Decide the most credit you will allow each customer at one time, write it at the top of their page, and stop new udhaar when they reach it until they pay something. This keeps any one customer from owing more than you can afford to lose.

Can I write off udhaar that a customer will never pay?

Do not just tear out the page or strike out the balance. Keep the record and a note of what happened, such as the customer closing their shop. Ask your tax adviser how unpaid amounts should be treated in your accounts, because the rules have conditions.