Hello,
I am brand new to Anaplan and am building a long range plan that has P&L, BS, CF. Our actual version in AP for the P&L is an import from our accounting software that is actuals + forecast = total FY year. For example, our FY year ends 6/30 so if I am in Dec, i will load a file that is 6 months actuals and 6 months forecast into the actual version in AP. We then forecast the out years based on that load. As we are 6/30 YE, I am using a switchover date of Jul22. My timescale is quarters.
The issue I have is that we do not forecast our BS. Thus, if we are only half way though year I load two quarters of actuals into AP actual version. I would like to be able to forecast out the remaining 2 quarters in the actual period, + the out years (like the P&L). However, as my switchover is July, I cant model out the remainder via the forecast version.
That said, is there a way to model within the actual version? I thought about creating another version with different switchover date, but then for summary level reporting, i don't think i can have the forecast P&L and 'new' version BS displayed at same time. I was also thinking about creating separate model with its own switchover date and then importing that to my original model for BS actuals. That seems cumbersome to maintain two models.
Any insight/direction on how to proceed would be greatly appreciated, thanks!