How it works
Compare each due date with the as-of date. Group unpaid balances into current, 1–30, 31–60, 61–90 and 91+ calendar days past due.
Input definitions
- CSV: invoice,due date,unpaid amount
- Plain text; maximum 200,000 characters.
- As-of date
- A complete Gregorian calendar date.
A worked example
- CSV: invoice,due date,unpaid amount
- invoice,due,amount INV-1,2026-09-01,500 INV-2,2026-10-31,300
- As-of date
- 2026-10-17
Assumptions & limits
Calendar-day aging with a manually entered as-of date. No automatic bank or invoicing account connection.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Is an overdue invoice automatically a bad debt?
No. Aging reports timing, not collectability. Disputes, payment plans and accounting treatment require separate review.
How does Invoice aging report work?
Compare each due date with the as-of date. Group unpaid balances into current, 1–30, 31–60, 61–90 and 91+ calendar days past due.
What are the limits of Invoice aging report?
Calendar-day aging with a manually entered as-of date. No automatic bank or invoicing account connection.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.