Definition

spreadsheet controls

Spreadsheet controls are a set of steps that an organization's accounting personnel can take to ensure accuracy and integrity of financial records and bookkeeping procedures. Achieving and maintaining effective spreadsheet control involves an ongoing effort to quickly identify and resolve errors and maintain the security of all information.

No matter how sophisticated and robust the hardware and software for a spreadsheet control system might be, it can work properly only when personnel receive thorough training. Long-term learning plans and frequent refresher seminars can keep employees informed and educated in the latest operational features. An effective spreadsheet control program should provide:

  • User access control including usernames, passwords, and biometric verification.
  • Up-to-date and complete roster of authorized users.
  • Access restrictions on cells that perform critical computations.
  • Strong encryption of critical data.
  • Accuracy checks for outgoing information.
  • Accuracy checks for incoming information.
  • Regular network hardware maintenance.
  • Cross-referencing and checksum processes to prevent data loss or corruption.
  • Thorough testing of new spreadsheet functions and features.
  • Incremental backup and scheduled archiving.
  • Offsite storage provisions.
  • Backup and archiving redundancy and use of multiple media types.
  • Pre-planned data recovery procedure.
  • Flexibility and ease of use.

This was last updated in March 2012
Posted by: Margaret Rouse

Email Alerts

Register now to receive SearchFinancialApplications.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Do you have something to add to this definition? Let us know.

Send your comments to techterms@whatis.com

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: