How to Import Bank Statements into QuickBooks Online Without a Bank Feed

Last updated July 2026.

You do not need a working bank feed to get transactions into QuickBooks Online. Under Transactions, then Bank transactions, QuickBooks lets you upload a CSV file with three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit), up to 1,000 lines per file. That manual upload is the reliable path whenever the bank connection fails, only reaches back about 90 days, or never supported your bank at all. The one catch: QuickBooks cannot read a PDF statement, so you first convert the statement to a clean CSV, then upload it exactly like a downloaded bank file.

When you need the manual route instead of the feed

Bank feeds are convenient until they are not. The manual upload exists for the gaps the feed leaves behind, and there are more of them than most people expect.

How do I import bank transactions into QuickBooks Online without connecting my bank?

Go to Transactions, then Bank transactions, select the account (or add it as a new account first), click the drop-down next to Link account, and choose Upload from file. Drag in your CSV, map the columns to Date, Description, and Amount, confirm the date format, and QuickBooks drops the rows into the For review tab exactly as a feed would. From there you categorize and match each line the same way you would a synced transaction. Nothing about the review, matching, or reconciliation step changes; only how the data arrived is different.

The exact CSV format QuickBooks Online accepts

QuickBooks is strict about the shape of the file, and most failed imports come down to formatting. Build the file to these rules and it goes in on the first try.

The trap is that a PDF statement does not export to this shape on its own. Copy and paste out of a PDF scrambles the columns, merges the date into the description, and turns amounts into text. The dependable fix is to convert the bank statement to a clean CSV first, so the date, description, and amount already sit in their own columns before you ever open QuickBooks.

Step by step: from PDF statement to reviewed transactions

1. Download the PDF statements for every month you need, including any closed or unsupported account.
2. Convert each statement to CSV with the columns already separated. The PDF bank statement to Excel and CSV converter keeps the running balance and reads scanned statements too.
3. Trim the file to Date, Description, and Amount (or Date, Description, Credit, Debit), remove currency symbols and commas, and keep the dates uniform.
4. In QuickBooks Online, open Transactions, then Bank transactions, and choose Upload from file.
5. Select the account, drag in the CSV, and map the columns.
6. Review the transactions in the For review tab, categorize them, and match any that already exist to avoid duplicates.
7. Reconcile the account against the statement's closing balance to confirm nothing is missing or doubled.

Avoiding duplicate transactions

Duplicates are the most common problem when you mix a feed and a manual upload. If the feed already pulled the last 90 days, only upload the older months, or the same charges land twice. When overlap is unavoidable, QuickBooks flags likely matches in the For review tab, and you accept the match rather than adding a new transaction. Reconciling right after import catches anything the review missed, because a clean reconciliation only balances when every real transaction is present exactly once. If your books run on QuickBooks and you would rather skip the spreadsheet entirely, you can also convert each statement straight into a ready-to-import QuickBooks bank file that carries the date, description, and amount without any manual mapping.

Can QuickBooks Online import a PDF bank statement directly?

No. QuickBooks Online accepts CSV, TXT, QBO, QFX, and OFX files for bank uploads, but not PDF. A PDF is a picture of a statement, not structured data, so QuickBooks has nothing to map. You convert the PDF to one of the accepted formats first. CSV is the most flexible because you can inspect and clean it in a spreadsheet, while a QBO file imports with no mapping at all.

How many transactions can I upload at once?

QuickBooks Online caps each upload at 1,000 lines and about 350 KB. For a busy account or a full year of catch-up, that means splitting the data into month-by-month or quarter-by-quarter files. Converting the statements first makes this trivial, because each statement is already its own file and rarely exceeds the limit. Upload them oldest to newest so the running balance stays sensible when you reconcile.

What if my bank already exports a CSV?

A bank-provided CSV is a head start, but it rarely matches QuickBooks out of the box. Banks add columns QuickBooks does not want, such as a running balance, a check number, or a separate status field, and many put the day of the week inside the date cell or wrap amounts in parentheses for withdrawals. QuickBooks reads parentheses and currency symbols as text and rejects the row. Open the bank CSV in a spreadsheet, delete the extra columns down to Date, Description, and Amount, convert any parentheses to a minus sign, and strip the symbols. If the bank only exports the last few statements, or the download stops short of the history you need, converting the PDF statements gives you the full period in one consistent layout instead of stitching partial exports together.

The bottom line

A broken or missing bank feed is not a dead end. Convert each PDF statement to a clean three or four column CSV, upload it under Bank transactions, review, match, and reconcile. It is the same workflow professional bookkeepers use for catch-up work and unsupported banks every day, and it puts every transaction into QuickBooks whether or not the feed ever connects.