Aging of Accounts Receivable

Aging of accounts receivable is the process of grouping unpaid customer balances by how long invoices have been outstanding or how many days they are past due. The resulting receivables aging schedule helps a business evaluate collection risk, prioritize follow-up, estimate credit losses, and support borrowing-base reporting.

An aging schedule is more informative than the total accounts receivable balance because it shows whether unpaid amounts are recent, overdue, disputed, or concentrated in older buckets.

Key Takeaways

• Aging can be measured from the invoice date or from the contractual due date; the report must state which basis it uses.
• Common buckets include current, 1-30, 31-60, 61-90, and more than 90 days past due, but no bucket structure is universal.
• Older receivables often deserve more scrutiny, but age alone does not establish collectibility or the required allowance.
• Accounting, collections, and lending teams can use the same schedule for different decisions.
• Reconcile the aging total to the general ledger and investigate credits, disputes, unapplied cash, and cutoff errors before relying on it.

How Receivables Aging Works

The company selects a reporting date, such as month-end, and assigns each open invoice to a bucket. If aging is based on days past due, the calculation is:

Days past due = reporting date - contractual due date

An invoice due after the reporting date is current. An invoice due 18 days before the reporting date belongs in the 1-30 days past-due bucket under a conventional schedule.

If aging is based on invoice age, the calculation starts from the invoice date. A 45-day-old invoice with 60-day payment terms is not yet past due, even though its invoice age is 45 days. Mixing those two bases can make collection performance look better or worse than it is.

A reliable schedule also accounts for:

• credit notes, returns, rebates, and other dilution;
• cash received but not yet applied to an invoice;
• disputed balances and promised payment dates;
• customer master-data changes and duplicate accounts;
• foreign-currency translation; and
• invoices recorded in the wrong reporting period.

Worked Example: Aging Schedule

Assume a company prepares the following days-past-due aging at month-end:

The schedule shows $30,000, or 18.75% of total receivables, more than 30 days past due. That fact can trigger customer-level review, but it does not by itself determine the amount uncollectible.

Illustrative Provision Matrix

An entity may use aging buckets as one input to an expected-credit-loss provision matrix when permitted by its accounting framework and appropriate for the portfolio. Assume the company applies these illustrative, not prescribed, rates after considering historical outcomes, current conditions, and reasonable forecasts:

The arithmetic is balance x applicable loss rate for each bucket. The $6,600 result is not automatically the correct allowance for doubtful accounts. Management may need separate segments, customer-specific adjustments, collateral or insurance analysis, macroeconomic adjustments, and treatment of balances that no longer share common risk characteristics.

Operational Credit and Collections Use

Credit teams use aging to identify changes that aggregate sales and receivables figures can hide:

• customers moving into later buckets;
• recurring slow payment despite growing sales;
• disputed invoices that remain unresolved;
• concentration of overdue balances in one customer or industry;
• deterioration after a credit-limit increase; and
• collection promises that repeatedly fail.

The schedule can guide collection priority, account holds, revised customer credit limits, dispute escalation, and cash forecasting. It should not replace customer contact, invoice-level evidence, or assessment of the commercial relationship.

Lending and Borrowing-Base Use

An asset-based lender may use aging to determine whether receivables remain eligible collateral. The agreement may exclude balances older than a stated threshold and may apply cross-aging, under which excessive delinquency for one account debtor makes that debtor’s otherwise current invoices ineligible too.

Lenders also examine dilution, concentrations, credit memos, offsets, contra accounts, disputes, foreign receivables, and collections after the reporting date. A receivable can be current yet ineligible, or old yet supported by circumstances that require specific analysis. The loan agreement, not a general aging convention, controls borrowing-base treatment.

Aging Versus Other Collection Measures

These measures answer different questions and are stronger when reviewed together.

How to Review an Aging Schedule

1. Confirm the reporting date, aging basis, bucket boundaries, and payment terms.
2. Reconcile the total to the subledger and general-ledger control account.
3. Match selected invoices to contracts, delivery evidence, due dates, credits, and cash receipts.
4. Review old balances by customer rather than relying only on bucket totals.
5. Separate disputes, related-party balances, insured receivables, and balances with different risk characteristics.
6. Compare the schedule with prior periods, DSO, write-offs, recoveries, and credit-limit changes.
7. For lending use, apply the exact eligibility, concentration, dilution, and cross-aging rules in the agreement.
8. For accounting use, document how historical experience, current conditions, and forecasts affect the loss estimate.

Common Mistakes and Limitations

• Using invoice age as days past due. The two measures differ when customers have nonstandard terms.
• Treating bucket labels as universal. A 30-day bucket does not prove the invoice had 30-day terms.
• Ignoring unapplied cash. Receivables can appear overdue after the customer has paid.
• Leaving credits and disputes unresolved. Gross balances can overstate both exposure and delinquency.
• Applying one loss rate to unlike customers. Geography, product, collateral, insurance, and customer type can produce different loss patterns.
• Equating old with worthless. Age is a risk signal, not conclusive evidence of non-collection.
• Using aging alone for a credit decision. Customer solvency, concentration, legal rights, subsequent receipts, and economic conditions also matter.

Accounting requirements, lending eligibility, and collection rights vary by jurisdiction, reporting framework, and contract. This page provides general financial education, not accounting, legal, lending, or collection advice.

Official Sources

• IFRS Foundation: Post-implementation Review of IFRS 9 Impairment
• SEC: Staff Accounting Bulletin No. 119
• OCC: Accounts Receivable and Inventory Financing

These sources illustrate expected-credit-loss methods and lender use of aging, delinquency, dilution, and cross-aging. They do not prescribe one schedule or loss rate for every entity.

Related Terms

• Accounts Receivable: Customer amounts owed for credit sales or services.
• Allowance for Doubtful Accounts: Valuation allowance for estimated receivables that will not be collected.
• Bad Debt: Credit loss associated with an amount that is not expected to be recovered.
• Days Sales Outstanding: Sales-based measure of receivables collection timing.
• Accounts Receivable Turnover: Ratio comparing credit sales with average receivables.
• Asset-Based Lending: Lending whose availability depends on eligible collateral and reserves.

FAQs