Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Create a budget workbook

  • Create and publish filtered workbooks

    After you create and complete a budget workbookor forecast, you can clone (copy) that workbook and use it as a foundation for a new workbook. You can then update the budget values in the new workbook and publish the workbook into a new stream or existing stream (with the same structure). 

    The new workbook has the same contents as the original budget or forecast workbook, such as the structure, tabs, drivers, assumptions, formulas, and so on. The budget owner and administrators also remain the same. However, you do have the option to use a different period.

    Tip

    If you want to have a rolling budget or forecast, instead of cloning a workbook and ending up with two workbooks, you can edit the date range for the current budget or forecast instead.

    This option is

    See Roll a budget forward or Edit the budget workbook setup

    1. Click the Budget (or Forecast) button > Copy workbook.

    2. Enter a name for the new workbook.  

    3. Select one of these options:

      • Clone budget (or forecast): This option makes an exact copy of the workbook (including any comments) in the same period. It's useful if you want to run different scenarios, such as a best or worst-case budget, alongside your main budget. You can then publish

    your cloned budget as a new stream.

    Points to note about a cloned workbook:

    • The budget owner and administrators remain the same in the cloned workbook and they can see the cloned workbook in their menu straight away.

    • The workflow remains the same in the cloned workbook. However, the users that are assigned to the workflow tasks will not see the cloned workbook in their menu straight away. They need to be reassigned to a task or assigned a new task in order to trigger the access to the cloned workbook.
      For example, if Bill Branchmanager has a task assigned to him in the original workbook, it will also be assigned to him in the clone but he will not be able to access the workbook until he is reassigned to that task in the clone.

    Click the New button, click Make a copy, then enter a name for the new workbook and click Clone.

    Image Removed

    Related pages

      • to a different stream and compare the budget scenarios in Financial Statements. 

      • Copy budget (or forecast) forward:This option copies the contents of the workbook forward into a new budget period. it’s suitable when you want to roll your budget into the next financial year. In the Offset box, enter the applicable number of periods that you would like to move the budget forward by. For example, enter 12 for a 12-month budget or 1 for a 1-year budget. If your selected offset is out of range, zeros will be used for outstanding periods.

    1. (Optional) Clear the Clone comments checkbox if you don’t want to copy the workbook comments across into the new workbook.

    2. (IF APPLICABLE) Change the budget filter, if required. This option only displays if a budget filter has been applied in the main budget setup. Selecting a different filter (dimension and/or entity) allows you to create the same budget for a different purpose, such as another country, branch, business unit, or project. For example, if you create a budget for Australia, you can copy that budget for use in the UK.

      Image Added
    3. Click Copy. The process might take a few minutes to complete if you are copying a large budget or forecast.