Adding a custom Microsoft Excel workpaper

Alerts and notices

In AdvanceFlow, 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.

Notes

  • You can add custom Excel workpapers to only those 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. Click the Engagements button at the bottom of the navigation pane and then select the applicable engagement in the navigation pane.
  2. In the Workpapers tab, click the folder to which you will add the workpaper.
  3. Click the Add Workpaper Add Workpaper button button.

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

  4. Select Custom Excel from the Source drop-down list.
  5. Select the grouping type for this workpaper from the Grouping Type drop-down list and click Next.
  6. 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.
  7. 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.

    Notes:

    • 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.
    • When the application recalculates the workpaper, it removes all text and formatting changes, including font style, font type, font size, and highlight, unless you are working in a User Defined column or in a column to the right of the last column that contains calculations and the specific cell contains data.
  8. Click Next.
  9. 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.
  10. Click OK.

Excel does not automatically update custom Excel workpapers with the latest trial balance data. The application displays a yellow banner along the top of the workpaper, prompting you to recalculate the formulas if there may be differences.

Share This