Remember Me
forgot your password?

Is This the End for Spreadsheet Based Reconciliation Certification, Tracking, Control and Compliance?

Since the well publicised events surrounding the collapse of Barings Bank, Enron, WorldCom, and other high-profile financial disasters – both in the US and internationally - an increasing array of legislation has been put in place to try to mitigate the future risk of a repeat of these catastrophic (in the business context) events.

In the US, the Sarbanes Oxley Act of 2002 demanded a much greater level of accountability for Directors and in the UK, similar demands of business stakeholders were made through the Combined Code on Corporate Governance originally published in 1998 (revised 2003) and in the revised Companies Act 2006.

The result has been a significant increase in corporate cost, both in terms of in-house operational and management costs as well as external Audit, Consultancy and other specialist fees to achieve and maintain compliance. A substantial portion of this cost has been as a result of defining and implementing additional, time-consuming (and often manual), control processes, review structures, and certification processes all geared toward the provision of documentary evidence of control around the processes organisations already had in place. Having achieved compliance first time round, the number of organisations electing to replace these manual control processes with technological, best of breed, process automation and improvement tools has increased significantly. Few more so than in the area of GL account control, reconciliation and certification.

Today, the vast majority of organisations world-wide still rely heavily on (Excel) Spreadsheets to manage this critical process. Spreadsheets are used to accept a download of accounts from the GL; to track responsibility for ownership of the reconciliation and review; to track the completion of the reconciliation, review, and sometimes Approval, of each reconciliation; to track queries (open reconciling items); and to attempt to aggregate the value and categorisation of those open reconciling items for the purposes of assessing materiality.

Specialist (Web-based) tools for the automation of the GL account certification process have been developed (resulting in the elimination of Spreadsheets from the process). These tools are comprehensive, encompassing reconciliation preparation, review/approval, quality assurance testing (Audit), aggregation of open reconciling items, reporting and improved program management. The solutions are starting to make major inroads in helping organisations with thousands (to hundreds of thousands) of GL accounts to finally take complete control of the process - whilst driving real monetary benefit through efficiency and time-saving at the same time as ensuring compliance.

Organisations with a distributed National or International infrastructure are particularly well suited to this type of Web-based technology that provides for global visibility into the status of the reconciliation program.

For more information contact Ted Sparrey.

Ted Sparrey

Ted Sparrey is a UK Sales Professional who specializes in helping UK Finance Professionals to reduce costs, manage risk, increase efficiency and ensure compliance in the areas of GL/Balance-Sheet Reconciliations, Spreadsheet Controls and SOX compliance. Contact me for more details of recommended technology solutions. email: ted.sparrey@supaworld.com

Rate this Article: 5 / 5 stars - 6 vote(s)
Print Email Re-Publish


Article Source: http://www.articlesbase.com/regulatory-compliance-articles/is-this-the-end-for-spreadsheet-based-reconciliation-certification-tracking-control-and-compliance-175957.html

  • Latest Regulatory Compliance Articles
  • More from Ted Sparrey

Liability Lawyers Help Protect Consumers

By: P. Macneil | 02/07/2009
In my experience, the general public has no idea how much the legal profession contributes to their safety, including as users and consumers of products.

Drug Testing, State Laws, Workers Compensation: Do It Right or Suffer the Consequences

By: Robert Elliott, J.D. | 01/07/2009
State laws and drug testing in the workplace and workers compensation. Follow state laws to avoid problems.

Preliminary Name Searches versus Corporate Searches

By: Holly Crosgrey | 23/06/2009
Explains what preliminary name searches are and why they are done with a comparison of the difference between a preliminary name search and a corporate search for Canadian companies.

Work Accidents: When do you need to report an accident at work?

By: Jessica Parker | 19/06/2009
Employers and self-employed people, as well as people in control of premises, must legally report certain types of accident to the Incident Contact Centre of the Health and Safety Executive (HSE).

The Rules of Redundancy

By: Victoria Cochrane | 19/06/2009
It pays to be informed, whatever the situation. Stay on top of employment relations by keeping yourself up to speed with redundancy rules and regulations and how they affect you, whether you are an employee or employer.

ASIAN GARMENT INDUSTRY RATTLED BY MARKET SITUATION

By: Mallikarjuna N.L. | 14/06/2009
As American countries to head towards a recession, many will begin to question exactly how the garment industry affected by global trade in near future. The US has recently found itself approaching what some economics fear could be the next recession and its impacting many industries negatively in terms of profit and human capital

Landlords Should Choose Their Words Carefully

By: Daniel Butler | 10/06/2009
If a tenant asks for your consent think twice before responding with phrases such as “in principle” and “subject to licence”.

How to Improve Corporate Governance in China with Online Training

By: Alex Raymond | 10/06/2009
Online training (e-learning) is a powerful tool to improve corporate governance. Here are 5 ways that e-learning can help improve corporate governance and lead to China SOX compliance.

Spreadsheet Risk Management and Compliance

By: Ted Sparrey | 24/07/2007 | Regulatory Compliance
Following the advent of Sarbanes Oxley and other financial controls and corporate governance legislation, companies identified risks inherent in their use of Spreadsheets for critical financial reporting processes. Find out here what they have done and what you can do to mitigate these risks.

Submit Your Articles Free: Signup


Article Categories




Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2008 Free Articles by ArticlesBase.com, All rights reserved. (0.27, 7)