In our benchmark research at least half of participants that use spreadsheets to support a business process routinely say that these tools make it difficult for them to do their job. Yet spreadsheets continue to dominate in a range of business functions and processes. For example, our recent next-generation business planning research finds that this is the most common software used for performing 11 of the most common types of planning. At the heart of the problem is a disconnect between what spreadsheets were originally designed to do and how they are actually used today in corporations. Desktop spreadsheets were intended to be a personal productivity tool used, for example, for prototyping models, creating ad hoc reports and performing one-off analyses using simple models and storing small amounts of data. They were not built for collaborative, repetitive enterprise-wide tasks, and this is the root cause of most of the issues that organizations encounter when they use them in such business processes.
Topics: Analytics, application, benchmark, Business Analytics, Business Collaboration, Business Intelligence, Business Performance, closing, Customer Performance, dashboard, Data, enterprise spreadsheet, ERP, Excel, Financial Performance, Financial Performance Management, Forecast, GRC, Information Management, Operational Performance, Planning, Reporting, Risk, Sales Performance, Office of Finance
Tagetik provides financial performance management software. One particularly useful aspect of its suite is the Collaborative Disclosure Management (CDM). CDM addresses an important need in finance departments, which routinely generate highly formatted documents that combine words and numbers. Often these documents are assembled by contributors outside of the finance department; human resources, facilities, legal and corporate groups are the most common. The data used in these reports almost always come from multiple sources – not just enterprise systems such as ERP and financial consolidation software but also individual spreadsheets and databases that collect and store nonfinancial data (such as information about leased facilities, executive compensation, fixed assets, acquisitions and corporate actions). Until recently, these reports were almost always cobbled together manually – a painstaking process made even more time-consuming by the need to double-check the documents for accuracy and consistency. The adoption of a more automated approach was driven by the requirement imposed several years ago by United States Securities and Exchange Commission (SEC) that companies tag their required periodic disclosure filings using eXtensible Business Reporting Language (XBRL), which I have written about. This mandate created a tipping point in the workload, making the manual approach infeasible for a large number of companies and motivating them to adopt tools to automate the process. Although disclosure filings were the initial impetus to acquire collaborative disclosure management software, companies have found it useful for generating a range of formatted periodic reports that combine text and data, including board books (internal documents for senior executives and members of the board of directors), highly formatted periodic internal reports and filings with nonfinancial regulators or lien holders.
Topics: Analytics, benchmark, Budgeting, Business Analytics, Business Intelligence, Business Performance, CFO, close, closing, compliance, Consolidation, Controller, Data, ERP, Finance Financial Applications Financial Close, Financial Performance, Financial Performance Management, financial reporting, FPM, GAAP, Governance, Risk & Compliance (GRC), IFRS, Integrated Business Planning, Mobile, Modeling, Profitability, Reporting, SEC Software, XBRL, Office of Finance, Human Capital Management, Big Data
Our recently released benchmark research on optimizing payroll management assesses how organizations use payroll information, processes and technology. It finds that most of them still need to improve. Our analysis compared the forces motivating investment in payroll management systems to broader strategic drivers for human capital management (HCM) that I previously outlined and found substantial agreement. Three of the five leading factors – demand for higher employee productivity (48%), limited alignment between pay and performance (36%), and inconsistent execution of performance goals (24%) – are part of a broader HCM agenda as seen in previous research projects and discussions with clients. But apart from that the research found a disconnect between what motivates companies and what they actually are doing.
Topics: Employee Productivity, Financial Performance, HCM, HR, Pay for Performance, Payroll Management, Talent Management, Workforce Management, Workforce Performance, Office of Finance, Big Data, benchmark
Learning is an integral component of human capital management, and a new generation of learning management systems advances learning in organizations around the world. These systems have evolved over the years from a classroom scheduling tool that facilitated instructor-led and classroom training into an array of enterprise applications that deliver and track various types of training. Recently new technologies, such as business analytics, cloud computing, social collaboration, and mobile technology have become part of the learning management process. To assess the impacts of this ongoing shift, Ventana Research is conducting benchmark research on how organizations are implementing and using this new generation of systems.
Topics: Analytics, Business Analytics, Business Collaboration, Business Intelligence, Cloud Computing, Collaboration, HCM, HR, HR research, Learning Management, LMS, Mobile, Social Media, Training, Workforce Performance, Big Data, benchmark
Our benchmark research on enterprise spreadsheets explores the pitfalls that await companies that use desktop spreadsheets such as Microsoft Excel in repetitive, collaborative enterprise-wide processes. Because people are so familiar with Excel and therefore are able to quickly transform their finance or business expertise into a workable spreadsheet for modeling, analysis and reporting, desktop spreadsheets became the default choice. Individuals and organizations resist giving up their spreadsheets, so software vendors have come up with adaptations that embrace and extend their use. I’ve long advocated finding user-friendly spreadsheet alternatives.
Topics: Analytics, benchmark, Business Analytics, Business Collaboration, Business Performance, Cloud Computing, Customer & Contact Center, enterprise spreadsheet, Financial Performance, Financial Performance Management, Governance, Risk & Compliance (GRC), GRC, Information Applications, Information Management, Operational Performance, Reporting, Risk, Sales Performance, Workforce Performance, Office of Finance