How unapplied cash inflates DSO and distorts the picture leadership uses to manage cash?
In Issue 31 I mentioned that readers had sent in topics for future issues, and this one takes on one of the first of them. swapna parigi suggested unapplied cash, a problem every order to cash team recognizes and most leadership teams rarely see.
It also connects to recent issues. Issue 28 argued that process debt and data debt sit in places like order to cash and customer master data, and Issue 31 asked whether finance functions are ready for AI or simply buying AI tools. Unapplied cash is where both show up on the balance sheet.
What Is Unapplied Cash?
Unapplied cash is money your customer has paid and your bank has received but that has not yet been matched to the invoices it was meant to settle. While the cash sits in the bank, the invoices stay open in the ledger and the customer looks late until someone connects the payment to the right items.
A small, steady balance is normal, but a balance that grows or ages is a signal that something upstream needs attention.
Why It Builds Up
In my experience most of the balance traces back to four sources.
The most common is a remittance gap, where the payment arrives without the detail needed to match it. The remittance advice may land in a personal inbox or a separate email, if it arrives at all, and the payer name on the bank file often does not match the customer master.
Short pays and deductions come next. When a customer pays less than the invoice amount without a reason code or backup, the cash cannot be applied cleanly and the whole payment tends to wait. Issue 27 covered how tariff-related deductions are adding another layer to this work.
Lockbox and portal payments create their own gaps, because lockbox capture can only read what is in the envelope and payables portals keep remittance detail inside the portal until someone logs in to download it.
The fourth source is common in PE-backed companies built through acquisition, where multiple ERPs and legal entities mean a customer may pay one entity for invoices raised by another, so the cash lands in one bank account while the open items sit in a different ledger.
It Distorts DSO, Forecasts and Collections
When invoices stay open after they have been paid, receivables are overstated and DSO looks worse than it is. Some companies net unapplied cash against AR at month end, which can make headline DSO look fine while the customer-level aging underneath is still wrong, and the customer level is where collections decisions get made.
The cash forecast suffers in the same way. A forecast built on open AR expects receipts from invoices that were already paid, and any model of customer payment behavior learns from the wrong dates. Collectors end up calling customers who have already paid, which strains the relationship and pushes the accounts that are past due further down the list.
For PE-backed companies the stakes are higher. Working capital is often a named lever in the value creation plan, and lenders, diligence teams and eventual buyers will look at the quality of receivables. An unexplained unapplied balance invites questions you would rather answer before anyone asks them.
Five Fixes to Start With
The first fix is capturing remittance at the source. Set up one shared remittance inbox, ask your largest customers to send structured remittance with every payment, and pull portal remittance on a fixed schedule.
Second, document the matching rules your best cash application specialist carries in their head, including reference formats and tolerances for small differences, and build them into the system so they no longer depend on one person.
Third, triage deductions separately. Apply what can be applied and route the short-paid amount, with a reason code, to the team that can resolve it so one disputed line does not hold up the entire payment.
Fourth, give every unapplied item an owner and an aging SLA, with an escalation point when the deadline is missed and a weekly review of anything past the threshold.
Fifth, measure it. I would put unapplied cash as a percentage of receipts on every O2C dashboard, tracked weekly and by entity, alongside days to apply, which runs from the date cash hits the bank to the date it is applied to an invoice.
Where AI Helps
Cash application is a good candidate for automation because volumes are high and many decisions follow rules. Current tools can read remittance from emails and PDFs, suggest matches when a reference is incomplete and learn how individual customers pay, which frees your team to spend its time on the exceptions.
The lesson from Issues 28 through 31 still applies, though. An AI tool cannot match cash to a customer that exists three times in your customer master or apply a payment to an invoice in an ERP it has no connection to, and it has no basis for judging a deduction if nobody has defined what a valid one looks like. Clean master data, documented matching rules and clear ownership need to come first, along with a baseline for both KPIs, so that automation has a working process to accelerate and you can prove it changed a result.
Why It Matters
Cash application sits underneath almost every working capital result a finance team wants to deliver, because you cannot collect well on receivables you cannot see clearly, and every day a payment sits unapplied is a day your DSO, your forecast and your collectors are working from the wrong picture.
Where to Start This Week
Pull your unapplied cash balance by entity, age it and look at the ten largest items to understand why each one is still unapplied. The answers will tell you where the problem sits and where to start.
Thank you, Swapna, for the suggestion. The other reader topics, including B2B collections and cash forecasting, are still on the list, so if there is something you want covered, reply and tell me.
If you want to see how much cash is tied up in your own order to cash process, start with the Clear Cycle Advisors Liquidity Diagnostic, a self-assessment that comes with the option of a consult to walk through the results. Book 30 minutes with me directly at calendly.com/ian-thompson-clearcycleadvisors