How to Import a CSV File into QuickBooks Online (Bank Transactions)
When a bank feed disconnects or does not reach far enough back, the quickest fix in QuickBooks Online is to upload the missing transactions from a file. QuickBooks Online accepts CSV, QBO, QFX, OFX and TXT files for this. CSV is the most common — and the one that fails most often, because QuickBooks is strict about the layout.
The CSV format QuickBooks Online expects
QuickBooks Online reads bank CSV files in one of two layouts:
3 columns — one amount column
| Date | Description | Amount |
|---|---|---|
| 10/01/2026 | Office Depot | -54.20 |
| 10/02/2026 | Client payment | 1200.00 |
4 columns — separate debit and credit
| Date | Description | Credit | Debit |
|---|---|---|---|
| 10/01/2026 | Office Depot | 54.20 | |
| 10/02/2026 | Client payment | 1200.00 |
Rules that save time:
- One header row, then one transaction per row. Remove opening balances, totals and blank lines.
- One date format for the whole file, for example
MM/DD/YYYY. - Plain numbers in amount columns — no currency symbols, no text like “CR”.
- In the 3-column layout, money out is negative.
If your export does not look like this, you can fix it in a spreadsheet — or drop it into the free converter, choose CSV as the output, and download a clean Date, Description, Amount file. The converter handles debit/credit columns, amounts in brackets, trailing minus signs and European decimals for you.
Step-by-step: upload the CSV
- In QuickBooks Online go to Banking → Bank transactions.
- Click the arrow next to Link account and choose Upload from file (some accounts show an Upload transactions button instead).
- Drag the CSV file in or browse for it, then click Continue.
- Select the QuickBooks account the transactions belong to (for example Checking), or add a new one.
- Map the columns: tell QuickBooks which column is the date, the description and the amount, and choose whether amounts are in one column or two. Pick the date format that matches your file.
- Select the transactions to import and click Next, then confirm.
- Open the For review tab to categorise or match the new transactions.
Common errors and how to fix them
“Some info may be missing from your file.” A row is missing a date or amount, or there are summary lines. Delete everything that is not a transaction.
Dates are wrong or rejected. The date format selected during mapping does not match the file, or the file mixes formats. Excel often converts some dates and leaves others as text — export the CSV again or let the converter normalise it.
Every amount is positive. Your bank exports debits as positive numbers in a separate column. Use the 4-column option during mapping, or convert the file first so money out becomes negative.
Duplicates after uploading twice. CSV files carry no transaction IDs, so QuickBooks cannot always tell that a transaction was already imported. Exclude duplicates in the For review tab — or upload a QBO file instead, which includes a unique ID for every transaction.
CSV or QBO — which should you upload?
| CSV | QBO | |
|---|---|---|
| Column mapping needed | Yes, every time | No |
| Transaction IDs (duplicate protection) | No | Yes |
| Works in QuickBooks Desktop | No (bank transactions) | Yes |
| Easy to edit by hand | Yes | No |
For a one-off upload, a clean CSV is fine. For regular imports or QuickBooks Desktop, convert the CSV to QBO and skip the mapping step.