Adding a custom Microsoft Excel workpaper

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

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


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

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-only accounts, 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.)

    Notes

    • By default, Columns A, B, and C are defined as Account Number/Account Grouping and Description and System Required respectively, and cannot be deleted or moved in the column order.
    • 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 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.

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. For details, see Creating and using templates for custom Excel workpapers.

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.

Related topics

Adding blank Microsoft Excel and Word workpapers

Adding a PPC Checkpoint Tools workpaper

Adding a scanned workpaper

Adding a workpaper placeholder

Adding workpapers from an existing binder

Workpapers workflow for audit-based engagements

Share This