Forecast v Actual: Version or Import
Wondering what everyone does when creating Forecast (Actual + Plan) v Plan modules for P&L use cases.
More specifically I am asking whether people
1) Take a copy & create a new version of the Plan P&L at the time of finalisation of the Plan P&L, keep the Swtichover as July (For June Financial Year End periods) & then use the Variance Version to compare Forecast v Plan as the year progresses
2) Create Plan & Variance modules within your current version & import the Plan data into those modules as static values (no formula)
Ideally Option 1 is preferred but we are updating & improving our model frequently & hence the Plan values will change if any calculation is adjusted & hence we have used method 2 for the current financial year
Does anyone else have the same issue & if so what are your solutions?