How to Import Bank Transactions into QuickBooks Online

Figuring out how to import bank transactions into QuickBooks Online matters most when the automatic bank feed is not enough. The feed is great for ongoing activity, but it does not cover every bank, it sometimes drops a period, and it will not reach back into history from before you connected the account. When that happens you upload a file instead. This guide covers the two file routes, QBO and CSV, the full upload and mapping workflow, and how to convert a PDF statement first if you do not already have an importable file.

Feed versus file: pick the right one

QuickBooks Online has two ways to get transactions in:

The two are not mutually exclusive. Many businesses run the feed for current activity and use file imports to backfill history or patch gaps.

Step one: get an importable file from your statement

QuickBooks Online cannot read a PDF, so if that is what your bank gave you, convert it first. BankConvert detects the layout from any major bank and produces a file QuickBooks Online accepts. You can convert a PDF statement to QBO for the most reliable import, or convert it to CSV if you want to map columns yourself. Already have a bank CSV? You can also convert that CSV to QBO to skip the mapping step entirely.

Importing a QBO file

A QBO file is the smoothest upload because it already carries the structure and identifiers QuickBooks needs:

• Go to Transactions, then Bank transactions.
• Select the account, then choose the dropdown next to Link account and pick Upload from file.
• Select your QBO file and choose the QuickBooks account it belongs to.
• Start the import. There is no column mapping, because the QBO already defines its fields.
• Review everything in the For review tab before you categorize and accept.

Importing a CSV file

CSV gives you control but adds a mapping step:

• Go to Transactions, then Bank transactions, then Upload from file.
• Select your CSV.
• Choose whether your file uses a single amount column or separate debit and credit columns.
• Map each QuickBooks field (date, description, amount) to the matching column in your file.
• Confirm the date format so day-month-year is not read as month-day-year.
• Import, then review the transactions in the For review tab.

A clean CSV makes mapping painless. If your statement export has merged cells, totals rows, or split debit and credit columns, converting it through a tool that normalizes those first removes most mapping errors.

Reviewing and categorizing

Importing is only half the job. Once transactions land in the For review tab:

• Confirm or correct the category QuickBooks suggests for each transaction.
• Match transactions to existing invoices or bills where they apply.
• Set up bank rules for recurring payees so future imports categorize automatically.
• Reconcile against the statement balance once everything is added.

Avoiding duplicate transactions

If a feed already brought in part of a period, importing an overlapping file double-counts those transactions. To stay clean, import only the date range the feed missed, and check the For review list for repeats before accepting. A QBO with unique transaction IDs helps QuickBooks recognize and flag potential duplicates.

Bank-by-bank notes

Because statement layouts differ between banks, a converter that adapts to each is what keeps the file clean. Whether your data starts as a Chase statement or a Wells Fargo statement, the convert-then-upload flow is the same.

Security and limits

A statement is sensitive data, so check how a tool treats it. BankConvert encrypts files, processes them only to convert, then discards them, and never stores or sells your statements, as set out on the security page. And BankConvert converts files rather than giving accounting or tax advice, so review the imported data and categories before they post.

Bottom line

Bank feeds handle the everyday flow, but file imports are how you backfill, patch gaps, and bring in unsupported banks. Convert your statement to a clean QBO or CSV, upload it to the right account, map carefully on CSV, then review and categorize before reconciling. For a deeper look at the QBO format itself, see the guide on the QuickBooks bank statement import.