How do I create a trial balance report in CCH® ProSystem fx® Engagement or Workpaper Manager?

The video below gives an overview on how to create a Trial Balance report in CCH® ProSystem fx® Engagement or Workpaper Manager.

  1. Open the binder containing the Trial Balance for which you want to create the report.
  2. Open the Trial Balance.
  3. On the CCH® ProSystem fx® Engagement or Workpaper Manager ribbon, select Create > TB Reports .
  4. If not already selected, select the Trial Balance from which you want to create the report from the Trial Balance drop-down list.
  5. In the Grouping List field, select the account grouping with the groups you want to use.
    • The account groups in that grouping appear in the box below.
    • The list does not show subgroups.
    • The selected grouping list cannot be changed after the report is created.
  6. In the Account Groups box, choose from the following:
    • Include selected
      • Includes only those account groups that are selected from the Account Groups list.
    • Include current and future
      • Includes all current account groups listed in the Account Groups list as well as any additional groups you add in the future.
      • When this option is selected, all of the account groups are automatically selected and the Select All button become inactive.
    • Classified report
      • Checking this box includes account class and account type totals in the trial balance report.
      • This check box is enabled if you chose Include current and future.
      • This check box is disabled if you chose Include selected.
  7. Check the boxes next to the group or groups for which you want to create a report.
    • To include all groups, click Select All.
    • To clear all selections, click Unselect All.
  8. A default report name will appear in the Report Name Guide field, which you can accept or change.
  9. Under Report Type, choose the type of report to create:
    • Summary - Groups
      • Includes just the totals of each account group.
    • Summary - Subgroups
      • Includes the subtotals by subgroup and then the totals for each group.
    • Detail
      • Lists the accounts in each account group and account subgroup and shows the subtotals.
      • You can have each account group in a separate report or combine all account groupings in a single report.
      • Check the Combine Groups box if you want all detail information in a single report.
  10. Based upon the selections made, check and/or uncheck the following boxes under Settings:
    • Hide empty groups and subgroups
      • Causes groups and/or subgroups not to be included on the report if the groups and/or subgroups do not have accounts grouped to them.
    • Hide accounts with zero balances
      • Hides any accounts that have zero balances from within your report.
      • This option is available only when you select Detail as the report type. Place a check in the box to activate this function.
      • Select this option with caution. Only accounts with zero balances in the columns selected to be included on the report will be hidden. Other balance columns or journal entry columns may have non-zero balances or activity, but the account will still not be included on the report.
    • Print as Black and White
      • Sets the printer settings to not print the cell background colors.
    • Show WP Ref Columns
      • Shows any workpaper references—if you have workpaper reference columns set up in the corresponding trial balance.
      • This check box is only enabled if the report type is Detail.
    • Include sum of account groups
      • Prints a “Sum of Account Groups” row at the bottom of the trial balance report.
      • This row provides the total for each balance and journal entry type of all the groups selected to be included in the report.
      • This box is enabled for all Summary - Groups, Summary - Subgroups, and Detail report types, both classified and unclassified, except an unclassified Summary - Group TB Report.
    • Include net income
      • Prints a “Net (Income) Loss” row at the bottom of the trial balance report.
      • This row provides the net (income) loss amount for each balance and journal entry type included in the report.
      • This will be the “true” net (income) loss amount for all groups, not just the groups selected to be included in the report.
  11. Click Format to define what columns will be reflected in the report(s) you are creating.
  • Note: The columns available for selection under "Available columns in this period" correspond to columns that have been added to the trial balance database using TB Column Setup.  If a column that you are wanting to add to your report is not available, it will need to be added to the correct view before it is available to select when creating a report. Refer to our article How do I add balance columns to my Trial Balance?
  1. Click OK when you are finished defining the report settings.

Note: The reports are created and stored in the Unfiled Workpapers folder within the Binder window. If you are creating multiple reports, you can see what report is being created in the status bar of Excel in the bottom-left corner of the Excel window.

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

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