Key takeaways
- Xero can match one bank line to many invoices with Find & Match, but the totals must agree to the cent.
- With no remittance, start from the amount and the customer's oldest open invoices.
- Past a few hundred payments a month, matching by hand costs more than a credit controller's week.
Can Xero match one payment to several invoices?
Yes. In bank reconciliation, open the statement line, choose Find & Match and tick every invoice the payment covers. The selected total has to equal the bank line to the cent, or you record the difference as a short payment or an overpayment before Xero lets you reconcile.
How do you match it by hand?
Filter open invoices by the customer, sort by date, and tick from the oldest until the total matches. For large customers, export the open invoice list and work out the combination in a spreadsheet first.
Check the result against any remittance before you reconcile: a matched total can still be the wrong set of invoices.
What if there is no remittance?
Ask for it, but do not wait. Most customers pay their oldest invoices first, so match from the oldest down and flag the line for review. Keep a note of which customers never send remittance; they are the first ones to automate.
How should you handle short payments?
A short payment is usually a deduction: a pricing difference, a damaged delivery or a promotional allowance. Record the shortfall against the invoice, open a dispute with the reason, and chase the evidence before the customer pays their next batch.
When should you automate cash application?
When matching takes more than a day a week, when customers pay dozens of invoices in one line, or when short payments go unchased. Modern works with any ERP, from Xero and MYOB to NetSuite, QuickBooks and SAP: it matches payments and remittance to invoices, flags short payments as deductions and posts cash the same day.
