Module                        : ACT 308: Computerised Accounting

          Programme                  : B.Com

Credit Value              : 12

Prerequisite               : ACT 101: Accounting Principles

General Objectives:

·               To impart conceptual knowledge of computerized accounting system that uses database system resources to store, maintain and process accounting data for providing various accounting reports

Learning Outcomes:

Upon the successful completion of this module, student should be able to:

·         explain the fundamental concepts and components of computerized accounting

·         apply accounting package so as to operate and work for setting-up accounting environment, creating vouchers and generating the available accounting reports

·         create necessary database designs for a variety of accounting systems using the concepts of ER and RD Models

·         create and execute SQL statements for retrieving accounting information from databases designed for accounting created in Unit-III above

·         implement database designs for accounting using a particular DBMS software to computerized accounting systems using necessary programming language support

CONTENT

Unit-I: Introduction:                                                                                                      (10 Hours)     

Meaning; Basics of Computerized Accounting

Concept of accounting groups

Hierarchy of accounts

Codification in accounting

Unit-II: Accounting Package-Exposure                                                                         (5 Hours)       

Accounting package

Creation of accounts

Designing and Creating of vouchers

Data Entry Forms

Processing for Reports

Payroll Accounting

Cost Centers

Unit-III: Database Design for Accounting                                                                  (15 Hours) 

Identifying and Appreciating the data CONTENT in accounting transactions; Overview of database concepts, ER model; Creating and implementing RDM for Financial Accounting; SQL to retrieve data and generate accounting information

Documenting transactions using vouchers; System of vouchers and database design for accounting; Storing transaction data.

Unit-IV: Accounting Information and SQL                                                                (12 Hours)

Identifying accounting information and appropriate queries

Forming and executing the SQL

Generating Accounting information for a report

Unit-V:  DBMS and Computerized Accounting                                                         (18 Hours)

Creating data tables defining relationships and constraints

Designing Accounting vouchers

Designing Accounting Reports:

Cashbook

Journal Book

Ledger

Trial Balance

Profit and Loss Account

Balance Sheet

Note:

         The DBMS and accounting package for computerized accounting shall be prescribed by the College. 

         Familiarity with DBMS accounting software shall be imparted through the medium of guidelines that shall be revised every year.

Teaching strategies

·                                 Lectures

·                                 Teaching Lab cum Practical work

·                                 Group Work/Projects and Presentation

Assessment

·         Group Work, Projects and Presentation                                 30%

·         Mid-Term Exam (theory)                                                        20%

·         End-Term Exam (theory-20% and Lab Practical-30%)          50%

                                                                            Total                      100%  

Essential Texts

1.      The Module Guide (Gaeddu College of Business Studies)