For teams that run on Xero
Xero remittance: match one payment to invoices
Some customers pay many invoices in one transfer and send a remittance listing them: funding bodies, agencies, larger clients. In bank reconciliation that one line is matched to each invoice by hand, which for some businesses takes hours each week.
How it goes today
- Open the remittance from the customer next to Xero.
- Find each invoice on it in the bank reconciliation screen.
- Adjust amounts where a customer paid less than the invoice.
- Check the total matches the bank line before you reconcile.
How it can go
Match one payment for many invoices without splitting it by hand.
You forward the remittance as a file or email. Each line is matched to the open invoice by number and amount, and lines that do not match are listed with the reason. After you approve, one batch payment with those invoices is made in Xero for invoices in your own currency, ready to match against the bank line in a single step.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. Xero works with a sign-in instead of a key: you sign in to Xero once to give access, never in the chat.
With Hypamoon, when I forward a remittance from a customer, read each line and match it to the open Xero invoice by invoice number and amount. List the lines that do not match, with the reason. After I approve, record one batch payment in Xero for the matched invoices in our own currency on the payment date, so I can reconcile it against the bank line in one step.
You register your own app in the Xero developer portal and connect your organisation once. It stays yours.
More for teams on Xero
- I want to mark a bill as in dispute, so nobody pays it by accident.
- I want statements to go out to my customers each month, with how overdue each invoice is.
- It takes a lot of time to go into each invoice and work out the interest.
- I spend a lot of time applying one credit at a time before a pay run.
- I want my monthly profit and loss emailed to me without running it each time.
- I want to write off invoices that will not be paid, without doing each credit note by hand.
- I want to download every attachment at once, not one by one.
- I want a receipt to go out once a payment is reconciled.
- I want a report of how many days each customer takes to pay.
- I have to change the price on each repeating invoice one by one.
- I export the profit and loss of each company every month and merge them in a spreadsheet.
- I am still typing in every line of every bill.
- I have to tell someone by hand that they have bills to approve.
- I want to spread prepaid costs over the months they cover without a journal every month.
- I want a reminder to go to customers who have not responded to a quote.
- I want to see which documents still need to be uploaded.
- We agree several payment dates per order, and Xero gives an invoice one due date.
- Printing a packing slip for each invoice every day takes a lot of clicking.
- Some customers pay one price and others another, and we have over a hundred items.
- Our bank wants a file Xero does not produce, so we build it by hand.
- I want livestock trading reports with quantities and average cost per head.
- Clients ask which invoices are in the CIS return and I work it out by hand.
- Xero doesn't show what retention is outstanding across our contracts.
- I need opening balance, net movement and closing balance for each fund.
- I calculate super from contractor invoices by hand and have to remember to pay it.
- I create a receipt for our donors in Word and email it myself.
- I check every invoice by hand so the margin scheme VAT is right.
- A tenant wants us to set the bill they sent against their rent invoice.
- We log in and out of each company to check the loans between them.
- Hours have to be entered twice, once in the roster and once in Xero.
- I want a loan schedule with rate and term, not a journal by hand each month.
- I download a PDF for each subcontractor and email them one by one at year end.
- Every month I enter the till figures for each day: cash, vouchers, cards and VAT.
- We need a percentage taken off each invoice as commission, and we do it in Excel.
- We write a buyer created invoice by hand and then enter it into Xero.
- The customer withheld tax, so the invoice in Xero still shows a balance.
- We record gifts in Xero and then rebuild them in a spreadsheet for Gift Aid.
- Deposits come in months before the booking and I move them to income by hand.
- Xero only gives me a CSV, and the PDFs come one at a time.
- We prepare NDIS claims by hand and match each payment back to the invoice.
- Each month I make a statement per owner from bookings and costs by hand.
- We invoice literally everyone in our contacts list once a year.
- I have hundreds of repeating invoices and change the quantity each month.
- I check the VAT number of every new supplier on the tax office site.
- Everything for Xero