Special characters in a QuickBooks CSV break the bank upload in three common ways: a comma inside a payee name splits one column into two, a stray quote mark swallows the rows after it, and accented letters turn into junk when the file is saved in the wrong encoding. Clean the description column, then save as a plain CSV.
Which special characters break a QuickBooks CSV upload?
The characters that cause trouble are the ones a CSV file uses for its own structure, plus any letter the file's encoding cannot hold. A comma separates columns. A double quote wraps a cell that contains a comma. Accented letters, curly quotes and symbols like the euro sign depend on how the file was saved.
Intuit lists this as its own cause in common errors when importing bank transactions from a CSV. It says special characters in the bank description can stop the import, and that the fix is to remove them with Ctrl-H, the find and replace shortcut in Excel. The same page lists currency symbols in the amount column as a separate formatting problem.
Bank descriptions are where these characters gather. Card processors add asterisks and hash marks, merchants put ampersands and apostrophes in their names, and foreign suppliers bring accented letters.
Commas inside payee names in a QuickBooks CSV
A comma inside a description splits that description across two columns unless the cell is wrapped in double quotes. The CSV format itself sets this rule: RFC 4180, the CSV format specification, says a field containing a comma should be enclosed in double quotes. Without the quotes, every column after the comma shifts one place right.
Picture a row for an example supplier, "Smith, Jones & Co". Unquoted, QuickBooks sees "Smith" as the description and " Jones & Co" in the amount column, and the row fails. Excel adds the quotes for you when it saves a CSV, so this usually happens when a file was edited in a plain text editor or produced by a tool that skipped quoting.
The simplest fix is to replace commas in the description column with a space or a hyphen before saving. The payee stays readable and the problem disappears.
Stray quote marks in a QuickBooks CSV description
A single unmatched double quote in a CSV can make everything after it look like one long cell. Programs reading the file see the quote as the start of a quoted field and keep reading until they find a closing quote. That may be several rows later, so rows merge, vanish or land in the wrong columns.
RFC 4180 says a double quote inside a quoted field must be written as two double quotes. Banks rarely follow that rule when a description includes something like a 12" pipe fitting or a nickname in quotes. Excel handles it correctly when it saves, but a file assembled by hand often does not.
For bank uploads, the quote mark carries no meaning you need. Replace every double quote in the description column with nothing, or with a single apostrophe if the text reads better that way.
Accented letters that come out garbled in a QuickBooks CSV
Accented letters turn into strange symbols when the file is saved in one encoding and read in another. "Café" becomes "Café", or a curly apostrophe becomes three odd characters. The letter was never lost; the program reading it guessed the encoding wrong.
Intuit's guide to formatting CSV files in Excel for bank transactions gives one save instruction worth heeding here: Mac users must save the file as a Windows CSV file. Beyond that, the safest course for an upload is to replace accented letters with plain ones, such as e for é, so the encoding stops mattering.
Find and replace for special characters before the QuickBooks upload
Cleaning special characters takes one pass with find and replace, limited to the description column. Select that column first, press Ctrl-H, and work through the list below, replacing each character in turn. Then save as CSV and upload again.
The table shows example cells. The merchants are made up.
| Before (example) | Character | Replace with | After |
|---|---|---|---|
| Smith, Jones & Co | comma | space | Smith Jones & Co |
| SQ *CAFÉ LUNA | É | E | SQ *CAFE LUNA |
| 12" PIPE SUPPLY | double quote | nothing | 12 PIPE SUPPLY |
| O’BRIEN PLUMBING | curly apostrophe | nothing | OBRIEN PLUMBING |
| PAYPAL #INV-2207 | hash | nothing | PAYPAL INV-2207 |
Intuit's common errors page offers one more tip: copy the CSV content into a blank spreadsheet to reveal hidden formatting problems. Do that last, after the replacements, and save the new sheet as the file you upload.
If you start from a bank's own export, check it before cleaning. Exporting Chase transactions to CSV shows what one bank's download looks like and which columns you get.
When should special characters stay in a QuickBooks CSV?
Special characters should stay wherever QuickBooks needs them to read a value. The minus sign on a withdrawal and the decimal point in an amount are characters too. Stripping them changes the money, so limit find and replace to the description column and leave the amount and date columns alone.
The same caution applies to other kinds of import. A journal entry upload or a QuickBooks Desktop IIF file has its own layout and its own rules, and cleaning those files the same way can break them in new places. Fixing a journal entry import error in QuickBooks Online and reading an IIF import error in QuickBooks Desktop cover those files.
If your CSV came from typing up a PDF statement, much of this cleaning comes from the copying. SimpleBankConvert is being built to turn a PDF statement into a CSV laid out for the QuickBooks Online upload. Accounts are not open yet; get started to be told when they are.