We moved!
Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!
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
- 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 icon.
- In the Workpaper Type screen of the Add Workpaper Wizard, select Custom Excel from the Source drop-down list, and click Next.
- Based on the client's Chart of Accounts setup, choose the grouping type.
- 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.
- 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.)
- 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.
- Click Next.
Defining columns
- 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 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 button to copy the attributes of the currently selected column to a new column in the grid.
- You can click the Delete Column button to remove the selected column from the grid.
- You can click the Move Up or Move Down buttons to change the position of the selected column in the workpaper.
- 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.
- Select the amount properties (amount type, balance type, period, and year) in the Type Definition section.
- Mark the Landscape checkbox or leave the checkbox cleared to retain a Portrait orientation.
- Click Next.
Notes
- 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
- 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.
- Click Finish to insert the workpaper into the engagement binder.
Was this article helpful?
Thank you for the feedback!