Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group

Key Takeaways From This AR Aging Guide

• An accounts receivable aging report groups every open invoice into standard buckets (Current, 1–30, 31–60, 61–90, 90+ days) and must tie exactly to the general ledger balance on the same reporting date.
• Accurate preparation depends on a clean AR subledger, verified invoice and due dates, and consistent use of the due date for aging calculations.
• Reading the report for risk means watching for customer concentration, migration into older buckets, and a growing 90+ column, which signal collection problems and cash-flow exposure.
• Reconciling the aging report to the GL and updating the allowance for doubtful accounts each period are required steps for reliable financial statements and GAAP compliance.
• Condesa Financial helps SMEs produce accurate AR aging reports, reconcile them to the general ledger, and turn the data into specific collections and cash-flow decisions.

Talk With Condesa About Your AR Process

Before You Begin: What You Need For An Accurate AR Aging Report

A reliable accounts receivable aging report starts with four inputs: a clean AR subledger, accurate invoice and due dates on every open invoice, current customer records, and a defined reporting date, typically the last day of the accounting period.

Every invoice carries two key dates, and each serves a different purpose. The invoice date is when the invoice was issued. The due date is when payment is contractually owed, calculated as the invoice date plus the payment terms (for example, Net 30). Aging should be calculated from the due date, not the invoice date, because the due date is the first day a payment is actually late. Aging from the invoice date inflates overdue buckets and creates false urgency on invoices that are not yet past due.

The aging basis, invoice date versus due date, is a system-level setting in most accounting platforms. Confirm which basis your system uses before relying on the output. Some accounting systems age invoices from the invoice date rather than the due date, which can make balances appear older than they are if payment terms are long.

How much work the aging report takes depends on a few variables: company size, number of legal entities, multi-currency or cross-border customers, and whether finance is handled internally or by an outside accountant. A single-entity US business on standard Net 30 terms is straightforward. A multinational with customers in multiple currencies, by contrast, requires foreign-exchange adjustments and careful cutoff management before the aging report is meaningful.

Common tools for generating AR aging reports include QuickBooks for small to medium-sized enterprises, Excel for customized layouts, and NetSuite for larger organizations with complex receivables. When the report exists but no one is interpreting it, reconciling it to the GL, or acting on the buckets, outside accounting support or fractional CFO oversight often unlocks real value.

Get Help Cleaning Up Your AR Subledger

How To Prepare An Accounts Receivable Aging Report

An accounts receivable aging report involves four core actions: pull every open invoice from the AR subledger, calculate how many days each invoice is past its due date, assign each invoice to a standard aging bucket, and total the results by customer and by bucket.

Step 1: Confirm The Reporting Date And Pull The AR Subledger

Set the reporting date before pulling any data. Month-end is standard for management review and GL reconciliation. The AR subledger, the detailed customer-by-customer record of every open invoice, must be pulled as of that exact date. The AR aging report and the GL AR balance must be pulled as of the exact same date, or the comparison becomes misleading and produces false differences from timing.

Step 2: Verify Invoice And Due Dates And Customer Records

Review the open invoice list for missing or incorrect due dates, invoices posted to the wrong customer, and duplicate entries. Each outstanding invoice must carry five data fields: customer name, invoice number, invoice date, due date, and amount outstanding. Stale or inconsistent customer names, such as “ABC Ltd” and “ABC Limited” treated as separate records, split balances across duplicate rows and distort the customer-level view.

Step 3: Calculate Days Outstanding For Each Open Invoice

The aging formula is: Days Outstanding = Reporting Date − Due Date. A positive result means the invoice is past due. A zero or negative result means the invoice is current. For an invoice raised on March 1 with Net 30 terms, aging from the invoice date would show it as 45 days old on April 15, while aging from the due date would show it as 15 days overdue on the same date.

Step 4: Assign Each Invoice To A Bucket

