Skip to content
statement2sheets

Getting bank transactions into QuickBooks Desktop without a .QBO file

· 5 min read

QuickBooks Desktop's bank import is fussier than QuickBooks Online's. Web Connect only reads .QBO files, and many banks don't offer one, or only offer the last few months. If all you have is a CSV, an OFX file or a pile of PDF statements, there are still ways in.

First, check whether your bank has a .QBO download

It's worth one more look. On your bank's transaction download page, look for an option labelled "QuickBooks", "Web Connect" or ".QBO". If there is one, import it from File → Utilities → Import → Web Connect Files. It's the route QuickBooks Desktop is built for.

Why a CSV doesn't work

QuickBooks Desktop has no "upload a CSV of bank transactions" option like QuickBooks Online's. Intuit's answers in its community say so directly and point to .QBO files instead. Renaming a CSV to .QBO doesn't help, and renaming an OFX file usually doesn't either: QuickBooks Desktop expects an INTU.BID identifying a bank registered with Intuit, which only your bank can provide.

Option 1: Batch Enter Transactions (Accountant and Enterprise)

If you use QuickBooks Desktop Accountant or Enterprise, you can paste transactions in from a spreadsheet. According to Intuit, only those two editions support batch entering transactions from Excel or CSV files.

  1. Get the transactions into a spreadsheet, one row per transaction.
  2. Open Accountant → Batch Enter Transactions.
  3. Choose the transaction type and the bank or credit card account.
  4. Arrange your spreadsheet's columns in the same order as the columns in that window.
  5. Copy the rows from the spreadsheet, right-click the first date field in the window, and choose Paste.
  6. Anything QuickBooks doesn't recognise, such as a new payee, shows in red. Add it with Quick Add or Set Up, then save.

Money in and money out are different transaction types (for example deposits and checks), so it's usually easiest to sort the spreadsheet and paste each type as its own batch.

Option 2: other editions

According to Intuit, other editions, such as Pro and Premier, can't batch-enter transactions from Excel or CSV. Your choices there are:

  • Keep asking the bank for .QBO. Some banks offer Web Connect only for some account types, or only through a business login.
  • Enter the transactions by hand in the register, working from a clean spreadsheet so at least the reading and totalling is done.
  • Use an import tool built for QuickBooks Desktop. Several third-party tools exist; check they're compatible with your version, and back up your company file before any import.

Getting the spreadsheet in the first place

  • From a CSV: the free bank CSV converter cleans up a bank's CSV into Date, Description and Amount columns, with one date format and money out as negative.
  • From an OFX or QFX file: the OFX and QFX viewer exports the transactions as CSV.
  • From PDF statements: the statement converter reads them in your browser and checks every statement against its closing balance before you paste anything into QuickBooks.

Whichever route you take, compare the account's balance in QuickBooks with the bank statement's closing balance afterwards. If they agree, nothing was missed or entered twice.

More from the blog