Unapplied cash: how to find and clear it, step by step

Unapplied cash is money you have received but not yet matched to an invoice. To clear it, find each payment with no invoice against it, get the remittance that came with it, match each line to an open invoice, and put anything that does not match on an exceptions list with an owner.

This matters beyond tidiness. Unapplied cash leaves the invoices it should have paid looking open, which can put a paying customer on a false credit hold or send them a past-due notice. This guide gives you a routine to clear it.

Why does cash end up unapplied?

Four common reasons, all visible in the remittance:

• No remittance arrived. A bank feed shows a deposit with no invoice numbers on it. In one r/Accounting thread, a client with 50 or more ACH and wire payments a day had exactly this problem.
• The remittance has no invoice numbers, only a PO number or a reference of the customer's own.
• The amount does not match anything. The customer short paid, overpaid or paid several invoices in one lump.
• The reference is wrong, for example a typo, an old invoice number or another entity's.

How do you clear unapplied cash?

1. List every unapplied payment, with its date, payer and amount. Your accounting system's unapplied or undeposited report is the usual source; the name varies by system.
2. Find the remittance for each. Search your inbox and the customer's portal. If there is none, ask the customer for it by email.
3. Match the lines. By invoice number, then PO number, then a unique amount for that customer.
4. Check the sum. The matched lines should add up to the payment. If they do not, a line is missing or a deduction was taken.
5. Apply what matches and write down what does not.
6. Chase the remainder and keep the list until it is empty.

How do you match a payment when there is no invoice number?

Use the PO number: find the open invoices that carry it. If there is no PO either, look for a single open invoice for that customer with exactly that amount. If two have it, do not guess. Ask the customer. Remit Match uses the same three passes and shows which one matched each line.

What about short pays and overpays?

• A short pay is paid less than open. The shortfall is the amount to explain: a discount, a deduction, a dispute or a mistake.
• An overpay is paid more than open. Hold it as a credit or send it back, according to your policy.

Both are cash you have received but cannot fully apply, so they sit in unapplied until someone decides. Put them on the exceptions list with the amount off, not just in someone's head. Remit Match lists exceptions across remittances with totals by type and lets you mark each resolved with a note.

How do you keep unapplied cash from building up again?

• Work remittances the day they arrive.
• Match before you post, so a bad reference is caught early.
• Review the exceptions list weekly.
• Keep a clean open-invoice export, since a stale one produces false "unmatched" lines.

Remit Match covers the reading and matching steps for remittance PDFs, Excel and CSV files. It reports differences, but posting to your ledger is still your step. For a step-by-step version of the matching itself, see the cash application process; if you use QuickBooks, see unapplied payments in QuickBooks.

What should go on the exceptions list?

Every payment you cannot fully apply today. For each one, record the payer, the payment date, the amount, the amount still unexplained, what you need to resolve it, and who is waiting on whom. A one-line note such as "asked customer for remittance on the 12th" is enough, but without it the same payment gets re-investigated by whoever opens the list next.

Review the list on a fixed day each week and drop anything resolved. An item that has sat for several weeks usually needs a different action: a call to the customer, or a decision from your controller about a credit or write-off.

What is the fastest first pass on a big backlog?

Sort the unapplied payments by amount, largest first, and start with payers who send a remittance every time. Those clear quickly and reduce the number of customers who might be chased wrongly. Leave the payments with no remittance and no PO for last, and send the customer requests for them in one batch.

FAQ

Is unapplied cash a liability?

How you record it depends on your accounting policy and system. Ask your accountant; this guide does not give accounting advice.

How long can cash stay unapplied?

There is no universal limit, but the longer it sits, the more likely a customer is chased for an invoice they have paid. Many teams aim to clear it the same day or week.

Can I clear unapplied cash without the remittance?

Sometimes, by PO or a unique amount, but you are guessing. Ask the customer when the match is not unique.