🏦 QuickBooks Web Connect File Builder

Free OFX to QBO QuickBooks Web Connect Converter

Convert OFX and QFX bank files to QBO for QuickBooks Online and QuickBooks Desktop. The tool checks every transaction, adds the Intuit bank ID (INTU.BID), fixes missing or duplicate transaction IDs, and builds the .qbo file in your browser. Nothing is uploaded.

Runs 100% in your browser 15+ QuickBooks checks Bank and credit card files

1. Add your file

Drop your .ofx, .qfx or .qbo file here or click to choose a file · read on your device only

2. QuickBooks settings

Importing into

Account type

Intuit bank ID (INTU.BID) 3000 is the ID most converters use. It only changes the bank label; you still choose your own account.

If the file already has a bank ID

Advanced options and fixes

Bank name (ORG)

Currency

Account number (ACCTID)

Routing number (BANKID)

Only transactions from

Fix missing and duplicate transaction IDs (FITID)Creates stable IDs from date, amount and payee, so converting the same file twice gives the same IDs. Shorten payee names to 32 charactersOFX 1.x allows 32 characters in NAME. The full text is kept in the memo. Set transaction times to 12:00 noonStops time-zone offsets from moving a transaction to the day before or after. Replace accented and special charactersQBO files use the Windows-1252 / US-ASCII header. é becomes e, and so on. Remove $0.00 transactions Flip signs (charges ↔ payments)Use only if deposits import as withdrawals, which some credit card exports cause.

3. File check

Waiting for a fileAdd an OFX, QFX or QBO file to start.

Transactions—

Date range—

Money in—

Money out—

Format: —
Bank: —
Account: —
Ledger balance: —

Transactions will appear here after you add a file.

The generated QBO file will appear here.

Your bank data stays on your device. This page reads the file with your browser's FileReader and builds the QBO file locally. No file, account number or transaction is sent to iLoveTool4 or anyone else. Close the tab and it is gone.

Quick answer: A QBO file is an OFX file with an Intuit bank ID (INTU.BID) and a .qbo extension. To convert, the file needs an OFX 1.x header, that bank ID, and a unique ID (FITID) on every transaction. This tool adds anything missing and checks the rest. Then import the file with Upload from file in QuickBooks Online or File > Utilities > Import > Web Connect Files in QuickBooks Desktop.

What Is an OFX to QBO Converter?

An OFX to QBO converter turns a bank file in Open Financial Exchange format (.ofx) into a QuickBooks Web Connect file (.qbo). Both formats hold the same kind of data: account details, a date range and a list of transactions. The difference is that QuickBooks expects a few extra things before it will accept the file.

Many banks, credit unions and card issuers let you download OFX but not QBO, because Intuit licenses QBO downloads to banks separately. A converter fills that gap. This one also works as a checker: it reads the file, tells you what QuickBooks will complain about, and fixes what it safely can.

How to Convert OFX to QBO

Add your OFX file: Drop your .ofx, .qfx or .qbo file into the box, choose it from your device, or paste the OFX text.
Review the checks: The tool reads the file in your browser and shows the account, date range, totals and a pass or warning for each QuickBooks requirement.
Adjust settings if needed: Pick the account type, keep or change the Intuit bank ID (INTU.BID), filter by date, and turn fixes on or off.
Download the .qbo file: Click Download QBO File. The file is created on your device and saved with a .qbo extension.
Import into QuickBooks: In QuickBooks Online use Banking > Upload from file. In QuickBooks Desktop use File > Utilities > Import > Web Connect Files.

Before converting, download the OFX file straight from your bank's website for the exact date range you need. Avoid re-saving it in Excel or a text editor that changes the encoding, because that can break the file's header.

OFX vs. QBO: What Is the Difference?

	OFX	QBO
Full name	Open Financial Exchange	QuickBooks Web Connect file
Who controls it	Open standard, created in 1997 by Microsoft, Intuit and CheckFree, now managed by the Financial Data Exchange (FDX)	Intuit
Structure	OFX 1.x uses SGML (tags often not closed); OFX 2.x uses XML	OFX 1.x-style SGML is the most common form
Bank ID tag	Not required	`<INTU.BID>` expected, especially by QuickBooks Desktop
Opens in	Many finance apps, including Xero and GnuCash	QuickBooks Desktop and QuickBooks Online
QuickBooks Online upload	Not in Intuit's supported list	Supported (with QFX and CSV)

Why Convert an OFX File to QBO?

Your bank only offers OFX. Many smaller banks and non-US banks export OFX but not QBO.
QuickBooks Desktop needs Web Connect. Desktop imports bank files through Web Connect, which looks for the INTU.BID tag that plain OFX files do not have.
QuickBooks Online lists QBO, not OFX. Intuit's upload help page names QBO, QFX and CSV as the transaction file formats.
It is safer than CSV. A QBO file carries a unique ID for every transaction, so QuickBooks can spot and skip duplicates. A CSV has no such ID.
Older transactions. Bank feeds often reach back only a limited time. A downloaded file lets you fill gaps from earlier months.

