Analyzing a TB Link Formula

To view a TB link formula in a workpaper, do one of the following:

  • In Microsoft® Excel®, click the cell containing the TB link. The formula displays in the formula bar. You can also click Drill Down TB Link on the Axcess Engagement ribbon.
  • In Microsoft®Word, select the linked formula in the document, and then click Toggle Field Codes or View Field Codes. You can also press Alt + F9. A Word formula has several formatting parameters, but within the formula you will see the same formula that would be used in Excel®.

In both Excel® and Word, you can also view a TB link by selecting Drill Down TB Link on the Axcess Engagement ribbon. In Excel®, you must first click the cell containing the TB link, and in Word you must highlight the linked formula.

The TB link formula is based on the following:

XTBLink("Trial Balance","ADJ[5]","1000","FS","1").

  • Trial Balance displays for non-consolidated engagements. For consolidated engagements, the engagement name will show for the consolidated entity and the subsidiary short name will show for each subsidiary entity..
  • ADJ[5] represents the balance type. ADJ is a short description for Adjusting Journal Entry and [5] is the balance type period ID assigned by Engagement.
  • 1000 is the Account/Index # based on the Type selected in the formula. The value will be the group index, group|subgroup index, account type abbreviation, account class abbreviation, or the account number.
  • FS represents the Financial Statement account grouping ID. If the Tax account group is used for the formula, Tax is the account grouping ID.
  • 1 represents the type of trial balance link that is being created. It indicates the level of detail needed.

    • Options include:

    • 3 = Account Detail
    • 2 = Account Group|SubGroup
    • 1 = Account Group
    • -1 = Account Class
    • -2 = Account Type