Asset Based Lending Ineligible Calculations: How Cross-Aging and the Other AR Exclusions Compound Through the Borrowing Base

Most borrowers know the names of the ineligible categories. Far fewer understand the order of operations that turns a clean-looking AR aging into a borrowing base availability number — and the cascading interactions that cause a $20M gross AR balance to settle around $11.4M of net revolver availability after the math runs. The compounding is where the surprises live, and cross-aging is the single line that contributes the most surprise.

This is a worked walkthrough of the ineligible calculations a lender's borrowing base agent will actually run when your monthly certificate hits their desk. I have spent five decades inside this math — I wrote Asset Based Lending Disciplines, the first textbook on the discipline, trained more than 5,000 lenders and field examiners, and was inducted into the SFNet Hall of Fame in 2021 for the body of work behind it. The mechanics in this article are the same mechanics every credit-trained ABL underwriter uses when they sit down to validate availability.

For the foundational list of which categories exist and why, see our companion post on eligible vs. ineligible receivables in ABL. For the certificate-format walkthrough, see how to read an ABL borrowing base certificate, line by line. This post is the missing piece in the middle: the actual arithmetic that connects the two, with the cross-aging mechanic broken out in detail because it is the one borrowers most consistently misread.

The Calculation Skeleton: Eight Steps, Always in This Order

Every ABL credit agreement defines "Eligible Receivable" as a long list of negative conditions. When the borrowing base agent computes availability, those conditions are applied in a specific order — and the order matters, because each step modifies the pool the next step operates on. Run the steps out of sequence and you will arrive at a different (usually higher) number than the lender will.

The standard order is:

1. Start with Gross AR — total accounts receivable per the general ledger, tied to the trial balance.
2. Remove categorical ineligibles — intercompany, affiliate, employee, bill-and-hold, consignment, COD, progress-billing, disputed, credit-balance, and any other invoice that fails the basic definition before aging is even considered.
3. Remove aged invoices — typically any invoice over 90 days from invoice date, or over 60 days past stated due date, depending on the credit agreement.
4. Apply cross-aging — for any customer whose past-due percentage trips the cross-age threshold, exclude the entire remaining customer balance, not just the past-due portion.
5. Remove foreign and government exclusions — uninsured foreign AR, federal receivables without an Assignment of Claims acknowledgment, and other jurisdictional carve-outs.
6. Net contra balances — for any customer who is also a vendor, subtract the lower of the AR and AP balances.
7. Apply concentration caps — for any single customer (or affiliated group) whose remaining eligible balance exceeds the concentration limit, exclude the excess.
8. Apply the advance rate, then subtract reserves — multiply the resulting eligible AR pool by the advance rate (commonly 80 to 85 percent), then deduct dilution reserves, dispute reserves, slow-pay reserves, and any availability blocks the agent has imposed.

The pool that remains is AR availability. Inventory availability is computed in parallel on its own waterfall, then summed; LCs outstanding and revolver loans outstanding come off the top to produce net availability. The mechanics of the inventory side are covered in our appraisal guide and the certificate-level mechanics in the BBC walkthrough.

Why Order Matters: The Cross-Aging Trap

The single biggest source of CFO surprise is the interaction between Step 3 (aged invoices) and Step 4 (cross-aging). Borrowers commonly assume the calculation works like this: take out the past-due dollars and move on. The actual mechanic is different. Past-due invoices are removed in Step 3, then in Step 4 the calculation looks at each customer as a unit and asks: of this customer's original balance, what percentage was past due? If that percentage exceeds the threshold in the credit agreement — most commonly 25 percent, but in some agreements 50 percent — the entire remaining balance from that customer is wiped out of the eligible pool, including invoices that are current.

The cross-age threshold is sometimes called the "taint" rule. Customers above the threshold are tainted, and the taint travels to every dollar that customer owes. A customer with $500,000 current and $200,000 over 90 days has a 28.6 percent past-due percentage. At a 25 percent threshold, the $500,000 of current balance is also ineligible. At a 50 percent threshold, it stays eligible. That single negotiation point — 25 versus 50 — moves real availability for any borrower with concentrated slow-paying customers.

The reverse case matters too. A borrower who reduces a customer's past-due bucket from $200,000 to $140,000 has moved that customer from 28.6 percent past due to 21.9 percent past due — under the 25 percent threshold. The $500,000 of current balance becomes eligible again. Sixty thousand dollars of collections recovered $500,000 of availability. The leverage on disciplined 60-to-89-day collections is enormous, and it is almost entirely a cross-aging effect.

The Two Cross-Aging Methodologies

Credit agreements vary on how the cross-age percentage is calculated. The two common methodologies:

• Past-due to total method. The numerator is the customer's past-due dollars; the denominator is the customer's total balance (current plus past due). This is the most common formulation. A $700,000 customer with $200,000 past due is at 28.6 percent.
• Past-due to current method. The numerator is the customer's past-due dollars; the denominator is the customer's current dollars only. This is a more punitive formulation. The same customer would be at 40 percent under this method.

