CSV to QBO Converter for QuickBooks
Turn the CSV file your bank gives you into a QBO file you can import into QuickBooks. Columns, dates and signs are detected for you. Your file never leaves your computer.
- Free, no sign-up
- Files stay on your computer
- CSV → QBO
Drop your CSV file here
or
Converted in your browser. Your file is never uploaded.
| Date | Description | Amount |
|---|
How to convert CSV to QBO
- Download your transactions from your bank as a CSV file.
- Drop the CSV file in the box above. Check that the Date, Description and Amount columns are right in the preview.
- Choose the account type and download your QBO file.
- In QuickBooks, open the bank account, choose File › Utilities › Import › Web Connect Files (Desktop) or Upload from file (Online), and pick the QBO file.
What is a QBO file?
A QBO file is the Web Connect format QuickBooks uses to import bank transactions. Inside, it is an OFX file (Open Financial Exchange) with one extra line: an Intuit bank ID, called INTU.BID.
Many banks only offer CSV downloads, or stop offering QBO files after a few months of history. Converting the CSV to QBO lets you import those transactions with the normal bank feed screen, where QuickBooks matches and categorizes them.
Tips for a clean import
- Some credit card exports show purchases as positive numbers. If your spending shows as money in, tick "Flip signs".
- Use the same account number every time for the same account. QuickBooks uses it to remember which account the file belongs to.
- Each transaction gets a stable ID, so if you import the same transaction twice, QuickBooks can recognise it.
Frequently asked questions
Does the QBO file work with QuickBooks Online and QuickBooks Desktop?
The file follows the QuickBooks Web Connect format (OFX 1.0.2 with an INTU.BID), which both QuickBooks Online and QuickBooks Desktop import. QuickBooks Desktop checks that the bank ID belongs to a bank it supports; you can change the bank ID in the options if needed.
What is the "QuickBooks bank ID" option?
It is the INTU.BID value inside the file. QuickBooks Desktop uses it to check that the file comes from a bank on its list. The default works for most imports. If QuickBooks says your bank is not supported, try the bank ID QuickBooks shows for your own bank.
My bank CSV has separate Debit and Credit columns. Is that OK?
Yes. The converter finds Debit/Credit (or Money in/Money out) columns and turns them into one signed amount. Money out becomes negative, money in becomes positive.
My dates are in day/month/year format. Will they be read correctly?
The tool checks every date in the file. If any day is above 12, it knows the order. If all days are 12 or lower, it asks you to confirm the format in the preview.
Is it free?
Yes. The CSV, QIF, OFX and QBO converters are free with no sign-up and no limit on the number of transactions, because they run on your own computer. Our only paid tool is the PDF statement converter, which needs a server to read PDF files.
Is my bank data uploaded anywhere?
No. The conversion runs inside your browser. Your file is never sent to our server, and we cannot see it. You can even disconnect from the internet after the page loads and the tool still works.