OFX into QuickBooks
OFX to QBO: getting a bank OFX file into QuickBooks
Your bank's OFX file is nearly a QBO already. What it lacks is the Intuit bank ID QuickBooks Desktop checks for, which is why the download gets rejected. Here's what the conversion involves and when you can skip it.
- QuickBooks Online takes .ofx directly
- Desktop Web Connect needs .qbo
- The difference is the bank ID
- Or build a checked QBO from the PDF
<INTU.BID>10898<STMTTRN> <TRNTYPE>CREDIT <DTPOSTED>20260302 <TRNAMT>4210.00 <FITID>a3f9c2e81b07 <NAME>ACH DEPOSIT STRIPE PAYOUT</STMTTRN><STMTTRN> <TRNTYPE>CHECK <DTPOSTED>20260305 <TRNAMT>-1250.00 <FITID>5d10e7b4c9a2 <CHECKNUM>1042</STMTTRN><LEDGERBAL><BALAMT>15354.12
The short answer
How to convert OFX to QBO
Converting OFX to QBO means adding your bank's Intuit bank ID (the INTU.BID tag) to the sign-on section of an OFX 1.0.2 file and saving it with a .qbo extension; the transactions themselves don't change. If you use QuickBooks Online, you may not need to convert at all, because Upload from file accepts .ofx alongside .qbo. The conversion matters for QuickBooks Desktop, whose Web Connect import wants a .qbo with a recognised bank ID.
There are two practical routes. If your bank's OFX is version 1.x and you know your bank's Intuit ID, the edit is small and described below. If the OFX is the XML-based version 2.x, if the bank has no Intuit ID, or if you also want the transactions checked against the statement, VouchRow builds the QBO from the PDF statement for the same period instead: upload the PDF, enter your bank's ID, and download a .qbo in which every row has been verified.
Step by step
Getting your bank's OFX transactions into QuickBooks
- 1On QuickBooks Online, try the OFX firstTransactions → Bank transactions → Link account → Upload from file, then select the .ofx. If it imports, you're done; no conversion is needed.
- 2On Desktop, find your bank's Intuit IDOpen any .qbo your bank has issued in a text editor and copy the number after <INTU.BID>. If the bank has never issued one, it may not be enrolled in Web Connect; IIF is then the Desktop route.
- 3Build the QBO from the statementSign in, upload the PDF statements covering the OFX period, review the reconciliation, and export QBO with the bank ID.
- 4Import into QuickBooks DesktopFile → Utilities → Import → Web Connect Files, choose the .qbo, link it to your existing account, and add the transactions from the Bank Feeds Center.
Why it works
Why build the QBO from the statement
Checked against the bank's figures
Each row is verified against the statement's running balance and totals. A bank OFX gives you nothing to check it against.
Periods the OFX doesn't cover
Bank OFX downloads usually reach back a limited time. Statement PDFs cover older months too.
Stable IDs
FITIDs are derived from each transaction, so converting the same statement twice yields the same IDs.
Traceable rows
Every transaction links to its highlighted line on the statement page.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
The difference
OFX vs QBO: what actually differs
QBO is OFX with Intuit's additions. A typical bank OFX and a QBO for the same account differ in only a few places:
| Plain OFX | QBO | |
|---|---|---|
| Version | 1.0.2 SGML or 2.x XML | 1.0.2 SGML |
| <INTU.BID> | Absent | Required, inside <SONRS> after </FI> |
| File extension | .ofx | .qbo |
| QuickBooks Online Upload from file | Accepted | Accepted |
| QuickBooks Desktop Web Connect | Not accepted | Accepted when the bank ID is recognised |
| Transactions (STMTTRN, FITID, TRNAMT, DTPOSTED) | Same | Same |
By hand
Editing an OFX into a QBO yourself
For an OFX 1.x file (its first line reads OFXHEADER:100), the edit is mechanical. Open it in a plain-text editor, not a word processor. Inside <SONRS>, after the closing </FI> tag, add a line with <INTU.BID> followed by your bank's Intuit ID. Save it, then change the extension from .ofx to .qbo.
Three cautions. Use your own bank's ID: a borrowed one may get past the check but makes the file claim an origin it doesn't have, and it can tangle the account's online banking settings in QuickBooks. Keep the bank's FITIDs untouched, because they're what stops duplicates. And if the file starts with an XML declaration (<?xml ...?>), it's OFX 2.x, and adding a tag isn't enough; the whole document would need rewriting as SGML.
Troubleshooting
Why QuickBooks rejects a bank OFX or a converted QBO
The errors name a connection problem, but the cause is almost always in the file.
| Error | Cause | Fix |
|---|---|---|
| Desktop won't accept the .ofx at all | Web Connect import expects .qbo | Convert to QBO, or use IIF |
| OL-301 or "unable to verify financial institution" | INTU.BID missing or not on the Web Connect list | Add your own bank's ID; if it has none, use IIF on Desktop or OFX/CSV on Online |
| OL-249 / unsupported financial institution | The bank ID isn't recognised for Web Connect | As above |
| File reported as invalid | An OFX 2.x (XML) file was given a QBO extension | Build the QBO from the PDF statement instead |
| Account picker shows the wrong account | The QuickBooks account is linked to another bank's online services | Deactivate the account's online services, then import |
Duplicates
Mixing your bank's OFX and a converted QBO
Transactions from your bank's OFX carry the bank's FITIDs. Transactions in a QBO built from the PDF carry IDs derived from the transaction itself. They won't match each other, so importing both for the same dates duplicates the overlap. Pick one source per period: the bank's file for the months it covers, and the statement conversion for older months or months where you want the rows checked.
Which route to take
QuickBooks Online: upload the OFX as it is. Desktop with a bank ID and an OFX 1.x file: either edit it by hand or build the QBO from the PDF statement. Desktop with OFX 2.x, or with periods the OFX doesn't cover: build from the PDF. Desktop with no Intuit ID for your bank: use IIF, which needs none.
Side by side
Your options for OFX into QuickBooks
| Situation | Best route |
|---|---|
| QuickBooks Online, any bank | Upload the .ofx directly |
| QuickBooks Desktop, OFX 1.x, bank has an Intuit ID | Add INTU.BID and rename, or build the QBO from the PDF |
| QuickBooks Desktop, OFX 2.x | Build the QBO from the PDF statement |
| QuickBooks Desktop, bank has no Intuit ID | IIF from the PDF statement |
| Need to check rows against the statement first | Build from the PDF statement |
Who uses it
Who searches for OFX to QBO
QuickBooks Desktop users whose bank offers OFX
The bank's Money or "other software" download is OFX, and Desktop's Web Connect import won't take it.
Users switching from other software
History exported as OFX from a previous program, now headed for QuickBooks.
Accountants with a client's OFX and PDFs
Recent months as OFX, older months only as statements. Converting the statements gives one consistent QBO source for the older period.
FAQ
OFX to QBO: getting a bank OFX file into QuickBooks: questions
Why does QuickBooks reject my bank's OFX file?
QuickBooks Desktop's Web Connect import expects a .qbo carrying an INTU.BID tag, and a plain OFX download has none. QuickBooks looks for that identifier before accepting the file. QuickBooks Online is more relaxed and accepts .ofx through Upload from file.
How do I convert OFX to QBO?
For an OFX 1.x file, add <INTU.BID> with your bank's Intuit ID inside <SONRS> after </FI>, and change the extension to .qbo. For OFX 2.x, or to get rows checked against the statement, convert the bank's PDF statement to QBO here instead.
Do you accept OFX files as input?
No. The converter reads PDF bank and credit card statements, digital or scanned. Upload the PDF statements for the same period to get a QBO.
Can I import an OFX file into QuickBooks Online?
Yes. Transactions → Bank transactions → Link account → Upload from file accepts .ofx as well as .qbo, .qfx and .csv.
Can I import an OFX file into QuickBooks Desktop?
Not through Web Connect, which wants .qbo. Convert it to QBO, or use IIF if your bank has no Intuit ID.
Can I use any bank's INTU.BID?
Don't. It makes the file claim to come from a bank it didn't come from and can interfere with the account's online banking setup. Use your own bank's ID, or a format that needs none.
Will I lose anything converting OFX to QBO?
No. The transactions, amounts, dates and FITIDs are the same; QBO only adds the bank ID.
Keep going
Related guides and converters
Build a QBO file from your bank statements
Create an account, upload the PDF statements and export QBO with your bank's ID, with every row checked against the statement. Starter is $15 a month for 300 pages.