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

Reconciling a remittance advice in Xero means taking a single bank credit, splitting it across the right set of invoices, and matching the whole lot against the line on your bank feed. This guide walks through the process step by step, shows where it tends to break at scale, and outlines how finance teams speed it up.

The steps below assume you already have Xero connected to your bank feed and that you are reconciling AR (money coming in from customers). If the remittance in front of you covers one invoice, you can skip to the end. The real problem is multi-invoice remittances, so that is 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 do not split your screen, you will 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 does not, 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 do not match and you cannot explain the gap within a minute, park the remittance and come back to it once you have 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 are 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 has not already been paid from a previous remittance.

This is where things slow down. If your customer's invoice numbers do not 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 need to allocate the payment. In Xero, this can be done two ways:

1. Record a payment on each invoice individually. You open each invoice, click "Receive a payment", enter the amount, date, and reference, and save. This creates a separate payment record per invoice.
2. Use Xero's Find and Match on the bank feed. From the bank reconciliation screen, use Find and Match to pick multiple invoices at once, tick each one that the payment covers, adjust allocations where the amount paid differs from the invoice total, and click OK. Xero creates a batch of payments tied to the single bank credit.

Option 2 is faster for multi-invoice remittances and keeps the bank line clean. It is also more fragile: if you tick the wrong invoice, 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

Real-world remittances almost always include adjustments. A customer paid the invoice minus £47 for damaged goods. Another customer applied a credit note from a previous month. Another took a 2% early-settlement discount. Each of these needs to be handled 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 are off by even a cent, Xero will refuse. 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 are selling B2B, most customers will not 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 is 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.

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 do not 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

Reconciling a remittance advice in Xero is a seven-step manual process that is conceptually simple but operationally painful at scale. The bottleneck is almost always the transcription step between reading the remittance and finding the invoices in Xero. Every approach to speeding it up (prefix discipline, shared inboxes, batching) helps at the margin. For teams processing dozens of remittances a week, automation is the only change that moves the number from hours to minutes.

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