How to Convert CSV to QBO (Free, Without Uploading Your Bank Data)

Banks are happy to give you a CSV file. QuickBooks Desktop, however, imports bank activity only as a Web Connect file with the .qbo extension. Converting one into the other takes about a minute if the CSV is clean — and a lot longer if you fight with dates, signs and debit/credit columns by hand. This guide shows the fast way and explains what to check so the import goes right the first time.

What you need

• A CSV (or Excel) export of the account from your online banking. Most banks call it “Download transactions”, “Export” or “Spreadsheet (CSV)”.
• A converter that writes valid QBO files. The free CSV to QBO converter on this site works in your browser, so the file is never uploaded anywhere.
• QuickBooks Desktop (Pro, Premier or Enterprise for Windows) or QuickBooks Online.

Step 1 — Export the right CSV from your bank

Choose the date range you want to bring into QuickBooks and export one account per file. If the bank offers several CSV layouts, prefer the one with a single Amount column; separate Debit and Credit columns work too.

Open the file once in a text editor (not Excel, which can silently change dates) and check:

• every transaction is on its own row,
• there is a date and an amount on every row,
• summary lines such as “Opening balance” or “Total” are at the top or bottom — the converter skips rows without a valid date and amount, but it is good to know they are there.

Step 2 — Convert the CSV to QBO

1. Open the CSV to QBO converter and drop the file into the box.
2. Check the detected columns. The converter recognises common headers such as Date, Posting Date, Description, Payee, Amount, Debit, Credit and Check Number, and guesses headerless files by content.
3. Look at the preview and the totals. Money out must be negative and money in positive. If purchases on a credit card export show as positive, tick Reverse signs.
4. If dates look wrong (for example 3 October became 10 March), switch the date order between MM/DD/YYYY and DD/MM/YYYY.
5. Choose the account type — checking, savings or credit card — and click Download QBO.

The converter also creates a stable transaction ID (FITID) for every row from its date, amount and description. If you import the same file twice, QuickBooks recognises the duplicates.

Step 3 — Import the .qbo file into QuickBooks

QuickBooks Desktop

1. Go to File → Utilities → Import → Web Connect Files.
2. Select the .qbo file.
3. Choose an existing bank account to link it to, or create a new one.
4. Open the Bank Feeds center and review, match or add the downloaded transactions.

QuickBooks Online

1. Go to Banking → Bank transactions.
2. Open the Link account drop-down and choose Upload from file (on some accounts the button is called Upload transactions).
3. Select the .qbo file, pick the QuickBooks account it belongs to and continue.
4. Review the transactions in the For review tab and categorise them.

QuickBooks Online can also take the CSV directly — see how to import a CSV into QuickBooks Online. A QBO file is still handy there because it carries transaction IDs and does not need column mapping.

Troubleshooting

“The bank is not supported” / Web Connect error in QuickBooks Desktop. QuickBooks Desktop checks the bank ID (INTU.BID) stored in the file. Open Settings in the converter and try a different bank ID, then convert again.

Amounts have the wrong sign. Use Reverse signs. This is typical for credit card exports where purchases are positive numbers.

Some rows are missing. The preview lists skipped row numbers. These are usually totals, balances or pending transactions without a final amount. If a real transaction was skipped, its date or amount column is probably in an unusual format — check the column selection.

Payee names are cut off. The OFX standard allows 32 characters for the payee name. Longer descriptions are kept in full in the memo field.

Can I convert Excel files instead?

Yes. The Excel to QBO converter reads .xlsx and .xls files directly — there is no need to save as CSV first. It converts the first worksheet.

Summary

Export one account to CSV, drop it into the CSV to QBO converter, make sure money out is negative, download the .qbo file and import it via File → Utilities → Import → Web Connect Files in QuickBooks Desktop or Upload from file in QuickBooks Online.