How to Match One Payment to Multiple Invoices in Xero

In Xero, one receipt settles many invoices in a single action on the bank reconciliation screen, which is where people go wrong when they key a payment against each invoice in turn. The credit lands, you know it covers more than one invoice, and often no remittance advice arrived to explain it, so you're working backwards from the amount, maybe a customer settled a dozen at once, maybe the bank reference is a string that means nothing to anyone. The pure Xero mechanics below turn that lump sum into a clean reconciliation.

Here you're starting from the money on its own. 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, since this one assumes the receipt is all you've got.

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, one transfer clears every invoice they owe you that month, and 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 don't need a remittance advice to do this, though you do need to know, or be able to work out, which invoices the amount covers. If the deposit is a round $12,480 and you have three open invoices for that customer totalling exactly $12,480, the arithmetic answers itself. If it doesn't add up cleanly, the difference is where the work is, and that's covered further down.

Applying one payment across multiple invoices with Find and Match

Find and Match is the tool for this, and it lives on the bank reconciliation screen. People who go looking on the individual invoices instead end up receiving a payment on each one in turn, and then can't get the bank line to clear.

1. Open the Reconcile screen for the bank account the money landed in: 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, searching by customer name, invoice number, or amount to bring the right ones into view. Xero keeps a running total of what you've selected against the value of the bank line.
4. Watch that running total. Once the selected invoices hit the exact value of the deposit, the Reconcile button wakes up, and one click applies and reconciles the whole set.

In the clean case the ticked invoices equal the deposit to the cent and you're finished, with Xero creating a payment against each invoice, all tied to the one bank statement line, so the feed stays tidy. The friction starts when the numbers don't line up, which in practice is often.

When the deposit does not equal the invoice total

Three versions of this come up and Xero handles each differently, though in all of them 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, so the invoice stays in Awaiting Payment showing the remaining balance and the deposit now ties out. Plenty of people never notice the Split link is there.

Small unexplained differences. A few dollars of bank charges on an international transfer, or a rounding difference, don't 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, and a made-up adjustment isn't the way to close it. 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 don't exist.

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 couple of weeks, so you have several bank lines and one invoice, and you want each receipt to chip away at the balance until it's cleared.

The mechanics are the mirror image of the above. For each deposit, open Find and Match, tick the same invoice, use Split to allocate only the portion this receipt pays, and 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're recording a part-payment against the invoice from each bank line separately, without going into the invoice itself each time.

Because each receipt is reconciled independently, it's 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, or you can over-apply and create an overpayment credit by accident.

Where doing this by hand stops paying off

Find and Match is fine for a handful of receipts a day. The clicking is quick, and the time goes on working out which invoices a bald bank reference covers, chasing the ones whose numbers don't 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's 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 doesn't stop you at 200, though ticking that many invoices by hand against one deposit takes about as long as it sounds.

When the volume gets there, the expensive step to hand over is the working out, reading the payment detail and deciding which invoices it settles. That's what RemitClear does for multi-invoice payments in Xero. It takes the payment detail in whatever form it arrives, works out which of your open Xero invoices each line settles, splits the part-pays, and hands you the finished allocation to approve, then posts it as one batch payment or as separate payments so the bank line still reconciles cleanly, with the searching and ticking done and the checking left to you.

Summary

The allocations have to equal the bank line to the cent before anything reconciles, and it works the same way in both directions, one deposit across many invoices or many receipts against one. What doesn't scale is the searching and ticking underneath it, and that's the part worth handing to software the day a deposit routinely fans out across dozens.