Creating a copy of a budget is easy using the Copy Plan Wizard in Microsoft Forecaster. Pretty much every client I have needs more than one version of their budget. They will have a conservative version, an aggressive version, a realistic version and about fifty million other versions. With Microsoft Forecaster, creating these copies is pretty easy using the Copy Plan Wizard. The Copy Plan Wizard is located in Forecaster under Tools, Wizards and then Copy Plan Wizard. This wizard will let you copy balances, memos, HR details, revenue details, capital details, line item details, HR setup, exchange rates, input set overrides and more from one budghet scenario to another budget scenario. It is an awesome feature and comes in really handy when getting ready for a new budget or forecast.
There are three main tasks to complete before starting the Copy Plan Wizard:
- Create the new PERIODS for the new scenario.
- Create the new COLUMN SET to be used for this new INPUT SET.
- Create the new INPUT SET ID.
If possible, copy the existing Column Set and Input Set to create the new versions.
Launch the Copy Plan Wizard from Tools>Wizards.
The first screen of the wizard allows you to select the INPUT SET from which you are copying data and the INPUT SET to which you are copying. You may also specify the SEGMENTS and PERIODS – whether or not you are copying all of the SEGMENT ID’s and all of the PERIODS involved or just specific SEGMENT ID’s and PERIODS.
The second screen of the wizard allows you to select different pieces that you wish to copy including account balances, memos, revenue details, HR details, Line Item Details, Capital Details, HR Setup, Overrides and Exchange Rates.
The next and last screen of Forecaster’s Copy Plan Wizard is really just summary of the selections made of the previous screens. After clickng FINISH, the Copy Plan Wizard runs pretty fast and the new scenario is then ready for input.
For questions about this post, email Noah.Moseley@MSXGroup.com
Noah is available for assistance with new implementations of Microsoft Forecaster or with questions on existing implementations of Microsoft Forecaster.