The Xero Bank Statement Import Mapping Most Bookkeepers Get Wrong
Xero's bank statement import is unforgiving in three specific ways that are not in the documentation. Get them right and reconciliation takes minutes.
Summary
Xero rejects rows silently when the date format is ambiguous or the amount column has both signs. Here is the exact mapping that always works for UK statements.