This is a topic quite close to my heart. We are using Apptio for both Finance (traditional Cost Accounting views) as well as Service / Product financials (Service Accounting). On the core Finance side we use ITP for monthy forecasting and annual planning, CT for the finance management reporting on the actuals vs forecast vs budget and and Vendor Insights for AP/Payment reporting. The TBM office sits in an IT Finance team which maybe helps to explain the approach. I do not think you can ever get Finance or Accountants completely away from excel and the source GL but given that we have a detailed GL table loaded into Apptio we have built a number of summary management reports and more transactional Finance reports to replace legacy Finance reporting. However, this does require customized reporting as I do not think the Out of the Box reports fulfill the requirements for core Finance users.
While the overall approach has many advantages there are some considerations:
- Performance: it requires a detailed GL table to be loaded into Apptio to meet the detailed reporting and analysis requirements from Finance. Such a detailed table can have performance implications and requires alot of reconfiguration to have off model tables for detailed Finance reporting and summarised GL tables flowing up through the model. It is far from an Out of the Box implementation
- Architecture: the monthly finance cycle requires transfer of data between ITP and CT a number of times over a 2 week window early in the month. This can require data to be pushed to production and a full model calculation (even though you are only reporting on the very bottom of the model rather than Towers or Services) which if you have a big and complex model with a long calculation time can be operationally challenging (particularly given tight Finance timelines). This has improved slightly with recent updates to ITP which makes the transfer of data into CT much easier but the issues still remains to some extent.
- Reporting and Maintenance: as mentioned the Out of the Box reports do not really meet the needs of core Finance users and customized reporting is required. Deciding to run core Finance processes on the system adds to the overall workload and maintenance efforts
Its an interesting question and I think that ultimtely the issues mentioned above steer core Finance folk away from using the tool. However, with some configuration updates, customization and alot of hard work I think it is achievable but we are early in our implementation and would not yet like to cliam success.