Workpapers
Search
Search Cloud Audit Suite Support Help and Support.

This article applies to:

  • Product: Cloud Audit Suite
  • Subject: Documents,Workpapers

Add special formatting for engagement links in Microsoft Excel

With AdvanceFlow 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 AdvanceFlow are available in Engagement Link.
To access Engagement Link:
  1. In AdvanceFlow, open the spreadsheet you want to edit.
  2. After the spreadsheet opens in Microsoft Excel, select the
    AdvanceFlow
     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 AdvanceFlow formula for client name. The formula should look similar to this:
    =PROPER(AfText("CP<Client Name'Description><Text>"))
  • In AdvanceFlow, add an account in the
    Trial Balance
     tab. Enter the client name using the proper capitalization for the
    Description
    . You can then insert the AdvanceFlow account description variable instead of the client name into the Excel spreadsheet.
  • In AdvanceFlow, 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 AdvanceFlow 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 AdvanceFlow 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.
    important
    Remember to include spaces inside the quotes for 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 AdvanceFlow 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 "&
    . You must include the quotes and spaces.
  6. Place your cursor after the AdvanceFlow 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'>")