How to Import Bank Transactions into QuickBooks Online (CSV, Excel & PDF)

Short answer: QuickBooks Online cannot read a PDF bank statement directly, but it does import bank transactions from a CSV or Excel file. Go to Transactions > Bank transactions > Upload from file, then upload a CSV in one of two exact layouts: a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit). Each upload takes up to 1,000 transactions and the file must stay under 350 KB, so most people import one statement or one month at a time.

That is the whole job in a sentence. The reason it trips people up is the file. QuickBooks Online (QBO) is strict about columns, headers, dates, and symbols, and a bank export almost never matches on the first try. Below is every method that works in 2026, the exact format QuickBooks expects, and the errors that block most imports.

QuickBooks Online bank-import formats and limits at a glance

Here is what QuickBooks Online will and will not accept when you upload transactions yourself, before any bank feed is involved.

The bank feed is the easiest path going forward, but it almost always stops around 90 days back and skips closed accounts and older periods. That is why a manual CSV or QBO Web Connect file is the dependable route for anything historical, and why so many bookkeepers convert the statement PDF instead of waiting on a feed.

Can you import bank statements into QuickBooks Online?

Yes, but not the PDF itself. QuickBooks Online imports the transactions from a bank statement once they are in a CSV, Excel, or QBO file, not the PDF document. You either download a CSV from your bank, connect the account through the bank feed, or convert the statement PDF into a QuickBooks-ready CSV. Once the data is in the right shape, QuickBooks reads it like any other upload and drops the transactions into the For Review tab.

How to import bank transactions into QuickBooks Online from a CSV file

This is the method that works for any bank, any date range, and any closed or historical account. The steps are the same whether the CSV came from your bank or from a converted PDF.

1. In QuickBooks Online, open Transactions, then Bank transactions.
2. Select the account tile, click the drop-down next to Link account, and choose Upload from file. On a fresh account, click Upload transactions instead.
3. Drag your CSV in or browse to it, then click Continue.
4. Pick the QuickBooks account the transactions belong to.
5. Map the columns: tell QuickBooks which column is the date, which is the description, and which holds the amount (or the credit and debit columns).
6. Choose the date format that matches your file, then select the transactions to import and confirm.

QuickBooks then shows the new lines in the For Review tab, where you categorize and match them exactly like bank-feed transactions.

The exact CSV format QuickBooks Online requires

Almost every failed import comes down to the layout. QuickBooks accepts only two shapes, and it rejects anything with a category column or more than four columns.

In the 3-column format, money out is a negative number and money in is positive. In the 4-column format, deposits go in the credit column and withdrawals go in the debit column, and each row uses only one of the two. Keep these rules in mind:

• Remove dollar signs, commas, and percent signs from the amount column. Use plain numbers with two decimals, like 1042.50.
• Keep every date in one consistent format. MM/DD/YYYY is the most reliable for US files.
• Do not put commas in the description, since a stray comma breaks the CSV into extra columns.
• Delete opening balance, closing balance, account number, and summary rows. QuickBooks wants transaction lines only.
• Do not add a category column. QuickBooks Online ignores categories on import and errors out if the file has more than four columns.

How to import bank transactions into QuickBooks Online from Excel

QuickBooks Online does not read a raw .xlsx workbook through the bank upload, so save the sheet as a CSV first. In Excel, use File > Save As and choose CSV (Comma delimited). Before you save, trim the sheet to the 3 or 4 columns above, strip the currency symbols, and delete any header rows the bank added at the top. Then upload the CSV with the same steps as any other file. If your workbook has several months across tabs, save each tab as its own CSV so you stay under the row and size caps.

How to import a PDF bank statement into QuickBooks Online

QuickBooks Online will not accept a PDF in the bank upload, so the PDF has to become a clean CSV first. You can retype it by hand, but a full statement can run hundreds of lines and one mistyped amount throws off the whole reconciliation. The faster route is to run the PDF through a bank statement converter that outputs the date, description, and amount columns already structured, then upload that CSV. If your goal is a native QuickBooks file rather than a CSV, our guide on how to convert a bank statement PDF to QuickBooks covers the QBO Web Connect path, and the dedicated convert bank statements to QuickBooks tool prepares the file in the exact shape QuickBooks expects. Teams that live entirely in QuickBooks often route every statement through a single bank statement to QuickBooks converter so the format is consistent every month.

How to manually import (add) bank transactions in QuickBooks Online

If you only need to add a handful of missing transactions, you do not need a file at all. Open Transactions > Bank transactions, select the account, and use Add manually to enter the date, description, payee, category, and amount for each line. This is fine for three or four items. For a full statement, the CSV upload is far quicker and less error-prone than typing each row, and it keeps the running totals accurate.

Common CSV import errors and how to fix them

When QuickBooks rejects a file, the message is usually vague. These are the fixes that clear almost every case:

• "Some info may be missing from your file." A header name does not match, or there is an extra column. Rename the headers to Date, Description, and Amount, and delete every column QuickBooks does not use.
• File too large. The file is over 350 KB or over 1,000 rows. Split it by month and upload each piece separately.
• Dates look wrong. Mixed date formats confuse the mapper. Reformat the whole column to MM/DD/YYYY before saving.
• Amounts blank or doubled. A comma or dollar sign is being read as a column break. Strip the symbols and make sure only one amount column (3-column) or two (4-column) exist.

If your source is a CSV that a bank or app already produced and you want a native QuickBooks file out of it, a dedicated CSV to QBO converter turns that spreadsheet into a .QBO Web Connect file so QuickBooks treats it like a normal download. And if you are on the desktop edition rather than the cloud, the process differs, so follow our companion guide on how to import bank transactions into QuickBooks Desktop instead.

Once your file matches the layout above, importing bank transactions into QuickBooks Online takes under a minute per statement. The work is all in the file prep, which is exactly why converting the statement into a clean, QuickBooks-shaped CSV up front saves the most time over a full year of bookkeeping.