How to Import Extracted Data into Xero

More from this article

• Need to import data into Xero after extracting a bank statement? Xero's CSV bank statement import has its own specific requirements, and getting them wrong is the usual reason an import fails or, worse, records the wrong amounts. Here's what its own documentation actually specifies.
• What Xero's CSV import actually requires
• Per Xero's own import documentation:
• Getting there from Datafromfile
• 1. Extract your bank statement with Bank Statement to Excel. 2. Confirm your Xero organisation's region setting, then format the Date column to match (DD/MM/YYYY or MM/DD/YYYY). 3. Set debits as negative and credits as positive in a single Amount column (or split into two columns if you prefer). 4. Export to CSV and import it in Xero under Accounting > Bank Accounts > Import a Statement.
• The mistake that causes the most confusion