Free QFX to OFX Converter

The tag that makes your file a QFX instead of an OFX

OFX is an open specification. <INTU.BID> is not in it — it is Intuit's own addition, sitting in the sign-on block at the top of the file:

<SONRS>
  <FI>
    <ORG>Chase Bank
    <FID>10898        standard OFX — the institution id
  </FI>
  <INTU.BID>10898     Intuit only — this is the line that comes out
</SONRS>

That one line is what lets Quicken and QuickBooks recognise each other's files. It is also what other software trips over: some importers ignore an unknown tag, others refuse the file, and the ones that refuse almost never say which tag was the problem. That is why a QFX that looks perfectly valid gets rejected with nothing useful on screen.

Renaming it .ofx leaves the tag inside

Changing the extension changes what your operating system thinks the file is. It does not change a byte of what is in it, so the Intuit tag is still there when the importer reads it. If your program was going to refuse the tag, it still will.

Renaming also does not help with two other things:

• Newer QFX files are XML. They start with <?xml. Most OFX importers expect the older 1.0.2 SGML form, which is a different syntax for the same data. This page reads either and always writes 1.0.2 SGML.
• A file can hold more than one account. Most importers take one at a time, and handed two they put everything in whichever account you picked. This page splits them.

Everything except that one line is copied across

The page shows you a field by field comparison before you download — institution id, account number, account type, closing balance, transaction count — so you can see for yourself that only the Intuit tag is gone. That matters more than it sounds: you are importing this into years of your own records, and “trust me” is not good enough.

One detail worth naming, because converters get it wrong: <FID> and <INTU.BID> are different fields that usually hold the same number. <FID> is standard OFX and stays; <INTU.BID> is the Intuit one and goes. A converter that treats them as the same thing will either strip both or keep both.

Which programs want plain OFX

If yours is not listed, look for an import option labelled OFX rather than Quicken. Those two labels usually sit next to each other, and the Quicken one is the one that wants the tag left in.

Questions

I want to go to QuickBooks, not away from it.

Then use QFX to QBO instead. That conversion keeps the Intuit tag rather than removing it, because QuickBooks Web Connect refuses files without one — and it keeps your bank's own value, so the import screen shows your bank's name instead of a generic default.

Where do I get a QFX file?

From your bank's download page, when you choose Quicken as the destination. Banks label it “Quicken”, “Quicken Web Connect” or just “.QFX”. If the same page offers a plain “OFX” or “Microsoft Money” download, take that and skip this page entirely — we would rather say so than pretend you need us.

My importer still rejects the converted file.

Then the problem was not the Intuit tag. The next most common causes are the account type being something the importer does not expect, and a date range it considers empty. The page shows you both before you download, so compare them against what your software is asking for. Send us the file if you want a second look.

Is my file uploaded anywhere?

No. Every converter here runs in the browser, and each page ships a Content Security Policy with connect-src 'none', so your browser refuses to let the page make any network request. Watch the Network tab in developer tools while you convert and it stays empty.

Related

• QFX to QBO converter keeps the tag, for QuickBooks
• OFX to QBO converter the opposite direction
• CSV to OFX converter when you only have a spreadsheet
• QBO to CSV converter read the file as a table