Convert a bank CSV to OFX

OFX is the open bank-statement format read by GnuCash, Xero, Microsoft Money, Moneydance, YNAB and many other apps. Convert your CSV or Excel export to OFX 1.0.2 or OFX 2.2 without uploading it anywhere.

Runs 100% in your browser
No sign-up
Free for 10 transactions per file
Pro: $29 one-time

Drop your bank CSV or Excel (.xlsx) file here or click to choose a file. It is read by your browser and never uploaded.

1. Check how the file was read

Delimiter Header row (0 = no header) Date format in file Decimal separator Flip sign (money out ↔ money in)

Columns

Use either one signed Amount column, or separate Debit and Credit columns.

2. Review transactions

	Date	Description	Amount	Check #	Balance

3. Account details (written into the file)

Account type Account number (or any unique ID) Routing number / bank ID Currency INTU.BID (QBO/QFX only) Bank name (optional) Dates in QIF/CSV output

Use a different account number for each real account, and the same number every time you convert that account. QuickBooks and Quicken use it to recognise the account. See what INTU.BID means.

4. Download

Pro ($29 one-time): coming soon

The output follows the standard Web Connect (QBO/QFX) and OFX formats and has been checked with independent OFX parsers. Try the free 10-transaction export in your software before buying Pro ($29 one-time). If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. Refund policy

Which OFX version should I pick?

OFX 1.x (SGML) is the classic format most banks still use. It is the safest choice for older desktop software and for QuickBooks/Quicken-style importers.
OFX 2.x (XML) is well-formed XML. Pick it if your app asks for OFX 2 or if you want to process the file with XML tools.

Both files include the bank or credit card account block, a statement date range, a ledger balance (taken from the balance column when your CSV has one, otherwise 0.00), and a unique FITID for each transaction.

How to import an OFX file in common apps

GnuCash: File → Import → Import OFX/QFX, then match the account.
Xero: open the bank account, choose Manage Account → Import a Statement, and upload the .ofx file.
Moneydance: File → Import, choose the file, then pick the account.
Other apps: look for "Import statement", "File import" or "Web Connect/OFX" in the account or file menu.

Menu names change between versions; check your app's help if a step looks different.

FAQ

Does the OFX file contain my real bank details?

Only what you type in the account details box. The routing number and account number fields default to zeros; some apps use the account number to tell accounts apart, so a unique made-up number is fine.

Why are accented characters replaced?

OFX 1.x files are declared as ASCII, and several importers reject non-ASCII text even in OFX 2, so we convert é → e, ü → u and so on for compatibility.

Can I convert credit card statements?

Yes. Choose Credit card as the account type and the file is written with a credit card statement block (CCSTMTRS) instead of a bank statement.

Is my bank file uploaded anywhere?

No. The page reads the file with your browser's built-in file APIs and builds the output on your device. There is no server-side code: you can open your browser's developer tools, watch the Network tab while converting, and see that no file data is sent. See the privacy page.

Is it free?

Yes for up to 10 transactions per file in every format, with full preview and editing. Pro removes the limit for $29 one-time. Try the free export in your software first. If a file you export with Pro won't import into the software you made it for, you get a full refund within 30 days of purchase. See the refund policy.

QuickBooks and Quicken are trademarks of their respective owners (Intuit Inc. and Quicken Inc.). This site is independent and is not affiliated with, endorsed by, or sponsored by Intuit or Quicken. Product names are used only to describe file compatibility.