Cash Flow Frog logo

AR Aging Report

Table of Contents
1. What Is an AR Aging Report?2. How It's Structured3. Worked Example4. Why It Matters in Practice5. How AR Aging Report Affects Your Cash Flow6. How You'd See This in Cash Flow Frog7. Related Terms

What Is an AR Aging Report?

An AR aging report is a snapshot of all outstanding customer invoices, grouped by how long they have been unpaid. It shows the total receivables balance broken into time buckets, typically current, 31–60 days, 61–90 days, and over 90 days, so a business can see at a glance where its collection risk sits.

How It's Structured

The aging report is not calculated from a formula, it is a sorted view of the accounts receivable ledger, organized by the number of days each invoice has been outstanding since its due date or invoice date, depending on the accounting system's configuration.

Each row typically shows:

  • Customer name
  • Invoice number and date
  • Invoice amount
  • Due date
  • Days outstanding
  • Which aging bucket the invoice falls into

The columns aggregate those invoices into standard time brackets:

Bucket Definition
Current Not yet due, or due within the period
1–30 days overdue Past due by up to 30 days
31–60 days overdue Past due by 31 to 60 days
61–90 days overdue Past due by 61 to 90 days
90+ days overdue Past due by more than 90 days

The total across all buckets equals the closing accounts receivable balance on the balance sheet. If it does not, there is a reconciliation issue in the books.

Some accounting systems age invoices from the invoice date rather than the due date, which can make balances appear older than they are if payment terms are long. Knowing which method the system uses matters when interpreting the report.

Worked Example

A commercial electrical contractor generates an AR aging report at the end of the month. Total accounts receivable is $187,500.

Customer Invoice # Amount (USD) Due Date Days Overdue Bucket
Client A INV-0441 $42,000 Not yet due – Current
Client B INV-0398 $31,500 18 days ago 18 1–30 days
Client C INV-0371 $28,000 44 days ago 44 31–60 days
Client A INV-0352 $19,000 52 days ago 52 31–60 days
Client D INV-0318 $24,000 76 days ago 76 61–90 days
Client E INV-0271 $43,000 103 days ago 103 90+ days
Total $187,500

Aging summary:

Bucket Amount (USD) % of Total
Current $42,000 22%
1–30 days overdue $31,500 17%
31–60 days overdue $47,000 25%
61–90 days overdue $24,000 13%
90+ days $43,000 23%
Total $187,500 100%

This report has a problem. Nearly a quarter of the total receivables balance, $43,000, is more than 90 days overdue. That is not a collection delay; at that age, it is a collection risk. Client E has not paid an invoice for over three months. The business should know why before assuming it will ever arrive.

Client A appears twice: one invoice is current, one is 52 days overdue. That customer is placing new orders while an older invoice sits unpaid, a pattern worth addressing before extending further credit.

Why It Matters in Practice

It makes collection risk visible by customer and by age

The total accounts receivable balance tells you how much is owed. The aging report tells you how healthy that balance actually is. An $187,500 receivables balance where $150,000 is current looks very different from one where $43,000 is over 90 days old and the rest is spread across the overdue buckets. Without the aging breakdown, both balances look identical on the balance sheet. The aging report is what separates a receivables position that is performing from one that is quietly deteriorating.

It tells you where to focus collections effort

Most businesses do not have the administrative bandwidth to chase every overdue invoice with equal intensity. The aging report provides a natural prioritization: the oldest balances with the largest amounts represent the greatest cash risk and should receive attention first. A business that works its aging report systematically, contacting the oldest accounts before moving to newer overdue items, collects more efficiently than one that responds to invoices ad hoc or only follows up after the customer is months late.

It is an early warning system for bad debt

An invoice that ages from current to 30 days overdue may simply reflect a slow payment cycle or an oversight on the customer's side. An invoice that ages from 30 days to 60 to 90 days without resolution is following a different pattern, one that may indicate financial difficulty on the customer's part, a dispute over the work, or an administrative failure that has not been escalated. The aging report catches that progression while there is still time to intervene, request payment, or negotiate a resolution before the amount is written off entirely.

How AR Aging Report Affects Your Cash Flow

An aging report sorts unpaid invoices by how overdue they are. The oldest buckets are the cash most at risk of never arriving.

