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

July 14, 2026

I used to dread tax season, and it wasn't because of the math. It was the bank statements. Every year I'd log into my bank accounts, download whatever format they offered, and then spend hours trying to get that data into a spreadsheet or accounting tool that would actually use it. I had statements in OFX from one bank, QFX from another, CSV exports that were formatted differently 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 developed back in the late 90s by Intuit, Microsoft, and CheckFree to let financial institutions exchange data in a consistent way. OFX files are structured and contain not just transaction data but also metadata like account numbers, balances, and date ranges. Most major banks in the US and Canada support OFX downloads.

QFX is Quicken's variant of OFX. It follows the same basic structure but adds some Quicken-specific fields and formatting quirks. If you use Quicken, QFX is the format you want because it imports cleanly with all the categories and tags intact. If you're trying to open a QFX file in anything else, you might run into issues because some software expects the standard OFX structure.

QBO is QuickBooks Online's format. It's another OFX variant, this one tailored for QuickBooks. QBO files look similar to OFX on the surface, but they use different headers and some unique tags. QuickBooks handles them perfectly, but other applications may not recognize them.

CSV is the wildcard. It's not a financial format at all — it's just Comma Separated Values, a generic way to store tabular data. CSV files from different banks look completely different. One bank might put dates in the first column, while another puts descriptions first. One might include running balances, another might not. 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.