Apply the standard bucket labels: Current (not yet due), 1–30, 31–60, 61–90, and 90+ days past due. Each invoice belongs in exactly one bucket based on its days outstanding figure. Invoices with a days outstanding of zero or less fall in the Current bucket.

Step 5: Total Each Bucket And The Grand Total

Sum the open balances within each bucket, first by customer and then across all customers. The grand total across all buckets and all customers is the AR subledger balance. This figure must equal the accounts receivable control account in the general ledger as of the same reporting date.

Step 6: Format And Review The Report

The standard layout places customers in rows and aging buckets in columns, with a total column on the right. Review the output for implausible figures. Watch for a customer with a large balance entirely in the 90+ bucket, credits appearing as negative balances, or invoices that appear in multiple rows due to duplicate entries.

Step 7: Distribute To The Right Stakeholders

The report creates value only when it reaches the people who act on it. Typical recipients include the controller or CFO for financial reporting, the collections team or account managers for follow-up, and the owner or board for cash flow visibility. A report that is produced but never distributed reflects a process gap.

Tools And Examples For Building The Report

Accounts Receivable Aging Report In Excel

To build the report in Excel, export the open invoice list from your accounting system or enter it manually. Add a Days Overdue column using the formula =MAX(0, ReportingDate - DueDate). The MAX(0, …) wrapper keeps not-yet-due invoices at zero. Assign invoices to buckets with a nested IF formula such as =IF(Days=0,"Current",IF(Days<=30,"1–30",IF(Days<=60,"31–60",IF(Days<=90,"61–90","90+")))), and sum each bucket with SUMIFS. Build a summary pivot or SUMIFS table with customers in rows and bucket labels in columns. A separate “Current” column using the criterion “=0” is required, because the overdue SUMIFS formulas cover only invoices with Days Overdue greater than zero.

Generating The Report In QuickBooks Online

In QuickBooks Online, the AR aging report appears under Reports in the left navigation panel, within the “Who Owes You” section, and is available in two versions: the AR Aging Summary (totals by customer) and the AR Aging Detail (individual invoices). Set the report date to month-end before running the report. QuickBooks Online calculates days past due from the invoice due date automatically. Export to Excel for further analysis, reconciliation work, or distribution to stakeholders who do not have system access. The report remains only as reliable as the underlying data, so incorrectly posted payments or unapplied credits will distort the output.

What A Completed AR Aging Report Looks Like

The example below shows what a completed aging report looks like for a hypothetical SME and highlights two patterns that matter most when reading one: healthy balances concentrated in Current and 1–30, and a single customer whose balance has migrated into the 90+ column. All figures are illustrative.

Reading This Example: The Current column ($33,500, roughly 56% of total) looks healthy. Acme Corp and Delta Services are paying on normal cycles. Beta Industries has balances migrating across three buckets, with $6,200 in 1–30, $3,800 in 31–60, and $1,500 in 61–90, which signals a customer that is progressively slower to pay and warrants direct outreach now, before the balance reaches 90 days. Gamma LLC is the most urgent case. A balance of $4,800 in the 90+ bucket alongside $2,200 in 61–90 shows that this customer has been consistently non-paying for at least three months. The 90+ balance should trigger a formal collections decision, such as a payment plan, demand letter, or write-off evaluation. The $4,800 also represents the most significant bad debt exposure in this portfolio. For more on collections strategy and prioritization, see Condesa’s guide to AR collections.

Review Your Aging Layout With Condesa

How To Read An Accounts Receivable Aging Report

This section focuses on interpreting what the distribution of balances across buckets says about collection risk, customer behavior, and the reliability of the AR balance.

A healthy aging profile has most balances concentrated in the Current and 1–30 columns, small and stable 61–90 and 90+ balances, and no single customer dominating the total. A strong AR aging profile shows the vast majority of outstanding funds concentrated in the current and 1–30 day buckets; balances accumulating in the 60-day or 90+ day columns signal a risky profile that threatens cash flow stability.

