Spreadsheets are a wonderful planning and financial analysis tool, but a simple mistake can throw off a budget or expense tally costing companies thousands or even millions of dollars. Also, without proper controls, spreadsheets can be manipulated for personal gain or other criminal behavior.
A number of solutions have emerged to help keep spreadsheets under control so companies can track data entry and adhere to their own business rules as well as government regulations, such as Sarbanes-Oxley.
As with Microsoft, ClusterSeven's relationship with Google is independent. The search giant recommends third party program's like Enterprise Spreadsheet Manager to corporate clients who want more features than Google's own integrated set of applications provide.
"When we talk to corporate accounts about on-line spreadsheet collaboration, we often get asked about visibility and control over those collaborations," said Scott McMullan, Google Apps Partner Lead for Google Enterprise, in a statement. "ClusterSeven builds on our standard controls to provide a solution that has solved the additional demands of some of some of the world's premier financial institutions."
Enterprise Spreadsheet Manager checks entries against business rules set by the company without any slow down or impact on the user, the company said. Business rules could include adherence to Sarbanes-Oxley compliance regulations and basic security measures to insure no one can benefit personally from what they enter.
Depending on how Spreadsheet Manager is implemented, a designated manager(s) is alerted by e-mail or SMS text message when a rule is broken or conflict arises with a spreadsheet entry. For simple, less critical issues, the user is simply alerted when a mistake, conflict or something counter to company policy is entered.
"We primarily adopt a detective mode like a security camera," Ralph Baxter, senior vice president for product development at ClusterSeven told InternetNews.com. "We don't stop anyone, but we do send alerts when there's an issue and provide companies with a fully auditdable view of each spreadsheet."