Free converter · QFX → OFX

Convert QFX to OFX

Convert a Quicken QFX download to a plain OFX statement for FreeAgent, Sage, Xero or GnuCash. Intuit tags removed, account number cut to the last 4, balance kept. Free up to 100 transactions.

Free up to 100 rowsColumns detected automaticallyFiles deleted after 1 hour
Processed in memory, never stored
No file handy? See the result on a fictional one first:

Only have a PDF statement? Use the PDF statement converter.

Why OFX?

A QFX is OFX with Intuit's Web Connect tags added. Most programs read it as it is, but some importers only take .ofx files, and a QFX carries your bank's routing number and full account number. Utilly reads each transaction and writes a clean OFX 1.02 statement with stable transaction IDs. Going to QuickBooks Desktop? Use QFX to QBO or QFX to IIF instead.

How to convert QFX to OFX

  1. Download the .qfx from your bank's website (often labelled Quicken or Quicken Web Connect), or use one you already have. A QuickBooks .qbo or an OFX 2 (XML) file works the same way.
  2. Drop it in the converter above. Posted dates, signed amounts and payees are read from every transaction; checking and savings statements are told apart from credit card statements.
  3. Check the preview. Money out should be negative. Leave Account last 4 or nickname empty to keep the last 4 digits from the QFX, or type a nickname so every monthly file lands on the same account ID.
  4. Download the .OFX and import it into the matching bank or card account (which programs want OFX).

What's different between QFX and OFX

The transactions are the same. The difference is the wrapper Quicken adds and the account details your bank puts in it. The top of our sample QFX:

<FI><ORG>Example Community Bank<FID>3000</FI><INTU.BID>3000

becomes this in the OFX:

