The options you select in the Current and Budgets menus determine the datasets that are used to populate Current and Budget columns in the statement grid. You can change the data that displays in these columns, which coupled with the ability to change the period, allows you to determine the exact data that displays in the grid.
The Current column always displays in the statement grid but you can add or remove the Budget column via the Columns menu.
After you set up the Current and Budget columns, save your view as a favorite, so you do not have to repeat the steps next time you view the financial statement.
Change the current dataset
By default, the Current column displays the default latest-period-actuals but you can change this. For example, you might want to view one budget stream here and another in the Budget column. You can then apply different date ranges (periods) to each column.
Click Current, then select the checkbox of the dataset you want to view. Then, if required, change the period for the Current column (see below).
Change the budget dataset
While the word ‘budget’ is used throughout this page, it also includes forecasts.
By default, the Budget column displays the first budget that appears in your list of available budgets* but you can display an alternative. For example, you might want to toggle between your current and stretch budgets, or your budget and forecast.
Click Budgets, then clear the checkbox of the budget that is currently selected and select the checkbox of the budget you want to view. Then, if required, change the period for the Budget column (see below).
*If you have permission to manage financial statements, you can manage the budgets that are available to other users.
Rather than view each budget one-by-one, you can view multiple budgets at the same time. For example, you might want to view your current and stretch budgets, or your budget and forecast, side-by-side.
Click Budgets, then select the checkboxes of the budgets you want to view. New columns are added to the statement grid for the additional budgets, for the same period.
Change the period that applies to the Current or Budget column
If you want to compare budgets for different periods, you can change the dataset that displays in the Current column (see above) to be a budget, then apply a custom period to that column.
See Change the period to learn more about periods get detailed instructions on how to apply a custom period.
Example 1: Your budget is set for the future (next year) but you want to compare your current performance against that budget.
Leave the current dataset (Profit and Loss) and period as it is. Select the budget from the Budgets menu and change the Budget Period to a future period. You might also want to select Periods > All in the Columns menu to get a detailed view.
Example 2: You want to compare budgets for different periods - the forecast you completed for July-December 2022 and the initial budget.
Change the current dataset (see above) to be the forecast and select the budget from the Budgets menu, then apply the following custom periods:
Current Period date range to align with the forecast. In this case it is July-December 2022.
Previous Period to 2021, to compare to actuals of the same month range.
Budget Period to 2022, for comparison.
