How to Upload a Bank Statement to QuickBooks Online

7 min read · Updated October 29, 2026 · By the StatementCheap team

To upload a bank statement to QuickBooks Online, open Bank transactions, choose Link account > Upload from file, and add the statement. QuickBooks Online can read a PDF statement itself, or you can upload a QBO, CSV or OFX file made from it. This guide covers both ways, the file rules that trip people up, and how to import a statement into QuickBooks Desktop.

A live bank feed is still the easiest way to get transactions into QuickBooks. But feeds break, banks change connections, and a new connection only pulls a limited amount of history. When you need older history, or the account was never connected, uploading the bank statement is the way to fill the gap.

Option 1: Let QuickBooks read the PDF

QuickBooks Online can now take an account statement directly. According to Intuit's help article on manually uploading transactions, you can upload a statement as a PDF or an image (JPG, PNG or HEIC), and QuickBooks uses AI to extract the transactions. Intuit says the statement "can be from any bank, as long as it's in English."

1. Go to All apps, then Accounting, then Bank transactions.
2. Select the account tile if you see one.
3. Open the Link account dropdown and choose Upload from file.
4. Drag in the statement and select Continue.
5. Review the side-by-side view of the statement and what QuickBooks extracted. Fix anything flagged, then select Save.

Intuit notes that if some items need review, its team of experts may look at the statement, and QuickBooks will tell you on the Bank transactions page when it's ready. The transactions then show up on the Bank transactions page for that bank or credit card account.

When this is enough: you use QuickBooks Online, you have a few statements, and you're happy to review the data inside QuickBooks. Try it first. It's included in your subscription.

When a converter still helps:

• You use QuickBooks Desktop. Desktop imports bank transactions from .qbo Web Connect files, so you need the statement in that format. See PDF to QBO.
• You want a spreadsheet copy to review, edit, or send to a client or colleague before anything touches the books.
• You want an automatic check that the transactions add up from the statement's opening balance to its closing balance before you import.
• You're catching up a year or more of history and want every statement converted, checked and saved as files in one place.

Option 2: Convert the PDF, then upload the file

The same Upload from file screen also accepts transaction files. Intuit lists .csv, .txt, .qbo and .ofx, mentions QFX as well, and recommends QBO files. So the classic route still works: turn the PDF into a QBO or CSV file, check it, and upload it.

Step 1: Convert the statement

Pick QBO if you can. It carries the dates, amounts and descriptions in a structure QuickBooks expects, so there's no column mapping. Pick CSV if you want to open and edit the file in Excel first. If you already have a CSV and want a QBO, our CSV to QBO tool does that.

Step 2: Check the file before you import

• Opening balance plus all transactions should equal the closing balance on the statement.
• No page headers, subtotals or "balance forward" rows.
• No overlap with transactions already in QuickBooks. If the account already has activity, start your file the day after the last transaction that's in there. Overlapping dates are the most common cause of duplicates.

Step 3: Know the limits

Intuit's rules for transaction files: the file must be in English and 350 KB or less, with up to 1,000 lines per upload. Each line is one transaction. If you have more, split the file by date range and upload the pieces in order.

Step 4: Upload

1. Go to All apps > Accounting > Bank transactions and select the account tile.
2. Open Link account and choose Upload from file. If the account isn't connected to a bank feed, you can also use the option to upload transactions manually.
3. Select your file and choose Continue.
4. In the QuickBooks account dropdown, pick the account the transactions belong to. Pick the credit card account for a card statement, not a checking account.
5. For a CSV, match your columns to the QuickBooks fields and confirm the date format.
6. Select the transactions to import, choose Continue, then Yes and Done.

The transactions land on the Bank transactions page, where you categorize or match them like feed transactions. If you set up bank rules first, QuickBooks can apply them to uploaded transactions too.

The CSV layouts QuickBooks accepts

Intuit says each CSV needs either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit).

3-column example

4-column example

Rules from Intuit's checklist:

• Headers should read "Credit" and "Debit", without the word "amount".
• Leave a cell blank instead of entering 0.
• Use one date format for every row. Intuit's article suggests dd/mm/yyyy. Whichever you use, choose the matching format when you map the columns.
• If your bank adds the day of the week to the date (for example "TUE"), split it into its own column and delete it.
• On a Mac, Intuit suggests saving the file as a Windows CSV.

Common problems and fixes

How to upload a bank statement to QuickBooks Desktop

The PDF upload above is a QuickBooks Online feature. QuickBooks Desktop imports bank transactions from .qbo Web Connect files: Intuit's help calls .qbo "the only type Web Connect can read." It doesn't take QIF files either. So convert the statement to QBO first.

1. Convert the PDF statement to a .qbo file with a PDF to QBO converter. If you already have a CSV or a Quicken QFX file, our free CSV to QBO and QFX to QBO tools make the QBO in your browser.
2. Back up your company file.
3. Go to Banking > Bank Feeds > Import Web Connect Files and select the .qbo file. Intuit notes that you need to be signed in to your Intuit Account within QuickBooks Desktop.
4. Choose the existing QuickBooks account the transactions belong to, or create a new one. Use a credit card account for a card statement.
5. Review the transactions in the Bank Feeds Center and add or match them.

On a Mac, QuickBooks Desktop also opens Web Connect downloads from a .qbo file. If Desktop says it's "unable to verify the Financial Institution information for this download," see Intuit's help article on fixing Web Connect import errors, which lists that message. Our QFX to QBO page explains the bank ID inside QBO files and how to change it.

Which option should you pick?

For a few statements in QuickBooks Online, start with the built-in PDF upload and review carefully. For QuickBooks Desktop, a client catch-up, or any time you want a balance-checked file you can keep, convert first. The two approaches also mix well: convert to a spreadsheet to review, then upload the QBO.

Convert a statement for QuickBooks

StatementCheap turns PDF bank and credit card statements into QBO files or 3-column CSVs for QuickBooks, as well as Excel, Xero CSV and OFX. Each conversion is checked against the statement's opening and closing balances, so you see problems before they reach your books. The first 5 pages each day are free with a free account (email only, no card). Upload a statement, or read more about bank statements to QuickBooks and QBO vs OFX vs QFX.

Frequently asked questions

Can I upload a PDF bank statement to QuickBooks Online?

Yes. Intuit says QuickBooks Online can extract transactions from a statement uploaded as a PDF or an image, from any bank, as long as it's in English. Use Bank transactions, then Link account, then Upload from file.

What file types can I upload to QuickBooks Online?

Intuit lists .csv, .txt, .qbo and .ofx files, mentions Quicken QFX files too, and suggests QBO. Each file must be in English, 350 KB or less, with up to 1,000 lines.

How do I upload a bank statement to QuickBooks Desktop?

Convert the statement to a .qbo Web Connect file, then go to Banking, Bank Feeds, Import Web Connect Files. Intuit says .qbo is the only type Web Connect can read. Our PDF to QBO converter makes the file.

Why did my upload create duplicate transactions?

The file overlapped transactions already in QuickBooks, from the bank feed or an earlier upload. Exclude the duplicates, and start future files the day after the last transaction you imported.