Take a tour of Financial Statements
Learn about the key elements of the Financial Statements user interface (UI).
Last updated
Was this helpful?
Learn about the key elements of the Financial Statements user interface (UI).
Last updated
Was this helpful?
In Phocas, when you open a financial database via your homepage, dashboard, or some other means, it opens in the Financial Statements module.
Watch these videos:
Phocas Academy:
PUG Training: (for users who manage the statements)
Financial Statements has the following key elements, as identified by the numbers in the image.
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.
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.
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 , 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.
, 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.
: 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.
: 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 of each one.
: Visualize the data in the grid in a chart format.
: Export the data into Microsoft Excel or as a PDF.