In order to perform a Paste TB Import into a Trial Balance, the import data needs to be formatted correctly.

• Ideally, the trial balance would be in the same binder as the source Excel workpaper that is being imported.
  • How to add a workpaper to a binder in CCH® ProSystem fx® Engagement or Workpaper Manager.
• In the source spreadsheet, the data that will be used for the Paste TB Import function should be set up into continuous columns with no blank columns or rows.
• Any blank cells will need to be either removed or have a value entered.
• Verify there are no frozen panes in Excel by scrolling up and down, also left and right. If so, please go to View > Freeze Panes > Unfreeze Panes.
• Verify that all account numbers are unique.
• A column for the Account Number and Description should be included as well as a single column for each balance column to be imported. Ensure that there are no special characters in the Account Number and Description columns.
  • Do not use the following special characters in your Account Number: ' | : " , ( ) * ? &
    • Note: Account numbers cannot exceed 64 characters.
  • Do not use the following special characters in your Account Description: | * ? "
    • Note: Account descriptions cannot exceed 255 characters.
  • Remove any spaces that follow the account number or description
• Balance columns should not contain any formulas or non-numeric data. Remove formulas by using the Copy and Paste Value Excel function.
• Verify that the Debits and Credits are in one column. The credits should be differentiated with a minus sign (-) or in parentheses.
• Column headers should not be copied when copying the data for the Paste TB Import.
• Optionally, you can also include one or more columns for account group mappings. Note that this feature of the Paste TB Import function is limited to the following CCH ProSystem fx grouping lists:
  • Financial Statements
  • Trial Balance - Basic
  • Trial Balance - Advanced

• Example: You want to import an account into the "4100.00 Cash" subgroup in a Financial Statements grouping list. Your Excel file needs a column for Group Index and a column for Subgroup Index.  The Group Index cell must contain only "4100" while the Subgroup Index cell must contain only "4100.00" and the cell must be formatted as "Number."

We have included a Paste_TB_Import_Template.xlsx template workpaper in the "X:\Pfx Engagement\WM\Workpaper Templates\TB Import" directory that explains how to perform the Paste TB Import method and can be used as the template file for performing the import. 
Those files are available for download in the attachments section of this article. For more information, please visit the following article:

• How do I import Chart of Accounts information into my CCH® ProSystem fx® Engagement or Workpaper Manager Trial Balance from a Microsoft® Excel® document?