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.
Make the report reconcile before explaining it
Run the aging report for the same date as the financial statements supplied to the lender. Reconcile its total with the receivables control account and explain differences, including unapplied receipts, credits, or entries posted after the reporting date.
Confirm whether aging buckets measure days since invoice or days past due. An invoice issued forty days ago on sixty-day terms tells a different story from one forty days overdue. Keep the original invoice date and payment terms visible.
Explain quality as well as age
Flag disputed invoices, related-party balances, credits awaiting processing, and material customer concentrations. Add factual collection notes and evidence of payments received after the report date. Do not make an old invoice appear younger by changing its date.
For receivables-backed financing, ask how the agreement treats overdue accounts, concentration, and cross-aging. A customer with one problem balance may affect more than that single invoice under the lender's rules. Accounting receivables and eligible collateral must remain separate totals.
Illustrative concentration hidden inside a total
A fictional report totals $120,000: $70,000 not yet due and $50,000 overdue. One customer owes $40,000, or one-third of the total. The lender needs the customer detail and aging, not merely the $120,000 headline. No eligibility percentage is assumed.
Ask your broker
- Which date and aging convention does the lender require?
- How do concentration and cross-aging affect eligible invoices?
Your next-step checklist
- Report date and aging convention
- Reconciliation to the ledger
- Disputes, credits, and subsequent receipts
- Customer concentration and financing eligibility
Crack this combination.
Does the full receivables ledger automatically equal eligible collateral?
Keys track learning on this device and, when signed in, in your Saved files library. Every dossier stays open.
Sources & further reading
This file draws on the following references. Product availability and requirements must be confirmed with the provider.
Levr: accounts receivable reportsOCC: asset-based lending handbook