Configure Options

Sort by Col

From the drop-down list, select the sorting order on the initial generation of the report. Click the arrow to sort in either ascending or descending order.

Planning

From the drop-down list, select the planning balance on which the Financial statement areas worksheet is to be based.

• <Custom Balance>: Select the custom balance to use as defined in Tools | Options | Custom Balances. This option will only display if at least one custom balance has been defined.
• Prior Year Budget: Select to use the prior year budget balance as defined in the trial balance.
• Current Year Budget: Select to use the current year budget balance as defined in the trial balance.
• Prior Year: Select to use the prior year final balance.
• Current Year: Select to use the current year preliminary import.

Round To

From the drop-down list, select the rounding to use. Select 1's (the default) to round to the nearest dollar, 1000's to round to thousands, or 1,000,000's to round to millions.

The rounding selected from this drop-down list is used in the Financial statement areas worksheet, the Risk Report, the Partner and Manager Summary, and all work programs.

Note: Rounding difference may occur as the apply rounding relations feature is not set.

Include zero amount

Use the check box to include line items with zero amounts in both planning and current balances in the worksheet.

Grouping:

From the drop-down list, select the mapping / grouping used in the engagement file. The default is by Leadsheet.

Include From

From the drop-down list, select the starting point of the grouping number.

Include To:

From the drop-down list, select the ending point of the grouping number.

Mask Level

From the drop down list, select the grouping mask level to generate. For example, say a grouping uses three levels (e.g. XXX.XXX.XXX), where the first level represents the financial statement type (Balance Sheet), the second level represents the financial statement line items (Cash and Cash equivalents), and the third represents account details (Bank - foreign). You would likely set the mask level at 2. If you are unsure of your full mapping mask, double click the cell to open a dialog that displays the mask.

Include Parent Numbers

Select this check box if you want to display the parent numbers of the group numbers specified by Mask Level. For example, suppose that Mask Level is 3, which means that group 140.101.1 is displayed. If Include Parent Numbers is selected, parent groups 140 and 140.101 are also displayed.