How to Import Bank Transactions into QuickBooks Online

QuickBooks Online gives you three ways to bring in bank and credit card activity. They end up in the same place, the For review list of the bank account, but they differ in how much history you get, how much work the import takes, and how likely you are to end up with duplicates.

The three ways transactions get into QuickBooks Online

Method	What you need	Best for
Bank feed	A direct connection to the bank	Ongoing, day-to-day activity
Web Connect file (.qbo)	A QBO file from the bank or a converter	History the feed doesn’t reach, closed accounts, feed outages
CSV upload	A spreadsheet export	Banks that only export CSV

A bank feed is the most convenient once it’s set up, but when you first connect, the bank usually sends only a limited window of history, often around 90 days. Anything older has to come from files.

A Web Connect file is a bank file in the format QuickBooks reads natively. There is no column mapping, the account type is built in, and every transaction carries an ID that QuickBooks uses to skip transactions it has already imported. If your bank doesn’t offer QBO downloads for the period you need, you can convert a PDF statement to QBO or a CSV export to QBO.

A CSV upload works with almost any bank, but you map the columns on every import, and CSV rows carry no transaction ID, so importing an overlapping period twice creates duplicates.

Before you import

A few minutes of preparation saves hours of cleanup.

• Use the right account type. Bank statements go into a Bank account (checking, savings); card statements into a Credit card account. Importing a card statement into a bank account reverses the meaning of every amount.
• Decide on a start date. Pick the first day you want in the books, usually the start of a month or the fiscal year, and make sure the account’s opening balance in QuickBooks matches the statement balance on that date.
• Check for overlap. If a bank feed is connected, or someone imported files before, look at the account register for the dates you’re about to import. If two files cover overlapping dates, run them through the duplicate finder first.

Importing a QBO (Web Connect) file

1. Go to Transactions > Bank transactions.
2. Choose Link account (or the Update menu if accounts are already linked) and select Upload from file.
3. Drop the .qbo file and continue.
4. Pick the QuickBooks account the transactions belong to, or create one.
5. Continue. The transactions appear in the For review tab.

The file contains an account number. QuickBooks remembers which QuickBooks account you matched it with, so later files with the same account number go to the same place. When you convert statements yourself, use the same account number every time for a given account.

Because each transaction has a stable ID, re-importing the same file, or a file that overlaps a previous one, doesn’t create copies of transactions QuickBooks already accepted.

Uploading a CSV

QuickBooks Online accepts two CSV layouts:

• 3 columns: Date, Description, Amount (negative for money out).
• 4 columns: Date, Description, Credit, Debit (both positive).

The steps start the same way: Transactions > Bank transactions > Link account > Upload from file, then choose the CSV and the account. QuickBooks then asks you to map the columns: which column is the date and in which format (pick the format your file actually uses, such as MM/dd/yyyy), which is the description, and whether amounts are in one column or two.

A few rules avoid most failures:

• One header row, no blank lines or totals at the bottom.
• No currency symbols or thousands separators in amounts (1234.56, not $1,234.56).
• The file must be under 350 KB. Larger files are rejected; split them with the CSV splitter or see how to fix the “file too large” error.

If you’d rather skip the mapping step, convert the CSV to QBO and upload that instead.

Reviewing and categorizing

Nothing you import changes your books until you act on it in For review. For each transaction you can:

• Add it, with a category (expense or income account) and optionally a payee;
• Match it to a transaction already in QuickBooks, such as an invoice payment or a bill payment, so it isn’t recorded twice;
• Exclude it, for personal charges or genuine duplicates.

For payees that come back every month, create a rule (from the transaction’s options or the Rules page) so QuickBooks categorizes them automatically.

When the period is done, reconcile the account against the statement. The reconciliation is the final check that every transaction was imported exactly once.

Common errors and fixes

• “The file is too large”: the 350 KB limit. Split the file by date range.
• Dates are wrong or rejected: the date format chosen in the mapping step doesn’t match the file. Day-first files (31/01/2026) need the matching format.
• Every amount has the wrong sign: common with card CSVs that list purchases as positive numbers. Flip the signs before uploading, or convert to QBO with the account type set to credit card.
• Nothing was imported: the file may contain only transactions QuickBooks already has (same transaction IDs), or the account picked is a different one than expected. Check the account’s register for the dates in the file.
• The file won’t open at all: open it in the QBO file viewer, which explains what’s missing or malformed.