AR Aging Report: How to Read It, What Every Column Means, and How to Use It to Protect Your Cash Flow

What Is an AR Aging Report?

An accounts receivable aging report — sometimes called an AR aging summary or AR aging schedule — is a financial reporting tool that shows every outstanding customer invoice grouped by the length of time it has been unpaid. The word “aging” refers to how old the receivable is: an invoice that has been unpaid for 45 days is older than one that has been unpaid for 10 days, and the two are treated differently in collections.

The report serves two purposes simultaneously. First, it is a collections management tool: it tells you which customers you need to follow up with and how urgently. Second, it is a cash flow risk indicator: the older your receivables, the less likely they are to be fully collected, and the larger that risk bucket, the greater the threat to your operating cash position.

In QuickBooks Online, the AR aging report is found under Reports, in the Who Owes You section. There are two versions: the AR Aging Summary, which shows totals by customer, and the AR Aging Detail, which shows individual invoices. Both are essential tools in any well-structured bookkeeping engagement.

How to Read an AR Aging Report: What Each Column Means

Current (Not Yet Due)

The Current column shows invoices that have been sent to customers but have not yet reached their payment due date. This is the normal, healthy part of your AR. For a business with net 30 payment terms, a current balance represents services delivered and invoiced in the last 30 days. A large current balance is expected for a business with active billing activity.

1 to 30 Days Past Due

Invoices in this column have passed their due date by one to 30 days. At this stage, the collection rate is still high. A simple reminder — an automated follow-up from QuickBooks or a direct email — resolves most balances in this bucket. These are typically oversights on the customer side, not signs of a collection problem or disputed invoice. Immediate, friendly outreach is the right response.

31 to 60 Days Past Due

Balances in the 31 to 60 column need active, direct outreach — a phone call, not just an email. Some customers at this stage are experiencing their own cash flow difficulties. Understanding whether the delay is administrative, financial, or related to a dispute about the invoice determines the right response: a payment arrangement, a final demand, or escalation to your collections process. Do not wait for these to age further.

61 to 90 Days Past Due

Invoices this old signal either a collection problem or a dispute that has gone unresolved. Before escalating, confirm there is no legitimate dispute about the quality of work, the accuracy of the invoice, or a contractual term you may have missed. If the invoice is not in dispute and the customer is simply not paying, a formal written demand is appropriate at this stage. Many small businesses begin engaging a collections agency or collections attorney at the 60 to 90 day mark.

91 Days or More Past Due

Receivables older than 90 days have a significantly lower collection rate than those addressed earlier. At 90 days, the window for amicable resolution is largely closed. Options at this stage include collections agency engagement, legal action, or writing the balance off as bad debt — which has its own tax implications that your accounting professional can guide you through. The most important lesson is not to allow invoices to reach 90 days without intervention, because the intervention options diminish and the cost of recovery increases.

What a Healthy AR Aging Report Looks Like

Industry benchmarks vary by business type, but a generally healthy AR aging structure for a service business has 70 to 80 percent of total outstanding AR in the current or 1 to 30 column, less than 10 to 15 percent in the 31 to 60 column, and minimal balances in the 61-plus columns. If more than 20 percent of your total AR is 60 or more days past due, your collections process needs attention.

A growing balance in the 90-plus column month over month without a corresponding reduction in total AR is a significant warning sign. It means new receivables are being added to the balance faster than old ones are being collected. Left unaddressed, this pattern leads to a cash flow problem even when revenue appears healthy — because the cash that revenue should generate is being delayed indefinitely. A fractional CFO working with your business will typically flag this pattern before it becomes a crisis, because it shows up in monthly KPI tracking before it appears in the bank balance.

How to Use the AR Aging Report to Manage Collections

Build a Weekly Collections Review Process

The AR aging report is most valuable when it triggers a specific action. Build a weekly process: generate the AR aging detail report in QuickBooks on Monday morning, identify every invoice that moved into a new aging bucket in the past week, and assign follow-up tasks immediately. A business that reviews its accounts receivable weekly collects faster than one that reviews it monthly, because fewer invoices reach the 31-plus column before anyone notices.

Set Up Automated Payment Reminders in QuickBooks

QuickBooks Online allows you to set up automated invoice reminders that send follow-up emails to customers at preset intervals: three days before the due date, on the due date, and at intervals after the due date. These reminders do not replace direct outreach for balances over 30 days past due, but they handle the routine follow-up for the current and 1 to 30 buckets without manual effort. For businesses with high invoice volume, automated reminders significantly reduce the number of invoices that age into the 31-plus column.

Track DSO (Days Sales Outstanding) Monthly

Days Sales Outstanding is the AR aging metric that most directly measures collection efficiency: DSO = (accounts receivable balance / total credit revenue) x number of days. If your DSO is 45 days and your payment terms are net 30, you are collecting 15 days late on average. Tracking DSO monthly alongside your AR aging report — as part of your monthly financial reporting package — shows whether your collection performance is improving, stable, or deteriorating over time.

