Analyzing a TB Link Formula
To view a TB Link in Excel, click on a cell containing the TB Link. The
formula displays in the formula bar.
In Word, click the Toggle Field Codes or View Field Codes button. A
Word formula has several formatting parameters, but within this
formula you will see the same formula noted in Excel:
TBLink(“TB”,"FINAL[7]","4110","15","1","0")
§
TB represents the name of the trial balance database you
linked from.
§
FINAL[7] represents the trial balance column you linked from.
FINAL shows the Abbreviation you defined in the TB Column
Setup window. [7] is the column ID assigned by Engagement.
§
4110 represents the index assigned to an account class, ratio
class, account group, account sub-group, or the account
number if linked to the Account Detail.
§ 15 represents the Grouping List ID number.
§
1 represents the trial balance tab you linked from or the
account type you linked: ”1" = Group Summary tab, “2" =
Sub-Group Summary tab, and ”3" = Account Detail tab, “-1" =
Account Class, ”-2" = Account Type, “0" = Ratio Class.
§
0 is reserved for future use.
Drill Down to Trial Balance Accounts
To drill down to the accounts that make up the amounts calculated in a
linked formula in an Excel or Word workpaper, do the following:
1. Open the Excel or Word workpaper.
2. Do one of the following:
§
In Excel, click the cell with the linked formula.
§
In Word, select the linked field.
3. Click the Drill Down TB Link button.
4. Click Close.
Page 38
Using Trial Balance Functions