The choice of methodology is a credit-agreement negotiation point, not a market default. Borrowers who do not know which method their lender uses will misforecast their own availability. Our ABL term sheet negotiation playbook covers the eligibility and cross-age definitions among the highest-leverage items to nail down before the credit agreement is drafted.

A Worked Example: From $20M Gross AR to $11.4M of Availability

Consider a distribution business with the following characteristics — representative of the deals we package at Don Clarke Enterprises for placement with banks like Wells Fargo Capital Finance, JP Morgan ABL, PNC Business Credit, and the specialty platforms.

• Gross AR: $20,000,000
• Top customer concentration: $4,500,000 (22.5 percent of gross)
• Federal government customer (no Assignment of Claims in place): $600,000
• Canadian customer (uninsured): $400,000
• Contra exposure on largest customer (AP balance to same counterparty): $300,000
• Intercompany receivable from affiliated entity: $250,000
• Past-due over 90 days: $1,200,000
• Two customers tripped by cross-age (25 percent threshold, past-due to total method): combined current balance $850,000 plus combined past-due balance $400,000
• Open disputes flagged in AR system: $150,000
• Trailing twelve-month dilution: 7.5 percent against a 5 percent threshold
• Advance rate: 85 percent
• Concentration cap: 20 percent of eligible AR, with the top customer being a Tier 1 grocery chain that has been negotiated to a 25 percent custom cap

The waterfall runs as follows:

Step 1: Gross AR	$20,000,000
Step 2a: Less intercompany	($250,000)
Step 2b: Less disputed	($150,000)
Step 3: Less past-due over 90 days (excluding cross-age customers, already in the $1.2M)	($800,000)
Step 4: Less cross-age customers (current $850K + past due $400K)	($1,250,000)
Step 5a: Less federal government AR (no Assignment of Claims)	($600,000)
Step 5b: Less uninsured Canadian AR	($400,000)
Step 6: Less contra exposure	($300,000)
Pre-concentration eligible AR	$16,250,000
Step 7: Less top-customer concentration excess ($4,500,000 cap of 25% × $16.25M = $4,062,500 → excess = $437,500)	($437,500)
Eligible AR after concentration	$15,812,500
Step 8a: Times advance rate (85%)	$13,440,625
Step 8b: Less dilution reserve (7.5% − 5% = 2.5%; reserve formula = (2.5% / (1 − 7.5%)) × eligible AR = 2.7% × $15,812,500)	($427,500)
Step 8c: Less lender-imposed slow-pay reserve on a watchlist customer	($150,000)
Step 8d: Less landlord reserve (3 months rent on the primary distribution center, no waiver in place)	($1,500,000)
Net AR availability	$11,363,125

The borrower started with $20M of AR and arrived at $11.4M of revolver availability against that AR — a 56.8 percent net advance rate against gross. The advance rate itself was 85 percent. The compounding effect of the ineligible cascade and the reserves accounts for the rest. This is the math every ABL borrower needs to be able to run on their own AR aging before the first lender meeting.

Where the Largest Dollars Hide

Three observations from the example above generalize across the deals we see:

Cross-Aging Dwarfs Past-Due in Aggregate Impact

The $800K of pure past-due exclusion is meaningful, but the $1,250,000 of cross-age exclusion — including $850K of current dollars that get pulled into the past-due penalty box — is larger. Across our deal book, cross-aging on average removes 1.5 to 3 times as much availability as raw past-due exclusions alone. Borrowers who run a "past-due only" projection and ignore cross-aging consistently overstate their availability by mid-to-high single-digit percentages of gross AR. That is real money on a $20M base. On a $200M base, it is a financing-defining error.

Reserves Are Often Larger Than Ineligibles

In the worked example, AR ineligibles total $3,387,500 (gross less pre-concentration eligible AR plus concentration excess). Reserves total $2,077,500. On many deals — particularly real-estate-heavy distribution and manufacturing businesses without landlord waivers — the reserve stack approaches or exceeds the ineligible stack. We covered the negotiation mechanics in detail in our ABL borrowing base reserves article; the operational point here is that ignoring reserves while modeling ineligibles produces a similarly distorted availability picture.

The Compounding Is Multiplicative, Not Additive

Each step in the waterfall reduces the pool the next step operates on. The advance rate is applied to a smaller number after ineligibles. The concentration cap is applied to a smaller number after the foreign/federal/contra cuts. Even the dilution reserve formula uses eligible AR as its base. A 1 percentage-point change to the concentration cap interacts with cross-aging, with foreign exclusions, and with the advance rate — so the marginal value of moving 20 percent to 25 percent depends on what the rest of the pool looks like. CFOs who treat the calculation as eight independent subtractions miss the interaction effects and consistently misestimate the value of any single negotiation point.

What Borrowers Can Control Before the Lender Runs the Math

Most of the levers worth pulling are operational, not contractual — though contractual definitions set the ceiling for what operations can recover.

