Convert OFX to QBO
Free OFX to QBO converter. Rewrap a bank OFX download as a QuickBooks .qbo file in seconds, in your browser, with no upload and no row limit.
Coming soon: OFX to QBO
Reading that format is still being built. The converter below already turns CSV and Excel statements into a QuickBooks .qbo file, which covers most of the same work.
Drop a CSV or Excel statement here
.csv, .txt, .xlsx and .xls — or choose a file
Your file never leaves your browser.
About OFX to QBO
OFX is the open format every US bank speaks behind the scenes. QBO is the same format with an Intuit bank id stamped on it. So when QuickBooks Online refuses your .ofx download, it is not because the data is wrong — it is because the file does not identify itself as a Web Connect file from an institution Intuit knows.
Converting OFX to QBO rewrites that wrapper and leaves the ledger alone. Posted dates, amounts, payee names, memos, check numbers and transaction types all survive the trip. The converter picks the right message set for the account you are importing into: checking and savings statements are written as bank statements, credit cards are written as credit card statements. Choosing the wrong one is the single most common reason an otherwise valid file is rejected, so the account type is a question you are asked up front rather than a setting buried in an options panel.
Everything happens in your browser. The file is read with JavaScript on your own machine, converted in memory and handed back as a download. No copy is stored, which is the answer bookkeepers need when a client asks where their statement went. There is no row limit either; if a file is over the 1,000 transaction ceiling QuickBooks Online enforces per upload, it is split into numbered files you can import one after another.
OFX reading is not finished yet. In the meantime the converter below turns the CSV or Excel export of the same account into the same .qbo file.
How to convert OFX to QBO
- Export the transactions from your bank. While OFX reading is being finished, use the CSV or Excel export of the same account.
- Drag the file onto the converter. It never leaves your browser.
- Confirm the detected bank preset, or map the columns yourself if your bank is not recognised.
- Set the account type and account number, then review the preview table for duplicates and odd rows.
- Download the .qbo file and import it in QuickBooks Online through Transactions, then Upload from file.
Frequently asked questions
- What is the difference between OFX and QBO?
- They are the same file format. A .qbo file adds the INTU.BID tag that identifies the institution to QuickBooks Online; a plain .ofx file does not have it, which is why the import screen turns it away.
- Can I just rename my .ofx file to .qbo?
- Usually not. The extension is only half the problem: without a bank id inside the file, QuickBooks Online still refuses it, and the message set has to match the account type.
- Is there a row limit?
- Not in the converter. QuickBooks Online itself accepts at most 1,000 transactions per upload, so larger statements are split into several .qbo files automatically.
- Does my file get uploaded anywhere?
- No. The conversion runs entirely in your browser. Nothing is transmitted, logged or stored.
- Which account types are supported?
- Checking, savings, money market, credit line and credit card. The account type decides which statement block is written, so pick the one that matches the QuickBooks account you are importing into.