Software
SBA
Guides

Industry Guides

CPA Firm GuideDental Practice Guide409A Valuation GuideHVAC GuideLegal Firm GuideManufacturing GuideMedical Practice GuideOptometry GuideOrthodontist GuidePlumbing GuideVeterinary Guide

Financing Guides

A/R Aging Report Guide1031 Exchange GuideLOC GuideSBA 7(a) GuideSBA 504 GuideSection 179 Guide
Articles

Selling a Business

Setting an Asking PriceUsing a Business BrokerSelling a Business During DivorceSelling a Failing BusinessTransferring Intellectual PropertyPreparing an Online Business for SalePreparing for Sale, Two Years OutSelling a Business QuicklyWriting a Selling MemorandumSelling a Business Step by StepSelling a Business With DebtChanges Worth Making Before Selling

Valuation

What Is Enterprise ValueSeller's Discretionary EarningsValuing a Business Accurately

Buying & Financing

Financing an AcquisitionWriting a Financial Plan

Modelling & Operations

Building a Business ModelRisk Management for a Small Business
Templates

Business Templates

Client Service AgreementIndependent Contractor AgreementNon-Disclosure Agreement (NDA)LLC Operating AgreementEmployment AgreementProfessional Invoice TemplateBusiness Loan AgreementBuy-Sell AgreementLetter of Intent (LOI)Partnership Agreement
Sign in
A/R Aging & Borrowing Base
Receivables

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

For informational purposes only. This tool is educational and does not constitute lending, accounting, tax or legal advice. Eligibility criteria, advance rates, concentration caps, cross-aging thresholds and reserve requirements are set by each lender in its loan and security agreement and vary substantially; the defaults here are illustrative rather than standard. Lenders commonly apply further exclusions and reserves not modelled here, including dilution reserves for credit notes and returns, contra accounts, foreign and government receivables, disputed or unbilled amounts, and rent or landlord reserves. An actual borrowing base certificate is prepared to the lender's definitions and is subject to field examination. Confirm all criteria with your lender before relying on any figure shown here.