CODA Group, a finance and systems specialist headquartered in the United Kingdom, offers financial solutions that help companies grapple with international business issues such as language, currency, and compliance. Designed to be an "upgrade friendly system", CODA applications offer open and standards-based reporting tools. CODA's alliance with Microsoft Corp. has allowed it to deliver a range of financial and management accounting systems, and it has made several strategic acquisitions to further strengthen its position as a compliance solution.
Part Three of the Composing Collaborative Financial Applications, CODA series.
Among its recent endeavors, CODA has recently announced new set of financial planning and budgeting products: CODA s-Planning ("s" standing for "standard") and CODA c-Planning ("c" standing for "collaborative"), as well as a range of improved analysis and reporting tools, which will be detailed shortly. Nevertheless, to date, these corporate performance management (CPM) capabilities have targeted mainly existing customers of the CODA transactional systems. These users have focused on financial analytics, budgeting, and planning, either through Microsoft Excel integration within CODA c-Planning and CODA s-Planning, or through a partnership with Cognos for enterprise-level planning and budgeting. CODA's consolidation capabilities have traditionally been limited to the basic ones inherent in Coda-Financials. While these are adequate for simpler enterprises, the vendor has thus far been unable to successfully compete with offerings from specialists such as Hyperion Solutions, Geac (formerly Comshare), Applix, Longview, Outlooksoft, or Cartesis. Yet, the importance of these functionalities has been witnessed by Cognos' acquisition of Adaytum in 2003 and Business Objects' recent acquisition of the specialist SRC. See Financial Reporting, Planning, and Budgeting as Necessary Pieces of EPM for information on the functionality.
Thus, this merger deal should benefit both parties for many reasons. While Simple Concepts should get access to CODA's well developed global distribution channel and benefit from its financial stability, CODA should fill the financial consolidation gaps in its solution. Immediate cross-selling opportunities into CODA's install base will expand further as CODA translates OCRA into more languages. Not to mention, there are opportunities coming from OCRA's prior integration with SAP, Oracle, and other leading enterprise resource planning (ERP) solutions. The acquisition also gives CODA a base for strengthening its direct sales operation and presence in Scandinavia.
The two recent acquisitions came at the heels of CODA's June 2005 launch of a suite of add-on applications that extends the range of planning and budgeting requirements: CODA s-Planning and CODA c-Planning . These could offer more benefits for CODA-Financials users. The suite includes Version 3 of the much talked about CODA-XL application. CODA-XL allows the fairly simple and secure output, manipulation, display, sharing, and input of CODA-Financials data within Microsoft Excel. s-Planning and c-Planning were seen to enable users to carry out a range of day-to-day tasks, such as producing and sharing statutory reports; processing expenses; or even developing and setting financial budgets using CODA-Financials alongside Excel and the other familiar Microsoft Office tools that most organizations probably already have in place. These new products were meant to make CODA-Financials the launch pad for a quicker and easier budget cycle. By combining the functionality and embedded control of CODA with the familiarity and convenience of Microsoft Excel, CODA s-Planning and CODA c-Planning should streamline the seeding, preparation, manipulation, and production of budgets, based on (or update) the user's CODA-Financials data. Moreover, CODA continues to develop its relationship with Cognos, offering the Cognos Enterprise Planning product where clients have wider enterprise requirements. The vendor also uses a mix of partnership and in-house development to address other CPM elements, such as activity-based costing (ABC), strategic planning and scenario analysis, shareholder value measurement, activity monitoring, information distribution, etc.
In addition to the "standard" budgeting and forecasting facilities provided by CODA s-Planning, users have the option to make their entire cycle more coordinated, efficient, and controlled by opting for the "collaborative" add-on of the CODA c-Planning product. This interfaces with the CODA-Control process management solution, adding a facility to publish budgets as CODA-Control web sites and tasks. This will keep all participants informed and aware of the input needed and when it is required. There are also audit trails and document history to support compliance reporting. CODA c-Planning aims to help organizations set financial budgets and collaboratively develop plans, which both reflect top-down business objectives and assess the need to account for bottom-up creativity and realities. For example, it will give budget managers visibility of process bottlenecks, including vacation and sick days of department managers, information on groups waiting for information from subsidiaries, and vice versa. Conversely, many other peer products focus purely on bringing together and reporting the figures in the system, and not on collaborative processes that are key to collecting and verifying the figures in the first place. The application's aggregation features often make the budgeting and planning process quicker, more dependable, and more predictable, giving financial professionals more time to analyze and consider their overall budget before making decisions crucial to the organization's mid-term plans.
Another analytic module worth mentioning is the CODA Collaborative Scorecard, which helps user organizations link corporate goals through group objectives and individual performance. Designed to be deployed to every desktop in the enterprise, the product supports multiple performance management methodologies. Generally speaking, scorecards assist organizations in monitoring their business performance beyond bottom-line results by tracking both financial and non-financial measures, and then reporting them in a graphical user interface (GUI). A key element is the way they cascade corporate goals through the organization, helping managers to set individual objectives, and then aggregate performance results back up through the company structure, so that management can review the contributions made by individuals and groups. This aligns corporate strategy with the activities of individuals within the organization.
CODA believes that scorecards should be a strategic pillar of any analytic framework, bonding personal accountability to the enterprise's overall performance management. Initial releases of CODA Collaborative Scorecard have complied with commonly used performance management methodologies, such as the European Foundation for Quality Management (EFQM) balanced scorecard, Six Sigma, etc. to provide a relatively functional and flexible method of managing and aligning enterprise, group, business unit, and personal objectives. However, one should note that, although scorecards should be the fundamental link between personal performance and the overall objectives of the enterprise, they are frequently the weak link in the CPM closed-loop cycle, either because they are too difficult to deploy widely in the organization, or because they have fixed, inflexible methodology (see Why Most Balanced Scorecards are Subverted).
Related to the above line of products is CODA Analytic Explorer, which is a business intelligence (BI) tool that allows CODA users to carry out multidimensional browsing across CODA-Mart and any other relational data source. It is a generic, on-line browsing tool with both two-dimensional and multidimensional browsing capabilities built in, and has a separately licensable cube builder that provides extra performance. As finance departments struggle to add value to their businesses, performance management enables them to deliver better decisions more efficiently. However, CPM is not about static plans that sit on the shelf and get dusted off at board meetings, but rather about continuously adjusting to the range of inputs that the business is constantly receiving. To that end, CODA Analytic Explorer provides the ability to investigate exceptions and trends quickly and easily, so that corrective actions can be taken, and forecasts and plans reviewed.
CODA-XL is now in its third release. It provides a two-way bridge between Excel, which is indisputably the most popular spreadsheet, and CODA's enterprise-level financial and CPM products. CODA-XL was launched in 2003 and brings the familiarity of the Excel interface to CODA-Financials. It should provide customers with several benefits, such as reduced training for end users of CODA-Financials during implementation. Other benefits typically include the elimination of transcription errors and file-handling overheads during the transfer of data between CODA-Financials and Excel. Thus, it may prevent the proverbial "islands of information," where local systems containing great value and insight are locked on individuals' desktops and personal computers and cannot be shared across the organization. However, unlike some similar products from competitors, CODA-XL goes beyond exploiting the familiarity of the user interface (UI) and makes use of the success that Excel enjoys as an informal business modeling and planning tool. It provides "What If?" scenario testing with the option of writing back from the spreadsheet to CODA-Financials. For example, the CODA Security Model is fully embedded within CODA-XL, thus ensuring consistent data security. This means that while add-ins to Excel deliver rich CODA functionality accessed directly from the Microsoft Office desktop, they must respect the same CODA security, validation, and business rules. For example, Excel formulas referencing live account balances are stored directly in CODA Database, with all necessary authorizations for users appearing down to the spreadsheet cell level. For more on the advantages and the inherent risks of Excel-based tools, see Vendors Harness Excel (and Office) to Win the Lower-end of Business Intelligence Market.
Within CODA e-Finance (a Web-based version of the product), all reports validated and cross-checked on-line to validate, to eliminate separate, unsecured reporting tables. "Lights out" scheduling and Web document publishing also eliminate manual intervention. In addition, the data manipulation capabilities of Excel mean that management accountants can build and model scenarios that can be tested against real data relatively quickly, which can be very useful for creditor and debtor management, customer profitability analysis, and ad hoc queries. Furthermore, US Security and Exchange Commission (SEC) submissions can be made through Microsoft Word documents with embedded "live" Excel documents that do not have cut and paste, export, and manipulation functions, which can introduce the potential for errors. Non-programmatic, wizard-driven automation of data entry with real time validation direct from Excel (transactions, allocations, masters, budgets, and forecasts) also eliminates open database connectivity (ODBC), direct structured query language (SQL) updates, relational database management systems (RDMBS) logons, etc., which are also points of risk.
Last but not least along collaboration lines, CODA Collaborative Close is yet another application built using Microsoft Office technologies, one that is designed to help organizations close their books more quickly, more dependably, and more predictably, giving financial professionals more time to analyze and consider data before making crucial decisions. The product was designed to recognize and support the neglected collaborative processes that underpin period close. Other products in this area focus merely on consolidating and reporting the finance figures, but not on collaborative processes that are key to collecting and verifying the figures in the first place. Unfortunately, verification is traditionally carried out manually, which can be time-consuming and makes the process hard to track and improve.
Period-end reporting has always been a challenge for all accounting departments, and this challenge grows when an organization is distributed. The cost of an extended period close in human resources is considerable, since each extra elapsed day can cost a finance department many days of labor. Period-end closing is a collaborative process of questions and answers, of confirming detailed information, and of individuals collaborating to arrive at the answer and generate a picture of numbers about the organization's current financial situation. Every organization in the world has to address this, and they all have different processes; often, financial processes across corporations vary due to merger and acquisition activity, which has absorbed different groups using different business models. This adds complexity to the task of gathering information to close the financial period, and makes it all but impossible to fully automate using conventional systems. Ironically, the aim is to ensure that accountants spend more time adding value to management and performance information, and less time "chasing" data.
The use of technology to render the process less painful, to enable people to collaborate, to progress tasks, and to automate the final postings may be of help in delivering a true, fast closing process to business. Another potential benefit is that CODA's Collaborative Close may uses only information technology (IT) infrastructure and technology that a customer likely already uses. CODA Collaborative Close uses the latest technologies and features from Microsoft Office 2003, Microsoft SharePoint Portal Server, and Microsoft Office Infopath. These, together with task modeling technology from CODA, allow CODA Close to manage approvals, exception reporting, stock reconciliations, aged debt processes, and a string of other potential bottlenecks in the period-end closing process. The application automatically generates a period-end web site through the Microsoft SharePoint Portal Server. Related links then automatically bring up InfoPath forms to gather information from different participants and to drive period-end processes, while the web site dynamically reflects data in the back-office finance system. Real time information sharing between CODA and Microsoft applications is driven through Office Research Panes in Microsoft Excel, Word, and Outlook.
It is a well-known fact that many accountants currently use Microsoft Office tools like Excel in their closing processbut in isolation. Conversely, CODA Collaborative Close integrates these tools with a wide variety of corporate finance systems to bring a unified approach to the problem, with the likely result of improved speed and control over information gathering, allowing more time for analysis and planning. The idea is to help user organizations meet the regulatory demands of the Sarbanes-Oxley Act (SOX), International Accounting Standard (IAS), Basel II, etc., and also to give finance managers more time to analyze their finance figures, and to think about and plan for the near future. CODA Collaborative Close has been designed to work with extensible markup language enabled (XML)-financial applications from vendors such as Microsoft Navision, Microsoft Great Plains, SAP, and Oracle (including PeopleSoft), as well as CODA's own CODA-Financials.
SOURCE:
http://www.technologyevaluation.com/research/articles/best-of-breed-approach-to-finance-and-accounting-18267/
Part Three of the Composing Collaborative Financial Applications, CODA series.
Among its recent endeavors, CODA has recently announced new set of financial planning and budgeting products: CODA s-Planning ("s" standing for "standard") and CODA c-Planning ("c" standing for "collaborative"), as well as a range of improved analysis and reporting tools, which will be detailed shortly. Nevertheless, to date, these corporate performance management (CPM) capabilities have targeted mainly existing customers of the CODA transactional systems. These users have focused on financial analytics, budgeting, and planning, either through Microsoft Excel integration within CODA c-Planning and CODA s-Planning, or through a partnership with Cognos for enterprise-level planning and budgeting. CODA's consolidation capabilities have traditionally been limited to the basic ones inherent in Coda-Financials. While these are adequate for simpler enterprises, the vendor has thus far been unable to successfully compete with offerings from specialists such as Hyperion Solutions, Geac (formerly Comshare), Applix, Longview, Outlooksoft, or Cartesis. Yet, the importance of these functionalities has been witnessed by Cognos' acquisition of Adaytum in 2003 and Business Objects' recent acquisition of the specialist SRC. See Financial Reporting, Planning, and Budgeting as Necessary Pieces of EPM for information on the functionality.
Thus, this merger deal should benefit both parties for many reasons. While Simple Concepts should get access to CODA's well developed global distribution channel and benefit from its financial stability, CODA should fill the financial consolidation gaps in its solution. Immediate cross-selling opportunities into CODA's install base will expand further as CODA translates OCRA into more languages. Not to mention, there are opportunities coming from OCRA's prior integration with SAP, Oracle, and other leading enterprise resource planning (ERP) solutions. The acquisition also gives CODA a base for strengthening its direct sales operation and presence in Scandinavia.
The two recent acquisitions came at the heels of CODA's June 2005 launch of a suite of add-on applications that extends the range of planning and budgeting requirements: CODA s-Planning and CODA c-Planning . These could offer more benefits for CODA-Financials users. The suite includes Version 3 of the much talked about CODA-XL application. CODA-XL allows the fairly simple and secure output, manipulation, display, sharing, and input of CODA-Financials data within Microsoft Excel. s-Planning and c-Planning were seen to enable users to carry out a range of day-to-day tasks, such as producing and sharing statutory reports; processing expenses; or even developing and setting financial budgets using CODA-Financials alongside Excel and the other familiar Microsoft Office tools that most organizations probably already have in place. These new products were meant to make CODA-Financials the launch pad for a quicker and easier budget cycle. By combining the functionality and embedded control of CODA with the familiarity and convenience of Microsoft Excel, CODA s-Planning and CODA c-Planning should streamline the seeding, preparation, manipulation, and production of budgets, based on (or update) the user's CODA-Financials data. Moreover, CODA continues to develop its relationship with Cognos, offering the Cognos Enterprise Planning product where clients have wider enterprise requirements. The vendor also uses a mix of partnership and in-house development to address other CPM elements, such as activity-based costing (ABC), strategic planning and scenario analysis, shareholder value measurement, activity monitoring, information distribution, etc.
In addition to the "standard" budgeting and forecasting facilities provided by CODA s-Planning, users have the option to make their entire cycle more coordinated, efficient, and controlled by opting for the "collaborative" add-on of the CODA c-Planning product. This interfaces with the CODA-Control process management solution, adding a facility to publish budgets as CODA-Control web sites and tasks. This will keep all participants informed and aware of the input needed and when it is required. There are also audit trails and document history to support compliance reporting. CODA c-Planning aims to help organizations set financial budgets and collaboratively develop plans, which both reflect top-down business objectives and assess the need to account for bottom-up creativity and realities. For example, it will give budget managers visibility of process bottlenecks, including vacation and sick days of department managers, information on groups waiting for information from subsidiaries, and vice versa. Conversely, many other peer products focus purely on bringing together and reporting the figures in the system, and not on collaborative processes that are key to collecting and verifying the figures in the first place. The application's aggregation features often make the budgeting and planning process quicker, more dependable, and more predictable, giving financial professionals more time to analyze and consider their overall budget before making decisions crucial to the organization's mid-term plans.
Another analytic module worth mentioning is the CODA Collaborative Scorecard, which helps user organizations link corporate goals through group objectives and individual performance. Designed to be deployed to every desktop in the enterprise, the product supports multiple performance management methodologies. Generally speaking, scorecards assist organizations in monitoring their business performance beyond bottom-line results by tracking both financial and non-financial measures, and then reporting them in a graphical user interface (GUI). A key element is the way they cascade corporate goals through the organization, helping managers to set individual objectives, and then aggregate performance results back up through the company structure, so that management can review the contributions made by individuals and groups. This aligns corporate strategy with the activities of individuals within the organization.
CODA believes that scorecards should be a strategic pillar of any analytic framework, bonding personal accountability to the enterprise's overall performance management. Initial releases of CODA Collaborative Scorecard have complied with commonly used performance management methodologies, such as the European Foundation for Quality Management (EFQM) balanced scorecard, Six Sigma, etc. to provide a relatively functional and flexible method of managing and aligning enterprise, group, business unit, and personal objectives. However, one should note that, although scorecards should be the fundamental link between personal performance and the overall objectives of the enterprise, they are frequently the weak link in the CPM closed-loop cycle, either because they are too difficult to deploy widely in the organization, or because they have fixed, inflexible methodology (see Why Most Balanced Scorecards are Subverted).
Related to the above line of products is CODA Analytic Explorer, which is a business intelligence (BI) tool that allows CODA users to carry out multidimensional browsing across CODA-Mart and any other relational data source. It is a generic, on-line browsing tool with both two-dimensional and multidimensional browsing capabilities built in, and has a separately licensable cube builder that provides extra performance. As finance departments struggle to add value to their businesses, performance management enables them to deliver better decisions more efficiently. However, CPM is not about static plans that sit on the shelf and get dusted off at board meetings, but rather about continuously adjusting to the range of inputs that the business is constantly receiving. To that end, CODA Analytic Explorer provides the ability to investigate exceptions and trends quickly and easily, so that corrective actions can be taken, and forecasts and plans reviewed.
CODA-XL is now in its third release. It provides a two-way bridge between Excel, which is indisputably the most popular spreadsheet, and CODA's enterprise-level financial and CPM products. CODA-XL was launched in 2003 and brings the familiarity of the Excel interface to CODA-Financials. It should provide customers with several benefits, such as reduced training for end users of CODA-Financials during implementation. Other benefits typically include the elimination of transcription errors and file-handling overheads during the transfer of data between CODA-Financials and Excel. Thus, it may prevent the proverbial "islands of information," where local systems containing great value and insight are locked on individuals' desktops and personal computers and cannot be shared across the organization. However, unlike some similar products from competitors, CODA-XL goes beyond exploiting the familiarity of the user interface (UI) and makes use of the success that Excel enjoys as an informal business modeling and planning tool. It provides "What If?" scenario testing with the option of writing back from the spreadsheet to CODA-Financials. For example, the CODA Security Model is fully embedded within CODA-XL, thus ensuring consistent data security. This means that while add-ins to Excel deliver rich CODA functionality accessed directly from the Microsoft Office desktop, they must respect the same CODA security, validation, and business rules. For example, Excel formulas referencing live account balances are stored directly in CODA Database, with all necessary authorizations for users appearing down to the spreadsheet cell level. For more on the advantages and the inherent risks of Excel-based tools, see Vendors Harness Excel (and Office) to Win the Lower-end of Business Intelligence Market.
Within CODA e-Finance (a Web-based version of the product), all reports validated and cross-checked on-line to validate, to eliminate separate, unsecured reporting tables. "Lights out" scheduling and Web document publishing also eliminate manual intervention. In addition, the data manipulation capabilities of Excel mean that management accountants can build and model scenarios that can be tested against real data relatively quickly, which can be very useful for creditor and debtor management, customer profitability analysis, and ad hoc queries. Furthermore, US Security and Exchange Commission (SEC) submissions can be made through Microsoft Word documents with embedded "live" Excel documents that do not have cut and paste, export, and manipulation functions, which can introduce the potential for errors. Non-programmatic, wizard-driven automation of data entry with real time validation direct from Excel (transactions, allocations, masters, budgets, and forecasts) also eliminates open database connectivity (ODBC), direct structured query language (SQL) updates, relational database management systems (RDMBS) logons, etc., which are also points of risk.
Last but not least along collaboration lines, CODA Collaborative Close is yet another application built using Microsoft Office technologies, one that is designed to help organizations close their books more quickly, more dependably, and more predictably, giving financial professionals more time to analyze and consider data before making crucial decisions. The product was designed to recognize and support the neglected collaborative processes that underpin period close. Other products in this area focus merely on consolidating and reporting the finance figures, but not on collaborative processes that are key to collecting and verifying the figures in the first place. Unfortunately, verification is traditionally carried out manually, which can be time-consuming and makes the process hard to track and improve.
Period-end reporting has always been a challenge for all accounting departments, and this challenge grows when an organization is distributed. The cost of an extended period close in human resources is considerable, since each extra elapsed day can cost a finance department many days of labor. Period-end closing is a collaborative process of questions and answers, of confirming detailed information, and of individuals collaborating to arrive at the answer and generate a picture of numbers about the organization's current financial situation. Every organization in the world has to address this, and they all have different processes; often, financial processes across corporations vary due to merger and acquisition activity, which has absorbed different groups using different business models. This adds complexity to the task of gathering information to close the financial period, and makes it all but impossible to fully automate using conventional systems. Ironically, the aim is to ensure that accountants spend more time adding value to management and performance information, and less time "chasing" data.
The use of technology to render the process less painful, to enable people to collaborate, to progress tasks, and to automate the final postings may be of help in delivering a true, fast closing process to business. Another potential benefit is that CODA's Collaborative Close may uses only information technology (IT) infrastructure and technology that a customer likely already uses. CODA Collaborative Close uses the latest technologies and features from Microsoft Office 2003, Microsoft SharePoint Portal Server, and Microsoft Office Infopath. These, together with task modeling technology from CODA, allow CODA Close to manage approvals, exception reporting, stock reconciliations, aged debt processes, and a string of other potential bottlenecks in the period-end closing process. The application automatically generates a period-end web site through the Microsoft SharePoint Portal Server. Related links then automatically bring up InfoPath forms to gather information from different participants and to drive period-end processes, while the web site dynamically reflects data in the back-office finance system. Real time information sharing between CODA and Microsoft applications is driven through Office Research Panes in Microsoft Excel, Word, and Outlook.
It is a well-known fact that many accountants currently use Microsoft Office tools like Excel in their closing processbut in isolation. Conversely, CODA Collaborative Close integrates these tools with a wide variety of corporate finance systems to bring a unified approach to the problem, with the likely result of improved speed and control over information gathering, allowing more time for analysis and planning. The idea is to help user organizations meet the regulatory demands of the Sarbanes-Oxley Act (SOX), International Accounting Standard (IAS), Basel II, etc., and also to give finance managers more time to analyze their finance figures, and to think about and plan for the near future. CODA Collaborative Close has been designed to work with extensible markup language enabled (XML)-financial applications from vendors such as Microsoft Navision, Microsoft Great Plains, SAP, and Oracle (including PeopleSoft), as well as CODA's own CODA-Financials.
SOURCE:
http://www.technologyevaluation.com/research/articles/best-of-breed-approach-to-finance-and-accounting-18267/
No comments:
Post a Comment