Budget vs Rolling FC
We have recently completed our annual FP&A planning cycle and now have a FY21 budget (Jul20 to Jun21) locked down. I'm creating our new FP&A model which will be a Rolling Forecast & also have the FY21 Budget values static to compare against
How do other people complete this task? I don't want to use Versions and we will have more than 1 live Version running at any time & will need to use the Formula scope 'All Versions except Actual'
The only way I can see is to create Budget modules and import the data from the Budget model. Then I can create modules which calculate the difference between the 2 values, Rolling Forecast v Plan. So basically creating an additional 2 Modules for every module we wish to bring in from the Budget model. 1 for the Budget values and 1 for the variance
Are there any other methodologies to complete this task? Seems very time consuming