Accounts receivable aging explained

The business context

Before reading the buckets, check the report date and whether aging runs from invoice date or due date. A 45 day old invoice with 60 day payment terms is not yet overdue. Mixing those definitions can make a healthy customer balance look delinquent.

What an accounts receivable aging report shows

An aging report usually identifies customers, invoice balances, and time buckets such as current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. A summary combines customer balances; a detail report lets you examine individual invoices. Intuit documents both report types for QuickBooks.^[1]

Record whether the report includes credit notes, unapplied cash, disputed balances, and related party invoices. Ask the finance team to reconcile it to the accounts receivable control balance using the same date and accounting basis.

An aging report is a snapshot. It does not prove that each invoice is valid or that the customer will pay on the expected date. Collections notes and supporting documentation complete the picture.

Read the report with a simple example

Assume the following hypothetical report uses days past the contractual due date:

The overdue balance is $45,000, or 45% of total receivables. The amount more than 60 days past due is $8,000, or 8%. These percentages describe this example only; neither is a universal lending threshold.

The next step is to identify why the balances are late. A large approved payment arriving next week presents a different situation from a disputed invoice with no acceptance evidence. Investigate at the invoice and customer level before deciding what the total means.

Why lenders and factors examine aging

Receivables financing relies on the quality and availability of the underlying claims. Providers may consider age, disputes, credits, customer concentration, contractual rights, and existing security interests. The OCC's asset based lending guidance discusses evaluating receivables and setting controls around the collateral base.^[2]

A provider may exclude invoices beyond its age cutoff or apply limits to balances owed by one customer. Some use cross aging provisions that make additional invoices from a customer ineligible when enough of that customer's balance is overdue. These are contract specific rules, not one standard applied to every facility.

If you are evaluating a sale of invoices, read how invoice factoring works. Recourse terms can also leave specified unpaid invoices your responsibility after funding.^[3]

Estimate availability without confusing it with the ledger balance

Use the provider's actual eligibility rules to build a borrowing base. For illustration, start with $100,000 in total receivables and assume three nonoverlapping exclusions: $8,000 beyond the provider's age limit, $7,000 in disputed invoices, and $10,000 above a customer concentration cap.

That leaves $75,000 of eligible receivables. At an illustrative 85% advance rate, gross borrowing base support is $63,750. If the facility already has $40,000 outstanding and applies a separate $5,000 availability reserve, additional availability is $18,750 before any other limits or costs.

These assumed rules are not a quote. Actual availability can also be restricted by the facility limit, covenant status, prior liens, dilution, or other contract provisions. Avoid deducting an invoice twice when multiple exclusions overlap.

Fix the records before drawing conclusions

Apply received payments to the correct invoices, issue valid credit notes, resolve duplicate entries, and confirm the reporting date. A customer can appear overdue because cash was received but never allocated. Conversely, changing a due date without a genuine agreed amendment can hide delinquency.

Preserve the original transaction history and document corrections. The objective is an accurate ledger that another person can verify, not a report that looks younger on paper.

When presenting an application, attach an explanation of material adjustments and any difference from the balance sheet. Use the business funding document checklist to keep the financial statements and schedules aligned.

Turn the report into a collections plan

Assign an owner and next action to each material overdue balance. Confirm that invoices reached the right contact and include the purchase order, delivery evidence, and any required acceptance documentation. Resolve disputes separately from ordinary late payment follow up.

Prioritize by amount, age, customer importance, and probability of collection. A small old balance may need a different process from a large invoice whose payment is held for one missing document. Review repeated late payment when negotiating future terms or credit limits.

Keep a record of promised payment dates and actual receipts. Those dates can inform your cash flow forecast, although a promise is still an assumption until cash arrives. Do not automatically forecast every overdue invoice as collected next week.

Common questions about receivable aging

Is a current invoice always eligible for financing?

No. It may still be disputed, unearned, owed by an unacceptable customer, subject to another assignment, or excluded by the facility's terms. Age is one eligibility factor.

Is aging the same as days sales outstanding?

No. Aging classifies specific unpaid balances by time bucket. Days sales outstanding is an aggregate collection metric based on receivables and sales over a defined period. They can be used together, but they answer different questions.

How often should I review the report?

Match the frequency to the volume and risk of your receivables. A weekly review can be useful for an active collection operation, while lenders may set their own reporting schedule. Review more closely when a major customer slows payment or a financing base is near its limit.

Use receivables as evidence of the cash cycle

Bring a reconciled aging report, customer concentration detail, and collection notes to a Westwind funding advisor. We can help discuss how the receivable base may fit available financing structures and what further evidence a provider may need.