· guides

How to import a bank statement into QuickBooks Desktop

QuickBooks Desktop imports bank transactions from a .qbo Web Connect file. Here's the process and what has to be true for it to work.

Steps

  1. In QuickBooks Desktop, go to File → Utilities → Import → Web Connect Files.
  2. Select your .qbo file.
  3. Choose to import into an existing account, or create a new one when prompted.
  4. Review the transactions in the bank feed and add them to the register.

What has to be true

Only have a PDF or CSV? You'll need to turn it into a well-formed .qbo/OFX first — see converting a PDF statement.

A .qbo Desktop will actually accept

The converter we're building is designed to output Web Connect files with a valid bank ID for QuickBooks Desktop. Private beta.

Join the early-access list →