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.
| Info |
|---|
The columns menu is not available in the Trial Balance. |
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
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 values for the current period, for comparison purposes. The budget might come from the Budgets and Forecasts module or the Designer modulesmodule. | |||
Previous | Displays the results from the previous period.
| ||||
Prior Previous | Displays the results from two periods ago. | ||||
Variances | Off | Does not display Removes 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
| ||||
Periods | Off[DM9] | Displays only the date range specified. | |||
Latest | Displays the latest period as well as the full date range specified. | ||||
Displays all periods within the date range. |
Example 1: 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 and ensure the Budgets checkbox is selected.
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.
Example 2: View your monthly performance
Suppose you are viewing a standard Profit and Loss statement but rather than an annual totals, you want to view the current values on a month-by-month basis.
Click the Columns menu and select the Include all periods checkbox, then:
Clear the Previous and Budgets checkboxes.
Select the (Variances) Off option.
Select the (Periods) All option.
Click anywhere outside the Columns menu to update the grid and view your changes. You now The Previous and Budget columns are gone, so you can clearly focus on the Current value, for which you have a total column and a column for every month from the beginning of the financial year through to your current financial period.
