The budget factory is a bulk editor that will save you time. You can use it in a variety of ways to create new budgets, update existing budgets or simply copy budgets for multiple business units in one process.
The basic flow is to choose source data such as actuals or existing budgets, then copy it to a destination budget with optional adjustments along the way.
Warning: ⚠️If you are replacing data, Formulas that exist in your Budget will be overwritten by the Budget Factory with values
Navigate to Budgets & Cashflow -> Budget Tools -> Budget Factory.
Select your Organisation from the Selected Organisation dropdown.
Select a Budget Type, either Profit & Loss or Balance Sheet, and click GET STARTED.
Choose Create an organisation budget for a simple overall organisation budget.
Or Create a business unit budget, then select the Business unit Category and Business units you wish to budget on from the drop down. Use Bulk Actions to see options, such as Select All.
Then click NEXT STEP.
Set the Source and Destination properties then click NEXT STEP.
Source: this is the source data you want to copy or use as the base for further calculations, you may select a Budget, Scenario or Actuals.
Destination: this is the destination budget and years where you want to copy the source data to, either an existing Budget or Scenario, or create new.
Apply any required changes to the Destination account totals and click NEXT STEP.
This is where you can optionally apply broad changes to the source information. The destination totals are recorded as a percentage change on the prior year. You can edit the value or the percentage change.
Cost of Sales can optionally be calculated as a Percentage of Income amount instead of the default percentage change on prior year. This allows you to set Cost of Sales as a percentage of the Total Income budget and also set a Net Profit target which will in turn increase Income and the related Cost of Sales budgets to meet this target.
The summary page provides an opportunity to review the source data and the destination budget years and business units. It also identifies if any of the destination years already have budget data that you will overwrite with these new budget values.
Review the Destination Years and confirm happy for the changes to be applied then click SAVE BUDGET.
