1

Import Format Specifications by Software

Each accounting platform uses a different column format, date standard, and encoding for bank statement imports. Using the wrong spec causes the entire import to fail or worse — silently import with wrong data.

QuickBooks Online

Format: QBO or CSV
Date: MM/DD/YYYY (CSV) or YYYYMMDD (QBO)
Columns: Date, Description, Amount or Date, Description, Credit, Debit
Encoding: UTF-8 or ANSI
Max rows: 1,000 per import

Xero

Format: CSV only (OFX also accepted)
Date: DD/MM/YYYY or MM/DD/YYYY
Columns: Date, Amount, Payee, Description, Reference, Cheque, Balance
Encoding: UTF-8
Max rows: Unlimited

Sage 50

Format: CSV (Sage format)
Date: DD/MM/YYYY
Columns: Date, Reference, Description, Net Amount, Tax Code, Tax Amount, Nominal Code
Encoding: ANSI
Max rows: 500 per import

MYOB AccountRight

Format: CSV
Date: DD/MM/YYYY
Columns: Date, ID, Memo, Deposit, Withdrawal
Encoding: UTF-8
Max rows: Unlimited

Wave Accounting

Format: CSV only
Date: MM/DD/YYYY
Columns: Date, Description, Amount (negative = debit)
Encoding: UTF-8
Max rows: 1,000 per import

Zoho Books

Format: CSV or OFX
Date: MM/DD/YYYY
Columns: Date, Payee, Memo, Debit, Credit, Balance
Encoding: UTF-8
Max rows: Unlimited
2

How to Import Bank Statements into QuickBooks Online

QuickBooks Online's bank transaction import has changed significantly in 2024-2025. Here are the exact steps using either QBO format (recommended) or CSV.

Step QBO Format (Direct) CSV Format (Manual)
1. Navigate Banking → Upload Transactions Banking → Upload Transactions
2. Select file Choose .qbo file Choose .csv file
3. Select account Auto-matched from header Manually select bank account
4. Map columns Skipped automatically Map Date, Description, Amount
5. Set date format Auto-detected Select MM/DD/YYYY manually
6. Review & import Review transactions → Import Review transactions → Import
7. Categorize AI suggestions pre-applied Manual categorization required
Time required 2–3 minutes 10–20 minutes
3

5 Most Common Import Errors (and Exact Fixes)

Import failures follow predictable patterns. These are the five errors accountants encounter most often, and the precise fix for each.

Error: "Date format not recognized"

Cause: Your CSV has DD/MM/YYYY but the software expects MM/DD/YYYY (or vice versa).
Fix: Zera Books auto-detects and standardizes date format to match your target software's requirement. No manual reformatting.

Error: "Duplicate transactions already exist"

Cause: The date range overlaps with transactions already imported in a previous session.
Fix: Zera Books duplicate detection flags transactions that already exist in your account before import. Filter to new-only transactions.

Error: "Invalid amount format"

Cause: Amounts have currency symbols ($, £), comma separators (1,234.56), or parentheses for negatives (1,234.56).
Fix: Zera Books strips all formatting and converts to plain decimal (1234.56) in every export.

Error: "Account not found"

Cause: QBO file header references an account number not in QuickBooks.
Fix: Zera Books generates QBO headers that match your connected QuickBooks account. The account number is pulled from your QBO OAuth connection.

Error: "File encoding error"

Cause: The CSV was saved in UTF-16 or ANSI but the software expects UTF-8 (or vice versa), causing special characters to display as garbage.
Fix: Zera Books exports in the correct encoding for each target software automatically.

Import-Ready Files for Every Accounting Platform

Zera Books generates import-ready files for every major accounting software. Zero format errors, zero manual column mapping.

Try for one week →
4

Xero Bank Statement Import: Complete Guide

Xero's import process differs from QuickBooks in a few important ways. Xero uses a bank feed model — imported transactions go into the bank feed for matching, not directly to the ledger.

Xero Import Column Required? Format Notes
DateRequiredDD/MM/YYYYXero accepts multiple formats but DD/MM/YYYY is safest
AmountRequiredDecimal (-100.00)Negative = money out (debit), positive = money in (credit)
PayeeOptionalTextAppears as contact in Xero — useful for matching
DescriptionOptionalTextBank transaction description
ReferenceOptionalTextCheck number or payment reference
BalanceOptionalDecimalRunning balance — Xero uses this to verify no missing transactions
5

Import FAQs

How do I import a bank statement into QuickBooks Online?
Go to Banking → Upload Transactions. Select your QBO or CSV file. Map columns if using CSV (not needed for QBO format). Review and categorize transactions. Zera Books QBO exports skip the mapping step entirely.
What format does Xero accept for bank statement import?
Xero accepts CSV files with specific column headers: Date, Amount, Payee, Description, Reference, Cheque Number, Balance. The date format DD/MM/YYYY is most reliable. Zera Books exports Xero-formatted CSV files that import without errors.
Why does my bank statement import fail in QuickBooks?
The most common causes are: wrong date format (QBO requires YYYYMMDD), combined debit/credit amounts instead of separate columns, missing account number in the header, or transactions that overlap with an already-imported date range.
Can I import multiple bank accounts in one file?
No — QuickBooks and Xero both require separate import files per account. Zera Books automatically detects multiple accounts in a single PDF and generates separate files for each, labeled by account number and type.