# QuickBooks CSV Amount Column Error: Fix the Numbers

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2025-02-22
- Updated: 2025-02-22
- Category: Import errors
- Canonical: https://www.simplebankconvert.com/blog/quickbooks-csv-amount-column-error

> How to fix a QuickBooks CSV amount column error: currency symbols, commas, brackets for negatives and blank cells that make the upload reject rows.
A QuickBooks CSV amount column error means some cells in the amount column aren't plain numbers QuickBooks can read. The usual culprits are dollar signs, thousands commas, brackets standing in for minus signs, zeros and stray text. Change the column to a general number format, write negatives with a minus sign and leave empty cells blank.

## What a clean QuickBooks CSV amount column looks like

A clean amount column in a QuickBooks CSV holds one plain number per row: digits, an optional minus sign at the front and a decimal point before the cents. Nothing else. No currency symbol, no comma between thousands, no brackets and no words such as "CR" or "DR" after the figure.

[Intuit's guide to formatting CSV files for bank transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US) shows the layout. A three-column file has Date, Description and Amount, and its example writes a payment as `-100.00`. A four-column file splits the money into Credit and Debit, and Intuit says those headers should read only "Credit" and "Debit," without the word "amount."

Here is what QuickBooks expects compared with what bank exports often contain. The rows are examples:

| Cell as exported | Problem | Cell after the fix |
| --- | --- | --- |
| `$1,250.00` | Currency symbol and comma | `1250.00` |
| `(42.10)` | Brackets for a negative | `-42.10` |
| `42.10-` | Minus sign at the end | `-42.10` |
| `310.55 CR` | Text after the number | `310.55` |
| `0.00` | A zero in a split column | (blank) |
| `1 250,00` | Space and comma decimal | `1250.00` |

Every fix in the right-hand column is something you can do in a spreadsheet in a few minutes. The rest of this post shows how, one problem at a time.

## Dollar signs and thousands commas in CSV amounts

A dollar sign or a thousands comma turns a number into text as far as the upload is concerned. Intuit's article on [common errors when importing bank transactions from a CSV](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/common-errors-importing-bank-transactions-using/L02IgW462_US_en_US) gives the fix: open Format Cells on the amount column and change the category from Currency to General, then upload again.

That fix works because many CSV files only look as if they have symbols. The spreadsheet shows `$1,250.00`, but the cell underneath holds `1250` with a currency format on top. Switching to General removes the display layer, and the file saves with the bare number.

Sometimes the symbol is part of the text itself. This happens when the bank wrote `"$1,250.00"` into the CSV in quotes. Switching the format then changes nothing on screen. Use find and replace on the amount column only:

1. Select the amount column (or the Credit and Debit columns).
2. Replace `$` with nothing.
3. Replace `,` with nothing. Do this only in the money columns, never across the whole sheet, because descriptions often contain commas that should stay.
4. Set the column format to General or Number with two decimal places.
5. Check a few large values by eye. `1,250.00` should now read `1250.00`, not `1.25`.

Commas inside a description cause a different failure, because the comma is also the column separator. That and other punctuation problems are covered in [special characters in a QuickBooks CSV](/blog/special-characters-in-quickbooks-csv).

### Amounts written the European way

Some exports use a comma for the decimal point and a space or full stop between thousands, so one thousand two hundred fifty dollars appears as `1 250,00` or `1.250,00`. Replacing commas there would turn it into `125000`. Remove the thousands separator first, then change the decimal comma to a full stop.

## Are brackets around negative amounts safe in a QuickBooks CSV?

Brackets around a number are an accounting habit for showing a negative, so `(42.10)` means minus 42.10. Intuit's formatting guide does not list brackets as an accepted form; its example writes payments with a leading minus sign. Convert every bracketed amount to that form before upload rather than relying on QuickBooks to read it.

In most spreadsheets, a number stored with a bracket format is already negative underneath. Change the column to General and the brackets become a minus sign. Check one cell: if the formula bar shows `-42.10`, you're done.

If the brackets are typed text, the column needs a small rebuild. Add a helper column next to it and use a formula that strips the brackets and multiplies by minus one when they were present. Copy the results, paste them back as values over the original column, then delete the helper. Check the totals before and after. The sum of the money-out rows should be the same number with the same sign.

The same applies to a trailing minus sign, as in `42.10-`, which some older bank systems print. QuickBooks needs the minus at the front.

### Getting the direction right

A three-column file carries direction in the sign. For a bank account, money out is negative and money in is positive. If the whole file has the signs the wrong way round, flip them all at once with a helper column that multiplies each amount by minus one. Card files can arrive the other way round. Intuit's formatting guide notes that in a credit card file, transactions may appear in reverse order and deposits may show as negative amounts, and that a card file should go to the credit card account, not a bank account.

## Zeros and blank cells in the amount column

In a four-column CSV, each row has money in only one of the Credit and Debit columns, so the other cell is empty. Intuit's formatting guide is direct about what goes there: remove any zeros from the file and leave those cells blank.

Many bank exports fill the unused side with `0.00` or a dash. Clear them. Use find and replace with the whole-cell option switched on, so that `0.00` is replaced but `100.00` is not. A dash or a pair of dashes should go the same way.

Blank cells are a different story in a three-column file. There, every row needs an amount. A row with an empty amount is usually not a transaction at all but a heading, a subtotal, a page break or an opening balance line copied from the statement. Delete those rows rather than typing a zero into them.

Watch for cells that look blank but hold a space. They pass a quick glance and fail the upload. Selecting the column and searching for a single space finds them.

## Why does a debit-only CSV amount column fail?

A debit-only file is a four-column CSV where every row is money out and the Credit column is empty from top to bottom. Intuit's common-errors article names this case: a file with separate debit and credit columns that covers a period of only money-out transactions can cause an upload error.

Intuit's fix is a placeholder. Add an extra line with a positive amount in the Credit column. Upload the file as usual, and on the final list of transactions, untick that one line before you confirm. Nothing extra reaches the books.

An example placeholder row, with made-up values:

| Date | Description | Credit | Debit |
| --- | --- | --- | --- |
| 03/31/2026 | PLACEHOLDER DO NOT IMPORT | 1.00 | |

Name the line so it is impossible to miss on the review screen. The other way round this problem is to switch the file to three columns, with a single Amount column where every payment is negative. That layout has no empty column to trip over.

## Amounts with twelve or more digits

QuickBooks Online refuses amounts that are too long. [Intuit's list of bank upload errors](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/fix-bank-upload-errors-quickbooks-online/L6FBh3zDC_US_en_US) gives the message "The uploaded file contains invalid transaction amount information" and says it happens when a transaction has 12 or more digits.

Real transactions that size are rare for a small business. A twelve-digit amount is far more often a mistake in the file: an account number or reference pasted into the amount column, or two cells that merged when a statement was copied from a PDF. Sort the amount column from largest to smallest and look at the top few rows. Anything that doesn't match a real payment is the culprit.

When the amount is genuine, Intuit's advice is to remove that transaction from the file, enter it in QuickBooks by hand as a sales receipt or expense, and upload the rest.

## Spreadsheet habits that break the amount column again

The amount column often breaks a second time after it was fixed, because of how the file was opened and saved. A spreadsheet reformats numbers when it opens a CSV, and saves them in that new form. Knowing which habits cause this keeps a clean file clean.

Habits to avoid:

- **Opening the fixed CSV and saving it again.** Excel and Numbers can reapply a currency format to anything that looks like money.
- **Saving as a spreadsheet file instead of CSV.** An .xlsx or .numbers file is not a CSV, whatever the column contents. Intuit's formatting guide adds that Mac users must save in Windows CSV format.
- **Fixing the display and not the value.** Shrinking the decimal places hides cents without removing them.
- **Rounding by formula.** A total that is off by a cent across hundreds of rows usually comes from this.

Check the saved file in a plain text editor before you upload. Each line should read like `03/14/2026,Hardware store,-42.18`, with nothing around the number.

Amount columns are not only a CSV problem. In an IIF file for QuickBooks Desktop the same rules apply to a different layout, covered in [reading an IIF import error in QuickBooks Desktop](/blog/iif-import-error-in-quickbooks-desktop). Bank files from treasury systems can be stranger still: the [BAI2 file format](/blog/bai2-file-format) stores amounts with no decimal point at all.

Dates and amounts that need fixing by hand are what SimpleBankConvert is meant to remove. It is being built to turn a PDF statement into a CSV with one amount column and money out shown as a minus. Accounts aren't open yet; [get started](/get-started) to hear when they are.