Accounts Receivable Aging Report

What an aging report actually shows

An aging report is a snapshot, not a to-do list: it groups every invoice you haven’t been paid for by how long it’s been outstanding, so you can see the shape of the problem instead of one invoice at a time. The buckets here are the usual ones an accountant expects: current (not yet due), 1-30, 31-60, 61-90, and 90+ days late. As a rule of thumb, the older an unpaid invoice gets, the less likely it is to be collected at all, which is exactly why these buckets exist: a pile of money in the 90+ column is a different problem than the same amount sitting in 1-30.

Aging by due date vs. invoice date

Aging by due date answers “how overdue is this,” measured from the date payment was actually owed: an invoice isn’t late until its due date passes, so this is what most people mean by an aging report. Aging by invoice date instead measures from the day you sent the invoice, useful if you want to see how long money generally sits outstanding regardless of the payment terms you happened to give that client. If a row has no due date, both modes fall back to its invoice date automatically.

What this is, and what it isn’t

This only totals what you type in: it doesn’t know which of your invoices are actually paid, so leave paid ones out entirely rather than marking them somehow. Nothing here is uploaded anywhere; the report is built and totaled in this browser tab, on your own device, and saved only in this browser’s local storage so it’s still here next time you open the page.

An aging report shows where money is stuck. A cash flow forecast shows what that means for the weeks ahead, once what’s still going out is factored in too.

Frequently asked questions

Should I include paid invoices in this report?

No. This report is only for invoices that are still outstanding. Once an invoice is paid, leave it out. The tool only totals what you type in, so including paid invoices will give you a wrong picture of what is actually owed.

What’s the difference between aging by due date and aging by invoice date?

Aging by due date answers “how overdue is this”, measured from when payment was owed. Aging by invoice date measures from when you sent the invoice, useful if you want to see how long money generally sits outstanding regardless of terms. Most people use due date aging.

Why are invoices grouped into 30, 60, 90 day buckets?

These are standard aging buckets accountants expect. As invoices get older, they become less likely to be collected. The older the money sits, the more urgent the collection becomes. The buckets help you see the shape of the problem at a glance.

Can I export this report as a file?

Yes. Use the “Download CSV” button in the “By customer” section to download a spreadsheet. You can then sort or filter it in Excel or Sheets.

If I have no data to enter, what does the report show?

The report is blank until you add at least one outstanding invoice with a customer name and amount. Once you do, the totals and breakdowns calculate automatically.

Related tools

• Invoice payment tracker: the day-to-day working list, one row per invoice, that you update as payments come in. This report is the periodic snapshot you pull from a moment like that; the tracker is what you keep open all the time.
• Overdue invoice reminder letter: once this report shows you who’s late, write the follow-up for a specific invoice here.