QIF to OFX converter
Convert a QIF file to an OFX file 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
- QIF in, OFX out
01 / Why convert
For Xero, Sage, MYOB, GnuCash and other apps that prefer OFX to QIF.
02 / What carries over
From QIF to OFX, field by field.
What the QIF file can hold, and where it goes in the OFX file.
| In the QIF file | In the OFX 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) | Not in a QIF file |
| Running balance | Not in a QIF file |
| Account number | Not in a QIF file |
| Category | OFX has no place for it |
| Credit card (not a bank account) | Kept |
03 / Importing it
Importing the OFX file.
Xero
- Open the bank account, then Manage account, then Import a statement, and pick the .ofx file.
Sage, MYOB, GnuCash, Moneydance
- Look for Import statement, Import bank file or File, then Import, then OFX/QFX.
04 / The QIF file
Getting a QIF file.
Quicken Interchange Format, an older plain-text format. Quicken, GnuCash, Microsoft Money, Banktivity and MoneyWiz read it. It has no account numbers or transaction IDs.
- Quicken: File, then Export, then QIF File.
- GnuCash and Microsoft Money export QIF, and some banks still offer it as a download.
Have a bank statement PDF instead? The bank statement converter reads it in your browser too.
05 / Good to know
The details that matter.
- Quicken’s “Opening Balance” record becomes the opening balance, not a transaction. Investment registers and category lists are skipped, and a file with several accounts lets you pick one.
- Dates like 03/04/2026 can mean March or April. The order is worked out from the file (a day over 12 decides it), and you can switch it when nothing does.
- 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 QIF to OFX 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 QIF file uploaded anywhere?
No. The file is read and the OFX 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.
How are dates read?
QIF files write dates in the order of the program that made them (MM/DD in the US, DD/MM in most other places). The order is worked out from the dates themselves, and you can switch it in the panel when nothing in the file decides it.
Does it work for credit cards?
Yes. A card account in the QIF file stays a card account. You can also set the account type to Credit card in the panel, and the OFX 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.