How do I reconcile a remittance advice that covers many invoices in Xero?

Check that the advice total matches the bank credit, then use Find and Match on that bank line to tick each invoice the advice lists. Use Split on any short-paid line so the allocations equal the deposit, and Xero lets you reconcile once they tie out to the cent. The advice tells you which invoices to tick; the slow part is transcribing it and finding each invoice in Xero, which is exactly what RemitClear reads and matches automatically.

Can Xero read a remittance advice automatically?

No. Xero has no feature that reads an incoming remittance advice and matches its lines to your open invoices. Find & Match still needs a person to search for and select every invoice by hand. RemitClear fills that gap: it reads the remittance in any format, matches each line to your open AR invoices in Xero, and posts the payment for your review.

How do I reconcile a remittance when the paid amount doesn't match the invoices?

First work out why. Short payments and deductions are common on real remittances, and the advice usually shows which line was underpaid. In Xero's Find & Match you can use the Split option to part-pay an invoice, leaving the balance outstanding. In RemitClear you adjust the allocation amount on the affected line during review, and the system validates that your allocations balance against the remittance total before anything posts to Xero.

How long should reconciling a remittance advice take?

Manually, a 20-invoice remittance typically takes 15 to 30 minutes of searching, ticking, and checking, and much longer when invoice numbers on the advice don't exactly match Xero. With automated matching the same document takes under 10 seconds to read and match, plus a quick human review before posting.

How to Reconcile a Remittance Advice in Xero

Get a remittance reconciliation wrong in Xero and it doesn't fail loudly. It fails quietly: an invoice you closed that should have stayed open, a customer chased next month for a payment they already made, a bank line that won't tie out until you find the one figure you mistyped. Done right, reconciling a remittance advice is simple enough to describe in a sentence, take a single bank credit, split it across the right set of invoices, and match the whole lot against the line on your bank feed. Done at scale, by hand, it's where the quiet errors breed.

This walkthrough assumes you already have Xero connected to your bank feed and that you're reconciling AR (money coming in from customers). If the remittance in front of you covers one invoice, you can skip to the end. Multi-invoice remittances are where the difficulty lives, so that's where we focus.

The manual process, step by step

Step 1: Open the remittance and the Xero bank feed side by side

Find the remittance advice (usually an email attachment), open it, and then open Xero's Reconcile screen for the correct bank account. You should be able to see the incoming payment in the bank feed and the remittance detail on the other half of your monitor. If you don't split your screen, you'll spend the next hour alt-tabbing.

Step 2: Match the totals

Before doing anything in Xero, check that the total on the remittance matches the credit in the bank feed. If it doesn't, stop and work out why. Common reasons include:

The remittance covers multiple bank credits (the payer is sending one advice for two transfers).
A credit note or deduction has been applied that is not explicitly listed.
Bank fees have been deducted from the transfer.
The advice relates to a different month's batch than the one you are looking at.

If the totals don't match and you can't explain the gap within a minute, park the remittance and come back to it once you've checked with the payer. Fighting the totals inside Xero only creates a mess that someone else has to clean up.

Step 3: Find each invoice in Xero

For each invoice number on the remittance, open the Business menu, go to Invoices, and search. You're looking to confirm:

The invoice exists and is in the "Awaiting Payment" state.
The customer on the invoice matches the payer on the remittance.
The gross amount is correct.
The invoice hasn't already been paid from a previous remittance.

This is where things slow down. If your customer's invoice numbers don't exactly match the ones on the remittance (missing prefix, extra leading zero, hyphen instead of slash), the search returns nothing and you have to widen your query. A common time-sink.

Step 4: Allocate payments

Once every invoice has been located, you allocate the payment, and Xero gives you two ways to do it. The slow way is to record a payment on each invoice individually: open each one, click "Receive a payment", enter the amount, date, and reference, and save, which creates a separate payment record per invoice. The faster way is Find and Match on the bank reconciliation screen, where you pick multiple invoices at once, tick each one the payment covers, adjust allocations where the amount paid differs from the invoice total, and click OK, so Xero creates a batch of payments tied to the single bank credit.

