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 CCH iFirm 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 CCH iFirm 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 CCH iFirm 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.
- 3 = Account Detail
- 2 = Account Group|SubGroup
- 1 = Account Group
- -1 = Account Class
- -2 = Account Type
Options include: