How to Match One Payment to Multiple Invoices in Xero

One credit lands in your bank feed and you know it pays more than one invoice. Maybe a customer settled a dozen at once, maybe you never got a remittance advice at all and you are working backwards from the amount. This guide covers the pure Xero mechanics: applying a single receipt across many invoices with Find and Match, splitting part-payments, handling a deposit that does not equal the invoice total, and the tie-out rule Xero will not let you break. It also covers the reverse, when several receipts chip away at one invoice.

The distinction that matters here is that you are starting from the money, not the paperwork. If a remittance advice did arrive with the payment and you want the document-led version of this workflow, see our walkthrough on how to reconcile a remittance advice in Xero instead. This post assumes the receipt is all you have to go on.

The situation: one deposit, several invoices

A single bank credit covering multiple invoices is the normal shape of B2B receipts. A customer runs a payment batch on the 30th and one transfer clears every invoice they owe you that month. Xero shows you one line on the bank feed with one total. Your job is to tell Xero which open invoices that total settles, and in what amounts, so each invoice is marked paid and the bank line reconciles.

You do not need a remittance advice to do this. You do need to know, or be able to work out, which invoices the amount covers. If the deposit is a round A$12,480 and you have three open invoices for that customer totalling exactly A$12,480, the arithmetic answers itself. If it does not add up cleanly, the difference is the interesting part, and it is covered further down.

Applying one payment across multiple invoices with Find and Match

Find and Match is the tool for this. It lives on the bank reconciliation screen, not on the individual invoices, which is the point people miss when they try to receive a payment on each invoice one at a time and then cannot get the bank line to clear.

1. Open the Reconcile screen for the bank account the money landed in. Go to Accounting, then Bank accounts, then Reconcile on the correct account.
2. Find the deposit line in the feed and click Find and Match on it (the option sits under the suggested match on the right of the statement line).
3. Tick every invoice the payment covers. Search by customer name, invoice number, or amount to bring the right ones into view, then tick each one. Xero keeps a running total of what you have selected against the value of the bank line.
4. Watch the running total. When the selected invoices add up to the exact value of the deposit, the Reconcile button becomes available. Click it and the whole set is applied and reconciled in one action.

That is the clean case: the ticked invoices equal the deposit to the cent, and you are done. Xero creates a payment against each invoice, all tied to the one bank statement line, so the feed stays tidy. The friction only starts when the numbers do not line up, which on real receipts is often.

When the deposit does not equal the invoice total

Three versions of this come up, and Xero handles each differently. In all of them the constraint is the same: the amounts you allocate have to end up equal to the bank line before Xero will reconcile it.

Short-pays and part-payments. The customer paid an invoice partially, or netted off a deduction, so the deposit is less than the invoices you ticked. Use the Split link next to the invoice inside Find and Match. It lets you allocate only part of that invoice's balance to this receipt, leaving the rest outstanding. The invoice stays in Awaiting Payment showing the remaining balance, and the deposit now ties out. Split is the single most useful control on this screen and the one most people never notice.

Small unexplained differences. A few dollars of bank charges on an international transfer, or a rounding difference, do not warrant a credit note. Use the Adjustments dropdown inside Find and Match to post a Bank Fee, coded to an account you nominate, or a Minor Adjustment, which Xero writes off to its own rounding account. Either one closes the difference without distorting the invoice.

Over-payments and unallocated remainders. The deposit is larger than the invoices you can account for. Do not force it with a fake adjustment. Allocate the invoices you can identify, then record the surplus as a customer overpayment, which Xero holds as a credit against that customer to apply to a future invoice. If the whole deposit is a prepayment against nothing yet invoiced, treat it as a prepayment rather than trying to match it to invoices that do not exist.

The reverse case: matching multiple payments to one invoice

The opposite problem is just as common. A customer pays a large invoice in instalments, or a single invoice gets settled by two or three separate transfers across a fortnight. Here you have several bank lines and one invoice, and you want each receipt to chip away at the balance until it is cleared.

The mechanics are the mirror image of the above. For each deposit, open Find and Match, tick the same invoice, and use Split to allocate only the portion this receipt pays. Reconcile that line. The invoice stays in Awaiting Payment with its balance reduced by each part-payment, and it closes automatically when the final receipt brings the balance to zero. You are not editing the invoice each time, you are recording a part-payment against it from each bank line separately.

One caution: because each receipt is reconciled independently, it is easy to lose track of how much of the invoice is still owed, especially across a month boundary. Check the invoice's remaining balance before you allocate each new receipt so you do not over-apply and accidentally create an overpayment credit.

Where doing this by hand stops paying off

Find and Match is fine for a handful of receipts a day. The manual cost is not the clicking, it is the deciding: working out which invoices a bald bank reference covers, chasing the ones whose numbers do not quite match your Xero formatting, and splitting the part-pays correctly. A customer who sends one payment against forty invoices turns a two-minute reconcile into a twenty-minute puzzle, and the accounts that pay you the most tend to send the messiest batches.

There is also a ceiling worth knowing about. If you lean on Xero's batch payment feature to pay suppliers, Xero caps a single batch at 200 invoices, and mega-batch remittances have to be split to fit. We cover that trap in full in our piece on the Xero 200-invoice batch payment limit. On the receiving side, Find and Match itself does not stop you at 200, but ticking that many invoices by hand against one deposit is its own kind of limit.

When the volume gets there, the step worth automating is the one that is actually expensive: reading the payment detail and deciding which invoices it settles. That is what RemitClear does for multi-invoice payments in Xero. It reads the payment detail in whatever form it arrives, matches every line against your open Xero invoices, splits the part-pays, and posts the payment for your review, as one batch or as separate payments, so the bank line still reconciles cleanly. Your job shrinks from searching and ticking to a quick approval.

Summary

To apply one payment to multiple invoices in Xero, use Find and Match on the bank reconciliation screen: tick each invoice the deposit covers, use Split for part-payments and short-pays, use the Adjustments dropdown for small bank-fee or rounding differences, and record any genuine surplus as a customer overpayment. Xero will only reconcile when the allocations equal the bank line to the cent, which is the guard-rail that keeps the ledger honest.

The reverse case, several receipts against one invoice, is the same tool used in mirror: part-pay the invoice from each bank line until the balance clears. All of this holds up at low volume. Once one deposit routinely fans out across dozens of invoices, the manual matching is the bottleneck, and that single step is the one worth handing to software.