3 columns
Date, Description, Amount. Deposits use positive amounts and payments use negative amounts.
Format guide
QuickBooks CSV formats, without the guesswork.
QuickBooks Online accepts a 3-column or 4-column bank CSV. The important part is the meaning of each column, not the bank export name.
4 columns
Date, Description, Credit, Debit. Keep the unused side blank for each row.
Dates
Use one unambiguous date format throughout the file. When a value such as 01/02/2026 could mean two dates, confirm it before export.
Common errors
- Remove zeros from unused Credit or Debit cells.
- Remove extra words from Credit and Debit headers.
- Check the sign direction for credit card accounts.
- Save Mac exports in a compatible CSV format.
Source: Intuit official CSV guidance. Need the formatter? Open the local tool.