Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Workpapers

Add special formatting for engagement links in Microsoft Excel

With Engagement Manager you can combine engagement links with Microsoft Excel formatting formulas to provide alternative display options for text in Excel workpapers. Most linking and formatting options for Excel workpapers opened through Engagement Manager are available in Engagement Link.
To access Engagement Link:
  1. In Engagement Manager, open the spreadsheet you want to edit.
  2. After the spreadsheet opens in Microsoft Excel, select the
    Engagement Manager
     tab.
  3. Select
    Engagement Link
    .

Format the client name

When you add client names using the fields in Engagement Link, Excel retrieves the names from the corresponding fields in GoFileRoom. This formats client names in all capital letters.
To display client names using the proper case, use one of the following methods.
  • Combine the Excel formula
    PROPER
    , which capitalizes only the first letter of each word, with the Engagement Manager formula for the client name. The formula should look similar to this:
    =PROPER(AfText("CP<Client Name'Description><Text>"))
  • In Engagement Manager, add an account in the
    Trial Balance
     tab. Enter the client name using the proper capitalization for the
    Description
    . You can then insert the Engagement Manager account description variable instead of the client name into the Excel spreadsheet.
  • In Engagement Manager, enter the client name (using the proper capitalization) as the workpaper description. For example, enter
    FS-1
     as the financial statement workpaper reference and
    ABC Company, LLC
     as the workpaper description. You can then insert the Engagement Manager workpaper description variable instead of the client name into the Excel spreadsheet.

Combine dates with text in the same cell

Follow these steps to display both text and dates in the same cell (for example,
Adjusted 12/31/20XX
 or
December 31, 20XX & 20XY
).
  1. In Microsoft Excel, insert a date formula using the fields in Engagement Link.
  2. Put your cursor before the Engagement Manager formula in the formula bar.
  3. Enter quotation marks around any text (excluding formulas) that should display in the cell, and enter an ampersand (&) between the text and formulas.
Displaying "Adjusted 12/31/20XX" in a cell
  1. Use the fields in Engagement Link to insert
    12/31/20XX
     as the date.
  2. In the formula bar, place your cursor after the equal sign and before anything else.
  3. Enter
    "Adjusted "&
    . You must include the quotes and spaces.
  4. Use Enter to insert the combined text and formula.
Displaying "Period ending December 31, 20XX and 20XY" in a cell
  1. Use the fields in Engagement Link to insert
    December 31, 20XX
     as the date.
  2. In a different cell, use Engagement Link to insert
    20XY
     as the date.
  3. Copy the Engagement Manager formula from the Excel formula bar for the
    20XY
     date.
  4. In the cell from step 1, place your cursor in the formula bar after the equal sign and before anything else.
  5. Enter
    "Period ending "&
    . Include the quotes and spaces.
  6. Place your cursor after the Engagement Manager formula, and enter
    &" and "
    . You must include the quotes and spaces.
  7. Paste the formula you copied for the 20XY date.
  8. Use Enter to insert the combined text and formulas.
If you completed the previous steps correctly, the formula should read as follows, and the workpaper should display the correct information.
="Period ending "&AfText("BP<Current Period Date'Description><Text'CP'C'mmmm dd, yyyy'>")&" and "&AfText("BP<Current Period Date'Description><Text'CP'1P'yyyy'>")

This article applies to:

  • Product: Engagement Manager
  • Subject: Documents, Workpapers
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close