Product

Company

Resources

Book a demo

Book a demo

Accounts receivable aging: what it is, how to structure the report, and how to use it

Executive summary

Accounts receivable aging is a foundational tool in working capital management. By structuring invoices into clear time buckets, AR teams gain visibility into payment risk, collections priorities, and cash flow impacts. When combined with metrics like DSO and AR turnover, AR aging helps finance teams act decisively: reducing late payments, improving liquidity, and protecting against bad debt. Want to see how AI-powered AR automation can streamline aging reports and collections? Book a demo with our team.

Accounts receivable (AR) aging is one of the most practical tools for monitoring customer payment behavior and managing working capital. While metrics like DSO and AR turnover give a high-level view, an aging report breaks receivables down by how long they've been outstanding — making it a frontline tool for credit controllers and CFOs.

In this article, we'll cover:

  • What AR aging is

  • How an AR aging report is structured

  • How to extend it with dunning cohorts

  • How finance teams should use aging reports in collections, credit management, and cash flow planning

What is accounts receivable aging?

AR aging is the practice of categorizing outstanding invoices by the length of time they've been unpaid. The resulting report, called an AR aging report, shows receivables grouped into time "buckets," such as 0–30 days, 31–60 days, 61–90 days, and over 90 days.

The goal is simple: to identify overdue accounts quickly, track patterns of late payment, and prioritize collection efforts.

How to structure an AR aging report

A standard AR aging report includes:

  • Customer name: The customer or account associated with the receivable.

  • Invoice details: Invoice number, invoice date, due date, and outstanding balance.

  • Aging buckets: Receivables are grouped into categories, most commonly:

    • 0–30 days (current, not yet due)

    • 31–60 days (slightly overdue)

    • 61–90 days (seriously overdue)

    • 91+ days (high risk of default)

  • Totals: The report usually shows both customer-level subtotals and grand totals for each bucket.

Example layout:

Customer

0–30 Days

31–60 Days

61–90 Days

91+ Days

Total

ABC Ltd.

$25,000

$10,000

$5,000

–

$40,000

XYZ Inc.

$15,000

$8,000

–

$3,000

$26,000

Total

$40,000

$18,000

$5,000

$3,000

$66,000

Extending AR aging with dunning cohorts

While a traditional AR aging report shows the current state, it doesn't reveal how invoices progress through time buckets. That's where dunning cohorts come in.

A dunning cohort table tracks groups of invoices by their start date (when the invoice was issued or became due) and shows how they "age" across different dates. This allows finance teams to see how quickly invoices are being resolved or slipping into later buckets.

Example: Dunning Cohort Table

Invoice Start (Due Date)

At Due Date

+30 Days

+60 Days

+90 Days

+120 Days

Status

Jan 1, 2025

$100,000

$40,000

$20,000

$10,000

$5,000

$25,000 still open

Feb 1, 2025

$80,000

$30,000

$15,000

$8,000

$2,000

$25,000 still open

Mar 1, 2025

$120,000

$60,000

$25,000

$12,000

$5,000

$18,000 still open

This structure shows how much of each cohort is collected over time versus how much drifts into later buckets.

Why it's valuable:

  • Identifies whether collections processes are improving or deteriorating across cohorts.

  • Highlights customers that consistently roll into later buckets.

  • Provides visibility into expected cash recovery over time.

How to use AR aging reports

1. Prioritize collections

The report shows which accounts are overdue and by how much, helping AR teams focus on the riskiest invoices first.

2. Monitor customer payment behavior

Aging reports reveal patterns, such as customers who consistently pay late or who are slipping into longer buckets. This can inform credit policy adjustments.

3. Estimate bad debt risk

Invoices in the 91+ day bucket are often at high risk of becoming uncollectible. Aging helps finance teams estimate allowances for doubtful accounts.

4. Support cash flow forecasting

By analyzing the timing of expected collections, AR aging provides more accurate cash flow forecasts.

5. Strengthen credit management

Consistently late-paying customers may need tighter terms, upfront deposits, or reconsideration of credit risk.

6. Provide transparency for stakeholders

CFOs, auditors, and investors often review AR aging as part of financial reporting and risk assessments.

Best practices for AR aging

  • Update regularly: Generate the report at least monthly, ideally weekly for high-volume businesses.

  • Set clear escalation policies: Decide what actions to take as invoices move through buckets (e.g. reminder email at 31 days, collections call at 61 days).

  • Integrate with AR automation: Modern tools can auto-generate aging reports, flag risky accounts, and trigger reminder workflows.

  • Combine with DSO and AR Turnover: Use aging alongside high-level metrics for a complete view of AR performance.

  • Analyze trends, not just snapshots: Track changes in each bucket over time to see if payment behavior is improving or worsening.

Final thoughts

Accounts receivable aging is a foundational tool in working capital management. By structuring invoices into clear time buckets, AR teams gain visibility into payment risk, collections priorities, and cash flow impacts.

When combined with metrics like DSO and AR turnover, AR aging helps finance teams act decisively: reducing late payments, improving liquidity, and protecting against bad debt.

Want to see how AI-powered AR automation can streamline aging reports and collections? Book a demo with our team.

“Accounts receivable aging is a foundational tool in working capital management. By structuring invoices into clear time buckets, AR teams gain visibility into payment risk, collections priorities, and cash flow impacts.”

Ready to transform your accounts receivable workflows with AI agents?

FAQs

Paraglide

Share

Jan 14, 2026

See the product in action

Click below to speak to one of our team.

Book a demo

Related posts

Paraglide and Future Fluent logos side by side on a blurred blue and amber gradient background

Paraglide chooses Future Fluent for sustainability reporting

Paraglide chose Future Fluent to report under the EU Voluntary Standard (formerly VSME) and set a full Scope 1–3 emissions baseline for investors and customers.

Nov 10, 2026

AI-Powered AR Automation: How AI Agents Work in 2026

Oct 21, 2026

Generic Shared AR Inbox vs. Automated Shared AR Inbox

Best AR Inbox Management Tools in 2026

A practical comparison of Account Receivables (AR) inbox management tools, from legacy platforms and ticketing systems to Paraglide’s AI-native agents that resolve billing queries directly.

Sep 17, 2026

Finally, a collections system that runs itself.

Book a demo

Finally, a collections system that runs itself.

Book a demo

Product

Product overview

Billing support agent

Collection agent

Disputes

Supplier portal agent

Cash application

Company

About

Careers

Contact us

Resources

Glossary

Blog

Agents for accounts receivable

Agents for credit management

Agents for debt collection

Agents for order-to-cash

Agents for shared services

Agents for dunning

Legal

Privacy policy

Security & data protection

Terms & conditions

Copyright 2026 Paraglide AI

Product

Product overview

Billing support agent

Collection agent

Disputes

Supplier portal agent

Cash application

Company

About

Careers

Contact us

Resources

Glossary

Blog

Agents for accounts receivable

Agents for credit management

Agents for debt collection

Agents for order-to-cash

Agents for shared services

Agents for dunning

Legal

Privacy policy

Security & data protection

Terms & conditions

Copyright 2026 Paraglide AI