Accounting Software (Skill Enhancement)

Paper Code: 
25SATG501
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to gain understanding of the basics of accounting software Tally.

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

25SATG301/25SATG501

 

Accounting Software

(Practical)

 

CO1: Develop an understanding of Tally Accounting software & frame various ledger accounts

CO2:     Create basic accounting vouchers, journal entries &  examine the procedure of maintaining balances of accounts.

CO3: Develop system for inventory management using Tally.

CO4: Adapt the concept of presentation of financial statements in day book and final accounts through excel

CO5: Take part in  applications of MS Access, preparation of tax invoices, GST Registration process & E way bills

CO6:Contribute effectively in course specific interaction.

Approach

in

teaching:

Interactive

Lectures,

Discussion,

Tutorials,

Problem solving sessions, Presentations

Learning

activities

for the

students:

Self-learning

assignments, Case Study analysis, Presentations, Group discussions

  

Continuous Assessment Test, Semester End Examinations, Quiz, Solving numerical problems, Assignments, Class Presentations, Individual and group projects.

 

12.00
Unit I: 
Introduction to Tally software and Accounting Master management:
  • Introduction to tally- Functional Features & Technological Advantages of Tally Software, Creation/ Display/ Alteration/ Deletion of a Company.
  • Tally Software Screen Components, Mouse/ Keyboard Conventions, switching between Screen Areas, Quitting Tally Software.
  • Pre-defined Groups of Ledger Accounts, Pre-defined Ledger Accounts.
  • Creation/ Display/ Alteration/ Deletion of Accounting Master; i.e., Ledger Accounts and Groups in Tally Software, List/ Chart of Accounts.
12.00
Unit II: 
Basic Accounting Vouchers and their management, journalizing:
  • Basic Accounting Voucher Types, Creation/ Display/ Alteration/ Deletion of Accounting Vouchers (Journal Entries),
  • Journalizing Compound Journal Entries in Tally Software, Creation/ Display/ Alteration/ Deletion of Accounting Voucher in Single Entry Mode/ Invoice Mode.
  • Maintaining Balances Bill-by-Bill of the Accounts of Debtors & Creditors and Mentioning Opening Balance during Ledger Creation.
12.00
Unit III: 
Inventory management in tally:
  • Creation/ Display/ Alteration/ Deletion of a Company for Inventory Accounting, Concepts of Stock Groups, Stock Categories, Godowns/ Locations,
  • Units of Measure and Stock Items,
  • Purchase & Sales Transactions & Invoicing, Debit note & Credit note
  • Use of Stock Journal for Stock Transfer, Display of Stock Summary (Stock Register), Inventory Books and Statement of Inventory, Use of F2 (Date/ Period) and F12 (Configure) during Display of Inventory Reports.
12.00
Unit IV: 
Advanced Excel for Accounting and Financial Analysis:

·        Accounting in Excel- Financial Report Generation through Excel, Financial Statement Analysis / Ratio Analysis Vertical Analysis or Common Size Statements using Excel, Horizontal Analysis & Trend

Analysis using Excel Application of MS-Excel in accounting- Basic functions, Mathematical and statistical Functions, logical functions, Date & Time functions, Financial Functions, what if analysis, Plotting of Graphs & Descriptive Statistics

12.00
Unit V: 
Data Management using MS Access and GST compliance:
  • ·        Data management using MS-ACESS (creating tables, forms,                   queries and reports), importing and exporting data.
  • ·        Preparation of tax invoices, debit note and credit note
  • ·        GST registration process and filling of GST returns, Electronic                 ledgers
  • ·        Process of payment of GST
  •         E-way bill procedures 
Essential Readings: 
  • Computerised Accounting- Neeraj Goyal & Rohit Sachdeva (Kalyani Publishers)
  • Computerised Accounting- M.Yadagiri & G. Srinivas (Bandla Publishers)
  • Computerized Accounting System- Manoj Bansal & Ajay Sharma (Sahitya Bhawan Publications, Agra)
  • Mastering Excel 2000 – Martin, Hansen, Klingher& Beth
  • SSC Study, Tally ERP 9 Book
References: 

Suggested Readings:

  • Computerized Accounting- Prof. C.M. Tembhurnekar, Dr. Alok Dwivedi (Sai Jyoti Publication)
  • Computer Accounting Systems Tutorial- Michael Fardon (Osborne Books Ltd.)
  • Tally ACE Tally Education Pvt. Ltd.,
  • Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
  • ShubhiLall, Elementary Computer Application

E-Content:

 

Reference Journals:

Academic Year: