How to Upload Bank Statements to QuickBooks Online

To upload bank statements to QuickBooks Online, open Bank transactions, choose Upload from file and pick the account. QuickBooks Online can now read an English PDF statement with AI and shows what it extracted for review. If that route fails, convert the PDF to a CSV or QBO file and upload that. Either way, compare the closing balance.

Does QuickBooks Online accept a PDF bank statement?

Yes, in current QuickBooks Online. Intuit's page on uploading transactions manually says the Upload from file screen takes an account statement as a PDF or an image (JPG, PNG or HEIC), from any bank, as long as it is in English. Its AI extracts the lines and shows them beside the statement so you can edit them before you save.

That route has limits worth knowing. Intuit says some items may be flagged for review by its own team, so the statement is not always ready straight away. The extraction is still a reading of a printed page, so you check every line against the PDF before you rely on it. Attaching a PDF to a transaction is a different thing: an attachment is kept as a record and is never turned into transactions.

When a converted file is the better route

The same upload screen also takes a transaction list. Intuit names QBO as the suggested file type and accepts QFX and CSV too, with a limit of 350 KB and 1,000 lines per upload. A converted file makes sense when:

• you want to open and check the rows in a spreadsheet before anything touches your books;
• the statement is not in English;
• the AI extraction is waiting on review and you need the month in today;
• you also need the same transactions for Xero or for an accountant.

Your choices

You have four ways to get from a PDF to transactions in QuickBooks Online:

1. Upload the PDF itself and review what QuickBooks extracts.
2. Ask your bank for a file instead. Many banks offer a QBO or CSV download from online banking. If yours does, skip the PDF entirely.
3. Type the lines in by hand. Reasonable for a handful of transactions, painful for a month of activity and prone to mistakes.
4. Convert the PDF into a CSV or QBO file. The rest of this post follows this route, and its balance checks apply to the other three as well.

CSV or QBO?

Both work with QuickBooks Online. A QBO file needs no column matching, so it is the quickest to upload. A CSV is easy to open and check in a spreadsheet first, but QuickBooks asks you to tell it which column holds the date, the description and the amount. If you are unsure, pick the one you find easier to check.

From statement PDF to upload-ready file in three moves

The shortest route has three moves: get the transactions out of the PDF into a table, tidy the table so QuickBooks reads it correctly, and save it as a CSV or QBO file. Do them in order, and keep the original PDF to check against.

Move 1: get the transactions out

Download the PDF from your bank's website. A downloaded PDF contains real text; a scan or a photo does not, and is harder to read accurately. Copy each dated line into a table with a date, a description and the money. If you have only paper statements, scanning paper statements into QuickBooks covers the extra care they need.

Move 2: tidy the table

QuickBooks wants these things from your file:

• One date format, such as MM/DD/YYYY, the same on every line.
• One amount column, with money out as a negative number and money in as a positive one. If the statement shows paid out and paid in separately, merge them.
• Descriptions on a single line, so a payee name that wrapped over two printed lines is joined back together.
• No extras: no balance rows, no page subtotals, no header text in the middle of the data.

Move 3: save it in the right format

For a CSV, save the table as a file with a .csv extension and plain columns. For a QBO file, the rows have to be written into the tagged structure, which is the job of a converter. The detail of that structure is in the post on converting a PDF to QBO.

SimpleBankConvert does these three moves for you: you give it the PDF, and it gives back a CSV or QBO file with the dates tidied and the money merged into one column. It is in early access and accounts are not open yet, so you can get started and be told when it opens.

A short worked example

Take a statement with a paid out column and a paid in column. A line of "Mar 4, POS PURCHASE PINECREST OFFICE SUPPLY, 86.42 in the paid out column" becomes "03/04/2026, Pinecrest Office Supply, -86.42". A line of "03/02/26, ACH CREDIT BRIGHTWATER CAFE, 1,250.00 in the paid in column" becomes "03/02/2026, Brightwater Cafe, 1250.00". These are examples only, but they show every change: the date is standardised, the amount carries a sign, and the thousands comma goes.

The end-to-end checklist

1. Download the PDF statement from your bank's website.
2. Note the opening balance, closing balance and statement period.
3. Convert the PDF to a CSV or QBO file.
4. Check the file: row count, and opening balance plus movements equals closing balance.
5. Upload the file to QuickBooks Online and choose the correct account.
6. Review the transactions QuickBooks shows and accept them.
7. Compare the QuickBooks balance on the statement's closing date with the closing balance on the statement.

The upload screens themselves, including the buttons to press, are shown in the QuickBooks Online upload screens, step by step, so this post does not repeat them.

Uploading one month's statement versus a whole year

Upload one statement at a time, oldest first, and confirm each month before starting the next. A year of transactions in a single file works, but a mistake in month two is then buried under eleven more months. Monthly uploads keep each check small.

Why one at a time

Each statement has its own opening and closing balance, and those balances give you a check you can do every time. If you upload twelve months in one go, you get one check at the end, and a mismatch could come from any month. With monthly files, a mismatch points to one month, and you fix it before it spreads.

Order matters

Go from the oldest month to the newest. That way the balance in QuickBooks rolls forward in the same order the bank's did, and each month's opening balance should match the previous month's closing balance. If it does not, you have found a gap before you have built on it.

When a single big file is fine

A single large file is sensible if the account is quiet, with few transactions, or if you have already tested the conversion and trust it. A transaction list upload is capped at 350 KB and 1,000 lines, so a busy year may be refused. If that happens, split it by month.

Keep a log

For a catch-up job, a simple list helps:

The figures are examples. The point is to tick each month off only when the two balances agree.

Older history

If you are loading statements from well before the current period, the date range matters. The same rules hold: go oldest first and check each month. The date limits for history that far back are covered in importing older bank transactions into QuickBooks Online.

Attaching the statement PDF to QuickBooks for your records

You can keep the PDF in QuickBooks as a record, separate from any import. QuickBooks Online lets you attach files to many transactions, so the original statement can sit beside your books as the source document. Attaching is a record-keeping step and does not change any numbers.

Why keep it

The PDF is the bank's own statement of what happened. If you or your accountant ever questions an entry, or a tax authority asks for support, the original is the strongest evidence you have. A converted CSV is your working copy; the PDF is the source.

Where to attach it

QuickBooks lets you attach a file to a transaction through its attachment control. A sensible habit is to attach the month's PDF to the closing entry or the reconciliation for that month, so each month's statement is easy to find. The exact buttons can change between QuickBooks releases, so look for the paperclip or "Attachments" control on the transaction or reconciliation screen.

Other places to keep it

If you do not want to attach files, keep the PDFs in a folder named by account and month, for example "Business checking 2026-03.pdf". Whichever way you store them, keep the naming consistent so a year later you can find the right month in seconds.

What not to do

Do not rely on the attachment as a substitute for importing. QuickBooks keeps an attachment as a document and will not turn it into transactions, and it will not appear on a reconciliation as data. Likewise, do not delete the PDF once the transactions are in, since the PDF is your proof the import was right.

Is the uploaded statement balance right?

After an upload, check the balance: the QuickBooks account balance on the statement's closing date should equal the closing balance printed on the statement. If they match, your import is complete. If they differ, the gap shows what went wrong.

The check

1. Open the account register for the bank account in QuickBooks.
2. Find the running balance on the last day of the statement period.
3. Compare it with the closing balance on the PDF.

Note that the register balance reflects every transaction in the account, not only the ones you uploaded. If the account had a balance before this month, the closing figures only agree if the opening balance did.

Reading a mismatch

The size of the gap usually names the cause: one amount off means a missing or doubled line, and twice one amount means a flipped sign. The full table of gaps and causes is in checking the QBO file against the PDF totals.

Reconciling formally

QuickBooks has a reconcile tool that asks for the statement ending balance and ending date, and then lets you tick the transactions that cleared. Using it is the strongest check, because it forces you to account for every line. A statement that reconciles to zero difference is a statement you can trust.

Duplicates

If you uploaded a line that was already in the account, perhaps from a bank feed or a previous file, the balance will be too high or too low by that amount. QuickBooks tries to flag likely duplicates, but it can only do that if the transaction details match, and a manually converted file may not match what the feed brought in.

Statement periods that overlap a bank feed

If a bank feed already brought in part of the month, upload only the dates the feed missed. Importing the whole statement on top of a feed creates duplicates. Trim the file to the missing days, or check for duplicates before you accept anything.

How overlap happens

A bank feed connects QuickBooks to your bank and pulls transactions automatically. It can start part-way through a month, stop for a few days after a password change, or begin a few weeks after you opened the account. You then have a feed covering some dates and a PDF covering the whole month.

Handling it

1. Look at the transactions in QuickBooks and note the first and last dates the feed covered.
2. Find which dates in the statement fall outside that range.
3. Build your file from only those missing dates.
4. Upload it, and confirm the balance.

For cutting a file down to the gap, trimming the import file to the missing dates only is set out in its own post, so follow that one for the detail.

If you have already uploaded duplicates

Look for pairs of lines with the same date, description and amount. Exclude or delete the extra copy rather than the original, and recheck the balance afterwards. If a whole month is doubled, it can be quicker to remove the uploaded batch and start again from the trimmed file.

A rule of thumb

The cleanest set-up is one source per date range: the feed for the days it covers, the uploaded file for the days it does not. Mixed coverage invites duplicates, so write the date ranges down before you start. For a wider look at which route to use, how to import bank transactions into QuickBooks Online gives an overview of the options.