Accounts receivable aging report
An accounts receivable aging report lists every unpaid customer invoice and how overdue it is, in buckets of current, 1 to 30, 31 to 60, 61 to 90 and over 90 days. This free template totals each bucket, so you can see who to chase first and how much of your sales are stuck as unpaid invoices.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Customer | Invoice no. | Invoice date | Due date | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total due | Next step |
|---|---|---|---|---|---|---|---|---|---|---|
| Maple Street Dental | 1042 | 2026-03-03 | 2026-04-02 | $1,095.40 | $0.00 | $0.00 | $0.00 | $0.00 | $1,095.40 | Due soon |
| Hill Country Cafe | 1031 | 2026-02-10 | 2026-03-12 | $0.00 | $780.00 | $0.00 | $0.00 | $0.00 | $780.00 | Email reminder |
| Brightline Realty | 1009 | 2026-01-06 | 2026-02-05 | $0.00 | $0.00 | $2,240.00 | $0.00 | $0.00 | $2,240.00 | Call owner |
| Oak Ridge HOA | 0987 | 2025-12-01 | 2025-12-31 | $0.00 | $0.00 | $0.00 | $0.00 | $1,350.00 | $1,350.00 | Final notice |
| Total | $1,095.40 | $780.00 | $2,240.00 | $0.00 | $1,350.00 | $5,465.40 |
How do I read an aging report?
Every open invoice sits in one column, depending on how far past its due date it is. Most of your total should be in Current. Money drifting right, into 31 to 60 and beyond, means slower collection and a cash squeeze ahead. The older an invoice gets, the less likely it is to be paid in full.
What should I do about old invoices?
Follow up at fixed points: a friendly reminder a few days after the due date, a call at 30 days, a firm notice at 60, and a decision at 90. Card or ACH payment links on every invoice cut late payment a lot.
How do write-offs work for taxes?
If you use cash-basis accounting, unpaid invoices were never counted as income, so there's nothing to deduct. On the accrual basis, a debt you counted as income and can't collect may be deductible as a bad debt in the year it becomes worthless. Ask us before you write off a large one.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceWhat is a good average collection time?
It depends on your terms. Most small businesses aim to collect within 30 to 45 days on Net 30 invoices.
Can QuickBooks run this report?
Yes. QuickBooks Online and Xero both have an A/R aging summary and detail report, as long as invoices and payments are recorded in them.
Should I charge late fees?
Only if your contract or terms say so, and within your state's limits. State them on the invoice.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.