Skip to the converter
StatementZap

Guides

How to import a CSV bank statement into QuickBooks Online

Prepare a 3-column or 4-column CSV and map Date, Description, and Amount in QuickBooks Online.

  1. 1

    Export the statement

    Download the bank or card activity as CSV. If the file is Excel, convert it first so QuickBooks receives a CSV.

  2. 2

    Make the columns QuickBooks expects

    QuickBooks Online accepts a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit). Amount is signed: money in is positive and money out is negative. Leave the header row, and remove a title or a totals row above it.

  3. 3

    Settle the dates

    Use one order for the whole file. If a date such as 03/04/2026 could be March 4 or April 3, choose MM/DD/YYYY or DD/MM/YYYY before you download. Year-first does not rewrite a slash date.

  4. 4

    Upload it

    In QuickBooks Online open the bank account, choose Upload from file, and select the CSV. Map the date, the description, and either the signed amount or the credit and debit pair. Add the rows QuickBooks shows you.

Questions

Which amount column should I use?

Use one signed Amount column when the export already shows deposits as positive and withdrawals as negative. Use Credit and Debit when the export splits them and leaves the other side blank.

Why did every transaction land on the wrong side?

The file treated charges as positive. Flip the signs so a purchase is negative, then download the CSV again.