How to clear an unapplied cash backlog

What unapplied cash is

Unapplied cash is money you have received and deposited but not yet matched to the invoice, claim, or account it pays. In a business, it usually sits in an unapplied payments or customer deposits account. In a medical practice or hospital, it often shows up as unposted payer payments, unidentified deposits, or patient payments held in suspense.

Either way, the money is in the bank, but your receivables do not know it. That gap is the problem.

Why it builds up

Almost every backlog we have worked traces back to a handful of causes, usually several at once:

• Payments arrive without enough detail. An ACH with no reference, a check with no remittance slip, or a lockbox item whose image does not show which invoices it covers.
• Remittances and deposits do not line up. In healthcare, a payer’s electronic remittance advice (the 835) may arrive days before or after the matching deposit, or one deposit may cover several remittances.
• Partial payments, offsets, and recoupments. A customer short pays, or a payer takes back money from an old claim against a new payment, and the difference has nowhere obvious to go.
• Posting is a part-time job. When cash posting is squeezed in around other work, the hard items get set aside “for later,” and later never comes.
• Systems disagree. The billing system, the bank, and the general ledger each hold a different version of the truth, and nobody owns the reconciliation between them.

What it quietly costs you

Unapplied cash rarely shows up as a crisis, which is why it grows. But it causes real damage:

• Your aging is wrong. Invoices and claims that have been paid still look open, so receivables and days in AR are overstated.
• You chase customers who already paid. Collection calls and statements go to people whose money you are holding. In healthcare, that can mean billing patients for balances their insurer already covered.
• Month-end close takes longer. Someone has to explain the unapplied balance every month, and the explanation gets harder as it ages.
• Old items get harder to resolve. Remittance detail is easier to find in the first weeks. After that, research takes longer, and some unresolved balances can eventually become a refund or unclaimed property question rather than a posting one.

How to clear it, step by step

1. Take a baseline before you touch anything

Pull the full list of unapplied items with the date received, amount, payer or customer, and payment method. Total it, count it, and age it by when the money arrived. This is your starting point, and it is how you will prove progress later.

2. Sort by why each item is stuck

Group the items by cause, not by size: no remittance detail, remittance without a deposit, partial or short payment, recoupment or offset, duplicate, or misposted to the wrong account. Each group has its own fix, and sorting this way usually shows that one or two causes explain most of the backlog.

3. Clear the easy matches first

Match items where the amount, date, and payer or customer line up exactly. In healthcare, the check or EFT trace number on the 835 is the most reliable link between a remittance and a deposit. Clearing the easy items quickly shrinks the list and frees time for the harder ones.

4. Research the rest, oldest and largest first

For items without detail, go to the source: lockbox images, bank detail, payer portals, or the customer. Set a time limit for each item, and when research runs out, escalate it with a written reason rather than leaving it in the queue.

5. Give every item an owner and a decision

Each remaining item should end in one of a few outcomes: applied, refunded, transferred to the right account, or held with a documented reason and a review date. Write-offs, refunds, and credits should need sign-off from someone with authority. A cleanup is finished when every item has an owner and a status, not when the balance happens to look smaller.

6. Fix the causes so it does not come back

This is the step most cleanups skip. Write down the daily posting procedure, reconcile deposits to remittances every day rather than every month, and decide in advance who handles each type of exception. Ask customers and payers for remittance detail where it is missing.

7. Measure it every week

Track a few numbers weekly: unapplied dollars, number of items, the age of the oldest item, and the share of items with an owner. If those numbers start creeping up again, you will see it within a week instead of at year-end.

How long it takes

It depends on the volume and how old the items are. A few hundred recent items can often be cleared in a couple of weeks. Thousands of items, or items that are many months old, take longer, because research is the slow part. What matters more than speed is ending with written procedures, so the same backlog does not rebuild.

When to bring in help

Most teams can keep up with daily posting. Where they struggle is clearing a large, old backlog on top of the daily work. If your unapplied balance has grown for several months in a row, if it is holding up close, or if your team is calling customers who have already paid, a focused cleanup is usually cheaper than hiring to catch up.

That is the work we do: a fixed-fee sprint inside your own systems, with every write-off approved by you and written procedures at the end.