How to Import a QBO File Into QuickBooks

QuickBooks Online

Go to Banking (or Transactions > Bank transactions).
Select Upload from file and drop in your .qbo file.
Choose the QuickBooks account the transactions belong to.
Review the transactions and select the ones to import.
Match or categorize them in the For review tab, then reconcile.

Intuit's limits: the file must be 350 KB or smaller and hold up to 1,000 transactions. For bigger files, use the date filter in this tool to split the file into smaller date ranges.

QuickBooks Desktop

Back up your company file first.
Go to File > Utilities > Import > Web Connect Files (or Banking > Bank Feeds > Import Web Connect File), or double-click the .qbo file.
Choose Use an existing QuickBooks account and pick the account.
Click Continue, then review the transactions in the Bank Feeds center.

If the account is already connected to a live bank feed and the import will not attach to it, some users have to deactivate online services for that account first (Edit Account > Bank Feed Settings).

Why QuickBooks May Reject an OFX File

Problem in the file	What you see	What this tool does
No `INTU.BID` tag	"QuickBooks is unable to verify the Financial Institution information for this download" (often reported as OL-222)	Adds the bank ID you choose (3000 by default)
Wrong file extension	File not offered in the import dialog	Saves as `.qbo`
OFX 2.x XML with odd header	"File not recognized" or invalid format	Rewrites as a standard OFX 1.02 SGML file
Missing or repeated FITIDs	Transactions skipped or duplicated	Creates stable, unique IDs
Special characters (&, é, emoji)	Import stops partway or text looks broken	Escapes and replaces them
No ledger balance	Import errors in some versions	Adds a `LEDGERBAL` block and warns you

One problem a converter cannot fix: very old QuickBooks Desktop versions. Intuit retires online banking features, including Web Connect imports, for Desktop versions that have passed their support date.

OFX to QBO Conversion and Bank Information

A QBO file identifies the bank and account in a few tags:

<FI> <ORG>Bank name <FID>3000 </FI> <INTU.BID>3000 ← Intuit bank ID (sets the bank label) ... <BANKACCTFROM> <BANKID>123456789 ← routing number <ACCTID>000123456789 ← account number <ACCTTYPE>CHECKING </BANKACCTFROM>

INTU.BID must be an ID on Intuit's list. 3000 is the ID most converters use (it belongs to Wells Fargo), so QuickBooks may show a Wells Fargo label. That is harmless. You pick your own QuickBooks account during import, and the transactions go there.
ACCTID is how QuickBooks links the file to an account and tracks which transactions it has already imported. Keep it the same every month.
Credit card files use a CCACCTFROM block with only an account number and no routing number. The tool switches formats for you when you choose Credit card.

What Happens to Transactions During Conversion?

Each <STMTTRN> block is read, checked and written out again with these fields:

Field	Meaning	Handling
`TRNTYPE`	Type, e.g. DEBIT, CREDIT, CHECK, POS, ATM, FEE	Kept if valid; otherwise set to CREDIT or DEBIT from the amount's sign
`DTPOSTED`	Date posted	Same day kept; time set to noon (optional)
`TRNAMT`	Amount (minus = money out)	Kept exactly, with its original decimals
`FITID`	Unique transaction ID	Kept; created only when missing or repeated
`NAME`	Payee	Shortened to 32 characters (optional); full text moved to memo
`MEMO`	Extra description	Kept
`CHECKNUM`	Cheque number	Kept

Nothing is categorized. QuickBooks does that after import, in the For review tab or with bank rules.

OFX to QBO: Are Dates and Transaction Amounts Preserved?

Amounts: yes, exactly. The tool writes back the number your bank gave, including three-decimal currencies. The only exception is if you turn on Flip signs.

Dates: yes, the day is preserved. OFX dates look like 20260315083000.000[-5:EST]. A time zone at the end can make some software shift a late-evening transaction to the next day. With the noon option on, the tool writes 20260315120000, which lands on the same day in any time zone. DTSTART and DTEND are recalculated if you filter by date.

How to confirm it: compare the tool's transaction count, money in and money out with your bank statement before you import.

Can You Rename an OFX File to QBO?

Only in some cases. Renaming works when the file is already OFX 1.x (it starts with OFXHEADER:100) and already has an <INTU.BID> line. Most bank OFX files do not. The usual manual fix is to open the file in a text editor, add <INTU.BID>3000 under the <LANGUAGE> line, save it, and rename it to .qbo.

That manual fix does nothing about OFX 2.x XML files, missing FITIDs, long payee names or special characters. This tool handles all of those.

OFX, QBO and QFX: What's the Difference?

