TOC
Article
Financial close

What Is an Accounts Receivable Aging Report? How to Create, Read, and Use One

Talisha Mehra
Associate Director - Solution Advisory
Published
October 30, 2026
Updated
October 22, 2026
×
Key Takeaways
Data sits everywhere, and moves faster than spreadsheets can keep up.

Key Takeaways

  • An accounts receivable aging report groups unpaid customer invoices by how long they have been outstanding, typically in 30-day buckets (current, 1-30, 31-60, 61-90, and 90+ days past due).
  • Finance teams use it to prioritize collections, flag credit risk, estimate bad debt provisions under CECL, and forecast short-term cash flow.
  • To calculate the age of a receivable, count the number of days between the invoice date (or due date) and today. Each invoice then drops into the matching aging bucket.
  • The most common mistakes are using static default buckets that don't match your payment terms, ignoring disputed invoices in the aging total, and waiting too long to escalate past-due accounts.
  • Automating the aging process eliminates manual data pulls, keeps the report current in real time, and lets your team focus on collecting rather than compiling.

What Is an Accounts Receivable Aging Report?

An accounts receivable (AR) aging report is a financial document that lists all unpaid customer invoices and categorizes them by how long they have been outstanding. It helps businesses track cash flow, identify slow-paying customers, and manage collection risks.

Think of it as a snapshot of everything your customers owe you right now, sorted by urgency. The longer an invoice stays unpaid, the less likely you are to collect it. An accounts receivable aging report makes that risk visible in one place so your finance team can act before balances become write-offs.

Most accounting systems (SAP, Oracle, NetSuite, QuickBooks, Xero) can generate a basic version of this report. But the real value isn't in generating it. It's in how you read, interpret, and act on what it tells you.

What Are the Standard Aging Buckets?

Most AR aging reports group open invoices into these five time-based categories:

  • Current (0-30 days): Invoices still within standard payment terms. No action needed yet, but worth monitoring if a customer has a history of late payments.
  • 1-30 days overdue: Slightly past due. A polite payment reminder, typically by email, is the right first step.
  • 31-60 days overdue: Past due and needs attention. A direct follow-up call or formal notice is appropriate here.
  • 61-90 days overdue: High risk. Collection efforts should step up, and you may want to pause extending further credit to this customer.
  • 90+ days overdue: Severe. At this stage, the invoice often moves toward a write-off, a collections agency, or legal action.

These are the standard buckets, but they aren't always the right ones for your business. If your standard payment terms are Net 60 rather than Net 30, a "1-30 days overdue" bucket captures invoices that aren't actually late yet. Adjust your buckets to match your terms. More on this in the common mistakes section below.

Example: What an AR Aging Report Looks Like

Customer Invoice
#
Invoice
Date
Due
Date
Amount Current
(0–30)
1–30
Overdue
31–60
Overdue
61–90
Overdue
90+
Overdue
Pinnacle Industries INV-4201 2026-09-22 2026-10-22 ₹12,50,000 ₹12,50,000 — — — —
Meridian Logistics INV-4178 2026-09-01 2026-10-01 ₹8,75,000 — ₹8,75,000 — — —
Zenith Healthcare INV-4102 2026-08-05 2026-09-04 ₹5,20,000 — — ₹5,20,000 — —
Atlas Manufacturing INV-3980 2026-07-10 2026-08-09 ₹3,40,000 — — — ₹3,40,000 —
Orion Tech Solutions INV-3845 2026-06-01 2026-07-01 ₹6,90,000 — — — — ₹6,90,000
Total — — — ₹36,75,000 ₹12,50,000 ₹8,75,000 ₹5,20,000 ₹3,40,000 ₹6,90,000

In this example, ₹10,30,000 (about 28% of total receivables) sits in the 61+ day buckets. That concentration is a red flag. It means over a quarter of your outstanding revenue is at serious risk of non-collection, and both Atlas Manufacturing and Orion Tech Solutions need immediate attention from your collections team.

When Is an Accounts Receivable Aging Report Used?

Finance teams don't just generate this report at month-end and file it away. It's a working tool with several practical applications:

Prioritizing collections. Your team can't chase every overdue invoice with the same urgency. The aging report tells them exactly where to focus: which accounts are deepest overdue, which carry the largest balances, and which have been slipping steadily from one bucket to the next. That's how you turn a reactive collections process into a structured one.

Assessing credit risk. Before you extend more credit to a customer, check their aging history. A buyer who consistently shows up in the 61-90 day bucket is a different risk profile than one who pays within terms. The aging report gives your credit team the data to adjust limits, require prepayment, or tighten terms on a customer-by-customer basis.

Estimating bad debt provisions. Under the CECL framework (ASC 326, issued by FASB), companies must estimate expected credit losses over the life of a receivable, not just when a loss is probable. The aging report is the foundation for that estimate. By looking at historical loss rates per aging bucket, you can calculate your allowance for doubtful accounts with actual data instead of guesswork.

Forecasting short-term cash flow. If you know what's current and what's overdue, you can build a more realistic picture of when cash will actually arrive. The aging report feeds directly into your AR-based cash flow forecast, especially when combined with days sales outstanding (DSO) trends.

Preparing for audits. Auditors will ask for the aging report. It's one of the first documents reviewed during an accounts receivable audit because it shows whether your reserves are adequate and whether management is actively monitoring collections. A clean, well-maintained aging schedule with clear bucket definitions and consistent cut-off dates makes the audit go faster.

How Do You Calculate the Age of Accounts Receivable?

The age of a receivable is simply the number of days between the invoice date (or the due date, depending on your method) and today's date.

Formula:

Age (in days) = Today's Date - Invoice Date

Some teams measure from the invoice date, others from the due date. Measuring from the invoice date gives you the total time elapsed since billing. Measuring from the due date tells you how many days the payment is actually overdue. The second method is more useful for collections because a "45-day-old" invoice on Net 60 terms isn't overdue at all.

Worked Example

Say today is October 22, 2026, and you have an invoice with these details:

Field Value
Invoice date August 15, 2026
Payment terms Net 30
Due date September 14, 2026
Amount ₹4,50,000

Age from invoice date: October 22 minus August 15 = 68 days. That puts it in the 61-90 bucket.

Age from due date: October 22 minus September 14 = 38 days overdue. That puts it in the 31-60 overdue bucket.

Both calculations are valid, but they tell different stories. Pick one method, document it, and apply it consistently across every invoice. Mixing methods in the same report leads to misclassified invoices and confused collection priorities.

The DSO Shortcut for Portfolio-Level Aging

If you want a single number that summarizes how fast your customers pay on average, days sales outstanding (DSO) is the metric:

DSO = (Average Accounts Receivable / Net Credit Sales) × Number of Days

A rising DSO alongside a growing 61-90 day bucket is a warning sign. It means your overall collection velocity is slowing, not just one or two accounts. That combination should trigger a review of your credit policies and escalation timelines.

How to Create an Accounts Receivable Aging Report

