Creating and Inserting Trial Balance Links

The Insert TB Link option allows you to create links to the trial balance from a Microsoft® Excel® or Microsoft® Word workpaper. This feature allows you to view information from the trial balance without having to open it. If the trial balance is updated, the TB link amounts will update when the workpaper is refreshed.

A TB link can include a single TB link formula or it can include several formulas. Once you have created a TB link, you can save it for future use in the same engagement, if needed.

Note: If needed, you can drill down to the accounts that make up the calculated amount in a TB link. See Drilling Down to Trial Balance Accounts in a TB Link for more information.

Create and Insert Simple TB Links

  1. ClosedOpen 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. Place the cursor where you want to insert the TB link.
  3. Click Insert TB Link on the CCH iFirm Engagement ribbon to open the Insert TB Link window.
  4. 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.

    Tip: If needed, the Insert TB Link window can be resized by dragging the corner of the window.

  5. Build a formula using the Closedlisted parameters.
  6. Select the Round check box if you want to round amounts. Then, in the text box to the right, select the number of places after the decimal you want to round to.
  7. Specify the Closedsign option you want to use.
    • Actual. Amounts are as they appear in the trial balance.
    • Reverse sign. Amounts use the opposite sign from the trial balance.
    • Absolute value. Amounts appear as absolute values.
  8. If you are working in a Word workpaper, select the negative style, numeric style, and zero style to use.
  9. Click Insert. The formula displays in the TB link formula text box.

    Note: See Analyzing a TB Link Formula for detailed information about the components that make up the TB link.

  10. Click Paste to insert the TB link into the workpaper.
  11. Do any of the following if needed:
    •  ClosedSave this TB link formula for future use in the engagement.
      1. Click Save.
      2. Enter a name and description for the formula.
      3. Click OK.
    • Paste the same TB link to another cell in the workpaper. Click the cell on the workpaper and select Paste on the Insert TB Link window.
    • Paste a different TB link to another cell in the workpaper. Click the cell on the workpaper and click Clear on the Insert TB Link window. Then, repeat steps 4 through 10 above as needed to add a different TB link.
    • Create a complex TB link formula by adding another TB link to this TB link formula. See Advanced TB Link Features below for details.
  12. Click Close.

Advanced TB Link Features

  1. Create the initial TB link as explained above, but do not paste it into the workpaper.
  2. Select appropriate parameters for the additional formula you want to include in the TB link.
  3. Click Insert again to add the new TB link formula after the initial formula in the text box. A plus (+) sign appears between the two formulas. The results of each formula are summed to calculate the result for the TB link.
    • In Excel®, the plus sign (+) at the end of a line in a TB link formula can be changed to a minus sign (-), a division sign (/), or a multiplication sign (*). Excel® calculates the operation. For example, changing the plus sign (+) to /2 will divide the formula by 2.
    • In Word, the only operator is the plus sign (+). To subtract two values, you can use Word formulas in a Word table.
  4. Repeat the steps above as needed until you've added all the parts of the complex formula.
  5. Click Paste to add the TB link to the workpaper.

Notes:

  • The Result field displays the total amount calculated by the formula. This amount only includes the values from the TB Links. Other operators you enter manually are not calculated in the Result field, but are calculated in the Excel® cell.

  • If needed, you can drill down on a cell with a TB link to see the accounts.

  • ClosedInsert a saved TB link formula into a TB link.
    1. In the Insert TB Link window, click Open.
    2. In the Saved formulas section, select the saved formula you want to insert.
    3. Click OK.
    4. Complete the formula as needed and paste it into the workpaper.

Freezing Engagement Links

If you freeze Engagement links within an Excel® or Word workpaper, changes to the trial balance and/or name and date properties are not carried to the document. Links are not automatically refreshed before they are frozen, so use the Refresh function prior to freezing the links.

Note: Be sure to open the workpaper at least once before you freeze links. This ensures that the links are updated.

When you freeze Engagement links within a workpaper, you cannot insert new links or use the following functions:

  • Name Functions
  • Date Functions
  • Refresh
  • Insert TB Link

You cannot freeze engagement links in a locked workpaper. The workpaper must be unlocked before links can be frozen.

When a workpaper is rolled forward, frozen engagement links remain frozen. If you copy an engagement that includes workpapers with frozen links, the links remain frozen.

You must be the Active User of a workpaper to freeze links and you must be granted the permission to freeze links.

To freeze Engagement links from within the workpaper, do the following:

  1. Navigate to the Engagement View page.
  2. Click the name of the workpaper whose links you want to freeze.
  3. Make sure the links have been updated to reflect the current trial balance and name/date information.
  4. On the CCH iFirm Engagement ribbon, select Freeze TB Links.
  5. For Excel workpapers, you will be notified that the workpaper will be automatically saved. Click Yes on the message to freeze the links.

Note: If the Excel workpaper has been signed off by one or more reviewers, the modified after reviewed status icon will display for the workpaper in the Engagement View. At least one reviewer must sign off the workpaper again to remove the status icon.

A frozen links icon displays in the Status column of the Engagement View so that all users are informed the links in the workpaper are frozen.

Unfreezing Engagement Links

You can unfreeze Engagement links that were previously frozen so they can be updated or changed. When you unfreeze links within an open workpaper, the links are automatically updated with any changes to the trial balance or the name and date functions.

You must be the Active User of a workpaper to unfreeze links and you must be granted the functional permission to unfreeze Engagement links.

To unfreeze Engagement links from within the workpaper do the following:

  1. Navigate to the Engagement View page.
  2. Click the name of the workpaper whose links you want to unfreeze.
  3. On the CCH iFirm Engagement ribbon, select Unfreeze TB Links.
  4. For Excel workpapers, you will be notified that the workpaper will be automatically saved. Click Yes on the message to unfreeze the links.

Note: If the Excel workpaper has been signed off by one or more reviewers, the modified after reviewed status icon will display for the workpaper in the Engagement View page. At least one reviewer must sign off the workpaper again to remove the status icon.

In the Engagement View page, the frozen links icon no longer displays in the Status column.