An aging schedule is a sort. This is what a lender does with it.
Enter your open invoices and this ages them, measures customer concentration, and applies the ineligibility rules a lender uses to size a borrowing base. The rules matter more than the sort: they routinely exclude receivables that look perfectly collectable on the schedule.
✓Cross-aging — if more than half of one customer's balance is past 90 days, most lenders deem that customer's ENTIRE balance ineligible — including the current portion. This is the rule that surprises people.
✓Concentration cap — no single account may exceed a stated share of the eligible pool. The excess is trimmed, not the whole balance.
✓Aged from the due date — not the invoice date. Aging from the invoice overstates delinquency by your payment terms.
✓Related parties excluded — balances owed by affiliates are not third-party receivables and lenders remove them entirely.
Also commonly excluded
ContraCustomers who are also your suppliers, to the extent of the offset
ForeignReceivables from outside the country, unless credit-insured
DisputedAnything subject to a claim, chargeback or credit note
ProgressUnbilled or progress-billed amounts on incomplete work
CreditsCredit balances, which cannot be netted against other accounts
Report identification
This schedule will be read by someone who did not prepare it. Naming the company, the responsible officer, the preparer and the date it speaks to is what turns a working spreadsheet into a document a lender or buyer can rely on.
Accounts Receivable Aging Schedule
— company name —
As of November 6, 2026Prepared November 6, 2026
Preparer
Chief executive / owner · approved
Section A — Report settings
Aging is measured to this date
Typically 75–85% of eligible
Per-customer limit, 15–25% typical
Over-90 share that taints the whole account
For the DSO calculation
Section B — Aging summary
Current
$0
0.0% of total
1–30
$0
0.0% of total
31–60
$0
0.0% of total
61–90
$186K
33.9% of total
Over 90
$362K
66.1% of total
Total A/R
$548K
DSO 48 days
66.1% of receivables are over 90 days. Above roughly 10% a lender starts questioning collection practice and the adequacy of any bad debt allowance, and a buyer will discount the balance in a working capital calculation. Aged balances are also the trigger for the cross-aging rule below.
Section C — Open invoices
Enter the due date, not the invoice date. Tick the related-party box for anything owed by an affiliate, an owner or a business under common control — lenders exclude those entirely.
Customer
Invoice
Due date
Amount
Days
Bucket
Related
101
Over 90
80
61–90
86
61–90
144
Over 90
97
Over 90
188
Over 90
237
Over 90
76
61–90
119
Over 90
93
Over 90
Section D — By customer
Customer
Current
1–30
31–60
61–90
Over 90
Total
Share
Eligible
Dover Industrialcross-aged
—
—
—
$92K
$118K
$210K
38.3%
$0
Crest Supplycross-aged
—
—
—
—
$90K
$90K
16.4%
$0
Borden Metalscross-aged
—
—
—
$40K
$45K
$85K
15.5%
$0
Acme Fabricationcapped
—
—
—
$54K
$26K
$80K
14.6%
$14K
Northgate Holdingsrelated
—
—
—
—
$48K
$48K
8.8%
$0
Edge Componentscross-aged
—
—
—
—
$35K
$35K
6.4%
$0
Total
$0
$0
$0
$186K
$362K
$548K
100%
$14K
Dover Industrial is 38.3% of receivables. Above the 25% cap, so the excess is excluded from the borrowing base. In diligence this is also read as customer concentration risk, which is priced separately from the lending consequence.
Cross-aging has removed 4 accounts entirely. Dover Industrial, Crest Supply, Borden Metals, Edge Components have more than 50% of the balance past 90 days, so the whole balance is ineligible — including $132K that is current or only mildly aged. Collecting the old invoices restores the rest.
Section E — Borrowing base
Total accounts receivable$548,000Less related-party balancesNot third-party receivables($48,000)Less balances over 90 daysOn accounts not otherwise cross-aged($26,000)Less cross-aged accountsWhole balance, where over-90 exceeds 50%($420,000)Less concentration excessAbove 25% of the $54,000 pool, i.e. $13,500 per account($40,500)Eligible receivables$13,500Advance rate80%Borrowing base$10,800
2% of your receivables are eligible, and the line advances against 80% of that. A borrowing base of $10,800 against $548,000 of receivables is 2% — which is why a line sized from total A/R is almost always larger than the line you are offered.