How to Convert OFX to QBO for QuickBooks (Free, No Upload)
· 6 min de lecture
To convert OFX to QBO, add an Intuit bank ID (the INTU.BID tag) to the OFX file and save it with a .qbo extension, which is what QuickBooks Desktop expects for a Web Connect import. The free OFX to QBO converter does this in your browser in about a minute, keeps every transaction ID, and never uploads your bank data.
This guide shows when you actually need the conversion, the three steps, how to import the file, and what to do when QuickBooks refuses it.
Do you need to convert OFX to QBO?
You need to convert OFX to QBO if you use QuickBooks Desktop and your bank only offers OFX (or Quicken QFX) downloads. QuickBooks Desktop imports bank files through Web Connect, and Web Connect reads .qbo files. If you use QuickBooks Online, you may not need to convert at all: Intuit's US help page lists .csv, .txt, .qbo and .ofx as upload types for bank transactions.
| Your setup | File your bank gives you | What to do |
|---|---|---|
| QuickBooks Desktop | QBO | Import it as is |
| QuickBooks Desktop | OFX or QFX | Convert to QBO |
| QuickBooks Desktop | CSV only | Use CSV to QBO or CSV to IIF |
| QuickBooks Online | OFX, QFX, QBO or CSV | Upload it directly; convert only if the upload is refused |
A common case: an online bank, a credit union or a payment app exports OFX for "Money" or "other software", and the QuickBooks option is missing or costs extra.
What is the difference between OFX and QBO?
QBO is OFX with an Intuit bank ID added. Both are Open Financial Exchange files; QuickBooks Web Connect files use OFX version 1.02 (the older SGML style), and the only part QuickBooks insists on is the INTU.BID line in the sign on block. QuickBooks uses that number to recognise the bank and decide whether the file is allowed.
| Part of the file | OFX | QBO |
|---|---|---|
| Format | OFX 1.x (SGML) or 2.x (XML) | OFX 1.02 (SGML) |
| Intuit bank ID (INTU.BID) | Not present | Required |
| Transaction IDs (FITID) | Present | Present, used to skip duplicates |
| Account type | Checking, savings, credit line or credit card | Same |
| Opens in | Many money programs | QuickBooks Desktop and Online |
That is why renaming file.ofx to file.qbo usually fails: the extension changes, but the bank ID QuickBooks looks for is still missing.
How to convert OFX to QBO in 3 steps
The conversion takes three steps: load the file, check the account settings, download the QBO.
- Load the OFX file. Open the OFX to QBO converter and drop the .ofx file on it (QFX and QBO files work too). You can drop up to 24 files at once, for example 12 monthly downloads: they are merged into one list, sorted by date, and repeats from overlapping date ranges are dropped.
- Check the file settings. Open "File settings for QuickBooks, Quicken and OFX" and confirm:
- Account type: checking, savings, line of credit or credit card. Credit card files are written as credit card statements.
- Account number: QuickBooks matches the file to an account by this number, so use the same one each time. The last digits are fine.
- Currency: USD for a US company file.
- Intuit bank ID: the converter fills in a default. If your bank has its own ID, enter it (see the next section).
- Download the QBO file. Press QBO (QuickBooks). The file is written in your browser and saved with the same name as the original. Check the totals panel first: number of transactions, money in, money out and the date range should match your bank download.
The tool also exports QFX for Quicken, CSV, Excel and IIF from the same file, so you can keep a spreadsheet copy for your records.
How to find your bank's Intuit bank ID
Your bank's Intuit bank ID is the number QuickBooks has on file for it, and the easiest place to find it is an old QBO or QFX file from the same bank. Open that file in Notepad or TextEdit, search for INTU.BID, and copy the number after it.
If you have never had a QBO file from the bank:
- Ask the bank's online banking support for its "Intuit ID" or "Web Connect ID".
- Try the default first. Many QuickBooks versions accept it; you only need the real ID if QuickBooks says the bank is not supported.
- Keep using the same ID every month, so QuickBooks keeps linking the files to the same account.
How to import the QBO file into QuickBooks
In QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files, pick the .qbo file, then choose an existing account or create a new one. The transactions land in the Bank Feeds center, where you match or add them.
In QuickBooks Online, go to Banking (or Transactions) > Bank transactions > Upload transactions (the menu name depends on your plan's layout), choose the file and the account, then review the transactions in the For review tab. Intuit's US page notes a limit of 1,000 lines per upload, so split a very long history into a few files.
Tip: before your first import, back up the QuickBooks Desktop company file, so a wrong account choice is easy to roll back.
Fixes when QuickBooks refuses the QBO file
Most import errors come from the bank ID, the account number or transactions QuickBooks already has.
| What you see | Likely cause | Fix |
|---|---|---|
| "Bank not supported" or "financial institution not available" | QuickBooks does not accept the bank ID in the file | Enter your bank's own Intuit ID in File settings and download again |
| Transactions go into the wrong account | A different account number than the one linked last time | Set the same account number as earlier imports |
| Import runs but nothing new appears | Every transaction ID (FITID) is already in QuickBooks | Expected when files overlap; only new transactions are added |
| Credit card charges show as deposits | File was saved as a bank account | Set account type to Credit card and download again |
| Some rows are missing | Rows without a readable date are left out | Fix the dates in the source, or convert the CSV copy with CSV to QBO |
| "File is not a valid Web Connect file" | The file was renamed, not converted, or edited in Excel | Convert the original .ofx again and do not open the QBO in Excel |
Will converting OFX to QBO create duplicates?
No, not for transactions QuickBooks has already imported, because the converter keeps each transaction's original FITID from the OFX file. QuickBooks reads the FITID and skips any ID it has seen before. Two different payments with the same amount on the same day stay separate, because each has its own ID.
Where duplicates do happen is when the same month was entered by hand earlier, or imported from a CSV (CSV files have no transaction IDs). In that case, match the imported rows to the existing ones in Bank Feeds instead of adding them.
Common mistakes to avoid
- Renaming .ofx to .qbo. The bank ID is still missing, so QuickBooks rejects it or picks the wrong bank.
- Opening the QBO in Excel and saving it. Excel rewrites the file and breaks the format. Keep a CSV or Excel copy for reading instead.
- Changing the account number every month. QuickBooks then asks for a new account each time.
- Converting a PDF statement. OFX converters need an OFX, QFX or QBO file. For a PDF statement, use the bank statement converter first, then export QBO from it.
Is it safe to convert bank files online?
It depends on where the file goes. Many online converters upload your file to their server. The TradingForms converter reads and writes the file with code running in your browser, so the transactions never leave your device, and there is no file limit or sign up.
Ready to try it? Drop your OFX download on the free OFX to QBO converter and import the QBO file into QuickBooks in a few minutes. If your bank only gives you CSV files, our guide on how to convert CSV to QBO covers that route.
Frequently asked questions
Can I just rename an OFX file to QBO?
Usually not. A QBO file needs an Intuit bank ID (INTU.BID) inside it, and renaming does not add one. QuickBooks then rejects the file or reports that the bank is not supported.
Does QuickBooks Desktop accept OFX files?
QuickBooks Desktop imports bank downloads through Web Connect, which expects .qbo files. Convert the OFX to QBO first, then use File, Utilities, Import, Web Connect Files.
Does QuickBooks Online accept OFX files?
Intuit's US help page lists .ofx among the upload types, along with .csv, .txt and .qbo. Try the OFX directly in Upload transactions, and convert it only if QuickBooks Online refuses it.
What is INTU.BID in a QBO file?
It is the Intuit bank ID, the number QuickBooks uses to recognise the bank that issued the file. You can find your bank's ID in any QBO or QFX file it has given you before.
Is the OFX to QBO converter free?
Yes. It is free with no sign up and no file limit, because the conversion runs in your browser and nothing is uploaded to a server.