HomeHome SearchSearch MenuMenu Our productsOur products

Are you an accountant? Here are the two disadvantages of using Excel spreadsheets

by , 28 February 2014
Almost everything has its disadvantages. This goes for Excel spreadsheets as well. Here are the two drawbacks to using Excel spreadsheets if you're an accountant.

The two disadvantages of using Excel spreadsheets exposed

In this article, we gave you the three benefits of using Excel spreadsheets if you're an accountant.

Now there's no denying that Excel spreadsheets have changed the 'accounting game', but we believe you should consider some of the disadvantages they come with.

Disadvantage #1: Excel spreadsheets are NOT a database

According to Az Central, users often set up spreadsheets as databases, not realising that spreadsheets work poorly in that capacity.

Excel spreadsheets have a row-and-column format very similar to a table in a database, but they're not suited to storing large amounts of information or managing it as effectively as a database.

While Excel spreadsheets are handy for up to a few hundred items, a spreadsheet becomes cumbersome for thousands or more.

#2: Excel spreadsheets do NOT provide an audit trail

As you know, audit trails are an important means of preserving the integrity of data. But the downside is that a spreadsheet programme doesn't have audit trails for data or formulas. It simply updates the file with new information.

The site adds that that 'although several people may have had a hand in creating a spreadsheet, you can't identify who worked on specific parts just by looking at it. The file has a modify date, but doesn't tell you the history of specific items within the spreadsheet.'

What's the verdict on Excel spreadsheets?

Everything has its pros and cons and, as with everything in life, you must be cautions. Giving you the good and the bad regarding Excel spreadsheets will help you make an informed decision.

'Spreadsheet users must take care to check their formulas and use data from appropriate sources,' says Az Central.

Enjoyed this article? Subscribe to receive these free articles in your inbox daily.



Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>