At AS Level you compared manual and computerised accounting. At A Level the syllabus asks two narrower, practical things: the process of moving a business’s accounts onto a computerised system, and how to make sure the data is transferred completely and accurately (its integrity), and kept secure afterwards. No knowledge of particular software is needed. Questions are written, often 6–9 marks: for example, “outline the next steps the company needs to take to implement the computerised system, considering both accuracy and security.” Good answers describe each step in order and explain why it matters.
The transfer, step by step
Step 1: plan and set objectives
Decide what the system must do (sales and purchases ledgers, inventory, payroll, reports such as aged receivables), who is in charge of the project, the budget and the timetable. Involve the accounts staff early: they know the current system and their support reduces resistance to change.
Step 2: choose the software and hardware
Compare packages on: whether they meet the business’s needs and can grow with it; cost (purchase or subscription, licences, maintenance); reliability and support from the supplier; ease of use; and security features. Decide between a single computer and a network: a network lets several staff work on one up-to-date set of records, but costs more to install and secure.
Step 3: install the system
Simple packages can be installed by staff; a networked system usually needs specialists. Ask whether installation, servicing and updates are included in the price.
Step 4: set up the chart of accounts
Every ledger account is given a numerical code, grouped by type, so that reports can be produced automatically. The default list in the package is adapted to the business before any data is entered. For example:
| Code range | Type | Example accounts |
|---|---|---|
| 1000–1999 | Non-current assets | 1010 Premises at cost; 1015 Premises accumulated depreciation; 1100 Vehicles at cost |
| 2000–2999 | Current assets | 2000 Inventory; 2100 Trade receivables control; 2200 Bank current account |
| 3000–3999 | Liabilities | 3000 Trade payables control; 3500 Bank loan |
| 4000–4999 | Capital and reserves | 4000 Capital; 4100 Retained earnings |
| 5000–5999 | Income | 5001 Sales — retail; 5002 Sales — online |
| 6000–7999 | Expenses | 6000 Purchases; 7000 Wages; 7100 Rent |
Leaving gaps in the codes lets new accounts be added later in the right place. Customer and supplier accounts are also set up, with credit limits and payment terms.
Step 5: choose the transfer date
The best time is the start of a financial year, just after the year-end accounts are complete: the income and expense accounts have been closed to the statement of profit or loss, so only the balances in the statement of financial position (assets, liabilities, capital) need to be entered as opening balances, and there is a full, checked trial balance to start from. Avoid the business’s busiest period, and stop last-minute changes to the old records once the figures are fixed.
Step 6: reconcile and check everything before transfer
This is the most important step for integrity: errors in the manual records must be found and corrected before they are copied into the new system, where they would be harder to trace.
- Trade receivables: reconcile the sales ledger control account with the total of the individual customer balances. Then list every unpaid invoice for each customer (date, invoice number, amount), because the new system will track who is late.
- Trade payables: reconcile the purchases ledger control account with the total of the supplier balances, and list unpaid invoices.
- Bank and cash: prepare a bank reconciliation statement and make any adjustments needed; count the physical cash and agree it to the cash book.
- Inventory: do a physical count at the transfer date; record quantities and values of each item for the new inventory records.
- Non-current assets and liabilities: check them against the asset register, loan statements and other evidence.
Reconciling before transfer. At the transfer date the sales ledger control account shows $48,600, but the list of individual customer balances totals $48,150. The difference of $450 is traced to a credit sale recorded in the sales day book (so it is in the control account) but never posted to the customer’s account. The customer’s account is corrected to include the $450, both figures now agree at $48,600, and only then are the customer balances entered in the new system. Had the difference been transferred, the new system’s receivables would have been wrong from day one and the customer would never have been asked to pay.
Step 7: enter the opening balances and check them
Enter the balances from the checked statement of financial position, plus the detail behind them (each customer’s and supplier’s unpaid invoices, each inventory line). Then print an opening trial balance from the new system and compare it with the final trial balance of the old system; any difference must be investigated before trading starts.
Checking the opening trial balance. The old system’s trial balance totals $512,300; the new system’s totals $512,030 — a difference of $270. A difference that divides exactly by 9 (270 ÷ 9 = 30) often means a transposition error, where two digits are swapped. The clerk checks each balance entered and finds a supplier balance of $1,520 keyed in as $1,250 (1,520 − 1,250 = 270). It is corrected and the totals agree.
Step 8: train the staff
Training is essential if the benefits are to be gained and costly mistakes avoided. It can be:
| Method | For | Against |
|---|---|---|
| External courses | Expert trainers; staff can focus away from daily work | Expensive (fees, travel); staff away from work; may not be tailored to this business |
| Visiting trainers | Training on the business’s own system and data; several staff at once | Costly; disrupts the office while it happens |
| In-house training (staff, supplier tutorials) | Cheap; flexible timing; tailored | Only as good as the person training; may pass on bad habits |
Step 9: change over
- Parallel running: run the old and new systems side by side, entering the same transactions in both, for a set period (often at least a month). Compare the outputs regularly — ledger balances, trial balance, bank balance. If they agree, the new system is working; differences are investigated. The old system also acts as a back-up if data is lost. It is the safest method but doubles the work and cost, so a business may accept “near agreement” to end it.
- Pilot or phased introduction: one part of the system (for example the sales ledger) or one branch first, then the rest. Problems are limited to one area, but the full changeover takes longer.
- Direct changeover: switch completely on a set date. Quick and cheap, but very risky — if the new system fails there is nothing to fall back on.
Step 10: review
After changeover, check reports and controls, ask users about problems, and make sure the expected benefits (speed, accuracy, better reports) are being achieved.
Ensuring the integrity of the data during transfer
Data integrity: the accuracy, completeness and consistency of the accounting data, so that the computerised records are a faithful copy of the manual ones and stay reliable afterwards.
| Control | How it protects integrity |
|---|---|
| Reconcile before transfer | Errors are corrected in the manual records first, so they aren’t carried into the new system |
| Agree the opening trial balance | The new system’s trial balance must agree with the old one; any difference reveals an input error |
| Control totals | The total of each group of balances entered (all customer balances, all inventory lines) is compared with the manual total — a missing or duplicated item shows up at once |
| Validation checks | The software rejects impossible or incomplete entries: a missing account code (presence check), a date outside the period (range check), letters in a number field (type check), a customer code that doesn’t exist |
| Verification | A second person checks each entry against the source document (the reconciled lists), or data is keyed twice and compared |
| Parallel running | Results from both systems are compared before the old one is dropped |
| Restricted access during transfer | Only named staff can enter opening balances, and the system logs who entered what (an audit trail) |
Keeping the data secure afterwards
- Strong passwords and restricted access: each user sees only the parts of the system their job needs (for example, not payroll); passwords are changed regularly; access is removed at once when staff leave.
- Audit trail: the system records who entered or changed each item and when, deterring and detecting fraud.
- Regular backups, kept securely off-site or in the cloud, so data can be restored after hardware failure, theft, fire or a cyber-attack.
- Up-to-date antivirus software and firewalls against viruses, ransomware and hackers.
- Automatic lock-out of unattended computers; controls on USB drives and on taking data out of the office.
- An acceptable-use policy, staff training in spotting suspicious emails, and a disciplinary process for breaches.
- Internal audits and compliance checks, including unannounced ones.
When a question asks about both accuracy and security, split your answer: accuracy (reconciliations, trial balance agreement, control totals, validation, verification, parallel running) and security (passwords and access rights, audit trail, backups, antivirus and firewalls, training). For each point, say what it is and how it protects the data — explanation earns the marks, a list doesn’t.
Is it worth it?
| Advantages of a computerised system | Disadvantages and risks |
|---|---|
| Speed: one entry updates the day book, the ledger and the control account automatically | Cost: hardware, software, licences, installation, maintenance, training |
| Accuracy: arithmetic is automatic and entries that don’t balance are rejected | Disruption during changeover and training; resistance from staff |
| Reports on demand: aged receivables, inventory levels, up-to-date statements | System failures, lost data, cyber-attacks |
| Documents (invoices, statements, reminders) produced automatically | Fraud or data theft by staff if access isn’t controlled |
| Less storage space; easier audit trail | Over-reliance: staff may take less care, assuming the system will catch errors |
Answering the Paper 3 questions
Typical questions: “Outline the next steps the company needed to take to implement the computerised accounting system. Your answer should consider the need for both accuracy and security”; “Discuss ways in which the integrity of the accounting data can be ensured during the transfer”; or “Evaluate whether the business should run the old and new systems in parallel.”
Paper 3 has three structured questions of 25 marks each: you prepare statements and calculate figures, then explain, discuss or advise. The written parts are marked on knowledge, analysis and evaluation. Plan every “discuss”, “advise” or “evaluate” answer in the same five steps, in this order:
- Knowledge: describe the stages of the transfer and the controls that protect data integrity and security.
- Application: apply them to the business in the case: its size, the state of its manual records, its staff’s skills, the timing of its year end, how many people need access.
- Analysis: explain why each step matters: for example, reconciling the control accounts before transfer prevents existing errors being built into the new system, where they would be harder to trace.
- Evaluation: weigh the changeover methods (parallel running is safest but costly; direct changeover is cheap but risky), the cost of training and the risks of data loss.
- Conclusion: give a justified recommendation, for example: the business should use parallel running for one month, because its customer records are complex and an error in their balances would damage cash flow.
Check yourself
Why is the start of the financial year the best time to transfer?
There is a complete, checked trial balance; the income and expense accounts are closed, so only statement of financial position balances need entering.
Why should manual records be reconciled before transfer?
So that existing errors are corrected before the balances are entered, rather than being carried into the new system where they are harder to trace.
The old trial balance totals $86,400 and the new one $85,770. What kind of error might this be?
The difference is $630, which divides by 9 (630 ÷ 9 = 70), suggesting a transposition error such as a balance of $1,810 entered as $1,180 — check each balance against the reconciled list.
Name the three changeover methods and one drawback of each.
Parallel running (doubles the workload and cost); pilot or phased (slower to complete); direct changeover (nothing to fall back on if it fails).
Give two controls for accuracy and two for security.
Accuracy (any two): reconciliations; trial balance agreement; control totals; validation and verification; parallel running. Security (any two): passwords and access rights; audit trail; backups; antivirus and firewalls; staff training.
What is an audit trail?
A record kept by the system of who entered or changed each item and when.
Now practise it
Try the 1 past paper question on Computerised accounting systems, with mark schemes. Start with the most recent ones; if one goes wrong, come back to the section above that covers it.