Accounts Receivable Aging: How Lenders Test Working-Capital Collateral

01

Why Lenders Review the Aging

Receivables may support repayment and serve as collateral for a working-capital line, asset-based loan, or factoring facility. The aging helps a lender see how much is current, how quickly customers pay, whether balances are concentrated, and whether past-due amounts are increasing. It also shows whether reported revenue is converting to cash. A large receivable balance is not automatically strong collateral: collectability, documentation, customer quality, invoice terms, offsets, and eligibility rules all affect how the lender views it.

02

Build the Report From Invoice-Level Data

Prepare the aging as of the same date as the balance sheet and borrowing-base certificate. Include customer name, invoice number, invoice date, due date, original invoice amount, open balance, credits, and the aging bucket used by the accounting system. Common buckets are current, 1–30, 31–60, 61–90, and more than 90 days past due, but the lender may require a different format. Use the contractual due date—not an estimated collection date—and separate retainage, deposits, unbilled work, finance charges, related-party balances, and other nonstandard items.

• Requested amount and use of proceeds
• Historical and current financial statements
• Complete debt and ownership schedules
• Collateral and transaction documentation

03

Reconcile the Aging to the General Ledger

The aging total should agree with the accounts-receivable balance on the dated general ledger and financial statements. Identify unapplied cash, credit memos, write-offs, foreign-currency adjustments, intercompany amounts, and timing differences that cause discrepancies. Reconcile the beginning balance, invoices, cash collections, credits, and ending balance for the review period. If the company uses multiple systems or entities, provide a short bridge between each subledger and the consolidated financial statements rather than submitting totals that appear similar but cannot be traced.

04

Explain Past-Due Balances and Collection Patterns

A lender will look beyond the percentage in each aging bucket. Explain material late accounts, disputed invoices, customer approvals, payment plans, returns, short payments, offsets, and collection actions. Distinguish a recurring slow-pay customer that remains current under agreed terms from an invoice that is contractually delinquent. Provide subsequent-payment evidence for large balances when requested. Track days sales outstanding, aging migration, bad-debt expense, and write-offs over time so the lender can determine whether a favorable month-end report reflects durable performance or temporary collection timing.

05

Measure Customer Concentration and Cross-Aging Risk

Calculate each customer's share of total receivables and revenue. A strong customer can still create risk if one account represents a large portion of expected cash collections. Some lenders cap the amount attributable to a concentrated customer or require additional support. Cross-aging provisions may exclude all invoices from a customer when too much of that customer's balance is past due. Show parent-company relationships, common payors, government or foreign customers, and known rights of offset so concentration is measured economically rather than by slightly different customer names.

06

Separate Gross Receivables From Eligible Collateral

A borrowing base usually applies an advance rate only to eligible receivables. Depending on the facility, exclusions may include balances beyond a stated age, retainage, related-party invoices, foreign receivables, progress billings, unbilled amounts, consumer accounts, contra accounts, disputed invoices, certain government receivables, or amounts exceeding concentration limits. Eligibility is defined by the loan documents and lender, not by the borrower. Build a transparent schedule from gross receivables to total ineligible amounts, eligible collateral, advance rate, reserves, outstanding line balance, and remaining availability.

07

Connect the Aging to Cash Flow and the Requested Line

Use invoice issuance and actual collection behavior to build a weekly or monthly cash forecast. Match payroll, supplier, freight, tax, and operating disbursements against expected customer receipts. Show seasonal peaks, growth-related working-capital needs, and how the line returns toward a lower balance when the cycle completes. If the proposed facility would remain fully drawn without a credible repayment cycle, explain whether the need is permanent capital, a term loan, or a different structure rather than presenting it as a short-term revolver.

08

Maintain a Lender-Ready Monthly Process

Close the subledger promptly, apply cash consistently, investigate negative and duplicate balances, document credits, and retain supporting invoices, contracts, purchase orders, delivery evidence, and customer correspondence. Review the aging alongside payables, inventory, revenue, and bank activity so one report does not contradict the rest of the file. PFCS can help organize a working-capital request and coordinate it with third-party capital sources, but each lender determines collateral eligibility, advance rates, reserves, reporting frequency, covenants, approval, pricing, and final terms.