How to import bank transactions into QuickBooks Online (CSV, step by step)
If QuickBooks Online can't connect to your bank, or you want transactions from before you connected, you can upload a file instead. The upload itself takes a minute. Getting the file into the right shape is where most people get stuck, so this guide covers both.
Everything below comes from QuickBooks' own help pages, linked at the end. The upload article we read was the Irish edition; menu names can differ slightly in the US, UK and other editions, so treat the steps as a map, not a script.
Before you start
- Download the CSV from your bank's website. QuickBooks says to pick a date range that starts at least one day before your oldest QuickBooks transaction for that account, so nothing is missed.
- Check your Chart of accounts first. QuickBooks warns that this avoids creating duplicate transactions.
- Optional: set up bank rules before uploading if you want QuickBooks to categorise the transactions as they come in.
Step 1: Make the file match what QuickBooks accepts
QuickBooks accepts these file types: .csv, .txt, .qbo and .ofx (it suggests QBO or CSV). For a CSV the limits are:
- Maximum file size: 350 KB.
- Maximum 1,000 lines per upload, one transaction per line.
- English-language files.
The columns must be one of two layouts, with headers in the first row:
| Layout | Columns | Notes |
|---|---|---|
| 3 columns | Date, Description, Amount | Payments are negative, deposits are positive |
| 4 columns | Date, Description, Credit, Debit | Fill either Credit or Debit on each row and leave the other cell empty |
Then clean up, using QuickBooks' own checklist:
- One date format throughout the file. QuickBooks recommends dd/mm/yyyy in its Irish edition; if your QuickBooks is set up for US dates, keep every date in the same order your account expects and check the preview.
- Remove zeroes. "Leave those cells blank" in the Amount, Credit or Debit columns.
- Description cells that contain only numbers should be fixed.
- Credit and Debit headers should read just "Credit" and "Debit". Remove the word "amount".
- Day of the week: if the Date cell includes a weekday, split it out into another column and delete it.
- Mac users: save as a Windows CSV file.
- Credit card files can list transactions in reverse order, so deposits may show as negative. When you upload one, choose the credit card account, not a bank account.
- Too big? Shorten the date range and import in smaller batches.
Doing this by hand in Excel works. If you would rather not, StatementSnap is a free browser tool we make that reshapes a bank CSV into the 3-column layout (free for the first 25 rows; your file is not uploaded anywhere). There is also a free QuickBooks CSV template you can paste into. Either way, review the result before importing.
Step 2: Upload the file
According to QuickBooks' article:
- Go to Accounting, then Bank transactions.
- If there is a tile for the account, select it.
- Open the Link account dropdown and choose Upload from file (or Upload transactions if the account isn't connected to online banking).
- Drag and drop your file, or browse for it, then Continue.
- In Select account, pick the account the transactions belong to, then Continue. If it doesn't exist yet, add it from the dropdown.
- Map the columns: match each column in your file to the right QuickBooks field, then Continue.
- Select the transactions you want to import, then Continue.
- Confirm with Yes, then Done.
Step 3: After the import
QuickBooks may fill in details from recognised descriptions or your bank rules. The transactions land in the Bank transactions list, where you match or categorise them. Then reconcile the account against your statement.
If the upload fails
The usual causes are mixed date formats, extra columns, zeros in Credit/Debit, a row with no date, or a file over the limits above. We collected the causes and fixes, each with its source, in Bank CSV import errors in QuickBooks Online. Start by trying a five-row copy of the file: if it works, the problem is in the other rows.
If your bank is one of the common US ones, there is a page with its export layout and notes, for example Chase, Bank of America and Wells Fargo.
Sources
- QuickBooks: Manually upload transactions into QuickBooks Online (read 2026-10-08)
- QuickBooks: Format CSV files in Excel to get bank transactions into QuickBooks (read 2026-10-08)
Disclosure: we make StatementSnap, which is linked above, and used AI assistance to write this guide. We are not affiliated with Intuit or QuickBooks. QuickBooks can change its rules and menus; if its help pages say something different today, follow them.