The Xero Winning Post: A Shortcut to Reconciling Multiple Invoices
Perpetual BlogIt's Cheltenham week, and while punters are placing their bets on the favourites, there's a different kind of race happening in your Xero account. You've got multiple invoices stacking up, and a single bank payment has just landed that covers three, five, or even ten of them.
The slow way? Opening each invoice individually, clicking reconcile, and repeating the process until your fingers ache. The fast way? A little-known Xero shortcut that lets you match multiple invoices to one payment in seconds flat.
Consider this your betting slip for smarter bookkeeping.
The Problem: When Customers Pay Multiple Invoices in One Go
If you run a trade business, manage a salon, or train clients one-on-one, you'll know this scenario well. A customer settles up at the end of the month and pays several outstanding invoices in a single bank transfer. Or perhaps you've sent a statement, and they've bundled everything into one payment to save on transaction fees.
You open your bank feed in Xero, and there it is: one juicy lump sum sitting in your account. But on your books, you've got five separate invoices waiting to be reconciled.

The rookie move is to reconcile each invoice separately, manually ticking them off one by one. It works, but it's painfully slow: like backing every outsider at Cheltenham and hoping for the best.
The smarter play? Xero's Find & Match feature, which lets you bundle multiple invoices against that single bank transaction in one move.
Why This Matters (And Why You're Probably Doing It Wrong)
Let's say you're a personal trainer charging £50 per session. You've invoiced a client for four sessions in March (that's £200 total), but they've paid it all at once. If you reconcile each £50 invoice individually against a £200 payment, you'll end up with a mess: overpayments, mismatched records, and a reconciliation report that looks like a jockey who's lost their stirrups.
Instead, you need to tell Xero: "This £200 payment covers these four invoices." That's where Find & Match comes in.
It's not just about saving time (though it does). It's about keeping your books accurate, your VAT returns clean, and your accountant off your back. When HMRC comes knocking: especially with Making Tax Digital for Income Tax starting in April: you want every transaction matched correctly, not bodged together with sticky tape and hope.
The Slow Way: Reconciling One Invoice at a Time
Before we get to the shortcut, let's acknowledge the traditional method. This is what most Xero users do when they're starting out:
- Open your bank feed
- Click on the £200 transaction
- Select "Create" and choose the first invoice
- Save it
- Repeat for the next invoice
- Realise you've now overpaid by £150
- Panic slightly
- Delete everything and start again
It's inefficient, error-prone, and about as enjoyable as watching your accumulator fall apart on the final fence.
The Shortcut: Find & Match in Action
Here's how to do it properly. The next time a customer pays multiple invoices in one lump sum, follow these steps:
Step 1: Open Your Bank Feed
Head to Accounting > Bank Accounts and select the account where the payment has landed. Find the transaction in your feed: it'll be sitting there marked as "unreconciled" in Xero.
Step 2: Click "Find & Match"
Instead of hitting "Create" or "OK", click the Find & Match button. This tells Xero you want to match this payment against existing invoices, rather than creating something new.

Step 3: Search for the Customer
Type the customer's name into the search bar. Xero will pull up all their outstanding invoices, showing you the amounts and due dates.
Step 4: Tick the Invoices
Select the invoices that add up to your bank transaction. Xero will show you a running total at the bottom of the screen. If your bank payment is £200 and you've ticked four £50 invoices, the totals will match perfectly.
Step 5: Hit "Reconcile"
Once the amounts match, click Reconcile. Job done. All four invoices are now marked as paid, and your bank transaction is cleared. No fuss, no overpayments, no mess.
When the Numbers Don't Match: Handling Partial Payments and Rounding
Sometimes, the numbers won't line up exactly. Perhaps your customer has paid £195 instead of £200, or they've deducted a small fee. Here's how to handle it:
Partial Payments:
If they've paid less than the full invoice total, Xero will flag the mismatch. You can still reconcile it, but you'll need to choose what to do with the remaining balance. Options include:
- Mark it as a partial payment (the invoice stays open for the remainder)
- Write off the difference (if it's a small rounding error or agreed discount)
- Create a credit note (if you've formally agreed to reduce the amount)
Overpayments:
If they've paid too much, Xero will offer to allocate the extra amount as a credit on their account, or you can refund it. Don't just ignore it: mismatched credits are a red flag during HMRC audits.

Pro Tips: Speeding Up the Process Even More
Once you've mastered Find & Match, here are a few extras to shave even more seconds off your reconciliation time:
Use Keyboard Shortcuts
Xero has built-in shortcuts that work across the platform. Press ? on your keyboard to bring up the shortcut menu. You can navigate between transactions, open reconciliation windows, and save records without touching your mouse.
Set Up Bank Rules for Regular Payments
If you have clients who pay the same invoices every month (gym memberships, retainer fees, standing orders), create a bank rule to automate the reconciliation. Head to Accounting > Bank Accounts > Manage Bank Rules and set conditions like "if payment from [Customer Name] equals £200, match to these invoice numbers."
Batch Reconcile at the End of the Week
Don't reconcile transactions as they trickle in throughout the day. Block out 30 minutes every Friday afternoon, pour yourself a brew, and blast through them all in one go. You'll work faster and catch any errors more easily.
When to Use Bank Rules Instead
Find & Match is brilliant for one-off situations where invoice amounts vary. But if you're reconciling the same type of transaction repeatedly: like supplier payments, VAT returns, or regular client retainers: bank rules are your friend.
A bank rule tells Xero: "Every time you see a payment from X for £Y, automatically match it to this account/invoice." Set it up once, and you'll never reconcile that transaction manually again.
For example, if you're a hairdresser who orders stock from the same supplier every month for around £300, you can create a rule that automatically posts it to your Stock Purchases account. No clicking, no matching, no fuss.
Why This Matters for MTD and HMRC Compliance
Making Tax Digital for Income Tax is kicking in from April 2026, and HMRC expects digital records that are accurate, complete, and traceable. That means every payment needs to match an invoice, and every reconciliation needs to be watertight.
Using Find & Match isn't just a time-saver: it's a compliance tool. When HMRC asks to see your digital records, they'll want proof that your bank transactions align with your invoicing. If you've been bodging reconciliations or leaving invoices half-matched, you're storing up trouble.

Get into the habit now. Clean books, clear records, no surprises.
Final Furlong: Make Reconciliation a Habit, Not a Chore
Reconciling invoices doesn't have to be a drag. With Find & Match in your toolkit, you can clear multiple transactions in the time it takes to make a cuppa. And just like picking the right horse at Cheltenham, knowing the shortcut gives you an edge over the competition.
Whether you're a personal trainer chasing session fees, a builder juggling stage payments, or a salon owner managing retail and services, this little Xero hack will save you hours every month.
So next time that lump sum lands in your account, don't panic. Don't reconcile one invoice at a time. Just open Find & Match, tick the boxes, and sprint to the finish line.
If you'd like a hand setting up bank rules, automating your Xero workflows, or getting MTD-ready before April, get in touch with us. We'll make sure your books are as sharp as a jockey's whip: and a lot less painful.
