RemitClear

How-To

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

How to apply a remittance advice across multiple invoices in QuickBooks Online with Receive Payment, whether it can be automated, and how to avoid unapplied cash.

By RemitClear8 min read

One customer payment can settle a dozen open invoices at once, and QuickBooks Online lands it in a single screen: Receive Payment. You enter the total received, tick the invoices the payment clears, and the running balance falls to zero as you go. For a handful of invoices that's a minute's work, and your job is only to land the amount on exactly the right ones. The clean case is genuinely that simple. The messy reality a remittance usually brings is where the care goes.

This is the receiving side of the desk. If you're looking for how to send a remittance to your own vendors, that's a different job, covered in how to send a remittance advice in QuickBooks Online. Here we're 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

Remittances are rarely clean, and the Payment column on the right of each invoice line is what lets you land less than the full balance on an invoice. Doing that correctly, and deciding what the shortfall actually is, is covered in how to apply a partial payment to an invoice in QuickBooks Online.

Credit memos and overpayments

A remittance that nets off a credit needs that credit applied to the invoices the advice names before the cash lands, and an overpayment does the reverse, leaving a surplus credit on the customer's account. The credit side, including the setting that applies credits for you and why it causes trouble, is covered in how to apply a credit memo to an invoice in QuickBooks Online.

Undeposited Funds and matching the bank deposit

One customer payment often reaches your bank inside a larger lump sum, so receiving each payment into Undeposited Funds and then grouping them onto a single Bank Deposit is what keeps your bank feed matchable. The full account, how to find the balance and how to clear it, is covered in how to clear undeposited funds in QuickBooks Online.

The trap: unapplied cash

A payment recorded but never applied to specific invoices does not disappear: it sits as unapplied cash, overstating your receivables aging while QuickBooks reports it as Unapplied Cash Payment Income on a cash basis. Finding and clearing those is covered in how to apply an unapplied payment in QuickBooks Online.

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 every two weeks by a national grocery group. The remittance arrives as a spreadsheet running several pages and close to two hundred invoices, a couple knocked down for a short delivery, one reduced 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's most of an afternoon, every two weeks, and it's pure transcription.

Can you apply remittance advice to invoices automatically in QuickBooks Online?

Not with QuickBooks Online on its own. Receive Payment is a manual screen, and there is no native setting that reads a remittance advice and applies the payment across the invoices it names. The automation has to come from an app working on the receiving side. RemitClear reads the remittance advice as it arrives, whether it is a PDF, a spreadsheet, a CSV or the body of an email, extracts every invoice number and amount, matches them against the open invoices in your QuickBooks Online company, and creates the Receive Payment transactions once you approve the allocations, posting one payment per customer applied across every invoice that payment covers. Short payments, rebate deductions and credit memos are surfaced for a decision rather than guessed at, so a two-hundred-line document becomes a quick review instead of a box-ticking afternoon.

That's 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.

Which apps actually do this, and why most QuickBooks remittance apps do not

Search for a QuickBooks remittance app and nearly everything you find solves the opposite problem. This is the single most confusing thing about the category, and it is worth stating plainly before you evaluate anything.

Remittance advice in QuickBooks Online means two different jobs depending on which side of the transaction you are on. On the accounts payable side, you are paying a supplier and sending them a document listing what you paid; QuickBooks Bill Pay does this natively by attaching a remittance advice to the payment email, and most third-party apps with "remittance" in the name are built for this. On the accounts receivable side, a customer has paid you one lump sum and sent you a remittance listing the invoices it covers, and you have to apply that money across your open invoices. Those are different products. An app that sends remittance advice to your vendors will not apply a customer payment to your invoices, and QuickBooks Online has no built-in automation for the receiving side: Receive Payment is a manual screen.

So if you are a bookkeeper looking for the second thing, the category to search for is cash application or remittance matching, not remittance advice. What that kind of tool does is read the remittance your customer sent, whether it arrives as a PDF, a spreadsheet, a CSV or the body of an email, extract every invoice number and amount, match those against the open invoices in your client's QuickBooks Online file, and prepare the Receive Payment allocations for you to approve. The manual steps in this article do not change; the transcription does.

  • Sending remittance advice to vendors (AP). QuickBooks Bill Pay natively, plus various add-ons. Not what you need here.
  • Receiving and applying customer remittances (AR). Cash application and remittance matching tools. This is the job in this article.
  • Batch deposits and bank feed matching. Handled inside QuickBooks Online with Undeposited Funds and Find Match, covered above. A cash application tool feeds this rather than replacing it.

For bookkeepers running several client files, the thing worth checking is whether a tool works across multiple QuickBooks Online companies from one login, because the volume problem is rarely in one client file, it is spread thinly across many. RemitClear does the receiving side for QuickBooks Online and is built for exactly that multi-file case.

Summary

The mistake that quietly corrupts the books here is trusting the default. Enter an amount without ticking the invoices the remittance names, and QuickBooks applies it oldest-first, so your ledger and the customer's advice drift apart one line at a time. The second mistake is receiving the cash now and promising to apply it later, which only parks the same work in unapplied cash for a future you with less context. Tick the exact invoices, route everything through Undeposited Funds, and apply while the remittance is still in front of you. Past a couple of hundred lines every two weeks, reading it for you stops being a nicety.

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