1. Tighten the 60-to-89-Day Collection Bucket

Every dollar collected before day 90 stays eligible. Every dollar collected after day 90 is ineligible and can trigger cross-age on the customer's entire balance. A dollar-for-dollar lift in this bucket can deliver multiples of itself in restored availability when the cross-age threshold is in play. We covered the operational cadence in the borrowing base monitoring guide.

2. Negotiate the Cross-Age Threshold and Methodology

At term sheet stage, push for the 50 percent threshold under the past-due to total method. That single combination produces materially more eligible AR than 25 percent past-due to current. Few CFOs negotiate this line; the lenders we work with regularly accept reasonable cross-age relief in the credit agreement when it is asked for early and supported with historical aging data. The mechanics of high-leverage term sheet negotiation are in our ABL term sheet negotiation post.

3. Build Custom Concentration Carve-Outs for Investment-Grade Customers

The $4.5M Tier 1 grocery customer in our example was already negotiated to a 25 percent cap. Without that custom cap, the standard 20 percent cap would have excluded an additional $387,500 ($4,500,000 minus 20 percent of $16,250,000 = $1,250,000 versus the $437,500 actually excluded). For investment-grade customers with long clean payment histories, individual concentration carve-outs are a regular negotiation outcome.

4. Get Foreign AR Insured Before the Field Exam

An uninsured Canadian or European receivable goes to zero in the eligibility calculation. A receivable insured through Allianz Trade, Atradius, Coface, Marsh, or EXIM at typical premium levels of 20 to 60 basis points of insured sales is generally eligible at the same advance rate as domestic AR, subject to the insurance policy limits. This is one of the cheapest availability-recovery moves available.

5. File Assignment of Claims on Federal Receivables in Advance

Federal AR without an Assignment of Claims acknowledgment is ineligible. With the filing in place — 30 to 60 days of administrative lead time per contract — federal AR is fully eligible at typical advance rates. Government contractors planning ABL should build the assignment process into the contract lifecycle; our government contractor ABL article walks through the FAR 32.8 mechanics in detail.

6. Reduce the Dilution Number Itself

The dilution reserve formula is multiplicative on dilution percentage. Moving dilution from 7.5 percent to 6 percent on the example deal would shrink the dilution reserve from $427,500 to roughly $169,000 — a $258,500 availability lift, recurring monthly. Dilution drivers are operational: returns, chargebacks, rebates, early-pay discounts, warranty claims, and disputes. Many of these are policy choices that can be tightened. The reserves article covers the dilution reserve formulas in depth.

7. Obtain Landlord Waivers for Material Locations

The $1,500,000 landlord reserve in the example was the single largest deduction in the waterfall. A landlord waiver — a relatively standard form executed between the landlord and the lender giving the lender a window to remove collateral after a default — eliminates the reserve. The lender's counsel will produce the form; obtaining the landlord's signature is the borrower's problem. On a multi-location distribution business, this work can recover seven figures of availability before any operational change touches the AR aging.

How a Field Exam Will Re-Run This Math

Everything described above happens monthly on the borrower-prepared BBC. But the lender's field exam team — at ABLC or one of the other exam firms — re-runs the whole waterfall from raw data on a 6-to-12-month cycle. They pull the AR aging directly from the borrower's system, tag every ineligible category independently, recalculate cross-age, validate the contra and concentration math, and recompute dilution from a 12-month invoice-to-cash trace. Differences between the borrower's BBC and the field exam recomputation become "findings" — adjustments that often take immediate effect on availability. Our field exam findings article documents the typical cost stack; the seven-step pre-exam preparation playbook is in how to prepare for your first ABL field exam.

The borrowers who navigate field exams cleanly are the borrowers who have already run this math themselves, found the surprises in their own data, and either fixed them or pre-disclosed them. The borrowers who get hurt are the ones who let the field exam discover the cross-age problem, the contra problem, or the dilution problem for the first time.

What We Do at Don Clarke Enterprises

For every borrower we work with, we rebuild the borrowing base from raw AR data before any lender sees the deal. We run cross-age at the customer level under both methodologies, model concentration at the negotiated and default caps, surface contras and intercompany the borrower's controller may not have flagged, recompute dilution against a 12-month invoice-to-cash baseline, and price out the reserve stack the lender is likely to impose. The resulting availability number is the number the lender will actually fund against — not the optimistic Excel projection.

That diagnostic is the foundation of the credit memorandum we package for placement, covered in detail in our ABL credit package article and the asset based lending consultants role overview. It is also what makes the difference between a deal that places at full availability and a deal that loses $2M of working capital between term sheet and closing.

If you want to see the math run on your own AR aging — cross-age methodology applied at both 25 and 50 percent, concentration tested at standard and custom caps, dilution recomputed from your own trailing twelve months, reserves modeled against the deal structures we see in this market — call us at (954) 962-0099, email info@donclarkeenterprises.com, or submit the situation through the form below. We will return the projection inside 48 hours.