{"id":183,"date":"2007-01-22T11:30:10","date_gmt":"2007-01-22T19:30:10","guid":{"rendered":"http:\/\/www.formtek.com\/blog\/?p=183"},"modified":"2007-01-22T11:30:10","modified_gmt":"2007-01-22T19:30:10","slug":"compliance-bpm-and-the-evolving-spreadsheet","status":"publish","type":"post","link":"https:\/\/formtek.com\/blog\/compliance-bpm-and-the-evolving-spreadsheet\/","title":{"rendered":"Compliance:  BPM and the evolving Spreadsheet"},"content":{"rendered":"<p>Twenty-five years ago the introduction of the spreadsheet defined the term &#8220;<a title=\"Killer Application\" href=\"http:\/\/en.wikipedia.org\/wiki\/Killer_application\" target=\"_blank\">killer application<\/a>&#8220;.\u00a0 Since then, <a title=\"Spreadsheet\" href=\"http:\/\/en.wikipedia.org\/wiki\/Spreadsheet\" target=\"_blank\">spreadsheets<\/a> have become the centerpiece of financial reporting, budgeting, planning, and forecasting.\u00a0 <a title=\"78% of finance companies\" href=\"http:\/\/www.computerweekly.com\/Articles\/2006\/12\/11\/220519\/finance-teams-need-to-kick-the-spreadsheet-habit.htm\" target=\"_blank\">78% of companies<\/a> still rely on the spreadsheet as their main tool for financial reporting.\u00a0 Many companies are basically run on Excel.<\/p>\n<p>But Compliance, particularly Sarbanes-Oxley, is causing companies to rethink spreadsheets.\u00a0\u00a0\u00a0Problems with traditional spreadsheets include:<\/p>\n<ol>\n<li>Spreadsheets can&#8217;t capture real-time data<\/li>\n<li>They don&#8217;t scale well and lack good tools for collaboration between many users.<\/li>\n<li>Consolidation or &#8220;rolling up&#8221;\u00a0of multiple spreadsheets is often difficult and time-consuming<\/li>\n<li>Lack of auditing and revision control.\u00a0<\/li>\n<ul>\n<li>Who changed what and when?<\/li>\n<\/ul>\n<li>Error prone.\u00a0 As many as <a title=\"Spreadsheet errors\" href=\"http:\/\/www.pwc.com\/extweb\/ncpressrelease.nsf\/docid\/A7725D67014E964A802570B90049C289\" target=\"_blank\">90% of spreadsheets<\/a> might have errors.<\/li>\n<ul>\n<li>Interface Errors (for example, incorrect links to other spreadsheets)<\/li>\n<li>Logic Errors<\/li>\n<li>User\/Human Error (for example, accidently changing data for formulas, or incorrect input)<\/li>\n<\/ul>\n<li>Not Time-efficient.\u00a0 68% of large companies take 2-3 months to complete their annual budget and 25% of that time is related to creating and processing spreadsheets.<\/li>\n<li>Process controls are lacking.\u00a0 No real concept of review and approval of spreadsheet design or data.<\/li>\n<li>Spreadsheets are often not treated as business records<\/li>\n<\/ol>\n<p>Simplicity is the main reason for the continued success of the spreadsheet.\u00a0 Another reason that they&#8217;ve succeeded is the lack of a need for rigorous controls.\u00a0 Spreadsheets have empowered financial groups, bypassing the control of IT.<\/p>\n<p>But Sarbanes-Oxley is demanding more rigorous control over\u00a0handling of spreadsheets.\u00a0 Section 404 requires that internal controls and procedures be established in managing financial reporting and also for accessing the effectiveness of those controls.<\/p>\n<p>Policies and procedures for auditing changes are slowly being adopted to comply with regulations.\u00a0 The newly released Microsoft Excel 2007 was <a title=\"Microsoft Excel and Compliance\" href=\"http:\/\/download.microsoft.com\/download\/8\/d\/7\/8d7ea200-5370-4f23-bdca-ca1615060ec4\/Excel%20Regulatory%20White%20Paper_Final0424.doc\">designed<\/a> to address some of the compliance issues.<\/p>\n<p>But what also is happening is that BPM vendors see that while they have the tools and processes needed to address many of the deficiencies of spreadsheets, their tools\u00a0to-date have not been widely adopted.\u00a0<\/p>\n<p>In the short term, BPM vendors are\u00a0fighting back by\u00a0<a title=\"BPM and Spreadsheets\" href=\"http:\/\/www.cfo.com\/article.cfm\/3860298?f=related\" target=\"_blank\">embracing<\/a> and integrating spreadsheet functionality\u00a0as part of their solutions.\u00a0 And, more often than not, BPM vendors have selected to integrate tightly with Excel.\u00a0 But longer-term, vendors continue to try to promote the more robust\u00a0capabilities of BPM.\u00a0\u00a0<a title=\"BPM at a tipping point\" href=\"http:\/\/www.cio-today.com\/story.xhtml?story_id=1020061OXN8I\" target=\"_blank\">Key among those capabilities<\/a> is the ability to\u00a0create a single auditable and accurate source of financial information.\u00a0 The obstacle for BPM vendors contiunues to be the need to capture\u00a0the same kind of\u00a0simplicity and intutiveness in usability that has made spreadsheets so successful.<\/p>\n<div class=\"lightsocial_container\"><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/digg.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/digg.png\" alt=\"Digg This\" title=\"Digg This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.reddit.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/reddit.png\" alt=\"Reddit This\" title=\"Reddit This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.stumbleupon.com\/submit?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F&amp;title=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/stumbleupon.png\" alt=\"Stumble Now!\" title=\"Stumble Now!\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/buzz.yahoo.com\/buzz?targetUrl=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F&amp;headline=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/yahoo_buzz.png\" alt=\"Buzz This\" title=\"Buzz This\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dzone.com\/links\/add.html?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dzone.png\" alt=\"Vote on DZone\" title=\"Vote on DZone\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.facebook.com\/sharer.php?t=&amp;u=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/facebook.png\" alt=\"Share on Facebook\" title=\"Share on Facebook\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/delicious.com\/save?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/delicious.png\" alt=\"Bookmark this on Delicious\" title=\"Bookmark this on Delicious\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.dotnetkicks.com\/kick\/?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetkicks.png\" alt=\"Kick It on DotNetKicks.com\" title=\"Kick It on DotNetKicks.com\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/dotnetshoutout.com\/Submit?title=&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/dotnetshoutout.png\" alt=\"Shout it\" title=\"Shout it\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.linkedin.com\/shareArticle?mini=true&amp;url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F&amp;title=&amp;summary=&amp;source=\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/linkedin.png\" alt=\"Share on LinkedIn\" title=\"Share on LinkedIn\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.technorati.com\/faves?add=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/technorati.png\" alt=\"Bookmark this on Technorati\" title=\"Bookmark this on Technorati\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/twitter.com\/home?status=Reading+https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/twitter.png\" alt=\"Post on Twitter\" title=\"Post on Twitter\" \/><\/a><\/div><div class=\"lightsocial_element\"><a class=\"lightsocial_a\" href=\"http:\/\/www.google.com\/buzz\/post?url=https%3A%2F%2Fformtek.com%2Fblog%2Fcompliance-bpm-and-the-evolving-spreadsheet%2F\" target=\"_blank\"><img decoding=\"async\" class=\"lightsocial_img\" src=\"https:\/\/formtek.com\/blog\/wp-content\/plugins\/light-social\/google_buzz.png\" alt=\"Google Buzz (aka. Google Reader)\" title=\"Google Buzz (aka. Google Reader)\" \/><\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Twenty-five years ago the introduction of the spreadsheet defined the term &#8220;killer application&#8220;.\u00a0 Since then, spreadsheets have become the centerpiece of financial reporting, budgeting, planning, and forecasting.\u00a0 78% of companies still rely on the spreadsheet as their main tool for<span class=\"ellipsis\">&hellip;<\/span><\/p>\n<div class=\"read-more\"><a href=\"https:\/\/formtek.com\/blog\/compliance-bpm-and-the-evolving-spreadsheet\/\">Read more &#8250;<\/a><\/div>\n<p><!-- end of .read-more --><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,9],"tags":[],"class_list":["post-183","post","type-post","status-publish","format-standard","hentry","category-business-process-management","category-compliance"],"_links":{"self":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":0,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/posts\/183\/revisions"}],"wp:attachment":[{"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/media?parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/categories?post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/formtek.com\/blog\/wp-json\/wp\/v2\/tags?post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}