Borrowing Base Dilution: Formula, Causes, and Effect on Availability

Borrowing base dilution is the share of a borrower's invoices that never turns into cash. A customer returns goods, takes a discount, disputes a charge, or never pays, and the receivable shrinks without a matching payment. Asset-based lenders and factoring companies track dilution because it tells them how much of the collateral on a borrowing base certificate will turn into cash. When dilution rises, the amount a borrower can draw goes down.

What a borrowing base is

A borrowing base is the pool of collateral that sets how much a lender will advance on a revolving line. The OCC's Asset-Based Lending handbook defines it as "a collateral base agreed to by the borrower and lender that is used to limit the amount of funds the lender advances the borrower." The loan agreement sets three things for each collateral type:

• Eligibility. Which receivables or inventory count at all.
• Advance rate. The percentage of eligible collateral the lender will lend against.
• Sub-limits and reserves. Caps and deductions for specific risks.

The borrower reports the numbers on a borrowing base certificate. The Journal of Accountancy describes it as a form the borrower prepares and sends to the lender that "reflects the current status of the lender's collateral." The same OCC handbook says ABL lenders often require these certificates weekly or monthly, and some higher-risk borrowers report as often as daily.

What dilution means

The OCC's ABL glossary defines dilution as the difference between the gross amount of invoices and the cash collected on them. Its Accounts Receivable and Inventory Financing handbook describes dilution risk as the chance "that non-cash credits will reduce, or dilute, the accounts receivable balance."

A customer payment lowers the receivable balance and brings in cash. A credit memo lowers the same balance and brings in nothing, so the lender has advanced money against an invoice that is now worth less.

How to calculate borrowing base dilution

The standard formula compares non-cash credits to gross sales over the same period.

Dilution rate = total non-cash credits to receivables ÷ gross invoiced sales, for the same period

The same Journal of Accountancy article, published by the AICPA, gives a clean example. A company bills $1,000,000 and collects $930,000. The $70,000 gap is made up of $20,000 in returned goods, $5,000 in prompt-payment discounts, and $45,000 in bad debts. The dilution rate is 7 percent ($70,000 ÷ $1,000,000). The same article notes that the lender uses dilution to set the advance rate.

A few practical points on the calculation:

• Use the period in the agreement. Many credit agreements name the look-back window. Use that window every time so month-to-month changes mean something.
• Be consistent about timing. Decide once whether a credit counts in the month it is issued or the month of the original invoice, and apply the rule the same way on every certificate.
• Separate cash from non-cash. Only credits that reduce the balance without cash belong in the numerator.

For context, the OCC notes that dilution "varies by industry but is usually expected to be 5 percent or less of receivables."

Common sources of AR dilution

Both OCC handbooks name returns and allowances, disputes, bad debts, and other credit offsets as the main causes. In practice, operations teams usually see these line items:

Contra accounts need special care. The OCC lists them as usually ineligible because "the customer can 'set off' the debt it owes against the debt owed to it and pay only the net amount."

Rising dilution also carries a warning. The OCC tells lenders that "a rise in dilution rates can signal a decline in product or service quality, which can lead to financial problems for the borrower." It also directs field auditors to "review and test selected credit memos."

How lenders respond: dilution reserve, advance rate, and ineligibles

Lenders have three main tools.

1. Lower the advance rate. The OCC's ABL handbook says common receivable advance rates run from 70 to 85 percent of eligible receivables, and that "effective advance rates are often lower after subtracting historic dilution and minimum reserve levels." In that setup, past dilution comes straight off the advance rate.

2. Take a dilution reserve. A reserve is a dollar deduction from the borrowing base. The OCC describes reserves as "deductions from the collateral value" that account for liquidation costs, "the possible dilution of accounts," and other factors that could affect collection. A dilution reserve leaves the headline advance rate alone and subtracts a dollar amount instead.

3. Tighten ineligibles. Ineligibles remove receivables from the base before any advance rate applies. Typical ones on the OCC list include receivables past due too long, amounts over concentration limits, affiliate receivables, re-aged receivables, government and foreign receivables, contra accounts, and unbilled receivables. It also describes cross-aging, where all of one customer's invoices become ineligible once a set share of that customer's balance is past due. The OCC's glossary notes 10 percent is a common threshold.

Worked example: dilution on a borrowing base certificate

The numbers below are hypothetical and rounded to make the math easy to follow. Real agreements set their own rates, thresholds, and formulas.

Assume the credit agreement says the following. The advance rate is 85 percent of eligible receivables. For each point of dilution above 5 percent, the lender takes a reserve equal to that excess times eligible receivables. The borrower has an outstanding loan balance of $700,000.

Month 1. Trailing dilution is 5 percent, so no reserve applies.

Month 2. A large customer returns a shipment and the borrower issues several pricing credits. Trailing non-cash credits come to $90,000 on $1,000,000 of gross sales, so dilution is 9 percent. That is 4 points over the threshold.

Dilution reserve = 4% × $900,000 eligible = $36,000

Availability drops from $65,000 to $29,000 even though gross receivables did not change. If the agreement cut the advance rate instead, the result would match here. Reducing 85 percent by 4 points gives 81 percent, and 81 percent of $900,000 is $729,000.

For the lender, that $36,000 is the gap between what the certificate showed and what the receivables will likely collect. For the borrower, it is cash it can no longer draw.

What to track in your lending system

Dilution is only as accurate as the data behind it. An operations or credit team monitoring a book of ABL or factoring clients should be able to pull these for each borrower without rebuilding a spreadsheet:

• Gross sales by period, as reported and as verified
• Every non-cash credit, tagged by type (return, allowance, discount, write-off, dispute, contra)
• Trailing dilution rate, using the window named in the credit agreement
• The dilution threshold and reserve or advance-rate formula from the agreement
• Ineligible categories and amounts, including cross-aged customers and concentrations
• Each borrowing base certificate as submitted, with the date, signer, and resulting availability
• Field exam results, including credit memo testing
• Alerts when dilution moves past the threshold or trends up across several periods

The tracking gets harder at volume. The invoice factoring company in our factoring company case study was handling 1.2K+ accounts a month through email and manual file saves before it moved onto one onboarding portal. Triumph Business Capital, which provides invoice factoring to over 7,000 trucking businesses, cut underwriting from 5 to 7 days down to 1 day or less after joining its sales and underwriting systems on one Salesforce platform.

Fundingo's loan servicing software runs on Salesforce and tracks past-due loans, exceptions, maturities, and covenants, with an audit trail on approvals. Lenders offering lines of credit to small businesses can see how the same record carries from underwriting into servicing on our small business lending page.

Next step

Pull the last six months of credit memos for your three largest borrowers and compute each one's dilution rate with the formula above. Compare it to the threshold in each credit agreement. If any borrower is near the line, or if you cannot produce the numbers in under an hour, that is where to start. To see how that tracking could work on Salesforce, talk to the Fundingo team.