You are currently browsing the tag archive for the ‘spreadsheet’ tag.
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.
Tagetik’s Collaborative Disclosure Management automates the document creation process, eliminating many repetitive, mechanical functions and reducing the time needed to administer the process and ensure accuracy. Automation can shorten finance processes significantly. For example, our benchmark research on trends in developing the fast, clean close finds that companies that use little or no automation in their accounting close take almost twice as long to complete the process as those that fully automate it (9.1 days vs. 5.7 days). Manually assembling the narrative text from perhaps dozens of contributors and combining it with data used in tables and elsewhere in the document is a time-consuming chore. Regulatory filings are legal documents that must be completely accurate and conform to mandated presentation styles. They require careful review to ensure accuracy and completeness. Complicating this effort recently are increasingly stringent deadlines, especially in the U.S. Anyone who has been a party to these efforts knows that there can be frequent changes in the narratives and presentation of the numbers as they are reviewed by different parties, and those responsible need to ensure that any change to a number that occurs is automatically reflected everywhere that amount is cited in the document; to use the depreciation and amortization figure as an example, that would include the statement of cash flows, income statement, the text of the management discussion and analysis and the text or tables of one or more footnotes. Moreover, automated systems afford greater control over the data used. They make it possible to answer the common question of where a number came from quickly and with complete assurance. While inaccuracies in other types of financial documents may not have legal consequences, mistakes can have reputational or financial consequences.
Those managing the process also spend a great deal of energy simply checking the document to ensure that the various sections include the latest wording, that the numbers are consistent in the tables and text, that amounts have been rounded properly (which can be really complicated) and that the right people have signed off on every part of the filing. Automation obviates the need for much of these tasks. Tagetik’s CDM workflow-enables the process, so handoffs are automated, participants get alerts if they haven’t completed their steps in timely fashion, and administrators can keep track of where everyone is in the process. Workflow also promotes consistent execution of the process, and the workflows can be easily modified as needed.
In designing Collaborative Disclosure Management, Tagetik took advantage of users’ widespread familiarity with Microsoft Excel and Word to reduce the amount of training required to use its product. CDM’s workflow design makes it relatively easy for business users to define and modify business process automation. Typically, individuals or small groups work on different sections of the document. CDM enables multiple contributors from finance, accounting, legal, corporate and other functions to work with their part of the document without being concerned about other contributors’ versions. Work can proceed smoothly, and those administering the process can see at any time which components have been completed, are in progress or have not even started. Tagetik’s software can cut the time required to prepare any periodic document, since once a company has configured its system to create what is in effect a template, it’s relatively easy to generate these documents on monthly, quarterly or annual bases. The numbers relevant to the current period are updated from the specified controlled sources, and references to tabular data within the text are automatically adjusted to tie back to these new figures. Often a large percentage of the narrative text is boilerplate that either must not be updated or requires only limited editing to reflect new information. Starting with the previous edition of the report, contributors can quickly mark up a revised version, and reviewers can focus only on what has changed. Other important automation features are data validation, which reduces errors and revisions, and the system’s ability to round numbers using the appropriate statutory methodology.
CDM also handles XBRL tagging, which is essential for all SEC documents and necessary for an increasing number of regulatory filings around the world. The software specifically handles tagging for the two main European prudential regulatory filings for banks and other credit extending institutions, COREP (Common Reporting related to capital) and FINREP (Financial Reporting performed in a consistent fashion across multiple countries).
Companies can gain several key benefits by automating the production of their periodic regulatory filings and internal or external financial reports that combine text and data. One of the most important is time. Automation can substantially reduce the time that highly trained and well-compensated people spend on mechanical tasks (freeing them to do more productive things), and the process can be completed sooner. Having the basic work completed sooner gives senior executives and outside directors more time to review the document before it must be filed or made public. Time that can be devoted to considering how best to polish the narratives or if necessary lengthen upstream deadlines to handle last-minute developments and consider options for how best to treat accounting events. Automation can also reduce the chance of errors, since the numbers tie directly back to the source systems and (if properly configured) ensure that references in the narratives and footnotes to items in tables and the numbers in those table agree completely. Restatements of financial reports caused by errors are relatively rare but when they occur are exceptionally costly for public companies’ reputations.
Disclosure management systems are an essential component for any financial performance management (FPM) system. All midsize and larger corporations should be using this software to automate the production of their periodic mandated filings and other documents that combine text and data. They will find that they are useful in cutting the time and effort required to produce these documents, provide senior executives and directors more time to review and craft the final versions, and reduce the chance of errors in the process. Companies that are using older FPM software should investigate replacing it with an FPM suite to gain the additional capabilities – including disclosure management – that newer suites offer. Tagetik’s should be among the financial systems evaluated for office of finance.
Robert Kugel – SVP Research
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.
Anaplan designed its software to support business planning integrated across an enterprise in a practical way that’s an attractive alternative to spreadsheets. Its HyperBlock architecture is a hybrid of relational, vertical and OLAP databases with in-memory data storage and calculation. To translate that technology-speak into a plain concept, it’s easier than ever for those trained in spreadsheet modeling to transport their skills to a dedicated planning application. Anaplan simplifies the process of creating a planning environment that can be used by sales and marketing, finance, operations – any part of a company. Individual business units can create their plans without IT involvement. Customer companies don’t have to move all plans at once to Anaplan, but when they do, integrating all of the plans into a unified company view is straightforward.
The bulk of the changes in the Winter Release are aimed at refining and improving the user experience and facilitating model creation and updates. One of the most obvious changes is in the individual user interface, which opens up with “model tiles” representing each of the plans each individual has in his or her portfolio. It’s fairly typical for individuals to participate in multiple planning activities. Our benchmark research on business planning finds that, on average, employees participate in five sets of plans. Each of these may have multiple versions, and some may have subsidiary plans to a main plan. Some plans may be current while others are no longer used and are archived. The new interface makes it easier to organize this collection, making the most important plans readily accessible. This enhancement and others that will follow reflect Anaplan’s intent to incorporate ergonomics in the design of its software.
Choosing a model opens a dashboard relevant to the specific role of the user and the plan he or she has selected. Organizations can configure the layout of the dashboard, which provides high-level summarized information and different ways of navigating into and around the details in the plan. Navigation is now role-based to enable users to zero in on only those models and dashboards relevant to their function or role. Anaplan can be configured to drill down to specific items or transactions if necessary. Doing this in a multidimensional model is not always straightforward. An Excel add-in is a must for any planning application because it provides a familiar user interface that enhances productivity while eliminating the disadvantages of desktop spreadsheet, since the individual is working with a formal application and an advanced database environment. Anaplan’s Winter Release simplifies installation of the add-in. All of these enhancements go beyond a simple “consumerization” of business software – layering a snappy gloss onto software that remain tedious to use – to provide a more satisfying working environment.
Another notable addition in the Winter Release is “intelligent mapping,” a useful way for one person to create templates of components used in a model (say, all of the costs of adding a store, doing a marketing campaign or performing heavy maintenance on capital equipment) that others can use. Since organizations tend to handle most processes in much the same way, the operational and financial aspects of those processes are likely to be modeled in almost exactly the same ways. Being able to quickly copy a useful exemplar and easily customize it to an individual’s specific needs saves time. Moreover, making it simple to achieve consistency can improve the effectiveness of planning. Using intelligent mapping needn’t be the product of a conscious effort to create a template, either. An equally likely use is when someone looks at a plan created by another business unit and sees some component in that plan that’s useful to his or her model. Intelligent mapping makes it easy to copy and modify it to suit the need.
Effective collaborative planning is a structured dialog. Structured because it involves hard numbers and a dialog because it involves a back-and-forth exchange between executives and managers to mediate between the results desired and what’s feasible. Toward that end, Anaplan has added a capability in its models it calls a “hold,” which fixes one or more values in the model while the rest are adjusted. This simplifies the process of setting month-by-month, line-by-line objectives because it enables executives to impose selective constraints (minimum or maximum values such as sales by a product line or advertising expense) while adjusting assumptions quickly to assess whether the resulting changes are realistic. Fixing and releasing holds iteratively simplifies and shortens the process of assessing specific details to achieve a plan that is workable and agreeable.
For analysts that create or support planning models, the Winter Release adds a floating formula editor. This is a small but important element because it improves the productivity of modelers – typically a constrained resource in most companies.
The new release further advances Anaplan’s strategic objective to provide corporations with a tool that reduces the amount of effort needed for collaborative planning in any part of the business and enhance the value of this planning by better aligning business unit objectives with market opportunities. Our planning research finds that companies have many plans but, other than the annual budget, very little of it connected and coordinated. Anaplan focuses on collaborative business planning as a way to differentiate its offering from budgeting tools – a mature market with entrenched competitors. Its objective is supported by the underlying architecture of the software, which is designed to lower the barriers to switching from spreadsheet planning and budgeting as well as generating greater business value from a company’s planning processes.
Having said all this, I have to add that making it easier not to use spreadsheets is necessary but insufficient to alter corporate behavior. Companies need a business incentive to change. Anaplan’s use of in-memory technology provides that incentive because it adds considerable value to the planning process. Since the software can process even complex models with large data sets in seconds, in-memory computing can change the nature of planning, budgeting, forecasting and reviews. For example, the technology enables organizations to run more simulations during a planning or review session to understand trade-offs and the consequences of specific events. It can change the focus of reviews from what just happened to what to do next. Rather than relying on intuition or simplistic scenarios to make that decision, in-memory systems support structured, numbers-driven conversations to develop the details of a plan. This is the breakthrough to any planning or budgeting process that in-memory processing provides and a good reason for businesses to make the leap to more capable software.
Anaplan’s product doesn’t do everything. For example, companies that want all of the rigor that goes with a formal sales and operations planning effort should focus on applications dedicated to this process. And Anaplan doesn’t have all of the features that dedicated project planning software can provide. That noted, I recommend that companies that are looking for a dedicated application for general business planning and financial budgeting consider Anaplan. This is especially true if their objective is to have a planning environment usable by all parts of the business that can serve as the integration point for all business planning. We have found their customers have made significant progress to improving the modeling and planning which is why it received the 2013 Ventana Research Leadership Award. If you have not taken a look at Anaplan it is well worth your time.
Robert Kugel – SVP Research