Invoice aging report
Group invoice amounts by how many days old they are, and total each group.
Result
Invoice aging report
Total open
—
Enter an as-of date and at least one invoice.
Estimate for planning only. This is not tax, legal, accounting or financial advice. Results depend on the figures you enter. Check all numbers, rates and rules with the official source or a qualified professional before relying on them.
How this works and common questions
About this tool
This report counts calendar days from each invoice date to the as-of date you type, then totals the amounts in four age groups. Nothing is stored.
How it works
Age is the number of calendar days from the invoice date to the as-of date. Current is 0 to 30 days. Then 31 to 60, 61 to 90, and 91 or more. An invoice dated on the as-of date is 0 days and sits in Current. Totals add the amounts in cents.
Rules
Days are calendar days, not business days. No holiday list is used. A future invoice date is still Current, and the result says so. On 3 October 2026, an invoice from 1 October is 2 days, from 2 September is 31 days, from 3 August is 61 days, and from 4 July is 91 days.
Questions
Which group is an invoice dated the same day?
Age is 0 days, so it is Current. Current runs from 0 days through 30 days.
What are the four groups?
Current is 0 to 30 days. Then 31 to 60, 61 to 90, and 91 days or more. Day 30 stays in Current. Day 31 moves to the next group. Day 90 stays in 61 to 90. Day 91 is 91 or more.
What if the invoice date is after the as-of date?
The age is negative and the amount is counted in Current. The result says that one or more invoices are dated after the as-of date.
Do I need an account?
No. The tools work without one. You only need to sign in to save your work.
Is what I type saved?
No. Nothing is saved unless you sign in and choose Save. Otherwise it stays on the page.
Do you show ads or sell my information?
No. We show no ads and we do not sell your information.
Is this tax or legal advice?
No. Results are estimates for planning. Check rates and rules with the official source or a qualified professional.
Sign in to save this. Your entries stay on screen.
Estimate for planning only. This is not tax, legal, accounting or financial advice. Results depend on the figures you enter. Check all numbers, rates and rules with the official source or a qualified professional before relying on them.