Unapplied cash: the reconciliation gap that reduces your borrowing base

It feels unfair: the customer paid, the money is in the bank, and the lender reduces your borrowing base anyway. But look at it from the collateral side. If $650,000 of payments have not been applied to invoices, then $650,000 of invoices on your aging are shown as open when they are actually paid. The lender would be advancing against receivables that no longer exist. The deduction is not punishing the collection, it is correcting the ledger.

Unapplied cash also poisons every downstream test. Paid invoices that stay open keep aging, so they drift into the over 90 bucket, inflate the aged ineligibles line, and can push customers over the cross-aging threshold. A borrower with a cash application backlog gets hit twice: once by the deduction and again by phantom aging.

Most agreements deduct the full balance of unapplied and unidentified receipts as of the report date. Some sweep it into a general reserves line; the math is the same. Here is a certificate slice showing both the direct deduction and the phantom aging effect.

The direct deduction costs $654,500 of availability at an 85 percent advance rate. The $240,000 of paid but unapplied invoices sitting in the over 90 bucket costs another $204,000 as aged ineligibles, even though that money was collected weeks ago. Clearing the application backlog would recover roughly $850,000 of availability without a single new sale.

You need the open amount and invoice date of every AR item, plus the receipt records: payment date, payer, amount, and whatever remittance reference came with the cash. The breakage is structural. Customers pay with short remittance advice, take unauthorized deductions that stop auto matching, pay multiple invoices with one wire, or pay from a parent entity whose name matches nothing in the customer master. Each failure leaves a receipt on account and an invoice that looks unpaid.

The reporting failure is subtler: unapplied cash often hides as negative rows inside the aging rather than as a separate line. A certificate built by summing the aging nets those credits into the buckets, which understates both gross AR and the required deduction, and lenders who spot netted agings start asking for the full open item detail.

• Unapplied and unidentified receipts are identified from the open item detail deterministically, including credits netted inside aging buckets, and deducted the way the facility defines.
• Treatment is configured per facility: a direct deduction line, a reserve, or netting against specific obligor balances where the agreement allows it.
• Every deducted receipt traces to its source row, payment date, and payer, so the deduction reconciles to the cash book.
• Aging is flagged where unapplied cash is inflating buckets, so you can see the availability that cash application work would recover.