Account Tree Reports

This section describes the two methods for creating account tree reports in YSL.

The original method, Account Tree 1st Edition, specifies the use of the Tree and TreeFunction functions.

The Account Tree 2nd Edition, available in YSL Classic 2.8 and later, is based on the familiar YSL financial functions, and offers an alternative and perhaps a simpler method for creating account tree reports.

Advantages of the Account Tree 2nd Edition method:

c	Financial reports are built using the familiar cBal functions: cBalMTD, cBalMTD, cBalYTD, etc.

c

Account book types are supported across the row. That is, because your financials are built from the cBalMTD type functions, you can have two different book types (cash and accrual) in adjacent cells in your worksheet. This cannot be done with the Account Tree 1st Edition method, where all financial cells default to All Books.

Note the following when planning a YSL report that uses the Account Tree 2nd Edition method.

The following illustration comes from the YSL_AcctTree_AT2Demo.xls example YSL report that ships with Yardi Voyager and Yardi Enterprise.

1 The sAcctTree function is placed in Column A, and, when the YSL report is generated, expands vertically to display accounts based on the selected account tree.

2 The sAccountName (account name) and sAccountNumber (account number) reflect the name and number defined in the selected account tree, not your chart of accounts. It is possible that the account names and numbers in your account tree and those in your chart of accounts are the same, but this is not necessarily so.

3 Users who are familiar with building financial reports with the cBalMTD type functions might find the Account Tree 2nd Edition method easier to learn.

The following table shows the equivalent functions between the Account Tree 1st and 2nd Edition methods.

1st Edition Tree Function	2nd Edition Tree Equivalent
Acct	sAcctNumber
Acct Desc	sAcctName
Actual PTD	cBalMTD
Budget PTD	cBudMTD
Actual YTD	cBalCurYr
Budget YTD	No equivalent
Actual Cur	cBalYTD
Budget Cur	cBudYTD