
Receivable Ageing Report: How Pakistani Businesses Can Track Udhaar and Recover Payments Faster
In short: A receivable ageing report lists every customer who owes you money and sorts each unpaid invoice by how long it has been outstanding: current, 1–30 days, 31–60, 61–90 and over 90 days. Reviewing it every week tells you who to call first, which customers to stop supplying on credit, and how much of your “sales” is really cash you may never collect. This guide shows how to read the report, a weekly recovery routine, and the mistakes that let udhaar pile up.
For many wholesalers, distributors, manufacturers and traders in Pakistan, credit sales are normal. A shopkeeper takes stock today and pays after the next market cycle. The problem is not giving credit; it is losing track of it. When balances live in a register, a WhatsApp chat and the salesman’s memory, nobody can say quickly how much is overdue, since when, and from whom. Profit on paper then looks healthy while the bank account stays empty.
What a receivable ageing report shows
The report takes your customer ledgers and breaks each customer’s balance into time buckets based on the invoice date or due date. A simple version looks like this:
| Customer | Current | 1–30 days | 31–60 days | 61–90 days | Over 90 days | Total |
|---|---|---|---|---|---|---|
| Customer A | 120,000 | 40,000 | 0 | 0 | 0 | 160,000 |
| Customer B | 0 | 25,000 | 60,000 | 15,000 | 0 | 100,000 |
| Customer C | 0 | 0 | 0 | 35,000 | 90,000 | 125,000 |
The figures above are an illustration only. Customer A owes the most but is healthy: most of the balance is recent. Customer C owes less but is the real risk, because most of the money is more than three months old. Without ageing, you would chase A first.
If you give every customer the same credit period, ageing by invoice date is fine. If different customers get 15, 30 or 45 days, age by due date instead, so a customer on 45-day terms is not shown as late on day 20.
Why udhaar gets out of control
- Payments are not matched to invoices. A customer pays a round amount “on account” and nobody records which bills it clears. The oldest invoices stay open on paper while new ones are paid.
- No credit limit. Salesmen keep supplying a customer whose old balance is already overdue, because nobody stops the order at billing.
- Returns and discounts are not posted. The customer refuses to pay because your balance is higher than theirs, and the dispute drags on for months.
- Follow-up depends on one person. When the salesman leaves, the knowledge of who owes what leaves with him.
- Nobody looks at the total. Each balance seems small, but together they can be several months of profit.
A weekly recovery routine that works
- Post everything first. Before running the report, make sure all sales invoices, receipts, returns and discounts up to yesterday are entered. An ageing report on half-posted data sends you after the wrong customers.
- Match receipts to invoices. Apply each payment to specific invoices, normally the oldest first, so the buckets are accurate.
- Sort by the oldest bucket, not the biggest balance. Start with customers who have amounts over 90 days, then 61–90 days.
- Send a statement before you call. Share a customer statement on WhatsApp or email listing open invoices, so the conversation is about specific bills, not a single disputed total.
- Agree a date and record it. Note the promised payment date and amount against the customer and check it the following week.
- Resolve disputes quickly. If the customer says a return or rate difference is not adjusted, check and fix it the same week. Unresolved disputes are the main reason old balances never clear.
- Put risky customers on hold. For customers past an agreed limit, require payment or management approval before the next delivery.
- Review the total trend monthly. At month end, compare total receivables and the share over 60 days with the previous month. If the old buckets keep growing, your credit policy needs to change.
Set a simple credit policy
A written policy, even one page, removes arguments with customers and staff. It should state:
- the standard credit period, for example 30 days, and who may approve longer terms;
- a credit limit for each customer, reviewed every few months against how they actually pay;
- what happens when a customer is overdue, for example a reminder at 7 days late, a call at 15 days and a hold on new supplies at 30 days;
- how cheques, bank transfers and cash receipts must be recorded and by whom;
- who can give discounts or write off small balances.
Apply it consistently. Customers soon learn which suppliers follow up and which do not, and they pay the ones who follow up first.
Doing it in Excel vs accounting software
You can build an ageing report in Excel with invoice dates, amounts and a formula for days outstanding. It works for a handful of customers, but it breaks down as you grow: receipts must be matched by hand, returns are forgotten, and the file is out of date the moment a new sale is made.
Good accounting software builds the report automatically from the same sales invoices and receipts you already enter. Look for features such as:
- receipts applied against specific invoices;
- customer-wise and salesman-wise ageing, with your own bucket sizes;
- credit limits that warn or block at billing time;
- customer statements that can be shared on WhatsApp or email in a click;
- branch-wise and area-wise receivable reports for distributors.
If your sales are reported through FBR digital invoicing, the same sales invoices should feed both the FBR submission and the customer ledger, so the two never disagree.
Common mistakes to avoid
- Running the report once a quarter. By then a 30-day balance has become 120 days.
- Leaving unapplied receipts and advance payments sitting on account, which makes customers look worse or better than they are.
- Chasing the friendliest customers instead of the oldest balances.
- Not separating disputed amounts from simply late ones.
- Keeping very old balances on the books for years without a decision. Review them with your accountant and decide whether to pursue, settle or write off.
When a customer pays with dated cheques, review the ageing together with your post-dated cheque register, so invoices stay open until the cheque clears.
See who owes you, and since when, in one report
Switcher Techno’s accounting and inventory software gives you customer ledgers, receivable ageing, credit limits and statements from the same invoices you already issue, with local support from Karachi. Book a free demo and bring your current udhaar list.
Frequently asked questions
What is a receivable ageing report?
It is a report that lists money customers owe you and splits each balance into time periods, such as current, 1–30, 31–60, 61–90 and over 90 days, so you can see which amounts are late and by how much.
How often should I check receivable ageing?
Weekly is a good habit for businesses that sell on credit, with a fuller review at month end. Daily checks make sense if you have many credit customers or high-value orders.
Should ageing be based on invoice date or due date?
Use invoice date if all customers have the same credit period. Use due date if credit terms differ by customer, so that customers on longer agreed terms are not shown as overdue too early.
Which customers should I follow up first?
Start with balances in the oldest buckets, such as over 90 days, and with customers who are over their credit limit, rather than simply the largest balances.
Can I make an ageing report in Excel?
Yes, for a small number of customers. As the number of invoices grows, matching receipts and returns by hand becomes slow and error-prone, and accounting software that builds the report from posted invoices is more reliable.
What should I do with very old balances?
Separate disputed amounts from late ones, try to settle disputes, and agree a payment plan where possible. For balances that are unlikely to be collected, discuss with your accountant whether to keep pursuing them or write them off.
Figures in the example table are illustrative. This article is general guidance, not legal, tax or accounting advice. Please confirm your own position with a qualified adviser before writing off balances or taking recovery action.
