OFX to QBO Converter

QuickBooks only imports OFX data packaged as a .qbo Web Connect file. Drop an .ofx file here and get a .qbo that QuickBooks accepts, with the bank's transaction IDs kept intact.

  1. Upload
  2. Check
  3. Download

Drop your .ofx file here

or choose a file

Files are processed in your browser and never uploaded.

Only have a PDF statement? Convert PDF to QBO →

How to import the file

QuickBooks Desktop

  1. 1Go to File > Utilities > Import > Web Connect Files.
  2. 2Select the .qbo file you downloaded and click Open.
  3. 3Choose "Use an existing account", pick your bank or card account, then review the transactions in the Bank Feeds center.

QuickBooks Online

  1. 1Go to Transactions > Bank transactions, open the Link account menu and choose Upload from file.
  2. 2Drag in the .qbo file, then choose which QuickBooks account the transactions belong to.
  3. 3Click Continue, then categorise or match the transactions under For review.

What the .qbo file looks like

A .qbo file is plain text in the OFX format that QuickBooks reads. The header and bank ID come first, then one block per transaction with its own ID, so QuickBooks can skip anything it has already imported.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
…
<INTU.BID>3000
…
<BANKTRANLIST>
<DTSTART>20260115120000
<DTEND>20260116120000
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260115120000
<TRNAMT>-42.50
<FITID>20260115b07214c56caac787
<NAME>HOME DEPOT #4521
<MEMO>Debit card purchase
</STMTTRN>
… one <STMTTRN> block per transaction
<LEDGERBAL>
<BALAMT>5012.83
<DTASOF>20260116120000
</LEDGERBAL>

Questions

What is the difference between OFX and QBO?

A .qbo file is an OFX file with an extra Intuit bank ID (INTU.BID) that QuickBooks requires. The transaction data is the same, which is why converting is lossless.

Can I just rename .ofx to .qbo?

Sometimes, but QuickBooks usually rejects it because the INTU.BID tag is missing, or the file is OFX 2.x XML, which QuickBooks Desktop does not read. This converter writes the OFX 1.02 SGML dialect with the bank ID QuickBooks expects.

Do you support OFX version 2 (XML) files?

Yes. OFX 1.x (SGML) and 2.x (XML) files both work, including files with several accounts; you pick the account to convert.

Are the original transaction IDs kept?

Yes. The bank's FITID for each transaction is copied to the .qbo file, so QuickBooks can match transactions it already downloaded from your bank and avoid duplicates.

Is the OFX file uploaded?

No. Conversion runs in your browser and the file never leaves your computer.

More free converters

Have PDF bank statements?

Extract transactions from PDF statements, checked against the statement balances.

See pricingConvert PDF to QBO