Bank Statement File Formats Explained: PDF, CSV, Excel, QBO, OFX, QFX

Banks send statements in PDF format, but accounting software and spreadsheets need CSV or Excel. Understanding file formats helps you choose the right conversion pathway and avoid compatibility issues.

---

Bank Statement Format Overview

Format Comparison Table

---

PDF (Portable Document Format)

What is PDF?

PDF is a read-only format designed for viewing and printing documents. Banks send statements as PDFs to preserve formatting and prevent tampering.

Created by: Adobe (1993)

File extension: .pdf

Opens in: Adobe Reader, Preview (Mac), Chrome, Edge, all browsers

---

PDF Characteristics

Pros:

• ✅ Universal: Opens on any device
• ✅ Preserves formatting (logos, tables, fonts)
• ✅ Secure: Can be password-protected
• ✅ Small file size (compressed)

Cons:

• ❌ Not editable (can't modify transaction data)
• ❌ Can't import into accounting software directly
• ❌ Data locked in document structure (not in spreadsheet rows)
• ❌ Difficult to analyze (can't sort, filter, or sum transactions)

---

When Banks Use PDF

All banks send PDFs:

• Monthly email statements
• Online banking downloads
• Archived statements
• Tax documents (1099-INT, etc.)

Why banks use PDF:

• Prevents customers from altering transaction history
• Consistent appearance across devices
• Official document format for legal/tax purposes
• Smaller file size than image scans

Learn more: Why Bank Statement PDFs Are Hard to Work With →

---

How to Convert PDF

PDF to CSV (Most Common): Convert PDF Bank Statements to CSV →

PDF to Excel: Convert PDF Bank Statements to Excel →

PDF to Google Sheets: Convert PDF to Google Sheets →

Scanned PDFs (Image-Based): Convert Scanned Bank Statements to CSV →

---

CSV (Comma-Separated Values)

What is CSV?

CSV is a plain-text format where each line is a row and commas separate columns. It's the universal format for importing data into accounting software and spreadsheets.

Created by: IBM (1972, for mainframe data transfer)

File extension: .csv

Opens in: Excel, Google Sheets, Numbers, all accounting software, text editors

---

CSV Characteristics

Pros:

• ✅ Universal: Works with all software
• ✅ Editable: Open in Excel, modify before importing
• ✅ Lightweight: Plain text, smallest file size
• ✅ Imports into QuickBooks, Xero, Zoho, all accounting software
• ✅ Easy to troubleshoot: Open in Notepad/TextEdit to see raw data

Cons:

• ❌ No formatting: No bold, colors, or fonts
• ❌ No formulas: Just raw values
• ❌ Single sheet: Can't have multiple tabs like Excel
• ❌ Special characters can break: Commas in descriptions require quotes

---

CSV Structure Example

Simple bank statement CSV:

Date,Description,Amount
01/15/2026,Amazon Purchase,-50.00
01/16/2026,Salary Deposit,3000.00
01/17/2026,Starbucks,-5.50

Debit/Credit column format (Xero, Zoho):

Date,Description,Debit,Credit
01/15/2026,Amazon Purchase,50.00,
01/16/2026,Salary Deposit,,3000.00
01/17/2026,Starbucks,5.50,

With check numbers and balance:

Date,Description,Check Number,Amount,Balance
01/15/2026,Amazon Purchase,,"-50.00",2450.00
01/16/2026,Salary Deposit,,"3000.00",5450.00
01/17/2026,Check #1234,1234,"-150.00",5300.00

---

When to Use CSV

Best for:

• ✅ Importing into QuickBooks, Xero, Zoho
• ✅ Excel/Sheets analysis (pivot tables, sorting, filtering)
• ✅ Batch processing multiple statements
• ✅ Merging transactions from multiple banks
• ✅ Accountants processing client data

Not ideal for:

• ❌ Sharing final reports (use Excel or PDF instead)
• ❌ Complex calculations (use Excel for formulas)
• ❌ Visual presentation (no charts, formatting)

---

CSV Import Guides by Software

Accounting Software:

• Import CSV into QuickBooks →
• Import CSV into Xero →
• Import CSV into Zoho Sheet →

Spreadsheet Analysis:

• Reconcile in Excel →
• Merge Multiple CSVs →

---

Excel (XLSX)

What is Excel (XLSX)?

Excel is Microsoft's spreadsheet format, supporting formulas, formatting, charts, and multiple sheets. More powerful than CSV but less compatible with accounting software.

Created by: Microsoft (1987 for .xls, 2007 for .xlsx)

File extension: .xlsx (modern), .xls (legacy)

Opens in: Microsoft Excel, Google Sheets, LibreOffice, Numbers

---

Excel Characteristics

Pros:

• ✅ Formulas: SUM, VLOOKUP, pivot tables, conditional formatting
• ✅ Multiple sheets: Track multiple accounts in one file
• ✅ Charts & graphs: Visualize spending trends
• ✅ Formatting: Colors, bold, cell styles
• ✅ Protection: Lock cells, password-protect sheets

Cons:

• ❌ Limited accounting software support (most want CSV)
• ❌ Larger file size than CSV
• ❌ Version compatibility issues (.xls vs .xlsx)
• ❌ Formulas break when importing into software

---

When to Use Excel

Best for:

• ✅ Advanced analysis (pivot tables, VLOOKUP, charts)
• ✅ Multi-account tracking (one sheet per bank)
• ✅ Internal reports with formatting and charts
• ✅ Reconciliation with formulas
• ✅ Expense categorization with conditional formatting

Not ideal for:

• ❌ Direct import to QuickBooks/Xero (convert to CSV first)
• ❌ Sharing with non-Excel users (compatibility issues)
• ❌ Large datasets (100K+ rows—use CSV or database)

---

Excel Conversion Guides

PDF to Excel: How to Convert PDF Bank Statement to Excel →

Excel to CSV (for accounting software):

1. Open Excel file
2. File → Save As
3. Format: CSV (Comma delimited) (*.csv)
4. Click Save

Excel Reconciliation: How to Reconcile Bank Statements in Excel →

---

QBO (QuickBooks Online Format)

What is QBO?

QBO is QuickBooks' proprietary format for importing bank transactions. Despite the name "QuickBooks Online," it only works with QuickBooks Desktop (not QuickBooks Online).

Created by: Intuit (for QuickBooks Desktop)

File extension: .qbo

Opens in: QuickBooks Desktop only (Pro, Premier, Enterprise)

---

QBO Characteristics

Pros:

• ✅ Zero-click import: Drag/drop into QuickBooks Desktop
• ✅ No column mapping required
• ✅ Preserves transaction IDs (better duplicate detection)
• ✅ Includes bank routing info

Cons:

• ❌ QuickBooks Desktop only (doesn't work with QB Online)
• ❌ Can't preview data before import (binary format)
• ❌ Can't edit transactions before import
• ❌ Not compatible with Xero, Zoho, Wave, etc.

---

When to Use QBO

Best for:

• ✅ QuickBooks Desktop users who want simplest import
• ✅ Accountants using QB Desktop with many clients
• ✅ Businesses already using .qbo downloads from banks

Not recommended for:

• ❌ QuickBooks Online users (use CSV instead)
• ❌ Xero, Zoho, Wave users
• ❌ Anyone who wants to preview/edit data before import

---

QBO vs CSV

Recommendation: Use CSV unless you're a QuickBooks Desktop power user who values zero-click import.

---

How to Get QBO Files

Option 1: Convert PDF to QBO Some converters (including Data River) can output QBO format from PDF bank statements.

Option 2: Download from Bank Few banks offer .qbo downloads directly (most offer CSV or OFX instead).

Learn more: Bank Statement Formats Explained →

---

OFX (Open Financial Exchange)

What is OFX?

OFX is an open standard for exchanging financial data between banks and software. More compatible than QBO but less common than CSV.

Created by: Microsoft, Intuit, CheckFree (1997)

File extension: .ofx

Opens in: Xero, QuickBooks Desktop, Wave, MYOB, Quicken (NOT QuickBooks Online)

---

OFX Characteristics

Pros:

• ✅ Multi-software compatibility (Xero, QB Desktop, Wave, MYOB)
• ✅ Standardized format (unlike QBO)
• ✅ Includes transaction IDs for duplicate detection
• ✅ Supports multi-currency transactions
• ✅ Bank account metadata included

Cons:

• ❌ Can't preview (XML-based, not human-readable)
• ❌ Can't edit before import
• ❌ QuickBooks Online doesn't support it
• ❌ Some banks generate broken OFX files

---

When to Use OFX

Best for:

• ✅ Xero users (Xero prefers OFX over CSV)
• ✅ QuickBooks Desktop users
• ✅ Wave Accounting users
• ✅ MYOB users (Australia)
• ✅ Multi-currency transactions

Not recommended for:

• ❌ QuickBooks Online users (use CSV)
• ❌ Zoho Books users (no OFX support)
• ❌ Users who want to preview/edit data

---

OFX vs CSV

Recommendation: Use OFX for Xero if your bank provides it. Otherwise, CSV is more flexible.

---

QFX (Quicken Financial Exchange)

What is QFX?

QFX is Quicken's proprietary format (essentially renamed OFX). It only works with Quicken, not QuickBooks or other accounting software.

Created by: Intuit (for Quicken personal finance software)

File extension: .qfx

Opens in: Quicken only

---

QFX Characteristics

Pros:

• ✅ Zero-click import for Quicken users

Cons:

• ❌ Quicken only (doesn't work with QuickBooks, Xero, etc.)
• ❌ Personal finance focus (not business accounting)
• ❌ Can't preview or edit

---

When to Use QFX

Best for:

• ✅ Quicken users tracking personal finances

Not for:

• ❌ Business accounting (use QuickBooks, Xero, Wave)
• ❌ Any software other than Quicken

Note: QFX is for Quicken (personal finance). QBO is for QuickBooks (business accounting). They are not interchangeable.

---

Conversion Pathways

PDF → CSV (Most Common)

Use case: Import into QuickBooks, Xero, Zoho, Excel

How to convert: Convert PDF Bank Statements to CSV →

Result: Universal format, editable, works with all software

---

PDF → Excel

Use case: Advanced analysis, pivot tables, charts

How to convert: Convert PDF Bank Statement to Excel →

Result: Formulas, formatting, multi-sheet support

---

PDF → QBO

Use case: QuickBooks Desktop zero-click import

How to convert: Use converter that supports QBO output

Result: Drag/drop import into QB Desktop

---

PDF → OFX

Use case: Xero, Wave, MYOB import

How to convert: Use converter that supports OFX output

Result: Import with transaction IDs for duplicate detection

---

Excel → CSV

Use case: Convert Excel analysis to accounting software format

How to convert:

1. File → Save As
2. Format: CSV (Comma delimited)
3. Save

Note: Formulas convert to values, formatting is lost

---

CSV → Excel

Use case: Add formulas, formatting, charts to CSV data

How to convert:

1. Open CSV in Excel
2. File → Save As
3. Format: Excel Workbook (*.xlsx)
4. Save

Result: Editable Excel file with formula support

---

❌ CSV/Excel → PDF (Not Recommended)

Why not: Converting back to PDF loses editability. Only do this for final reports or archiving.

How: Excel → File → Export → Create PDF/XPS

---

Format Selection Guide

Choose CSV if you need to:

• ✅ Import into any accounting software
• ✅ Edit data before import
• ✅ Merge transactions from multiple banks
• ✅ Share data with accountants/bookkeepers
• ✅ Smallest file size

Recommended for: 90% of users

---

Choose Excel if you need to:

• ✅ Advanced analysis (pivot tables, VLOOKUP, charts)
• ✅ Reconciliation with formulas
• ✅ Multi-account tracking (one sheet per bank)
• ✅ Internal reports with formatting

Recommended for: Financial analysis, reconciliation

---

Choose QBO if you need to:

• ✅ Zero-click import into QuickBooks Desktop
• ✅ Better duplicate detection (transaction IDs)

Recommended for: QuickBooks Desktop power users only

---

Choose OFX if you need to:

• ✅ Xero import (Xero prefers OFX)
• ✅ Multi-currency support
• ✅ Transaction IDs for Wave, MYOB

Recommended for: Xero users, multi-currency businesses

---

Choose PDF if you need to:

• ✅ Official archive (legal/tax purposes)
• ✅ Print physical copies
• ✅ Share read-only statements

Recommended for: Archiving only (not for analysis)

---

Technical Details

Why PDFs Are Hard to Convert

Why Bank Statement PDFs Are Hard to Work With →

PDF challenges:

• Text may be images (requires OCR)
• Tables may not have cell boundaries
• Multi-line descriptions split incorrectly
• Check images disrupt table structure
• Each bank uses different layouts

---

Multi-Page Statements

How to Handle Multi-Page Bank Statements →

Multi-page challenges:

• Page headers/footers repeat
• Balances carried forward across pages
• Transactions split mid-table

Solution: AI-powered converters automatically handle multi-page statements, merging transactions across pages.

---

OCR vs AI for Processing

OCR vs AI for Bank Statement Processing →

OCR (Optical Character Recognition):

• Template-based (breaks when format changes)
• Requires manual table boundary definition
• Fails on scanned/image PDFs

AI-Powered Conversion:

• Adapts to any format automatically
• Handles scanned PDFs
• Learns from bank-specific quirks

---

Format-Specific Guides

PDF Conversion

• PDF to Excel (Step-by-Step) →
• PDF to CSV (Online) →
• PDF to Google Sheets →
• Scanned PDFs to CSV (OCR) →

Multi-Format Handling

• All Formats Explained (PDF, CSV, OFX, QBO) →
• Multi-Page Statements →
• Extract Transactions from PDFs →

---

Next Steps

By Bank

Different banks offer different export formats: Convert Bank Statements by Bank →

By Software

Match format to your accounting software: Convert Bank Statements by Software →

Troubleshooting

Common format-related errors: Common Errors in Bank Statement Conversion →

---

Frequently Asked Questions

Can I convert Excel to PDF?

Yes, but you lose editability. Only convert to PDF for final reports or archiving. Excel → File → Export → Create PDF/XPS. For accounting software, use CSV instead.

Which format is best for tax purposes?

PDF for official records (IRS accepts PDFs). Excel or CSV for tax preparation software (easier to categorize expenses, calculate deductions). Keep both—PDF for archive, CSV for tax software import.

Can I import Excel files into QuickBooks?

QuickBooks Online: No, CSV only. QuickBooks Desktop: Yes, but CSV is recommended (better compatibility). Convert Excel to CSV: File → Save As → CSV.

What's the difference between .xls and .xlsx?

.xls: Legacy Excel format (pre-2007), limited to 65,536 rows. .xlsx: Modern Excel format (2007+), supports 1+ million rows, smaller file size. Always use .xlsx unless you need compatibility with Excel 2003.

Why do some CSVs open incorrectly in Excel?

Cause: Date format mismatches, regional settings (comma vs semicolon separator), encoding issues. Fix: Excel → Data → From Text/CSV → Set delimiter and encoding manually. Or save CSV as UTF-8 in text editor first.

Can I convert QBO to CSV?

Technically yes, using third-party tools. But QBO is meant for direct QuickBooks Desktop import. If you need CSV, convert the original PDF to CSV instead (better data quality).

What format do banks use for electronic statements?

Email statements: Always PDF. Online banking downloads: PDF (all banks), CSV (some banks like TD Bank, Citi), OFX (rare). Bank feeds (API): OFX or custom API format (handled automatically by software).