Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Batch Import feature fails due to invalid character in field

When using the Batch Import feature in Quickbooks, the import fails due to a report of an invalid character, the dollar sign ($). However, in looking at the Excel spreadsheet with the original data, there are no visible dollar signs.

How to fix it
  1. Within Excel, highlight the column containing the dollar amounts.
  2. Right-click that column and select format cells.
  3. On the Number tab, change the Category from Currency to General
    Note: The currency attribute adds the monetary symbol as a global property.
  4. Save the spread sheet with the edits.
  5. Re-attempt copying & pasting into the Batch Import screen.


KB ID# SLN75083
4/27/2017 3:33:57 PM
QYPPRDQBKSWS09 9138 Pro 2017 3656c7