QuickBooks Online accepts two CSV formats for importing bank transactions: a 3-column format and a 4-column format. They contain the same data — just organized differently. This guide explains the exact difference, when to use each, and how to import both into QBO without errors.
The Two Formats at a Glance
3-Column Format: Date, Description, Amount
Date,Description,Amount
01/15/2025,Stripe Payout,1280.45
01/16/2025,Office Rent,-1450.00
01/17/2025,AWS Invoice,-372.88
01/18/2025,Client Payment,950.00The Amount column uses a single signed number:
- Positive values (e.g.,
1280.45) = credits (money in) - Negative values (e.g.,
-1450.00) = debits (money out)
4-Column Format: Date, Description, Credit, Debit
Date,Description,Credit,Debit
01/15/2025,Stripe Payout,1280.45,
01/16/2025,Office Rent,,1450.00
01/17/2025,AWS Invoice,,372.88
01/18/2025,Client Payment,950.00,Credits and debits are split into separate columns:
- Credit column has a value when money comes in (the Debit column is blank)
- Debit column has a value when money goes out (the Credit column is blank)
- Both values are always positive — the column determines the direction
Key Differences
| Aspect | 3-Column | 4-Column |
|---|---|---|
| Columns | Date, Description, Amount | Date, Description, Credit, Debit |
| Debit representation | Negative number (e.g., -1450.00) | Positive number in Debit column |
| Credit representation | Positive number (e.g., 1280.45) | Positive number in Credit column |
| Blank cells | None — every cell has a value | One of Credit/Debit is blank per row |
| Visual clarity | Compact — one number to check | Clearer — debits and credits separated |
When to Use 3-Column
The 3-column format is the simpler option:
- Fewer chances for formatting errors — only three columns to get right
- Matches how most banks report amounts — a single signed number
- Easier to generate manually — if you're building the CSV by hand or in a script
- Default in most tools — many converters output this format by default
Best for: Quick imports, automated workflows, users who are comfortable reading signed amounts.
When to Use 4-Column
The 4-column format is preferred by some bookkeepers:
- Easier to visually verify — you can scan the Credit and Debit columns separately
- Matches traditional accounting layout — debit on one side, credit on the other
- Simpler to review large imports — debits and credits don't blend together in one column
- Helpful for reconciliation — separating directions makes it easier to spot misclassified transactions
Best for: Manual review before import, reconciliation-heavy workflows, users who prefer traditional debit/credit layout.
Common Mistakes (and How to Avoid Them)
Mistake 1: Negative amounts in the 4-column Debit column
In the 4-column format, debit amounts must be positive. The Debit column itself indicates the direction. If you enter -1450.00 in the Debit column, QBO may interpret it as a credit or reject the file entirely.
Fix: Use positive numbers only. The column name tells QBO the direction.
Mistake 2: Filling both Credit and Debit on the same row
Each row should have a value in either Credit or Debit — never both. If both columns have values, QBO won't know how to categorize the transaction.
Fix: Leave one column blank per row. Credits get a value in Credit (Debit blank), debits get a value in Debit (Credit blank).
Mistake 3: Wrong date format
QBO expects dates in MM/DD/YYYY format (e.g., 01/15/2025). If your CSV uses DD/MM/YYYY or YYYY-MM-DD, QBO will either reject the file or misinterpret the dates (turning January 2 into February 1, for example).
Fix: Always use MM/DD/YYYY. If your bank uses a different format, convert it before importing.
Mistake 4: Currency symbols or thousands separators in amounts
Values like $1,450.00 or 1.450,00 (European format) will cause import failures. QBO expects plain numbers: 1450.00 or -1450.00.
Fix: Strip all currency symbols, thousands separators, and non-numeric characters from amount fields.
Mistake 5: Extra header rows or blank lines
QBO expects exactly one header row followed by data rows. Extra blank lines, summary rows at the bottom, or multiple header rows (common when copy-pasting from multi-page PDFs) will cause errors.
Fix: Ensure the CSV has one header row and no blank lines or summary rows.
How to Import Either Format into QuickBooks Online
The import process is the same for both formats:
- Go to Banking (or Transactions → Bank transactions)
- Click the dropdown next to "Link account" and select "Upload from file"
- Choose your CSV file from your computer
- Select the bank account you want to import the transactions into
- Map the columns:
- For 3-column: Date → Date, Description → Description, Amount → Amount
- For 4-column: Date → Date, Description → Description, Credit → Credit, Debit → Debit
- Preview the transactions — QBO shows you what will be imported
- Click Import to finalize
QBO usually auto-detects the column mapping, but always verify it before confirming.
Generating QBO CSVs from Bank Statement PDFs
If you're manually building these CSVs from bank statement PDFs, you're doing unnecessary work. Exact Statement converts PDF bank statements directly to either QBO format:
- Upload your bank statement PDF
- Select "QBO 3-column" or "QBO 4-column" as the output format
- Preview the extracted transactions
- Download the CSV and import into QBO
The converter handles date formatting, amount normalization, page-break cleanup, and column mapping automatically — no manual template filling needed.
Ready to try it? Convert your first bank statement for free — no sign-up required for your first page.
