Take a tour of Financial Statements

The grid is where you view and analyze the information from the selected financial statement.

Rows

Color-coding helps you differentiate the information that's displayed:

Grey rows: These rows are the categories (groups of accounts), like Revenue and Expenses in a Profit and Loss or Assets and Liabilities in a Balance Sheet.
- You can expand these rows to view the underlying accounts and drill down into individual transactions.
- By default, the General Ledger accounts within the groups are displayed in ascending code order. You can switch between descending and ascending sort order as required. When the groups are expanded, right-click any row within a group and click Sort Ascending or Sort Descending. Even though you change the sort order for a particular group, for consistency purposes, the accounts in all groups are sorted in the same way.
- If you have a Suspense row at the bottom of the statement, it means there are one or more new accounts that haven't yet been mapped to the applicable category in the statement.
White rows: These rows are the calculations, for example, Total Revenue. These rows can be a combination of different groups or other calculations, such as ratios, to create an end result. You can hover over the fx symbol to view the formula used in the calculation. These rows aren't expandable nor do they have transactions.

Columns

First there's the column showing the name of the category, account or calculation, as applicable. Then you typically have columns showing data for the Current period, Previous period and Budget, followed by variance columns.

The panel on the left has the following elements:

Dimensions: View the list of dimensions in your underlying database. A dimension is a level in your statement and an entity is a value within a dimension. For example, a dimension is Country and the entities are Australia, the UK and the USA. Users who have permission to manage financial statements can create custom dimensions to add a level of detail that was not in the original dataset. Use these dimensions to add levels to the statement grid and filter the data to focus on specific information. If you click a dimension, you move into the Analytics grid, where you can drill deeper into your data, all the way down into the transaction level. To remove this list and get a better view of the statement, click the Hide dimensions button below the grid)
Focus, Reset, and Summary buttons: Use the buttons above the dimension list to focus on specific entities within a dimension, reset the grid to the default view, or return to the summary (high-level) view of the data.
Levels: Drag dimensions into the Levels box to add them as levels in the grid and create a nested view of the information and view the information at a more granular level. For example, add the Country dimension as a level to view the contribution of each country to the overall performance.
Column groups: Use the Column groups feature with selected dimensions to transform the grid into a matrix format and view the entities side-by-side. For example, select the Country dimension, then select three countries to view financial information for those countries in separate columns in the grid, alongside the combined information in the Total column.

The toolbar on the top has several menus that you can use to switch between your financial statements and customize your view of each one.

It also has the following action buttons:

Charts: Visualize the data in the grid in a chart format.
Export: Export the data into Microsoft Excel or as a PDF.
Settings: Access the settings for advanced features, such as the currency settings and groups.

Take a tour of Financial Statements

Financial Statements homepage

Financial Statements module