Class 12 Commerce . Accountancy . Computerised Accounting System . Overview of Computerised Accounting System

Chapter 1: Overview Of Computerised Accounting System

Ch 1

Accountancy

Class 12 Commerce

Lecture 1

Introduction

Introduction to Computerised Accounting

Why businesses use computers and IT

  • Speed and accuracy: Computers help process accounting transactions quickly and accurately, with timely access to information.
  • Decision-making: Timely information supports business decisions, strengthens competitive advantage and can improve profitability.
Definition

Computerised Accounting System (CAS) — A system that processes accounting transactions using hardware and software to produce accounting records and reports.

Five components of CAS
ComponentMeaning
ProcedureA logical sequence of actions used to perform a task.
DataRaw facts entered as input for a business application.
PeopleThe users of the system.
HardwareThe computer, associated peripherals and their network.
SoftwareSystem software and application software.
Computer system components: hardware and software; software includes system and application software.
Computer system components: hardware and software; software includes system and application software.

Processing Transactions and Producing Reports

CAS processing

  1. Accounting transactions are entered as inputs.
  2. Accounting software processes the transaction data.
  3. The system generates accounting records and reports, which can be displayed or printed.

Reports produced by CAS

  • Day books/Journals record transactions.
  • Ledger groups transaction entries by account.
  • Trial Balance lists account balances.
  • Position Statement (Balance Sheet) and Statement of Profit and Loss report financial position and performance.
Accounting transactions pass through accounting software to produce displayed or printed information.
Accounting transactions pass through accounting software to produce displayed or printed information.

Data and Information

Definition

Data item (data element) — The smallest named unit of data in an information system.

Transaction data

  • Accounting transaction: A record of the inflow and outflow of resources.
  • Four data elements: Account name, accounting code, transaction date and amount.
  • Processing: Transaction data is processed by accounting software to create information such as journals and ledgers.
Data vs Information
PointDataInformation
MeaningRaw facts or inputs.Data processed to meet a decision-maker’s needs.
ExampleDays worked and rate per day.The resulting amount payable.
Pay amount example
A=d×rA = d \times r

Multiply the number of days worked, dd, by the rate per day, rr, to find the amount payable, AA.

Information at different levels

Information at one level can serve as data at another; after further processing for a decision-maker’s needs, it becomes information at that level.

Name the five components of a Computerised Accounting System.

Answer: Procedure, data, people, hardware and software.

List four data elements in an accounting transaction.

Answer: Account name, accounting code, transaction date and amount.

Quick recap

  • CAS uses hardware and software to process accounting transactions into records and reports.
  • The five CAS components are procedure, data, people, hardware and software.
  • CAS can produce journals, ledgers, trial balances and financial statements.
  • A transaction records resource inflows and outflows and has four key data elements.
  • Processing raw data produces information for users and decision-making.
  • Information at one level may become input data for further processing.
Lecture 2

Components Of CAS

Accounting Cycle

Stages of the accounting cycle

  1. Analyse business transactions.
  2. Record the transactions in the journal.
  3. Post journal entries to ledger accounts.
  4. Prepare a trial balance from account balances.
  5. Review accounts and make necessary adjustments.
  6. Post adjustments to the ledger and prepare the adjusted trial balance.
  7. Use the adjusted trial balance to prepare the balance sheet and profit and loss account.
  8. Prepare financial statements from the finally adjusted ledger and balanced accounts.

Computerised processing

  • Computer processing: The accounting cycle can be carried out using computers.
Pay from days worked
P=d×rP = d \times r

Multiply the number of days worked by the daily rate to calculate the amount to pay.

Days worked multiplied by the daily rate gives the amount to pay.
Days worked multiplied by the daily rate gives the amount to pay.

Salient Features of CAS

Features of CAS
FeatureKey points
Simple and integratedAutomates and connects sales, finance, purchases, inventory and manufacturing. It provides accurate, up-to-date information quickly; it may also support MIS, multilingual use and organised data.
Transparency and controlImproves access to vital information and visibility of day-to-day operations, allowing more time for planning and supporting user satisfaction.
Accuracy and speedUser-definable data-entry templates support fast, accurate transaction entry and help generate documents and reports.
ScalabilityAdjusts to changes in data-processing volume and can be used by organisations of different sizes and types.
ReliabilityHelps ensure critical financial information is accurate, controlled and secure.

Quick recap

  • The accounting cycle identifies, measures and communicates information through journals, ledgers, trial balances and adjustments.
  • Financial statements are prepared according to GAAP; the manual system has traditionally been the most popular record-keeping method.
  • Computers can process the accounting cycle.
  • CAS integrates business operations and helps provide accurate, up-to-date information.
  • The key CAS features are simplicity and integration, transparency and control, accuracy and speed, scalability, and reliability.
Lecture 3

Grouping Of Accounts Parts I

Accounting Equation and Account Groups

Definition

Accounting equation — The accounting equation expresses the equality between a business’s assets and the claims against those assets.

Basic accounting equation
A=E,E=L+C,A=L+CA = E,\quad E = L + C,\quad A = L + C

Equities comprise liabilities and capital.

What the equation represents

  • A = assets; E = equities; L = liabilities; C = capital.
  • Liabilities represent creditors’ claims; capital represents owners’ claims.
  • Profit or loss changes the owners’ claim and is summarised through the income statement.
Equation including income and expenses
A=L+C+(R−X)A = L + C + (R - X)

Revenue increases capital; expenses consume resources in earning revenue.

Definition

Revenue — An inflow of resources from selling goods or services in the normal course of business, increasing capital.

Definition

Expenses — Resources consumed while generating revenue.

Main Groups of Accounts

Equity and liabilities
Main groupSubgroups and accounts
Shareholders’ fundsShare capital; reserves and surplus; money received against share warrants; share application money pending allotment
Non-current liabilitiesLong-term borrowings; deferred tax liabilities (net); other long-term liabilities; long-term provisions
Current liabilitiesShort-term borrowings; trade payables; other current liabilities; short-term provisions
Assets
Main groupSubgroups and accounts
Non-current assetsFixed assets: tangible assets, intangible assets, capital work-in-progress, intangible assets under development, fixed assets held for sale; non-current investments; deferred tax assets (net); long-term loans and advances; other non-current assets
Current assetsCurrent investments; inventories; trade receivables; cash and cash equivalents; short-term loans and advances; other current assets
Revenues and expenses
GroupExamples
RevenuesSales; other income
ExpensesMaterial consumed; salary and wages; manufacturing expenses; depreciation; administrative expenses; interest; selling and distribution expenses

Why classification matters

  • Classification organises the growing volume of transaction data into useful account groups.
  • Hierarchy links each main group to its subgroups and individual accounts.
  • Codification assigns identifiers that preserve this hierarchy and support preparation of the Balance Sheet and Statement of Profit and Loss.

Codification of Accounts

Definition

Code — An identifying mark made of letters or figures that gives information a concise form and supports machine processing.

Purpose and structure

  • Account-head codes should group accounts at different levels to produce the Balance Sheet (Position Statement) and Statement of Profit and Loss.
  • First digit identifies the top-level account group; further digits identify subgroups.
  • Ascending order of codes automatically lists accounts in the intended hierarchy.
  • Gaps between subgroup codes leave room to add groups later.
Illustrative account codes
CodeAccount group
11Equity and liabilities
22Assets
33Revenues
44Expenses
1111Shareholders’ funds
1313Non-current liabilities
1414Current liabilities
2121Non-current assets
2323Current assets
Memory hook Prepzy tip

Codes keep accounts in order

Read the code from left to right: the first digit gives the broad group, and later digits narrow it to subgroups and accounts.

