All subjects · Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development
Transaction processing systems
Edexcel IAL Information Technology · WIT13 2 hour written exam on data, enabling technologies and systems development
A transaction is a single business event, such as a sale or a payment. Transaction processing (TP) systems record and process these events reliably. The specification names EPOS, order processing, financial systems and Bacs (spec 14.1.2).
What transaction processing is
Transaction processing is the collection, storage, processing and retrieval of business transactions. A good TP system is fast, reliable, accurate and consistent, and copes with many simultaneous users.
Transactions must be all or nothing (atomic): a bank transfer debits one account and credits the other, or does neither; a half-completed transaction is rolled back.
- Real-time (online) processing: each transaction is processed immediately (cash machines, seat booking), so data is always up to date.
- Batch processing: transactions are collected and processed together later, often overnight (payroll, utility bills, cheque clearing); efficient for large volumes with no need for an immediate result.
Why organisations use TP: speed and accuracy, up-to-date records, less paperwork and fewer staff, an audit trail, data that feeds MIS and analytics.
EPOS and order processing
EPOS (electronic point of sale): a till with barcode scanner, card reader and receipt printer linked to a central system. Each sale looks up the price, records the transaction, takes payment, updates stock levels (triggering automatic reordering), and feeds sales data to managers and loyalty schemes.
Order processing: an order (online, phone or EDI) is checked for stock and credit, payment is authorised, picking lists and delivery notes are produced, stock is updated, invoices are generated, and the customer is kept informed with order tracking.
Financial systems and Bacs
Financial TP records sales and purchase ledgers, invoices, payments, payroll and accounts, producing statements and reports.
Bacs is the UK's system for bank-to-bank payments processed in batches (the specification names Bacs Payment Schemes Limited; Bacs is now owned and operated by Pay.UK). Its two main services are Direct Debit (an organisation collects money from customers' accounts, with their authorisation, for bills and subscriptions) and Direct Credit (an organisation pays money into accounts, for wages, pensions and supplier payments). Payments follow a three-day cycle: day 1 the payment file is submitted; day 2 Bacs processes it and passes instructions to the banks; day 3 the money leaves the payer's account and arrives in the recipient's. It suits predictable, bulk payments, not urgent ones.
Worked example
A supermarket checkout scans a tin of beans. Describe the transaction processing that follows.
- The barcode is read and the product code sent to the central database.
- The price and description are looked up and shown on the till.
- When payment is complete, the sale is recorded with date, time, till and items.
- Stock level for the item is reduced by one; if it falls below the reorder level, an order is generated.
- Sales data is later used for reports and loyalty points.
Answer: Lookup, record, pay, update stock, reorder, report
Check yourself
- Which task is best suited to batch processing?
- Booking the last seat on a flight
- Producing monthly salary payments for 5000 employees
- Withdrawing cash from an ATM
- Checking a card payment at a till
Show answer
Producing monthly salary payments for 5000 employees. Large volume, no immediate response needed.
- Why must a theatre booking system use real-time transaction processing?
- Real-time processing is always cheaper
- Batch processing cannot store dates
- It avoids the need for a database
- Seats must be updated immediately so the same seat is not sold twice
Show answer
Seats must be updated immediately so the same seat is not sold twice. Up-to-date availability prevents double booking.
- During a bank transfer, the debit succeeds but the system crashes before the credit. What should a TP system do?
- Keep the debit and forget the credit
- Roll back the debit so that neither part of the transaction takes effect
- Credit the account twice later
- Delete the customer's account
Show answer
Roll back the debit so that neither part of the transaction takes effect. Transactions are all or nothing.
- A gym collects membership fees monthly from members' bank accounts, with their authorisation. Which Bacs service is this?
- Direct Credit
- EPOS
- Direct Debit
- Order processing
Show answer
Direct Debit. The organisation pulls money from the payer.
- A company submits its Bacs Direct Credit payroll file on a Monday (day 1). On which day of the cycle do employees receive the money?
Show answer
3. Day 1 input, day 2 processing, day 3 entry: money arrives on day 3 (Wednesday).
- Which is a benefit of EPOS for a shop's managers?
- Customers no longer need to pay
- Prices never change
- Sales and stock data are recorded automatically for reports and reordering
- No network is needed
Show answer
Sales and stock data are recorded automatically for reports and reordering. Data capture supports decisions.
- Explain why an audit trail is an important feature of a financial transaction processing system.
Show answer
It records every transaction with details such as who made it and when, so errors and fraud can be traced and the accounts can be checked by auditors.. Records details, so trace errors or fraud.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (first teaching 2018), Issue 2, February 2021
- Pearson Edexcel IAL Information Technology: scheme of work for Unit 3
- Bacs (Pay.UK): glossary, Bacs cycle and Day 1 to Day 3
Last updated 8 November 2026. Spotted a mistake? Tell us.