Invoice Aging Report
Who owes you, how much, and how overdue — bucketed by age so you chase the right money first.
Add unpaid invoice
Aging summary
Not yet due
₹0.00
1–30 days
₹0.00
31–60 days
₹0.00
61–90 days
₹0.00
90+ days
₹0.00
Total
₹0.00
Loading…
Invoices in this report (0)
Nothing added yet.
What is debtor aging analysis, and who uses it?
An invoice aging report, also called accounts receivable aging or debtor aging analysis, lists the money customers owe you and sorts it by how far past the due date each invoice is. Your sales figures show what you earned; the aging report shows how much of it is still sitting with customers. Owners use it to plan collection calls. Banks commonly ask for a debtors list by age when working out drawing power on a cash credit account. Your CA/CPA uses it at year end to judge which old balances may never come in and should be treated as bad debt.
For a GST-registered business, an unpaid invoice costs more than the wait. GST on a sale generally becomes payable based on the invoice date, not the date the customer pays, so you deposit the tax in your next return even if the customer has not paid you anything. A customer who pays 60 days late is borrowing that tax from you as well. Companies also have to show trade receivables by age in the notes to their balance sheet, so a running aging list makes the year-end close quicker. Tracking days sales outstanding month on month tells you whether collections are improving.
What the AR aging report shows
Five aging buckets
Invoices fall into Not yet due, 1–30, 31–60, 61–90 or 90+ days overdue, measured against today's date, with a total for each bucket and overall.
Customer-wise rows
All of a customer's unpaid invoices roll up into one row, sorted so the customer who owes the most is at the top.
Pull from Customer Ledger
Bring in every customer who still has an udhaar balance in your Setu Customer Ledger, dated from their oldest credit entry.
Past-due warning
A highlighted line shows the total already past due, so you see the size of the collection job at a glance.
Invoice list by due date
Below the summary, every invoice is listed with the earliest due date first and tagged when it is overdue, with a Paid / remove button.
CSV export
Download one row per customer across all five buckets plus a totals row, ready for Excel or Google Sheets.
How to use the free invoice aging report
- 1Under Add unpaid invoice, enter the customer name, the invoice number, the due date and the amount still outstanding, then tap Add to report.
- 2Repeat for each unpaid invoice. For a part-paid invoice, enter only the balance the customer still owes.
- 3If you keep udhaar in the Setu Customer Ledger, tap Use workspace on the banner if it appears, then Pull from Customer Ledger. Every customer with a balance comes in as one line, and this replaces the invoices currently in the report.
- 4Read the Aging summary: the total in each bucket, the grand total, and one row per customer with the biggest balance first.
- 5When a customer pays, tap Paid / remove on that invoice in the list below the summary.
- 6Tap Export CSV to download the customer-by-bucket table for follow-up calls or for your accountant.
Pulled ledger balances age from the oldest udhaar
When you pull from the Customer Ledger, each customer's whole balance is dated from their oldest credit entry, because a khata has no invoice due dates. A customer who took credit on 1 August and has paid part of it since will still show the full remaining balance as 77 days overdue on 17 October. That is the cautious view, and it suits collections. For invoices on agreed terms such as Net 30, add them by hand with the real due date instead, so customers who are still within terms are not chased early.
Related tools for collections
Frequently asked questions
A view of all unpaid customer invoices grouped by how overdue they are — not yet due, 1–30, 31–60, 61–90 and 90+ days. It's the standard tool for prioritising collections.
The oldest. Collection odds fall sharply with age — industry studies put the expected recovery of a debt past 90 days well below face value. The 90+ column is your priority list.
Money in the 30+ buckets is working capital you're lending interest-free while possibly paying for your own credit. Check the Payment Terms calculator to price early-payment discounts that pull cash in faster.
From the due date you enter, not the invoice date. An invoice due today or later is Not yet due. After that, the days since the due date decide the bucket: 1–30, 31–60, 61–90 or 90+. An invoice due on 10 September is 37 days overdue on 17 October and appears in the 31–60 column. Invoices move into older buckets automatically as time passes.
An aging report covers all your customers at once and groups what they owe by how overdue it is, so you can decide whom to chase first. A customer statement covers one customer and lists every invoice, payment and credit note with a running balance. Use the aging report to plan collections, then send each overdue customer a statement with your reminder.
Remove it and add it back at the reduced amount. The report has no part-payment entry, so tap Paid / remove on the invoice and add it again with the balance still due and the original due date. Keeping the original due date means the remaining amount stays in the right bucket instead of looking freshly issued.
There is no fixed day count. Most businesses review everything in the 90+ bucket with their accountant at year end and write off amounts where the customer has closed, cannot be traced or has refused to pay despite repeated reminders. Keep a record of the calls, messages and statements you sent, because it supports the decision if your auditor asks why a balance was written off.