Quick recap

  • The accounting equation is A=L+CA = L + C, or assets = liabilities + capital.
  • Profit or loss affects owners’ claims; the expanded equation is A=L+C+(R−X)A = L + C + (R - X).
  • Accounts are classified into equity and liabilities, assets, revenues, and expenses.
  • Assets and liabilities are further grouped as current or non-current where applicable.
  • Codes represent account groups at successive levels and support financial statement preparation.
  • Listing codes in ascending order displays accounts in the intended hierarchy; gaps allow flexibility.
Lecture 4

Grouping Of Accounts Parts II

Sequential Codes

Worked example

Which code is missing from the sequence CL001, CL002, CL004?

  1. Compare the document codes CL001, CL002 and CL004 in order.
  2. The sequence skips CL003, so that code may relate to a missing document.
Answer: CL003 is missing.

Block Codes

Worked example

What dealer type does code 325 represent?

  1. Code 325 falls within the range 300–399.
  2. The 300–399 block is assigned to pipes.
Answer: Pipes.

Mnemonic Codes

Worked example

Give the mnemonic code for Head Quarters.

  1. Take the initial letters of Head Quarters.
  2. Use HQ as the abbreviation-based code.
Answer: HQ.

Developing a Coding Structure

Student Code Structure

  • Order: School → Entry-year → Stream → Class → Section → Student.
  • Length: The six segments use a total of 10 digits.
  • Information available: The code can identify the student's school, entry year, stream, class, section and student number.
  • Record search: Codes can help list students who entered a particular school in a given year.

Assigning a Student Code

  1. Identify the value of each student attribute in the planned hierarchy.
  2. Convert each value to its assigned code and required digit length.
  3. Arrange the segments in the specified order, retaining leading zeroes.
Worked example

What code can be formed for student 54, who entered Section B of Class XII in 2008, chose Science (non-biology; stream code 1), and attends School 6?

  1. School 6 is written as 06, and entry-year 2008 is represented by 08.
  2. Use stream code 1, Class XII as 12, and student number 54.
  3. The section is Section B, but the section-letter-to-digit mapping is not given.
  4. Arrange the known segments in order and leave the section digit undetermined: 06 | 08 | 1 | 12 | ? | 54.
Answer: The known segments are 06 | 08 | 1 | 12 | ? | 54. A complete 10-digit code cannot be determined from the information provided because the digit for Section B is unspecified.
The code digits represent school, entry-year, stream, class, section and student number.
The code digits represent school, entry-year, stream, class, section and student number.
Practice

A trading firm assigns codes 200–299 to medium pumps. What type is code 248?

Hint: Find the range containing 248.
Key step: 248 lies in the 200–299 block.
Solution: Medium pumps.
Practice

What does stream code 0 indicate for primary or secondary classes?

Hint: Recall the code used when stream is not applicable.
Key step: Stream is not relevant at these levels.
Solution: The stream does not apply; code 0 is used.
Practice

How many digits are assigned to the Student segment, and how many students in a section does it accommodate?

Hint: Use the segment length and stated capacity.
Key step: The Student segment is two digits long.
Solution: Two digits, accommodating up to 99 students in a section.

Quick recap

  • Sequential codes use consecutive numbers and/or letters to trace documents and spot missing codes.
  • Block codes assign number sub-ranges to specific groups.
  • Mnemonic codes use letters or abbreviations to represent information.
  • A coding structure follows an attribute hierarchy and assigns enough digits to each segment.
  • The student code has 10 digits: school, entry-year, stream, class, section and student number.
  • Use stream code 0 when stream is not applicable; include a Trust segment if multiple trusts must be distinguished.
  • The Section B code digit cannot be inferred without a section-to-digit mapping.
Lecture 5

Using Software Of CAS

Using CAS Software

CAS Activities

  • One-time activities: Set up organisation details, the accounting year and ledger types; these create master files.
  • Recurring activities: Enter transactions and generate accounting reports.

Transaction Vouchers and Reports

  • Vouchers: Transactions are entered using cash, bank, purchase, sales and journal vouchers.
  • Books and statements: CAS can generate day books, ledgers, trial balance, Statement of Profit and Loss, Position Statement and Cash Flow Statement.

