A customer's ACH lands in the bank on Tuesday for $18,420, the email explaining which invoices it pays arrives on Wednesday, and until someone puts the two together your receivables report still shows fourteen invoices as overdue. The cash application process is how that gap gets closed, with each incoming payment matched to the invoices it pays and recorded in the ledger.
This guide walks through the steps in order, follows one payment from deposit to posted, and covers where the process usually stalls and which numbers tell you it's healthy. It's written for a finance team on a cloud ledger such as QuickBooks Online or Xero, though the steps are the same on any system.
What cash application is
Cash application is the part of accounts receivable that matches a customer's payment to the open invoices it's meant to settle, and then records (applies) that payment against those invoices. You'll also hear it called payment application, cash posting, or remittance matching, and on a small team it's often just "allocating receipts".
Two events are involved and they rarely happen together. The money arrives, by check, ACH, wire or card, and then the money is applied, so the invoices are marked paid and the customer's balance comes down. The document that connects them is the remittance advice, the customer's note listing which invoices a payment covers and any amounts they've held back. It might be a PDF attachment, the body of an email, a check stub, a spreadsheet or a download from the customer's supplier portal. Our guide to payment advices, check remittances, ACH and EDI 820 covers the forms it takes.
The cash application process in six steps
- Receive the payment. A deposit appears on the bank feed or a check arrives in the mail. Note the amount, the date and the payer reference, which is often a shortened company name and a number that means little without the remittance.
- Find the remittance. Look for the advice that explains the payment in the AR mailbox, the envelope, or the customer's portal. It often arrives a day or two either side of the money and sometimes goes to a different person.
- Read the lines. Pull each invoice number and amount off the remittance, along with any credit memos taken and any deductions. A fourteen-line advice is fourteen lookups, and the customer's version of your invoice number rarely matches your formatting exactly.
- Match each line to an open invoice. Find every invoice in the ledger and confirm the customer, the amount and the open balance. This is where a dropped prefix, a purchase order quoted in place of an invoice number, or an invoice that's already been paid shows up.
- Resolve the exceptions. Decide what to do with anything that doesn't settle cleanly: a short payment, a deduction for damaged goods, a credit memo netted off, an overpayment, or a line you can't identify.
- Post and reconcile. Record the payment against the matched invoices, then tie the total to the deposit in the bank so the reconciliation balances.
Steps one and six take seconds. Almost all of the time goes on two to five, and it grows with the number of lines on the remittance, not with the number of payments.
A worked example: one ACH, fourteen invoices
The figures here are illustrative. A distributor receives an ACH for $18,420 from a customer. The remittance emailed the next morning lists fourteen invoices totaling $18,550, with $130 deducted from one of them for a damaged pallet.
Thirteen invoices are paid in full and one is short by $130. In QuickBooks Online that's a single Receive Payment for the customer with fourteen invoices ticked and the short one edited down, and in Xero you tick the fourteen invoices against the one line on the bank feed in Find & Match and adjust the short one. Behind the screen the entry is the same in both: debit the bank (or Undeposited Funds, if you group deposits in QuickBooks) for $18,420 and credit accounts receivable for $18,420.
The $130 stays open on the invoice until someone decides what it is. If the claim is valid you issue a credit memo and apply it, which closes the invoice, and if it isn't you leave the balance open and ask the customer for it. Our guide to short-paid invoices in QuickBooks Online covers both routes.
If the payment had been recorded against the customer with no invoices selected, the bank would still agree and the customer's total balance would still be right, and all fourteen invoices would keep aging. That's unapplied cash, and it's why a customer who paid on time still gets a reminder.
Where the process breaks
- The remittance and the money arrive separately. The deposit sits unexplained until the advice turns up, or the advice sits in an inbox for a payment that hasn't cleared yet.
- There's no remittance at all. The only clue is the bank reference, so someone matches on amount and emails the customer to confirm.
- One payment covers several customer accounts. A head office pays for its branches in a single transfer, and the payment has to be split across the accounts they're billed under. We covered that case in one payment, several customer accounts.
- Checks are deposited as a batch. The bank shows one deposit for twenty checks, each with its own stub.
- Deductions come without a reason. The payment is short and the remittance doesn't say why, so the invoice can't be closed or chased with any confidence.
When any of these pile up, payments get recorded on account to keep the bank reconciled, and the unapplied balance grows. If that's where you are today, start with our guide to applying an unapplied payment in QuickBooks Online.
The numbers that tell you it's working
- Unapplied cash. The total value of payments received and not yet matched to invoices. A small figure that clears within a day or two is normal, and one that grows week on week means application is falling behind collection.
- Days sales outstanding (DSO). Slow application inflates DSO even when customers pay on time. A payment received on day 30 and applied on day 36 adds six days of receivables that were never really outstanding.
- Match rate. The share of remittance lines that match an open invoice without a person untangling them.
- Exception rate. The share of payments that need manual handling. This is the number that sets the workload.
To see why, take 600 payments a month with 85 percent matching cleanly and the other 90 taking twelve minutes each. That's 18 hours a month spent on the awkward 15 percent. At a 99 percent match rate there are six exceptions and a little over an hour of work.
Manual and automated cash application
Done by hand, a person carries out steps two to five for every payment: opening the remittance, keying or copying invoice numbers, searching the ledger, and working out the differences. Automation takes over the reading and the matching and leaves the decisions to people.
Enterprise cash application suites were built for ERP systems such as SAP, Oracle and NetSuite, and they come with an implementation project to match. A team on a cloud ledger needs the same matching against the ledger it already has. RemitClear reads the remittance, whether it's a PDF, a spreadsheet, an email or a check scan, matches every line to your open invoices in QuickBooks Online or Xero, and posts the payment, with exact matches able to post without review and anything unusual held for a person to check. The category view is on our cash application software page, and our comparison of cash application tools covers the options by ledger.
When to stop doing it by hand
Manual application works for a long time, and the sign that you've outgrown it is usually a few trends arriving together.
- Unapplied cash is creeping up. Payments sit unmatched for days because the busy period no longer ends.
- Month-end is slipping. The close waits on the same pile of unallocated payments every month.
- One person owns all the matching. When they're out, application stops, and nobody else knows how the big customers' remittances map to invoices.
- Your biggest customers send the longest remittances. The accounts that bring in the most revenue pay fifty invoices at a time with deductions, and they take the most hours.
When those line up, the step to automate is the matching, because that's where the hours are. Collections, credit control and the bank reconciliation can stay as they are.
