Xero CSV Format Requirements
Xero's CSV import is more prescriptive than QuickBooks. It requires columns in a specific positional order, and the date format must match your Xero organization's regional settings. Getting either wrong results in an import failure or silently misread transaction dates.
| Column (position matters) | Required | Format | Notes |
|---|---|---|---|
| Column A — Date | Yes | Match your Xero org's date format | Check Settings > General Settings > Formatting |
| Column B — Amount | Yes | Negative = money out, positive = money in | No $ signs, no comma separators |
| Column C — Payee | Optional | Plain text | Xero uses this for reconciliation matching |
| Column D — Description | Optional | Plain text, max 255 chars | Appears as transaction reference |
| Column E — Reference | Optional | Plain text | Check or reference number if available |
| Column F — Cheque Number | Optional | Numeric | For check transactions only |
Column position, not column names, drives Xero's import. Xero reads the file positionally — column A is always Date regardless of what the header says. If your bank CSV has Description first and Date second, Xero reads description values as dates and rejects the entire file. Zera Books Xero exports put columns in the correct order automatically.
The Xero Date Format Problem
The Xero date format issue catches accountants off guard because it depends on a setting that is rarely checked. Xero ties the accepted date format to your organization's regional settings, not a global software default.
Check your Xero date setting first
Go to Settings → General Settings → Formatting. The "Date Format" field shows exactly what format your CSV must use. US organizations: MM/DD/YYYY. AU/UK organizations: DD/MM/YYYY.
Match your CSV exactly
Even a single incorrectly formatted date causes the whole file to fail. If your bank exports DD/MM/YYYY but your Xero org expects MM/DD/YYYY, reformat the date column in Excel before uploading.
ISO format is universally accepted
YYYY-MM-DD (ISO 8601) is accepted by all Xero organizations regardless of regional settings. For programmatically generated CSV, ISO format is the safest choice.
Use OFX to skip this entirely
OFX files do not depend on column order or regional date settings. Zera Books exports OFX for Xero — if you import regularly, OFX eliminates all date format issues permanently.
Step-by-Step: Import CSV into Xero
The complete process from a prepared CSV to matched transactions in Xero's bank reconciliation queue.
Go to Accounting → Bank Accounts
In Xero's top navigation, click Accounting, then Bank Accounts. Find the account you want to import transactions into and click on it.
Click "Import a Statement"
Inside the bank account view, click Import a Statement. This button is on the account page, not the main Bank Accounts list. Xero opens the file selector for the import.
Select CSV and upload your file
Choose CSV as the file type and upload your prepared file. Xero reads the first rows and shows a transaction preview table. Verify that Date and Amount columns are reading correctly before proceeding.
Review and confirm the import
Xero shows all parsed transactions with date and amount. Check for misread dates (a date-amount swap indicates wrong column order). Click Import to complete.
Reconcile in Bank Reconciliation
Imported transactions appear in the bank reconciliation queue under Accounting → Bank Accounts → your account. Xero suggests matches against existing invoices, bills, and account codes.
Batch processing multiple clients. Zera Books processes 50+ statements at once and generates a separate export file per account. Import each file individually through the Xero Import a Statement workflow — Xero handles sequential imports without issues.
Get Xero-ready CSV (or OFX) from any bank statement
Zera Books exports CSV with correct Xero column order and ISO date format. AI categorization to your Xero chart of accounts included. $79/month unlimited.
Try for one weekCommon Xero CSV Import Errors
"Invalid date" on all rows
Your CSV date format doesn't match the Xero organization setting. Fix: Go to Settings → General Settings → Formatting to check the expected format. Reformat all dates in your CSV to match exactly, then re-import.
Dates show as amounts and amounts show as dates
Columns are in the wrong order. Xero reads positionally: column A = Date, column B = Amount. Fix: Reorder so Date is first and Amount is second. The header row labels do not override positional reading.
All transactions import with zero amount
The amount column contains non-numeric characters like "$" or commas. Fix: Remove all currency symbols and comma separators. Use plain decimal numbers. Xero parses anything non-numeric in the amount column as zero.
Debits and credits are reversed in Xero
Your bank exports debits as positive numbers, but Xero expects negative = money out. Fix: Multiply your debit amounts by -1 before importing. Xero uses negative for money leaving the account, positive for money arriving.
Frequently Asked Questions
What CSV format does Xero require for bank statement imports?
Columns in this order: Date, Amount, Payee (optional), Description (optional). Date must match your Xero org's regional date setting. Amount is negative for money out, positive for money in — no $ or commas. A header row is required.
How do I import a CSV bank statement into Xero?
Accounting > Bank Accounts > click the account > Import a Statement. Upload your CSV. Xero previews transactions before completing. Imported transactions appear in the bank reconciliation queue for matching and account coding.
Why is Xero rejecting my CSV date format?
Your CSV date format doesn't match the Xero organization's regional date setting. Check Settings > General Settings > Formatting. ISO date format (YYYY-MM-DD) works with all Xero organizations regardless of regional setting. Zera Books uses ISO dates in all Xero CSV exports.
Does Xero accept OFX or QIF files for import?
Yes. Xero accepts OFX, QIF, QBO, and CSV. OFX is the most reliable — no column ordering requirements, no regional date setting dependencies. Zera Books exports OFX for Xero pre-formatted to current Xero specifications.