ʯƵɫ

Skip to main content

  • Categories

  • Top products

Recommended products

Questions? We are here to help

  • Categories

  • Top products for corporations

  • Top products for accounting firms

Recommended products

Questions? We are here to help

Recommended products

Questions? We are here to help

  • Categories

  • Top products

Recommended products

Questions? We are here to help

  • Who we serve

  • Services

  • Platforms

  • Media Solutions

  • About

Recommended products

Questions? We are here to help

Books

Recommended products

Questions? We are here to help

  • APIs by industry

  • Use case library

  • Related sites

  • New releases

  • Join a TR community

  • Free trials & demos

Sign in to your products
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.
important
We recommend that you complete all of the grouping-type selections the 1st time you create the custom Microsoft Excel workpaper as they can't 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.

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.)
    note
    • By default, Columns
      A, B,
       and
      C
       are predefined as Account Number/Account Grouping and Description and System Required respectively, and can't 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 won't be deleted when the workpaper is recalculated from the Workpapers CS ribbon in Microsoft Excel.
    • You can select the
      Copy Column
       command to copy the attributes of the currently selected column to a new column in the grid.
    • You can select the
      Delete Column
       command to remove the selected column from the grid.
    • You can select the
      Move Up
       or
      Move Down
       commands to change the position of the selected column in the workpaper.
  2. Select a column type from the dropdown 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. Select
    Next
    .
note
  • 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.
  • Text formatting changes in column headings, column resizing, and font type in Microsoft Excel workpapers are retained after the workpaper is closed and reopened.

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