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
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
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
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
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.
- A QBO or QFX file is for QuickBooks Desktop and Quicken. QuickBooks Online wants the CSV, not the Web Connect file.
- Pending rows are not posted activity. Leave them out so they are not imported and then posted again later.
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.