Convert CSV to OFX
Your bank gives you CSV but your software needs OFX. Upload the CSV, get a clean OFX file that Quicken, GnuCash, and Moneydance import without errors.
For Quicken, GnuCash, Moneydance, Xero, and Sage users. Free online — no software to install.
How It Works
Upload Your CSV
Bank export, credit card download, or any CSV with transaction data — any column layout, any delimiter.
Columns Auto-Mapped
Date, description, and amount fields detected automatically. Account ID and bank routing set for OFX compatibility.
Download OFX
Valid Open Financial Exchange file ready for Quicken, GnuCash, Moneydance, Xero, or Sage. Import directly.
Software That Accepts OFX Files
OFX is the universal standard for financial data exchange. Unlike QBO (QuickBooks-only) or QFX (Quicken-only), OFX works across dozens of accounting and personal finance applications.
What is CSV?
Comma-Separated Values
Plain-text bank export with no standard layout. Every bank uses different column names, date formats, and amount styles. Most accounting software can read CSV — but requires manual column mapping every time.
What is OFX?
Open Financial Exchange
XML-based standard for financial data exchange. Includes account metadata, transaction IDs, and structured fields that Quicken, GnuCash, Moneydance, Xero, and Sage read automatically — no mapping required.
Why This Tool
Quicken-Ready Headers
Includes INTU.BID and ORG institution identifiers that Quicken requires. Without these, Quicken rejects OFX files with a "download error."
Auto-Detect Any CSV Layout
Date/Amount/Description, Datum/Betrag/Beschreibung, or custom headers — columns identified regardless of naming or language.
Valid FITID Generation
Every transaction gets a unique Financial Transaction ID. Duplicate FITIDs cause GnuCash parse errors and Quicken import failures.
Account Metadata Built In
Bank ID, Account ID, and Account Type fields set automatically. These OFX-required fields are what most CSV-to-OFX tools leave for you to configure manually.
Handles Messy CSVs
Commas in amounts, currency symbols, blank rows, mixed delimiters, quoted fields — cleaned and normalized before OFX output.
Works Across All Platforms
OFX files import identically on Windows, Mac, and Linux. No line-ending issues that plague CSV imports across operating systems.
When to Use This
Bank Dropped OFX Downloads
Chase, Discover, and others discontinued direct OFX/QFX exports. Download CSV from your bank and convert here — your Quicken workflow stays the same.
GnuCash & Moneydance Users
Both support CSV import but require manual column mapping. OFX imports are automatic — File > Import > OFX and transactions appear instantly.
Xero & Sage Bank Import
Need to import bank transactions from a CSV into Xero or Sage? OFX gives cleaner auto-matching than raw CSV uploads.
How to Import OFX Into Your Software
Quicken
File > Import > Web Connect (.OFX) > select your file > map to account. Quicken reads the institution headers and imports transactions into bank feeds.
GnuCash
File > Import > Import OFX/QFX > select your file. GnuCash matches the account ID automatically. Use Tools > Import Map Editor if accounts map incorrectly.
Xero
Accounting > Bank Accounts > select account > Import a Statement > upload .ofx file. Xero auto-matches transactions to existing rules.
Common OFX Import Errors and Fixes
Quicken "download error" when importing OFX
Quicken expects institution identifiers (INTU.BID, ORG) in OFX files. Without them, it treats the file as a failed bank download. Our converter includes these headers automatically.
Quicken R6025 runtime error on import
Crashes when OFX is missing Quicken-specific QFX fields. Our output includes all required Quicken headers so this error doesn't occur.
GnuCash "failed to parse" or wrong account mapping
Usually caused by mismatched account numbers or non-unique transaction IDs (FITIDs). We generate unique FITIDs and set valid account metadata.
Transactions imported with wrong dates (day/month swapped)
OFX uses YYYYMMDD date format internally. Some converters misparse DD/MM as MM/DD. We auto-detect your CSV's date format and convert correctly.
Duplicate transactions appearing after import
Caused by importing a date range already in your software. Most OFX-compatible apps use FITIDs to detect duplicates — our unique IDs help, but avoid overlapping date ranges.
Frequently Asked Questions
Why convert CSV to OFX instead of importing CSV directly?
Quicken cannot import CSV at all — it only accepts QFX/OFX. GnuCash and Moneydance support CSV but require tedious column mapping each time. OFX imports are automatic with no mapping needed.
Quicken shows a "download error" when I import the OFX file — why?
Quicken expects institution identifiers (INTU.BID, ORG) inside OFX files. Without them, Quicken treats the file as a failed bank download. Our converter includes these fields so Quicken accepts the file cleanly.
Does this work with Quicken Mac and Windows?
Yes. Quicken Mac technically requires QFX, which is OFX with Quicken-specific headers. Our output includes those headers so it works on both platforms.
My bank stopped offering OFX downloads — can I use CSV instead?
Exactly what this tool is for. Chase, Discover, and other banks have dropped direct OFX/QFX downloads. Export CSV from your bank and convert it here.
GnuCash gives a parse error on import — what went wrong?
Usually a mismatch between the account number in the OFX file and your GnuCash account setup. Also check that transaction IDs (FITIDs) are unique. Our converter generates valid FITIDs automatically.
What account details do I need to set?
Account ID (your account number) and account type (checking, savings, credit card). We set sensible defaults, but matching your software's account setup ensures smooth import.
Can I import the OFX file into Xero or Sage?
Yes. Xero: go to Accounting > Bank Accounts > Import a Statement. Sage: Banking > Import Statement. Both accept standard OFX files.
Other converters charge $25-50/month. Is this free?
Yes. MoneyThumb CSV2OFX starts at $25/month, ProperConvert requires a desktop install. We convert free online, no signup, no install.
Is my data secure?
Encrypted in transit, processed in memory, never stored. Your CSV is deleted after conversion.
Related Tools
CSV to QBO
Convert CSV financial files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →CSV to QIF
Convert CSV financial files to QIF for Quicken. Auto-detects columns and preserves categories if present in your data. Free, instant, no signup required.
Convert now →PDF to OFX
Convert bank statement PDFs to OFX for Quicken, GnuCash, Moneydance, and Microsoft Money. AI extracts all transactions accurately. Free online tool.
Convert now →CSV to QFX
Convert CSV financial files to QFX for Quicken Web Connect import. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →