In this topic
Learning outcomes
- Explain the relevant accounting rule and terminology.
- Prepare a correctly classified calculation or statement.
- Show working notes and verify the debit-credit or balance check.
Key vocabulary
Concepts to know
A system that uses software and structured data to record, process, store and report accounting information.
A coded, hierarchical list of ledger accounts used to organise transactions.
Checking entered data against rules such as date, account code, range or required field.
A record of who entered or changed data, when and what changed.
Core notes
System structure and package choices
A CAS typically includes source data, input interfaces, validation rules, processing logic, databases, reports and controls. Generic packages can serve many businesses; specific packages target a sector; tailored systems are configured for an entity’s needs. Choose by transaction volume, reporting needs, integration, security, training and total cost—not appearance alone.
Create a chart of accounts with consistent codes and parent-child groups. Opening entries establish balances; transaction vouchers record activity; adjusting entries recognise accruals/allocations; closing entries transfer nominal balances; reports produce statements and ledgers. Role-based access and backups reduce risk.
Core notes
Spreadsheet accounting applications
Spreadsheets can support bank reconciliation, fixed-asset depreciation schedules, loan repayment schedules and ratio analysis. Use clear input cells, formula cells, labels, date and number formats, and control totals. Lock formula cells where possible. A graph should use an accurate scale and labelled axes, and source figures should remain auditable.
Validation can restrict dates, account codes and numeric ranges; verification compares input to source documents. Protect confidential files, use strong access control, retain backups and document formula changes. A spreadsheet is not automatically a secure ledger: version control, review and error checks matter.
Worked example
Step-by-step illustration
| Control | Spreadsheet implementation | Purpose |
|---|---|---|
| Input validation | Allow only date range and valid account code | Prevents malformed entries |
| Reconciliation | Bank book balance compared with statement | Finds timing differences and omissions |
| Formula check | Debits total = credits total | Flags incomplete/unbalanced posting |
| Access control | Restrict edit rights; retain audit trail | Reduces unauthorised change |
For a loan schedule, calculate periodic interest on opening principal, principal repaid = instalment − interest, and closing balance = opening balance − principal repaid. Check that the closing balance trends to zero after the final scheduled instalment, allowing for rounding.
Board preparation
Original practice questions
- Differentiate generic, specific and tailored accounting software.
- Design two validation rules for voucher entry.
- Explain how a spreadsheet can support bank reconciliation and what controls are needed.
Describe the process from source document through validated entry to report. Name the control, the risk it addresses and the evidence it leaves.
These are original practice questions, not claimed previous-year questions. Follow the exact method and rounding instructions in your prescribed text and school guidance.
Current syllabus
How this topic fits the course
Optional alternative to Financial Statement Analysis is part of the CBSE Class XII Accountancy course structure. Computerised Accounting is an alternative to Financial Statement Analysis, not an additional compulsory unit.
Chapter directory