Control Frameworks for End User Computing Spreadsheets
Do you use Excel workbooks to support your financial reporting needs?
If so, you'll appreciate that Microsoft Excel offers the flexibility and ease-of-use of a desktop application combined with the power to perform complex analysis and calculations. But regulatory pressures are now demanding that workbooks be managed within a compliance framework supporting managed development, auditing, versioning, change control and timely reporting.
Using SharePoint 2007, Excel, Excel Services and Outlook the Rule Financial solution supports compliance activities for regulations including Sarbanes Oxley, the Data Protection Act and Basel II. It provides secure storage of EUC (End User Computing) spreadsheets with a full audit trail so changes can be tracked.
These might include:
-
Audit workbook ‘difference' – Changes in used range (column/row count), Functions, Creating, editing & deleting, Worksheets, Adding and removing
-
Cell level auditing: Cell protection, Lock/unlock, Audit critical areas, Changes to cell values
-
Lifecycle management: New EUC and change request, Build, Test, QA, Deployment sequence, Permissions and access, Identify period end version, Renaming and Archiving
-
Workbook quality assurance: UI, VBA, Functions & Charts, Links & References, Workbook Metrics, macro routines, Lines of code, % Cells with errors and % Unprotected formulae
Click to enlarge