Upload Bank Statement to QuickBooks Online as a QBO File

The upload screen in QuickBooks Online takes a .qbo, QFX or CSV file, and it now reads a PDF statement too, as long as the file is under 350 KB and the statement is in English. Multi-page and scanned statements are usually bigger than that. Convert those to a .qbo file first and the same upload finishes in one pass.

Quick answer

To upload a bank statement to QuickBooks Online, go to Transactions, then Bank transactions, then Link account, then Upload from file. QuickBooks Online accepts QBO, QFX and CSV files, and a PDF or image statement that its AI reads, all capped at 350 KB per file, with CSV and QBO lists capped at 1,000 lines. When the PDF is over 350 KB or you are on QuickBooks Desktop, convert the statement to a .qbo file and upload that instead.

No column mapping Scanned statements read too QBO and IIF output

Convert your statement to a .qbo file

Upload the PDF, check the rows, then download a file the QuickBooks Online upload screen accepts.

No credit card required to try your first statement.

350 KB

Maximum upload file size Intuit publishes

1,000

Maximum transaction lines per upload

3 or 4

Columns a CSV must have, exactly

English

The only statement language the upload reads

What QuickBooks Online accepts when you upload a bank statement

Most of the time lost here comes from not knowing which file will actually get through. The upload screen takes a statement document or a transaction list, and each behaves differently once chosen. The table below is the whole list, with what each one costs you in work.

File you have	Accepted	Column mapping needed	What happens next
PDF statement from the bank	Yes, if under 350 KB and in English	None, you review what the AI extracted	QuickBooks shows the statement next to what it read. Some statements are held for review by Intuit's team before they post. Larger files are refused.
.qbo Web Connect file	Yes	None	Dates, descriptions and amounts arrive already labelled, so transactions land in the For review tab ready to match.
.qfx file	Yes	None	Behaves like a .qbo file. Fewer US banks offer it without a Quicken subscription.
.csv export	Yes	Every time	The file must be trimmed to exactly 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), and you map them by hand on each upload.
Scanned or photographed statement	Only under 350 KB	None, you review what the AI extracted	Scans are image files, so a multi-page statement is rarely small enough. Converting it to a .qbo file gets the transactions in regardless of the scan's size, and a phone photo goes through the image to QBO converter the same way.

File types, the 350 KB size limit, the English-only rule and the 1,000 line limit above are the ones Intuit publishes for manually uploading transactions into QuickBooks Online. Intuit changes these screens from time to time, so check the current help article if an upload behaves differently.

Why the CSV route costs more than it looks

A CSV is free, so it looks like the obvious answer. The reason bookkeepers stop using it on client work is that the cost is paid per upload rather than once, and three specific things go wrong often enough to matter.

The column shape is strict

Bank exports carry running balances, check numbers, reference codes and a blank column or two. QuickBooks Online wants exactly three or four columns in a fixed order, so every export needs trimming in a spreadsheet before it will load at all.

Debits and credits flip

Some banks write withdrawals as positive numbers in a Debit column, others as negative numbers in one Amount column. Map it the wrong way once and the register reconciles to a number that is out by twice the month's spending, which is slow to spot and slower to unpick.

It repeats every month

The mapping is not saved in a way that survives a differently shaped export, so the work comes back with each statement and each new client. A .qbo file carries the field labels inside it, so there is nothing to map on any upload.

When a CSV is still the right call

If your bank offers a clean CSV export, you are uploading one account, and the columns already match, use it. It is free and it works. The case for converting the PDF instead starts when the statement is scanned, when the bank's export only reaches back 90 days, when a client hands you paper or PDFs rather than portal access, or when you are doing this for several accounts every month.

Uploading a PDF bank statement, start to finish

Step 1

Convert the PDF

Upload the statement here and read the extracted rows on screen. Scanned and photographed statements are read the same way, so a fax copy from a client is fine.

Step 2

Tie out the closing balance

Compare the converted total against the closing balance printed on the statement. A page that failed to read shows up here, before anything posts to the books.