Key risk signals to watch include:

• Customer Concentration. A single customer representing a large share of total AR, particularly in older buckets, concentrates credit risk. If that customer slows or stops paying, the impact on cash flow becomes disproportionate.
• Migration From Current Into Older Buckets. An invoice that moves from Current to 1–30 to 31–60 across consecutive months reflects a pattern, not a timing quirk. Silence at 61–90 days is a decision the client is making.
• A Growing 90+ Column. A growing 90+ day balance often points to write-offs that have not been recognized yet, collection inefficiency, deteriorating customer quality, or some combination of these.
• Credits And Unapplied Cash Distorting Totals. Negative balances or unexplained credits in the aging report indicate payments that were received but not applied to specific invoices. These distort the true overdue exposure and must be resolved before the report guides decisions.

Read the report by customer as well as by bucket. The bucket view shows the overall portfolio distribution, and the customer view shows which specific relationships drive the risk. Collection action always happens at the customer level, so that is the view to act on. An aggregate DSO of 22 days can hide the fact that two of twelve clients are in the 61–90 day bucket while the other ten pay promptly; the segmented aging view reveals risk that aggregate DSO alone cannot show.

For a deeper treatment of AR aging analysis and what the patterns mean for cash flow forecasting, see Condesa’s article on AR aging analysis.

Discuss Your AR Risk Profile With Condesa

How To Reconcile AR Aging To The General Ledger

The grand total of the accounts receivable aging report must equal the accounts receivable balance in the general ledger as of the same reporting date. When the two figures differ, the aging report cannot support financial statements, collections decisions, or the allowance for doubtful accounts calculation.

The reconciliation procedure has three steps:

1. Pull the GL accounts receivable control account balance as of the reporting date.
2. Pull the AR aging report grand total as of the same date.
3. Calculate the variance: AR subledger total minus GL balance. Investigate any non-zero difference above your materiality threshold.

Common reconciling items that cause a difference between the two figures include:

• Unapplied Or Unallocated Cash. Payments received and deposited but not matched to a specific invoice reduce the bank balance correctly but leave the invoice open in the subledger. Unapplied cash, payments deposited but never matched to a specific invoice, sitting in a clearing or holding account, is the top source of AR drift for high-volume clients.
• Customer Credits And Credit Memos. Credits issued but not applied to open invoices appear as negative balances in the subledger and may not be reflected in the GL control account if posted incorrectly.
• Invoices Posted To The Wrong Period. An invoice entered after the reporting date but dated before it, or the reverse, creates a timing difference between the subledger and the GL.
• Duplicate Invoices. An invoice entered twice inflates the subledger total without a corresponding GL entry if the duplicate was caught at the GL level but not in the subledger.
• Write-Offs Not Yet Recorded. A balance written off in the GL but still appearing as open in the subledger overstates the aging report total.
• Foreign-Exchange Adjustments. For multi-currency receivables, unrealized FX gains and losses may be recorded in the GL but not reflected in the subledger at the same rate.
• Invoices In A Clearing Or Suspense Account. Transactions routed through a clearing account rather than posted directly to AR will appear in the GL but not in the aging report.

When the two figures do not agree, trace the difference to the subledger transaction level. Correct the posting, document the adjustment with a reference to the source transaction, and re-confirm that both balances agree before closing the period. An unresolved $50 AR gap can become a $500 audit flag by Q4, and unreconciled AR causes overstated cash flow assumptions, revenue misstatement from duplicate invoices or unapplied credits, and extra billable CPA time at year-end review.

This reconciliation is a required step in the month-end close. An unreconciled aging report undermines both the collections process and the integrity of the financial statements. For a full treatment of the month-end close workflow, see Condesa’s article on month-end reconciliation. Once the aging report ties to the GL, the next question is what portion of that balance the business actually expects to collect, which is where the allowance for doubtful accounts comes in.

