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.

Example rows
CustomerInvoice no.Invoice dateDue dateCurrent1 to 3031 to 6061 to 90Over 90Total dueNext step
Maple Street Dental10422026-03-032026-04-02$1,095.40$0.00$0.00$0.00$0.00$1,095.40Due soon
Hill Country Cafe10312026-02-102026-03-12$0.00$780.00$0.00$0.00$0.00$780.00Email reminder
Brightline Realty10092026-01-062026-02-05$0.00$0.00$2,240.00$0.00$0.00$2,240.00Call owner
Oak Ridge HOA09872025-12-012025-12-31$0.00$0.00$0.00$0.00$1,350.00$1,350.00Final 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.

Sources

General information, not tax advice for your situation.

Want your books off your plate?

One accountant keeps them current, every month.

See our bookkeeping service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
What 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.