Computers in Accounting — NCERT Class 11 Accountancy

How to Use These Solutions

These NCERT solutions cover every exercise question from CBSE Class 11 Accountancy Chapter 12 — Computers in Accounting. For the best results:

1. Read the NCERT chapter first — this chapter is primarily theoretical; understanding concepts is more important than memorising 2. Use the comparison tables to answer "distinguish between" questions 3. Give examples wherever possible — naming specific software (Tally, Zoho Books) or hardware adds depth to your answer 4. Write in bullet points for 3-mark and 4-mark questions — examiners prefer structured answers 5. Re-attempt any question where your answer misses key points

Key Concepts

Before solving the exercises, review these essentials:

• Computerised accounting = maintaining accounts using accounting software on computers; automates recording, posting, and reporting
• Five components: Hardware, Software, Data, Procedures, People
• Manual vs Computerised: speed, accuracy, posting, reports, storage, backup, security
• Three types of accounting software: Ready-made (Tally), Customised (modified software), Tailor-made (custom-built)
• MIS = Management Information System; collects, processes, and distributes information for decision-making
• DBMS = Database Management System; software to create, store, retrieve, and manage data
• Three types of DBMS: Hierarchical, Network, Relational (RDBMS is most common)
• Key database terms: Table, Field, Record, Primary Key, Foreign Key
• Three types of reports: Routine, On-demand, Special-purpose
• Security measures: Password, role-based access, encryption, audit trail, backup, antivirus
• Audit trail = record of every transaction showing who, when, and what changes

Intext Questions

Computerised accounting is the system of maintaining accounts using accounting software on computers. It automates the recording, classifying, summarising, and reporting of financial transactions.

Differences:

1. Hardware — physical equipment (keyboard, processor, printer, storage) 2. Software — programs (operating system, accounting software, DBMS) 3. Data — master data, transaction data, reference data 4. Procedures — rules for data entry, authorisation, backup, and security 5. People — users (data entry operators, accountants, managers, system administrators)

MIS stands for Management Information System. It is a structured system that collects, processes, stores, and distributes information to support decision-making in an organisation.

In accounting, MIS is useful for: 1. Monitoring revenue, expenses, and profitability 2. Comparing budgeted figures with actual performance 3. Identifying trends, anomalies, and areas needing attention 4. Generating reports like profitability analysis, fund flow statements, and ratio analysis 5. Providing timely and accurate information to managers for decision-making

Chapter-End Exercise

Exercise 1: Define computerised accounting. List any four advantages of computerised accounting over manual accounting.

Definition: Computerised accounting is the system of maintaining accounts using accounting software on computers. It automates the recording, classifying, summarising, and reporting of financial transactions.

Four advantages over manual accounting:

1. Speed and accuracy: Transactions are processed instantly and calculations are automatic, eliminating arithmetic errors that are common in manual accounting. 2. Automatic posting: A single voucher entry automatically updates all related ledger accounts, removing the need for manual posting and the risk of posting errors. 3. Instant reports: Financial statements, Trial Balance, and other reports can be generated at the click of a button, unlike manual preparation which takes hours. 4. Data security and backup: Password protection, encryption, role-based access control, and automatic backup protect financial data from loss, theft, and unauthorised access.

Exercise 2: Distinguish between ready-made and tailor-made accounting software. Give two examples of each.

Exercise 3: What is a Database Management System? Name the different types of DBMS.

A Database Management System (DBMS) is software that allows users to create, store, retrieve, update, and manage data in a structured format. In accounting, the DBMS manages the data that accounting software uses — transaction records, master data, and reports.

Types of DBMS:

1. Hierarchical DBMS: Data organised in a tree-like (parent-child) structure. Each child has only one parent. Example: IBM IMS. 2. Network DBMS: Extension of hierarchical model where a child can have multiple parents. Supports many-to-many relationships. Example: IDMS. 3. Relational DBMS (RDBMS): Data stored in tables (rows and columns) linked through common fields (keys). Most widely used in modern accounting. Examples: MySQL, PostgreSQL, Oracle, MS SQL Server.

Exercise 4: Explain the following terms: (a) Table, (b) Field, (c) Record, (d) Primary Key, (e) Foreign Key.

(a) Table: A collection of related data organised in rows and columns. In an accounting DBMS, examples include the Vouchers table, Ledger table, and Party Master table.

(b) Field: A specific category of data within a table, represented as a column. For example, in a Vouchers table, fields include Voucher No., Date, Account Code, Debit Amount, and Credit Amount.

(c) Record: A single complete entry in a table, represented as a row. For example, one voucher with all its details (Voucher No., Date, Amounts, Narration) is one record.

(d) Primary Key: A field (or combination of fields) that uniquely identifies each record in a table. No two records can have the same primary key value. For example, Voucher No. is the primary key of the Vouchers table.

(e) Foreign Key: A field in one table that refers to the primary key of another table, creating a relationship between the two tables. For example, Account Code in the Vouchers table is a foreign key that links to the Account Code in the Ledger Master table.

Exercise 5: What is an audit trail? Why is it important in a computerised accounting system?

An audit trail is a record that traces the origin, processing, and output of every transaction in the accounting system. It shows who entered the transaction, when it was entered, from which terminal, and what changes (if any) were made later.

Importance in a computerised accounting system:

1. Verification: Auditors can trace any figure in the financial statements back to the original voucher entry. 2. Authorisation check: Confirms that every transaction was authorised before being recorded. 3. Detection of fraud: Unauthorised changes or deletions are flagged with user ID and timestamp. 4. Compliance: Ensures the system meets accounting standards and regulatory requirements. 5. Data integrity: Prevents tampering because every modification is logged with before-and-after values. 6. Accountability: Each user is responsible for their own entries and modifications.

Exercise 6: What are the different types of accounting reports? Explain briefly.

1. Routine Reports: Generated at regular intervals (daily, weekly, monthly, quarterly, annually). These are standard reports that the organisation needs on a fixed schedule. Examples: Daily cash report, monthly Trial Balance, quarterly GST return, annual financial statements.

2. On-demand Reports: Generated whenever a specific need arises. The user specifies parameters like date range, account, or category. Examples: Customer-wise outstanding report, product-wise sales analysis, ageing analysis of debtors, cost centre report.

3. Special-purpose Reports: Prepared for a specific event or unique requirement. These are not part of regular reporting. Examples: Project cost report, fund flow analysis, forensic audit report, feasibility study report.

Exercise 7: State any four limitations of computerised accounting.

1. High initial cost: Purchasing hardware, software, and setting up the system requires significant investment compared to manual books. 2. Need for training: Staff must be trained to operate the software, which takes time and additional cost. 3. Dependence on technology: The system depends on electricity, hardware, and software functioning properly. Power failures or system crashes can disrupt work. 4. Risk of data loss: If proper backup procedures are not followed, data can be lost due to hardware failure, virus attacks, or accidental deletion. 5. Security concerns: Despite passwords and encryption, the system is vulnerable to hacking, unauthorised access, and cyber attacks. 6. Inflexibility of ready-made software: Off-the-shelf software may not fit the unique needs of every business, and customisation can be expensive.

Related Resources

• [Chapter 12 Guide — Computers in Accounting](/school/cbse/class/11/accountancy/cbse-computers-in-accounting)
• [All Class 11 Accountancy Solutions](/school/cbse/class/11/accountancy/solutions)
• [Class 11 Accountancy Subject Guide](/school/cbse/class/11/accountancy)