Xero™ bank statement import failed: check your sheet first
Xero™ is strict about the bank statements it accepts, and its error messages point at the file, not the fix. Before retrying an import, check the sheet itself: most failures come from a small set of causes.
The usual causes
- Date format. The date column must match what Xero™ expects for your organisation. A column of mixed formats, or text that merely looks like dates, fails.
- Blank rows inside the data. A gap partway down can end the import early or fail it outright.
- Amounts stored as text. Currency symbols, commas in the wrong place or trailing spaces turn amounts into text that Xero™ cannot read as money.
- Rearranged or renamed columns. If the file was tidied in Google Sheets™ first, check the columns still match the layout Xero™ wants.
- Stray content. Notes, totals or a second table below the data do not belong in an import file.
Check by hand
- Read Xero™'s error message and go to the row it names. The fault is usually on that row or the one above it.
- Check the date column is one consistent, real-date format throughout.
- Check every amount cell holds a number (
=ISNUMBER()never lies). - Remove blank rows inside the data and anything below the last transaction.
Validate before you upload
Import Cleaner for Xero checks an upload file before it goes near Xero™: dates, amounts, references and the contact names that would silently create duplicates. The full scan, every explanation and Undo are free, and your data stays in your Google™ account.
Install from the Google Workspace Marketplace™
Google, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Not affiliated with, endorsed by or sponsored by Xero Limited. Xero is a trademark of Xero Limited. Import Cleaner for Xero is not affiliated with or endorsed by Google.
Google, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Not affiliated with, endorsed by or sponsored by Xero Limited. Xero is a trademark of Xero Limited. Import Cleaner for Xero is not affiliated with or endorsed by Google.