What Your Invoice Aging Report Is Telling You — And What to Do About Each Bucket

An invoice aging report (or accounts receivable aging report) is a snapshot of what you're owed, organized by how long each amount has been outstanding. Invoices are grouped into time buckets—typically 0–30 days, 31–60 days, 61–90 days, and 90+ days—based on days past the due date.

Each bucket shows the invoices (and total amounts) in that range. Example: You might see $2,000 in 0–30, $4,500 in 31–60, and $1,200 in 61–90. That tells you $5,700 is overdue, with most of it in the 31–60 bucket. For more on managing receivables, see our accounts receivable management tips.

A flat list of unpaid invoices shows you what's owed. An aging report shows you what's at risk. The distinction matters because collection rate and invoice age are directly correlated: invoices collected within 30 days have near-100% recovery rates. By 60 days that drops significantly. After 90 days, recovery rates often fall below 50% without formal escalation. The key metric to watch alongside your aging report is Days Sales Outstanding (DSO) — your average collection time across all invoices.

• Prioritization: Focus on high-value, older invoices first.
• Cash flow visibility: You see how much is at risk and when. The cash flow calculator quantifies the annual cost of your outstanding AR.
• Pattern spotting: Repeated late payers show up in higher buckets.
• Bad debt risk: Use the bad debt calculator to estimate write-off risk in your 61–90+ day buckets before they become unrecoverable.

A good way to track invoices includes aging or equivalent visibility. If you don't know what's aging, you can't act on it.

Standard buckets and what they mean:

• 0–30 days: Current or slightly overdue. Friendly reminder if past due.
• 31–60 days: Overdue 1–2 months. Prioritize follow-up; escalate tone if needed.
• 61–90 days: Overdue 2–3 months. Firm escalation, late fees, or demand letter.
• 90+ days: High risk. Consider collections, small claims, or write-off.

Some reports use 0–30, 31–45, 46–60, 61–90, 90+. The principle is the same: older = higher risk. Watch for invoices about to age into the next bucket—a 28-day-old invoice needs attention before it becomes 31–60.

Spreadsheet: List each invoice with client, amount, due date. Add a "Days Overdue" column (today minus due date). Add an "Aging Bucket" column with a formula or manually assign 0–30, 31–60, etc. Use filters or pivot tables to summarize by bucket.

Software: Many invoice and accounting tools (QuickBooks, Xero, FreshBooks, etc.) generate aging reports automatically. Invoice tracking tools like InvoiceGrid often surface aging through a Today View or dashboard—showing what's overdue and for how long.

Run the report at least weekly. Update when you receive payments so the snapshot stays accurate. For more on tracking options, see our best way to track invoices guide.

Use the report to build your weekly chase list. The prioritization logic is straightforward: oldest bucket first, then highest amount within that bucket. A $5,000 invoice 45 days overdue gets priority over a $300 invoice 10 days late. A $1,000 invoice 75 days overdue may need formal escalation rather than another reminder email.

In practice: open your aging report on Monday morning. Look at everything in the 31–60 bucket — these are your highest-value recovery opportunities before the situation becomes formal. Then check the 61–90 bucket — these likely need a firm notice or a direct call. Anything in the 90+ bucket needs a decision: pursue formally or write off. Use our AR management tips for the full follow-up cadence by bucket.

A traditional aging report is a table. A visual alternative is a "who to chase today" view—invoices due or overdue, sorted so you see the most urgent first. InvoiceGrid's Today View does this: it shows which invoices need attention today based on due date and status (Pending, Reminded, Follow-up).

Combined with the Kanban board (Pending → Reminded → Follow-up → Paid), you get visual aging: you see what's new, what's in progress, and what's done. Chase History logs every follow-up per invoice. It's not a numeric aging report, but it serves the same purpose—prioritizing what to work on. See InvoiceGrid pricing for features.