Workpaper Check Balance Diagnostic in Excel

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017.

For details, see CSA license expiration 2017 – frequently asked questions.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of these CSA modules.

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.

Note: By default the Exclude Check Balance Diagnostic checkbox on the Custom Workpaper Grouping Schedules grid page of the Create Workpaper wizard is unmarked.

Example

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

Share This