Columns are a great tool to help you build your view of a financial statement. You can use the Columns menu to specify which columns display in a financial statement. The table below describes the defined columns that are available. Coming soon is the ability to customize columns.
Create a richer view by including or excluding budgets, and financial data from the previous or prior pervious periods, or by including periods. Coming soon is the ability to customize columns.
For example, in a Profit and Loss statement, you might want to view the current financial performance only, then add more columns to view more information and make comparisons, as illustrated in the following images. More detailed examples of how to add and remove columns to create different views of a Profit and Loss statement are outlined below.
After you set up the columns the way you want them, you can:
Change the period to view the information against a different timeframe, for example, Financial Quarters.
Save your new view as a favorite.
Click the Reset button to revert back to the default view.
Defined column options
Financial | Budgets | Displays the budget values [DM1] [DH2] for the current period, for comparison purposes. The budget might come from the Budgets and Forecasts or Designer modules. |
Previous | Displays the results from the previous period. /Info To set the date range that is used in the Previous column, see Apply a custom period. |
Prior Previous | Displays the results from two periods ago. |
Variances | Off | Does not display any variance columns. |
Together | Displays the variance columns together, to the right side of the grid. |
With each column[DM3] | Displays each the variance column adjacent to the comparative column. |
Percentages | % Contribution | Available in Profit and Loss statements only - Displays the percentage contribution for each item relative to the category to which it belongs. For example, Wages 65% indicates that the wages value represents 65% of all expenses. |
% Revenue | Available in Profit and Loss statements only - Displays each item as a percentage of revenue. For example, Wages 35% indicates that the wages expense is 35% of revenue. This option is particularly useful when looking at items such as operating expenses, to understand what percentage of revenue they represent.[DM4] [DH5] Note that this calculation excludes the category 'Other revenue'.[DM6] [DH7] [DM8] |
Periods | Off[DM9] | Displays only the date range specified. |
Latest | Displays the latest period as well as the full date range specified. |
All[DM10] [DH11] | Displays all periods within the date range. |
Example[DM1] [DM2] : Compare the current and budgeted performance [DM3] [DH4] [DM5]
Suppose you are viewing a standard Profit and Loss statement and you want to compare the current performance with the budgeted performance for the most recent month and year to date.
Click the Columns menu, then:
· Clear the Previous checkbox.
· Select the (Variances) With each column option.
Select the (Periods) Latest option.
Click anywhere outside the Columns menu to update the grid and view your changes. The Previous columns are gone, so you can clearly compare the Current and Budget values.
Suppose you are viewing a standard Profit and Loss statement but rather than an annual totals, you want to view the values on a month-by-month basis.
Click the Columns menu and select the Include all periods checkbox.
Click anywhere outside the Columns menu to update the grid and view your changes. You now have a total column and a column for every month from the beginning of the financial year through to your current financial period.