How to match one payment that covers several invoices

To match one payment that covers several invoices, get the customer's remittance advice and record the payment against exactly the invoices it lists, in your accounting software, so the total equals the bank line. Without a remittance, look for invoices that add up to the amount, then ask the customer before you allocate anything, because more than one combination often fits.

In this article

The short version

• Ask for the remittance advice and allocate the payment to exactly the invoices it lists.
• Without one, more than one combination of invoices can add up to the same amount.
• Allocate oldest first only if the customer doesn't reply, and note it on the payment.
• In Xero use Find & Match; in QuickBooks use Receive payment and tick each invoice.
• Apply credit notes first and record any shortfall as a part payment.

Why a bulk payment is hard to match

Customers with several open invoices often pay them together. Larger businesses do it on every payment run, and smaller ones clear a few invoices at once when cash comes in. What reaches your bank is one line: an amount, a date and a reference that might be your invoice number, their own supplier code or nothing useful at all.

Your accounting software can usually suggest a match when a payment equals one invoice. When it equals three of them, or two and part of a third, it has nothing to go on. The bank line then sits unreconciled, the invoices stay open, and the customer may get a reminder for something they've paid.

How to work out which invoices it covers

The remittance advice is the answer. It's the note a customer's accounts team sends, or makes available in their supplier portal, listing which invoices a payment covers and anything they've deducted. Many large customers send one automatically to whatever email address is on your supplier record, so check that address is one somebody reads.

Without a remittance, you're reduced to arithmetic, and arithmetic can mislead. Here's an example. A customer has five open invoices, oldest first: £1,200, £850, £2,350, £1,310 and £460. A payment of £4,860 arrives with no reference.

Two exact combinations fit, and the oldest-first approach gives a third answer that leaves a part-paid invoice. If you guess wrong, your aged debtors will be wrong, and so will your next reminder. Before allocating, email the customer's accounts team with the amount and date, and ask which invoices it covers. If they don't reply and you need to close the month, oldest first is the usual convention, with a note on the payment so you can move it later.

A statement makes this easier from the start. When you send a customer a statement of everything they owe, their accounts team tends to pay against it, often quoting the invoices in the reference.

How to record it in Xero or QuickBooks

In both systems you record one payment and tick each invoice it covers, so the payment total matches the bank line exactly.

In Xero, open the bank statement line, choose Find & Match, and tick each invoice the payment covers until the selected total equals the line. If the payment only partly covers one invoice, you can record a part payment against it during reconciliation. Small differences such as a bank fee go in as an adjustment.

In QuickBooks, use Receive payment for that customer, tick each invoice in the Outstanding Transactions list, and check the amount received equals the bank line. Then match that one payment to the line in the bank feed. Recording it as one payment, instead of several separate ones, keeps your bank register looking like your bank statement.

Bulk payments rarely add up perfectly, and the gap usually has one of a few causes:

• the customer has taken a credit note off the total, so you should apply the credit note to its invoice before matching;
• they've held back one invoice they're querying and paid the rest;
• they've deducted a discount, a retention or bank charges;
• one invoice is short-paid, which you record as a part payment and leave the balance open.

Ask before you write anything off. A gap that looks like a disputed invoice can turn out to be a credit note you raised and forgot about, and the reverse happens too.

How to get payments that arrive already matched

Most of the effort above comes from the payment and the invoices arriving separately. Adfin's statements let a customer pay several invoices in one payment through a single link, so the payment is recorded against the invoices they chose, and those invoices show as paid in Xero or QuickBooks.

For customers who'll only pay by bank transfer, Adfin gives each one unique bank details in your business's name. A payment to those details is matched by reference to an invoice number first, then by amount, and otherwise goes against the most overdue invoices. If it's short, Adfin records a part payment against the invoice. Adfin's collection agents then follow up any balance left open, within rules you approve, so a customer isn't chased for invoices they've already paid.

Related guides

• How to match a bulk payout to individual invoices
• What do you do when a client pays less than the invoice?
• Why is my aged debtor report wrong?
• How do I match bank payments to recruitment invoices automatically?
• Payment reconciliation: a complete guide

Common questions

What is a remittance advice? It's a note from your customer listing which invoices a payment covers and any deductions. Large customers often send one automatically after each payment run.

What if a customer won't send a remittance? Allocate the payment oldest first and add a note to it, so you can move it if the customer later tells you otherwise.

Can Xero match one bank line to several invoices? Yes. Use Find & Match and tick each invoice the payment covers until the selected total equals the bank line.

How do I record one payment for several invoices in QuickBooks? Use Receive payment for the customer, tick each invoice it covers, then match that payment to the bank feed line.

What if the payment is less than the invoices it covers? Apply any credit notes first, then record what's left as a part payment and leave the balance open. Ask the customer what the difference relates to.

Should I allocate a bulk payment to the oldest invoices first? It's the usual convention when the customer hasn't told you otherwise. Ask first if more than one combination of invoices fits the amount.

Sources

• Xero Central - Find transactions to match to bank statement lines (accurate as of November 2026) https://central.xero.com/0/article/Reconcile-a-bank-statement-line-using-Find-Match
• Intuit QuickBooks UK - Record invoice payments in QuickBooks Online (accurate as of November 2026) https://quickbooks.intuit.com/learn-support/en-uk/help-article/invoicing/record-invoice-payments-quickbooks-online/L4ZadDW7F_GB_en_GB
• Adfin Help Centre - An introduction to Adfin bank transfers (accurate as of November 2026) https://support.adfin.com/en/articles/12600901-an-introduction-to-adfin-bank-transfers