Ineligible Receivables

Ineligible receivables are the customer balances a loan agreement excludes from the borrowing base because they are old, disputed, offset, concentrated or otherwise less likely to be collected in full.

Formula

How are eligible receivables calculated?

Eligible receivables = total receivables − each category of ineligible receivables, with every dollar removed once

Common categories, each defined in the loan agreement:

  • Aged: invoices past a set number of days from invoice or due date.
  • Cross-aging: the remaining balance of a customer when too large a share of that customer's balance is aged.
  • Concentration: the part of a customer's balance above a set share of total receivables.
  • Contra: balances of customers that are also suppliers, up to what the borrower owes them.
  • Others: affiliate and employee receivables, foreign and government accounts, progress billings, bill-and-hold sales, disputed items and unapplied credits.

What are the ineligibles on a sample C&I deal?

Illustrative figures for Sample Fabrication, Inc. at fiscal year end, under the revolver's illustrative terms.

Category and ruleAmount
Over 90 days from invoice$112,000
Cross-aging: Customer 7 has $40,000 of $60,000 over 90 days (more than 50%), so its $20,000 under 90 days is also excluded$20,000
Concentration: Customer 1's $520,000 above 25% of total receivables ($400,000)$120,000
Contra: Customer 4 owes $90,000; Sample Fabrication owes it $48,000$48,000
Total ineligible$300,000
Eligible receivables ($1,600,000 − $300,000)$1,300,000

At an 80% advance rate, the eligible balance supports $1,040,000 of borrowing. Customer 7's $40,000 over 90 days is already in the first line, so cross-aging removes only the remaining $20,000. Ineligibles total 18.8% of receivables.

How do lenders use ineligibles?

The advance rate assumes the receivables can be collected if the lender has to rely on them. Ineligible categories remove the balances where that assumption fails: an invoice unpaid after 90 days is less likely to be paid, a customer that also sells to the borrower can net what it owes, and one large customer that stops paying would remove a large share of the collateral at once. Categories and thresholds differ by lender and by borrower, and are negotiated in the loan agreement.

Illustrative policy treatment: the sample revolver excludes invoices over 90 days, the rest of any account with more than 50% of its balance over 90 days, any customer balance above 25% of receivables and contra balances.

Where do ineligibles go wrong?

  • Double counting: excluding the same dollar in two categories, which understates availability. Apply categories in a fixed order to the remaining balance.
  • Missing contras because the payables ledger is not compared with the customer list.
  • Measuring concentration against eligible receivables when the agreement says total, or the reverse.
  • Accepting the borrower's ineligible calculation on the borrowing base certificate without testing it against the aging.

Where do ineligibles appear in the credit memo?

The collateral section of a revolver memo shows the ineligible table, the trend in ineligibles as a share of receivables, and any exception granted on a category.

Related terms

Borrowing base, advance rate, accounts receivable aging, customer concentration, borrowing base certificate.

Where LenderBox does this work

On a borrowing base line, LenderBox removes past-due, cross-aged and concentrated accounts from eligibility under your own rules, so ineligibles are caught at the certificate.

See it worked on a deal you bring.

A 30-minute demo can run on documents you bring: LenderBox reads the file, shows the source page behind each figure, and checks the result against your credit policy.

See it on your deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.