Computerized Accounting

Paper Code: 
ATG-421
Credits: 
6
Contact Hours: 
90.00
Max. Marks: 
100.00
Objective: 

The objective this course is to -

·        Gain expert knowledge of principle and procedure of computerized accounting

·        Enable students with the application of computerized accounting in different practical situations.

Course Outcomes (COs):

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Paper Code

Paper Title

 ATG-421

 

Computerized Accounting

CO77:Attain a comprehensive skill set with Tally Accounting Software

CO78:Create finance- and accounting-related spreadsheets and charts by enhancing previously acquired finance, accounting and computer skills.

CO79:Critical Thinking and Problem-solving skills in analyzing financial information.

CO80:Once you understand computerized accounting, you will be amazed at how much better you can be at organizing your own finances.

Approach in teaching: Learning how to work in tally.

2. How to generate reports using Tally.

3. How to analyze and interpret financial information using Ms Excel

4. Creating your own financial portfolio.

Teaching Strategies:

1. Working with Tally ERP.

2. Working with Ms Excel

3. Watching you tube videos

4. Preparing financial reports

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Individual projects. Tally workings.

Ms Excel Worksheets

PPT on analysis of financial information

 

18.00
Unit I: 

• Computerized Accounting: Introduction, Double entry system of Book-Keeping, types of accounts, Mode of Accounting, Financial Statements, Manuals Accounting v/s Computerized Accounting. Accounting with Tally: Introduction, company creation, company features and configurations

18.00
Unit II: 

• Creating Accounting masters in Tally: List and charts of Accounts, Creation of groups and ledgers, Display and Alter of Groups and Ledgers, Accounting Vouchers, Accounting Voucher entry. Use of excel in Accounting

20.00
Unit III: 

• Financial Report Generation through Excel, Financial Statement Analysis / Ratio Analysis Vertical Analysis or Common Size Statements using Excel, Horizontal Analysis & Trend Analysis using Excel, Case Study of Alibaba Financial and Valuation Guide.

22.00
Unit IV: 

• Models Using Excel
• Discounted Cash Flow Model: Discounted Cash Flow Model – Example
• Leveraged Buyout Model: LBO Model Example
• Comparable Company Analysis Mode: Comparable Company Analysis Model – Example
• Mergers & Acquisitions Model

12.00
Unit V: 

• Advantages of Computerized Accounting: Security Controls, Backup and Restore, Export and Import of Data & Printing Reports.

Essential Readings: 

1. Advanced Accounts:R. L Gupta & R Radhaswamy (S.Chand& Sons)
2. Tally Module

References: 

1. Modern Accountancy- A Mukharjee& M Hanif (Tata McGraw Hill)
2. Advanced Accounts-Shukla, Grewal, Gupta(S.Chand)
3. Advanced Accountancy-S.N Maheshwari (Vikas Publishing House Pvt Ltd)

Academic Year: