September 2026 8 min read

Accounts receivable aging explained for retailers

The khata tells you how much the mohalla owes you. An aging report tells you something far more useful: who owes it, and how long each rupee has been waiting. It is the single report that turns "logon ka udhaar hai" into a collections plan — and once you can read one, you will never look at a single receivables total the same way again.

1. What an aging report actually is

Accounts receivable is simply everything customers owe you — every udhaar entry sitting unpaid. An aging report takes that total and sorts each customer's balance by age: how many days have passed since the credit sale happened. Instead of one scary figure like Rs 312,000 outstanding, you get the same money laid out in columns — current, a month old, two months old, older — per customer. The report needs no accounting background to read: it is your khata, organised by urgency.

2. The buckets: what 0–30, 31–60, 61–90 and 90+ mean

Standard aging splits balances into day-ranges, and each range carries a different meaning for a retail shop:

0–30 days (current): normal udhaar doing its job — regulars settling on payday or month-end. No action needed beyond an occasional statement.
31–60 days: the reminder zone. A polite nudge with the exact balance usually moves these; silence lets them slide further.
61–90 days: the warning zone. New credit should pause here, and the customer needs a personal call or visit, not another message.
90+ days: the danger zone. Collection odds drop sharply — this money needs a written instalment plan, active recovery, or an honest write-off decision.

3. A worked example from a real-feeling khata

A garment-and-general store in Rawalpindi shows Rs 312,000 total receivable across 35 customers. Aged properly, it reads: Rs 198,000 in 0–30 (63% — healthy), Rs 64,000 at 31–60, Rs 31,000 at 61–90, and Rs 19,000 past 90 days. Two facts jump out immediately. First, Rs 50,000 — one-sixth of everything owed — is in the danger zones, and three names carry almost all of it. Second, the Rs 64,000 sitting at 31–60 is this month's easy win: still fresh, still collectable with simple reminders before it ages into real risk. None of that is visible in the single Rs 312,000 figure.

4. Why older money is harder to collect

Fresh debt collects because the purchase is still in the customer's mind — they remember the goods, they remember the promise. As weeks pass, three things work against you: the memory fades and the balance starts feeling negotiable; the customer reorganises their spending around a life that no longer includes paying you; and their silence trains itself into a habit. A balance that crosses 90 days unpaid is not just late — it is teaching the customer that your khata has no teeth, which is why aging exists: to catch money while it is still easy to move.

5. How to read your aging report in five minutes

Open the receivables aging in SYEZPOS and run this checklist — it takes minutes, not hours:

Start with the biggest balances past 60 days — those are this week's calls, regardless of who the customer is.
Check the 31–60 bucket total: growing month over month means reminders are going out too late or not at all.
Count how much of the total sits in 0–30 — under half is a warning that credit policy, not just collections, needs attention.
Note any customer still buying on credit while an old balance sits unpaid — that account needs a pause today.

6. From report to action: the weekly loop

An aging report read once a quarter is an autopsy; read weekly, it is a steering wheel. Tie it to one recovery slot — Friday after Jummah, Monday morning, whatever survives contact with your week — and work top-down: statements and reminders for the 31–60 bucket, calls and visits for 61–90, firm decisions past 90. The full chasing playbook is in how to reduce overdue customer payments, and the limits that keep buckets small live in controlling customer credit. Because SYEZPOS posts every credit sale and partial payment from the counter into the ledger, the aging builds itself — the same discipline a paper khata demands, without the fortnight of catching up described in digitizing the udhaar khata. It also feeds straight into your wider financial reports, so receivables are never a separate mystery.

An aging report is not an accounting ritual — it is a collections to-do list sorted by urgency. If you can say, in one minute, how much of your khata is past 60 days and whose names sit there, the report is doing its job.

Frequently asked questions

What is a healthy aging mix for a retail shop?

Most of the money should sit in the 0–30 bucket — in a healthy shop roughly 70–80% — with small amounts at 31–60 and almost nothing past 90. When the 60+ share keeps growing month over month, collections are slipping even if sales look fine.

How often should I look at the aging report?

Weekly if udhaar is a real part of your sales — run it on your chosen recovery day and work it top-down. Monthly is enough only when credit is a tiny share of the business; for a credit-heavy shop, a monthly look lets 30-day problems quietly become 90-day losses.

Is the aging report different from my khata total?

The khata total is one number — everything owed to you. The aging report splits that same money by how long each amount has been waiting, which is what tells you who to call first and which balances are drifting towards never arriving.