Accounts receivable aging report: What does each aging bucket tell you?

What is an accounts receivable aging report?

An accounts receivable (AR) aging report breaks down everything your customers owe you by how far past due each invoice is. It's the primary tool AR teams use to spot collection risk before it becomes a cash flow problem.

Building and reading an aging report helps you prioritize collections, forecast cash flow, and reduce bad debt. The same framework works whether you track receivables in a spreadsheet or through your accounting software.

What does an AR aging report show?

Every unpaid invoice your company is owed gets grouped into time-based categories called aging buckets. Each bucket represents a range of days past the invoice due date, giving you a snapshot of where your outstanding revenue sits and how quickly it's being collected.

Most reports follow a standard set of buckets:

The further an invoice moves across these buckets, the less likely you are to collect it. The report also reveals where collection risk is concentrated and growing.

A typical report lists each customer on its own row, with their total outstanding balance broken down by bucket. If a customer owes you $50,000 with $30,000 current and $20,000 in the 1–30 day column, that's a different situation than $50,000 sitting entirely in the 90+ column.

What should you do with your AR aging report?

Your aging report informs decisions across five areas of your accounts receivable management process.

Focus collection time where it matters most

The aging report shows your AR team where to spend their hours by highlighting which invoices are closest to becoming uncollectible. Start with the 61–90 day and 90+ day buckets, where each passing day reduces the likelihood of payment.

This prioritization matters most when you're managing hundreds of open invoices. The report gives your team a collection queue ordered by risk rather than an unordered list of overdue invoices.

Forecast cash flow

The distribution of invoices across aging buckets gives you a forward-looking view of when cash is likely to arrive. If most of your outstanding AR sits in the current and 1–30 day buckets, you can expect relatively predictable inflows over the next month. If a growing share is migrating into the 60+ day range, your near-term cash flow forecast needs to account for delayed or missed payments.

This matters for any decision that depends on available cash.

Refine your credit policies

When the same customers repeatedly show up in older aging buckets, that's a signal to revisit the payment terms you've extended to them. You might shorten net-60 terms to net-30, require deposits on new orders, or set credit limits that prevent a single customer from concentrating too much of your AR exposure.

Estimate bad debt reserves

You're required to estimate how much of your receivables won't be collected and set aside a reserve on your balance sheet. The aging report is the most common input for that calculation.

Invoices in the current bucket have a high probability of collection, so you reserve a small percentage. Invoices in the 90+ day bucket have a much lower probability, so you reserve a larger share. Applying these percentages across your full aging schedule gives you a defensible allowance that auditors can verify.

Track collection efficiency over time

Pulling aging reports on a regular schedule lets you see whether your AR process is improving or deteriorating. A shrinking share of invoices in older buckets means your collection efforts are working, while a growing share signals that something in your process or customer mix has changed.

Pair the aging report with your days sales outstanding (DSO) calculation for a more complete view. DSO measures the average number of days it takes to collect payment after a credit sale. When DSO rises alongside a shift toward older buckets, the two metrics together confirm a real slowdown in collections.

How to spot patterns in your aging report

The distribution across customers and time periods often tells you more than the totals alone.

Look at concentration, not just totals

A $200,000 total AR balance might look healthy until you notice that $150,000 of it sits with a single customer in the 61–90 day bucket. Concentration in a single account amplifies the impact if that receivable goes bad.

Review both the dollar amounts and the customer distribution across buckets.

Compare across periods

Comparing two or three consecutive reports reveals whether the situation is stable, improving, or getting worse. Is the 90+ day bucket growing? Are the same customers moving from the 31–60 column to the 61–90 column between pulls?

Segment by customer type

If your business serves different customer segments, break the aging report down accordingly. Your enterprise customers might pay reliably on longer terms while your smaller accounts generate more overdue invoices on shorter cycles. Segmenting helps you apply the right collection strategy and credit terms to each group.

What red flags can your aging report reveal?

Three patterns in your aging report signal collection problems worth investigating.

Rising days sales outstanding

When your DSO climbs steadily over several reporting periods, your average collection cycle is lengthening. This can point to gaps in invoicing, payment terms that don't match certain customers' payment behavior, or a follow-up cadence that could be more frequent. The fix starts with identifying which aging buckets are growing and whether the trend is broad or concentrated in a few accounts.

Heavy concentration in the 90+ day bucket

Invoices that pass the 90-day mark have a low probability of full collection. When a significant portion of your total accounts receivable balance lands here, you're carrying risk that likely needs to be written off or escalated. Tightening your 31–60 day outreach can help prevent invoices from reaching this stage.

Payment irregularities and potential fraud

Lapping is a scheme where an employee applies one customer's payment to another customer's account to hide a shortfall. Your aging report can surface this if you notice unusual credit applications, unexplained adjustments, or customers whose balances fluctuate in patterns that don't match their invoicing history.

If you notice payments applied inconsistently or credits appearing without supporting documentation, it's worth auditing the payment application process. The most effective control is separating the person who records payments from the person who reconciles accounts.

How to build an AR aging report

Building an aging report requires four pieces of data: your open invoices, the original due date for each one, the amount outstanding, and today's date.

Step 1: Gather your open invoices

Pull a list of every invoice that hasn't been fully paid. Include the customer name, invoice number, invoice date, due date, and the remaining balance. If you use accounting software like QuickBooks or NetSuite, you can export this data directly.

Step 2: Calculate the days outstanding

For each invoice, subtract the due date from today's date to get the number of days past due. Invoices that haven't reached their due date yet go into the current bucket.

Step 3: Sort into aging buckets

Assign each invoice to the appropriate bucket based on its days past due. Current, 1–30, 31–60, 61–90, and 90+ are the standard categories. Then group the results by customer so you can see each customer's total exposure and how it breaks down by age.

Step 4: Total and review

Sum each bucket column to see total dollars at each stage of aging, then review individual customer rows to spot which accounts need follow-up.

Step 5: Automate for next time

Most accounting and enterprise resource planning (ERP) systems generate aging reports automatically and can kick off reminder emails or escalation tasks when an invoice crosses into the next bucket. If you're building the report manually in a spreadsheet, consider whether your current tool stack can handle this for you. Manual generation works at low invoice volumes but becomes less practical as your accounts receivable operation grows.

Make aging data easier to act on

An aging report tells you which balances need attention. The work starts after the report, when your finance team needs to decide who to contact, what to say, and whether a payment has already arrived.

Ramp’s newly released AR software helps move those next steps into the same workflow.

• AI collections agent prepares follow-up using the collections policy finance sets, along with invoice status and buyer context. Finance reviews, edits if needed, and sends every message
• AI cash application uses details like invoice number, amount, and date to match incoming payments to open invoices
• Collections cases bring invoices that need attention into one place, so finance can act on aging balances with the right customer context

An aging balance is easier to address when the follow-up and payment activity are already connected to it.

See how Ramp’s accounts receivable automation software can help your team turn aging balances into clear next steps.