Security Features of CAS

Purpose

  • CAS security: Protects the security, safety and confidentiality of accounting data.
Main Security Features
FeatureMeaning and purpose
Password securityA password is the code that allows access to the system. User rights can be set according to organisational policy, allowing access to some data while restricting other data.
Data auditShows who made changes to original data and what changes were made. It helps assign responsibility for manipulation and supports data integrity; it is similar to an audit trail.
Data vaultProvides additional protection through data encryption.
Definition

Encryption — The process of scrambling information so that it is extremely difficult to interpret without decoding it.

How Encryption Protects Data

  1. Information is encrypted (scrambled).
  2. If it reaches the wrong hands, it remains extremely difficult to interpret.
  3. The receiver must decode it to read and understand the information.

Advantages of CAS

  • Timely information: Generates reports on time and in the desired format.
  • Efficient records: Supports efficient accounting record-keeping.
  • Effective control: Helps maintain control over the accounting system.
  • Economy: Makes the processing of accounting data economical.
  • Confidentiality: Helps maintain data confidentiality.

Limitations of CAS

  • Technology obsolescence: Rapid technological change requires investment at shorter intervals.
  • Power interruptions: Data may be lost or corrupted.
  • Hacking risk: Data is vulnerable to hacking.
  • Report constraints: Reports that are not programmed or specified in the software cannot be generated.

Distinguish between one-time and recurring activities in CAS.

Answer: One-time activities set up organisation details, the accounting year and ledger types to create master files. Recurring activities include entering transactions and generating reports.

How do data audit and data vault protect CAS data?

Answer: Data audit records who changed the original data and what was changed, supporting responsibility and data integrity. A data vault uses encryption to make information difficult to interpret if it reaches the wrong hands.

Quick recap

  • CAS has one-time setup activities and recurring transaction-entry and reporting activities.
  • Transactions are recorded through cash, bank, purchase, sales and journal vouchers.
  • Common reports include day books, ledgers, trial balance and financial statements.
  • Password security restricts access, data audit tracks changes, and data vault encryption scrambles information.
  • CAS supports timely reporting, efficient record-keeping, effective control, economy and confidentiality.
  • CAS limitations include technological obsolescence, power-related data loss, hacking and inability to generate unprogrammed reports.
Lecture 6

Accounting Information System (AIS)

AIS and Its Sub-systems

Interconnected sub-systems of an Accounting Information System.
Interconnected sub-systems of an Accounting Information System.

Cash and Bank Sub-system

  • Purpose: This AIS sub-system records and monitors an organisation’s cash and bank transactions.
  • Role: It supports the recording and reporting of cash receipts and payments.

Sales and Accounts Receivable Sub-system

  • Purpose: This AIS sub-system records sales transactions and tracks amounts due from customers.
  • Role: It provides information to monitor sales and customer collections.

Inventory Sub-system

  • Purpose: This AIS sub-system maintains records of goods and other inventory items.
  • Role: It helps provide information about inventory quantities and value.

Purchase and Accounts Payable Sub-system

  • Purpose: This AIS sub-system records purchases and amounts payable to suppliers.
  • Role: It supports the monitoring of supplier obligations and payments.

Payroll Accounting Sub-system

  • Purpose: This AIS sub-system records employee wages and salaries.
  • Role: It supports the calculation and reporting of employee payments.

Fixed Assets Accounting Sub-system

  • Purpose: This AIS sub-system maintains records of an organisation’s fixed assets.
  • Role: It provides information for monitoring assets and their accounting values.

Expense Accounting Sub-system

  • Purpose: This AIS sub-system records and classifies the expenses incurred by an organisation.
  • Role: It helps organise expense information for accounting and reporting.

Tax Accounting Sub-system

  • Purpose: This AIS sub-system supports the recording and reporting of an organisation’s tax obligations.
  • Role: It helps the organisation meet applicable tax requirements.

