Understanding accounts receivable aging

The principle

An accounts receivable aging report groups customer balances by age, often using current and overdue buckets. Confirm whether the report measures age from invoice date or due date, because that changes interpretation. The report should reconcile to the receivables balance in the accounting records.

Put it into practice

Examine customer concentration, disputed invoices, credit notes, and payments received after the report date. A large old balance can dominate the headline total while contributing little usable borrowing capacity. Connect collection expectations to the cash forecast and explain unusual payment terms or seasonal billing patterns.

What people often miss

For factoring or receivables lending, the provider applies its own eligibility rules. Overdue, related-party, foreign, disputed, or concentrated balances may receive different treatment or be excluded. Do not assume every recorded dollar can be advanced. Track how a single customer delay affects both cash receipts and borrowing availability at the same time.

Read the bucket definition before the balance

Suppose an invoice was issued 45 days ago on 60-day payment terms. It is 45 days old by invoice date but is not yet past due. An aging report based on invoice date and one based on due date will place it differently. Neither report is necessarily wrong, but a lender and borrower comparing different conventions can reach different conclusions about overdue balances. Put the reporting date and aging basis at the top of the schedule.

Consider a fictional $100,000 ledger: $55,000 current, $25,000 one to thirty days overdue, $12,000 thirty-one to sixty days overdue, and $8,000 older. Those buckets total $100,000, but a $5,000 unresolved credit note and a $7,000 disputed invoice would require investigation. Do not count the same adjustment twice if it already appears in the net customer balance.

Source: Sage: aged receivables report settings

Separate collections management from lending eligibility

A collections list asks what action gets an invoice paid: confirm delivery, resolve a dispute, correct a purchase-order reference or agree a payment date. A lender eligibility schedule asks a different question: which balances qualify under the financing contract today? A current invoice could still be excluded because of customer concentration, related-party status, foreign-customer rules or another contractual limit. No general guide can establish the eligibility of a particular ledger.

For a simplified illustration, assume a provider accepts $70,000 of the $100,000 ledger and applies an 80% advance rate. Gross support is $56,000. If $35,000 is already drawn and a $3,000 reserve applies, illustrative remaining availability is $18,000. The numbers are not a quoted product. They show why $100,000 of receivables does not mean $80,000 of new cash. Refresh the calculation as customers pay, credits are issued and invoices age, and reconcile the resulting cash movements with the accounting records.

• Is aging measured from invoice date or contractual due date?
• Do credits, disputes and later receipts explain old balances?
• Which customers account for the largest portion of exposure?
• What contract exclusions and existing drawings reduce availability?

Source: OCC: accounts receivable and inventory financing

Your next-step checklist

• Report date and aging convention
• Reconciliation to the ledger
• Disputes, credits, and subsequent receipts
• Customer concentration and financing eligibility