After you create and complete a budget workbookor forecast, you can clone (copy) that workbook and use it as a foundation for a new budget 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 budget 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 can do have the option to copy the budget workbook into the same or different budget use a different period.
| Infotip |
|---|
If you are copying a large budget, the process might take a few minutes to complete. |
Copy a budget (into the same period)
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. See Roll a budget forward or Edit the budget workbook setup. |
Click the Budget (or Forecast) button > Copy workbook.
Enter a name for the new workbook.
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 to a different stream and compare the budget scenarios in Financial Statements.
Click the New button > Make a copy.
Enter a name for the new workbook.
Copy budget
Click Copy.
Copy a budget forward (into a new period)
(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.
Click the New button > Make a copy.
Enter a name for the new workbook.
Select Copy budget forward.
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.
Click Copy.
On this page
| Table of Contents | ||||
|---|---|---|---|---|
|
If your selected offset is out of range, zeros will be used for outstanding periods.
(Optional) Clear the Clone comments checkbox if you don’t want to copy the workbook comments across into the new workbook.
(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.
Click Copy. The process might take a few minutes to complete if you are copying a large budget or forecast.
Related pages
Create a budget workbook
Publish a budget workbookor forecast