Convert Bank CSV to Xero Format Instantly

Why Bank CSVs Fail When Importing to Xero

You downloaded a CSV from your bank, tried to import it into Xero, and got an error. This is one of the most common frustrations Xero users face, and it's not your fault. The problem is that there is no universal standard for how banks format CSV exports. Every bank uses different column names, date formats, number conventions, and file encoding. Chase uses “Post Date” and “Description” columns. Bank of America uses “Date” and “Payee.” Wells Fargo separates debits and credits into separate columns. European banks use commas as decimal separators (1.234,56 instead of 1,234.56). Australian banks often use DD/MM/YYYY dates while US banks use MM/DD/YYYY. Xero expects a very specific column structure — Date, Amount, Payee, Description, Reference — and when your bank's CSV doesn't match, the import fails. This CSV to Xero converter automatically detects your bank's column structure and reformats everything to match Xero's requirements.

Xero's CSV Import Requirements

Understanding exactly what Xero expects helps you verify the converted output. Here are Xero's CSV import specifications:

• File format: CSV (Comma-Separated Values) with UTF-8 encoding. The first row must be column headers.
• Date column (required) — Must match your Xero organization's regional date format. US: MM/DD/YYYY, UK/AU/NZ: DD/MM/YYYY, ISO: YYYY-MM-DD.
• Amount column (required) — A single column with positive values for money in (credits) and negative values for money out (debits). Standard decimal notation using a period as the decimal separator (e.g., -52.40, not -52,40).
• Payee column (optional) — The name of the other party. Xero uses this for transaction matching and bank rule auto-categorization.
• Description column (optional) — Additional details about the transaction.
• Reference column (optional) — A unique identifier like a check number. Xero uses this for duplicate detection during import.
• Maximum rows: Xero recommends up to 1,000 transaction lines per import. For larger files, split by date range and import in batches.

Common Bank CSV Column Structures

Here are some of the most common CSV formats exported by major banks and how they differ from what Xero expects:

• Chase Bank — Columns: Details, Posting Date, Description, Amount, Type, Balance, Check or Slip #. Uses MM/DD/YYYY dates and a single Amount column (already signed). The converter maps Posting Date → Date, Amount → Amount, Description → Payee.
• Bank of America — Columns: Date, Description, Amount, Running Bal. Uses MM/DD/YYYY dates. Relatively clean format, but the Running Bal column confuses Xero. The converter strips it out.
• Wells Fargo — Columns: Date, Amount, *, Description. Uses separate rows for debits (negative) and credits (positive). The asterisk column is an internal code that Xero cannot use. The converter removes it and keeps Date, Amount, Description.
• Citibank — Columns: Status, Date, Description, Debit, Credit. Uses separate Debit and Credit columns instead of a single signed Amount. The converter merges these into one Amount column with the correct sign.
• Capital One — Columns: Transaction Date, Posted Date, Card No, Description, Category, Debit, Credit. Multiple date columns, separate debit/credit, and extra columns. The converter picks the right date, merges amounts, and strips extras.
• European banks — Often use semicolons instead of commas as delimiters, DD.MM.YYYY or DD/MM/YYYY date formats, and commas as decimal separators (1.234,56). The converter handles all these European conventions automatically.

Date Format Troubleshooting for Xero

Date format mismatches are the #1 reason Xero CSV imports fail. Here's how to avoid them:

1. Check your Xero region setting — Go to Settings → General Settings in Xero. Your country determines the expected date format: US = MM/DD/YYYY, UK/AU/NZ = DD/MM/YYYY.
2. Match the converter output — In this converter's Configure step, select the date format that matches your Xero organization's region.
3. Watch for ambiguous dates — Dates like 01/02/2024 are ambiguous (January 2nd or February 1st?). If Xero shows transactions on unexpected dates after import, your date format doesn't match. Re-convert with the correct format.
4. ISO format as a safe choice — If you're unsure, YYYY-MM-DD (ISO 8601) is unambiguous and accepted by all Xero regions.

Auto-Detection and Manual Column Mapping

The CSV to Xero converter uses intelligent auto-detection to identify your bank's column structure. It scans column headers for common patterns (“Date,” “Post Date,” “Transaction Date,” “Amount,” “Debit,” “Credit,” “Description,” “Payee,” etc.) and automatically maps them to Xero's expected columns. For 95% of bank CSVs, auto-detection works perfectly. For the remaining edge cases — custom headers, non-English column names, or unusual file structures — the Configure step lets you manually assign each column's role using dropdown menus. You can map any column as Date, Amount, Debit, Credit, Payee, Description, Reference, or “Skip” (to exclude irrelevant columns like balance or internal codes). The Preview step then shows exactly how the converted output will look before you download, so you can verify everything is mapped correctly.

Related Free Accounting Tools

The CSV to Xero converter is part of our complete suite of free financial file conversion tools. Whether you need to convert between formats, import marketplace data, or migrate to another accounting platform, we have a dedicated tool for every workflow:

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• OFX to QBO Converter — Convert OFX bank statement files to QuickBooks QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• QBO to CSV Converter — Export QBO transaction files to CSV spreadsheets.
• OFX to CSV Converter — Convert OFX bank files to CSV for Excel and Google Sheets.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to QBO format.
• QBO to PDF Converter — Generate professional PDF statements from QBO files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QBO.
• QIF to CSV Converter — Convert Quicken QIF files to CSV spreadsheet format.
• QIF to IIF Converter — Convert Quicken QIF files to QuickBooks IIF format.
• IIF to CSV Converter — Export QuickBooks IIF files to CSV spreadsheets.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 bank statements to CSV format.
• XLSX to QBO Converter — Convert Excel XLSX files to QuickBooks QBO format.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QBO.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks format.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks format.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks format.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks format.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks format.
• Etsy to QuickBooks Converter — Convert Etsy Shop Manager CSV exports to QuickBooks format.
• IIF Viewer — Preview and validate IIF files before QuickBooks import.
• Chart of Accounts Generator — Generate industry-specific chart of accounts for QuickBooks.
• Bank CSV Cleaner — Clean messy bank CSV exports for QuickBooks import.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• QBO Viewer — Preview and inspect QBO Web Connect files before import.
• OFX Viewer — Preview and inspect OFX bank statement files.
• Duplicate Detector — Find and remove duplicate transactions before import.
• File Format Detector — Identify unknown financial file formats automatically.
• QBO to Xero Converter — Convert QuickBooks QBO files to Xero CSV format.
• OFX to Xero Converter — Convert OFX bank statement files to Xero CSV format.
• IIF to Xero Converter — Convert QuickBooks Desktop IIF files to Xero CSV format.
• QBO to Wave Converter — Convert QBO files to Wave-compatible CSV format.
• OFX to Wave Converter — Convert OFX bank files to Wave CSV format.
• IIF to Wave Converter — Convert IIF files to Wave-compatible CSV format.
• CSV to Wave Converter — Reformat bank CSV for Wave's import requirements.
• QBO to FreshBooks Converter — Convert QBO files to FreshBooks CSV format.
• OFX to FreshBooks Converter — Convert OFX bank files to FreshBooks CSV format.
• IIF to FreshBooks Converter — Convert IIF files to FreshBooks CSV format.
• CSV to FreshBooks Converter — Reformat bank CSV for FreshBooks import.
• QBO to Sage Converter — Convert QBO files to Sage-compatible CSV format.
• OFX to Sage Converter — Convert OFX bank files to Sage CSV format.
• IIF to Sage Converter — Convert IIF files to Sage-compatible CSV format.
• CSV to Sage Converter — Reformat bank CSV for Sage's import requirements.