CBSE Class 11 Accountancy Chapter 12 Notes: Computers in Accounting

Chapter Overview

Computers in Accounting (also called Applications of Computers in Accounting) is the final chapter of CBSE Class 11 Accountancy. It introduces students to the use of information technology in maintaining accounting records. Unlike other chapters that focus on journal entries and numerical problems, this chapter is primarily theoretical — it covers accounting software, Management Information Systems (MIS), database management, and automation.

Though it carries fewer marks in the exam compared to adjustment or rectification problems, short-answer and long-answer questions from this chapter appear regularly. A clear understanding of the concepts is sufficient to score well.

Need for Computers in Accounting

Traditional manual accounting involves maintaining books of original entry, ledgers, and financial statements by hand. As the volume of transactions increases, manual accounting becomes:

• Slow — each transaction must be recorded, posted, and balanced by hand
• Error-prone — arithmetic mistakes, wrong postings, and omitted entries are common
• Difficult to retrieve — finding a past transaction requires searching through physical books
• Limited in reporting — generating reports like ageing analysis, ratio analysis, or comparative statements is tedious
• Hard to audit — tracing entries and verifying calculations across multiple books is time-consuming
• Inflexible — changes in tax rates, formats, or regulations require manual updating

Computers solve these problems by automating data entry, posting, calculations, and report generation. A computerised accounting system processes thousands of transactions per minute, eliminates arithmetic errors, and produces any report instantly.

Manual vs Computerised Accounting — Detailed Comparison

Components of Computerised Accounting System

A computerised accounting system has five main components:

1. Hardware

The physical equipment used to process accounting data:

• Input devices — keyboard, mouse, scanner, barcode reader
• Processor — CPU that performs calculations and executes instructions
• Output devices — monitor, printer
• Storage devices — hard disk, USB drive, cloud storage
• Network devices — router, modem (for multi-user or cloud access)

2. Software

The programs that process accounting data:

• Operating system — Windows, Linux, macOS
• Accounting software — Tally, Zoho Books, QuickBooks, Busy, etc.
• Database management system — MySQL, PostgreSQL, MS Access
• Utility programs — backup software, antivirus

3. Data

The raw facts and figures entered into the system:

• Master data — permanent information like account names, addresses, tax rates
• Transaction data — day-to-day entries like sales, purchases, receipts, payments
• Reference data — charts of accounts, cost centres, product codes

4. Procedures

The set of rules and instructions that govern how the system operates:

• Data entry procedures (who enters, how, when)
• Authorisation procedures (who approves transactions)
• Backup procedures (frequency, method, storage location)
• Security procedures (password policies, access levels)
• Reporting procedures (which reports, when, to whom)

5. People

The human element — users who operate the system:

• Data entry operators — enter daily transactions
• Accountants — review entries, prepare adjustments, generate reports
• Managers — use reports for decision-making
• System administrators — manage software, security, backups
• Auditors — verify data integrity and compliance

Accounting Software

Types of Accounting Software

Features of Accounting Software

1. Recording of transactions — vouchers for sales, purchases, receipts, payments, journals, and contra entries 2. Automatic posting — one voucher entry automatically updates all related ledgers 3. Preparation of Trial Balance — generated instantly with no errors 4. Preparation of financial statements — Trading A/c, P&L A/c, Balance Sheet at the click of a button 5. Inventory management — stock tracking, reorder levels, batch/serial number tracking 6. Payroll processing — salary calculation, tax deductions, payslip generation 7. Tax compliance — GST returns, TDS calculations, e-filing support 8. Multi-currency support — automatic exchange rate updates, foreign currency transactions 9. Budgeting and forecasting — compare actual vs budgeted figures 10. Audit trail — every transaction tracked with user ID, date, and time stamp 11. Data security — password protection, role-based access, data encryption 12. Reporting — customised reports, graphical charts, export to PDF/Excel/email

Popular Accounting Software

Management Information System (MIS)

Meaning

A Management Information System (MIS) is a structured system that collects, processes, stores, and distributes information to support decision-making, coordination, and control within an organisation.

In the context of accounting, MIS transforms raw financial data into meaningful reports that help managers:

• Monitor revenue, expenses, and profitability
• Track budget vs actual performance
• Identify trends and anomalies
• Make informed decisions about pricing, investment, and cost control

Role of MIS in Accounting

1. Data Collection: Gathers data from accounting software, inventory systems, payroll, and other modules 2. Data Processing: Classifies, summarises, and calculates ratios, variances, and trends 3. Information Generation: Produces reports such as profitability analysis, fund flow statements, and budgetary control reports 4. Decision Support: Provides managers with timely, accurate, and relevant information 5. Feedback Mechanism: Compares planned performance with actual results and highlights deviations

Features of a Good MIS

• Timeliness: Reports are available when needed — not after the decision is already taken
• Accuracy: Data is reliable and error-free
• Relevance: Only information useful for decision-making is included
• Completeness: All necessary data is captured; nothing critical is missing
• Cost-effectiveness: The cost of generating information should not exceed its benefit
• Flexibility: The system adapts to changing information needs
• Security: Access is restricted based on roles; data is protected

Database Management System (DBMS)

Meaning

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

Types of DBMS

Relevance to Accounting

• All accounting software uses RDBMS at the back end
• Transaction data is stored in tables (e.g., Voucher table, Ledger table, Master table)
• Reports are generated by querying these tables using SQL
• Multiple users can access and update data simultaneously (with locking mechanisms)
• Data integrity is maintained through constraints (primary key, foreign key, not null)

Database Design for Accounting

Key Concepts

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

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

Record (Row): A single complete entry in a table. For example, one voucher with all its details is one record.

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

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

Example: Tables in an Accounting DBMS

Vouchers Table:

Ledger Master Table:

Accounting Reports

Accounting reports are the output of the accounting system. They summarise and present financial data in a form useful for decision-making.

Types of Accounting Reports

Characteristics of Good Accounting Reports

• Relevance: Contains only information needed by the user
• Timeliness: Available when the decision is being made
• Accuracy: Free from errors and based on verified data
• Completeness: Covers all aspects the user needs
• Understandability: Presented in a format the user can interpret
• Comparability: Allows comparison across periods, departments, or products

Automation and Security

Automation in Accounting

Computers automate several repetitive tasks that are tedious and error-prone in manual accounting:

1. Automatic posting: Entering a voucher automatically updates all related ledgers 2. Automatic calculation: Depreciation, interest, tax, discounts are computed using built-in formulae 3. Automatic Trial Balance: Generated with zero arithmetic errors 4. Automatic financial statements: Trading A/c, P&L A/c, and Balance Sheet are produced from recorded data 5. Automatic bank reconciliation: Software imports bank statements and matches transactions 6. Automatic reminders: Due dates for payments, receivables, tax filings, and regulatory compliance 7. Automatic backups: Scheduled backups to local or cloud storage

Data Security

Protecting financial data is critical. A computerised accounting system uses multiple layers of security:

1. Password protection: Users must log in with a username and password; passwords are encrypted 2. Role-based access control: Different users have different permissions (e.g., data entry operator can only enter vouchers; manager can approve and view reports) 3. Data encryption: Sensitive data is stored in encrypted form so that even if the database is stolen, it cannot be read without the key 4. Audit trail: Every transaction records who entered it, when, and from which terminal; changes are logged with before-and-after values 5. Data backup: Regular backups (daily or hourly) stored at a different location; cloud backup provides off-site protection 6. Antivirus and firewall: Protects against malware, ransomware, and unauthorised network access 7. Physical security: Server rooms with restricted access; UPS for power backup

Audit Trail

An audit trail is a record that traces the origin, processing, and output of every transaction. It allows auditors to:

• Verify that transactions are authorised and recorded correctly
• Trace any figure in the financial statements back to the original voucher
• Detect unauthorised changes or deletions
• Ensure compliance with accounting standards and regulations

In a computerised system, the audit trail is maintained automatically — every action is logged with the user ID, date, time, and terminal.

Common Mistakes

1. Confusing DBMS with accounting software. DBMS is the underlying data management tool; accounting software is the application built on top of it. 2. Listing only advantages of computerised accounting. Exam questions often ask for limitations too — mention high initial cost, need for training, dependence on electricity, and risk of data loss. 3. Not giving examples of accounting software. Always name specific software (Tally, Zoho Books, QuickBooks) when asked about types. 4. Confusing MIS with accounting software. MIS is broader — it covers all information systems in the organisation; accounting software handles only financial transactions. 5. Forgetting the five components of a computerised accounting system. Hardware, Software, Data, Procedures, and People — all five are essential. 6. Writing vague answers for "features of accounting software." Be specific: automatic posting, instant Trial Balance, inventory management, payroll processing, GST compliance, audit trail. 7. Not knowing the difference between ready-made, customised, and tailor-made software. Ready-made = off the shelf; customised = modified off-the-shelf; tailor-made = built from scratch.

Exam Tips

1. For 1-mark questions: Memorise definitions of computerised accounting, MIS, DBMS, and audit trail. 2. For 3-mark questions: Prepare comparison tables (manual vs computerised, types of accounting software, types of DBMS, types of reports). 3. For 4-6 mark questions: Write structured answers with headings, bullet points, and examples. 4. Name specific Indian accounting software — Tally and Zoho Books are the most commonly expected. 5. Explain the five components with one example each — this is a frequent question. 6. Draw a simple diagram of how data flows from vouchers to ledgers to Trial Balance to financial statements in a computerised system. 7. Know the difference between primary key and foreign key — this has appeared in previous board papers. 8. For MIS, emphasise decision support — managers use MIS reports, not raw data. 9. Do not write long paragraphs. Use tables, bullet points, and numbered lists for clarity. 10. Practise at least two full theory answers from this chapter to get the format right.

Quick Revision Notes

• Computerised accounting = maintaining accounts using software on computers.
• Five components: Hardware, Software, Data, Procedures, People.
• Manual vs Computerised: speed, accuracy, posting, reports, storage, backup, security.
• Three types of software: Ready-made (Tally), Customised (Tally + add-ons), Tailor-made (custom-built).
• MIS = system that collects, processes, and distributes information for decision-making.
• DBMS = software to create, store, retrieve, and manage data in structured format.
• 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 (regular), On-demand (as needed), Special-purpose (specific event).
• Security measures: Password, role-based access, encryption, audit trail, backup, antivirus, firewall.
• Audit trail = record of every transaction showing who, when, and what changes.
• Automation = auto posting, auto calculations, auto Trial Balance, auto financial statements, auto backup.

Related Resources

• [Computers in Accounting — NCERT Exercise Solutions](/school/cbse/class/11/accountancy/solutions/cbse-computers-in-accounting-exercise-solutions)
• [Financial Statements II — Chapter Guide](/school/cbse/class/11/accountancy/cbse-financial-statements-2)
• [Trial Balance and Rectification of Errors — Chapter Guide](/school/cbse/class/11/accountancy/cbse-trial-balance-rectification)
• [All Class 11 Accountancy Solutions](/school/cbse/class/11/accountancy/solutions)
• [Class 11 Accountancy Subject Guide](/school/cbse/class/11/accountancy)