QuickBooks Online CSV: 3-Column vs 4-Column Format (Which to Use)

If you have ever uploaded a bank CSV to QuickBooks Online and hit the "Some info may be missing from your file" error, the column format is usually the cause. QuickBooks supports exactly two layouts, and the file you get from your bank rarely matches either one without adjustment. This guide shows when to pick each format, what the rows should look like, and how to handle the edge cases.

The two supported formats

Both formats import correctly. Both support credit cards and checking accounts. Neither supports a category column (QuickBooks asks you to categorize inside the For Review tab after import).

3-column format: one signed Amount column

The 3-column layout is the cleaner option when your bank gives you a single Amount column. QuickBooks reads the sign to determine whether the transaction is a deposit or a withdrawal.

Example rows:

Use this format when: your bank CSV already has one Amount column, you are uploading a credit card (where spending is typically all negative), or you want the cleanest possible file.

4-column format: separate Credit and Debit columns

The 4-column layout mirrors how many business banking portals export data. Each row shows either a Credit (money in) or a Debit (money out), never both. The unused column is left blank.

Example rows:

Use this format when: your bank CSV already has separate Credit and Debit columns, or you want QuickBooks to interpret direction without relying on positive/negative signs.

Which banks export each format

Bank export formats change over time and differ by account type (checking vs credit card vs business), so always verify with your own export. Here is what most users see today:

Converting between the two formats

If your bank exports a 4-column file but you prefer a cleaner 3-column import (or vice versa), you have three options:

1. Rewrite the columns manually in a text editor. Tedious but free.
2. Write an Excel or Google Sheets formula like =IF(C2>0, C2, -D2) to combine Credit and Debit into one signed Amount. Works but introduces formula errors if a row has zeros instead of blanks.
3. Run the file through a converter that handles both directions.

After the import

Both formats leave every imported transaction in QuickBooks' For Review tab, waiting for a category. QuickBooks ignores any category or class column in the CSV, so you cannot pre-categorize from the file itself.

The Bulk Categorizer groups transactions by category and Schedule C bucket so the review step takes minutes instead of hours, especially on larger statements where hundreds of rows land in the review queue at once.