Upload Bank Statement to QuickBooks Online: Convert a PDF Statement to QBO for QuickBooks Online and Desktop

Q: What file format does QuickBooks Online accept for bank statements?

CSV, QBO and QFX. QBO is the Web Connect format and needs no column mapping. CSV must be cut to exactly three columns, Date, Description and Amount, or four columns, Date, Description, Credit and Debit. PDF is not accepted.

The upload screen in QuickBooks Online takes CSV, QBO and QFX files. It does not take the PDF your bank gave you, and it will not tell you that until you have already picked the file. Convert the statement 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 CSV, QBO and QFX files up to 350 KB and 1,000 lines per upload. It does not accept PDF. Convert the PDF statement to a .qbo file and upload that, which skips the column mapping step a CSV requires.

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

PDF formats the upload screen accepts

What QuickBooks Online accepts when you upload a bank statement

Most of the time lost here comes from assuming the upload screen is a document uploader. It is a transaction importer, and it only reads four things. The table below is the whole list, with what each one costs you in work after the file is chosen.

File you have	Accepted	Column mapping needed	What happens next
PDF statement from the bank	No	Not applicable	The file is rejected. You need to turn it into one of the rows below first.
.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	No	Not applicable	An image-only PDF is still a PDF. It has to be read by OCR before there is anything to upload.

File type, size and line limits 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 CSV, QBO or QFX file, pick the account it belongs to, and confirm. A PDF statement has to be converted to one of those formats first, because the upload screen will not read it.

Can QuickBooks Online read a PDF bank statement?

No. QuickBooks Online has no PDF statement reader. The manual upload screen takes CSV, QBO and QFX files only, and attaching a PDF elsewhere in QuickBooks stores the document without creating any transactions. A converter has to turn the PDF into transaction data first.

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?

CSV, QBO and QFX. QBO is the Web Connect format banks use for direct downloads and it needs no column mapping. CSV works but must be cut to exactly three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). PDF is not accepted in any of these screens.

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