Adding a custom Microsoft Excel workpaper

Show expandable text

For licensed users of Accounting CS Workpapers

There are three main procedures for adding a custom Excel workpaper in Workpapers CS.

We recommend that you complete all of the grouping-type selections the first time that you create the custom Microsoft Excel workpaper as they cannot be modified once a custom Excel workpaper is created. However, you can create additional columns and change column headings after the custom Excel workpaper is created, as needed.

Selecting grouping types and general ledger accounts

  1. In the Engagement Binders Tree portlet in the Workpapers Dashboard, open the Add Workpaper Wizard by right clicking an engagement binder briefcase, folder or workpaper, and choosing Add Workpaper or by clicking the Add Workpaper Add workpaper icon.
  2. In the Workpaper Type screen of the Add Workpaper Wizard, select Custom Excel from the Source drop-down list, and click Next.
  3. Based on the client's Chart of Accounts setup, choose the grouping type.
    1. Account number. You can choose to include All accounts, Core accounts, Segment Only, or selected Segments from the Chart of Accounts. (See Setting up a client's Chart of Accounts mask for details.) Mark the Include inactive checkbox to include any accounts that are marked as inactive in the workpaper.
    2. Account grouping. Select the account grouping from the drop-down list, and then mark the checkboxes for the individual codes that you want to display on the workpaper. For each code, you can also choose to include detail on the subcode and/or account level. (The Account grouping drop-down list contains account groupings that have been set up for the client in the Account Groupings screen.)
    3. Tax code. Select this option to group accounts by tax code. Mark the Include account detail checkbox to view a detailed report. For details, see Tax code assignments for GL accounts.
  4. Click Next.

Defining columns

  1. In the Column Definition screen of the Add Workpaper Wizard, select the column that you want to define in the Column Order grid. (To add a new column, click in a grayed row below the last defined column.)


    • By default, Columns A, B, and C are predefined as Account Number/Account Grouping and Description and System Required respectively, and cannot be modified, deleted, or moved in the column order.
    • User Defined columns can be modified, deleted, and moved in the column order. Items that are added to the User Defined column will not be deleted when the workpaper is recalculated from the Workpapers CS ribbon in Microsoft Excel.
    • You can click the Copy Column Copy button button to copy the attributes of the currently selected column to a new column in the grid.
    • You can click the Delete Column Delete button button to remove the selected column from the grid.
    • You can click the Move Up Up arrow button or Move Down Down arrow button buttons to change the position of the selected column in the workpaper.
  2. Select a column type from the drop-down list for the selected column, and enter a custom heading.

    Note: If you choose not to enter custom heading text, the application applies default column headings.

  3. Select the amount properties (amount type, balance type, period, and year) in the Type Definition section.
  4. Mark the Landscape checkbox or leave the checkbox cleared to retain a Portrait orientation.
  5. Click Next.


  • You can save your column settings as a template. When you create subsequent custom Excel workpapers in the Add Workpaper wizard, the same column definitions can be selected from Template field of the Column Definition screen. For details, see Creating and using templates for custom Excel workpapers.
  • Text formatting changes in column headings, column resizing, and font type in Microsoft Excel workpapers are retained after the workpaper is closed and reopened.

Defining workpaper properties

  1. Select the following information in the Workpapers Properties screen of the Add Workpaper Wizard.
    • Engagement Binder. Select a the binder into which the workpaper will be added. (Note that Finalized binders do not appear in the list.)
    • Location. Select a the binder folder into which the workpaper will be added.
    • Reference. Enter a unique workpaper reference number for the engagement binder.
    • Name. Enter a unique name for the workpaper.
    • Roll Forward. Select one of the available Roll Forward treatment options from the list.
      • Exclude. Flags the workpaper for deletion during the roll forward process.
      • Include. Flags the workpaper to be included in both the final engagement and in the new engagement that is created during the roll forward process.
      • Replace - manual reference. Inserts a place holder in the engagement to assist in tracking and organizing manual documents after the roll forward is complete.
      • Replace - PPC Checkpoint Tools. Replaces the selected workpaper with another workpaper from PPC Checkpoint Tools during the roll forward process. (Note that this option is available only if you are licensed for PPC Checkpoint Tools and have the application installed.)
      • Replace - selected engagement. Replaces the selected workpaper with a workpaper from another engagement during the roll forward process.
      • Replace - SMART Practice Aids. Replaces the existing PPC workpaper with another workpaper from SMART Practice Aids during the roll forward process. (Note that this option is available only if you are licensed for SMART Practice Aids and have the application installed.)
    • Assigned. Assign a staff member from the drop-down list.
    • Delete on Finalize. Mark this checkbox to delete the workpaper when the engagement binder is finalized.
  2. Click Finish to insert the workpaper into the engagement binder.

Was this article helpful?

Thank you for the feedback!