The use of technology in managing finance, including spreadsheets, accounting software, online and electronic banking, and electronic payments, with the advantages and disadvantages.

What this key area is asking

Technology has made managing finance faster and more accurate, and the SQA wants you to describe uses such as spreadsheets, accounting software, online banking and electronic payments, and to discuss the advantages and disadvantages. Higher rewards balanced judgement, recognising the speed, accuracy and analysis technology brings, against the cost, training, security and risk of relying on it.

How technology is used in managing finance

Spreadsheets

Spreadsheets are widely used to prepare cash budgets and financial statements. They calculate automatically and accurately, update instantly when one figure changes, allow "what if" analysis (modelling different scenarios, such as a sales fall), and present data in graphs and charts, saving time and reducing errors compared with doing it by hand.

Accounting software

Accounting software records every transaction, produces invoices, tracks debtors and creditors (who owes the firm and whom it owes), and generates financial statements, ratios and reports automatically. This speeds up bookkeeping, reduces errors, and gives managers up-to-date financial information for decisions.

Online banking and electronic payments

Online (electronic) banking lets the firm check balances, make payments and transfer money at any time, from anywhere, without visiting a branch. Electronic payments (debit/credit card, BACS, online transfer) let the firm pay suppliers and staff and receive payment from customers quickly and securely, improving cash flow by speeding up receipts and making payments efficient.

The advantages and disadvantages

Advantages: speed (instant calculation, payments and reports); accuracy (fewer human errors); automatic calculation, reporting and "what if" analysis; convenience (banking and payments any time); and better, up-to-date financial information for decisions.

Disadvantages: the cost of software and the need for training; the risk that a single formula or input error is repeated and goes unnoticed; the need to keep financial data secure (against fraud and hacking) and backed up; and dependence on the technology, so a system failure disrupts financial work.

Examples in context

Example 1. A firm modelling scenarios in a spreadsheet. A firm builds its cash budget in a spreadsheet and uses "what if" analysis to see the effect of a $10\%$ fall in sales: the figures and graphs update instantly, showing when a cash shortage would arise so the firm can plan. Doing this by hand would be slow and error-prone. The risk is that an error in one formula would feed through every figure unnoticed, the classic trade-off of spreadsheet use.

Example 2. Accounting software producing instant reports. A company uses accounting software that records every sale and purchase, tracks debtors and creditors, and generates financial statements and ratios at the press of a button, giving managers up-to-date information for decisions and saving hours of manual work. But the firm must keep the data secure and backed up and train staff to use it, showing how the efficiency of accounting software comes with cost, training and security responsibilities.

Try this

Q1. Describe two ways technology could be used to manage a business's finances. [2 marks]

• Cue. Spreadsheets for budgets and "what if" analysis; accounting software to record transactions, invoice and produce reports; online banking to check balances and make payments; electronic payments (card, BACS); EPOS to record sales (any two).

Q2. Explain one advantage and one disadvantage of using accounting software. [4 marks]

• Cue. Advantage: it records transactions and produces invoices, statements and reports automatically and accurately, saving time and giving up-to-date information for decisions. Disadvantage: it costs money and needs training, financial data must be kept secure and backed up, and the firm depends on the system, so a failure disrupts financial work.