How to Import Bank Transactions Into QuickBooks Online

When your bank feed breaks, your bank is not supported, or you need transactions older than the feed reaches, you have to import them into QuickBooks Online yourself. This guide covers both methods, the exact CSV formats QuickBooks accepts, how to get the file out of your bank, what to do when you only have a PDF statement, and how to fix the errors that cause most imports to fail.

Why you would import transactions manually

Most of the time QuickBooks Online pulls transactions in automatically through a connected bank feed. But there are four situations where that does not work, and they are common enough that almost every business hits one eventually.

Your bank feed has broken or disconnected and stopped updating. Your bank is small enough that QuickBooks does not support a direct connection. You need history older than the 90 days most feeds reach back. Or you are catching up months of bookkeeping at once and the feed simply does not go back far enough.

In all four cases the answer is the same: upload the transactions yourself as a CSV file. QuickBooks Online supports this natively, and once you have done it once it takes about five minutes.

Method 1: connect your bank feed (if you can)

Before uploading anything manually, check whether a live connection is available, because an automatic feed saves you doing this every month.

In QuickBooks Online go to Transactions → Bank transactions and select Link account. Search for your bank, sign in with your online banking credentials, choose which accounts to connect, and pick the date you want history to start from. QuickBooks will pull in recent transactions and keep updating daily.

If your bank is not listed, or the connection keeps failing, move on to the CSV upload below. That is the reliable fallback and it always works.

Method 2: how to upload bank statements to QuickBooks Online

This is the manual route, and it is the one worth learning because it never depends on a third-party connection staying alive.

Step 1. Download your transactions from online banking as a CSV file. Most banks offer this under statements, activity, or download.

Step 2. Open the file and check it matches one of the two layouts QuickBooks accepts (details in the next section). Remove any header rows, summary lines, or blank rows above the data.

Step 3. In QuickBooks Online, go to Transactions → Bank transactions. Select the account you are importing into, then choose Upload from file (under the dropdown next to Link account).

Step 4. Drag in your CSV and select the QuickBooks account it belongs to.

Step 5. Map your columns. QuickBooks will ask which column is the date, which is the description, and which holds the amount. Set your date format here too, this is where most imports go wrong.

Step 6. Review the preview, confirm, and QuickBooks imports the rows into your For Review tab. Nothing hits your books until you categorise and accept each one.

The QuickBooks CSV format: 3-column and 4-column

QuickBooks Online accepts two CSV layouts, and knowing which one you need removes most import errors.

The 3-column format is Date, Description, Amount. Money coming in is a positive number and money going out is negative. This is the simpler option and works well when your bank exports a single amount column.

The 4-column format is Date, Description, Debit, Credit. Debits and credits sit in separate columns and every value is positive. Use this when your bank exports separate columns for money in and money out.

A few rules that apply to both: the first row should be your column headers, dates should be consistent throughout the file (QuickBooks lets you specify the format during mapping), amounts should not contain currency symbols, and the file should contain nothing except headers and transaction rows. Strip out running balances, page numbers and summary totals before uploading.

Getting the file out of your bank

Every bank puts this in a slightly different place, but the pattern is consistent: find your account activity, set a date range, and look for an export or download option.

Chase: open the account, choose the download icon near your transaction list, pick a date range and select the spreadsheet or CSV option. Chase also offers a QuickBooks-specific download, though the plain CSV is easier to inspect before importing.

Bank of America: go to the account, select Download, choose your date range and pick the Microsoft Excel or CSV format.

Wells Fargo and most others: look under account activity for Download account activity, then choose CSV or spreadsheet.

If your bank only gives you a PDF statement, you are not stuck, see the next section.

What if you only have a PDF statement?

Plenty of banks, and almost all credit card providers, hand you a PDF and nothing else. Retyping months of transactions is the usual response, and it is both slow and error-prone. The Journal of Accountancy has put manual data entry error rates at 2 to 4 percent, which on a 500-line statement means 10 to 20 mistakes.

Instead, run the PDF through our free bank statement converter. It reads the statement, pulls out the date, description, debit, credit and balance for each transaction, and exports a QuickBooks-ready CSV in either the 3-column or 4-column layout, ready to upload using the steps above.

It runs entirely inside your browser, which means your statement is never uploaded to us or anyone else. For a document containing your account number and every transaction you have made, that matters.

Common import errors and how to fix them

The date format is not recognised. The most common failure. During column mapping, tell QuickBooks explicitly whether your dates are DD/MM/YYYY or MM/DD/YYYY rather than letting it guess.

Everything imported with the wrong sign. Your file used the 3-column format but expenses were not negative. Add the minus signs, or switch to the 4-column layout with separate debit and credit columns.

QuickBooks rejects the file. Usually extra content. Delete any rows above the headers, any summary or total rows, blank rows, and any running-balance column.

Duplicate transactions. This happens when a date range overlaps something already imported or already in the bank feed. Select the duplicates in For Review and exclude them, they will not touch your books.

You imported the wrong file entirely. Because imports land in For Review, you can select all and exclude them, then start again cleanly.

QuickBooks Desktop

QuickBooks Desktop works differently. It expects a Web Connect file (.qbo), an OFX file (.qfx), or an IIF file, rather than a plain CSV.

Many banks offer a direct QuickBooks download that produces the right file, look for a QuickBooks or Web Connect option in your bank download screen. Then in Desktop use File → Utilities → Import → Web Connect Files.

Be cautious about third-party tools advertising CSV to QBO conversion. The .QBO format is tied to Intuit-registered financial institution identifiers, and files generated outside that system are frequently rejected on import. If your bank offers a native QuickBooks download, use that.

When it is worth handing this over

Importing transactions is the easy part. Categorising them correctly, matching them to invoices and bills, and reconciling the account against the statement is where bookkeeping actually lives, and where mistakes become expensive at tax time.

If you are spending a weekend each month on this, or catching up on a year of untouched books, it is usually cheaper to hand it to someone who does it every day. Our Ex-PwC Chartered Accountants handle monthly bookkeeping for US small businesses, with clean, reconciled books delivered within 48 hours of month end.

Frequently Asked Questions