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
- In QuickBooks Desktop, go to File → Utilities → Import → Web Connect Files.
- Select your
.qbofile. - Choose to import into an existing account, or create a new one when prompted.
- Review the transactions in the bank feed and add them to the register.
What has to be true
- The
.qbocarries a valid, recognized INTU.BID — otherwise you'll get “bank not authorized.” - Your QuickBooks Desktop version isn't too old (it generally stops importing Web Connect after ~3 years).
- You're importing into the right account, and not double-importing a period you already have.
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 →