The QuickBooks 3-column vs 4-column CSV choice comes down to how your bank exports money. A 3-column CSV has Date, Description and one Amount column, with payments negative. A 4-column CSV has Date, Description, Credit and Debit, with each amount in one column. Use whichever matches the bank file, so you convert less.
What the 3-column QuickBooks CSV layout looks like
The 3-column QuickBooks CSV layout is Date, Description and Amount, with every transaction's money in one column. Intuit's article Format CSV files in Excel to get bank transactions into QuickBooks shows payments as negative amounts and deposits as positive ones.
The sign carries the direction. A row reading -64.10 is money leaving the account; a row reading 2,400.00 is money arriving. Nothing else in the row says which way the money moved, so a lost minus sign turns a payment into a deposit.
Here are four example transactions for a fictional client, Example Client LLC, in the 3-column layout:
| Date | Description | Amount |
|---|---|---|
| 05/02/2026 | Client payment Ridgeline Studio | 2400.00 |
| 05/06/2026 | Card purchase Example Office Supply | -64.10 |
| 05/14/2026 | ACH Example Payroll Service | -1875.00 |
| 05/29/2026 | Interest paid | 3.12 |
Intuit's article Common errors for importing bank transactions using CSV names Date, Description and Amount as the only fields QuickBooks requires, which makes this the simplest file to build. Keep amounts plain, with no currency symbols or thousands commas, as that article advises.
What the 4-column QuickBooks CSV layout looks like
The 4-column QuickBooks CSV layout is Date, Description, Credit and Debit. Money is split into two columns by direction, and each row fills only one of them. Intuit's article Manually upload transactions into QuickBooks Online lists this as the second accepted layout.
Intuit's formatting article sets two rules for this layout. The headers should read only "Credit" and "Debit," so remove the word "amount" if the bank added it. And zeros should be removed, leaving the cell blank. Amounts in both columns are positive; the column tells you the direction.
The same four transactions in the 4-column layout. The columns follow the placement in Intuit's own 4-column example, which puts a payment under Credit and a deposit under Debit. Banks do not all label these columns the same way, so the upload preview, not the header, confirms the direction.
| Date | Description | Credit | Debit |
|---|---|---|---|
| 05/02/2026 | Client payment Ridgeline Studio | 2400.00 | |
| 05/06/2026 | Card purchase Example Office Supply | 64.10 | |
| 05/14/2026 | ACH Example Payroll Service | 1875.00 | |
| 05/29/2026 | Interest paid | 3.12 |
Intuit's common errors article flags one weakness of this layout. A 4-column file that holds only money-out transactions may fail to upload. Its workaround is to add one line with a positive amount and untick that line on the final screen.
Date and header rules apply the same way to both layouts. They are covered in the post on date formats QuickBooks Online bank uploads accept.
Which CSV column layout matches your bank's export?
The CSV column layout that matches your bank's export is the one with the same number of money columns. Open the download and count: one column with some negative values means a 3-column file; two columns, often labelled withdrawals and deposits or debit and credit, mean a 4-column file. Extra columns get deleted either way.
A typical bank download has more than the transaction columns. Look for these and remove them before choosing a layout:
- Running balance. A column that changes on every row and matches the account balance after each transaction. It is not a transaction amount.
- Check number or reference. Useful in the bank's view, not one of the QuickBooks fields.
- Type code. Labels such as DEBIT, CREDIT or ACH. These can tell you the sign when the amount column has none.
Watch for a hidden third pattern: one amount column, all positive, with a separate type column saying which rows are debits. That is neither layout. Either make the debit rows negative to get a 3-column file, or move them into their own column to get a 4-column file.
Card exports need a second look. Intuit's formatting article warns that credit card files may list transactions in reverse order and show deposits as negative amounts. Count the columns as usual, then check a known payment to see which sign the bank used.
If the file came from a PDF statement rather than a download, you choose the layout. Schema CPA reads bank and card statements and exports the rows to Excel or CSV, which the firm then arranges in whichever layout it prefers before uploading to QuickBooks; there is no direct QuickBooks connection. The list of supported documents on the homepage shows which statements it reads.
How do you convert a 4-column CSV to 3 columns in Excel?
To convert a 4-column CSV to 3 columns in Excel, add a new Amount column that subtracts the money-out column from the money-in column on each row. With the example layout above, payments in Credit (column C) and deposits in Debit (column D), the formula in E2 is =D2-C2. Fill it down, paste as values, then delete both source columns.
Using the example rows above, the formula gives 2400.00 for the client payment (2400.00 minus an empty cell), -64.10 for the card purchase, -1875.00 for the payroll debit and 3.12 for interest. Those match the 3-column table exactly. If your bank's file puts deposits under Credit instead, swap the cells: =C2-D2.
Three things to check after converting:
- Paste as values. Formulas do not belong in a CSV. Copy the new column and paste it back as values before deleting the source columns.
- Check one row of each direction. Confirm a known payment came out negative and a known deposit positive.
- Compare totals. The sum of the new Amount column should equal total money in minus total money out from the original columns.
Going the other way, from 3 columns to 4, takes two formulas. With Amount in C and the example placement above, put =IF(C2<0,-C2,"") in the Credit column and =IF(C2>0,C2,"") in the Debit column. That leaves the unused cell blank rather than zero, which matches Intuit's rule about removing zeros.
Before converting, clean the file. Totals rows, running balances and stray text break both formulas. The post on cleaning a CSV before importing it to QuickBooks covers what to remove first.
The flipped-sign mistake in 3-column QuickBooks files
The flipped-sign mistake in 3-column QuickBooks files is when payments arrive as deposits and deposits as payments. It happens when the bank's sign convention is the reverse of QuickBooks', most often in card exports, or when a 4-to-3 conversion subtracted the columns the wrong way round.
The symptom is easy to spot if you look. The upload preview shows the client's rent payment as money in and a customer deposit as money out. Intuit's video guide How to upload transactions manually says to confirm that amounts show as positive or negative correctly, and to select Reverse all values if they are reversed.
The fix is harder once rows are already in QuickBooks. A flipped file that went through review means every row needs undoing and the file uploading again. If the same file is then uploaded a second time without removing the first set, the account ends up with doubles. The post on duplicate transactions after a QuickBooks import covers clearing a batch like that.
A quick test before upload prevents both problems. Pick two rows you know: one payment and one deposit. If the payment is negative and the deposit positive, the file is the right way round. For more on building the spreadsheet from statements first, see the bank statements to Excel category.