Use of technology in accounting

A manual accounting system uses paper ledgers, day books, journals and trial-balance worksheets — the same techniques you study in Topic 2. Transactions are written by hand, totals are calculated on paper, and reports are compiled by manual recalculation.

A computerised accounting system replaces some or all of these steps with software. There are two main forms you must distinguish:

1. Spreadsheets (general-purpose) — Excel, Google Sheets, Apple Numbers. The user designs columns, writes formulae, and is responsible for the structure of the bookkeeping.
2. Integrated accounting software (purpose-built) — Sage, Xero, QuickBooks. The software is pre-configured for double-entry; the user enters one transaction and the software updates all the ledgers and reports automatically.

A cloud-based accounting system is integrated software hosted on the internet rather than installed on a local PC — adding multi-location access and automatic backups.

Each of the five SARA-T advantages can be developed into a 2-mark explain question — examiners want the consequence spelled out, not just the label.

• Speed. Transactions are recorded and totalled instantly, freeing staff time for analysis and customer service.
• Accuracy. Computers do not make arithmetic mistakes. Once data is entered, totals, balances and trial balance figures are correct by construction (errors of principle and commission are still possible — see Topic 3).
• Reports. Financial statements, ratio analysis and ageing schedules can be generated on demand. Management decisions can be based on yesterday's numbers, not last quarter's.
• Audit trail. Every transaction is logged with a timestamp and user ID. This deters and detects fraud, and accelerates the year-end audit.
• Trial-balance auto-balancing. Because integrated software enforces double entry on every posting, the trial balance must balance — eliminating one category of error entirely.

Additional benefits worth mentioning in extended-response questions: lower long-run cost (less paper, less filing), easier remote working (cloud), automated VAT/tax returns, and integration with bank feeds.

1. Cost. Initial purchase of software and hardware, plus ongoing licences (or monthly cloud subscriptions). For a very small business with few transactions, the cost-per-transaction may exceed the manual alternative.

2. Training. Staff must be taught to use the system. Time spent training is time not spent on revenue-generating activity. Mid-sized businesses sometimes need a dedicated bookkeeper familiar with the chosen software.

3. Dependence on power and internet. If the office loses electricity, no transactions can be recorded. If the cloud provider has an outage, the business may be locked out of its own books temporarily.

4. Cybersecurity. Computerised data is a target for cybercriminals. Risks include:

• Unauthorised access (weak passwords).
• Data theft (customer records, bank details).
• Ransomware (data encrypted by attackers until a ransom is paid).
• Fraudulent transactions posted under stolen credentials.

5. Loss of human judgement. Software accurately follows rules but does not exercise professional judgement on year-end adjustments, ethical issues, or interpretation. An over-reliance on software can mask conceptual errors.

6. Data protection compliance. Storing customer and financial data digitally brings legal obligations under data-protection law (UK Data Protection Act, EU GDPR). A breach can trigger fines and reputational damage.

Spreadsheets are common in small businesses and as supplementary tools alongside integrated software. They are especially useful for:

• Budgeting and forecasting — what-if analysis.
• Ratio analysis — building formulae for liquidity, profitability and efficiency ratios.
• Schedules supporting financial statements — depreciation schedules, fixed-asset registers, bad-debt analysis.
• Bank reconciliations — though integrated software automates this.

Strengths: flexibility, low cost (often free), familiar to most users, easy to share.

Weaknesses: no built-in double entry, formula errors hard to detect, version-control problems when multiple users edit copies, limited audit trail compared to integrated software.

Common formula errors in spreadsheet bookkeeping: incorrect cell references (a SUM that misses the last row), circular references, formatted cells displaying rounded values that don't match the underlying calculation. Markers often credit students who mention these specific pitfalls.

Cloud accounting is the dominant trend in modern bookkeeping. The software runs on the provider's servers and is accessed through a web browser or mobile app.

Key features:

• Real-time access from anywhere — staff at different branches, or the owner travelling, can all view current figures.
• Automatic backups to multiple data centres — far more robust than a small business's own backup arrangements.
• Automatic software updates — tax rates, regulatory changes and security patches are pushed by the provider.
• Bank feed integration — bank transactions flow into the books automatically, reducing manual entry.
• Subscription pricing — operating expense, not a large capital cost; can be scaled up/down as the business grows.

Trade-offs: dependence on internet, monthly cost can exceed one-off software purchase over a long period, data sovereignty concerns (where physically is the data stored?), trust in the provider's security.

Examiners increasingly test cybersecurity awareness. You should be able to name risks and mitigations in pairs.

Risk	Mitigation
Weak passwords / unauthorised access	Strong passwords, two-factor authentication (2FA), user-specific permissions
Phishing emails tricking staff into sharing credentials	Staff training, email-filtering, verifying senders
Malware and ransomware	Antivirus software, regular patching, offline backups
Theft of laptop / mobile device	Encryption of drives, remote-wipe capability
Insider fraud	Segregation of duties, audit trail review
Data-protection breach (regulatory)	Compliance with GDPR / DPA, data-processing agreements with cloud providers

The audit trail is the central control. It records who did what and when, making fraud easier to detect and discouraging unauthorised changes.

Software cannot:

• Decide whether a transaction is capital or revenue expenditure — this is judgement (Topic 2).
• Apply accounting concepts such as prudence or going concern — these require interpretation (Topic 1.3 / 5).
• Resolve ethical dilemmas when an entry is being asked to mislead users of accounts.
• Replace the professional accountant's interpretation of ratios and trends.
• Detect errors of principle (wrong account class) or original entry (wrong figure entered for both sides).

The role of the accountant has shifted from processing to interpreting, advising and controlling. Naming this shift in extended responses signals A*-level perspective.