Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Expand all | Collapse all

How often does your company load actuals into Apptio?

Apptio Community Member

Apptio Community MemberThu March 12, 2020 03:32 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 03:36 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 03:42 PM

Robert McGough

Robert McGoughThu March 12, 2020 03:46 PM

Kyle Castro

Kyle CastroThu March 12, 2020 03:51 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 03:58 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 04:13 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 05:15 PM

Apptio Community Member

Apptio Community MemberThu March 12, 2020 05:56 PM

Apptio Community Member

Apptio Community MemberFri March 13, 2020 03:07 AM

Jens Wallgren

Jens WallgrenFri March 13, 2020 03:44 AM

Apptio Community Member

Apptio Community MemberFri March 13, 2020 04:27 AM

Apptio Community Member

Apptio Community MemberMon March 16, 2020 03:11 PM

Apptio Community Member

Apptio Community MemberThu March 19, 2020 01:30 PM

  • 1.  How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:32 PM
    1. Monthly
    2. Quarterly
    3. Others

     

    Thanks for your time



    #Platform


  • 2.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:36 PM

    2-3 times per month.


    #Platform


  • 3.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:42 PM

    Monthly


    #Platform


  • 4.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:46 PM

    We load our cost transparency project data once a month and our cloud project data daily.  I am considering loading CT more than once a month, but haven't pulled that trigger yet.


    #Platform


  • 5.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:46 PM

    Monthly


    #Platform


  • 6.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:51 PM

    Monthly


    #Platform


  • 7.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:54 PM

    Thank you all. This is helpful. We are currently doing monthly. We are thinking if we should change it, hence the poll :-)


    #Platform


  • 8.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 03:58 PM

    Monthly !


    #Platform


  • 9.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 04:13 PM

    We load actuals monthly, forecasts quarterly.


    #Platform


  • 10.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 05:01 PM

    We load partial actuals on the 1st business day of the month for forecast in IT Planning and then a full actuals file following close.


    #Platform


  • 11.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 05:15 PM

    Monthly for most data, some is quarterly.


    #Platform


  • 12.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 12, 2020 05:56 PM

    Weekly for our GL data, monthly for our people data.


    #Platform


  • 13.  Re: How often does your company load actuals into Apptio?

    Posted Fri March 13, 2020 03:07 AM

    Monthly.


    #Platform


  • 14.  Re: How often does your company load actuals into Apptio?

    Posted Fri March 13, 2020 03:44 AM

    We load them monthly.


    #Platform


  • 15.  Re: How often does your company load actuals into Apptio?

    Posted Fri March 13, 2020 04:27 AM

    Monthly. What are the main reasons to do it more frequently? 


    #Platform


  • 16.  Re: How often does your company load actuals into Apptio?

    Posted Fri March 13, 2020 07:19 AM

    We currently post actuals and open the forecast monthly.


    #Platform


  • 17.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 16, 2020 04:26 AM

    Monthly for our data financial data. Most of the infrastructure data are uploaded monthly but some with less volatility e.g. Data Center, are uploaded quarterly.  


    #Platform


  • 18.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 16, 2020 12:37 PM

    Monthly.  Prior month actuals are loaded as soon as they're available (generally available by the third business day of the month) and become the basis for the current month customer bill.


    #Platform


  • 19.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 16, 2020 03:11 PM

    Thank you all for the quick responses. 


    #Platform


  • 20.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 19, 2020 01:30 PM

    10 times based on new data being added


    #Platform


  • 21.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 23, 2020 12:30 PM

    Actual (OpEx & CapEx) spend is loaded monthly (more in specific months if adjustments are made to the ledger after the regular load). In one previous company, I loaded actual spend for OpEx weekly, but pushed to Prod monthly.

     

    Budget (OpEx & CapEx) is loaded once. In cases of a restate, budget is loaded again.

     

    In a few past experiences, forecast is loaded in periods 3, 4, 6, 7, 8, and 9. Project forecast was more frequently completed, but not managed in any way by the TBMO nor loaded into TBMO tools.

    For Cloud providers...it depends. In one case, we were loading daily as a means of supplementing the absence of a tool like Cloudability. In most cases, I expected a monthly refresh would be sufficient since a separate Cloud management tool (eg Cloudability) should be deployed.


    #Platform


  • 22.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 26, 2020 08:08 AM

    Quarterly for now, but we are changing to a monthly cadence after the Q1 2020 loads are complete.


    #Platform


  • 23.  Re: How often does your company load actuals into Apptio?

    Posted Thu March 26, 2020 12:24 PM

    Kevin - is there a reason you were loading it quarterly? What was missing when you were following that cadence? 


    #Platform


  • 24.  Re: How often does your company load actuals into Apptio?

    Posted Fri April 03, 2020 05:17 PM

    Our data loads are done manually today, including the data extraction from our ERP. We chose the quarterly cadence mainly because of the manual effort involved. Now that we are close to automation, we are switching.


    #Platform


  • 25.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 30, 2020 05:46 AM

    We load the GL actuals monthly but release the numbers quarterly

     

    Infrastructure excluding virtual servers are loaded at the start of the quarter as there isn't much movement.

     

    We also load forecast monthly


    #Platform


  • 26.  Re: How often does your company load actuals into Apptio?

    Posted Mon March 30, 2020 06:39 AM

    We load the GL monthly, but timesheet actuals are weekly and cloud billing is daily.


    #Platform


  • 27.  Re: How often does your company load actuals into Apptio?

    Posted Tue March 31, 2020 02:05 AM

    Monthly financial loads and updates to the IT infrastructure-related datasets (CMDB, etc.), including cloud invoices.

    Daily updates to AWS consumption.

    I've been trying to forecast for a couple of years now. Not much success so far due to lack of reliable metrics.

    Finance do quarterly business reviews.


    #Platform


  • 28.  Re: How often does your company load actuals into Apptio?

    Posted Tue March 31, 2020 06:00 AM

    Monthly but it completely depends on cycle of your Actuals data re-freshness if its quarterly then there is no harm going with quarterly frequency.


    #Platform


  • 29.  Re: How often does your company load actuals into Apptio?

    Posted Fri April 03, 2020 12:33 PM

    Thank you all - this was very helpful. We are doing currently month, and we were rethinking, and wanted to see what others are doing. 


    #Platform