Convert OFX to QBO for QuickBooks Import
QuickBooks Desktop won't import your OFX file? It needs QBO format — same data, different header. Convert in seconds and import via Web Connect.
For QuickBooks Desktop and Online. Adds the INTU.BID header QuickBooks needs. Free online.
How It Works
Upload Your OFX File
OFX file from your bank's online portal. Both OFX 1.x (SGML) and OFX 2.x (XML) versions auto-detected and handled.
QBO Header Added
The INTU.BID, FID, and ORG fields QuickBooks requires are added to your file. Transaction data stays identical — nothing modified.
Download QBO
Import via File > Utilities > Import > Web Connect Files in QuickBooks Desktop, or drag into QuickBooks Online's bank feed.
OFX vs QBO — What's Actually Different?
QBO is just OFX with an Intuit header block. The transaction data is identical.
OFX File (Your Bank's Download)
OFXHEADER:100
DATA:OFXSGML
VERSION:102
...
<SIGNONMSGSRSV1>
<SONRS>
<STATUS><CODE>0
<FI>
<ORG>Wells FargoMissing INTU.BID — QuickBooks rejects this
QBO File (After Conversion)
OFXHEADER:100
DATA:OFXSGML
VERSION:102
...
<SIGNONMSGSRSV1>
<SONRS>
<STATUS><CODE>0
<FI>
<ORG>Wells Fargo
<FID>3511<INTU.BID>3511
INTU.BID added — QuickBooks accepts this
QuickBooks Import Compatibility
| Format | QB Desktop | QB Online | Import Method |
|---|---|---|---|
| OFX | No | Yes | Bank feed upload |
| QBO | Yes | Yes | Web Connect import |
| QFX | No | Yes | Bank feed upload |
| IIF | Yes | No | File > Utilities > Import |
QBO is the only format accepted by both QuickBooks Desktop and Online via bank feed import.
What is OFX?
Open Financial Exchange
Banking industry standard for transaction data. Contains dates, amounts, payees, and FITIDs. QuickBooks Desktop rejects this format — it needs the Intuit-specific QBO wrapper.
What is QBO?
QuickBooks Web Connect
OFX with Intuit headers (INTU.BID, FID, ORG) added. Imports via File > Utilities > Import > Web Connect in QuickBooks Desktop. Transactions land in the bank feed for review and matching.
Why This Tool
INTU.BID Header Added
The Intuit Bank ID that QuickBooks requires. Without it, QuickBooks rejects the file. We add the correct header so your import works on the first try.
OFX 1.x & 2.x Support
SGML-based OFX 1.x (no closing tags) and XML-based OFX 2.x both parsed and converted. No need to know which version your bank exports.
FITIDs Preserved
Transaction IDs pass through unchanged. QuickBooks uses FITIDs to detect duplicates — your matching rules and deduplication continue to work.
Zero Data Modification
Dates, amounts, descriptions, check numbers — all pass through untouched. Only the header wrapper changes from OFX to QBO.
Desktop & Online Compatible
The QBO file works with QuickBooks Desktop (Pro, Premier, Enterprise) and QuickBooks Online. One file, both platforms.
Bank Feed Import Ready
Transactions import into the bank feed for review, not as completed entries. You match, categorize, and approve — same workflow as automatic bank feeds.
When to Use This
QB Desktop Import Fix
Your bank provides OFX but QuickBooks Desktop only accepts QBO. Convert the file and import via Web Connect — the most common reason people need this tool.
Bank Feed Replacement
After your QB Desktop version loses automatic bank feeds (2022→May 2025, 2023→May 2026), download OFX from your bank and convert to QBO for manual import.
Multi-Bank Consolidation
Some banks export OFX, others export QBO. Convert all to QBO so you have one consistent format for importing into QuickBooks across all accounts.
How to Import the QBO File
QuickBooks Desktop
- Go to File > Utilities > Import > Web Connect Files
- Select your downloaded .qbo file
- Map to the correct bank account
- Transactions appear in Bank Feeds
- Review, match, and accept each transaction
QuickBooks Online
- Go to Banking > Upload transactions
- Select the bank account
- Upload your .qbo file
- Transactions appear in For Review
- Categorize and accept
OFX-to-QBO Import Issues
QuickBooks says "Unable to read the file" or "This file is not a valid Web Connect file"
The OFX file is missing the INTU.BID header. Simply renaming .ofx to .qbo doesn't work — the header must be added. Our converter handles this automatically.
Transactions imported but all marked as duplicates
You've already imported this date range. QuickBooks matches on FITID — if the same transactions exist, they're flagged. This is expected behavior, not an error.
"No transactions found in this file" after import
The OFX file may contain account info but no STMTTRN (transaction) blocks. Check your bank's date range when downloading — some default to an empty period.
Transactions import to the wrong bank account
During Web Connect import, QuickBooks asks which account to map to. Select the correct bank/credit card account from the dropdown. You can change this mapping later in Bank Feeds settings.
Frequently Asked Questions
Why won't QuickBooks Desktop import my OFX file directly?
QuickBooks Desktop requires QBO format — an OFX file with Intuit-specific headers (INTU.BID, FID, ORG). Without these, QuickBooks rejects the file even though the transaction data is identical.
What's the actual difference between OFX and QBO?
QBO is OFX with an extra header block. The INTU.BID field (Intuit Bank ID) tells QuickBooks which bank the file came from. Transaction data, dates, amounts, and FITIDs are identical between the two formats.
Does QuickBooks Online need QBO, or can it import OFX directly?
QuickBooks Online accepts both OFX and QBO files. The conversion is mainly needed for QuickBooks Desktop, which only accepts QBO via Web Connect.
Will this help after my QuickBooks Desktop version loses bank feeds?
Yes. Download OFX from your bank portal, convert to QBO here, and import via Web Connect. This replaces the automatic bank feed with a manual download-and-import workflow.
Can I just rename .ofx to .qbo?
Sometimes — but only if your OFX file already contains the INTU.BID header. Most bank downloads don't include it, so renaming alone usually fails. Our converter adds the required headers properly.
Does it handle both OFX 1.x (SGML) and 2.x (XML)?
Yes. Most US banks export OFX 1.x with SGML syntax (no closing tags). We parse both versions and output a valid QBO file regardless of the input version.
MoneyThumb charges $60+ and ProperConvert limits trials to 10 transactions. Is this free?
Yes. No transaction limits, no trial restrictions, no signup. Convert as many OFX files as you need.
Will duplicate transactions be imported?
QuickBooks uses the FITID (Financial Institution Transaction ID) to detect duplicates. If you import the same QBO file twice, QuickBooks will flag duplicates during the matching step.
Is my data secure?
Encrypted in transit via TLS, processed in memory, never stored. Your OFX file is deleted immediately after conversion.
Related Tools
OFX to CSV
Convert OFX (Open Financial Exchange) files to CSV for spreadsheets and analysis. Extracts dates, amounts, and descriptions. Free, instant, no signup required.
Convert now →OFX to Excel
Convert OFX financial files to formatted Excel (XLSX) spreadsheets. View, sort, and analyze your bank transactions in Excel. Free, instant, no signup required.
Convert now →CSV to QBO
Convert CSV financial files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →PDF to QBO
Import bank statement PDFs into QuickBooks as QBO files. AI auto-maps dates, debits, and credits. Works with QuickBooks Desktop and Online. Free, no signup.
Convert now →