AR Aging

AR Aging (or the AR Aging Report) groups open invoices by how many days they are past due, typically in buckets of current, 1-30 days, 31-60, 61-90, and 90+. It is the standard tool for spotting collection risk and prioritising follow-up.

Key Takeaways

  • AR Aging groups open invoices by days past due in standard buckets: current, 1-30, 31-60, 61-90, and 90+ days.
  • The aging report is the standard diagnostic tool for spotting collection risk and prioritising follow-up work.
  • Healthy B2B aging profiles keep 70 to 85% of total AR in the current bucket and under 5% past 60 days.
  • Aging alone hides whether 90+ day AR is true bad debt risk or stuck behind unresolved disputes.
  • Modern agentic AR platforms use aging plus payment history plus dispute status to score collection priority dynamically.

Why AR Aging matters

The aging report is the single most-used diagnostic tool in accounts receivable. It answers two questions at once: how much money is outstanding, and how concerning is the timing. A balance sheet shows $5M in AR; the aging report shows whether that $5M is current (healthy) or sitting 90+ days past due (likely write-off territory). For credit and collections teams, the aging report is the worklist driver. For controllers, it is the input to the allowance for doubtful accounts estimate.

The standard aging buckets

Most ERPs and AR platforms use the same five buckets.

  • Current: invoice issued but not yet past due. Healthy.
  • 1-30 days past due: payment delayed slightly. Usually self-correcting within terms.
  • 31-60 days past due: needs active collection follow-up. Probability of payment drops noticeably.
  • 61-90 days past due: high risk. Most companies escalate to senior collections or external agencies.
  • 90+ days past due: very high write-off risk. Typically less than 30% recovered without significant effort.

Some industries use different buckets. SaaS companies often run 30-day buckets because subscription terms shorten the cycle. Construction and government contracting use 60-day buckets because long terms are normal.

How AR Aging is calculated

The aging report runs on a given date (typically month-end or week-end). For each open invoice, the system calculates days past due as the report date minus the invoice due date. Invoices then bucket by that number. The result is a matrix: rows are customers, columns are aging buckets, cells are dollar amounts.

Two common variations exist. Invoice-date aging buckets by issuance date instead of due date (useful when payment terms vary across customers). Promise-to-pay adjusted aging treats invoices with confirmed PTP dates as if their due date had moved, reducing apparent risk.

Why AR Aging alone is not enough

AR Aging shows what is past due but not why. A $50K invoice 60 days past due could mean a customer in financial trouble (high risk), or an invoice waiting on disputed deduction documentation (medium risk, but resolvable), or a payment that arrived but is sitting unapplied in the cash application backlog (no risk at all). Aging treats all three the same way. Combining aging with cash application status, dispute status, and customer payment history gives a richer risk signal.

How agentic AR uses aging

Modern agentic AR platforms use aging as one input rather than the worklist driver. The agent reads aging, layers in customer payment history, current dispute status, and cash forecast pressure, then re-scores collection priority dynamically. An invoice in the 31-60 bucket from a customer with strong payment history and no disputes may get lower priority than a 1-30 invoice from a customer who has broken three recent promise-to-pay commitments. This dynamic scoring is what enables 100% invoice coverage within 24 hours of going past due, versus the 30 to 40% coverage manual aging-driven teams achieve.

Frequently asked questions

What is a good AR Aging profile?

Healthy B2B aging puts 70 to 85% of total AR in the current bucket. Past-due AR should taper sharply: 10 to 20% in 1-30 days, under 5% in 31-60 days, under 2% in 60+ days. CPG companies selling to large retailers typically run with more 31-60 weight because of long payment terms. Software/SaaS should run cleaner because of automated subscription billing.

What are the standard AR Aging buckets?

The standard five buckets: Current (not yet due), 1-30 days past due, 31-60, 61-90, and 90+ days past due. Some industries use 30-day buckets (SaaS) or 60-day buckets (construction, government). The buckets matter less than the trend over time and how each bucket converts to cash.

How do you reduce 90+ day AR?

Three levers. First, prevent invoices from reaching 90+ by working them earlier in the cycle (agentic AR platforms reach 100% coverage by day 31). Second, escalate aged invoices to senior collections or external agencies before they cross the write-off threshold. Third, resolve underlying disputes that are keeping invoices stuck (often 30 to 40% of 90+ AR is in unresolved dispute, not customer non-payment).

Is AR Aging the same as the AR Aging Report?

Yes, the terms are used interchangeably. AR Aging refers to the methodology (bucketing open invoices by days past due). The AR Aging Report is the document output. In practice, finance teams say 'pull the aging' meaning run the report.

How often should you run an AR Aging Report?

Weekly for active collections work, monthly for management reporting and allowance for doubtful accounts calculations. Real-time aging dashboards have become standard in agentic AR platforms because they let collections work the freshest data instead of last week's snapshot.

What is the difference between AR Aging and DSO?

AR Aging is a distribution (how AR is spread across age buckets at a point in time). DSO is a single number (average days from sale to payment, calculated over a period). Aging answers 'where is my AR concentration risk?'. DSO answers 'how fast is the overall cycle?'. Both are needed: DSO trend with a tight aging profile is healthy; flat DSO with growing 60+ AR is masked deterioration.

Continue learning