- Practice
- About 16 min
- 5 practice questions
Computerised accounting system: applications, reports and data exchange
Explain what a computerised accounting system is, list its applications, describe automated accounting, classify accounting reports and the steps to design one, and explain data exchange between information systems.
If something looks wrong, please tell us.
By the end of this lesson you can
- Define a computerised accounting system (CAS) and state its six applications given in the book.
- Explain how automated accounting differs from entering the same transaction in several books by hand.
- Separate routine reports from special purpose reports, list the steps in designing a report, and explain why the accounting information system exchanges data with other systems.
In Class 11 you recorded transactions by hand: journal, subsidiary books, ledger, trial balance and final accounts, each copied from the one before. A growing business with hundreds of transactions a day cannot keep up that way. A computerised accounting system (CAS) maintains accounts using computers: transactions are the input, accounting software processes them, and accounting records and reports are the output.
How a computerised accounting system works
- Input Accounting transactions entered once, through vouchers
- Processing Software posts them to every related record
- Storage Records kept on the computer, easy to retrieve
- Output Day books, ledgers, trial balance, final accounts and other reports
Applications of CAS
| Application | What CAS does |
|---|---|
| Maintaining accounting records | Keeps records easily and efficiently for a long time, needs little physical space, and retrieves data quickly and accurately |
| Inventory management | Identifies fast moving, slow moving and obsolete stock and gives up-to-date stock levels instantly |
| Payroll preparation | Records attendance, works out pay by time worked or units produced, and makes deductions such as provident fund and income tax |
| Report generation | Produces routine and special purpose reports |
| Data import and export | Brings data in from, and sends data out to, users inside and outside the organisation |
| Taxation | Computes taxes, deducts them and helps deposit them to the Government account |
Automated accounting
Automated accounting keeps accounting records up to date with the help of accounting software. In a manual system the same transaction is written in several books: the journal or a subsidiary book, then each ledger account. In an automated system the transaction is entered once, in one place, and the software automatically relates it to all the other records it affects. A single credit sale entered once updates the customer's account, the sales account, the trial balance and the final accounts together.
Accounting reports
An accounting report is a compilation of information drawn from the accounting records. Reports are either routine or special purpose.
Two kinds of accounting report
-
Routine reports
- Day books or journal
- Ledger
- Trial balance
- Income statement
- Balance sheet
- Cash flow statement
-
Special purpose reports
- Any report other than the routine ones
- Prepared to suit the needs of a particular user
- Example: dues from customers in one district, for the sales manager
The book gives three steps in designing an accounting report:
- Define the objective of the report: who needs it and for what decision.
- Specify the structure of the report: its columns, totals and order.
- Create database queries that interact with the database to retrieve, modify, add or delete the data the report needs.
Data exchange with other information systems
A Management Information System (MIS) provides information for decisions at all levels of management. It includes the manufacturing, marketing, human resource and accounting information systems. The Accounting Information System (AIS) collects financial data, processes it and gives information to users. It cannot work alone: it needs data from the other systems, and they need data from it. Data exchange among them is therefore unavoidable.
Management Information System and its parts
- Manufacturing information system Supplies, for example, hours worked and units produced
- Marketing information system Supplies sales orders and customer data
- Human resource information system Supplies staff details, attendance and pay rates
- Accounting information system Uses all of these to record, value and report; sends cost and budget data back
Worked example 1: where do the wage figures come from?
A made-up garment unit in Tiruppur must pay weekly wages. Working: the AIS needs (1) each worker's attendance and wage rate from the human resource information system, and (2) hours worked or pieces stitched from the manufacturing information system. With these, CAS computes gross pay, makes deductions such as provident fund, and records the wages. This is exactly the book's example of data exchange: wages cannot be computed from accounting data alone.
Worked example 2: routine or special purpose?
Classify these reports a made-up firm prints: (a) the trial balance at the end of March; (b) a list of customers who have owed money for more than 90 days, asked for by the credit manager; (c) the balance sheet; (d) a comparison of fuel costs of each delivery van, asked for by the transport head. Working: routine reports are the standard ones prepared regularly for everyone; special purpose reports are prepared for a particular user's need. So (a) and (c) are routine; (b) and (d) are special purpose.
Key takeaways: CAS turns transactions (input) into records and reports (output) through software. Its applications include records, inventory, payroll, reports, data import and export, and taxation. Automated accounting enters a transaction once and updates every related record. Reports are routine or special purpose, and the AIS constantly exchanges data with the other parts of the MIS.
Check your understanding
-
1. In a computerised accounting system, accounting transactions are:
- the output
- the input
- the hardware
- the final report
Show answer
Answer: B. CAS takes accounting transactions as inputs, processes them through software and generates reports as output.
-
2. Which is a special purpose report?
- Trial balance
- Ledger
- A list of slow-paying customers prepared for the credit manager
- Balance sheet
Show answer
Answer: C. A special purpose report is any report other than the routine reports, prepared to suit a particular user's requirement.
-
3. The main feature of automated accounting described in the book is that:
- a transaction is entered once and the software relates it to all relevant records
- no accountant is needed
- only cash transactions are recorded
- each book is kept in a separate program
Show answer
Answer: A. Accounting software allows entry in one field or place and automatically updates all related records, unlike the manual system of writing several books.
-
4. Identifying fast moving, slow moving and obsolete stock is which application of CAS?
- Payroll preparation
- Taxation
- Data import and export
- Inventory management
Show answer
Answer: D. CAS supports inventory management by identifying such items and giving instant information about stock levels.
-
5. To compute wages, the accounting information system needs data mainly from:
- the marketing information system only
- the manufacturing and human resource information systems
- the balance sheet of the previous year
- the bank statement
Show answer
Answer: B. The book's example: the AIS needs data from the manufacturing and human resource information systems to compute wages.
Sign in to keep track of the lessons you finish.