A retail chain's sales are keyed at tills in 40 shops, transmitted to head office, processed overnight and posted to the ledger. Purchase orders go to suppliers electronically. Customers order on a website and pay by card. There is no paper trail from the till to the ledger, and no clerk can see a transaction in flight. The auditor cannot follow invoices through a filing cabinet.
The audit must follow data through networks, so the auditor needs to know what each type of system risks and what controls to expect.
This topic covers the audit risks and controls of four kinds of system that need special attention: microcomputer systems, online systems, electronic data interchange (EDI) and e-commerce, together with information security measures. The earlier topic on control activities covered general and application controls, and the next topic covers tests of controls.
In 30 seconds
Microcomputer systems: desktop machines, hard to secure physically; wide access; user-written programs; need documentation. Online systems: immediate processing; strong access controls, programming controls, transaction logs (audit trail), firewalls, pre-processing authorisation, validation checks and balancing. EDI: no paper audit trail; dependence on systems; data loss or corruption; security risks; controls are encryption, acknowledgements, authentication, output checks, virus protection and contingency plans.
E-commerce: skills, business knowledge, transaction integrity, accounting policy and legal risks, weak audit trail.
Key terms in plain English
| Term | What it means |
|---|---|
| Microcomputer system | A system of desktop computers |
| Online system | A system with direct access to central data through terminals |
| EDI | Electronic data interchange of business documents |
| Audit trail | The ability to trace a transaction through all stages |
| Encryption | Turning data into code for transmission |
| Firewall | A device that blocks unauthorised access to a network |
Syllabus check
This topic is in syllabus area B, the nature and use of internal control (20% of marks). It covers:
- internal controls in a computerised accounting environment (ISA 315)
- information security measures
- the application of technology in audit, assurance and forensics
CAMA 2020 and IT systems
The Companies and Allied Matters Act 2020 (CAMA 2020) is the company law of Nigeria. The sections below apply to this topic.
| Section | What it says | Link to this topic |
|---|---|---|
| s. 404(2) | The report states whether proper books of account were kept | Electronic records must meet this test |
| s. 404(7)(d) | The audit committee reviews the effectiveness of accounting and internal control | Includes IT controls |
| s. 407(3) | Right of access to books, accounts and vouchers | Includes access to electronic records and logs |
The rules in more depth
Why the type of system matters
When the auditor evaluates general and application controls, the type of system must be taken into account. Four types need special attention: microcomputer systems, online systems, EDI systems and e-commerce.
Microcomputer systems
A microcomputer system uses a number of desktop computers across the organisation instead of a large central mainframe or minicomputer. Companies use them because they can be more efficient and cheaper, and because operating staff, such as accounts clerks, can run and sometimes even program them with little technical training. The audit risks are:
- it is hard to ensure the physical security of equipment spread over many locations;
- the same applies to the security of data and storage media, such as disks and memory drives;
- wide access creates problems of authorisation, with the chance of unauthorised changes to programs or data. Passwords restricting access to certain files reduce the risk;
- programs may be written or changed by users, which can cause processing and software problems; and
- there may be inadequate documentation. When software is bought, the supplier should provide documentation, and the auditor wants to see it.
Typical controls are passwords and logins, locked rooms or cable locks, regular back-ups held off the desk, licensed software only, anti-virus software, a ban on unauthorised programs and an inventory of all machines and software.
Online systems
Online systems give users direct access to centrally held data and programs through remote terminals linked in a network. Benefits are immediate entry of transactions, for example sales keyed at electronic point-of-sale terminals linked to a central computer; immediate updating of master files, such as stock records as soon as stock is requisitioned; and enquiry facilities, such as instant answers to price enquiries.
Because transactions are processed at once, the controls are a mixture of general and application controls.
General controls:
- Access controls must be strong, because unauthorised access would have an immediate effect on programs and files.
- Programming controls to prevent or detect unauthorised changes to programs or standing data.
- Transaction logs to give an audit trail: the ability to trace a transaction through all its stages. The trail may not exist on paper, but the program should produce it on request for any transaction.
- Firewalls: software or hardware that protects the network server from unauthorised access via the internet.
Application controls:
- Pre-processing authorisation: users must log on before they can use the program.
- Data validation checks on input: check digits, range checks, existence checks and completeness checks, which help ensure completeness and accuracy, for example the right number of digits in product codes.
- Balancing: immediate checking of control totals of data sent from a remote terminal, before and after processing.
Electronic data interchange (EDI)
EDI is the electronic transmission of business documents such as purchase orders, invoices or payroll information. It may work inside an organisation, for example the sales department sends copies of customer orders to accounts, or outside it, for example a company sends payroll data to a bureau or sends a purchase order electronically to a supplier.
The transmitted document is entered automatically into the receiver's different computer system, so it can be processed without manual intervention. The audit problems are:
- No paper audit trail. The system needs an electronic audit trail that it can produce.
- Greater dependency on the entity's computer systems, and possibly on outsiders, so a failure has a bigger effect, and general IT controls are extremely important.
- Loss or corruption of data during transmission.
- Security risks: unauthorised persons may be able to read the data.
Controls the auditor expects are: controls over transmission, which are encryption, acknowledgement systems and authentication codes; monitoring and checking of output; virus protection; and contingency plans and back-up. Authentication codes make senders and receivers prove their identity before data is sent. Encryption turns data into coded form for transmission and back again at the recipient's end.
E-commerce
E-commerce is any commercial activity that takes place through connected computers over a public network, such as a company that sells goods over the internet. As its volume and materiality grow, the auditor must consider the audit risks it creates and plan accordingly. The matters to consider are:
- Skills and knowledge the auditor needs to understand the effect of e-commerce on the entity. The more complex the activity, the greater the skill needed.
- Knowledge of the business. E-commerce may greatly change the business environment, raise security risks and broaden the geographical market, since customers can reach the site from anywhere.
- Additional business risks: loss of transaction integrity, use of inappropriate accounting policies, for example for capitalising website development costs, and legal and regulatory risks.
- Internal control: controls may exist within the system, but there may be no adequate audit trail for transactions on the website.
Typical e-commerce controls are secure payment processing, encryption of customer data, reconciliation of website orders to the accounting system and to the payment processor's settlements, authentication of customers, change control over the website, and monitoring for fraud. The auditor may need an IT specialist to help.
Information security measures
Information security aims to protect the confidentiality, integrity and availability of data. Measures include:
- Logical access: unique user IDs, strong passwords, multi-factor authentication and regular review of access rights;
- Physical access: locked server rooms, restricted entry and equipment protection;
- Network protection: firewalls, intrusion detection and secure remote access;
- Data protection: encryption of stored and transmitted data and secure back-ups;
- Malware defence: anti-virus software and prompt software updates;
- People: training on phishing and clear policies on use of systems and data; and
- Response: an incident response plan and tested disaster recovery.
A failure can cause loss of data, theft of funds, regulatory fines, damage to reputation and loss of reliable accounting records, so the auditor treats security as part of the control environment for IT.
Audit response to IT risks
The auditor evaluates the general controls first. If they are effective, the auditor tests application controls, and may test automated controls with a small number of examples. If they are not, the auditor does more substantive testing, often with computer-assisted audit techniques, which are explained in the next topic.
For systems with no paper trail the auditor asks the system to produce its logs and tests them, and for outsourced processing may need a report from the service provider on its controls.
Worked examples
Example 1: microcomputer risk. The accounts staff of a company use their own desktop computers, with no passwords, and keep back-up disks in their drawers.
- Risks: unauthorised access and changes, loss or theft of data, and loss of back-ups in a fire or theft.
- Controls: passwords, locked storage, back-ups held off site, and a record of who may use which files.
Example 2: audit trail. The auditor asks to trace a sale from a till to the ledger. The company has no paper documents for it.
- An online system should keep transaction logs that give an audit trail.
- The auditor asks the system to produce the log for the chosen transaction and checks each stage.
Example 3: EDI. A company sends its purchase orders to suppliers by EDI. Orders are sometimes lost and some suppliers deliver late.
- Risk: loss or corruption of data in transmission and over-dependence on the system.
- Controls: acknowledgement of each order, monitoring of unacknowledged orders and contingency arrangements.
Example 4: e-commerce. An online retailer capitalised ₦80 million of website costs as an asset.
- That is an accounting policy risk specific to e-commerce.
- The auditor tests whether the costs meet the recognition criteria for an intangible asset and whether any are really maintenance or marketing costs that must be expensed.
How to score full marks
- Name the type of system and give risks first, then controls.
- Separate general controls from application controls in online systems.
- Explain audit trail, encryption and authentication.
- Close with the audit response: test general controls first.
Common mistakes in the exam
- Looking for paper documents in a system that has none.
- Giving only risks or only controls.
- Forgetting transaction integrity and accounting policy risks in e-commerce.
- Not mentioning contingency plans for EDI.
Quick revision
- Micro: physical security, access, user programs, documentation.
- Online: access, programming controls, logs, firewalls, validation, balancing.
- EDI: no paper trail, dependency, corruption, security; encryption, authentication.
- E-commerce: skills, business risk, transaction integrity, policies, audit trail.
Practice questions
Questions 1 to 10 are multiple choice. Questions 11 to 13 are written. Try each before opening the answer.
Question 1. An audit trail in an online system is provided by:
- Transaction logs
- Paper invoices only
- The tax return
- The audit report
Show the answer
A. A record of how each transaction was processed.
Question 2. A firewall protects a network from:
- Unauthorised access via the internet
- Fire only
- Staff errors only
- Tax audits
Show the answer
A. It blocks unauthorised access.
Question 3. Balancing in an online system means:
- Checking control totals before and after processing
- Paying fees
- Setting budgets
- Counting cash
Show the answer
A. Immediate checking of totals.
Question 4. A risk of EDI is:
- No paper audit trail
- Too many documents
- Lower speed
- Higher paper use
Show the answer
A. Electronic trail only.
Question 5. Encryption means:
- Turning data into code for transmission
- Deleting data
- Printing data
- Sorting data
Show the answer
A. Re-translated at the recipient end.
Question 6. Authentication codes:
- Make senders and receivers prove identity
- Set prices
- Calculate tax
- Print invoices
Show the answer
A. Before data is sent.
Question 7. A microcomputer risk is:
- Physical security of equipment in many places
- Too much documentation
- Too little access
- Too few passwords
Show the answer
A. Desktop machines are spread out.
Question 8. E-commerce raises the risk of loss of:
- Transaction integrity
- Paper
- Pens
- Chairs
Show the answer
A. An additional business risk.
Question 9. Capitalising website development costs is an e-commerce risk in:
- Accounting policy
- Tax collection
- Payroll
- Cash counting
Show the answer
A. Inappropriate policies.
Question 10. For IT systems the auditor first evaluates the:
- General controls
- Tax computations
- Dividends
- Fees
Show the answer
A. Application controls depend on them.
Question 11 (10 marks). Explain the audit risks of a microcomputer system and the controls the auditor would expect. (7 marks)
Question 12 (10 marks). Describe the general and application controls the auditor expects in an online system. (7 marks)
Question 13 (10 marks). Explain the audit problems of EDI and e-commerce. (6 marks)
Model answers
Show the model answer to Question 11
Risks: physical security; security of data and media; authorisation and unauthorised changes; user-written programs; poor documentation. (3) Controls: passwords, locked equipment and storage, off-site back-ups, licensed software and anti-virus, supplier documentation. (4)
Show the model answer to Question 12
General: strong access controls; programming controls; transaction logs for an audit trail; firewalls. (3.5) Application: pre-processing authorisation by log-on; data validation checks such as check digits, range, existence and completeness; balancing of control totals before and after processing. (3.5)
Show the model answer to Question 13
EDI: no paper audit trail; dependency on systems; loss or corruption in transmission; security of data; controls such as encryption, authentication and back-up. (3) E-commerce: skills needed, business knowledge, transaction integrity, accounting policy and legal risks, inadequate audit trail. (3)
Spotted a mistake? Tell us and we will check it.