How to Import a Bank Statement into QuickBooks
QuickBooks Online does not read PDF bank statements. To import one, convert it to a .qbo or CSV file, upload that through Bank transactions > Upload from file, and add the transactions from For review. The steps below follow Intuit's own instructions.
Upload a bank statement to QuickBooks Online
Convert the PDF statement to a .qbo or CSV file
QuickBooks Online uploads only .csv, .txt, .qbo and .ofx files — not PDF. Convert the statement to QBO (or to CSV if you want to map the columns yourself). A scan or phone photo of a paper statement works the same way.
Open Bank transactions
In QuickBooks Online go to Accounting, then Bank transactions, and select the account tile if you see one.
Choose Upload from file
Open the Link account dropdown and select Upload from file. If the account is not connected to online banking, the option is called Upload transactions instead.
Pick the file and the account
Select the converted file, choose the QuickBooks account the transactions belong to — a bank account, or the credit card account for a card statement — and, for a CSV, match its columns to Date, Description and Amount.
Review, then add or match
The transactions land in For review. Nothing reaches your books until you categorise each one and add it, or match it to a transaction already recorded.
What QuickBooks Online accepts
From Intuit's article on manually uploading transactions:
- File types: .csv, .txt, .qbo or .ofx. Intuit suggests QBO.
- Size: 350 KB or less, and up to 1,000 lines per upload.
- CSV layout: three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), in English, with one date format throughout.
- Where to start: at least one day before the earliest transaction already in the QuickBooks account, so nothing is entered twice.
A statement converted to QBO fits these without editing. The file carries the date, description and signed amount of each transaction, and a card statement is written as a credit card account. A converted CSV uses the three-column layout, with dates as YYYY-MM-DD and money out negative.
If your bank already gave you a CSV and QuickBooks will not map it — too many columns, account details above the header, separate debit and credit columns — skip the mapping: the CSV to QBO converter turns the export into a .qbo with nothing to match. A Quicken file goes through QFX to QBO or QIF to QBO, and to check what a .qbo holds before uploading it, open it as a spreadsheet.
Importing into QuickBooks Desktop
Desktop treats a .qbo file as a Web Connect download from a bank. Intuit's Web Connect troubleshooting article asks for a supported Desktop version, a backup of the company file, and a .qbo downloaded from the bank's own site, and lists the error "QuickBooks is unable to verify the Financial Institution information for this download". A file made from a PDF statement has no bank behind it, so it is the wrong route for Desktop.
For Desktop, convert the statement to Excel or CSV and use your version's import for spreadsheet transactions; the menu differs between Desktop releases. The Online vs Desktop page covers which file goes where.
When an upload goes wrong
- The file is too large
- The upload is over 350 KB or 1,000 lines. Split it by date range and upload each part.
- Rows are missing a date, description or amount
- A CSV copied from a PDF usually holds page headers, balance lines and wrapped descriptions on rows of their own. Convert the statement instead of copying it, so every row is one transaction.
- Spending shows up as income
- The Credit and Debit columns were mapped the wrong way round, or a card statement's signs were taken as printed. A .qbo file has no columns to map, and a converted card statement already has purchases negative.
- Day and month are swapped
- The file mixes date formats, or QuickBooks read 03/04 the other way. Use one format throughout; QBO files store dates as year-month-day, which cannot be misread.
- Transactions appear twice
- Two statements overlapped, or the same file was uploaded twice. Exclude the duplicates in For review rather than adding them.
Frequently asked questions
Can I upload a PDF bank statement into QuickBooks Online?
No. Intuit lists .csv, .txt, .qbo and .ofx as the file types for a manual upload. A PDF statement has to be converted to one of them first — QBO is the one Intuit suggests.
How do I upload a bank statement to QuickBooks Online?
Accounting > Bank transactions > Link account dropdown > Upload from file (Upload transactions if the account has no bank connection). Choose the .qbo or CSV file, pick the account, map the columns if it is a CSV, then review the transactions in For review.
Is there a size limit for uploading a bank statement?
Yes. Intuit limits an upload to 350 KB and 1,000 lines. A year of a busy account can pass that, so convert it as one file and upload it in date ranges, or convert month by month.
What does a CSV need for QuickBooks Online?
Either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), one date format throughout, and no word "amount" in the credit and debit headers. A converted CSV has the three-column layout with money out negative, so you map Date, Description and Amount and leave the rest.
How do I import a credit card statement into QuickBooks?
The same way as a bank statement, choosing the credit card account in the upload step. Convert the card statement to QBO: the file is written as a credit card account, with purchases negative and payments positive, so charges do not import as payments.
Does a converted .qbo file work in QuickBooks Desktop?
Do not count on it. Desktop imports .qbo files as Web Connect downloads and checks which bank the file came from — Intuit documents the error "QuickBooks is unable to verify the Financial Institution information for this download". A file converted from a PDF has no bank behind it, so for Desktop convert to Excel or CSV and bring the transactions in through Desktop's own import.
How do I avoid duplicate transactions?
Start the upload at least one day before the earliest transaction already in that QuickBooks account, as Intuit advises, and check the account before uploading. Overlapping statements show up in For review, where a duplicate can be excluded instead of added.
Will importing a statement change my balances?
Not on its own. Uploaded transactions wait in For review and only reach the register when you add or match them.