Sundaram Traders: The Cost of Controls After Computerising the Books
Sundaram Traders, a partnership firm in Madurai with three branches, computerised its books on 1 October 2023 using a ready-made accounting package costing ₹18,000. A vendor separately quoted ₹1,20,000 for a customised package including 40 hours of staff training. Six weeks after going live the following were noticed. (a) The opening trial balance generated by the software differed from the manual closing trial balance by ₹4,300. (b) A clerk changed the amount of a posted sales voucher from ₹24,500 to ₹2,450 on screen instead of passing a reversing entry. (c) No backup was taken for eleven working days and the stand-alone computer at the largest branch crashed. (d) All four clerks use the administrator login because separate user IDs 'slow down the work'. (e) Two cash sales invoices were entered with the same voucher number. (f) The software allows a posted voucher to be deleted with no record of who deleted it. The partners meet to decide whether to continue with the current package, buy the customised one, or revert to manual books.
1. Classify each of the six symptoms by the type of control failure involved, and recommend one specific control for each.
Read the worked answer
| Symptom | Class | Control to introduce |
|---|---|---|
| (a) ₹4,300 opening difference | Data migration error | Ledger-wise mapping sheet: manual closing balance against software opening balance, signed off by the accountant before any transaction is posted |
| (b) Posted voucher edited | Audit trail / integrity | Disable editing of posted vouchers; corrections only by reversing entry; audit trail showing user, date, time, before and after values |
| (c) No backup for 11 days | Backup and recovery | Daily automatic backup with one copy off-site, weekly restoration test, named person accountable |
| (d) Shared administrator login | Access control | Unique user IDs, role-based rights (data entry vs approval vs master creation), password policy, administrator used only for administration |
| (e) Duplicate voucher number | Data validation | Mandatory, unique, pre-numbered voucher series per branch and per voucher type; software block on duplicates |
| (f) Silent deletion | Audit trail / access | Deletion rights withdrawn; cancellation instead of deletion; deletion log reviewed monthly |
The logic is that computerisation changes the form of a control, not the need for it: the physical pre-numbering of a manual invoice book becomes an automatic numbering rule, and the accountant's initials on a voucher become a user-ID log.
2. The accountant proposes parking the ₹4,300 opening difference in a suspense account and writing it off at year end. Why is that the wrong call for a migrated opening balance?
Read the worked answer
A suspense account is designed for a difference thrown up by transactions within the period - an error you know exists but cannot yet locate. It is a temporary parking space, and its balance is meant to shrink to nil as errors are traced.
An opening balance is different in kind: it is not a transaction at all, it is brought forward data. If the software's opening trial balance does not agree with the manual closing trial balance, one of the two is wrong, and the difference cannot be an arithmetic slip inside the software - nothing has been posted yet. Parking it would mean the opening balance sheet is knowingly incorrect and every later ratio, partner capital and tax figure built on it inherits the error.
Procedure to follow: (i) block transaction entry until the opening balances are reconciled; (ii) compare ledger by ledger, using the software's opening balance list against the signed manual balance sheet; (iii) check known migration traps - debit balances entered as credit, contra ledgers netted, rounding, a group total imported twice; (iv) correct the imported figure at source, with a dated, signed correction note, and retain the manual schedule as evidence. Only if a genuine transaction-level difference remains should it go to suspense, and even then it must be analysed before the audit.
3. The accountant argues the extra ₹1,02,000 for the customised package and training cannot be justified because 'both packages produce the same trial balance'. Assess this argument and recommend a course of action.
Read the worked answer
The argument is wrong in principle: a trial balance tests only arithmetic equality of debits and credits. It cannot show who changed a voucher, whether a voucher was deleted, whether the same invoice was entered twice, or whether the data can be restored after a crash - exactly the six failures listed.
Cost the failures, not just the package: if the largest branch records about 40 vouchers a day, eleven days without backup is roughly 440 vouchers to re-enter, at perhaps 10 minutes each - over 70 hours of staff time, plus any invoices that cannot be reconstructed at all and the risk of a wrong GST return. Against that, ₹1,02,000 one-time and 40 hours of training is modest. The lack of user IDs also means no one can be held responsible for an error or a fraud.
Recommendation - a middle path, not the extremes. Reverting to manual books loses the speed and reporting benefits already gained and is not credible for three branches. Buying a ₹1,20,000 customised package may overpay for features a wholesale firm will not use. Instead, buy or upgrade to a mid-range package (roughly ₹40,000–50,000) that provides an audit trail, user-wise rights, duplicate-voucher blocks and automatic backup; keep the ₹18,000 package only if the vendor confirms these can be switched on. Spend on the 40 hours of training regardless - most of the six failures are behavioural, not software.