Establish a Collections Escalation Policy

Define in advance what happens when an invoice reaches each aging bucket. At 15 days past due: automated reminder. At 30 days past due: personal phone call. At 45 days past due: formal written notice with a specific payment deadline. At 60 days past due: suspension of services until payment is received. At 90 days past due: collections agency or legal action. Having a documented escalation policy removes the emotional decision-making from collections and makes your process consistent and enforceable.

AR Aging Report vs. Cash Flow Forecast: How They Work Together

The AR aging report tells you what you are owed and how old each balance is. A 13-week cash flow forecast tells you when you expect those dollars to actually arrive in your bank account. Together, they give you a complete picture of near-term cash. The aging report identifies the risk; the forecast quantifies it in terms of timing and amount.

For businesses working with ClearPath CFO on fractional CFO services, AR aging is one of the primary inputs to the monthly cash flow analysis. A large 60-plus AR bucket means cash that was expected to arrive is delayed, which affects the forecast and may require drawing on a line of credit or accelerating collections on other receivables. This is exactly the kind of early warning that monthly AR monitoring provides.

Frequently Asked Questions About AR Aging Reports

What does AR aging mean?

AR aging refers to how long accounts receivable balances have been outstanding. An invoice is said to be “aging” from the day it becomes past due. The older the balance, the more it has aged, and the lower the probability of full collection. AR aging is measured in days past due and reported in time buckets on the AR aging report.

How do I generate an AR aging report in QuickBooks Online?

In QuickBooks Online, go to Reports in the left navigation panel. Under the Who Owes You section, you will find AR Aging Summary and AR Aging Detail. The summary shows total balances by customer in each aging bucket. The detail shows individual invoice amounts. Set the report date to the current date and run it. QuickBooks automatically calculates how many days past due each invoice is based on the invoice due date.

What is a good AR aging percentage?

For most service businesses, a healthy AR aging distribution has 70 to 80 percent of total outstanding AR in the current or 1 to 30 days past due column, less than 15 percent in the 31 to 60 column, and under 5 to 10 percent in the 61-plus columns. If the 60-plus bucket represents more than 20 to 25 percent of total AR, collections process improvement is needed.

What is the difference between AR aging summary and AR aging detail?

The AR aging summary shows one row per customer with their total outstanding balance distributed across aging buckets. It gives you a high-level view of which customers owe you and how much is in each aging category. The AR aging detail shows individual invoices within each customer, which is necessary when you need to know which specific invoice to follow up on. Use the summary for weekly review and the detail for active collections calls.

Why is my AR aging report showing invoices in the wrong bucket?

AR aging calculations in QuickBooks are based on the invoice due date, not the invoice date. If invoices show up in an older aging bucket than expected, check whether the due dates were set correctly on the invoices. If payment terms were not applied when the invoice was created, QuickBooks may have defaulted to a due date that does not reflect your actual terms. Correcting the payment terms settings in QuickBooks will fix this going forward.

How does the AR aging report affect my financial statements?

The total of your AR aging report should match the Accounts Receivable balance on your balance sheet. If these two numbers differ, there is a bookkeeping error — either an invoice that is not in the AR aging report, or a payment that was applied incorrectly. Reconciling the AR aging report to the balance sheet is part of the monthly close process that ClearPath CFO completes for every bookkeeping client.

How long does it take to collect on 90-plus day invoices?

The average recovery rate on invoices more than 90 days past due drops significantly compared to invoices addressed at 30 days. Industry data suggests that collection rates drop to 50 to 70 percent once an invoice reaches 90 days past due, and fall further after 120 days. The specific rate depends on the industry, the customer, and whether a payment arrangement exists. This is why early intervention — at 15 to 30 days past due — is the most effective collections strategy.

Can I write off bad debt from my AR aging report?

Yes. When a receivable is determined to be uncollectible, it can be written off as bad debt. In QuickBooks Online, you create a credit memo for the outstanding balance and apply it to the invoice. The write-off creates a bad debt expense on your profit and loss statement, which reduces taxable income. Your tax professional can advise on the specific requirements for deducting bad debt — generally, the debt must be income that was already recognized and the write-off must be documented.

What is DSO and how does it relate to AR aging?

Days Sales Outstanding (DSO) is a single-number summary of collection efficiency: DSO = (accounts receivable / revenue) x number of days. If your DSO is 45 days and your terms are net 30, you are collecting 15 days late on average. DSO is calculated from the same data as the AR aging report and is tracked as a monthly KPI in fractional CFO engagements. A rising DSO trend visible in the aging report is one of the earliest indicators of a developing cash flow problem.

How often should I review my AR aging report?

Monthly is the minimum. Weekly is better for businesses with more than 10 to 15 open invoices at any given time. High invoice volume businesses — construction contractors, healthcare practices, staffing firms — should review AR aging weekly and assign specific follow-up tasks for every invoice that moved into a new aging bucket. ClearPath CFO includes AR aging review in the monthly bookkeeping deliverable package for every client.