The treasury function in finance departments doesn’t get a lot of attention, but it’s a fundamentally important one: to ensure that all funds are accounted for and that there is sufficient cash on hand each day to meet operating requirements. Keeping track of and managing cash, especially in larger organizations, can be complicated because of multiple bank accounts, complex financing requirements and various methods of receiving and making payments; the complexity deepens when more than one currency is used across multiple jurisdictions, which also can pose regulatory issues.
Workday Financial Management (which belongs in the broader ERP software category) appears to be gaining traction in the market, having matured sufficiently to be attractive to a large audience of buyers. It was built from the ground up as a cloud application. While that gives it the advantage of a fresh approach to structuring its data and process models for the cloud, the product has had to catch up to its rivals in functionality. The company’s ERP offering has matured considerably over the past three years and now is better positioned to grow its installed base. Workday recently added Aon, the insurance and professional services company, to its customer list (becoming its largest customer to date) and reported that its annual contract value (ACV – the annualized aggregate revenue value of all subscription contracts as of the end of a quarter) has doubled since the second quarter of this year, albeit from a low base. This is an important milestone because for years the company’s growth has come from the human capital management (HCM) portion of the business, not financials. Workday has around 160 customers for its financials (more than 90 of which are live) compared to more than 1,000 customers for HCM.
Topics: Microsoft, SAP, ERP, FP&A, NetSuite, Operational Performance Management (OPM), Reporting, close, closing, Controller, dashboard, Human Capital, Reconciliation, report, Tax, Analytics, Business Intelligence, Cloud Computing, Collaboration, IBM, Oracle, Uncategorized, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), Amazon, BI, Financial Performance Management, FPM, Intacct, scorecard, spreadsheet, treasury
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. Software vendors and IT departments have been trying – mainly in vain – to get users to switch from spreadsheets to a variety of dedicated applications. They’ve failed to make much of a dent because, although these applications have substantial advantages over spreadsheets when used in repetitive collaborative enterprise tasks, these advantages are mainly realized after the model, process or report is put to use in the “production” phase (to borrow an IT term). To date most dedicated applications have been far more difficult than spreadsheets for the average business user to use in the design and test phases. To convince people to switch to their dedicated application, a vendor must offer an alternative that lets users model, create reports, collect data and create dedicated data stores as easily as they can do it in a desktop spreadsheet. Spreadsheets are seductive for most business users because, even with a minimum amount of training and experience, it’s possible to create a useful model, do analysis and create reports. Individuals can immediately translate what they know about their business or how to present their ideas into a form and format that makes sense to them. They can update and modify it whenever they wish, and the change will occur instantly. For these business users ease of use and control trump putting up with the issues that routinely occur when spreadsheets are used in collaborative enterprise processes. Moreover, it’s hard to persuade “spreadsheet jockeys” who have strong command of spreadsheet features and functions that they should start over and learn how to use a new application. Those who have spent their careers working with spreadsheets often find it difficult to work with formal applications because those applications work in ways that aren’t intuitive. Personally these diehards may resist because not having control over analyses and data would diminish their standing in the organization. Nevertheless, there are compelling reasons for vendors to keep trying to devise dedicated software that an average business user would find as easy and intuitive as a desktop spreadsheet in the design, test and update phases. Such an application would eliminate the single most important obstacle that keeps organizations from switching. The disadvantages of using spreadsheets are clear and measurable. One of the most significant is that spreadsheets can waste large amounts of time when used inappropriately. After more than a few people become involved and a file is used and reused, issues begin to mount such as errors in data or formulas, broken links and inconsistencies. Changes to even moderately complex models are time-consuming. Soon, much of the time spent with the file is devoted to finding the sources of errors and discrepancies and fixing the mistakes. Our research confirms this. When it comes to important spreadsheets that people use over and over again to collaborate with colleagues, on average people spend about 12 hours per month consolidating, modifying and correcting the spreadsheets. That’s about a day and a half per month – or five to 10 percent of their time – just maintaining these spreadsheets. Business applications vendors started to address business users’ reluctance to use their software more than a decade ago when they began to use Microsoft Excel as the user interface (UI). This provides a familiar environment for those who mainly need to enter data or want to do some “sandbox” modeling and analysis. Since the software behind the UI is a program that uses some sort of database, companies avoid the issues that almost arise when spreadsheets are used in enterprise applications. There also are products that address some of the inherent issues with such as the difficulty of consolidating data from multiple individual spreadsheets as well as keeping data consistent. Visualization software, a relatively new category, greatly simplifies the process of collecting data from one or more enterprise data sources and creating reports and dashboards. As the enterprise software applications business evolves to meet the needs of a new generation of users, as I mentioned recently, it’s imperative that vendors find a way to provide users with software that is a real alternative to desktop spreadsheets. By this I mean enterprise software that provides business users with the same ability to model, create reports and work with data the way they do in a desktop spreadsheet as well as update and modify these by themselves without any IT resources. At the same time, this software has to eliminate all of the problems that are inevitable when spreadsheets are used. Only at that point will a dedicated application become a real alternative to using a spreadsheet for a key business process. Regards, Robert Kugel – SVP Research
Topics: Planning, ERP, Forecast, GRC, Operational Performance Management (OPM), Reporting, closing, dashboard, enterprise spreadsheet, Excel, plan, Analytics, Business Analytics, Business Collaboration, Accounting, Business Intelligence (BI), Business Performance Management (BPM), Customer Performance Management (CPM), Data, Financial Performance Management (FPM), Risk, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), application, benchmark, Financial Performance Management, spreadsheet
Ventana Research recently released the results of our Next-Generation Business Planning benchmark research. Business planning encompasses all of the forward-looking activities in which companies routinely engage. The research examined 11 of the most common types of enterprise planning: capital, demand, marketing, project, sales and operations, strategic, supply chain and workforce planning, as well as sales forecasting and corporate and IT budgeting. We also aggregated the results to draw general conclusions.
Topics: Big Data, Planning, Predictive Analytics, Sales, Social Media, forecasting, Marketing, Operational Performance Management (OPM), Reporting, Budgeting, Controller, sales forecast, strategic, workforce, Business Analytics, Cloud Computing, In-memory, Business Performance Management (BPM), CFO, Customer Performance Management (CPM), Financial Performance Management (FPM), Sales Performance Management (SPM), Supply Chain, Workforce Performance Management (WPM), capital spending, demand, Financial Performance Management, financial reporting, FPM, Integrated Business Planning, S&OP, spreadsheet
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: Mobile, ERP, forecasting, Modeling, Reporting, Budgeting, close, closing, Consolidation, Controller, Finance Financial Applications Financial Close, IFRS, multinational Tagetik, process management, report, strategy, XBRL, Analytics, Business Analytics, Business Intelligence, Governance, Risk & Compliance (GRC), Accounting, Business Performance Management (BPM), CFO, Chief Financial Officer, compliance, Data, Financial Performance Management (FPM), benchmark, Financial Performance Management, financial reporting, FPM, GAAP, Integrated Business Planning, Profitability, SEC Software, spreadsheet
Anaplan, a provider of cloud-based business planning software for sales, operations, and finance and administration departments, recently implemented its new Winter ’14 Release for customers. This release builds on my colleagues analysis on their innovation in business modeling and planning in 2013. Anaplan’s primary objective is to give companies a workable alternative to spreadsheets for business planning. It is a field in which opportunity exists. Our benchmark research on this topic finds that a majority of companies continue to use spreadsheets for their planning activities. Almost all (83%) operations departments use spreadsheets for their plans, as do 60 percent of sales and marketing units. Yet the same research shows that satisfaction with spreadsheets as a planning tool is considerably lower than satisfaction with dedicated planning applications. But despite general agreement in companies that the planning process is broken and spreadsheets are a problem, companies seem reluctant to break the bad habit of using spreadsheets. This conclusion suggests that either switching to dedicated software hasn’t been easy enough or that the results of doing it have not been compelling enough to motivate change. Anaplan intends to address both of these issues.
Topics: Big Data, Performance Management, Planning, Predictive Analytics, Anaplan, forecasting, Marketing, Operational Performance Management (OPM), Operations, Reporting, Budgeting, Controller, Business Analytics, Cloud Computing, In-memory, Business Performance Management (BPM), CFO, Financial Performance Management (FPM), Sales Performance Management (SPM), Sales Planning, Supply Chain Performance Management (SCPM), Workforce Performance Management (WPM), Financial Performance Management, financial reporting, FPM, Integrated Business Planning, spreadsheet
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: GRC, Operational Performance Management (OPM), Reporting, Boardwalktech, enterprise spreadsheet, Analytics, Business Analytics, Business Collaboration, Cloud Computing, Governance, Risk & Compliance (GRC), Business Performance Management (BPM), Customer Performance Management (CPM), Financial Performance Management (FPM), Information Applications (IA), Information Management (IM), Risk, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), Workforce Performance Management (WPM), BCP, benchmark, Financial Performance Management, spreadsheet
Host Analytics has introduced AirliftXL, a new feature of its cloud-based financial performance management (FPM) suite that enables its software to translate users’ spreadsheets into the Host Analytics format. I find it significant in three respects. First, it can substantially reduce the time and resources it takes for a company to go live in adopting the Host Analytics suite, lowering the cost of implementation and accelerating time to value. Second, it enables Host Analytics users who have the appropriate permissions to create and modify models and templates that they use in planning, budgeting, consolidation and reporting. This can enhance the value of the system by making it easier to maintain. Third, it can make it far easier to routinely collect and connect planning and analytical models used by all departments and business users as it has outlined in its planning cloud offering. Although it has limitations in its initial release, AirliftXL gives corporations a workable alternative to stand-alone spreadsheets and has the potential to substantially increase productivity and effectiveness of an organization in the full range of budgeting, planning, consolidation and reporting functions.
Topics: Modeling, Operational Performance Management (OPM), Reporting, closing, Consolidation, Controller, Host Analytics, Business Analytics, Cloud Computing, Accounting, Business Performance Management (BPM), CFO, Financial Performance Management (FPM), Workforce Performance Management (WPM), Allocations, Financial Performance Management, FPM, spreadsheet
Tidemark announced the release of the Fall 2013 version of its eponymous cloud-based application that my colleague assessed earlier in 2013. This new release adds capabilities for labor planning and expense management as well profitability modeling and analysis. These two areas of planning and analysis are common to all businesses. The new release adds features that enhance the software’s ability to do sales forecasting, initiative planning and IT department planning. The company continues to refine its modeling capabilities to make it easier for people engaged in the planning process to translate their expectations and concerns into a quantified view of the future. For example, users now can build models using natural-language modeling. The objective is to eliminate the need for help from business analysts or experts trained in the use of a tool and immersed the details of the IT plumbing, such as the metadata used for specific general ledger accounts or operational data.
Topics: Performance Management, Planning, Predictive Analytics, forecasting, Operational Performance Management (OPM), Reporting, Budgeting, Controller, Cloud Computing, In-memory, Business Performance Management (BPM), CFO, Customer Performance Management (CPM), Financial Performance Management (FPM), Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), Tidemark, Workforce Performance Management (WPM), Analplan, Financial Performance Management, financial reporting, FPM, Integrated Business Planning, spreadsheet
Business planning is a new software category. These applications enable senior executives to integrate all the plans of business units into a single, integrated view, which helps them have more accurate plans, do more insightful what-if planning, achieve greater agility in reacting to changing business and economic conditions, and execute plans in a more coordinated fashion than was possible. Business planning software is intended for CEOs and COOs, who are not well served by current capabilities. Business planning software enables executives and managers to understand both the operational and the financial consequences of their actions, but it emphasizes the things that the various parts of the business focus on: units sold, sales calls made, the number and types of employees required, customers serviced and so on. Lines of business already do this but in a fragmented fashion using desktop spreadsheets circulated within silos via email. Business planning software provides a platform to support modeling in individual business units, individual planning processes and visualization of the impacts of changes in what-if scenarios. It offers a central data repository for all plans; our benchmark research shows the advantage of this approach: Companies that directly link individual business unit data to an integrated plan get more accurate results. To be specific, 22 percent of those with such links have very accurate budgets compared to just a handful with less direct links and none that employ summarized data.
Topics: Big Data, Performance Management, Planning, Predictive Analytics, forecasting, Operational Performance Management (OPM), Reporting, Budgeting, Controller, Business Analytics, Business Collaboration, Cloud Computing, In-memory, Business Performance Management (BPM), CFO, Workforce Performance Management (WPM), Financial Performance Management, financial reporting, FPM, Integrated Business Planning, spreadsheet