Fix a transaction posted to the wrong bank account in Xero
Open the bank transaction and check what needs to change. Unreconcile a wrong match. For a spend or receive money entry posted to the wrong bank account, Xero directs you to use Remove & Redo and enter it in the correct account. An invoice or bill payment has its own correction steps. Xero’s response on moving bank transactions
Check which record is wrong
- The bank statement line is matched to the wrong transaction. Open the reconciliation details, then unreconcile and match the statement line to the correct transaction. Unreconciling an invoice or bill payment keeps the payment applied to that document. For many wrong matches, see can you bulk unreconcile in Xero. Xero reconciliation details · Xero’s correction examples
- A spend or receive money entry is in the wrong bank account. Check the date, reference and amount against the actual bank statement. Save a copy of any receipt before removing the entry. Recreate it in the correct account and reconcile it to the matching statement line. Xero’s Remove & Redo guidance · Xero’s attachment guide
- An invoice or bill payment is recorded against the wrong bank account. Open the payment from the invoice or bill and check the account shown there. Xero directs you to delete the incorrect payment and reapply it from the correct account. Confirm the full allocation with your reviewer if the payment covers several documents. Xero’s payment account guide
- A whole bank statement was imported to the wrong account. Follow Xero’s statement move procedure. It starts by obtaining the original file or exporting the statement worksheet from Xero. Xero’s bank statement move guide
Check both accounts before correcting a batch
- Keep the original statements and export Xero’s Account Transactions report for the same date range and currency. Export each account separately. If you choose Excel, save each account’s worksheet as its own CSV. Xero’s Account Transactions report guide
- Compare each bank statement with its Xero ledger. For example, a fictional 86.40 AUD card charge might appear only on the card statement and only in the ledger for the current account. Confirm the payee and reference before treating those two rows as the same transaction.
- Keep the review list and verify both account balances after the corrections. Xero’s statement balance check
Recondiff shows rows that appear on only one side and flags possible duplicates. Run a separate comparison for each account. The tool reads CSVs in your browser, and the first 50 rows of each file are free. Make any corrections in Xero after reviewing the source records.
Download the four sample CSVs
Compare one pair at a time. The fictional charge appears under Only in bank for the card and under Only in ledger for the current account.
- Card account · Card statement · Card ledger
- Current account · Current account statement · Current account ledger
Questions people ask
How do I move a transaction to a different bank account in Xero?
For a spend or receive money entry posted to the wrong bank account, Xero directs you to use Remove & Redo and enter it again in the correct account. Save a copy of any receipt first, then reconcile the new entry to the matching statement line.
What is the difference between a wrong match and a wrong bank account?
A wrong match is a bank statement line reconciled to the wrong transaction: unreconcile it and match the line to the correct one. A wrong bank account means the entry itself sits in the wrong account, so it has to be removed and recreated in the right one.
What if an invoice or bill payment was recorded against the wrong bank account?
Open the payment from the invoice or bill and check the account shown there. Xero directs you to delete the incorrect payment and reapply it from the correct account. If the payment covers several documents, confirm the full allocation with your reviewer.
What if a whole bank statement was imported into the wrong account?
Follow Xero's statement move procedure. It starts with the original file, or with the statement worksheet exported from Xero.
How do I check that both accounts are right afterwards?
Export Xero's Account Transactions report for each account, for the same date range and currency, and compare each one with its bank statement. Then verify both account balances. Recondiff shows the rows that appear on only one side, and the first 50 rows of each file are free.