Skip to content

Chapter 14: Accounting Software and Ethics

Computerised accounting, its controls, and the professional duties of those who prepare accounts

Learning outcomes

After studying this chapter you should be able to:

  1. Explain what changes, and what does not, when accounts are kept by computer.
  2. Design a simple coded chart of accounts and describe masters, vouchers and reports.
  3. Build a trial balance from journal data with spreadsheet formulas or a short program.
  4. Describe the main controls in a computerised accounting system, including the audit trail.
  5. State the fundamental principles of professional ethics and the main threats to them.
  6. Recognise window dressing and earnings management, and measure their effect on reported figures.

14.1 From books to software

Almost every business today keeps its accounts by computer, from a spreadsheet in a small shop to a large enterprise system that links sales, purchasing, inventory, payroll and accounting. Accounting software performs, in a fraction of a second, the steps that earlier chapters did by hand: it posts every voucher to the ledger, balances the accounts, prepares the trial balance and produces the financial statements.

What changes is the mechanics. Posting, casting, balancing and transferring are done by the program, so the errors of Chapter 6 that arise from them (wrong totals, postings to one side only, wrong balances carried forward) largely disappear. Reports can be produced for any date or period at any time, rather than once a year.

What does not change is the accounting. The software does not know whether a payment is for a machine or for repairs, whether a sale belongs to this year or next, or how much of the debtors will never pay. Every decision about which account to debit and credit, every year-end adjustment, every estimate, is still made by a person. A wrong entry is processed just as fast as a right one. The principles of the earlier chapters are therefore as necessary as ever: the computer only removes the drudgery.

Key idea

Software automates recording, posting and reporting. It does not automate judgement. Errors of principle and of original entry, and deliberate misstatements, pass through software untouched.

14.2 The chart of accounts

Before any transaction is entered, the business sets up its chart of accounts: the list of every ledger account, arranged in groups that correspond to the headings of the financial statements. Each account is often given a numeric code so that it can be sorted and reported consistently.

Code range Group Examples of accounts (code)
1000-1999 Assets Cash (1010), Bank (1020), Trade receivables (1100), Inventory (1200), Prepaid expenses (1300), Office equipment (1510), Accumulated depreciation: office equipment (1515)
2000-2999 Liabilities Trade payables (2010), Outstanding expenses (2100), Bank loan (2500)
3000-3999 Capital (equity) Capital (3010), Drawings (3020)
4000-4999 Revenue Sales (4010), Sales returns (4020), Commission received (4500)
5000-5999 Cost of sales Purchases (5010), Purchases returns (5020), Carriage inwards (5100)
6000-6999 Operating expenses Salaries (6010), Rent (6020), Electricity (6030), Depreciation (6100)

Table 14.1. A simple coded chart of accounts.

Good coding makes reports reliable: if every expense account sits within its group, the profit and loss account and the balance sheet are produced simply by adding the groups. The groups also reflect the rules of debit and credit: accounts in the asset and expense groups normally carry debit balances, those in the liability, capital and revenue groups credit balances.

14.3 Masters, vouchers and reports

Most accounting packages organise work in three layers.

Masters (company, financial year, groups and ledgers, inventory items and tax rates) are set up once; vouchers (receipt, payment, contra, sales, purchase, journal, debit note, credit note) are entered every day and must balance; both feed a database that posts automatically and keeps an audit trail, from which reports such as the day book, ledgers, trial balance, financial statements, cash flow, ageing, bank reconciliation and tax returns are produced on demand.
Figure 14.1 How accounting software is organised. Masters (company, financial year, groups and ledgers, inventory items and tax rates) are set up once; vouchers (receipt, payment, contra, sales, purchase, journal, debit note, credit note) are entered every day and must balance; both feed a database that posts automatically and keeps an audit trail, from which reports such as the day book, ledgers, trial balance, financial statements, cash flow, ageing, bank reconciliation and tax returns are produced on demand.

Masters are the standing data, entered once and changed rarely: the company's name and financial year, the groups and ledger accounts (with opening balances), customers and suppliers with their credit terms, inventory items, and tax rates.

Vouchers are the transactions, entered daily. Each voucher type corresponds to a book of original entry of Chapter 4:

