RemitClear

How-To

How to Apply a Customer Payment to Multiple Invoices in QuickBooks Online

How to apply one customer payment across multiple invoices in QuickBooks Online with Receive Payment, plus short payments, credit memos, and unapplied cash.

By RemitClear8 min read

One payment, many invoices. A customer pays a single amount that settles a dozen invoices at once, and your job is to land that one payment on exactly the right invoices in QuickBooks Online. The tool for it is Receive Payment, and for a handful of invoices it is quick. This guide covers the clean case first, then the messy reality a remittance usually brings: short payments, deductions, credit memos, the deposit, and the payment you forget to apply.

This is the receiving side of the desk. If you are looking for how to send a remittance to your own vendors, that is a different job, covered in how to send a remittance advice in QuickBooks Online. Here we are the supplier, and the money has just arrived.

The job: applying one payment across many invoices

When a customer pays you, the payment rarely matches a single invoice. They run their accounts payable, batch everything they owe you, and send one amount with a remittance listing the invoices it covers. Applying that payment to the right open invoices, so each one is marked paid for the correct amount, is called cash application. In QuickBooks Online it happens in one screen: Receive Payment.

The clean case, step by step

Start with the simplest version: the customer paid every invoice in full, and the total matches.

  1. Open Receive Payment. Select + New, then Receive payment.
  2. Choose the customer. Pick the customer from the dropdown. QuickBooks Online lists all their open invoices in the Outstanding Transactions section.
  3. Enter the amount received. Type the total the customer paid into the Amount received field.
  4. Select the invoices. Check the box next to each invoice the payment covers. QuickBooks distributes the amount across the ones you tick, and the running total at the bottom should land on zero to apply.
  5. Set the deposit account. Use Deposit to, and choose the bank account the money landed in, or Undeposited Funds (shown in newer QuickBooks Online as Payments to deposit) if this payment will be part of a larger bank deposit. More on that below.
  6. Save. Select Save and close. Every selected invoice is now marked paid.

By default QuickBooks Online applies a payment to the oldest invoices first, so if you enter an amount without ticking specific invoices it works down from the top. When a remittance names exact invoices, tick those rather than relying on the order, so your books match the customer's advice line for line.

When the amounts do not line up: short payments and deductions

Real remittances are rarely clean. A customer short-pays an invoice by a few dollars for damaged stock, withholds a retention, or nets off a rebate. QuickBooks Online lets you control how much of the payment lands on each invoice through the Payment column on the right of each line.

  • Partial payment. Enter less than the full balance in the Payment column for that invoice. QuickBooks marks the invoice Partial and leaves the remaining balance open, so it still shows on the aging until the rest arrives.
  • A deduction you will not collect. If the short-paid difference is a deduction you are accepting, QuickBooks Online has no native deduction-coding step inside Receive Payment. You apply what was actually paid, then handle the difference separately, usually with a credit memo or a write-off to the right account, so the invoice can close cleanly.

This is the part that does not automate itself, because coding a deduction is an accounting decision, not a matching one. The clean lines can be matched in bulk; the deduction lines need a person to say what they are.

Credit memos and overpayments

If the customer's remittance applies a credit, you want that credit to reduce what they owe before the payment lands. QuickBooks Online can do this automatically: with Automatically apply credits switched on in Account and settings, open credit memos for a customer apply to their oldest open invoices. With it off, you apply credit memos by hand in Receive Payment, ticking the credit alongside the invoices.

The reverse case is an overpayment. If the Amount received is more than the invoices you apply it to, QuickBooks Online holds the surplus as a credit on the customer's account, which you can apply to a future invoice. Either way, the number to watch is the running balance at the bottom of Receive Payment: it tells you whether the payment has been fully accounted for.

Undeposited Funds and matching the bank deposit

Here is the detail that confuses most people the first time. The money on a customer's remittance often arrives in your bank as one lump even though it pays many invoices, and sometimes one bank deposit covers several separate customer payments. If you receive each payment straight to the bank account, your bank feed shows one deposit and QuickBooks shows several payments, and they will not match.

The fix is Undeposited Funds, shown in newer QuickBooks Online as Payments to deposit. Receive each payment into that holding account rather than the bank, then use + New, then Bank deposit, to group the payments that landed together into a single deposit. That deposit now matches the one line on your bank feed, and reconciliation stays clean. Use the bank account directly only when a payment truly lands on its own.

The trap: unapplied cash

A customer payment that is recorded but never applied to specific invoices does not disappear. It sits in unapplied cash, and QuickBooks Online reports it as Unapplied Cash Payment Income on a cash-basis profit and loss. Your accounts receivable aging overstates what is owed, your income looks inflated, and collections may chase invoices that are already paid.

This is what happens when a payment is taken in but the matching is deferred: someone receives the cash to get it off the bank feed, intends to apply it later, and later never comes. Clearing unapplied cash is the same line-by-line work you skipped, done weeks afterward with less context. The cheapest time to apply a payment correctly is when it arrives, with the remittance in front of you.

Where it breaks: volume

For a payment against two or three invoices, Receive Payment is a minute of work. The trouble is volume and length. Consider a wholesale distributor paid once a fortnight by a national grocery chain. The remittance runs to several pages and close to two hundred invoices, a handful short-paid for damaged stock, one offset by a promotional rebate. Every one of those lines has to be found in Outstanding Transactions, ticked, and amount-checked against the advice, and the deductions coded on the side, before the single deposit will reconcile. That is most of an afternoon, every fortnight, and it is pure transcription.

This is the half worth automating. Extraction reads every invoice line off the incoming remittance, matches each one against your open invoices in QuickBooks Online, handles the short-payments and offsets, and lets you review the allocations before they post, so a two-hundred-line remittance becomes a quick check rather than an afternoon of ticking boxes. That is the job RemitClear's cash application for QuickBooks Online is built for. For the platform-agnostic view, see our overview of cash application automation software.

Summary

Applying one customer payment across multiple invoices in QuickBooks Online is Receive Payment: choose the customer, enter the amount received, tick the invoices the remittance names, and pick the deposit account. Use the Payment column for short payments and deductions, let credit memos apply before the payment lands, and route payments through Undeposited Funds when one bank deposit covers several of them. Above all, apply the payment when it arrives, because the alternative is unapplied cash and an aging report you cannot trust.

None of this is hard at a handful of invoices. It only becomes a problem at volume, when a single remittance runs to dozens or hundreds of lines and the ticking has to happen every week. That is the point where reading the remittance for you, and matching it automatically, stops being a nicety and becomes the difference between a quick review and a lost afternoon.

Apply Every Customer Payment in Seconds

One payment, a dozen invoices, zero manual matching. RemitClear reads the remittance and applies the cash across the right invoices in QuickBooks Online. Book a demo and see it on your own remittances.

Read verified RemitClear reviews on G2