The options selected in the Current and Budgets menus determine the datasets that are used to populate Current and Budget columns in the grid.
The Current column always displays in the grid but you can add or remove the Budget column via the Columns menu.
Change the current dataset
By default, the Current column displays the default latest-period-actuals but you can change this. For example, if you want to view you might want to view one budget stream here and another in the Budget column, so you can apply different date ranges (periods).
Click Current, then select the checkbox of the dataset you want to view. The statement grid updates automatically.
Proceed to change the period for the Current column, if required.
Change the budget dataset
By default, the Budget column in the statement grid displays the first budget/forecast that appears in your list of available budgets (see Manage budgets below). You can display an alternate budget/forecast in the statement grid. 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/forecast that is currently selected and select the checkbox of the budget/forecast you want to view. The statement grid updates automatically.
View multiple budgets
You can view multiple budgets/forecasts 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/forecasts you want to view. The statement grid updates automatically, and new columns are added for the additional budgets/forecasts for the same period (date range).
Change the period that applies to the Current or Budget column
If you want to compare budgets under different periods, you can change the dataset that displays in the Current column to be a budget, then apply a custom period to that column.
For example, if you are reviewing your budget for the next year, you can set your current period to be that budget, then set comparative periods to be current year budget, and current year actuals, to understand variances.
Manage budgets
A budget is made up of data from more than one dataset (stream), such as a Profit and Loss statement, Balance Sheet and statistical dataset. You can select a particular set of datasets to create one budget, then select another set of datasets for another budget.
Often you will have multiple budgets, either different year’s budgets, or different types of budgets (expected, worst-case, stretch and so on), as well as forecasts. You can manage these budgets via the Budget menu.
Click Budgets > Manage Budgets.
Select a budget from the list on the left (which corresponds to list in the Budgets menu), then select the datasets you want to apply to that budget.
Repeat the above step for the other budgets in the list.
Optional: Add another budget to the list: Click the + Add button, then select the datasets you want to apply to that budget/forecast.
Optional: Remove a budget/forecast from the list: Select the budget, then click the - Remove button.
Click Save.
Related pages