A pre-upload checklist for a Xero™ file prepared in Excel™
An import rejected after upload costs more time than a check before it. This list covers the usual reasons a file may be turned away or may import something you did not intend. Confirm the details against Xero™'s own import guidance for your file type.
The checklist
- Required columns are present, and headers are spelled the way the template expects.
- Dates are ones Xero™ will read, in the format your organisation uses. If a value could be read two ways, such as 06/03/2026, confirm which day it is.
- Amounts are one column where the template wants one. A bank statement split across Debit and Credit may need combining into a single signed amount.
- Sign: money out is negative on a bank statement.
- Amounts are bare numbers. A value shown as 1,240.00 needs the formatting left to the cell, not typed into the value. Remove currency symbols and thousands separators from the value itself.
- Decimal separator is a full stop.
- Blank cells that may import as zero are filled or deliberately left.
- Contact names match existing ones exactly.
- Line breaks inside cells and odd encodings are removed.
- Field lengths are within Xero™'s limits, which change from time to time.
- No total rows or rows below the data.
Check by hand
These steps apply to Excel™ in Microsoft 365. Use Ctrl+End to find the true last cell, and sort a copy of each column to see stray values at the top or bottom. Use =ISNUMBER(C2) to confirm amounts are numbers.
Run the checklist as a pane
Import Cleaner for Xero™ has a "Check before uploading" direction that covers these points for the active sheet and names the cells. Its scan and explanations are free; applying fixes is the paid part, and Undo is always free. The workbook is not uploaded.
See Import Cleaner for Xero™ for Excel™
Microsoft, Excel and Microsoft 365 are trademarks of the Microsoft group of companies. Xero is a trademark of Xero Limited. Import Cleaner for Xero is an independent product, not affiliated with or endorsed by Microsoft or Xero Limited.