This receivables aging report turns a list of invoices into the classic aged debtors table. Paste or drop your open invoices with customer, invoice date, amount and any payments, set the as-of date and default terms, and it shows each invoice's due date, days overdue and bucket, then a summary by customer across current, 1–30, 31–60, 61–90, 91–120 and over 120 days, with totals. It runs in your browser.
| Bucket | Days past due |
|---|---|
| Current | Not yet due |
| 1–30 | 1 to 30 |
| 31–60 | 31 to 60 |
| 61–90 | 61 to 90 |
| 91–120 | 91 to 120 |
| Over 120 | 121 or more |
A table of unpaid invoices grouped by how long they are overdue, usually by customer.
From the due date — invoice date plus terms, or the due date you supply — to the as-of date.
Yes, at their remaining balance.
Chase them hard and consider a bad-debt provision.
No. Everything runs in your browser.
For each invoice the due date is taken from a due-date column or the invoice date plus payment terms. Open amount = invoice amount − amount paid; days overdue = as-of date − due date. Open amounts are placed in the current, 1–30, 31–60, 61–90, 91–120 or over-120-day bucket, and totalled by customer and overall, with the overdue share and the amount over 90 days.