Back to blog
quickbooksquickbooks csvbank statement importbookkeeping

QuickBooks 3-Column vs 4-Column CSV: Which to Use

QuickBooks Online accepts bank transactions as a 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) CSV. Here's which one to pick, the rules both must follow, and the errors that stop an upload.

Published 2026-11-21 7 min read AIBankStatement
Summarize this article:ChatGPTClaudePerplexityGrok

QuickBooks Online lets you upload bank and credit card transactions from a file when the bank feed can't help: the feed started mid-year, the account is closed, or the client sent a folder of PDFs.

If you upload a CSV, QuickBooks accepts exactly two layouts: 3-column or 4-column. Pick the wrong one, or get one detail wrong, and the upload fails or the money ends up going the wrong way.

The short answer

  • Use 3-column when money in and money out are in one Amount column, with withdrawals as negative numbers.
  • Use 4-column when the statement has separate money-in and money-out columns and you want to keep them that way.

Both import the same transactions. The choice is about which layout is less likely to go wrong with the data you have.

The two layouts

Intuit's help article lists both.

3-column: Date, Description, Amount

DateDescriptionAmount
03/11/2026Client payment, Smith Ltd1250.00
04/11/2026Office rent-950.00
06/11/2026Bank fee-12.50

One amount column. Deposits are positive, withdrawals are negative.

4-column: Date, Description, Credit, Debit

DateDescriptionCreditDebit
03/11/2026Client payment, Smith Ltd1250.00
04/11/2026Office rent950.00
06/11/2026Bank fee12.50

Two money columns, both holding positive numbers. Each row fills one and leaves the other blank.

Which one should you use?

SituationBetter choiceWhy
Bank CSV already has one signed amount column3-columnNo reshaping needed
PDF statement with separate withdrawals and deposits columns4-columnMirrors the statement, easy to check line by line
You review the file in Excel before import4-columnEasier to spot a payment in the wrong column than a missing minus sign
Credit card accountEither, but check signsCard statements reverse the usual meaning of payments and purchases
You want the smallest file3-columnOne fewer column, which helps with the 350 KB limit

Our usual advice for bookkeepers converting PDF statements: use 4-column if you're going to review the file first, and 3-column if you trust the signs and want the simplest upload.

Watch the Credit and Debit columns

This is the part that catches people. "Credit" and "Debit" mean opposite things depending on whose point of view you take. On a bank statement, a credit is money into the account. In accounting, a debit to a bank account is also money in.

Even Intuit's own 4-column example puts the payment in the Credit column and the deposit in the Debit column. So don't rely on the header names. When you upload, QuickBooks asks you to match the file's columns to its fields. Then:

  1. look at the preview before you import
  2. find one deposit you know, such as a client payment, and one withdrawal, such as rent
  3. confirm each shows up as money received or money spent correctly

If they're reversed, go back and swap the column mapping. That takes seconds; fixing a year of reversed transactions after import doesn't.

In AI Bank Statement's QuickBooks 4-column output, Credit is money in and Debit is money out, from the account holder's point of view, the same way your bank statement reads.

Rules both layouts must follow

From Intuit's QuickBooks Online help on uploading a transaction list:

  • File size: 350 KB or less.
  • Lines: up to 1,000 transactions per upload. For more, split the date range.
  • Language: the file must be in English.
  • Columns: exactly 3 or 4, as above. Delete any extra columns, such as Balance or Reference.
  • Zeros: leave cells that only contain 0 blank in Amount, Credit or Debit.
  • Headers: Credit and Debit should read just "Credit" and "Debit", not "Credit amount".
  • Dates: one format throughout. Intuit recommends dd/mm/yyyy.
  • Day names: if the bank adds a weekday to the date (for example, 20/11/2022 TUE), remove it.
  • Descriptions: Intuit says to remove numbers from cells in the Description column.
  • Mac users: save as a Windows CSV.
  • Large amounts: a transaction with 12 or more digits can't be uploaded. Enter it manually instead.

Common upload errors and what causes them

ProblemLikely causeFix
File rejected as too largeOver 350 KB or 1,000 linesSplit by month or quarter
Dates in the wrong monthDay and month swapped (03/04 read as 4 March)Use one date format and match it in the mapping step
Deposits showing as expensesCredit/Debit mapping reversedSwap the columns in the mapping step
Upload error on amountsZeros instead of blanks, currency symbols or text in amount cellsLeave zero cells blank and keep amounts numeric
Duplicate transactionsFile overlaps dates the bank feed already brought inStart the file the day after the last feed transaction, or before the feed began
Card payments shown as spendingCard file uploaded to a bank accountUpload card statements to the credit card account

Credit card statements

Intuit notes that credit card CSVs can look reversed: a payment to the card may show as a negative amount because it reduces the balance owed.

The fix is to choose the credit card account, not a bank account, when uploading. QuickBooks then treats the signs correctly. The credit card statement converter produces the same 3- and 4-column layouts for card statements.

QuickBooks can read PDFs now. Why convert?

Intuit's help says QuickBooks Online can also accept an account statement as a PDF or image, as long as it's in English. That's worth trying for a single clean statement.

Converting to CSV first is still useful when:

  • you want to review every line in Excel before anything touches the books
  • you're handling a year of statements across several accounts
  • statements are scanned or messy
  • you need the same data for Xero, Excel or a working paper as well

From PDF statement to QuickBooks CSV

  1. Collect the official PDF statements for the period.
  2. Upload them to AI Bank Statement. Use OCR mode for scans.
  3. Choose QuickBooks CSV (3-column) or QuickBooks CSV (4-column).
  4. Download the file. Dates come out as dd/mm/yyyy and zero values are left blank, matching Intuit's guidance.
  5. Open it in Excel and spot-check a few rows against the PDF.
  6. In QuickBooks, go to Bank transactions, select Link account ▼ › Upload from file, choose the account, map the columns, and check the preview.

If your client has a year of statements with more than 1,000 transactions, convert and upload one quarter at a time.

Country notes

  • Canada: QuickBooks Online Canada uses the same 3- and 4-column rules. Canadian bank exports vary a lot; see the Canada guide and the bank guides for RBC, TD, National Bank, Tangerine and EQ Bank.
  • United States: US banks often export MM/DD/YYYY. Keep one format throughout and confirm it in the preview. See the US guide.
  • UK and Australia: day-first dates match Intuit's dd/mm/yyyy recommendation.

Using Xero instead? See how to import a bank statement into Xero.

Keep reading

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing