Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Add or remove columns

  • Change the period

    The options selected in the Current and Budgets menus determine the datasets that are used to populate Current and Budget columns in the grid.

    Info

    The Current column always displays in the grid but you can add or remove the Budget column via the Columns menu.

    Image Removed

    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.

    Image Removed

    Proceed to change the period for the Current column, if required.

    Change the budget dataset

    By default, the Budget column Current column always displays 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 (you cannot remove it) but you can change the data that displays in that column and the period that applies to that data.

    Image Added

    Click the Current menu and select the checkbox of the budget/forecast dataset 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).

    Image RemovedChange

    Then, if required, 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.

    1. Click Budgets > Manage Budgets.

    2. 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.

    3. Repeat the above step for the other budgets in the list.

    4. Optional: Add another budget to the list: Click the + Add button, then select the datasets you want to apply to that budget/forecast.

    5. Optional: Remove a budget/forecast from the list: Select the budget, then click the - Remove button.

    6. Click Save.

    Image Removed

    Related pages

    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. See Change the budget data for an example.

    Tip

    After you set up the Current column the way you like it, save your view as a favorite, so you do not have to repeat the steps next time you view the financial statement.