Download Bank Statements into QuickBooks Online
Nov 16, 2026
Upload your bank statement
PDF, JPG, PNG, BMP, HEIC or TIFF, up to 50MB
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF · Max 50MB
Uploading...
Same tool as our bank statement to QBO converter. Free to try, no card needed.
To download bank statements into QuickBooks Online, first look at what your bank lets you download. If it offers a Web Connect (.qbo) or QFX file, download that and upload it in QuickBooks. If it offers only a PDF statement, convert the PDF to a .qbo with the bank statement to QuickBooks converter, then upload the result. A live bank feed is the third route, and it only covers the period after you connect it.
Most of the confusion on this topic comes from one word. "Download" can mean pulling a file from your bank, or pulling transactions from the bank straight into QuickBooks. They are different mechanics with different limits, and the right choice depends on how far back you need to go and which formats your bank actually exposes.
Which download route fits your situation?
| Situation | Best route | Watch out for |
|---|---|---|
| Current month, bank supports a direct connection | Bank feed | Starts when you connect, so no earlier history |
| Bank offers a .qbo or QFX download | Download the file, upload in QuickBooks | Banks often cap how far back the file reaches |
| Bank offers CSV only | CSV upload with column mapping | Signs, dates and columns are yours to map, and mistakes post silently |
| Only PDF statements exist, or a client sent a scan | Convert the PDF to .qbo, then upload | Check the parsed total against the statement |
| A full prior year for a new client | Convert twelve statements, import each, reconcile monthly | Import in order so opening balances line up |
How do I download a bank statement to QuickBooks Online?
Sign in to your bank, open the account and find the statements or export area. Download the file type your bank labels for QuickBooks, usually called Web Connect or .qbo. In QuickBooks Online go to Transactions, then Bank transactions, then Upload from file, choose the file and map it to the right account. The lines appear in the review queue for matching and categorizing.
What if my bank only gives me a PDF statement?
This is the common case for older periods, smaller banks, credit unions and anything a client mails you. Upload the PDF to the converter at the top of the homepage. It returns a .qbo with each transaction's date, description and amount, and checks the parsed total against the statement before you export. Then upload that .qbo exactly as you would a bank-supplied one.
QuickBooks Online has also begun reading PDFs directly, which we cover in can QuickBooks import a PDF bank statement. A converted .qbo is still useful when you want a file you can inspect, re-import for a single month, or hand to a colleague.
Why does my bank's download stop after a few months?
Banks set their own retention for downloadable transaction files, and many provide far less history than they keep as PDF statements. That is why a feed or a .qbo download can leave a hole while the statements archive goes back years. The PDF is the complete record, so when the downloadable file runs out, the statement is what you convert. Our guide to importing old bank statements into QuickBooks walks through that case.
A worked example, filling a six month gap
A bookkeeper takes over a client in October. The feed was connected in July, so July to October is covered. January to June is missing, and the bank's file download reaches back only a few months. The bookkeeper downloads six PDF statements from the bank, converts them to six .qbo files, and uploads them oldest first, reconciling each month against its statement before moving on. If the first statement shows 48 transactions and the converter reports 48 with matching totals, that month is done. Nothing is retyped, and each month closes against a source document.
| Month | Source | Check before moving on |
|---|---|---|
| January to June | Six converted PDF statements | Ending balance equals next month's opening balance |
| July to October | Bank feed | Reconcile to the statement as usual |
| Any month with a feed gap | Convert that statement | Look for duplicates with the feed before accepting |
How do I avoid duplicates when mixing a feed and uploaded files?
Upload files only for dates the feed does not cover, and import in date order. If the periods overlap, QuickBooks usually flags likely duplicates in the review queue, but you should still reconcile to the statement balance. See bank feed versus manual import for how the two behave together.
What should I check before uploading a downloaded file?
Four checks catch nearly every bad import. First, the account: pick the right QuickBooks account in the upload screen, because a file posted to the wrong account is tedious to unwind. Second, the date range: confirm the first and last transaction dates match the period you meant to load. Third, the count: compare the number of lines in the file with the number of transactions on the statement. Fourth, the balance: after accepting the lines, the register balance should land on the statement's closing balance.
If the count is off, the problem is almost always upstream of QuickBooks, a page of the PDF that did not parse or a CSV row dropped by a mapping rule. That is the practical reason to prefer a converter that reports its parsed total. A silent shortfall is the expensive kind, because it surfaces at reconciliation or, worse, at tax time. When a .qbo is rejected outright, why QuickBooks will not import a QBO file lists the usual causes in the order to check them.
How many statements does a typical backlog involve?
One account for twelve months is twelve statements. Add a business credit card and it is twenty four. A client with a checking account, a savings account and two cards over eighteen months is seventy two. Converting in a batch and importing oldest first turns that from a typing job into a checking job, and the bulk conversion page covers how a batch runs.
Does this work in QuickBooks Desktop?
Yes. A .qbo is a Web Connect file, so in Desktop you use File, Utilities, Import, Web Connect Files. The Desktop walkthrough covers the account prompts. Intuit's own reference for the upload steps is its support article on uploading transactions, which is worth bookmarking for the current screens.
Which route should a business owner pick?
Connect the feed for everything going forward, because it is automatic. For history, use whatever the bank gives you in the richest format, and where that is only a PDF, convert it. Owners who handle their own books once a year and bookkeepers closing a backlog both land in the same place: the statement is the source of truth, and a .qbo is the way to get it into QuickBooks without typing. You can try the converter on a real statement from the top of the homepage and see the parsed total before you commit to anything.
Convert your first statement free.
Upload a PDF bank statement, see every transaction extracted in seconds. No card to try it.
Still comparing tools? See our bank statement to QuickBooks converter comparison.