Free OFX to QBO Converter

Your bank gave you a .ofx or .qfx and QuickBooks Desktop won't take it. One tag is missing. This adds it and leaves everything else alone. No signup, and your statements never leave your browser.

Why Web Connect refuses a file it can obviously read

A .qbo file is not a different format from .ofx. It is an OFX file with Intuit's own tags added, and the one that decides everything is <INTU.BID>, the number that tells QuickBooks which bank the file came from. Web Connect looks for it. A file from your bank's website is built for Quicken and other finance apps, so it doesn't carry an Intuit tag, and QuickBooks turns it away.

Everything else in your file is already right: the same transaction blocks, the same date format, the same amounts. That is what makes this conversion different from the ones that start with a spreadsheet. There is almost nothing to work out.

The part that matters most is the part you don't do

You are not retyping your account number. It's in the file, along with the routing number, whether the account is a bank account or a credit card, and the currency. All of it comes across as it stands.

That is worth more than the typing it saves. QuickBooks decides whether it has seen a transaction before by looking at an ID built partly from the account number. Type it one way in January and a different way in February and nothing matches, so every transaction in the overlap comes in a second time. Starting from a file that already knows its own account number removes that whole class of mistake.

What you get

Importing it into QuickBooks Desktop

  1. Save the converted .qbo file somewhere you can find it.
  2. In QuickBooks Desktop, go to File › Utilities › Import › Web Connect Files.
  3. Pick the file. QuickBooks asks which account to use, or offers to create one.
  4. The transactions land in the bank feed for review before they touch your register.

That review step is the reason to prefer this route over an IIF import when you have the choice. Web Connect stages the transactions and lets you look before accepting. IIF writes straight into the company file with no undo.

Questions

What is INTU.BID and where do I get the right one?

It's a number Intuit assigns to a financial institution, and QuickBooks reads it to work out which bank a Web Connect file belongs to. If your file already carries one, this page keeps it. If not it writes 3000, a generic value QuickBooks takes. You do not need to hunt down your bank's real number for the import to work.

Will importing this create duplicates of transactions I already have?

QuickBooks decides by looking at each transaction's FITID, an identifier the bank assigns and guarantees is unique within your account. Your OFX file already has one on every transaction, and we copy it across rather than making up our own. Import an overlapping date range and QuickBooks sees the same IDs and treats them as the same transactions.

That also holds if you later get a genuine .qbo straight from your bank covering the same period. Because the IDs are the bank's, not ours, they line up.

Does this work with QFX files too?

Yes, and if that is what you have, the QFX to QBO page is the better one to use. A QFX already carries its own <INTU.BID>, which is kept rather than replaced with the generic value below — so QuickBooks shows your own bank's name on the import screen instead of “Wells Fargo”. If your bank offers a Quicken download but not a QuickBooks one, that download is what you want.

My file has more than one account in it. What happens?

The page tells you how many it found and asks which one you are importing, then converts that one. Web Connect imports into a single account, so putting two accounts in one file would post one account's transactions into the other. Convert them one at a time.

Is my bank statement 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