Accounts Receivable Aging Report

Summarize unpaid invoices by age, identify collection risk, and download a detailed aging template for Excel or Google Sheets.

Accounts receivable aging buckets

A useful report includes customer, invoice number, invoice and due dates, original amount, open balance, days overdue, aging bucket and collection notes.

The free interactive tool is available above when JavaScript loads. No signup is required.

How to prepare an accounts receivable aging report

Calculate age from each invoice due date, not from the last reminder. Group open balances into current, 1–30, 31–60, 61–90 and more than 90 days overdue, and keep disputed invoices visible with a note.

Frequently asked questions

What is an accounts receivable aging report?

It groups unpaid invoices by how long they have been outstanding or overdue.

How often should I review invoice aging?

Weekly review is useful for small businesses because it catches approval delays and disputes before invoices become seriously overdue.

What belongs in an aging report?

Include customer, invoice number, issue and due dates, original amount, open balance, days overdue, aging bucket and collection notes.