Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

The Workpaper Check Balance Diagnostic for workpapers created by grouping code in Engagement CS is a utility that compares the total balances in your Excel worksheet with the trial balance data in CSA. A mismatch in total balances can occur when an account is added in CSA and assigned to a grouping code that is in use, or if the grouping code assignments have been changed.

A balance diagnostic section prints at the bottom of each workpaper created by grouping code that displays amounts for each grouping code selected, based on the trial balance totals in CSA. Using Microsoft Excel's conditional formatting, any out of balance amount is displayed in red if it does not match the amounts in the Total line of the worksheet.

Example

The following example illustrates the Workpaper Check Balance Diagnostic in a worksheet that includes subcodes and account detail.

Was this article helpful?

Yes No

Submit