How to Export Bank Transactions for Accounting Software: A Complete Guide

The Problem: Every Bank Does It Differently

Every major bank offers some way to export transaction data. Chase, Bank of America, Wells Fargo, and credit unions all have export options — but they use different formats, different date ranges, and different levels of transaction detail. Getting that data cleanly into your accounting software takes knowing the right format for your combination of bank and software.

The Four Common Export Formats

OFX (Open Financial Exchange)

The gold standard for accounting import. Structured XML-like format that includes transaction date, amount, description, and a unique transaction ID. Supported by QuickBooks Desktop, QuickBooks Online, Sage, and most serious accounting platforms. When available, always prefer OFX over CSV.

QBO (QuickBooks Online format)

Proprietary Intuit format that imports directly into QuickBooks with better matching. If you use QuickBooks and your bank offers QBO, use it — it reduces duplicate detection errors and preserves more transaction metadata than CSV.

QFX (Quicken format)

Similar to OFX but with Quicken-specific extensions. Use for Quicken imports; most other platforms accept OFX instead.

CSV (Comma Separated Values)

The most universally available but least structured. Every bank's CSV has different column ordering — date might be column 1 at Chase and column 3 at Bank of America. Requires mapping when importing. Works with everything but needs cleanup.

Bank-by-Bank Export Instructions

Chase

Online Banking → Accounts → Download Activity → Select date range → Choose format (CSV, OFX, or QBO) → Download. QBO available for QuickBooks users. Go back up to 7 years of history.

Bank of America

Online Banking → Accounts → Download → Select account → Date range → Format (CSV, Microsoft Money OFX, Quicken QFX, or QuickBooks QBO). Up to 18 months in standard interface.

Wells Fargo

Account Summary → Download Account Activity → Date range → Format (CSV, QFX, OFX, or QBO). Up to 2 years.

Capital One

Account → Download Transactions → CSV or OFX. Note: Capital One's OFX sometimes requires manual date range entry for business accounts.

Importing Into QuickBooks Online

1. Banking → Upload transactions → Drag and drop file
2. Map columns (for CSV): Date, Description, Amount, Account
3. Review and categorize imported transactions
4. QuickBooks learns your categorization patterns over time

QBO/OFX imports skip the column mapping step and auto-match against existing transactions.

Importing Into Xero

1. Accounting → Bank Accounts → Import a Statement
2. Upload OFX, QFX, QBO, or CSV
3. For CSV: define column mapping (Xero remembers your mapping for future imports)
4. Reconcile: match imported transactions against invoices, bills, and manual entries

When Your Bank Doesn't Export OFX

Some smaller banks and credit unions only export CSV — or worse, only provide PDF statements. If you're dealing with PDF-only statements:

1. Use statementocr.com to extract all transactions from the PDF into structured CSV
2. Clean the CSV (consistent date format, positive/negative amounts)
3. Import to your accounting software using the CSV method above

This workflow handles the last mile — turning PDF bank statements into clean, importable transaction data without manual re-entry.

Dealing with Duplicate Transactions

The biggest risk when importing bank data: duplicates from overlapping date ranges. Always import in sequential non-overlapping periods, and use the "Exclude" function in QuickBooks/Xero to mark already-processed transactions before confirming imports.