Home › Guides › QuickBooks Online CSV Format: 3 Columns vs 4 Columns

QuickBooks Online CSV Format: 3 Columns vs 4 Columns

QuickBooks Online accepts a bank transaction CSV with three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit). In the three-column format, payments are negative and deposits positive. With four columns, map the two amount columns carefully and verify one payment and one deposit in the preview before importing.

Updated November 6, 2026

Downloadable sample files (fictional rows, dd/mm/yyyy dates, checked against Intuit’s format article on November 10, 2026) are on the QuickBooks Online bank statement CSV template page:

3-column sample CSV 4-column sample CSV

Choose the bank-transaction template, not an invoice import

This format is for Bank transactions → Upload from file. It is not the template for importing invoices, customers or a journal. A bank export with a running Balance column is useful for checking the statement, but make a separate import copy containing the transaction fields below. Keep the original unchanged.

Option 1: a three-column signed-amount CSV

For a checking account, this is usually the simplest layout to audit. Here is a fictional example, using DD/MM/YYYY dates:

Date,Description,Amount
15/10/2026,Office supplies,-84.60
16/10/2026,Customer receipt,1200.00

The first row is money leaving the bank; the second is money arriving. Use plain decimal amounts, not a currency symbol or a thousands separator. Do not remove the minus sign from a payment. Keep one transaction per row and omit opening balance, closing balance and total rows from the upload file.

Option 2: four columns with separate amount fields

Intuit documents the headings Date, Description, Credit, Debit. Its sample places a payment in Credit and a deposit in Debit. A bank may label its columns from a different perspective, so do not assume the words on the bank export mean the same thing as the import fields.

DateDescriptionCreditDebit
15/10/2026Office supplies84.60
16/10/2026Customer receipt1200.00

This example follows Intuit's published example, not a universal bank naming convention. Enter an amount in only one amount column on each row. Leave the other cell blank rather than putting zero in it. Remove the word “amount” from headers such as “Credit amount”. If the mapping is confusing, use the signed three-column layout instead.

Map the CSV without reversing money in and out

  1. Open Bank transactions, choose the correct bank or credit card account and select Upload from file from the Link account menu.
  2. Select the CSV and confirm the destination account. A card statement belongs in its credit card account, not the checking account that pays the bill.
  3. Map Date and Description. Choose the one-amount or two-amount option to match your file.
  4. Select the date format that matches the actual text in the CSV.
  5. In the preview, find one known payment and one known deposit. Stop if either has the wrong direction or date.
  6. Finish the upload, then match or categorise the lines. Uploading a file is not the same as completing reconciliation.

Checks before uploading a full month

Intuit's transaction-list guidance specifies English files of 350 KB or less and up to 1,000 transaction lines per upload. Split a large export into smaller, non-overlapping batches. Use a consistent date format; Intuit recommends DD/MM/YYYY. If you edited the file in Excel, reopen the saved CSV and verify that dates and minus signs survived saving.

For a checking statement, compare opening balance plus deposits minus payments with the closing balance before stripping balance columns. That check catches missing rows and many sign errors, but it does not prove each description or category is correct. Review the individual transactions too.

From a PDF to reviewed transaction data

Only have a statement PDF? Create a QuickBooks CSV in your browser, check the extracted rows and balances, then use the three-column workflow above.

Open the converter → · Plans and limits · How balance checks work

Conversion runs in your browser; statement files are not uploaded to CSVLedger. A balance check helps identify extraction issues, but does not replace review or accounting reconciliation.

Frequently asked questions

Is a four-column CSV required?

No. QuickBooks Online accepts either the three-column or four-column bank transaction format. A signed Amount column is often easier to check.

Can I keep a Balance column?

Keep balances in your source copy for checking, but prepare the import copy with the three or four transaction fields documented by Intuit.

Does this import invoices?

No. This guide covers bank transaction uploads. Invoices and other records use different import workflows.

Related guides

Sources and scope

Based on official help documentation reviewed through search results on November 6, 2026. Menus, regional availability and product requirements can change; use the current official instructions if your screen differs. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import test.