Xero's Bank Statement Import Format Requirements
Xero's bank import (Accounting > Bank Accounts > Import a Statement) is more structured than it looks. The CSV must have specific column headers and date formats that match your Xero organization's locale settings. A generic CSV export from a basic converter will usually fail or import with errors.
The required fields, the date format requirement, and account code handling are the three points where most basic converters fall short for Xero specifically.
| Xero CSV Column | Required? | Format | Zera Books Output |
|---|---|---|---|
| Date | Yes | DD/MM/YYYY or MM/DD/YYYY | Normalized to org locale |
| Amount | Yes | Signed decimal (negatives = debits) | Correctly signed from debit/credit columns |
| Payee | No | Text | Extracted from description where identifiable |
| Description | No | Text | Cleaned and standardized |
| Reference | No | Text | Check/reference numbers extracted |
| Account Code | No | Xero account code | AI-mapped before export |
Common import failure: Xero rejects CSVs where the Amount column contains both positive credits and positive debits in separate columns. Zera Books consolidates into a single signed Amount column automatically. See the full Xero converter.
How the Bank Statement to Xero Conversion Works
The process goes from PDF to a Xero-ready file in four steps. The categorization step is what distinguishes Zera Books from tools that only extract raw data.
Upload your bank statement PDF
Upload single files or batch up to 50 at once. Digital PDFs and scanned image PDFs both accepted. Zera AI auto-detects the bank and format.
OCR and extraction
Zera OCR processes scanned PDFs at 95%+ accuracy on financial documents. Zera AI then structures the extracted text into clean transaction rows.
Categorization against Xero chart of accounts
Each transaction is mapped to a Xero account code. Connect your Xero account to use your actual chart, or Zera Books uses Xero's standard codes by default.
Xero CSV export or direct API push
Download a Xero-formatted CSV and upload via Accounting > Bank Accounts > Import a Statement, or push directly to Xero via API without downloading.
Xero Import: Automated vs Manual Workflow
Accountants who haven't used AI conversion often spend 45–60 minutes per client preparing statements for Xero. Here's what the two workflows look like in practice.
| Task | Manual | Zera Books |
|---|---|---|
| Extract from PDF | PDF tool or Tabula (~15 min) | Automatic |
| Format for Xero CSV | Reformat columns, fix dates (~20 min) | Automatic |
| Fix import errors | Diagnose and re-export (~10 min) | Validated before export |
| Code transactions in Xero | Every line item manually (~30 min) | Pre-coded via AI before import |
| Total per client/month | 75 minutes average | 8 minutes average |
Bank statements ready for Xero in minutes
Correctly formatted CSV with AI account coding. Handles any bank, digital or scanned. $79/month unlimited.
Try for one weekWho Needs Bank Statement to Xero Conversion
Multi-client bookkeepers
Processing statements for 10–50+ Xero clients monthly. Batch upload reduces per-client prep from 45 minutes to under 10.
New client onboarding
Importing years of historical bank statements for a new Xero client. Direct feed history rarely covers more than 6–12 months.
International banks
Xero supports fewer international direct bank connections. PDF-to-Xero conversion works regardless of country or institution.
Bank feed gaps
Filling in missing transaction periods when a direct bank connection was interrupted or not set up at the start of the year.
Frequently Asked Questions
What CSV format does Xero require for bank statement imports?
Xero accepts CSV with these headers: Date, Amount, Payee, Description, Reference, and (optionally) Account Code. The Date field must match your Xero organization's locale (DD/MM/YYYY or MM/DD/YYYY). Zera Books generates Xero-formatted CSV automatically.
Can I import bank statements to Xero without a live bank feed?
Yes. Use Accounting > Bank Accounts > Import a Statement in Xero. This works for any bank, regardless of direct feed support, and is the standard method for historical statements older than your direct feed window.
Does Zera Books categorize transactions for Xero automatically?
Yes. Zera AI maps each transaction to Xero account codes before export. Connect your Xero organization for your actual chart, or use Xero's standard codes. You review suggestions before finalizing.
How does Zera Books handle scanned bank statements?
Zera OCR processes scanned and image-based PDFs at 95%+ accuracy on financial documents before extraction. Output is identical to a digital PDF — you don't need a separate OCR step.