OFX / QIF / QFX to CSV / XLSX
Convert bank & Quicken statements into clean accounting spreadsheets — 100% private client-side processing.
Active Converter
OFX / QIF / QFX to Excel / CSV: Converting Bank & Credit Card Statements Locally
Technical Anatomy of OFX, QFX & QIF Banking Files
Financial institutions expose downloadable transaction histories in three dominant interchange formats: OFX (Open Financial Exchange, created by CheckFree, Intuit, and Microsoft), QFX (Intuit's Quicken Web Connect flavor of OFX), and legacy QIF (Quicken Interchange Format).
OFX 1.x uses SGML tags without mandatory closing tags (for example, <TRNAMT>-129.50 inside a <STMTTRN> block), preceded by key-value headers such as OFXHEADER:100. OFX 2.x upgrades the structure to strict XML with explicit closing tags. Each transaction carries <TRNTYPE> (DEBIT/CREDIT/POS), <DTPOSTED> (YYYYMMDDHHMMSS), <TRNAMT>, <FITID> (Financial Institution Transaction ID), <NAME>, and <MEMO>. By contrast, QIF opens with an account header like !Type:Bank and emits one field per line: D (Date), T (Amount), P (Payee), M (Memo), terminated by a caret (^).
Raw OFX SGML Statement vs. Converted Excel Ledger
# Input: Bank Statement Export (checking_q4.ofx)
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20261118120000
<TRNAMT>-420.00
<FITID>202611180001
<NAME>AWS CLOUD SERVICES
<MEMO>Monthly Hosting Invoice
</STMTTRN>
# Converted Excel / CSV Output:
Date,Type,Amount,Name,Memo,FITID
"20261118","DEBIT","-420.00","AWS CLOUD SERVICES","Monthly Hosting Invoice","202611180001"
Real-World Software & Hardware Ecosystem
Bookkeepers, CPAs, and small-business owners extract .ofx, .qfx, and .qif files from Chase, Bank of America, HSBC, Barclays, BNP Paribas, Wise, and American Express, then convert them to Excel or CSV for reconciliation in Microsoft Excel, QuickBooks Online, Xero, Wave, GnuCash, or local tax-filing templates.
Troubleshooting & Edge Cases
- Unclosed SGML Tags in OFX 1.02: Standard XML parsers crash on older bank
.ofxfiles because leaf nodes like<TRNAMT>-50.00lack closing tags. Our custom SGML-aware tokenizer handles both OFX 1.x and XML OFX 2.x reliably. - Ambiguous QIF Date Formats (MM/DD/YY vs. DD/MM/YY): QIF does not embed a locale header, so US banks emit
11/20/26while European banks emit20/11/26. Check your date column in Interactive Table view before running Excel date formulas. - Batching 12 Monthly Statements: Drop all 12 monthly
.ofxfiles at once to convert your entire fiscal year into a single Batch ZIP archive.
Banking Format Comparison: OFX 1.x vs. OFX 2.x vs. QIF
| Feature | OFX 1.02 / QFX (SGML) | OFX 2.2 (XML) | QIF (Legacy Quicken) |
|---|---|---|---|
| Syntax Style | Unclosed SGML tags + header block | Strict XML with closing tags | Single-letter prefixes (D/T/P/M/^) |
| Duplicate Protection | Unique <FITID> per transaction | Unique <FITID> per transaction | None (risk of double-counting) |
| Date Ambiguity | Unambiguous YYYYMMDD | Unambiguous YYYYMMDD | Locale-dependent (MM/DD vs. DD/MM) |
Year-End CPA Bank Reconciliation Checklist
- Download All 12 Monthly Statements: Grab your bank's
.ofxor.qfxexports (avoiding PDF statements whose OCR tables frequently misread minus signs). - Batch-Convert the Entire Fiscal Year: Select all 12 files in the uploader above and click Convert All & Download ZIP to produce uniform CSV ledgers in one pass.
- Verify Opening + Net Flow = Closing Balance: In Excel, run
=SUM(C2:C500)on theAmountcolumn and compare against your statement's ending balance before categorizing tax-deductible expenses. - Audit Duplicate FITIDs: If overlapping date windows were exported from online banking, use Excel's Remove Duplicates on the
FITIDcolumn to guarantee zero double-counted deductions.
Handling Multi-Currency Statements & Pending Authorizations
Corporate Wise, Revolut, and international bank accounts often export separate .ofx ledgers per currency (USD, EUR, GBP, MAD), embedding the ISO 4217 currency tag inside <CURDEF>. Remember that OFX <STMTTRN> blocks reflect only settled (posted) transactions—pending credit card holds will appear in next month's download with their finalized settlement date. Keeping one Excel tab per currency and reconciling against the <LEDGERBAL><BALAMT> closing balance ensures clean, audit-ready books for quarterly VAT and annual corporate tax filings.
Frequently Asked Questions
QIF (Quicken Interchange Format) is a legacy plain-text format using single-letter line prefixes (D for date, T for amount, P for payee, ^ for end of record). OFX (Open Financial Exchange) is a structured SGML/XML banking standard with unique FITID transaction IDs; QFX is Intuit's Web Connect variant of OFX with an INTU.BID bank tag.
Accounting suites like QuickBooks Desktop, Quicken, GnuCash, and Xero rely on OFX's unique FITID keys to prevent importing duplicate transactions during monthly bank feeds. Converting OFX/QFX to Excel gives accountants and auditors full spreadsheet visibility without paying for proprietary middleware.
Negative values (e.g., -245.80) represent debits, withdrawals, or card purchases, while positive values represent deposits and incoming wire transfers—allowing immediate SUM() and pivot-table reconciliation in Excel.
No. The OFX/QIF/QFX parser runs strictly inside your browser's local JavaScript runtime. Your bank statements and financial records never touch any external server.