Whether you build this in Excel, pull it from your ERP, or generate it through your finance platform, the steps are the same:

  1. Pull all open invoices. Export every unpaid invoice from your billing or ERP system. Include customer name, invoice number, invoice date, due date, original amount, and current outstanding balance. If you have partial payments, the balance should reflect what's still owed, not the original amount.
  2. Define your aging buckets. Use the standard 30-day intervals (current, 1-30, 31-60, 61-90, 90+) as a starting point, then adjust to match your actual payment terms. If most of your contracts are Net 45, your first overdue bucket should start at day 46, not day 31.
  3. Calculate the age of each invoice. Use the formula above (today's date minus invoice date or due date). Be consistent about which date you use.
  4. Sort each invoice into its bucket. Based on the calculated age, place every invoice into the right column. Group by customer so you can see both the individual invoice ages and each customer's total exposure per bucket.
  5. Calculate totals. Sum each bucket column and calculate what percentage of total receivables each bucket represents. If your 61+ day buckets hold more than 15-20% of total AR, that's a sign your collections process needs attention.
  6. Add context. Flag invoices that are in dispute, mark customers who have payment plans in place, and note any partial payments received. A raw aging number without context can be misleading. An invoice that's 75 days old because the customer disputed a line item is a different situation than one that's 75 days old because the customer stopped responding.

How to Read an Accounts Receivable Aging Report

Generating the report is the easy part. Reading it well is where the value sits. Here's a four-step approach:

Step 1: Look at the distribution, not just the total. A company with ₹50 lakhs in total receivables looks healthy until you see that ₹30 lakhs of it is in the 90+ bucket. The distribution across buckets matters more than the headline number.

Step 2: Spot customer concentration. If one customer accounts for 40% of your overdue balance, you have a concentration risk problem. The aging report shows this clearly when you sort by customer rather than just by bucket.

Step 3: Watch for bucket migration. Pull the report weekly or bi-weekly and compare. If the same invoices keep moving from 31-60 to 61-90 to 90+, your follow-up process isn't working. The invoices aren't aging because they're new. They're aging because nobody is resolving them.

Step 4: Connect aging to action. Each bucket should map to a specific collection action. Current invoices get a courtesy reminder a few days before the due date. 1-30 overdue gets an email. 31-60 gets a phone call. 61-90 gets a formal demand letter and a credit hold. 90+ goes to a senior collector or an external agency. If your team doesn't have this mapping documented, the aging report is just a pretty spreadsheet.

Common Mistakes in AR Aging Reports (and How to Fix Them)

Even experienced finance teams make these errors. Each one distorts the report and leads to bad decisions.

Using default aging buckets that don't match your terms. If your standard terms are Net 45 or Net 60, the default 30-day buckets will show invoices as overdue when they're actually still within terms. Your collections team wastes time chasing invoices that aren't late, and the report overstates your risk. Fix: align your bucket boundaries to your actual payment terms, and if you have multiple term structures (Net 30 for domestic, Net 60 for international), consider running separate aging schedules or adding a terms column.

Ignoring disputed invoices. A disputed invoice sitting in the 90+ bucket inflates your bad debt estimate and triggers unnecessary escalation. The customer isn't paying because there's a legitimate issue with the invoice, the delivery, or the contract terms, not because they can't or won't pay. Fix: tag disputed invoices separately and exclude them from your standard collections workflow. Track them in a dispute management process with their own resolution timeline.

Not segmenting by customer type. A Fortune 500 buyer paying 45 days late is a very different risk than a small distributor paying 45 days late. The aging report treats them the same unless you add segmentation. Fix: add columns for customer tier, credit limit, and historical payment behavior. Some teams run separate aging views for enterprise accounts, mid-market accounts, and channel partners.

Waiting too long to escalate. Many teams don't start real collection efforts until an invoice hits the 61-90 bucket. By then, the probability of full collection has already dropped significantly. Research from industry benchmarks suggests that an invoice unpaid after 90 days may have less than a 20% chance of being collected in full. Fix: define escalation triggers at every bucket transition, not just at 90 days. Even a structured email at day 7 overdue improves your overall collection rate.

Running the report only at month-end. A monthly aging report is a historical document by the time anyone reads it. Invoices that were 25 days overdue at month-end are now 35 days overdue by the time the report reaches the collections team. Fix: generate the report weekly at minimum. Better yet, move to a system that keeps aging data current in real time.

How to Reduce AR Aging and Improve Collections

The aging report tells you where the problems are. Here's how to fix them:

Tighten credit terms proactively. Don't wait for a customer to hit the 90+ bucket before reviewing their credit. Set up automatic reviews when a customer crosses into 31-60 for the second consecutive cycle. Reduce their credit limit or require partial prepayment until they clear the backlog.

Automate payment reminders. A structured dunning process with automated emails at day 7, day 14, and day 30 overdue catches most late payments before they become collection problems. Most ERPs support this natively, and it takes the manual follow-up burden off your team.

Offer early payment incentives. A 2% discount for payment within 10 days (2/10 Net 30) costs you a small margin but improves your cash conversion cycle. For large enterprise invoices, even a 1% discount can motivate the buyer's AP team to prioritize your invoice.

Segment your collection strategy. Don't send the same follow-up email to a strategic enterprise account and a one-time buyer. High-value, repeat customers get a relationship-managed approach (a call from their account manager). Transactional buyers get automated workflows. The aging report tells you who falls into which category.

Reconcile AR to the GL regularly. If your accounts receivable reconciliation isn't current, your aging report could be working from stale or incorrect balances. A payment received but not yet applied makes an invoice look overdue when it isn't. Regular reconciliation keeps the aging report honest.

When Should You Automate Your AR Aging Process?

If your team spends hours each week pulling invoice data from multiple systems, pasting it into a spreadsheet, and manually sorting it into buckets, you've outgrown the manual approach. Here are the signals:

  • You have invoices spread across more than one billing system, ERP, or payment gateway, and building the aging report means pulling data from each one separately.
  • Your report is already outdated by the time it reaches the collections team because it takes a day or more to compile.
  • Disputed invoices, partial payments, and credit notes get missed or double-counted because they require manual adjustments.
  • Your team reconciles AR to the general ledger manually, and discrepancies between the aging report and the GL surface only at month-end.

When these pain points are familiar, it's time to move the aging process onto a platform that connects directly to your source systems and keeps the report current without manual intervention.

Create AR aging reports painlessly with Bluecopa

Aging reports with Bluecopa

Bluecopa automates aging reports in the following ways:

Automated data collection

Bluecopa automatically collects data from your invoicing and payment systems, eliminating the need for manual data entry. This ensures that your accounts receivable aging reports are always up-to-date and accurate.

Real-time aging categorization

Bluecopa automatically categorizes invoices based on their aging status. This feature makes it easy to identify overdue invoices and prioritize collection efforts.

Customizable report templates

Bluecopa offers customizable report templates that enable you to personalize your AR aging reports according to your specific requirements and preferences. You have the flexibility to add or remove columns, filter data, and format the report to suit your preferences.

Scheduled report generation

Bluecopa can automatically generate AR aging reports on a regular schedule, such as daily, weekly, or monthly. This ensures that you always have the most up-to-date insights into your accounts receivable balances.

If you're looking to automate AR aging reports, you're just one step away. Request a demo to learn more.

The aging report itself isn't the bottleneck. The bottleneck is the manual data work behind it. Removing that work is what turns the aging report from a backward-looking document into a tool your team actually uses every day.

Frequently Asked Questions

1. What is the difference between an AR aging report and an AR aging schedule?

They're the same thing. "Aging report" and "aging schedule" are used interchangeably in practice. Both refer to the document that lists unpaid invoices grouped by how long they've been outstanding. Some ERPs call it a "schedule" in their menu, while others call it a "report," but the output is identical.

2. How often should you run an AR aging report?

Weekly at minimum. Monthly is too slow for active collections because invoices that were borderline at month-end have already migrated to a worse bucket by the time the report is reviewed. Many finance teams run it weekly and review the 61+ day buckets daily. If your platform supports real-time aging, daily reviews of exception items replace the scheduled report entirely.

3. What is a good aging ratio for accounts receivable?

A healthy AR portfolio keeps 80% or more of receivables in the current (0-30 day) bucket. If more than 15-20% of your total AR sits in the 61+ day buckets, your collection process or credit policies need review. The right ratio depends on your industry and payment terms, but a growing share of aged receivables over consecutive periods is always a warning sign.

4. Can you build an AR aging report in Excel?

Yes. Export your open invoices, add a column that calculates the age of each one (today's date minus invoice date or due date), and use IF or VLOOKUP functions to sort each invoice into a bucket. Pivot tables work well for summarizing by customer and bucket. Excel works for smaller invoice volumes, but it breaks down when you have hundreds or thousands of open invoices across multiple systems because the data goes stale between manual refreshes.

5. What is the CECL connection to AR aging?

CECL (Current Expected Credit Losses, under ASC 326) requires companies to estimate lifetime expected credit losses on receivables at the time of recognition, not just when a loss becomes probable. The AR aging report is a key input because historical loss rates per aging bucket form the basis of the CECL calculation. For example, if your 90+ day bucket has historically had a 35% loss rate, you apply that rate to the current 90+ balance to estimate your allowance for doubtful accounts.

6. What is the difference between AR aging and DSO?

AR aging shows you the distribution of outstanding invoices across time buckets, giving you a detailed, invoice-level view. DSO gives you a single number that summarizes how many days, on average, it takes to collect payment. They complement each other: the aging report tells you where the problems are (which customers, which invoices), and DSO tells you whether your overall collection speed is improving or declining.

Frequently Asked Questions
No items found.

Book a demo

See Bluecopa run on your own close

70%

Faster month-end close

95%

Reduction in manual effort

100%

Data accuracy

Book a demo

30 min · your ERP · no slide deck

See the ROI for your finance operations.

Automate complex finance processes and systems.
Accelerate decisions with Bluecopa's Al-powered, real-time insights.

Reduce the manual work in your close.

Automate complex finance processes and systems.
Accelerate decisions with Bluecopa's Al-powered, real-time insights.

Simplify how your finance team works.

Automate complex finance processes and systems.
Accelerate decisions with Bluecopa's Al-powered, real-time insights.

Future-proof your finance operations.

Automate complex finance processes and systems.
Accelerate decisions with Bluecopa's Al-powered, real-time insights.

Future-proof your finance operations, today

Automate complex finance processes and systems. Accelerate decisions with Bluecopa's Al-powered, real-time insights.
Book a demo