How to apply one payment to multiple invoices in Xero (and where it breaks past 50)

A customer pays one amount that clears last month's invoices. The bank feed shows a single deposit. Your accounts receivable ledger shows a dozen open invoices. Somewhere between the two, you have to tell Xero which invoices that one payment settles. This is the everyday task that quietly eats an afternoon, and Xero gives you two honest ways to do it before it stops being pleasant.

Option one: match the deposit on the bank reconciliation screen

When the deposit lands in your bank feed, open the Reconcile tab for that account and find the line. Instead of accepting the suggested match, click Find & Match. Xero shows you a searchable list of outstanding transactions. Tick each invoice the payment covers. As you tick, Xero keeps a running total at the bottom of the panel and compares it to the statement line.

If the ticked invoices add up to the exact deposit, you reconcile and you are done. This is the cleanest path when the numbers are tidy: the customer paid the full face value of a handful of invoices and nothing was short-paid.

• Open Business, then Bank accounts, then Reconcile on the relevant account.
• On the statement line for the deposit, choose Find & Match.
• Search by contact or invoice number, then tick every invoice the payment settles.
• Confirm the running total equals the statement line, then click Reconcile.

Option two: record a batch deposit

The purpose-built tool for this is the batch deposit. From the sales dashboard, select the awaiting-payment invoices you want to settle together, choose Deposit, set the date and the account, and Xero records one payment that clears all of them at once. It then appears in your bank feed as a single line you reconcile in one click. For a payment run covering many invoices at their full value, this is the tool the workflow was designed around.

Where it breaks: the 50-invoice wall

Xero limits a single batch deposit to 50 invoices. On a small run you will never notice. On a large remittance you hit the wall hard. A distributor paying 90 invoices, or a plan manager settling 140 claim lines in one transfer, cannot be recorded as one batch deposit. You are forced to split the work into batches of 50 or fewer, and now you are reconciling one real-world payment against two or three separate Xero records.

That split is where errors creep in. The deposit total no longer matches any single batch, so you reconcile part of the bank line against one batch and the remainder against another. Miss an invoice in the selection and the batch will not balance. Include one twice and it will not balance. The arithmetic that used to be automatic is now yours to carry.

Practical ways to stay sane past 50

• Group by due date or invoice range so each batch of 50 is a clean, reconstructable slice.
• Reconcile the bank line last, after every batch balances, so the remainder is obvious.
• Keep the remittance advice open beside Xero and tick lines off it as you go, so you never lose your place across batches.
• Record short-paid invoices separately as part-payments rather than forcing them into a full-value batch.

The honest limitation

None of this is a Xero bug. Xero is excellent at recording a payment once you have decided which invoices it covers. What it does not do is read a supplier's remittance advice, work out the allocation for a 140-line payment, and hand you a balanced batch to approve. That decision, the matching, is the work. The 50-invoice cap simply marks the point where doing that work by hand stops being reasonable.

If your payments routinely clear more than 50 invoices, or arrive with part-pays and mangled references, the matching is worth automating even though the recording is not. The rule to protect at all costs is the one Xero enforces for you on a clean batch: the sum of what you allocate must equal the deposit, to the cent, before anything posts.