Format	Made for	Key feature	Convert?
OFX	Any finance app	Open standard, no Intuit bank ID	Yes, for QuickBooks
QFX	Quicken (Intuit's Web Connect for Quicken)	OFX plus an `INTU.BID`	Usually just a change of extension; this tool does it safely
QBO	QuickBooks	OFX plus an `INTU.BID`, `.qbo` extension	Ready to import

QFX and QBO files are almost identical inside. The extension tells your computer which program should open the file.

Common OFX to QBO Conversion Errors

"Nothing imported. Account up to date." QuickBooks already has these FITIDs for this account, even if you deleted the transactions. Intuit's options are to restore a backup, enter them by hand, or carefully change the account number in the file. You can do that last one with the Account number field in Advanced options.
Duplicate transactions after import. The same transactions were imported with different FITIDs, usually from two different converters or a CSV import. Stick to one method and one tool for each account.
Deposits show as withdrawals. The bank used the opposite sign convention, which is common with credit cards. Convert again with Flip signs turned on.
Payee names cut off. OFX 1.x allows 32 characters in NAME. The tool keeps the full text in the memo.
File too large for QuickBooks Online. Over 350 KB or 1,000 transactions. Split the file by date range.
"No transactions found". The file may be a balance-only download or an investment statement (INVSTMTRS). Download a transaction history instead.
Wrong bank label shown. The label comes from INTU.BID. It does not affect which account the transactions go into.

How to Check a QBO File Before Importing

Drop your .qbo file into the tool above. It runs the same checks on a finished QBO file as on an OFX file. Then confirm these points:

Header: starts with OFXHEADER:100 or an XML OFX header.
Bank ID: an <INTU.BID> line is present.
Account: the account number and type match the QuickBooks account you will import into.
Count and totals: the number of transactions, money in and money out match your statement.
Dates: the first and last dates cover the period you need, with no gap or overlap with your last import.
FITIDs: every transaction has one, and none repeat.
Size: under 350 KB and 1,000 transactions for QuickBooks Online.
Backup: for QuickBooks Desktop, back up the company file before importing.

OFX to QBO Converter FAQs

Is this OFX to QBO converter really free and private?

Yes. The converter runs entirely in your browser. Your OFX file is read, checked and turned into a QBO file on your own device, and no bank data is sent to our server. You can even disconnect from the internet after the page loads and it will still work.

What is the difference between OFX and QBO?

OFX (Open Financial Exchange) is the open standard banks use to export transactions. A QBO file is an OFX file that QuickBooks treats as a Web Connect download. It carries an INTU.BID bank ID and uses the .qbo extension so QuickBooks Desktop will accept it.

Can I just rename my .ofx file to .qbo?

Sometimes. Renaming works only if the file is already OFX 1.x (SGML) and already contains an INTU.BID tag. Most bank OFX files have no INTU.BID, so QuickBooks Desktop rejects them. This converter adds the tag, fixes the header and checks every transaction for you.

Does QuickBooks Online accept OFX files?

Intuit's help page lists QBO, QFX and CSV as the supported transaction file formats for Upload from file, with a 350 KB size limit and up to 1,000 transactions per upload. Converting OFX to QBO gives you a format that is on that list.

Why does QuickBooks say "unable to verify the Financial Institution information"?

QuickBooks Desktop checks the INTU.BID bank ID inside the file. If it is missing or not on Intuit's list, you get this message, which users often report as error OL-222. Converting with a known ID such as 3000 usually fixes it. The bank label QuickBooks shows does not matter, because you pick your own account during import.

Why did QuickBooks import nothing and say the account is up to date?

QuickBooks remembers the transaction ID (FITID) of every transaction it has imported into an account and skips any repeat. If you already imported these transactions, even if you later deleted them, QuickBooks will ignore them. Intuit suggests restoring a backup or, carefully, changing the account number in the file.

Are my dates and amounts changed during conversion?

No. Amounts keep their original value and decimals, and dates keep their original day. By default the time is set to 12:00 noon so time-zone offsets cannot move a transaction to the previous or next day. The only amount change happens if you turn on Flip signs yourself.

Can I convert a credit card OFX file?

Yes. The converter detects credit card statements (CCSTMTRS) and writes them in the credit card format QuickBooks expects. If charges show as payments after import, convert again with Flip signs turned on.

Can I use this tool to check a QBO file before importing?

Yes. Drop any .qbo, .qfx or .ofx file into the tool. It lists the account, date range, totals and every problem it finds, such as missing transaction IDs, duplicate IDs, long payee names or bad dates, before you import anything.

Resources and Sources

Manually upload transactions into QuickBooks OnlineIntuit: supported formats, 350 KB and 1,000-line limits.
Error: Nothing imported after importing a Web Connect fileIntuit: how QuickBooks blocks repeat transaction IDs.
"Unable to verify the Financial Institution information"QuickBooks Community thread on the OL-222 message.
What INTU.BID does in a QBO fileProperSoft: why the bank label can differ from your bank.
QuickBooks Desktop: importing .ofx filesSMMware: the manual INTU.BID edit and rename method.
Open Financial Exchange (Wikipedia)History of OFX, QFX and the FDX consortium.
Financial Data Exchange (FDX)The industry group that now manages the OFX specification.

Disclaimer: This free tool is not affiliated with or endorsed by Intuit. QuickBooks, Quicken and Web Connect are trademarks of their respective owners. Always compare imported transactions with your bank statement before using them for bookkeeping, tax or reporting.

Related Tools

Last reviewed: September 2026.