“Xero will not accept my bank statement file”
Xero is stricter than most about statement files, and its error messages point at the format rather than the specific problem. The rules it enforces are consistent, which makes the failures predictable once you know them.
Symptoms
The import wizard reports an invalid file or unsupported format Dates are rejected even though they look correct Amounts arrive as zero or with reversed signs
What actually causes it
Date format not matching the selection
Xero asks you to state the date format and then enforces it strictly. A file mixing formats, or a selection that does not match, fails rather than guessing — which is safer but produces a flat rejection.
Amount column shape
Xero expects either one signed amount or clearly separated debit and credit columns. Currency symbols, thousands separators and parenthesised negatives all make a column unreadable as a number.
Structural defects in an OFX file
For OFX and QFX, unescaped characters, malformed dates and truncated downloads stop Xero exactly as they stop desktop software, reported as an unsupported file.
How to fix it
- Drop the file into the fixer below. Escaping, dates, amounts, truncation and CSV structure are all checked in one pass.
- Repair what it reports, then set the date format in Xero to match the file rather than your locale.
- Strip currency symbols and thousands separators from the amount column before uploading.
- Import a short range first to confirm the mapping is right before committing a full year.
Related import problems
Skip the manual edit — fix it automatically
The fixer refuses to rewrite ambiguous amounts and says so, which matters in bookkeeping where a silently rescaled figure is worse than a rejected file. Free, no signup, no upload.
Open the fixer