Uses and advantages and disadvantages of computers in accounting
Traditionally accounts were kept by the means of handwritten record. Computers have only begun to be used in some of the functions of accounting over the last fifteen years or so. As computers became cheaper, easier to use, and more powerful, more firms have decided to computerise their own accounting records. However, some firms, (albeit a declining number) still prefer to use handwritten accountings. This leads us to believe that there must be reasons for and against using computers in accounting.
What we need to consider here is how computers are used in accounting, and then we should be able to evaluate the potential uses and limitations of using computers in accounting.
How are computers used in accounting?
Most firms will make some use of a computer within accounting at some point. Some firms will have all their accounting performed by computers. What we need to understand is how the computer can be used.
Spreadsheets
A computer-generated spreadsheet is commonly used by firms when presenting their accounts. A simple spreadsheet will appear as a grid to which both numbers and text can be inserted. Each 'cell' of the spreadsheet can be used to insert data. A typical spreadsheet will appear as follows:
2000
2001
2002
2003
£
£
£
£
Sales
25,000
27,500
29,750
32,000
Cost of goods sold
13,000
14,500
16,900
17,500
Gross profit
12,000
13,000
12,850
14,500
One of the attractions of using a spreadsheet is that the calculations can be done by the computer. Some data, such as sales and cost of goods sold would need to be manually typed in, but then the gross profit can be automatically calculated by inserting a formulae into the relevant 'cell' which states how the profit is to be calculated, Once inserted then the formulae can apply to the whole row (or whole column) which makes the process both easier and more less likely