Receivables aging report
A receivables aging report groups open invoices into time buckets based on days outstanding, commonly current, 1 to 30, 31 to 60, 61 to 90, and over 90 days. Lenders use it to apply aging eligibility tests, monitor collection performance, and calculate the delinquency and default ratios that drive reserves and triggers.
One report, several audiences
Collections teams use the aging to prioritize calls. Controllers use it to support the allowance. Lenders use it for something stricter: the buckets map directly to money. Invoices aging past the eligibility cutoff drop out of the borrowing base, customers crossing a cross-aging threshold take their whole balance with them, and the movement between buckets feeds the delinquency and default ratios in a securitization.
| Bucket | Amount | Share |
|---|---|---|
| Current (not yet due) | $26,000,000 | 61.9% |
| 1 to 30 days past due | $9,200,000 | 21.9% |
| 31 to 60 days past due | $4,100,000 | 9.8% |
| 61 to 90 days past due | $1,700,000 | 4.0% |
| Over 90 days past due | $1,000,000 | 2.4% |
If the facility makes invoices ineligible at 90 days past due, this pool loses $1,000,000 immediately, and the $1,700,000 in the 61 to 90 bucket is next month's risk.
Invoice date versus due date aging
The single most common source of confusion. Aging from invoice date measures how old the invoice is. Aging from due date measures how late it is. An invoice with 120 day terms can be 100 days old and still current on a due date basis. Most asset-based lending agreements cut eligibility at 90 days from invoice date or 60 days from due date, and many securitizations define delinquency buckets from due date. Using the wrong basis misstates eligibility and every ratio built on the buckets.
What quietly distorts an aging
- Unapplied cash sitting on account: paid invoices stay open and age, overstating delinquency.
- Credit memos left unmatched: a credit in the current bucket can mask an old debit it should offset.
- Rebilled invoices resetting the clock: cancelling and reissuing an invoice makes an old exposure look new, which most agreements treat as a reportable practice.
- Terms changes: extending a customer's terms silently moves their balance toward current on a due date basis.
Olycor ages every invoice on both bases from source dates, applies the bucket definitions your facility actually uses, and flags the distortions above, unapplied cash, unmatched credits, and reissued invoices, before they reach the certificate. Each bucket total decomposes to the invoices inside it.
Frequently asked questions
Which aging basis should I report to my lender?+
How do credit memos appear in an aging?+
How is the aging used in securitization ratio calculations?+
Age your receivables the way your agreement defines it.
Olycor builds agings on both invoice date and due date bases from source records, with every bucket traceable down to the individual invoices.
Get early accessRELATED READING
Last updated 2026-07-08. This page explains general market practice. Your credit agreement governs how these concepts apply to your facility. Olycor does not provide legal, tax, accounting, or credit advice.