Add Custom Excel workpapers linked to trial balance

  • A user account that has been granted the
    Add Workpaper
    permission.
  • A client and an engagement in
    Engagement Manager
    .
  • An engagement that has:
    • a trial balance that uses account grouping codes or
    • specified tax vendor information.
  1. In Engagement Manager, open the engagement, then select the
    Workpapers
    tab.
  2. Select the target folder where you want to add Custom
    Excel
    workpapers.
  3. Select
    Add
    , then
    Workpaper
    .
  4. Select
    Custom Excel
    from the Source dropdown list, then
    Next
    .
  5. Choose one of the following options from the
    Grouping Type
    dropdown list:
    • Account Grouping
    • Tax Code
  6. Select
    Next
    .
  7. If you selected the Account grouping type, specify the
    Account Grouping
    ,
    Format
    , and the codes you want to include.
  8. If you selected the Tax codes type, specify the
    Format
    and the codes you want to include.
  9. Select
    Next
    .
  10. Customize columns as needed.
    1. To edit the properties of a column, select the column, then use the Column properties fields. 
    2. To add a column, select
      Add
      , select the new column, then choose a
      Column type
      and properties.
    3. To arrange the columns you've added, select the column, then use
      Move up
      or
      Move down
      .
    4. To delete a column you've added, select the column, then
      Delete
      .
  11. Select
    Next
    .
  12. Use the
    Reference
    ,
    Description
    ,
    User Assignment
    ,
    Roll Forward
    , and
    During Finalize
    fields to choose the properties for your Custom
    Excel
    workpaper.
  13. Select
    Done
    .

Related content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close