<FI><ORG>Utilly</FI>
In the QFXIn the OFX
INTU.BID, INTU.USERID and the bank's FID (Intuit's Web Connect tags)Removed. These are what Quicken checks before importing; other programs don't need them.
BANKID (usually your bank's routing number)The placeholder 999999999.
ACCTID (the full account number)Only the last 4 digits, or the nickname you type. A QFX with ACCTID 123456780427 comes out as 0427.
LEDGERBAL (ending balance)The same balance and date, when it's dated on or after the last transaction and you haven't flipped the signs. Otherwise 0.00.
Bank (STMTRS) or credit card (CCSTMTRS) statementThe same kind of statement. Import a card file into a credit card account.
OFX 2 (XML) or OFX 1 (SGML) bodyAlways OFX 1.02 SGML, the version importers handle most widely.

Try renaming first

Because a QFX is OFX underneath, changing the extension from .qfx to .ofx is often enough, and it's free. Convert instead when:

  • the importer still rejects the renamed file, or only accepts files it can read line by line as plain OFX;
  • you're sending the file to a bookkeeper or a client and don't want the full account number and routing number in it;
  • the payees show &amp; codes, or you want one file per account from a download that holds several.

What carries over for each transaction

The first transaction of our sample QFX, as it comes out of the converter:

<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>
QFX tagOFX tag
DTPOSTEDSame date, written at noon. The time and time zone are dropped.
TRNAMTSame signed amount, two decimals. TRNTYPE is CREDIT for money in and DEBIT for money out.
NAME (or MEMO when NAME is empty)NAME cut to 32 characters, with the full text in MEMO. A separate bank memo isn't kept. & becomes "and".
FITID (the bank's transaction ID)A new ID from the account, date, amount and description, identical every time you convert the same file.
CHECKNUM, SIC, categoriesNot written.

Which programs want OFX rather than QFX

ProgramReads QFX?What to upload
FreeAgentNo. It lists OFX, QIF and CSV.This OFX: Banking → Bank Accounts → the account → Upload Statement.
Sage AccountingSage's help talks about OFX files, which upload without editing; only the first bank account in a file is imported.This OFX, one account per file.
XeroYes, Xero lists QFX with OFX, QBO, QIF and CSV.The QFX as it is, or this OFX without your full account number.
WaveYes (OFX, QBO, QFX and ASO).Either.
QuickBooks OnlineYes. Upload from file lists QBO, QFX, OFX, CSV and TXT.Either; QFX to QBO is the QuickBooks-first choice.
QuickBooks DesktopNo, Web Connect reads only .qbo.QFX to QBO, or QFX to IIF without Web Connect. Not OFX.
GnuCashYes (File → Import → Import OFX/QFX).Either.
QuickenYes, from your bank.The bank's own QFX. Quicken says it doesn't support files from conversion software, so an OFX from here isn't promised to open there.

OFX to QFX?

We don't write QFX. Quicken checks a QFX's Intuit bank ID with its online service before importing, and files made by converters usually fail that check. If the data is going into Quicken for Windows, convert to QIF with the OFX / QFX to QIF converter; if it's going to QuickBooks, use QFX to QBO.

Which QFX files work

  • Quicken Web Connect .qfx downloads, plain OFX 1.x/2.x files and QuickBooks .qbo Web Connect files.
  • Bank and credit card statement downloads. Investment (brokerage) downloads aren't supported.
  • Files with more than one account: each account gets its own preview tab and its own .ofx.
  • Free up to 100 transactions, and up to 20,000 per file.

Common problems

ProblemFix
"No transactions found in that OFX/QFX/QBO file"The download has no transactions for that date range, or it's an investment file. Download the account again with a wider date range.
Transactions imported twiceThe new IDs don't match the bank's own, so a program that already has these dates from a bank feed won't spot the repeats. Import only dates that aren't there yet.
Card payments show as chargesChoose Credit card as the account type in the preview, check the signs and tick Flip signs if they're backwards.
Balance in the program is offCheck the ending balance in the OFX. If it's 0.00, the QFX had no usable ledger balance; enter the opening balance in your program.
QuickBooks Desktop won't open the .ofxDesktop only imports .qbo Web Connect files. Use QFX to QBO or QFX to IIF.

Other conversions

Pricing

Free for files up to 100 transactions, which covers a typical month of activity. Larger files (a year of catch-up, a client's full history) use 1 credit from the same $9 pack of 5 as our PDF statement converter, or unlimited on Pro at $19/month. The preview is always free.

FAQ

Questions

Is it free?

Yes for files up to 100 transactions: no sign-up, no watermark. Bigger files (multi-month catch-up work) use 1 credit from the same $9 / 5-credit pack as our PDF converter, and the preview is always free.

How do I import the OFX file?

Xero: Accounting → Bank accounts → the account's menu icon (⋮) → Import a Statement. Sage Accounting: its bank statement import under Banking (Sage says OFX files upload without editing). FreeAgent: Banking → Bank Accounts → the account → Upload Statement. GnuCash: File → Import → Import OFX/QFX. QuickBooks Online also takes an OFX under Upload from file, but for QuickBooks pick the .QBO output instead.

Is my file stored?

No. Files are processed in memory and deleted after 1 hour. We never use your data for AI training.

Can I try it without uploading my own file?

Yes. Click a sample button under the upload box. It opens a made-up export from a fictional bank in the same preview your own file gets, and every format is free to download, so you can test an import in a test or backup company file first. Don't import a sample into your real books.

Is a QFX file the same as an OFX file?

Almost. QFX is Quicken's Web Connect version of OFX: the same statement and transactions, plus Intuit tags such as INTU.BID (the bank's Intuit ID) that Quicken checks before importing. Take those out and you have a plain OFX statement.

Can't I just rename .qfx to .ofx?

Often, yes, and it costs nothing to try first. Renaming keeps the Intuit tags, your bank's routing number and the full account number, though. Convert when the importer still rejects the renamed file, or when you're sending the file to someone and want only the last 4 digits in it.

Which programs need OFX rather than QFX?

FreeAgent lists OFX, QIF and CSV, and Sage says OFX files upload without editing. Xero, Wave, QuickBooks Online's Upload from file and GnuCash already read QFX, so try the original there first.

Can I convert OFX to QFX?

Not here: we don't write QFX. Quicken validates Web Connect files with its online service and says it doesn't support files from conversion software, so a converted QFX usually won't open in Quicken anyway. For Quicken for Windows, convert to QIF instead.

Does the OFX keep the ending balance?

Yes, when the QFX has a ledger balance dated on or after its last transaction and you haven't flipped the signs. Otherwise the OFX says 0.00 and your program works the balance out from the transactions.

Are the bank's transaction IDs kept?

No. Each transaction gets a new FITID made from the account, date, amount and description, the same every time you convert the same file. If you already imported some of these dates from the bank's own download, import only the dates that aren't in your program yet.

Can I convert a credit card QFX?

Yes. A credit card statement (CCSTMTRS) in the QFX is written as an OFX credit card statement, with charges negative and payments positive. Import it into a credit card account.

My QFX has checking and savings in one file. Will that work?

Yes. Each account gets its own tab in the preview and its own OFX, named with the account type and last 4 digits. One credit covers the whole file.

Other converters

More bookkeeping tools