OFX to QFX converter
Convert an OFX file to a Quicken Web Connect file (.qfx) in your browser: every transaction, with its date, payee, memo and amount. Your file never leaves your computer. 2 free a day, no sign-up.
No file to hand?
Convert to
Tally needs both ledger names exactly as they are in your company.
New company? Download the ledger setup file too and import it first (Import, then Masters).QuickBooks Desktop needs both account names exactly as they are in your chart of accounts.
QuickBooks makes any account it doesn’t know into a new bank account, so check the spelling.- Runs in your browser
- 2 free a day, no sign-up
- OFX in, QFX out
01 / Why convert
Quicken checks for Intuit’s bank id, which a plain OFX file lacks. This adds it, so Quicken imports the file as Web Connect.
02 / What carries over
From OFX to QFX, field by field.
What the OFX file can hold, and where it goes in the QFX file.
| In the OFX file | In the QFX file |
|---|---|
| Date | Kept |
| Amount (money in and out) | Kept |
| Payee or description | Payee (32 characters), full text in the memo |
| Memo (extra text) | Kept |
| Check or reference number | Kept |
| Bank’s transaction ID (FITID) | Kept |
| Running balance | Not in a OFX file |
| Account number | Kept |
| Currency | Kept |
| Credit card (not a bank account) | Kept |
03 / Importing it
Importing the QFX file.
Quicken for Windows
- File, then File Import, then Web Connect (.QFX) File.
- Link it to your existing account when Quicken asks.
Quicken for Mac
- File, then Import, then Bank or Brokerage File, and pick the .qfx file.
QuickBooks Online
- It takes .qfx files too: Link account, then Upload from file.
04 / The OFX file
Getting an OFX file.
Open Financial Exchange, the open bank-download format behind QBO and QFX. Xero, Sage, MYOB, GnuCash, Moneydance and most accounting apps read it.
- Online banking: Transactions, then Download, then OFX (or “Microsoft Money”). Common at banks outside the US.
Have a bank statement PDF instead? The bank statement converter reads it in your browser too.
05 / Good to know
The details that matter.
- A OFX file with several accounts (checking and savings in one download, say) lets you choose the account.
- OFX 1.x and 2.x are both read, along with the bank’s corrections to earlier transactions.
- The bank’s own transaction IDs are kept, so QuickBooks and Quicken still recognise transactions they downloaded before.
- Quicken may label the account “Wells Fargo”. Web Connect files need a bank id from Intuit’s list, and this is the one most converters use; the transactions are yours.
- Payee names are cut to 32 characters, the OFX limit QuickBooks enforces; the full text goes in the memo. Text is written as plain ASCII, which older importers need.
06 / Questions
Straight answers.
Is this OFX to QFX converter free?
Yes, for 2 files a day with no account. A free account (just your email, no password) gives you 2 more, and paid plans have no daily limit. It runs in your browser, and nothing is stored.
Is my OFX file uploaded anywhere?
No. The file is read and the QFX file is written by code running in this browser tab. Neither is sent to a server. You can check: open your browser’s developer tools, go to the Network tab, and convert a file.
Will Quicken import the same transactions twice?
No, as long as you import the same transactions: every transaction has an ID (FITID), and Quicken skips IDs it already has. The IDs from your bank’s file are kept.
My OFX file has several accounts. Which one is converted?
The first, until you choose another: when a file holds more than one account (checking and savings, say), the panel lists them all.
Does it work for credit cards?
Yes. A card account in the OFX file stays a card account. You can also set the account type to Credit card in the panel, and the QFX file is written as a card statement.
07 / More converters
Other files, same idea.
All of them run in your browser. For PDFs, start at the bank statement converter; every converter is on the converters page.