What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Import Transactions into QuickBooks Online (CSV)
QuickBooks Online

How to Import Transactions into QuickBooks Online From a Bank File

Your bank won't connect, the feed only reached back a few months, or a broken connection left a gap. QuickBooks Online takes a statement file instead: a .qbo, .ofx, .csv or .txt download from your bank, uploaded on the bank transactions screen. Those rows then wait for you to categorize or match, the same as feed transactions.

Where the upload lives

The account already has a tile: select it, then open the dropdown arrow beside Link account.

Bank transactions Link account ▾ Upload from file

The account has never been connected to a bank: the button simply reads Upload transactions.

Which file to download: a .qbo file (banks often call it QuickBooks Web Connect) if it's offered, since there's nothing to map. CSV works too, but you'll match the columns yourself.

Uploading a statement file, from download to review

  1. 1

    Download only the dates you're missing

    Look up the newest transaction QuickBooks already holds for this account, and start the bank download the day after it. An overlap is the most common reason the same charge appears twice.

    Watch for: the size limits. Intuit caps an upload at 1,000 lines and 350 KB, so split a long history into a few shorter date ranges.

  2. 2

    Open the upload screen

    All apps Accounting Bank transactions

    Older menus call this Banking or Transactions. Pick the account's tile, choose Upload from file, then drag the file in or browse to it and continue.

  3. 3

    Point it at the right QuickBooks account

    Use the Select account dropdown, or + Add new if this account isn't in your books yet. A card statement belongs in the credit card account, never the checking account, because the signs on the amounts run the other way.

  4. 4

    Match the columns, for a CSV

    Tell QuickBooks which column holds the date, which holds the description, and whether money is in one amount column or split into credit and debit. Choose the date format your bank used, so March 4 doesn't turn into April 3.

  5. 5

    Tick the rows to bring in, then confirm

    Untick anything you know is already in QuickBooks, continue, answer Yes, and finish with Done. The rows appear on the account's tile, waiting for review.

    Watch for: the review step itself. Uploaded rows aren't in your books until each one is added, categorized or matched to a payment you've already entered.

When QuickBooks rejects the file or doubles it

The CSV won't map, or errors out

How you'll know: QuickBooks complains about the format, or the amounts end up in the description.

Fix: Trim the file to three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Take the word "amount" out of the Credit and Debit headers, blank out cells that only hold a zero, keep one date format throughout, and give the weekday its own column if your bank glued it onto the date.

The upload stalls on a long statement

How you'll know: A year of a busy account fails partway, or never finishes.

Fix: It's over the 1,000-line or 350 KB limit. Download it again in quarters, or months, and upload each piece.

Everything shows up twice

How you'll know: After a second upload, or after the bank feed reconnected, the review list holds pairs of identical rows.

Fix: Exclude the copies before you add anything. If doubles were already added, delete one of each pair, then reconcile to prove the balance is right again.

Card purchases came in as money received

How you'll know: Charges show as deposits, or the card balance grows the wrong way.

Fix: The file went to a bank account, or the bank exported the signs reversed. Undo those rows, then upload again into the credit card account. Our credit card payments guide covers what each line should be.

A live bank feed or a file upload: which this account needs

Link account

Bank feed

  • New transactions download on their own once it's connected.
  • When you connect, you pick a start date. How far back it reaches depends on the bank: Intuit says anywhere from 90 days to 24 months.
  • The right choice for any bank that supports it.
Upload from file

Statement file

  • Covers any date range your bank lets you download, so it fills history older than the feed's start date.
  • Works for banks, card issuers and processors QuickBooks can't connect to at all.
  • Someone repeats it every period for an account that never connects.

Connect what you can, and use files to fill what came before the feed's start date. Upload over the same dates as the feed and you'll be cleaning up duplicates.

Questions people ask

How do I import transactions into QuickBooks Desktop instead?

Desktop generally wants the bank's own .qbo Web Connect file rather than a CSV. Download it from your bank, then use File, Utilities, Import, Web Connect Files, and pick the Desktop account it belongs to. The transactions show up in Bank Feeds for you to add or match.

How do I import a bank statement into QuickBooks if all I have is a PDF?

QuickBooks won't read a PDF statement. Log in to the bank and download the same period as .qbo, .ofx or CSV, then upload that. If the bank only gives PDFs for older months, ask it for a transaction export, or the rows have to be typed in.

How do I import credit card transactions into QuickBooks Online from a file?

Exactly like a bank account, with one difference: pick the credit card account in Select account. Card exports often show purchases as positive numbers, and uploading them into a checking account turns spending into deposits.

Can I import transactions into QuickBooks from an Excel file, or does it need CSV?

The bank upload takes .csv, .txt, .qbo and .ofx, not .xlsx. Open the workbook in Excel, use Save As, and choose CSV. QuickBooks' separate import tool for spreadsheets is meant for lists like customers and products; our Excel import guide covers that one.

How far back will a QuickBooks bank connection pull transactions?

You choose a start date when you connect, but the bank sets the limit. Intuit's help says it varies from 90 days to 24 months. For anything older, download statement files and upload them, starting where the feed's history begins.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.