Page Comparison

You Rather than focus on the high-level overview of your financial statements, you can filter the summary financial information in the statement grid to information and analyze the performance of specific entities in a dimension. You can display the filtered information in two ways:

• Basic - The filtered information displays in the statement grid. The grid looks the same as usual but the values now relate to the specified entity or group of entities. This is useful when you want to focus on the performance of one entity or a particular group of entities.

• Matrix - The statement grid converts into a matrix format. The combined financial information for specified entities displays in the Total column and beside that are columns displaying the financial information for each of the specified entities. This method is useful when you want to compare the performance of entities side-by-side, against their combined performance.

For example, suppose you want to analyze your organization’s performance at the branch level.

1. Click the Branch dimension. The statement grid converts into a data grid, where you can see a summary performance of each branch.

   Image Removed

2. In the data grid, select the branch(es) you want to focus on by clicking the number in the beginning of the applicable row(s).

3. Select one of these display methods:

   • Basic: Click the Summary button. The data grid converts back into the financial statements grid, where you can see the Profit and Loss statement for the selected branch or the combined Profit and Loss statement, if you selected more than one branch.

   • Matrix: Click the Matrix button, then click the Summary button. The data grid converts back into the financial statements grid, where you can see the Profit and Loss statement for the branch(es) to the right of the combined Profit and Loss statement.

at a lower level of detail. You use dimensions (and entities) to filter the financial statement. After you filter by one dimension, you can filter by another dimension. You can repeat this action to filter by multiple dimensions and view your financial statements at a more detailed level.

Apply a filter

In the financial statement, click the dimension you want to use as a filter, such as Country, Branch, Department and so on.

Image Added

When you click a dimension, you move into the Analytics module. You will notice some of the menu items change and the Summary button turns grey. The Analytics grid displays a summary performance of each entity in the selected dimension.

Image Added

From here, you have two options:

• Use the range of Analytics tools to drill deeper into your data, all the way down to the transaction level. See the Analytics pages for detailed information.

• Select one or more entities in the grid, then click the Summary button to return to the Financial Statements module and view the filtered statement. The filter that you apply displays above the grid, and the number of selected entities displays on the corresponding dimension button.

  Image Added

  Expand the sections below for more examples.

Expand
title Example 1 : - Filter a financial statement to view the performance of one branch
In the financial statement, click the Branch dimension, then in the Analytics grid, select the branch (	B008) and click the Summary button. The statement grid now displays the Profit and Loss for branch B008.

Expand
title Example 2 : - Filter a financial statement to view the performance of a selection of branches (basic view).
Info
multiple branches
In the financial statement, click the Branch dimension, then in the Analytics grid, select the branches (B002, B003 and B004) and click the Summary button. The statement grid now displays the combined Profit and Loss statement for the selected branches. The net profit value is the sum of the net profits of those branches.

Expand
title Example 3 : - Filter a financial statement to view and compare the performance of a selection of branches (matrix view).
Image Removed Tip If you select multiple entities to use with the matrix tool, you might be presented with a lot of data in the financial statements grid. To reduce the amount of data and get a clearer view of the key information, remove some columns.

a multiple cost centres in a branch

Suppose you have filtered the Profit and Loss statement by the Country (dimension) > Australia (entity). Now you want to take your analysis a step further and see how two specific cost centres in Australia are performing. In the filtered financial statement, click the Cost Centre dimension. Image Added In the Analytics grid, select the cost centres (C001 and C004) and click the Summary button. The statement grid now displays the combined Profit and Loss statement for the selected cost centres in Australia. The net profit value is the sum of the net profits of those cost centres. Image Added

Remove a filter

To remove a filter and return to the high-level summary financial information, click the X on the dimension button(s).

To completely reset the data, click the Reset button.