A QFX and a QBO are the same format wearing different labels
Both are OFX with Intuit's private tags added. QFX is the label Quicken opens; QBO is the label QuickBooks opens. The two programs will not touch each other's extension, which is the entire reason this page exists — the data inside is already what the other one wants.
That makes a QFX a much better starting point than a bank's plain .ofx, for one
specific reason covered below.
Isn't this just renaming the file?
Sometimes it is, and this page will tell you when. If your QFX is the older SGML flavour, holds one account, and is under 350 KB, renaming it can work and you do not need us. That is worth saying plainly, because most converter pages will not.
Renaming fails, quietly, in three cases:
-
Your QFX is the XML flavour. Newer files start with
<?xml. Web Connect reads the OFX 1.0.2 SGML form, which is a different syntax for the same data. Renaming hands it XML. This converter reads either and always writes 1.0.2 SGML. - The file holds more than one account. Web Connect imports into one account at a time. Give it a two-account file and every transaction lands in whichever account you picked, with no warning at all. This page splits them and makes you convert one at a time.
- The file is over 350 KB and you use QuickBooks Online. Online refuses the upload at that size. Quicken has no such limit, so your QFX never complained. The finished size is shown here before you download.
There is a fourth, smaller reason: the page shows you the account number, account type, date range and transaction count it read out of the file before you import anything. A rename tells you nothing until QuickBooks either accepts it or refuses without saying why.
The one tag that decides whether QuickBooks takes your file
<INTU.BID> is Intuit's bank identifier. Web Connect checks it before
anything else, and a file with no INTU.BID, or one carrying a value QuickBooks does
not recognise, is refused with no explanation given. It is the single most common
reason a file that looks perfectly fine gets rejected.
A QFX already carries one, because Quicken Web Connect uses the same tag.
A bank's plain .ofx does not — it is an Intuit-private tag and standard
OFX has no business including it. That is the whole difference between the two conversions:
| Starting from | INTU.BID in the file | What QuickBooks shows on import |
|---|---|---|
| Your QFX (this page) | present — kept as is | your own bank's name |
| A bank's plain OFX | absent — a generic value is added | “Wells Fargo”, whoever you bank with |
That second row is a display label on the import screen, not a destination — the money still lands wherever you tell it to. But it looks like an error, and it is worth avoiding when your file already has the right value sitting in it.
Going the other way? If your file is headed for GnuCash, Microsoft Money, Moneydance, Xero or Sage rather than QuickBooks, that tag is the thing standing in your way — QFX to OFX removes it instead.
Importing it into QuickBooks
- Desktop: File → Utilities → Import → Web Connect Files, then pick the downloaded
.qbo. - Online: Transactions → Bank transactions, then the
⌄next to Link account, then Upload from file. - QuickBooks asks which account to put the transactions in. Pick your own account — ignore the bank name shown on that screen.
- Review the imported list before accepting. Transactions already present are matched by their IDs and should not appear twice.
Questions
Where do I get a QFX file in the first place?
From your bank's download page, when you choose Quicken as the destination, or from Quicken itself. Banks label it “Quicken”, “Quicken Web Connect” or sometimes just “.QFX”. If the same page also offers “QuickBooks” or “.QBO”, take that instead — then you need no converter at all, and we would rather say so.
QuickBooks rejected the converted file anyway.
Then the INTU.BID your file carries is not one QuickBooks recognises — Quicken and QuickBooks do not accept an identical list of institutions. Nothing on this page can fix that, and any converter claiming otherwise is guessing. Send us the file if you want a second look at what is in it.
Will this create duplicates of transactions I already have?
QuickBooks matches on the transaction ID of each line, which is derived from the account number. This reads the account number out of your file rather than asking you to type it, so it is identical every time and matching works. Duplicates turn up when the number differs between two imports — which is what happens when a human retypes it.
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
- OFX to QBO converter when the file came from a bank, not Quicken
- CSV to QFX converter the other direction, for Quicken
- QBO to CSV converter read a QBO back out
- CSV to QBO converter when the bank only gives you a spreadsheet