The cash flow forecast depends on receivables converting to cash on something close to their expected schedule. When a significant portion of the receivables balance is sitting in the 61-day-plus buckets, those amounts are either going to arrive late, shifting the forecast inflows to a future period, or not arrive at all. Both outcomes affect the projected bank balance. An invoice in the 90-day bucket that was included in last month's forecast as an expected inflow has already missed its projected arrival date once. Keeping it in the forecast as a near-term inflow, without adjustment, overstates the projected cash position.

A business that reviews its aging report alongside the cash flow forecast can make that adjustment deliberately: flag the oldest invoices as uncertain, remove them from the near-term inflow projection, and add them back only when payment is confirmed or a specific arrangement is in place. That produces a more conservative, and more accurate, forward view of the cash position. The alternative is a forecast that looks comfortable on paper while a material portion of its projected inflows are sitting with customers who are already three months behind.

How You'd See This in Cash Flow Frog

Cash Flow Frog connects to QuickBooks Online, QuickBooks Desktop, Xero, Sage Intacct, Odoo, Zoho Books, and FreshBooks and builds a rolling cash flow forecast automatically from your accounting data. QuickBooks records what happened. Cash Flow Frog projects what is coming.

The accounts receivable data that populates the aging report in the accounting system feeds directly into the forecast, outstanding invoices appear as projected cash inflows on their expected collection dates. If the aging report shows a cluster of overdue invoices, the forecast reflects the timing consequence: those inflows are projected later than their original due dates, or flagged for review. The transaction-level drill-down means you can see exactly which invoices are driving a projected cash shortfall in any given week, which is more useful than knowing only that inflows are expected to be lower. For businesses with customers across multiple currencies or entities, the receivables picture consolidates natively. More on how Cash Flow Frog supports small business cash flow planning is at cashflowfrog.com/business/small-business/.

Back to Glossary Page

FAQ

Weekly is appropriate for businesses where collections are active and cash flow is tight. Monthly aligned to the accounting close is the minimum for most small businesses. The report becomes less useful the less frequently it is reviewed, because overdue invoices age further before anyone acts on them. A business that only looks at its aging report at quarter-end will find invoices that have been overdue for two months before they are noticed, at which point recovery is far harder than it would have been at 30 days.

Aging from the invoice date counts days from when the invoice was raised. Aging from the due date counts days from when payment was contractually required. For an invoice raised on March 1 with net 30 terms, aging from the invoice date would show it as 45 days old on April 15, while aging from the due date would show it as 15 days overdue on the same date. Aging from due date is more useful for collections purposes, because it directly shows how late a payment is relative to the agreed terms. Knowing which method the accounting system uses is essential for reading the report correctly.

There is no universal threshold, but any material concentration in the 90-day-plus bucket warrants investigation. An invoice reaching 90 days past due on standard 30-day terms has been unpaid for four months from the invoice date, at that point, the probability of collection without active intervention declines, and the probability that the amount will need to be written off increases. Businesses in sectors with notoriously slow-paying clients may have a higher baseline of aged receivables as a structural feature, which changes how the aging distribution should be interpreted.

Yes. Disputed invoices are still outstanding and still represent a potential cash inflow or a write-off risk. Removing them from the aging report hides their impact on the receivables balance and on the cash flow forecast. Best practice is to flag disputed invoices separately within the report, with a note on the nature of the dispute and the expected resolution, so they are visible but distinguishable from overdue amounts that simply have not been paid.

Most bad debt provision methods use the aging report as their primary input. The older a receivable, the higher the probability that it will not be collected, so a higher provision rate is applied to older buckets. A typical approach might apply a 5% provision to invoices 31–60 days overdue, 20% to 61–90 days, and 50% or more to invoices over 90 days, with the rates calibrated to the business's own historical collection experience. The resulting provision reduces the net receivables balance on the balance sheet and records a bad debt expense on the income statement before specific write-offs are formally approved.

Yes, and it is one of the most practical uses. A customer who consistently appears in the 31–60 day bucket is paying, but slowly. One who regularly reaches 90 days is a material risk. Both patterns are visible in the aging history over several months, which gives a factual basis for decisions about credit limits, deposit requirements, or payment terms on future orders. Extending credit to a new customer based only on their initial payment behavior, without later reviewing their pattern in the aging report, misses the information that builds up over time.

Looking for more help?

Visit our help center to find answers to your questions about CashFlowFrog.

Help Centre

Trusted by thousands of business owners

Start Free Trial Now