Find and Match is faster for multi-invoice remittances and keeps the bank line clean. It's also more fragile: tick the wrong invoice and the mistake is harder to spot than with per-invoice payments. Most teams standardise on one approach and stick with it.

Step 5: Handle deductions and credit notes

Remittances almost always carry adjustments. A customer paid the invoice minus £47 for damaged goods. Another applied a credit note from a previous month. Another took a 2% early-settlement discount. Each of these needs handling before you can reconcile.

Short-payments: enter the reduced amount as the payment against the invoice and leave the balance outstanding, or raise a credit note for the difference if the reduction is final.
Existing credit notes: add them to the Find and Match screen alongside the invoices so they offset correctly.
Discounts: treat as short-payments and either write off via a credit note or post the discount to a designated account.

Step 6: Reconcile the bank line

Once allocations total to the exact amount of the bank credit, Xero lets you click "OK" and the bank line is reconciled. If you're off by even a cent, Xero refuses. This is where teams discover they missed a line on the remittance or mistyped an amount.

Step 7: Send payment receipts (optional)

Some teams send payment receipts back to the customer as a polite acknowledgement. Xero supports this from the payment detail page. If you're selling B2B, most customers won't expect it, but it can be useful for building a paper trail.

Where the manual process breaks

The process above works fine for one or two remittances a day. It breaks in predictable ways as volume grows:

Scanning long PDFs: a 12-page remittance from a large retailer can take twenty minutes to transcribe without errors.
Mismatched invoice numbers: the "XYZ-" prefix your system uses does not appear on the customer's remittance, so searches fail until you learn the pattern.
Duplicate processing: the same remittance gets forwarded twice, and without strict discipline it's easy to process it both times.
Already-paid invoices: the customer includes an invoice on a remittance that was paid in a previous batch, and nobody notices until month-end.
Format variety: every customer has their own template, so no amount of Excel-based automation will cover them all.

A good diagnostic question: how long does your team take to reconcile remittances from your three largest customers? If the answer is more than 30 minutes each, you're losing several hours a week to a process that doesn't need a human.

How finance teams speed this up

Configure invoice prefixes consistently

If you use invoice prefixes in Xero (for example INV- or SI-), make sure your customers are told which variant is authoritative. When they drop or change the prefix on their remittance, your searches fail. This is a customer-education job that pays back quickly.

Use a shared remittance inbox

A dedicated mailbox like remittance@yourco.com means remittances don't get buried in individual inboxes and can be triaged by whoever is available. It also creates a natural backlog you can measure, which is useful when you start looking at automation.

Batch reconcile at set times

Rather than reconciling remittances as they arrive, process them in one or two dedicated blocks per day. Switching between remittance work and other AR tasks destroys concentration, and remittance reconciliation is unforgiving of interruptions.

Automate the extraction and matching

Once volume passes a certain threshold (usually around 10 to 20 remittances a week), automation pays for itself inside a month. The principle is the same as what you do manually: read the remittance, extract invoice numbers and amounts, find those invoices in Xero, allocate the payment. The difference is that it happens in seconds and you only get involved for review and approval.

Tools in this category follow a common pattern: upload or forward the remittance, OCR extracts every invoice line, the tool matches against your open AR invoices in Xero, and you review the allocations before they post. Your job shrinks from reading and typing to approving. For a side-by-side of how this plays out specifically for Xero users, see RemitClear's Xero remittance matching page.

Summary

It stops being a job worth a person's time at the point where the transcription step, reading the remittance and then hunting each invoice down in Xero, is doing all the damage and none of the value. Below a couple of dozen remittances a week, the margin tricks keep it survivable: prefix discipline so searches hit, a shared inbox so nothing gets buried, set blocks so you're not interrupted mid-reconcile. Past that, no amount of discipline moves the number from hours to minutes, and the seven manual steps become a review-and-approve the moment something else reads the remittance for you.

For the specific case of NDIS providers, see our guide to NDIS remittance processing in Xero.

How to Reconcile a Remittance Advice in Xero (Step-by-Step)