Step 3

Upload from file

In QuickBooks Online go to Transactions, Bank transactions, Link account, Upload from file. Choose the .qbo file and pick the account it belongs to. Do the oldest period first.

Step 4

Review and match

Transactions land in For review. Match anything QuickBooks already knows about, categorize the rest, then reconcile the period as normal.

Working inside the 350 KB and 1,000 line limits

Two published limits catch people out on catch-up work, and neither error message explains itself well. A file over 350 KB is refused as too large even when it looks small on disk, and anything past 1,000 transaction lines has to be split.

Split by statement, not by year

One monthly statement almost never reaches either limit. Converting statement by statement and uploading in date order keeps every file well inside both caps, and it makes a rejected period easy to isolate. Twelve small uploads beat one that fails at line 1,000 with no clue which rows made it in.

One account per file

Plenty of US banks print checking, savings and a line of credit on one PDF. QuickBooks Online uploads into a single account at a time, so those need to come out as separate files. Check which accounts a statement actually covers before you upload, or the balances will not reconcile.

Who ends up uploading statements by hand

The bookkeeper without portal access

The client will email PDFs but will not hand over online banking credentials, which is a reasonable position for them to take. Converting what arrives in the inbox is the only route that does not depend on the client doing anything else.

The owner past the feed's 90 day window

Bank feeds typically reach back 90 days at connection. Anything older has to be uploaded, and the only record that far back is usually the PDF statement archive in online banking.

The firm whose client's bank is not listed

Smaller institutions, business credit cards and some fintech accounts never appear in the QuickBooks bank list. For those, manual upload is not a workaround, it is the permanent process.

Questions people ask about uploading bank statements

How do I upload a bank statement to QuickBooks Online?

Go to Transactions, then Bank transactions, then Link account, then Upload from file. Choose a QBO, QFX or CSV file, or a PDF statement under 350 KB, pick the account it belongs to, and confirm. A PDF over 350 KB has to be converted to a .qbo file first.

Can QuickBooks Online read a PDF bank statement?

Yes, within limits. The upload screen reads a PDF or image statement with AI and shows it side by side with the extracted transactions for review. The file must be 350 KB or less and in English. Larger or scanned statements, and anything for QuickBooks Desktop, need converting to a .qbo file.

How do I manually upload bank statements to QuickBooks Online?

Manual upload is the same Upload from file path used for any account, connected or not. Convert each monthly statement to a .qbo file, upload the oldest first, and QuickBooks places the rows in the For review tab. Uploading in date order keeps running balances sensible as you match.

What file format does QuickBooks Online accept for bank statements?

QBO, QFX, CSV, and PDF or image statements under 350 KB. QBO is the Web Connect format banks use for direct downloads and Intuit's suggested file. CSV works but must be cut to exactly three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit).

Why is my bank statement upload file too large?

Intuit caps manual uploads at 350 KB and 1,000 transaction lines. Long date ranges cross one or both. Split the data by statement period and upload each month separately, which keeps files small and makes it obvious which period failed if one does.

How do I upload bank statements to QuickBooks Desktop?

In QuickBooks Desktop go to File, then Utilities, then Import, then Web Connect Files, and choose the .qbo file. Desktop versions Intuit no longer supports have lost Web Connect import, and for those an IIF file is the route in. The same converted statement can be written either way.

Can I upload more than one bank account at a time?

No. Each upload targets one QuickBooks account. Statements that print checking and savings together have to be separated into one file per account before uploading, otherwise the transactions land in the wrong register and the reconciliation will not tie out.

Does uploading a statement duplicate transactions already in QuickBooks?

It can, if the period overlaps what a bank feed already pulled in. QuickBooks flags likely matches in the For review tab rather than posting blindly, so work through that list before accepting anything. Uploading only periods the feed did not cover avoids the problem entirely.

Turn the statement into a file QuickBooks will take

Upload the PDF, check the rows against the closing balance, and download a .qbo or IIF file that uploads without column mapping. Fifty documents a month on the Starter plan.

Convert a statement now