Accounts receivable aging · Loan documents

Lend against receivables aged customer by customer.

Accounts receivable aging review, customer by customer and bucket by bucket, under your eligibility rules. LenderBox recalculates the borrowing base from the aging and ties each ineligible to its customer and page. Your team advances against receivables it can collect, at approval and every month the line is open.

RECEIVABLES AGING · ILLUSTRATIVEFISCAL YEAR END · DAYS FROM INVOICE
The aging as the controller ran it
ACCOUNTS RECEIVABLE AGING · SAMPLE FABRICATION, INC. · BY CUSTOMER · PAGES 1 TO 3
PAGE 1
CUSTOMERTOTAL0-3031-6061-9090+
3Customer 1520,000360,000160,00000
Customer 2230,000150,00080,00000
Customer 3165,00095,00030,00040,0000
PAGE 2
5Customer 490,00050,00020,00020,0000
4Customer 766.7% over 9060,000010,00010,00040,000
All others535,000305,00084,00074,00072,000
PAGE 3 · TOTALS
1Total1,600,000960,000384,000144,000112,000
2Share100.0%60.0%24.0%9.0%7.0%
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1Total receivables$1,600,000Aging, p. 3
2Over 90 days$112,000 · 7.0%Aging, p. 3
3Largest customer$520,000 · 32.5%Aging, p. 1
4Customer 7, over 90 days66.7% of its balanceAging, p. 2
5Customer 4, also a supplier$48,000 owed to itAging, p. 2 · Payables aging
One customer above the limit$120,000
Customer 1 owes $520,000, 32.5% of receivables, all within 60 days. Above the revolver's 25% limit, $120,000 is ineligible. The same customer is 28.0% of revenue, outside your 25% credit box limit.
Aging, p. 1Income statement
What a credit officer checks on an aging

Reads of the aging that decide what the line can lend.

The aging is tested against the balance sheet, the payables aging, the income statement and the revolver's eligibility rules, using the illustrative Sample Fabrication line.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
Total against the balance sheet
The aging total, set beside receivables on the balance sheet and the borrowing base certificate for the same date.
TIES OUT
$1,600,000 on all three.
Aging, p. 3Balance sheetBBC, p. 1
Past-due buckets
How much of the balance sits beyond 60 and 90 days from invoice.
ON THE RECORD
$112,000, 7.0%, is over 90 days and ineligible. $256,000, 16.0%, is over 60 days.
Aging, p. 3
Cross-aging
A customer with more than half its balance over 90 days loses the rest of its balance too.
FLAGGED
Customer 7 has $40,000 of $60,000 over 90 days, 66.7%. The other $20,000, though under 90 days, is ineligible.
Aging, p. 2
Concentration
Each customer's share of receivables against the 25% limit, and of revenue against your credit box.
FLAGGED
Customer 1 is 32.5% of receivables, so $120,000 is ineligible, and 28.0% of revenue, outside your 25% limit. The top three customers are 52.0% of revenue.
Aging, p. 1Income statement
Contra accounts
Customers that are also suppliers, matched against the payables aging.
FLAGGED
Customer 4 owes $90,000 while the borrower owes it $48,000. The $48,000 can be set off against what it owes and is ineligible.
Aging, p. 2Payables aging
Days sales outstanding
Receivables against a year of sales.
ON THE RECORD
$1,600,000 over $12,000,000 of revenue, times 365: 48.7 days. 60.0% of the balance is within 30 days of invoice.
Aging, p. 3Income statement
What LenderBox returns

$1,300,000 eligible, with each ineligible named by customer.

The aging becomes eligible receivables and a recalculated borrowing base, with each ineligible tied to its customer and page.

RECALCULATEDThe certificate built from this aging is recomputed under your eligibility rules and advance rates before the next advance.
CITED TO THE AGINGEach past-due, cross-aged, concentrated or contra balance points to its aging page and policy section.
YOUR FIGURE AND THEIRSYour eligible figure sits beside the controller's, with the reason for each customer that differs.
CONCENTRATION ON THE RECORDCustomer concentration is read from the financials and set against your limit.
See how revolving lines are underwritten →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
Eligible receivables, the advance and the base
ELIGIBLE RECEIVABLES$1,300,000 after $300,000 of ineligibles
Aging, pp. 1 to 3
RECEIVABLES ADVANCE$1,040,000 at 80%, 65.0% of gross receivables
BORROWING BASE$1,540,000 recalculated, against $1,690,400 certified
BBC, p. 1
CREDIT BOXCustomer 1 at 28.0% of revenue, outside your 25% limit
Income statement

Customer by customer, with the advance left to you.

Reading the aging
LENDERBOX DOESReads every customer and bucket, in whatever layout the borrower's system exports, each cited to its page.
STAYS WITH YOUR TEAMWhich aging, and which date, the certificate must match.
Ineligibles
LENDERBOX DOESApplies your eligibility rules to every customer: past due, cross-aging, concentration and contra.
STAYS WITH YOUR TEAMThe rules themselves, and any exception for a strong customer.
Differences
LENDERBOX DOESShows each difference from the borrower's certificate, customer by customer.
STAYS WITH YOUR TEAMWhether to advance, add a reserve or ask for a corrected certificate.
Each period
LENDERBOX DOESHolds each month's aging beside the covenants and key dates on the line.
STAYS WITH YOUR TEAMWhen to order a field exam or verify a customer.
The memo
LENDERBOX DOESDrafts the receivables part of the collateral section, each ineligible cited.
STAYS WITH YOUR TEAMWhether the $1.5 million line holds.

The aging at approval and every month the line is open.

01 · FIRST LOOKThe aging sent with the request gives a first read on how much of the line is eligible.
02 · UNDERWRITING · THIS DOCUMENTEligibility rules and advance rates are tested against the aging before you commit.
03 · CREDIT DECISIONCommittee sees eligible receivables, concentration and every ineligible, cited by customer.
04 · CLOSINGCurrent agings come before the first advance.
05 · LIFE OF THE LOAN · THIS DOCUMENTEach aging is read as it arrives and the certificate recalculated, with covenant monitoring on the line.

Contras, cross-aging and the 90-day bucket

Which aging fields does LenderBox capture and cite?

Every customer and every bucket, with the totals and the aging date. It reports past-due balances, cross-aging, concentration, contra accounts and days sales outstanding, each cited to the aging page.

Which ineligibles does it apply to an aging?

The ones in your loan agreement. On the sample: over 90 days $112,000, cross-aging $20,000, concentration above 25% $120,000 and contra $48,000. That is $300,000 in all, leaving $1,300,000 eligible.

Does it find contra accounts?

Yes, where the payables aging is in the file. On the sample, Customer 4 owes $90,000 and is owed $48,000 as a supplier, and the $48,000 is ineligible.

Can the aging come straight from the borrower's accounting system?

Yes. A spreadsheet, Word file, scan or PDF from the borrower's system is read as it comes, and an uncertain figure is held for your analyst.

Does it flag a customer with too much of sales?

Yes. On the sample, Customer 1 is 28.0% of revenue against your 25% limit, and its $120,000 above 25% of receivables is ineligible.

Pick the aging with the customer you worry about.

The demo can run on your own deal documents, with every customer, bucket and ineligible returned with its page.

See it in action
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing