Services for Organizations

Using our research, best practices and expertise, we help you understand how to optimize your business processes using applications, information and technology. We provide advisory, education, and assessment services to rapidly identify and prioritize areas for improvement and perform vendor selection

Consulting & Strategy Sessions

Ventana On Demand

    Services for Investment Firms

    We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

    Consulting & Strategy Sessions

    Ventana On Demand

      Services for Technology Vendors

      We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

      Analyst Relations

      Demand Generation

      Product Marketing

      Market Coverage

      Request a Briefing

        Robert Kugel's Analyst Perspectives

        << Back to Blog Index

        Consolidation Software Builds Staff Effectiveness in Midsize Companies

        Financial consolidation software assists companies in executing their accounting close process - especially those that use multiple ERP systems or have multiple legal entities - and with other characteristics that can complicate the process such as keeping books in multiple currencies. Not every midsize company needs consolidation software because many find their ERP (or financial management) software satisfies their needs. Our Office of Finance research finds that just 5% of midsize companies (which we define as those with 100-999 employees) use consolidation software to manage the process while 30% use their ERP system and another 51% use desktop spreadsheets either completely or to a significant degree. Using consolidation software can help shorten the close, especially when it substantially reduces the use of spreadsheets. Consolidation software supports the management discipline of continuous accounting.

        Smaller midsize companies usually find that their ERP system can handle their periodic accounting consolidation. Eventually, though, successful businesses grow and will often find that the very accounting software that once made things more efficient is now bogging down operations. As organizations grow, their structure and accounting tend to get more complicated. For example, intercompany transactions volumes increase, or there are substantially more legal entities, perhaps even operations in multiple countries with multiple currencies. An acquisition or merger, especially one involving a company of similar size, may make standardizing on one ERP system an unattractive option. Consequently, the accounting staff winds up spending significant time each month and quarter doing an increasing amount of time-consuming manual operations. And, except in the case of a merger or acquisition, the volume of additional manual work may start at a low level that is not a big deal but over time, as the business expands, the workloads become increasingly burdensome.

        Ventana_Research_Benchmark_Research_Office_of_Finance_19_38_Midsize CloseOne important reason for using a consolidation application is to close the books sooner so that financial and managerial accounting can be readily available to executives and managers, enabling them to respond to issues and opportunities earlier and build corporate agility. There is general agreement that corporations should close their books within one business week of the end of the month or quarter, yet our Benchmark Research found that 59% of midsize companies take more than six business days to complete the process. A too-long close is one sign that consolidation software could streamline the process by reducing the number of spreadsheets that are being used to get around the limitations of an organization’s ERP system or consolidate the accounts from multiple vendors’ ERP systems. Our Fast Close Benchmark Research reveals a correlation between spreadsheet use and time spent on the close: just 16% of companies that make substantial use of spreadsheets in the close process complete it within four business days compared to 33% that limit them to occasional use. Conversely, 33% of organizations that limit spreadsheet use in their close take seven or more days versus 54% of companies that use them extensively.

        Another important reason for investing in consolidation software is improving staff productivity. Workflows, for example, can streamline the close process, enabling the controller to manage by exception and focus on resolving issues quickly. The value of productivity is measured in staff effectiveness, not costs, because the finance and accounting workers in midsize companies typically wear multiple hats so it is unlikely that improving individual efficiency in one area of responsibility will make it possible to reduce departmental headcount. Not having to spend as much time on the accounting close frees up time to perform other work, including analysis and reporting, that provides a broader range of managerial and financial accounting measurements sooner to improve situational awareness and enhance performance. It is also likely that the department will be able to scale as the business grows without having to increase headcount.

        Financial control and financial statement integrity are also factors favoring the use of a consolidation application because the software, among other functions, provides an audit trail, converts currencies and generates financial reports. Desktop spreadsheets are notoriously error prone, lack an audit trail and can introduce inconsistencies in key items such as exchange rates.

        Unless a midsize company makes an acquisition that immediately complicates its accounting close, there usually is no bright line that indicates it is time to consider using consolidation software. As businesses grow, they become more complex as they expand geographically, create new legal entities, adopt new business models and otherwise make necessary business decisions that add to the accounting staff’s month- and quarter-end task burden. Two signs that consolidation software is needed are an accounting close that takes more than one business week or where the department makes extensive use of spreadsheets in the process. For those midsize companies, I recommend assessing how consolidation software can have a positive impact on the productivity and effectiveness of the accounting staff.


        Robert Kugel


        Robert Kugel
        Executive Director, Business Research

        Robert Kugel leads business software research for Ventana Research, now part of ISG. His team covers technology and applications spanning front- and back-office enterprise functions, and he personally runs the Office of Finance area of expertise. Rob is a CFA charter holder and a published author and thought leader on integrated business planning (IBP).


        Our Analyst Perspective Policy

        • Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

          Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to

        View Policy

        Subscribe to Email Updates

        Posts by Month

        see all

        Posts by Topic

        see all

        Analyst Perspectives Archive

        See All