QuickBooks Online bank CSV format: 3-column and 4-column
What a CSV file needs before QuickBooks Online will import it as bank transactions, taken from Intuit's own help pages. Checked November 10, 2026.
The two layouts QuickBooks Online accepts
QuickBooks Online reads a CSV of bank transactions in one of two layouts.1
3 columns: one Amount column. Money out is negative, money in is positive.2
| Date | Description | Amount |
|---|---|---|
| 1/1/2018 | Example of a payment | -100.00 |
4 columns: Date, Description, Credit, Debit. Amounts are written without a minus sign, in the column that fits (Intuit's example puts the 100.00 payment in one of the two columns rather than as -100.00).7
- Name the columns as QuickBooks does: Date, Description, Amount (or Credit and Debit). Intuit's fix for header problems is to rename the file's headers to match.3
- In the 4-column layout, take the word "amount" out of the Credit and Debit headers ("Credit amount" becomes "Credit").1
- Leave a cell empty rather than writing 0 in it.1
- During the upload you match the columns in the file to the QuickBooks fields.1
Dates
- Use one date format for every row. Intuit's page recommends dd/mm/yyyy.1
- You pick the date format when matching columns. A date error usually means the file's dates do not match the format picked there. Intuit's fix: in Excel, format the date column as Short Date, and pick the matching format during the upload.3
- If the bank puts the weekday in the date column ("Mon 03/11/2026"), split it into its own column first (Excel: Data, Text to Columns, Delimited, Space).2
- Users on Intuit's community forum report that year-first dates (2026-11-03) were not accepted; day/month/year or month/day/year avoids the question.6
Credit card files
A credit card CSV may show amounts the other way round: a payment to the card can appear as negative, because it lowers what you owe. Upload it to the credit card account in QuickBooks, not to a bank account.2
Size limits
- The file must be in English and no larger than 350 KB.1
- Up to 1,000 lines per upload. For more, upload shorter date ranges one after another.1
- Intuit's help says you can upload more than 90 days of bank transactions this way; it does not document a limit on how far back.2
Cleaning the file in Excel
- Format amount columns as General, not Currency, and remove special characters from descriptions.3
- On a Mac, save as "Windows Comma Separated" CSV.2
- A 4-column file that holds only money out can fail to upload. Intuit's workaround: add one line with a positive amount, then untick it on the review screen before confirming.3
Where the upload is
In QuickBooks Online: Bank transactions, choose the account's tile, then the Link account menu and Upload from file. For an account that is not connected to a bank feed, choose Upload transactions. Besides CSV, the same page lists .qbo and .ofx files (and, in another place, .qfx).1
Upload errors Intuit documents
| Message | Cause and fix (Intuit) |
|---|---|
| "The uploaded file contains invalid transaction amount information." | An amount with 12 or more digits. Take that row out, upload, and enter it by hand. |
| "The uploaded file is of a different type than these accounts." | The file is for another kind of account (for example savings into checking). Choose the matching account. |
| "We were unable to upload the file. Please start over and re-select the file you want to upload." | The upload timed out. Try again and check the account type. Uploading to a subaccount is a current limitation. |
| "QuickBooks Online couldn't upload your file. Please click Save again, or try again later." | A temporary problem on Intuit's side. Wait and retry. |
Source for this table: 4.
QuickBooks Desktop is different
QuickBooks Desktop's bank import (Web Connect) reads only .qbo files, downloaded directly from the bank, and needs you to be signed in to your Intuit account inside QuickBooks Desktop.5
Sources
- Intuit: Manually upload transactions into QuickBooks Online (US, updated August 24, 2026).
- Intuit: Format CSV files in Excel to get bank transactions into QuickBooks.
- Intuit: Common errors for importing bank transactions using CSV (updated August 3, 2026).
- Intuit: Fix bank upload errors in QuickBooks Online (Canada).
- Intuit: Fix Web Connect import errors in QuickBooks Desktop (updated August 4, 2026).
- Intuit community: a user report that yyyy-mm-dd dates were not accepted.
- Intuit: Import bank transactions using Excel CSV files (served the Canadian article when checked).
Intuit's pages change; check them if something here no longer matches what you see. Northstake Data is not affiliated with or endorsed by Intuit. QuickBooks is a trademark of Intuit Inc., used here only to name the software this guide is about.