Receivables aging calculator for Indian client invoices
A total outstanding figure can look perfectly healthy while one invoice from four months ago sits inside it. Enter your open invoices and this tool buckets them by age, so the old ones become visible as the exceptions they are.
Bucket your outstanding invoices
Add one row per open invoice with its amount and how many days it has been outstanding. The three rows already in the tool are placeholders — replace them with your real list.
Receivables by ageing bucket
| Ageing bucket | Invoices | Value | Share of total |
|---|---|---|---|
| 0–15 days | 1 | ₹45,000 | 28.4% |
| 16–30 days | 1 | ₹82,500 | 52.1% |
| 31–60 days | 1 | ₹31,000 | 19.6% |
| 61–90 days | 0 | ₹0 | 0% |
| 90+ days | 0 | ₹0 | 0% |
- Invoices counted
- 3
- Over 60 days
- ₹0
- Over 60 days share
- 0%
- Oldest open invoice
- INV-1035 · 47 days · ₹31,000
- Largest client exposure
- Client B · ₹82,500 (52.1%)
The rows above are placeholders — replace them with your real open invoices. Ageing here is days outstanding from the invoice date, and this is a planning view rather than a formal ageing statement: credit notes, advance payments, and part-paid invoices change what each row is really worth. Ageing is only worth keeping if somebody owns the outstanding list and works it.
How this is calculated
Bucket = the band that contains days outstanding
Bands = 0–15, 16–30, 31–60, 61–90, 90+
Bucket total = Σ invoice amounts in that band
Share % = Bucket total ÷ Total outstanding × 100
Over 60 days = (61–90 bucket) + (90+ bucket)Days outstanding is measured from the invoice date, so the same entry moves one band to the left every day without anyone touching it. A row missing a valid amount or a valid day count is left out of every total rather than counted as zero, and the tool tells you how many rows it had to exclude.
Worked example
Take three open invoices: ₹45,000 at 12 days, ₹82,500 at 28 days, and ₹31,000 at 47 days. Total outstanding is ₹1,58,500. They land in the 0–15 band (₹45,000, 28.4% of the total) and the 16–30 band (₹82,500, 52.1%), with ₹31,000 — 19.6% — in the 31–60 band.
Nothing there is over 60 days yet, so the collections effort is a reminder rather than an escalation. Now add a fourth invoice of ₹60,000 at 94 days. The total becomes ₹2,18,500 and the over-60 figure jumps to ₹60,000, or 27.5% of everything owed. That single line is the one worth a phone call today, and it is completely invisible inside a healthy-looking total of ₹2,18,500.
How to work the list, not just read it
Ageing is a prioritisation tool, not a report. The value of splitting by age is that it tells you where to spend the next hour: the 90+ band first, then 61–90, then a courtesy reminder on everything still inside terms. If a business chases invoices in the order they were typed into a spreadsheet, most of the chasing effort goes to the newest and least urgent ones.
For each invoice, know three things before you pick up the phone: what was agreed, when the invoice was raised, and whether a payment date was ever promised. A payment promise recorded against the invoice gives the follow-up a date to refer to, which turns a vague chase into a specific question — and stops collection from depending on whoever remembers hardest.
Ageing is only worth maintaining if somebody owns it. A shared outstanding list with nobody accountable becomes a shared outstanding list that ages every month, and the oldest invoices become too embarrassing to raise, which is exactly how they end up written off.
What this tool does not do
- It is not a formal ageing statement. Credit notes, advances, and part-paid invoices change what each row is really worth, and that reconciliation belongs in the billing system.
- It does not chase anyone. It sorts what you already owe being owed; the follow-up is a person, not a report.
- It does not handle credit terms. Every invoice is judged from its own date, so a 60-day-terms client is not flagged for being 45 days old.
Related tools
- Project Profitability Calculator — check whether the work behind those invoices was worth doing.
- Profit Margin Calculator — margin once the cost side is actually recorded.
- Billing Software Cost Calculator — what billing software costs your business over a year.
- Quotes, Billing & Finance — where outstanding value and payment promises live.
- Reports & Economics — outstanding read per client and by ageing.
- All free tools for small business operations.
Want the outstanding list to be a queue, not a monthly reckoning?
In NoxOrigin, receivables stay visible per client and by age, and money arriving with a promise attached is recorded as a payment promise with a date. An invoice that sat for four months then shows up as an exception instead of sitting inside a total that looks acceptable because it is averaged across everything else.
Collection still needs a named owner. Software can keep the list honest; it cannot decide who picks up the phone.