When organisations are faced with uncertainty, they typically re-forecast more often. For example, in the last three months, many businesses have re-forecast their financials at least weekly and their cash positions almost daily. It’s what FSN calls the ‘hamster wheel’ effect – the wheels are turning faster and faster, but unfortunately the process isn’t delivering any more substance by way of insight – and that’s because in most cases, fundamentally nothing has changed. But fascinatingly, recent experience with the COVID-19 crisis suggests that businesses are now looking more deeply, to non-financial and operational data to provide a better handle on their future prospects.


During all my years designing and implementing integration solutions for EPM processes, one thing is clear to me: data integration is a vital part of the equation. After all, it is what brings together any CPM process such as Financial Consolidation and Planning & Budgeting.  As an integration solution architect, I believe that having someone that builds the bridge between all stakeholders is key for any CPM project. Indeed, one of our main responsibilities is to align source systems owners with finance teams.


Data continuity is one of the greatest challenges in the Finance department. Many hands touch the data, enrich it, modify it, push it from one system to another until the end of the financial reporting process. The problem is that those breaks in data continuity have a cost: you lose the audit trail and also valuable information along the way. It is so normal that most Finance departments take it for granted that it is just the way it has to be. But does it still have to be that way?


The market disruption we are experiencing is a new challenge for most business models.  As work from home has become the norm we are often asked if a software implementation project can kick off or continue in a remote fashion.  The answer is an emphatic yes!  In fact, in the normal course of our business, some portion, and sometimes over half of OneStream project delivery is performed remotely.


Today’s CFOs and controllers need to manage their critical, enterprise-wide financial data and processes as effectively as possible. That data needs to be timely, accurate and easily accessible for insightful reporting and analysis to maintain a competitive edge. Accordingly, their corporate performance management (CPM) solutions need to be robust, scalable and provide full integration with their ERP, HCM, CRM and other systems.


In today’s volatile business environment, change is the norm and organizations need the ability to adapt rapidly to changing business conditions, changing regulatory requirements, and changing organization structures – including the impact of mergers and acquisitions.  One of the key benefits of today’s modern corporate performance management (CPM) software platforms is the agility they provide organizations to plan, forecast, and report through rapidly-changing business conditions.  But another key benefit is the capability to model the impact of reorganizations, mergers, and acquisitions and to quickly integrate these changes without disrupting reporting and planning cycles.

M&A’s on the Uptick

Global merger and acquisition (M&A) activity has been picking up steam in recent years, with 2017 coming in as one of the most active years on record.  According to a recent Harvard Law School article, total deal volume in 2017 reached $3.7 trillion globally (roughly equal to 2016, making it the fourth busiest year on record.  Key drivers of this increasing M&A activity include:

  • Low interest rates
  • Increasing stock market performance
  • Tax reform in the US
  • Appetite for digital technologies
  • Shareholder activism

According to a recent M&A trends report by Deloitte, M&A activity is expected to continue at high levels in 2018 and beyond.  The factors cited above, combined with increasing corporate cash levels, will continue to drive high M&A activity in corporations as well as in private equity companies.

The Deloitte report goes on to cite that companies and private equity firms appear to be getting better at achieving their goals for their deals.  Deloitte’s surveys consistently show that well-planned, carefully-executed integrations yield transaction success.

The report states “More than 6 in 10 respondents (63 percent) say they now incorporate the use of non-spreadsheet-based M&A technology tools as part of their deal processes. The respondents cite a raft of benefits. These analytical tools make post-deal integration smoother and faster, reduce costs and conflict, and shorten the time it takes to complete them.”

CPM Software Critical in Supporting M&As

As the Deloitte report cited above indicates, having the right tools in place to support M&A activity are critical to successful M&A integration.  Using spreadsheets to integrate the financials of acquired companies, and analyze the impact of acquisitions takes too much time and effort and is prone to errors.  In fact, Deloitte reported that those who have not used M&A technology tools yet would like to do so going forward: “Sixty-two percent of those who still rely on spreadsheets want to tap into these new M&A tools to integrate their acquisitions faster and more smoothly and to reduce costs and conflicts.”

CPM software provides many capabilities that make it essential to planning and executing successful M&As and reorganizations.  Here are a few examples:

M&A Modeling – planning and forecasting the financial impact of M&As on consolidated financial results, including factoring in cost synergies and impact on corporate taxes.

Planning Reorganizations – changing legal entity structures to simulate the impact on financials is not something that’s wise to do in a General Ledger (GL).  Modern CPM solutions support the creation of multiple hierarchies and the ability to create “what if” scenarios based on potential reorganizations.

M&A Integration – integrating new companies, collecting data from new GL/ERP systems, mapping disparate charts of accounts, and generating consolidated financial results for internal and external reporting.

Ongoing Performance Monitoring – post-M&A tracking of financial and operational performance and key performance indicators (KPIs), and making mid-course corrections is critical to realizing expected synergies and maximizing the return from M&As.

Real-World Customer Examples

Several customers using OneStream’s SmartCPMTM platform have cited M&A support as a key benefit of implementing the solution.

TEAM Inc. – implemented OneStream for financial consolidation, reporting, budgeting, forecasting and account reconciliations, replacing their GL and spreadsheet-based approach to integrating acquisitions.

Cleaver-Brooks – selected and implemented OneStream for unified budgeting, planning, and reporting. In additional to streamlining these processes, it made M&A integration much easier and faster.

To learn more, visit the customer testimonials page on our web site.  And contact OneStream if your organization needs a better solution for planning and executing successful M&As.

John O’Rourke is Vice President of Product Marketing at OneStream Software. With a background in accounting and finance, John has over 30 years of experience in the software industry, including 20 years of experience in product marketing at Hyperion Solutions, Oracle and Host Analytics. He has worked with many customers and partners on financial reporting and planning initiatives and has spoken and written on many topics in corporate performance management. John has also held positions in strategic marketing and product marketing at Dun & Bradstreet Software, Kenan Systems and Decisyon.  Find me on:   


Don’t Miss Another Blog Article, Subscribe Today!



Data integration is one of the most critical aspects of CPM solutions. Why?  Because the effectiveness of your budgeting, planning, consolidation and reporting processes is fully dependent on getting timely and accurate data from GL/ERP, HCM and other systems.