Get Support With AR–GL Reconciliation

How The Aging Schedule Feeds The Allowance For Doubtful Accounts

Under US GAAP, accounts receivable must be reported at net realizable value, the amount the business actually expects to collect. The allowance for doubtful accounts (also called the allowance for uncollectible accounts) is a contra-asset account that reduces gross AR to net realizable value. The aging method is a widely used approach for estimating this allowance for trade receivables.

The principle is straightforward. Older invoices carry higher expected loss rates because collectability declines with age. A 15-day-old invoice is far more likely to be paid than a 200-day-old one.

The mechanics follow five steps:

1. Run the AR aging report as of the reporting date.
2. Assign an estimated loss rate to each aging bucket, based on the company’s own historical write-off experience by bucket.
3. Multiply each bucket’s balance by its loss rate.
4. Sum the results across all buckets to arrive at the required ending allowance balance.
5. Compare the required ending balance to the existing allowance balance and book the difference as the period-end adjusting entry (debit Bad Debt Expense, credit Allowance for Doubtful Accounts).

Using the illustrative figures from the example table above, and applying example loss rates for demonstration purposes only (not prescribed benchmarks):

The required ending allowance balance is $4,389. If the existing allowance balance is $2,000, the adjusting entry is $2,389 (debit Bad Debt Expense, credit Allowance for Doubtful Accounts). The adjusting entry to record estimated uncollectible accounts debits Bad Debt Expense and credits Allowance for Doubtful Accounts, increasing the allowance by the amount needed to reach the target balance.

Loss rates must come from the company’s own historical write-off data matched to the aging bucket each receivable was in when written off. FASB’s illustrative implementation example in ASC 326-20-55 provides sample loss rates by aging bucket, Current 0.3%, 1–30 days 8.0%, 31–60 days 26.0%, 61–90 days 58.0%, and more than 90 days 82.0%, though these are illustrative only and a company’s rates must come from its own historical loss experience.

For private companies, FASB issued ASU 2016-13 (codified as ASC 326), introducing the Current Expected Credit Loss (CECL) model, which was effective for private entities in 2023. Even under CECL, the aging-of-receivables method remains a widely used and compliant approach for trade receivables, provided that historical loss rates are adjusted for current conditions and forward-looking factors. The forward-looking adjustment is a required step, and skipping it is non-compliant even if historical rates are accurate.

Get Help With Your Allowance Calculation

Common Mistakes, Watch Outs, And Troubleshooting

Common Mistakes

• Aging By Invoice Date Instead Of Due Date. As noted earlier, this approach inflates overdue buckets and creates false urgency. Confirm the aging basis in your system settings before relying on the output.
• Unapplied Cash Left In The Subledger. Payments received but not matched to invoices leave those invoices open and overstate the aging report total. Clear unapplied cash before finalizing the report.
• Stale Or Duplicate Customer Records. Inconsistent customer names split balances across multiple rows. Standardize customer records before building the report.
• Credits Not Applied To Open Invoices. Unapplied credit memos distort both the aging total and the GL reconciliation. Apply credits to the correct invoices as part of the close process.
• Invoices Never Entered. Revenue recognized in the GL but never invoiced in the subledger creates a gap between the aging total and the GL balance that cannot be reconciled without finding the missing invoice.
• Reports Pulled On Inconsistent Dates. Comparing this month’s aging report pulled on the 5th to last month’s pulled on the last day of the month produces a meaningless trend comparison. Use the same reporting date convention every period.

Watch Outs

• Invoices On Active Payment Plans. Accounts on structured payment plans making scheduled payments should be flagged with a status note such as “Payment Plan, Current” so the report reader does not treat a healthy account as a problem account.
• Disputed Invoices. Disputed invoices should remain on the aging report because they represent a potential cash inflow or write-off risk, but they should be flagged separately with a note on the nature of the dispute and expected resolution date.
• Installment Billing. Invoices for future installments may appear as outstanding if the system generates them early, which distorts overdue exposure. Configure installment invoices to generate close to their due date or tag them with a status note.
• Multi-Currency Receivables. Foreign-exchange adjustments recorded in the GL but not reflected in the subledger at the same rate will produce a reconciling difference that requires a separate FX adjustment entry.

