Bank Statement Formats Guide — OFX vs QFX vs QBO vs CSV vs PDF
A comprehensive reference for understanding bank statement file formats, their structures, and how to convert between them for accounting and personal finance.
Introduction to Bank Statement Formats
Bank statements are the primary record of financial transactions between an account holder and their financial institution. While paper statements have existed for centuries, digital bank statements have evolved into several distinct file formats, each designed for specific use cases, software compatibility, and regulatory requirements. Understanding these formats is essential for anyone who manages personal finances, runs a business, or works in accounting.
The five most common bank statement formats are PDF, OFX, QFX, QBO, and CSV. Each format has unique strengths and weaknesses. PDF statements are human-readable but difficult to process programmatically. OFX is the open standard for financial data exchange. QFX is Quicken's proprietary extension of OFX. QBO is QuickBooks' web connect format. CSV is the universal data interchange format that works with virtually all software. Choosing the right format depends on your accounting software, technical requirements, and the level of detail you need.
In this guide, we will explore each format in depth, compare their features, and provide practical advice for converting between them.
PDF Bank Statements
PDF (Portable Document Format) is the most widely used format for viewing and printing bank statements. Nearly every bank and credit union offers PDF statements through their online banking portals. PDFs preserve the visual layout of the statement, including the bank logo, account information, transaction table, and summary sections. This makes them excellent for human reading and archival purposes.
How Banks Generate PDF Statements
Banks generate PDF statements using template-based rendering engines. Transaction data is pulled from the bank's core banking system and merged into a PDF template. The resulting file includes formatted tables, headers, footers, and often encrypted metadata. Some banks produce searchable PDFs with embedded text, while others generate scanned-image PDFs that require optical character recognition (OCR) to extract text.
Challenges Parsing PDF Statements
Parsing PDF bank statements programmatically is notoriously difficult. PDF is a presentation format, not a data format. The same transaction data can be rendered in countless visual layouts. Different banks use different table structures, date formats, and column ordering. Some PDFs have merged cells, multi-line entries, or missing borders. Extracting data reliably requires sophisticated layout analysis, OCR for scanned statements, and bank-specific parsing rules. This is why dedicated tools like ConvertPivot's PDF Bank Statement to CSV converter use multiple strategies to handle diverse statement layouts.
OFX — Open Financial Exchange
OFX (Open Financial Exchange) is an open standard for exchanging financial data between financial institutions, accounting software, and consumers. It was introduced in 1997 by a consortium including Intuit, Microsoft, and CheckFree. OFX is based on SGML (Standard Generalized Markup Language) and uses a tag-based structure similar to XML. The format defines standard tags for transactions, account information, balances, and investment data.
OFX Structure
An OFX file begins with a header block that specifies the OFX version, security settings, encoding, and application information. The body contains SGML-style tags organized into aggregates. Key aggregates include SIGNONMSGSRSV1 for session authentication, BANKMSGSRSV1 for bank statement data, and CREDITCARDMSGSRSV1 for credit card transactions. Each transaction is wrapped in a STMTTRN aggregate with tags for type, date, amount, name, memo, and reference number.
How Banks Use OFX
Many banks provide OFX downloads through their online banking portals, though the option is often hidden behind "Download" or "Export" buttons. OFX is the preferred format for accounting software because it includes structured data that software can parse automatically. The format supports checking, savings, credit card, investment, and loan accounts. OFX files can be imported directly into Quicken, QuickBooks, Microsoft Money, GnuCash, and other financial software.
QFX — Quicken's OFX Variant
QFX is Quicken's proprietary extension of the OFX format. While it shares the same SGML-based structure as OFX, QFX adds Quicken-specific tags and metadata. The most visible difference is in the header: QFX files use a OFXHEADER:100 header with additional security and application identifiers. QFX also includes tags for Quicken categories, tags, splits, memorized payees, and account type mappings.
Key Differences Between OFX and QFX
The primary difference is that QFX includes Quicken-specific data extensions. Standard OFX parsers may not recognize these extensions, so QFX files are best handled by Quicken or specialized QFX converters. Conversely, Quicken can import standard OFX files, but some Quicken-specific features like investment lot tracking may not transfer. When converting QFX to CSV, the extra metadata is either preserved in additional columns or discarded depending on the converter.
QBO — QuickBooks Web Connect
QBO (QuickBooks Web Connect) is a file format used by QuickBooks for importing bank transactions directly from financial institutions. Despite the similar name, QBO is not related to QuickBooks Online (also called QBO). The QBO file format is essentially a modified OFX file with QuickBooks-specific tags and headers. Most US banks support QBO downloads, making it the standard format for QuickBooks reconciliation.
QBO Structure
A QBO file begins with a header similar to OFX but includes QuickBooks-specific version information. The body contains the same OFX aggregates with additional QuickBooks tags such as INTBIRATE for interest rate data and LEDGERBAL for ledger balances. QuickBooks uses these extra tags to match downloaded transactions against existing entries and to detect duplicate imports.
CSV — Comma-Separated Values
CSV is the simplest and most universal format for tabular data. A CSV bank statement is a plain text file where each line represents a transaction and fields are separated by commas. CSV files can be opened in any text editor, spreadsheet application, or accounting program. The downside is that CSV has no standard schema for bank data, so column headers vary between banks. Common columns include Date, Description, Amount, Type, and Balance. Some banks include check numbers, payee names, categories, and memo fields.
Pros and Cons of CSV
CSV's greatest strength is universality: every data processing tool supports CSV. Its greatest weakness is lack of standardization: importing CSV into accounting software often requires mapping columns manually. CSV also lacks the structured metadata of OFX, such as transaction IDs and account type indicators, which can lead to duplicate imports or incorrect categorization.
Comparison Table
| Format | Type | Best For | Pros | Cons |
|---|---|---|---|---|
| Document | Viewing, printing, archiving | Human-readable, universally supported, preserves layout | Difficult to parse, no structured data, requires OCR | |
| OFX | SGML | Accounting software import | Structured transaction data, open standard, wide support | Less common on consumer banking portals, older syntax |
| QFX | SGML | Quicken import | Quicken-specific metadata, category preservation | Proprietary extensions may not work in other software |
| QBO | SGML | QuickBooks import | Direct QuickBooks integration, duplicate detection | QuickBooks-specific, limited use outside Intuit ecosystem |
| CSV | Plain text | Universal data exchange | Works everywhere, human-readable, simple | No standard schema, manual column mapping, missing metadata |
When to Use Each Format
Choose PDF when you need to view, print, or archive your statement for record-keeping. Choose OFX or QBO when you are importing transactions into accounting or tax preparation software. Choose QFX specifically for Quicken if you want to preserve categories and tags. Choose CSV when you need to process data in a spreadsheet, upload to a custom system, or migrate between platforms. For maximum flexibility, download OFX alongside PDF from your bank: keep the PDF for records and use the OFX for data processing.
How to Convert Between Bank Statement Formats
Converting between formats depends on your starting format and target use case. ConvertPivot offers dedicated tools for each conversion path. Upload your file to the appropriate converter and download the result. For OFX to CSV, the converter extracts all transaction fields and writes them to a clean CSV with standardized column headers. For QFX and QBO, the converter handles the proprietary header differences and produces compatible output. For PDF bank statements, the converter performs OCR and layout analysis to reconstruct transaction data. Always verify a sample of converted transactions to ensure accuracy, especially when converting from PDF.