Adding a custom Microsoft Excel workpaper

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

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

Characters left:

A custom Excel workpaper is a dynamic workpaper that is linked to the trial balance in an engagement.

To add a custom Microsoft Excel workpaper, follow these steps.


  • You can add custom Excel workpapers only to trial balances that use account grouping codes or that have tax vendor information specified in the Firm Settings tab of the Administration workspace.
  • To add a custom Excel workpaper to a template, you must first create the workpaper within an existing engagement. Then, add the custom Excel workpaper to the template by choosing Existing Engagement as the source in the Add Workpaper wizard in the AdvanceFlow Templates area.
  1. In the Workpapers tab, click the folder to which you will add the workpaper.
  2. Click the Add Workpaper Add Workpaper button button.

    Note: You can also right-click the folder and choose Add > Workpaper from the context menu.

  3. Select Custom Excel from the Source drop-down list.
  4. Select the grouping type for this workpaper from the Grouping Type drop-down list and click Next.
  5. Do the following in the Options tab, depending on which grouping type you selected in step 4.
    • Account grouping: Select the account grouping and format from the drop-down lists in the Grouping Information section. You can choose all codes or click the Selected option and search for a specific code. You can include unassigned codes, codes with zero balances, or both. You can also include all codes with zero balances or only those codes that are currently active.
    • Tax codes: Select the format from the Format drop-down list. You can choose all codes or click the Selected option and search for a specific code. In addition to the options to include unassigned codes and codes with zero balances, you can also include M-3 Tax codes.
  6. Click the Columns tab and use the toolbar buttons to add, copy, arrange, or delete the columns listed in the right pane. You can change column properties as needed by selecting a column in the list and updating the properties that appear in the left pane.

    Note: The tickmark and workpaper references columns are unavailable for custom Microsoft Excel workpapers. Use the “User defined” column if you need to add this information.

  7. Click Next.
  8. In the Workpaper Properties screen, double-click beneath each column heading to update the workpaper properties, as needed.
    • Reference: Enter a reference.
    • Description: Enter a description.
    • User Assignment: Choose a user in the User Assignment dialog that opens and click OK.
    • Roll Forward: Choose the applicable item from this drop-down list to include or exclude the workpaper from the roll forward process.
    • During Finalize: Choose the applicable item from this drop-down list to retain or delete this workpaper during the finalize process.
  9. Click OK.

Related topic: Adding workpapers in AdvanceFlow

Share This