IBM Apptio

 View Only

 Create a budget (target) from forecast mid year

  • ApptioPlanning(ITP/ITFMF)
Pam Mercier's profile image
Pam Mercier posted 05/04/23 01:55 PM

We've been asked to create a Target plan (a new Budget essentially) for the remainder of 2023 with the baseline being the April Forecast.  The plan is to load this into CT to replace the Budget.    April Forecast has Jan-Mar Actuals in it.   When we create a Budget with using April forecast as the baseline- we are getting both Actuals and Forecast in the Jan-Mar data (due to the calculated data in the tabs).   We want the Jan-Mar Actuals to be reflected in this Target Budget but can't seem to find a way to accomplish this.  We could set it up as a forecast but to complicate things- our Budget table in CT is set up to accept the imports using Rows not Columns (which can't be exported from ITP in that manner) and of course the integration would send it ITPF Forecast instead of ITPF Budget.     

Normally, when we create a budget baselined off a forecast plan- it is for the following year so Actuals never come in to play.  

Anyone ever come across this scenario and have a solution? Before I start to reconfigure ITPF Budget (and gosh knows how many impacted tables downstream) to accept the Budget in columns and the way it exports from ITP so we can at least manually upload something from a Forecast version-not ideal but we are hoping we don't have to push that to CT more than a couple of times.   


#ApptioPlanning(ITP/ITFMF)
Stuart Saunders's profile image
Stuart Saunders

Hi Pam,

I'm an Advisor with Apptio. I don't have enough experience with IPT to help directly, but I'll check internally to see if we can get someone to help with your issue.

-Stuart


#ApptioPlanning(ITP/ITFMF)
Debbie Hagen's profile image
Debbie Hagen

Hello @Pam Mercier ,
Does this new budget need to be in CT or does it need to be ITP as well?  If just CT then the simplest way would be to just publish the existing April forecast to the ITPF budget file in CT.

If the budget needs to be in ITP as well, then, that's a bit more difficult.  The suggestion from the ITP team is to possibly just export the summary expense tab from the forecast, then import this into the Other tab for a newly created blank budget.   They also suggested that your idea of making an April forecast but calling it a budget could work.


#ApptioPlanning(ITP/ITFMF)
Pam Mercier's profile image
Pam Mercier

@Debbie Hagen Unfortunately we need this to be in ITP and CT.  We did try to export the Summary Expense tab from the Forecast into a blank budget but that did not produce desired results.  I will submit an RFE to have an option in Budget plan types to be able to set it to start it in a month other than Jan- Like forecast does.  


#ApptioPlanning(ITP/ITFMF)
Debbie Hagen's profile image
Debbie Hagen

Thanks for the clarification Pam and for submitting the RFE.   We do have a question out to see if anyone on our team has managed to do what you're asking.  I'll let you know if anyone has. 


#ApptioPlanning(ITP/ITFMF)