Question on switchover dates

Options
VNagarajan
VNagarajan Member, ALL USERS, GroupMember, Community Member Posts: 3 Occasional Contributor
in Security

Hi all,

 

We are having some slight issues with switchover dates in our financial model. We have outlined the issue in detail below:

 

Background

 

The structure of our model is that we have 5 different versions, of which 4 are currently being used (Actual, LIVE Forecast, Previous Forecast and Budget). The screenshot below gives a summary:

 

VNagarajan_0-1599667809597.png

 

The LIVE Forecast has a switchover date of June 2020 since that signifies the point at which our Q1 forecasting process started.

 

We are now going into Q2 and will need to change the switchover date on the LIVE Forecast version to allow an additional three months of actuals to come into the model.

 

At the same time, we want to store our Q1 Forecast on Previous Forecast version and an updated budget (Q1 forecast + a few additional transactions) in the Budget version. We thought that both can be achieved by taking bulk copies and changing the switchover date to June 2020 however we ran into difficulties as outlined below.

 

Issue

 

Actuals are posted retrospectively. So for instance something may be posted in Q2 forecast period that relates to April (which is in Q1). These new actuals come into our model from the data hub and are causing prior period changes to the Budget and Previous Forecast versions.

 

Possible fixes

 

Ideas on possible fixes we have come up with include:

 

  • Doing a true up say in the month after a given forecast period. The issue with this is that subsequent adjustments to actuals may cause our true up to change / have to be recalculated.
  • Creating a static view of the budget / previous forecasts however this could be quite labour intensive.

If anyone may have had similar experiences / come up with any novel solutions, we would be very happy to hear from you!

 

Many thanks,

 

Vivek

Tagged:

Comments

  • VNagarajan
    VNagarajan Member, ALL USERS, GroupMember, Community Member Posts: 3 Occasional Contributor
    @nathan_rudman thank you so much for your reply! We were unaware of this till quite recently but will be sure to give this a go.

    Thanks again,

    Vivek
  • VNagarajan
    VNagarajan Member, ALL USERS, GroupMember, Community Member Posts: 3 Occasional Contributor

    Thanks very much @sandeep_bk for the advice - we haven't given this a go but will definitely give this a go!

    Thanks,

    Vivek

Categories