The two layouts QuickBooks accepts
3 columns
Date,Description,Amount 01/01/2026,Office supplies,-100.00 01/01/2026,Client payment,200.00
Money out negative, money in positive.
4 columns
Date,Description,Credit,Debit 01/01/2026,Office supplies,100.00, 01/01/2026,Client payment,,200.00
Separate columns, blank cells instead of zeros.
Try your bank's other formats first
Intuit points out that every bank formats CSV files differently. If your bank also offers QBO, QFX or OFX files, try one of those: QuickBooks reads them without any reformatting.
Common errors and their fixes
Too many columns
Cause: Bank exports often include a running balance, a transaction type or a cheque number. QuickBooks only accepts its 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout.
Fix: Delete every other column so the file matches one of the two layouts exactly.
Rows above the headers
Cause: Account names, statement periods, opening balances or blank rows sit above the column headings.
Fix: Delete everything above the header row, and any totals or blank rows at the bottom.
Mixed date formats or day names
Cause: Some dates are written differently, or include the day of the week, such as 20/11/2018 TUE.
Fix: Use one format throughout; Intuit recommends dd/mm/yyyy. Split off day names with Data, then Text to Columns (Delimited, Space). See the CSV date formatting guide.
Days and months swapped
Cause: A date like 03/04/2026 can be read as 3 April or 4 March. If the format chosen during the upload doesn't match the file, transactions land in the wrong month.
Fix: Choose the date format that matches your file when you map the columns, and check a few transactions with days above 12 afterwards.
Money in and out the wrong way round
Cause: In the 3-column layout, money out must be negative and money in positive. Some banks export the opposite, or put all amounts as positive numbers.
Fix: Make payments negative and deposits positive, or switch to the 4-column layout with separate Credit and Debit columns.
Credit and Debit headers not recognised
Cause: Headings such as Credit Amount or Debit Amount.
Fix: Name the columns exactly Credit and Debit, without the word amount.
Zeros in amount cells
Cause: A 0.00 in the Credit or Debit column of a row that only has the other one.
Fix: Remove the zeros and leave those cells blank.
Numbers in the Description column
Cause: Descriptions that are only a number, often a reference or amount that ended up in the wrong column.
Fix: Correct those rows so each description is text, with the amount in its own column.
File from a Mac won't upload
Cause: Excel on a Mac can save a CSV format QuickBooks doesn't read.
Fix: Save the file as a Windows CSV (Windows Comma Separated) and upload that.
Credit card transactions upside down
Cause: Credit card files can list transactions in reverse, so payments show as negative.
Fix: Upload to the credit card account, not a bank account, and check the signs on a few transactions.
After uploading
Uploaded transactions go to the banking review list, just like feed transactions, so nothing is posted until you categorise or match it. Before working through them, check a handful: the dates (especially days above 12), the signs on payments and deposits, and the total against the bank statement. If something's wrong, exclude those transactions, fix the file and upload again.
Checklist before you import
Getting transactions from a client?
Send them a form instead of their bank's export. The QuickBooks bank transactions template only accepts one date format and plain signed amounts, requires a description on every row, and downloads the 3-column CSV QuickBooks expects. Using Xero? There's a Xero bank statement template too.
Try the bank transactions templateRelated Guides
Relevant Templates
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Intuit Inc. QuickBooks is a trademark of Intuit Inc. Import rules as described in QuickBooks Online help, October 2026.