Quotation marks are being added to the account, description, or account balance fields when using Paste TB import in CCH® ProSystem fx® Engagement and Workpaper Manager.

  • Article Type:
  • Problem Resolution
  • Last Modified:
  • 02/13/2020

Symptoms

When performing a Paste TB Import in Microsoft® Excel® quotation marks are inserted either or all columns for the account number, account description, or balance columns causing them to be invalid accounts which prevents them from properly importing.

Environment

  • CCH ProSystem fx Engagement
  • CCH ProSystem fx Workpaper Manager
  • Microsoft Excel

Cause

While not visible in the workbook there's hidden formatting or invisible quotation marks in the cells in Microsoft® Excel®.  This is normally when the data was imported or converted from another software programs.

For known examples:
  • Importing from Quickbooks.
  • Converting a PDF to Microsoft® Excel®

Resolution

  • Run the Text to Column function.  (Note: Microsoft® Excel® can only change one column at a time.)
  1. Open Microsoft® Excel®,
  2. Select the column or cells that are affected. 
  3. Click on the Data ribbon.
  4. Click Text to Column function.
  5. Leave the defaults and click Finish.
  6. Save and close the workbook.
  7. Reopen the workbook.
  8. Copy the data and use paste TB import. 
  • If the above is still occurring with the balance columns only, try changing the formatting to Currency.
  1. Open Microsoft® Excel®
  2. Select the balance column(s).
  3. Right-click and select Format Cells.
  4. Click Currency.
  5. Click OK.
  6. Re-attempt to Copy the data and use paste TB import.
  • Workaround the issue by manually removing the quotation marks with Notepad.
  1. In Microsoft® Excel® Click File
  2. Click Save As and cick Browse.
  3. Save the file the Desktop.
  4. Change the format from Excel Workbook to Text (Tab delimited).txt.
  5. Close Microsoft® Excel®.
  6. Open the (.txt) file in Notepad.
  7. In Notepad click Edit menu.
  8. Select Replace...
  9. In "Find what" type in:  "
  10. Leave "Replace with" blank (no spaces)
  11. Click Replace All.
  12. Save over the file in Notepad.
  13. Open Excel and go to File >Browse.
  14. Open the .txt file in Microsoft® Excel®.
  15. Use the defaults settings when prompted to open the file.
  16. Recopy the content and Paste TB Import into Engagement.
If receiving Invalid Data on the clipboard, please review this article link:

Additional Information

N/A

  Solution Tools
  Attachments
 Solution Id 000094483/000094483
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!