AppGarden Import Cleaner for Xero logo AppGarden

Import Cleaner for Xero

A pre-upload checklist for a Xero™ file prepared in Excel™

By Paul Kemp · Published

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

  1. Required columns are present, and headers are spelled the way the template expects.
  2. 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.
  3. 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.
  4. Sign: money out is negative on a bank statement.
  5. 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.
  6. Decimal separator is a full stop.
  7. Blank cells that may import as zero are filled or deliberately left.
  8. Contact names match existing ones exactly.
  9. Line breaks inside cells and odd encodings are removed.
  10. Field lengths are within Xero™'s limits, which change from time to time.
  11. 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.