Bank Statement Formats Explained — OFX, QFX, QBO, CSV

July 14, 2026

I used to dread tax season, and honestly it wasn't the math that got me. It was the bank statements. Every year I'd log into my accounts, download whatever format they happened to offer, and then spend hours trying to jam that data into a spreadsheet or accounting tool. I had OFX from one bank, QFX from another, CSV exports that looked completely different depending on which account I downloaded from, and PDFs that might as well have been printed on paper for all the good they did me digitally.

Let's break down what these formats actually are. OFX stands for Open Financial Exchange. It's a standardized format that was cooked up back in the late 90s by Intuit, Microsoft, and CheckFree so financial institutions could exchange data consistently. OFX files are structured — they contain not just transactions but metadata like account numbers, balances, and date ranges. Most major US and Canadian banks support OFX downloads.

QFX is Quicken's take on OFX. Same basic structure, but with some Quicken-specific fields and formatting quirks thrown in. If you use Quicken, QFX is what you want — it imports cleanly with all your categories and tags intact. Try opening a QFX file in anything else, though, and you might hit issues since some software expects the standard OFX structure.

QBO is QuickBooks Online's format. Another OFX variant, this one built for QuickBooks. QBO files look similar to OFX on the surface, but they use different headers and some unique tags. QuickBooks handles them perfectly. Other apps? Not so much.

CSV is the wildcard here. It's not a financial format at all — it's just Comma Separated Values, a generic way to store tabular data. The problem is that CSV files from different banks look completely different. One bank puts dates in the first column, another puts descriptions first. One includes running balances, another doesn't. CSV is the most universally compatible format, but it's also the least standardized.

Here's what I've learned after years of wrestling with bank exports. If your accounting software supports OFX, use it. It's structured, reliable, and imports cleanly. If you use Quicken, QFX is your best friend. QuickBooks users should grab QBO. If you just want to get transaction data into a spreadsheet for manual work, CSV is the simplest path. And if your bank only offers PDF statements, you're in for a harder road — PDFs are designed for printing, not data exchange, and converting them requires extra steps.

The biggest mistake I made early on was downloading PDF statements and manually retyping transactions into my spreadsheet. It took hours and I always introduced errors. Now I know to look for the OFX or CSV download option first. Most banks offer it, but they hide it behind a few clicks. It's worth digging for.