Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Workpaper Dashboard

Add a custom Microsoft Excel workpaper

For licensed users of Accounting CS Workpapers
There are 3 main procedures for adding a custom Excel workpaper in the application.

Select 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 selecting
    Add Workpaper
    .
  2. In the
    Workpaper Type
     screen of the Add Workpaper Wizard, select
    Custom Excel
     from the
    Source
     dropdown then select
    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. 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 dropdown, 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 dropdown 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.
  4. Select
    Next
    .

Define 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, select a grayed row below the last defined column.)
  2. Select a column type from the dropdown for the selected column, and enter a custom heading.
  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. Select
    Next
    .

Define 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.
    • 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. Select
    Finish
     to insert the workpaper into the engagement binder.

This article applies to:

  • Product: Workpapers CS
  • Subject: Engagements, Workpapers