Troubleshooting

• Aging Total Does Not Tie To The GL. Run the Open Invoices report and the Transaction List by Customer in QuickBooks Online to identify undeposited funds, unapplied payments, and voided transactions that created orphaned entries. In Excel, build a variance log capturing invoice reference, expected amount, current amount, dollar difference, and root cause before making any corrections.
• No One Owns The Report. When the report is produced but no specific person is responsible for reviewing it, reconciling it, and distributing it, it will not be acted on. Assign ownership explicitly as part of the month-end close checklist.
• Collections Follow-Up Is Ad Hoc. The aging buckets should drive a defined follow-up sequence with clear thresholds. When collections activity is not tied to bucket thresholds, the report is not functioning as a management tool.

Stabilize Your AR Process With Condesa

How To Evaluate Progress

The accounts receivable aging process is working when several conditions hold true consistently.

• The AR subledger is clean: no duplicate invoices, no stale customer records, and no unapplied cash older than the current period.
• The aging report ties to the GL AR balance every period without requiring material manual adjustments.
• The month-end close is faster because AR reconciliation is completed within the first few business days of the new period rather than causing delays.
• Unapplied cash items are cleared promptly rather than accumulating across periods.
• Customer-level visibility is clear: the team knows which customers are in which buckets and what follow-up action is assigned to each.
• The report is distributed consistently to the right stakeholders, such as the controller, owner, and collections team, on the same schedule every period.
• The allowance for doubtful accounts is updated each period using current aging data and documented loss rates, rather than a stale percentage carried forward from a prior year.

These points serve as process maturity indicators. A reliable AR aging process supports sound collections management and accurate financial reporting. Faster collections and lower bad debt follow when teams use the report actively to guide outreach, credit decisions, and allowance updates.

Assess Your AR Maturity With Condesa

Advanced Considerations And Next Steps

Once the accounts receivable aging report is reliable, tied to the GL, produced on a consistent schedule, and distributed to the right people, the next step is to use it as an operational tool rather than a static report.

The aging report becomes the primary input for collections prioritization, including which customers to contact, in what order, and with what escalation. It also forms the foundation for cash flow forecasting, since the expected collection timing of each aging bucket drives near-term cash inflow projections. Balances in the 90+ bucket carry significant uncertainty and should be removed from near-term forecasts until payment is confirmed or a specific arrangement is in place. For a full treatment of these topics, see Condesa’s articles on AR collections strategy and cash-flow forecasting.

Tightening credit terms is a downstream action that the aging report informs. A customer who consistently appears in the 31–60 day bucket is paying slowly. A customer who regularly reaches 90 days represents a material risk. Both patterns appear in the aging history over several months and provide a factual basis for adjusting credit limits, requiring deposits, or shortening payment terms on future orders.

Building a repeatable month-end close checklist that includes AR reconciliation as a defined step, with a named owner, a completion deadline, and a sign-off requirement, is the process improvement that makes everything else sustainable.

Outside support can accelerate this progress in several ways:

• An outsourced accounting team can keep the AR subledger clean, apply payments promptly, and produce the aging report on schedule.
• FP&A support can translate the aging report into a rolling cash flow forecast and flag concentration risk before it becomes a cash problem.
• A fractional CFO can interpret the aging profile, direct collections and credit policy, and ensure the allowance for doubtful accounts remains defensible under ASC 326.

Condesa is a price-competitive fractional CFO and outsourced accounting firm staffed with ex-Big 4 (EY, PwC) professionals that can help SMEs prepare the accounts receivable aging report correctly, reconcile it to the GL, and act on it.