Import bank statements into QuickBooks
4.7/5(124 reviews)Trusted by 10,000+ finance teams
Catch up any client's QuickBooks from their PDF statements
For the months the bank feed doesn't reach: catch-up, clean-up, new clients and prior years. Upload a year of bank or card statements, see that each one balances, and import it into QuickBooks Online or Desktop.
4.7/5(124 reviews)Trusted by 10,000+ finance teams14-day free trialNo credit card required
Last updated:
How to get a bank statement into QuickBooks
There are four ways to get bank statement transactions into QuickBooks: connect a bank feed, download a QBO, QFX or CSV file from your bank and upload it, upload a single PDF statement in QuickBooks Online, or convert PDF statements to a QBO or IIF file. The first three cover recent months on accounts you can reach. For a year of history, client statements, scans or QuickBooks Desktop, convert the PDFs with DocuClipper: every statement is checked against its printed balances, then imported through QuickBooks' own Upload from file or Web Connect screen.
| Route | Use it for | In QuickBooks |
|---|---|---|
| Bank feed | Use it for: Ongoing transactions on accounts you can log in to; history only as far back as the bank sends | In QuickBooks: Bank transactions, Link account |
| File from your bank (QBO, QFX or CSV) | Use it for: Recent months your bank still offers as a download | In QuickBooks: Online: Link account, Upload from file. Desktop: File, Utilities, Import, Web Connect Files |
| QuickBooks Online PDF upload | Use it for: An occasional English statement, reviewed side by side before saving | In QuickBooks: Online only: Link account, Upload from file |
| DocuClipper PDF conversion | Use it for: A year of statements at once, client PDFs, scans, closed accounts, QuickBooks Desktop | In QuickBooks: Download a QBO, IIF or CSV file and import it on the screens above |
Comparing the built-in upload with a converter? QuickBooks' PDF upload vs DocuClipper · Need only the file? PDF to QBO converter · Every method step by step: import guide
32,226
Statements for QuickBooks (30 days)
71%
Ended more than 90 days before import
2.76M
Transactions in QBO files (30 days)
1,541
Accounts downloading QBO files
Source: DocuClipper production data, Sep 14 to Oct 13, 2026.
How to Import Bank Statements into QuickBooks
From PDF to QuickBooks-ready in four steps.
1
Upload the PDF statements
Drag in one statement or a year of them, from any bank or card issuer, scanned or digital.
2
See that each statement balances
Every transaction is pulled out and each statement is checked against its printed balances, so a missing line is flagged before import.
3
Download a QBO or IIF file
Pick the bank and account type for a QBO (Web Connect) file, or map accounts for a Desktop IIF file.
4
Import it into QuickBooks
Online: Banking, File upload. Desktop: File, Utilities, Import, Web Connect Files (or IIF Files).
Step-by-step with screenshots: QuickBooks Online · QuickBooks Desktop (Web Connect) · Troubleshooting imports
Bank feeds cover recent months. Statements cover the rest.
Most statements our customers bring into QuickBooks are history, not this month: the median one had closed about 9 months before it was imported. That is catch-up work, and it is what DocuClipper is built for. Across 32,226 statements from September 14 to October 13, 2026:
| Statement ended before import | Share of statements |
|---|---|
| Within the last 90 days | 29% |
| More than 90 days earlier | 71% |
| More than 1 year earlier | 40% |
| More than 2 years earlier | 12% |
- Catch-up and clean-up work. A year or more of history for an account that was never connected, or was connected late.
- New clients and prior-year tax work. Statements a client sends you, for accounts you have no online banking access to.
- QuickBooks Desktop. 87% of the statements exported as IIF files were more than 90 days old.
Importing history next to a live bank feed? End the file the day before the feed starts and set the opening balance from the first statement. Every method, including bank file downloads, is in the guide how to import bank statements into QuickBooks.
Everything You Need to Get Bank Data into QuickBooks
DocuClipper handles the conversion, you focus on the books.
Upload any bank statement PDF
Scanned or digital PDFs from any bank or card issuer, with no per-bank template to set up.
Every transaction, no typing
Dates, descriptions and amounts arrive in QuickBooks as bank transactions, ready to categorize in the For Review tab.
QBO for Online and Desktop, IIF for Desktop
QBO (Web Connect) lands in the bank register like a bank feed. IIF posts each line to the account you choose, and keeps working on Desktop versions without bank feeds.
Checked before it reaches QuickBooks
Every statement is added up against its printed opening and closing balances, and one that doesn't balance is flagged for a look before import.
A full year in one job
Upload 12 months of statements for an account at once. 29% of the statements converted for QuickBooks last month arrived in batches of 12 or more.
SOC 2 Type II
DocuClipper is SOC 2 Type II certified, so client bank statements are handled under audited controls.
QuickBooks Online and Desktop
QuickBooks Online
QuickBooks Desktop Pro
QuickBooks Desktop Premier
QuickBooks Enterprise
On an older QuickBooks Desktop version? Use IIF instead
Intuit retires online banking services for older Desktop versions on a rolling schedule, which is what produces “Bank feeds are no longer supported for your version.” IIF import is not part of that service, so it keeps working when Web Connect doesn't.
QBO (Web Connect)
- • Versions where Intuit still supports the import
- • Carries transaction IDs, so QuickBooks de-duplicates for you
- • Lands in the For Review queue to categorize and match
- • File → Utilities → Import → Web Connect
IIF
- • Works on discontinued versions, no upgrade needed
- • You pick the source account and the destination account per split
- • Each transaction's category becomes its destination account
- • File → Utilities → Import → IIF Files
Upload your Chart of Accounts to the project once and every IIF download is validated against it, so account-name mismatches surface before QuickBooks rejects the file. Read the IIF import guide or see the full QuickBooks Desktop integration.
Related bank statement tools for QuickBooks
Depending on your workflow, one of these formats may be a better fit.
QuickBooks Desktop (IIF)
Import statements into Desktop versions that no longer accept Web Connect files.
Bank statement to Excel
Download the same reconciled transactions as an .xlsx file for review.
PDF to QBO converter
Just need the .qbo file? Convert a PDF statement to QuickBooks Web Connect.
CSV to QBO converter
Already have transactions in CSV? Convert to QBO for a cleaner import into QuickBooks.
Bank statement to CSV
Export a plain CSV file of transactions, useful for spreadsheets or manual reviews.
Bank statement converter
Convert bank statements to any format, QBO, CSV, Excel, OFX, or QIF.
Try it on your hardest catch-up. 14-day free trial, no credit card required.
Convert a statement freeFrequently Asked Questions
QuickBooks Online can read an occasional PDF statement itself: under Bank transactions, open Link account, choose Upload from file, drop in an English statement, then review the extracted rows side by side before saving. QuickBooks Desktop does not read PDFs. For Desktop, for a year of statements, or for scans and older months, convert the PDFs to a QBO (Web Connect), IIF or CSV file with DocuClipper and import that file instead.
Yes, and without upgrading. Intuit retires online banking services for older Desktop versions on a rolling schedule, which is what produces messages like “Bank feeds are no longer supported for your version.” IIF import is separate from that service and keeps working. Convert your PDF statements with DocuClipper, export a QuickBooks Desktop IIF file, and import it under File → Utilities → Import → IIF Files.
Use QBO (Web Connect) if your version still accepts it: it carries transaction IDs, so QuickBooks handles duplicate detection and the transactions land in the For Review queue. Use IIF when Web Connect is no longer available for your version, or when you want each transaction posted directly to a chosen destination account instead of being reviewed. Upload your Chart of Accounts first and DocuClipper validates every account name in the IIF before you download it.
Yes. DocuClipper exports QBO (Web Connect) files for QuickBooks Desktop and both QBO and CSV for QuickBooks Online. Pick the format that matches your edition and import it using QuickBooks' standard bank transaction upload flow.
QBO (also called Web Connect) is Intuit's native bank transaction format, QuickBooks imports it with accounts and types already mapped. QFX is the same format used by Quicken. CSV is a plain spreadsheet; QuickBooks Online accepts it but you'll map columns manually. For the fastest import, use QBO.
Yes. Scanned PDFs go through OCR with no extra setup. Digital PDFs extract more reliably than scans, and a statement that doesn't reconcile to its printed opening and closing balance is flagged so you can review it before importing.
No. There is no per-bank template or column mapping to set up. When you download the QBO file you pick the bank from 5,531 QuickBooks bank IDs, so QuickBooks recognizes the file.
Yes. Upload a quarter or a full year of PDF statements in one job, review them together, and download the QuickBooks files to bring the history in.
As far back as you have statements. A bank feed only reaches back a limited time, often a few months, and statements cover the rest. Of the 32,226 statements converted for QuickBooks with DocuClipper from September 14 to October 13, 2026, 71% had ended more than 90 days before they were imported, 40% more than a year, and 12% more than two years. Import only up to the day before the bank feed starts so the two do not overlap.
QuickBooks checks each transaction ID (FITID) in a QBO file against what's already in the account. DocuClipper's IDs are stable across re-downloads of the same conversion, so re-importing the same file is safe. A different file covering overlapping dates gets new IDs, so trim the date range to what isn't in QuickBooks yet.
**For one English statement, use QuickBooks Online's own Upload from file. For more than a few, convert the PDFs to a QBO (Web Connect) or CSV file with DocuClipper, then upload that file on the same Upload from file screen.** DocuClipper checks the extracted transactions against the statement's printed balances, needs no per-bank template, and writes stable transaction IDs so QuickBooks handles duplicate detection.
From September 14 to October 13, 2026, 1,541 accounts downloaded 23,475 QBO files from bank and credit card statements, carrying 2.76M transactions.
What Customers Say
Real reviews from accountants, bookkeepers, and finance teams.
“DocuClipper has helped us eliminate several manual data entry processes, saving us a lot of time.”
KR
Kristin Mitchell
Accounting, United States
“It's a complete game-changer. Instead of spending hours combing through statements, we get the data we need almost instantly.”
MA
Matt
Lending, United Kingdom
“DocuClipper allowed us to enhance our advisory services, directly impacting our bottom line.”
SA
Sarah Winship
Accounting, United Kingdom