Analyzing Financial Statements with the Review Booklet

The review booklet comes delivered with five business pages. These business pages are organized by type of financial statement.

Business Pages

Each business page has one or more sub-pages with aggregated and detailed data. The consolidated balance sheet is a financial statement that shows assets and liabilities and equity at the end of the fiscal period. The Consolidated Balance Sheet main tab contains the following three detail tabs where you can review the data:

1. Overview: a basic overview of assets, liabilities, and equity
2. Assets: a detailed look at current and non-current assets
3. Liability & Equity: a detailed look at equity as well as current and non-current liabilities

The following business pages use FS items:

• Consolidated Balance Sheet
• Profit & Loss Statement (Function of Expense)

The following business pages use Reporting Items:

• Profit & Loss (Nature of Expense)
• Cash Flow Statement
• Statement of Changes in Equity

Note

Business pages that use reporting items require Report Rule Variants.

You can adjust the columns and rows in the report to display your data in various ways. You can also select specific column structures that enable you to make comparisons with your data, such as Closing Period vs. Previous Period.

In the following image, you can use the dropdown next to Rows to select the most popular dimensions.

You can also add any other dimension in group reporting into the report. For example, you can right-click on FS item and select other dimensions to include in the output.

The structures in the columns can be changed by using the dropdown next to Columns. You can also right-click Structure and edit the filter.

You can use dimension properties to:

1. Change how members are displayed.
2. Change how members are sorted.
3. Change hierarchy expansion level and position of nodes.

You can access properties via the context menu or from the layout.

Note

There are similar properties for measures and structures.

Dimension Properties

Global filters apply to all business pages in the app and underlying data providers. You define them in the filter bar. Use Adapt Filters to add to the global filters.

Note

Consolidation Unit must be added to the global filters and restricted to a hierarchy that is different than the default.

Page filters only apply to a specific business page and underlying data provider. Some variables for page filters are already derived based on your selection of global filters. You can display them in the side panel. In addition, you can apply page filters for specific dimensions in the report.

When the page filters are displayed, they show the default dimension filters. In the All view, you can Add additional dimensions to the filter or choose Clear to remove previously added dimensions.

To select a hierarchy node, you can switch the view to Proposed. In the proposal, hierarchy nodes can be selected and applied.

Note

The filter for the Consolidated Balance Sheet - Overview page is different than the other pages because the filter has an Asset view and Liabilities & Equity view.

You can also filter a dimension via the context menu. For example, right-click FS Item → Filter → Edit. You can then select a hierarchy node and choose OK.

You can access the report definition by going to the layout panel. The layout panel has the following components:

• Builder Pane: Here you can see the information that you've selected under Available Objects. It's displayed in your statement, either as a row or as a column.
• Available Objects: Here you choose which type of measure, structure, and dimension you want to display in your financial statement by selecting or deselecting it.

You can use drag and drop to change the rows and columns. You can use the ...More option to control:

• Zero suppression: hide members if they have zero values.
• Compact display: group dimension members hierarchically.
• Set properties.
• Edit filters.
• Display unbooked members.
• Control totals.
• Control sorting.

Note

Structures are made up of multiple dimensions. For example Closing YTD 2022 includes the period mode, and time dimensions.

You can use the formatting option to:

• Select measures
• Change scaling
• Set the number of decimal places
• Change the sign display
• Set up conditional formatting

Formatting

You can use the context option to display global filter values and jump to hierarchies.

If you need to evaluate the review booklet results in Microsoft Excel, you can download it.

From your review booklet, you can navigate to other areas and apps of group reporting.

This navigation is context-sensitive: The booklet settings (for example, the global filters and page filters) are automatically applied in the group reporting app that you navigate to.

You can jump to the Manage Global Hierarchies app by selecting a hierarchy from the Context Information in the side panel.

You can also transfer the context (selections and filters) to the Display Group Journal Entries app. You do this by right-clicking a data cell in the table and choosing Jump to Display Group Journal Entries.

After you apply filters and select the rows, columns, and dimensions that you want, you can then save the pages as a view. Saved views can then be selected to reload all the pages in the review booklet as you had saved them. Depending on your authorization, you may be able to save a view as Public so that other users can use it as well.

To save a view, choose the dropdown list of views and select Save As. When you save the view, you can also select Set as Default so that it appears by default every time you enter the app.

You can also manage views by selecting Manage from the dropdown list of views. Here, you can view the details of views, rename them, set them as default, and delete them.