How to spot a "phishing" email
Survival rates for new businesses drop
The end of the tax return?
5 steps to creating the perfect business document
Is it time to go paperless?
Tax rates and thresholds for 2016/17: get ready for the new tax year
Which website style is right for your business?
What every small business should know about going digital
How can we help? Free information to help you break free from the jargon
Discover what the rest of the world can see about you: Does your private address stay private online?
Taking your business to the next level: why management reporting matters
Why a business address with Whitehill might make sense for you
Six marketing skills every business needs to know in 2016
Pensions autoenrolment: what you need to know
Changes to salary and dividend tax rules from April 2016
5 tax changes affecting small businesses in April 2016
The basic requirements for setting up your business.
5 Reasons Why You Need a Professional Mailbox Address
Five things for small business owners to know about the 5G Network
Why the right business structure is important
Top tips for starting a business
Five tips for success
Do you need a business bank account?
Four things that could help your small business get paid quicker
Management reports - the missing support?
Launch of new Excel tools
What's the point in cold-calling?
UK Leads the Way in Start-Up Job Creation
Small Businesses Urged to Engage Older Workers
Do Small Businesses Lack Digital Skills?
Are Small Businesses Scared of Auto-Enrolment?
Is your small business 'recognised' or 'invisible'?
Budget summary
UK Small Businesses Expect Turnover Increase
2 in 5 People Seek to Start a Business
Increasing Costs for Small Businesses
Early settlement discounts - if you're VAT registered you need to read this...
Introducing Swiftmail!
What's the best mix of salary and dividends for 2015/16? Some factors to consider.
New scam for tax return - information and details
Small Businesses Predict Expansion in 2015
Triple Bottom Line: Our Promise to You
Pension auto-enrolment
UK Tax rates for 2015/16 - part 1: Personal tax
Has technology given small businesses an advantages over larger firms?
Small Business Branding - Dos and Don'ts!
Are British employees less productive away from their desks?
UK Set to Overtake Germany's Economy
Would Graduates Rather Go It Alone Than Become Employees?
How do I leave my day job and start my own business?
Small Businesses Fail to Take Advantage of Social Media - npower survey
Apple's Business Tips
20 principles for spreadsheets
Whitehill staff receive full signoff from Xero to offer Xero across the UK
Where can I go for information on pensions?
Technology - where next?
HMRC continues to warn taxpayers to be aware of the problem of fraudulent phishing emails
Tax info: tax free limit for employer loans is doubled
Whitehill publish white paper on cloud accounting packages
It's official: People like small businesses
Quickbooks Cloud - Whitehill achieve certified status
HMRC to monitor credit and debit card transactions
Moving to the Cloud
Red tape cuts - latest from the UK Government
The new Employment Allowance - what does it mean?
New article in Talk Business magazine - "Bookkeeping - cutting costs"
Budget - March 2014. Read a summary here
Whitehill Business Services Ltd >> news >> latest news >> 20 principles for spreadsheets

20 principles for spreadsheets

Posted by admin on July 18, 2014

The Chartered Accountants organisation ICAEW this week launched its ‘Twenty principles for good spreadsheet practice’ guide after months of collaborative work among the profession’s tick.jpgleading Excel experts.

The guide is intended as a framework “to instil attitudes” and encourage best practice."

The 20 principles are;

  1. Determine what role spreadsheets play in your business, and plan your spreadsheet standards and processes accordingly.
  2. Adopt a standard for your organisation and stick to it.
  3. Ensure that everyone involved in the creation or use of spreadsheets has an appropriate level of knowledge and competence.
  4. Work collaboratively, share ownership, peer review.
  5. Before starting, satisfy yourself that a spreadsheet is the appropriate tool for the job.
  6. Identify the audience. If a spreadsheet is intended to be understood and used by others, the design should facilitate this.
  7. Include an ‘About’ or ‘Welcome’ sheet to document the spreadsheet.
  8. Design for longevity.
  9. Focus on the required outputs.
  10. Separate and clearly identify inputs, workings and outputs.
  11. Be consistent in structure.
  12. Be consistent in the use of formulae.
  13. Keep formulae short and simple.
  14. Never embed in a formula anything that might change or need to be changed.
  15. Perform a calculation once and then refer back to that calculation.
  16. Avoid using advanced features where simpler features could achieve the same result.
  17. Have a system of backup and version control, which should be applied consistently within an organisation.
  18. Rigorously test the workbook.
  19. Build in checks, controls and alerts from the outset and during the course of spreadsheet design.
  20. Protect parts of the workbook that are not supposed to be changed by users.

you can read the full report here.  If you need spreadsheet updating, linking or creating, get in touch and we'll get it sorted for you!