Final Accounts Sub-system

  • Purpose: This AIS sub-system brings together accounting information for financial reporting.
  • Role: It supports the preparation of reports on an organisation’s financial performance and position.

Costing Sub-system

  • Purpose: This AIS sub-system supports the planning and monitoring of an organisation’s costs.
  • Role: It provides cost information for analysing business operations.

Budget Sub-system

  • Purpose: This AIS sub-system supports financial planning and performance monitoring.
  • Role: It helps compare planned results with actual performance.

Management Information System

  • Purpose: A Management Information System (MIS) generates and processes reports needed for management decisions.
  • Flexibility: It should provide customised reports to meet different managerial information needs.
  • Functions: MIS supports planning, organising, staffing, oversight, control and decision-making.
  • Decision levels: It assists operational, functional and strategic management.

Quick recap

  • AIS uses interconnected sub-systems to record and process accounting information.
  • Cash and bank, sales and receivables, inventory, and purchases and payables handle key transaction cycles.
  • Payroll, fixed-assets and expense sub-systems record employee payments, assets and expenses.
  • Tax and final-accounts sub-systems support tax compliance and financial reporting.
  • Costing uses linked information to determine production costs and report cost changes.
  • The budget sub-system supports budgeting and comparison with actual performance.
  • MIS supplies flexible reports for operational, functional and strategic management decisions.
Lecture 7

Summary

Computerised Accounting System

  • Meaning: A Computerised Accounting System (CAS) processes accounting transactions using computer hardware and software.
  • Output: It produces accounting records and reports such as journals, ledgers, trial balances and financial statements.

Coding in CAS

  • Purpose: Coding identifies account heads and other items processed in a CAS.
  • Structure: The coding structure should match the hierarchy of the item being coded.
  • Use: Account codes help organise and summarise information for the Balance Sheet and Statement of Profit and Loss.

Advantages and Limitations of CAS

  • Advantages: CAS enables faster, more efficient and accurate processing while saving costs and maintaining data confidentiality.
  • Limitations: Technology can become obsolete quickly; power interruptions or hardware damage may cause data loss, and systems face security risks.

Accounting Information System

  • Meaning: An Accounting Information System (AIS) integrates related sub-systems to process accounting information.
  • Sub-systems: These include cash and bank, sales and receivables, inventory, purchases and payables, payroll and fixed assets.
  • Other areas: AIS also includes expense, tax, final accounts, costing, budget and management information sub-systems.
  • Purpose: Together, the sub-systems provide information for accounting records, reports and management decisions.

Quick recap

  • CAS processes accounting transactions using computer hardware and software.
  • Accounting software is application software; Tally is one example.
  • Coding structures should suit the elements being coded and support required summaries.
  • CAS offers speed, efficiency, accuracy, cost saving and data confidentiality.
  • CAS risks include rapid obsolescence, data loss and security hazards.
  • AIS integrates specialised sub-systems, from cash and inventory to budgeting and management information.

Formula sheet

Pay amount example
A=d×rA = d \times r
Pay from days worked
P=d×rP = d \times r
Basic accounting equation
A=E,E=L+C,A=L+CA = E,\quad E = L + C,\quad A = L + C
Equation including income and expenses
A=L+C+(R−X)A = L + C + (R - X)

Accountancy — ALL CHAPTERS

1

Accounting for Share Capital

View

2

Issue and Redemption of Debentures

View

3

Financial Statements of a Company

View

4

Analysis of Financial Statements

View

5

Accounting Ratios

View

6

Cash Flow Statement

View

1

Overview Of Computerised Accounting System

View

2

Spreadsheet

View

3

Use Of Spreadsheet In Business Applications

View

4

Graphs And Charts For Business Data

View

1

Accounting for Partnership: Basic Concepts

View

2

Reconstitution of a Partnership Firm –Admission of a Partner

View

3

Reconstitution of a Partnership Firm –Retirement/Death of a Partner

View

4

Dissolution of Partnership Firm

View