Voucher type Used for Manual equivalent
Receipt Money received in cash or bank Debit side of the cash book
Payment Money paid in cash or by bank Credit side of the cash book
Contra Transfers between cash and bank Contra entries
Sales Credit (and cash) sales of goods Sales book
Purchase Credit (and cash) purchases of goods Purchases book
Credit note Goods returned by customers, allowances Sales returns book
Debit note Goods returned to suppliers Purchases returns book
Journal Adjustments, depreciation, rectification, other non-cash items Journal proper

Table 14.2. Voucher types and their manual equivalents.

Reports are produced from the posted data whenever needed: the day book, the cash and bank book, any ledger account, the trial balance, the profit and loss account and balance sheet, the cash flow statement, the ageing of receivables (how long each customer's balance has been outstanding), stock summaries, and the statements needed for tax returns.

Features that support the earlier chapters

  • Bank reconciliation. The bank statement is imported or entered, and cleared items are matched with the cash book; the unmatched items are exactly the timing differences of Chapter 5.
  • Fixed asset register. Assets are recorded with cost, date and rate, and depreciation is computed and posted (Chapter 7).
  • Credit control. Ageing reports and reminders support the estimate of doubtful debts.
  • Tax. Sales and purchase vouchers carry tax rates, and the tax accounts and returns are prepared from them (Chapter 4).

14.4 Spreadsheets

Many small businesses, and many accountants for analysis, use spreadsheets. A spreadsheet is not an accounting system (it does not stop unbalanced entries or keep an audit trail unless designed to), but it is an excellent tool for understanding one.

Example 14.1 A trial balance with spreadsheet formulas

Suppose the journal of Sharma Electricals (Example 3.1) is typed into a sheet named Journal, one entry per row: column A the date, column B the account debited, column C the account credited, column D the amount (rows 2 to 15). A second sheet, TB, lists the account names in column A from row 2. The formulas are:

B2  (net balance)  =SUMIF(Journal!$B$2:$B$15,A2,Journal!$D$2:$D$15)-SUMIF(Journal!$C$2:$C$15,A2,Journal!$D$2:$D$15)
C2  (debit)        =IF(B2>0,B2,0)
D2  (credit)       =IF(B2<0,-B2,0)
C15 (total debit)  =SUM(C2:C14)
D15 (total credit) =SUM(D2:D14)
E15 (check)        =IF(C15=D15,"Agrees","Does not agree")

The first formula adds every amount debited to the account and subtracts every amount credited to it, which is exactly what posting and balancing do. Copied down for the thirteen accounts, the sheet reproduces the trial balance of Example 3.4: total debits ₹3,03,000 and total credits ₹3,03,000.

14.5 A small program

The heart of any accounting program is short. The Python program below holds the vouchers of Sharma Electricals, refuses any voucher whose debits and credits differ, posts them to a ledger and prints the trial balance.

Example 14.2 Posting vouchers and printing a trial balance in Python

from collections import defaultdict

# Each voucher: (date, [(account, debit, credit), ...])
vouchers = [
    ("2025-04-01", [("Cash", 200000, 0), ("Capital", 0, 200000)]),
    ("2025-04-02", [("Bank", 120000, 0), ("Cash", 0, 120000)]),
    ("2025-04-03", [("Purchases", 80000, 0), ("Mehta & Co", 0, 80000)]),
    ("2025-04-05", [("Office Equipment", 30000, 0), ("Bank", 0, 30000)]),
    ("2025-04-08", [("Gupta Stores", 45000, 0), ("Sales", 0, 45000)]),
    ("2025-04-10", [("Cash", 25000, 0), ("Sales", 0, 25000)]),
    ("2025-04-12", [("Mehta & Co", 50000, 0), ("Bank", 0, 50000)]),
    ("2025-04-15", [("Cash", 30000, 0), ("Gupta Stores", 0, 30000)]),
    ("2025-04-18", [("Purchases", 12000, 0), ("Cash", 0, 12000)]),
    ("2025-04-20", [("Rent", 8000, 0), ("Cash", 0, 8000)]),
    ("2025-04-25", [("Drawings", 4000, 0), ("Cash", 0, 4000)]),
    ("2025-04-28", [("Cash", 3000, 0), ("Commission Received", 0, 3000)]),
    ("2025-04-30", [("Salaries", 10000, 0), ("Bank", 0, 10000)]),
    ("2025-04-30", [("Electricity", 2000, 0), ("Cash", 0, 2000)]),
]

def post(vouchers):
    """Post balanced vouchers to a ledger; a positive balance is a debit."""
    ledger = defaultdict(int)
    for date, lines in vouchers:
        dr = sum(d for _, d, _ in lines)
        cr = sum(c for _, _, c in lines)
        if dr != cr:                       # the software refuses an unbalanced voucher
            raise ValueError(f"Voucher of {date} does not balance: {dr} vs {cr}")
        for account, d, c in lines:
            ledger[account] += d - c
    return ledger

ledger = post(vouchers)
total_dr = total_cr = 0
print(f"{'Account':<22}{'Debit':>10}{'Credit':>10}")
for account, bal in ledger.items():
    dr, cr = (bal, 0) if bal > 0 else (0, -bal)
    total_dr += dr
    total_cr += cr
    print(f"{account:<22}{dr or '':>10}{cr or '':>10}")
print(f"{'Total':<22}{total_dr:>10}{total_cr:>10}")

Its output is the trial balance of Example 3.4:

Account                    Debit    Credit
Cash                      112000          
Capital                             200000
Bank                       30000          
Purchases                  92000          
Mehta & Co                           30000
Office Equipment           30000          
Gupta Stores               15000          
Sales                                70000
Rent                        8000          
Drawings                    4000          
Commission Received                   3000
Salaries                   10000          
Electricity                 2000          
Total                     303000    303000

A voucher such as ("2025-05-01", [("Cash", 5000, 0), ("Sales", 0, 4500)]) is rejected with the message "Voucher of 2025-05-01 does not balance: 5000 vs 4500". Because every voucher must balance before it is posted, the trial balance of a computerised system always agrees; that is why, in software, the trial balance stops being a useful check on arithmetic, and the review of what was posted becomes all the more important.

14.6 Controls in a computerised system

Computerisation removes some risks and creates others: one careless or dishonest user can now change many records at once, and a single failure can destroy all the data. Good systems include:

  • Access controls. Each user has a password and a role, and can see and do only what the role requires. A sales clerk can enter sales vouchers but not alter the bank ledger.
  • Segregation of duties. No one person should be able to authorise a payment, record it and reconcile the bank account; dividing these tasks makes fraud harder.
  • Authorisation and approval. Vouchers above a limit, or of certain kinds (write-offs, credit notes), need approval by a second person.
  • Audit trail (edit log). The system records who entered or changed each transaction, when, and what the old and new values were, and the log cannot be switched off or altered. Company law in some countries, including India, now requires the accounting software used by companies to maintain such an audit trail.
  • Period locking. Once a period has been closed and reported, it is locked so that entries cannot be back-dated into it without authorisation.
  • Validation checks. The software rejects unbalanced vouchers, invalid dates and unknown account codes, and warns about unusual entries (a credit balance in cash, a duplicate invoice number).
  • Backups and recovery. Data is copied regularly to a secure separate location, and the restore process is tested.
  • Regular reconciliation and review. Bank reconciliations, confirmations from customers and suppliers, physical counts of inventory and review of unusual journal entries catch what validation cannot.

Caution

A balanced trial balance from software proves nothing about the correctness of the accounts. The errors that matter in a computerised system are those of principle, omission, wrong classification and wrong cut-off, plus deliberate manipulation. These are found only by review, reconciliation and audit.

14.7 Why ethics matters in accounting

Financial statements are used by people who cannot check them for themselves: investors, lenders, employees, the government. They rely on the people who prepare and audit them to act honestly and competently. When that trust fails, the damage spreads far beyond one business: investors lose savings, employees lose jobs, lenders lose money, and confidence in all financial reporting falls. Many of the rules of company law, the accounting standards and the audit profession were tightened after such failures.

Accounting also offers many opportunities for choice: estimates of useful lives and doubtful debts, the timing of revenue, the classification of an item as capital or revenue. Most of these choices are legitimate; the duty of the accountant is to make them honestly, so that the statements are a faithful representation (Chapter 1), not a picture that suits the preparer.

The fundamental principles

The international code of ethics for professional accountants, issued by the International Ethics Standards Board for Accountants (IESBA) and adopted, with modifications, by many national professional bodies including those in India, sets out five fundamental principles:

Principle What it requires
Integrity Be straightforward and honest in all professional and business relationships; do not be associated with information you believe to be false or misleading
Objectivity Do not allow bias, conflict of interest or undue influence of others to override professional judgement
Professional competence and due care Keep knowledge and skill at the level required, and act diligently in accordance with applicable standards
Confidentiality Respect the confidentiality of information acquired through professional work; do not disclose it without proper authority unless there is a legal or professional right or duty to do so, and do not use it for personal advantage
Professional behaviour Comply with laws and regulations and avoid any conduct that discredits the profession

Table 14.3. The fundamental principles of professional ethics.

Threats and safeguards

The same code groups the circumstances that can undermine these principles into categories of threats:

  • Self-interest: a financial or other interest will inappropriately influence judgement (an accountant whose bonus depends on reported profit).
  • Self-review: an accountant will not appropriately evaluate work that he or she did earlier (auditing a system one designed).
  • Advocacy: an accountant promotes a client's or employer's position to the point that objectivity is compromised.
  • Familiarity: a long or close relationship makes an accountant too sympathetic to the interests of others or too accepting of their work.
  • Intimidation: an accountant is deterred from acting objectively by actual or perceived pressure, including threats of dismissal.

Safeguards reduce threats to an acceptable level: independent review by another person, rotation of staff, separating duties, clear policies, board audit committees, and, ultimately, refusing or withdrawing from the work.

14.8 Window dressing and earnings management

Window dressing means arranging transactions around the year end so that the financial statements look better than the underlying position. Earnings management means using the choices available in accounting, or the timing of transactions, to report a desired profit. Some timing choices are ordinary business decisions; the line is crossed when the purpose or effect is to mislead users. Recording sales that have not happened, or that belong to the next period, is plainly wrong.

Example 14.3 The effect of window dressing on reported figures

(a) Dressing the current ratio. On 30 March a company's current assets are ₹4,00,000 (including bank ₹1,80,000) and its current liabilities ₹2,50,000. On 31 March it pays ₹1,50,000 of trade payables from the bank, intending to buy on credit again in April.

Before payment After payment
Current assets (₹) 4,00,000 2,50,000
Current liabilities (₹) 2,50,000 1,00,000
Current ratio 1.6:1 2.5:1

Paying a genuine debt is not wrong in itself, but a ratio of 2.5 at the year end suggests far more liquidity than the business usually has. A reader who knows the trick looks at the cash flow statement and at the ratio during the year, not only at the year end.

(b) Bringing forward revenue. A business with a profit of ₹2,00,000 for 2025-26 records in March goods invoiced for ₹60,000 (cost ₹40,000) that are not dispatched until April.

Correct With early recording
Profit for 2025-26 (₹) 2,00,000 2,20,000
Effect on 2026-27 profit (₹) — 20,000 lower
Trade receivables at 31 March (₹) unaffected 60,000 higher
Inventory at 31 March (₹) unaffected 40,000 lower

Profit is overstated by ₹20,000 (10%) this year and understated by the same amount next year. Revenue recognition rules (Chapter 1) forbid this: the sale is not complete until control of the goods passes to the customer.

Example 14.4 Ethical dilemmas

Case 1. An accounts assistant is told by the sales manager to record next month's sales in this month "to meet the target", and is reminded that her contract is up for renewal. Threats: self-interest and intimidation. Principles at stake: integrity and objectivity. A proper response: decline, explain that the entry would breach revenue recognition, and if the pressure continues, raise it with a more senior person, the finance head or the audit committee, keeping a written record.

Case 2. An accountant preparing a client's accounts notices that a large debtor has gone into insolvency, but the client refuses to make any provision because "the bank must not see a loss". Principle at stake: integrity (being associated with misleading information) and professional competence (applying the standards). A proper response: explain that a provision is required by prudence and the standards; if the client refuses, decline to be associated with the statements.

Case 3. A friend asks an accountant whether a listed company she audits is about to report a large loss. Principle at stake: confidentiality. A proper response: refuse; using or passing on such information would also breach the law on insider trading.

14.9 Summary

Summary

  • Software automates posting, balancing and reporting; it does not make accounting judgements. Errors of principle, omission and cut-off, and deliberate misstatements, pass through it.
  • A coded chart of accounts, organised in groups that match the financial statements, is the foundation of a computerised system. Masters are standing data; vouchers are transactions; reports are produced on demand.
  • A trial balance can be built with spreadsheet formulas (SUMIF of debits minus credits) or with a short program that rejects unbalanced vouchers.
  • Controls include access controls, segregation of duties, authorisation, an unalterable audit trail, period locking, validation, backups and regular reconciliation.
  • The fundamental ethical principles are integrity, objectivity, professional competence and due care, confidentiality and professional behaviour; the main threats are self-interest, self-review, advocacy, familiarity and intimidation.
  • Window dressing and earnings management can flatter ratios and profit; they are detected by looking beyond year-end figures and are wrong when they mislead.

14.10 Exercises

Exercise 1

Assign each account to a group of the chart of accounts in Table 14.1 and suggest a code: (a) discount received; (b) delivery van; (c) outstanding salaries; (d) carriage inwards; (e) advertisement; (f) drawings.

Answer

(a) Revenue, for example 4600; (b) Assets, for example 1520 (with accumulated depreciation 1525); (c) Liabilities, for example 2110; (d) Cost of sales, 5100 in the table; (e) Operating expenses, for example 6200; (f) Capital, 3020 in the table.

Exercise 2

Name the voucher type used for: (a) cash withdrawn from the bank for office use; (b) depreciation for the year; (c) goods returned by a customer; (d) rent paid by cheque; (e) a credit sale.

Answer

(a) contra; (b) journal; (c) credit note; (d) payment; (e) sales.

Exercise 3

In the spreadsheet of Example 14.1, what would the formula in B2 return for Gupta Stores, and why?

Answer

15,000. Gupta Stores was debited ₹45,000 (the credit sale) and credited ₹30,000 (cash received), so the formula gives 45,000 − 30,000 = 15,000, a positive figure, which appears in the debit column.

Exercise 4

The accountant of a small firm authorises supplier payments, makes the payments through internet banking and prepares the monthly bank reconciliation. What control weakness does this show, and how could it be reduced?

Answer

There is no segregation of duties: one person could create a false supplier, pay it and hide the payment in the reconciliation. The owner (or a second person) should approve payments and review or prepare the bank reconciliation, and supplier master data should be changed only by someone other than the person who pays.

Exercise 5

A firm has current assets of ₹3,00,000 and current liabilities of ₹2,00,000. On the last day of the year it takes a 15-day bank loan of ₹1,00,000, keeping the money in its bank account. What happens to the current ratio? Is the loan a current or non-current liability?

Answer

The loan is repayable within a year, so it is a current liability. Current assets become ₹4,00,000 and current liabilities ₹3,00,000: the ratio falls from 1.5 to 1.33. (Borrowing short-term and holding the cash lowers a ratio that is above 1; window dressing usually does the opposite, paying off current liabilities.)

Exercise 6

Identify the ethical principle and threat: an auditor has audited the same company for twelve years and is a close friend of its finance director.

Answer

The threat is familiarity: the long and close relationship may make the auditor too accepting of the finance director's work. The principle at risk is objectivity. Safeguards include rotating the audit partner and having the work reviewed by another partner.

14.11 Quiz

Check your understanding of Chapter 14

Exercise 1

Which kind of error is most likely to remain in a computerised accounting system?

  1. An error in casting a total
  2. A posting to one side only
  3. An error of principle
  4. A wrong balance carried down
Answer

An error of principle

Exercise 2

Transfers between cash and bank are entered in software as a

  1. journal voucher
  2. contra voucher
  3. sales voucher
  4. debit note
Answer

contra voucher

Exercise 3

A record of who entered or changed each transaction, and when, is called

  1. a chart of accounts
  2. an audit trail
  3. a trial balance
  4. a master
Answer

an audit trail

Exercise 4

Which is one of the five fundamental principles of professional ethics?

  1. Profitability
  2. Confidentiality
  3. Conservatism
  4. Materiality
Answer

Confidentiality

Exercise 5

Match each situation with the threat it creates.

AB
Bonus depends on reported profitintimidation
Auditing a system you designedfamiliarity
Threat of dismissalself-interest
Twelve years with the same clientself-review
Answer

Bonus depends on reported profit — self-interest; Auditing a system you designed — self-review; Threat of dismissal — intimidation; Twelve years with the same client — familiarity

Exercise 6

Current assets ₹5,00,000 and current liabilities ₹3,00,000. A creditor of ₹1,00,000 is paid from the bank on the last day. What is the new current ratio? (write as a number, e.g. 1.5)

Answer

2 / 2.0 / 2:1

(5,00,000 − 1,00,000) ÷ (3,00,000 − 1,00,000) = 4,00,000 ÷ 2,00,000 = 2.