Drilling Down to Trial Balance Accounts in a TB Link

You can drill down to the accounts that make up the dollar amounts calculated in a TB link formula in Microsoft®Excel®and Microsoft®Word workpapers. Use this process if you need to review the formula to ensure the correct accounts were summed together.

To drill down to the accounts from a linked formula, do the following:

  1. Open the Excel® or Word workpaper you want to use.

    1. Click the engagement on the Engagement List page.

      Note: See Using the Engagement List Page for information about using the pagination and search features to find an engagement in the list.

    2. Locate the workpaper on the Engagement View page.

      Tip: You might need to expand the node or folder that holds the item you need.

  2. Do one of the following:
    • In Excel®, click the cell containing the linked formula.
    • In Word, highlight the linked formula.
  3. Click Drill Down TB Link on the CCH iFirm Engagement ribbon. The TB Link Drill Down window displays.
    • The top section of the window displays the TB Link formula parameters.
    • The bottom section of the window displays the accounts used in the formula. If the TB link is made up of more than one formula, this section shows the subtotal for each formula and the total of the amounts.

    Important: If you have CCH iFirm Engagement installed on your computer, you may also see an Engagement ribbon. Be sure to click the button on the CCH iFirm Engagement ribbon.

    Note: The Total amount displays values from the TB Link formulas only. Any operators you entered manually when creating the formula are not calculated.