10 or 12th PASS / if passed by commerce ( benefits for quick learning )

Tally Essential Comprehensive

Course name: Tally Essential Comprehensive

About the programme:

This course covers all aspects of financial accounting concepts ranging from basics to

intermediate. It's enriched with illustrations and self-learning videos, along with

industry-based scenarios. Based on the latest release of Tally-TallyPRIME, the course shall

also provide exposure to the practical application of skills.

Programme outcomes:

1.       Accounting

2.       Taxation

3.       Inventory

4.       Data analysis

5.       MIS reporting

Eligibility criteria: Class 10- 12 pass-outs

Graduation in any stream ( Candidates pursuing graduation can also apply for this course)

Duration of the programme:

● Hours: 106

● Days: 106

● Months: 4

Course Syllabus:

Module 1:

 TallyEssential Level 1

Unit: Fundamentals of Accounting

1.1 Introduction

1.1.1 Meaning of Accounting

1.2 Terminologies used in Accounting

1.3 Concepts of Accounting

1.4 Double Entry System of Accounting

1.4.1 Uses of Debit and Credit

1.4.2 Rules of Debit and Credit

1.5 Golden Rules of Accounting

1.6 Recording of Business Transactions

1.6.1 Journalising Transactions

1.7 Trial Balance

1.8 Financial Statements

1.8.1 Trading Account

1.8.2 Profit & Loss Account

1.8.3 Balance Sheet

1.9 Subsidiary Books & Control Accounts

1.9.1 Cash Book

1.9.2 Petty Cash Book

1.9.3 Purchase (Journal) Book

1.9.4 Purchases Return (Journal) Book

1.9.5 Sales (Journal) Book

1.9.6 Sales Return (Journal) Book

1.9.7 Journal Proper

1.9.8 Control Accounts

1.10 Depreciation

1.10.1 Methods for Depreciation

1.10.2 Preparation of Depreciation schedule

1.11 Computerised Accounting

1.11.1 Advantages of computerised accounting

1.11.2 Accounting Structure for computerised accounting

Module 2: TallyEssential Level 1

Unit: Introduction to TallyPrime

2.1 Introduction

2.2 Features of TallyPrime

2.3 Downloading and Installation of TallyPrime

2.4 Types of Licenses in TallyPrime

2.5 Activate New License

2.6 Reactivate License in TallyPrime

2.7 Use License from Network in a Multiuser Environment

2.8 Working TallyPrime in Educational Mode

2.9 Company Creation and Setting up Company Features in TallyPrime

2.10 Getting Started with TallyPrime

2.10.1 Navigating from Anywhere to Anywhere in TallyPrime

2.11 F12 Configuration in TallyPrime

2.12 Alter Company Details

2.13 Shut the Company Conclusion Key Takeaways Practice Exercises

Module 3 TallyEssential Level 1

Unit: Maintaining Chart of Accounts

3.1 Introduction

3.2 Chart of Accounts

3.3 Creation of Masters in TallyPrime

3.3.1 Accounting Masters

3.3.2 Inventory Masters

3.4 Alteration of Masters in TallyPrime

3.5 Deletion of Masters in TallyPrime

3.6 Multi-Masters Creation and Display of Chart of Accounts

3.6.1 Multi Groups Creation

3.6.2 Multi Ledgers Creation

3.6.3 Multi Stock Groups Creation

3.6.4 Multi Stock Items Creation Conclusion Key Takeaways Shortcut Keys Practice

Exercises

Module 4: TallyEssential Level 1

Unit: Recording and Maintaining Accounting Transactions

4.1 Introduction

4.2 Recording Transactions in Tally

4.3 Recording Accounting Vouchers in TallyPrime

4.3.1 Receipt Voucher (F6)

4.3.2 Contra Voucher (F4) 4.3.3 Payment Voucher (F5)

4.3.4 Purchase Voucher (F9)

 4.3.5 Sales Voucher (F8)

4.3.6 Debit Note Voucher (Alt+F5)

4.3.7 Credit Note Voucher (Alt+F6)

4.3.8 Journal Voucher (F7) Conclusion Key Takeaways Shortcut Keys Practice Exercises

Module 5: TallyEssential Level 1

Unit: Banking

5.1 Introduction

5.2 Banking Payments

5.3 Cheque Printing

5.3.1 Single Cheque Printing

5.3.2 Multi Cheque Printing

5.4 Deposit Slip

5.4.1 Cheque Deposit Slip

5.4.2 Cash Deposit Slip

5.5 Payment Advice

5.6 Bank Reconciliation

5.6.1 Manual Bank Reconciliation

5.6.2 Auto Bank Reconciliation Conclusion Key Takeaways Shortcut Keys Practice

Exercises

Module 6: TallyEssential Level 1

Unit: Generating Financial Statements and MIS Reports

6.1 Introduction

6.2 Final Accounts Reports in Tally

6.2.1 Trial Balance

6.2.2 Profit and Loss Account

6.2.3 Balance Sheet

6.2.4 Cash Flow & Fund Flow Analysis Report

6.2.5 Receipts and Payments

6.3 MIS Reports in Tally

6.3.1 Stock Summary Analysis

6.3.2 DayBook

6.3.3 Cash and Bank Book

6.3.4 Purchase Register

6.3.5 Sales Register

6.3.6 Journal Register

6.4 Bird’s eye view/Drill down display from anywhere to anywhere Conclusion Key

Takeaways Shortcut keys Practice Exercises

Module 7: , Unit: Data Security

7.1 Introduction

7.2 Security Control

7.3 Activation of Security Control

7.4 Creation of Security Levels (User Roles)

7.5 Creation of Users And Passwords for Company

7.6 Accessing the company using Security Levels

7.7 Auto Login

7.8 TallyVault Conclusion Key Takeaways Shortcut Keys Practice Exercises

Module 8: TallyEssential Level 1

Unit: Company Data Management

8.1 Introduction

8.2 Backup of Company Data

8.3 Restoring of Company Data

8.4 Company Data Repair

8.5 Migration of Tally.ERP 9 Company Data to TallyPrime Conclusion Key Takeaways

Shortcut Keys Practice Exercises, Key Answers for Practice Exercises, Business Case Studies-1

Module 9: TallyEssential Level 2, Unit: Storage and Classification of Inventory

1.1 Introduction

1.2 Supply Chain

1.2.2 Types of Suppliers

1.3 Inventory Management

1.3.1 Terms Used in Inventory Management

1.4 Inventory Masters in TallyPrime

1.4.1 Company Creation in TallyPrime

1.4.2 Introduction of Capital to a Business

1.4.3 Creation of Inventory Masters in TallyPrime

1.5 Tracking of Movements of Goods in Batches/Lots

1.5.1 Activation of Batches/Lots for Stock Items

1.5.2 Batch Reports

1.6 Price Levels and Price Lists

1.6.1 Activating Price Lists and Defining Price Levels

1.6.2 Creation of Price List

1.6.3 Price Level & Price List usage in Sales Voucher

1.6.4 Revise Price List Conclusion Key Takeaways Shortcut Keys Practice Exercises,

Module 10: TallyEssential Level 2

Unit: Accounts Receivable and Payable Management

2.1 Introduction

2.2 Accounts Payable and Receivable

2.3 Maintain Bill-wise Entry

2.4 Activation of Bill-wise Entry

2.4.1 Usage of Bill-wise entry in Purchase and Payment Voucher

2.4.2 Usage of Bill-wise entry in Sales and Receipt Voucher

2.4.3 Usage of Bill-wise entry in Payment and Receipt Voucher

2.4.4 Usage of Bill-wise entry - On Account

2.5 Specifying of Credit Limit for Parties

2.5.1 Specifying Credit Limit for Individual Ledger

2.5.2 Specifying Credit Limit for Multiple Ledger

2.5.3 Sales Voucher Restriction Based on Credit Limit

2.6 Splitting of Credit Sale Into Multiple Bills

2.7 Payment Performance of Debtors

2.8 Bills Payable and Receivable Reports in TallyPrime

2.8.1 Bills Receivable

2.8.2 Ageing Analysis of Outstanding

2.8.3 Generating Reminder Letter in TallyPrime

2.8.4 Generating Confirmation of Accounts in TallyPrime

2.8.5 Bills Settlement 2.8.6 Bills Payables Conclusion Key Takeaways Shortcut Keys

Practice Exercises

Module 11: TallyEssential Level 2 , Unit: Purchase and Sales Order Management

3.1 Introduction

3.2 Purchase Order Processing

3.2.1 Recording of Purchase Order

3.2.2 Recording of Receipt Note Voucher

3.2.3 Recording Rejections Out Voucher

3.2.4 Recording Purchase Voucher

3.2.5 Recording Debit Note Voucher

3.2.6 Recording Payment Voucher

3.3 Sales Order Processing

3.3.1 Recording of Sales Order In TallyPrime

3.3.2 Recording Delivery Note Voucher

3.3.3 Recording Rejections In Voucher

3.3.4 Recording of Sales Voucher

3.3.5 Recording Receipt Voucher

3.4 Order Outstandings

3.4.1 Sales Order Outstanding

3.4.2 Purchase Order Outstanding

3.4.3 Pre-Closure of Orders

3.5 Reorder Level

3.5.1 Display Reorder Status

3.6 Godown Transfer in TallyPrime Conclusion Key Takeaways Shortcut Keys

Module 12: TallyEssential Level 2

Unit: Tracking Additional Costs of Purchase

4.1 Introduction

4.2 Configuration of Additional Cost of Purchases in TallyPrime

4.2.1 Purchase Transaction with Additional Cost Details in Voucher Mode

4.2.2 Purchase Transaction with Additional Cost Details in Item Invoice Mode

4.2.3 Debit Note Voucher with Additional Cost Conclusion Key Takeaways

Module 13: , TallyEssential Level 2

Unit: Cost/Profit Centres Management

5.1 Introduction

5.2 Cost Centre and Cost Categories

5.2.1 Activation of Cost Centre

5.2.2 Allocation of Expenses and Incomes using Cost Centre

5.2.3 Cost Centre Classes (Automatic Allocation)

5.2.4 Allocation of Expenses to Multiple Cost Centres and Cost Categories

5.3 Cost Centre Reports

5.3.1 Category Summary

5.3.2 Cost Centre Break-up

5.3.3 Ledger Break-up

5.3.4 Group Break-up Conclusion Key Takeaways Shortcut Keys Practice Exercises,

Module 14: TallyEssential Level 2

Unit: Budgets and Scenarios

6.1 Introduction

6.2 Creation of Budget

6.3 Recording Transactions

6.4 Display Budgets and Variances Reports for Group Budget

6.5 Scenario Management

6.5.1 Creation of Scenario

6.5.2 Temporary Inclusion of Reversing Journal Voucher In the Reports. Conclusion Key

Takeaways Shortcut Keys Practice Exercises

Module 15: TallyEssential Level 2

Unit: Generating and Printing Reports

7.1 Introduction

7.2 On the Fly Reporting

7.2.1 Bird’s eye View/Drill Down Display

7.2.2 Drill Down Display

7.2.3 Date/Period Based Reporting & Comparing

7.3 Inventory Reports 7.3.1 Stock Summary

7.3.2 Godown-wise Stock Availability

7.3.3 Movement Analysis 7.3.4 Stock Query

7.4 Financial Reports

7.4.1 Balance Sheet

7.4.2 Profit & Loss A/c

7.5 Books & Registers

7.5.1 Sales Register

7.5.2 Purchase Register

7.6 Printing of Invoice and Report Conclusion Key Takeaways Shortcut Keys Practice

Exercises Key Answers for Practice Exercises Business Case Studies-2

Module 16: TallyEssential Level 3

Unit: Goods and Services Tax

1.1 Introduction to GST

1.1.1 Why GST?

1.1.2 GST Tax Structure

1.1.3 Determination of Tax

1.1.4 GST Registration

1.1.5 Managing HSN CODE/SAC

1.1.6 GST Rate Structure

1.1.7 Supply of Goods and Services

1.1.8 Invoicing

1.1.9 Debit Note, Credit Note/Supplementary Invoice

1.1.10 Receipt Voucher

1.1.11 Transportation of Goods without Issue of an Invoice

1.1.12 Input Tax Credit

1.2 E-Way Bill

1.2.1 Components of E-Way Bill

1.2.2 Who must generate E-Way Bill

1.2.3 Validity of E-Way Bill

1.2.4 E-Way Bill Process Flow

1.3 GST e-Invoicing

1.3.1 Benefits of e-invoices to the businesses

1.3.2 Date of implementing GST e-invoicing

1.3.3 Entities exempted from e-invoices

1.3.4 Generating E-Way bill with e-Invoice

1.3.5 Modification of e-Invoice

1.3.6 Role of e-Invoice in GST Returns

1.3.7 Various modes of generating e-invoice

1.3.8 Role of IRP in e-Invoice

1.3.9 The practice of Generating GST e-Invoice

1.3.10 E-invoice Details

1.3.11 Invoice Reference Number (IRN)

1.4 GST in TallyPrime

1.4.1 Creation of Company and Activating GST

1.4.2 Introducing Capital into the Business

1.4.3 Creation of Masters in TallyPrime

1.5 Hierarchy of Calculating Tax in Transactions

1.5.1 Defining GST Rates at Company Level

1.5.2 Defining GST Rates at Stock Group Level

1.5.3 Defining GST Rates at Stock Item Level

1.5.4 Defining GST Rates at Accounting Group Level

1.5.5 Defining GST Rates at Ledger Level

1.5.6 Defining GST Rates at Transaction Level

1.6 Recording GST-compliant transactions

1.6.1 Accounting Intrastate Supply of Goods & Services

1.6.2 Accounting Interstate Supply of Goods & Services

1.6.3 Accounting Purchase and Sales Returns of Goods with GST

1.6.4 Supplies Inclusive of Tax

1.7 E-Way Bill Report in Tally

1.7.1 Export for e-Way Bill Report

1.7.2 Exporting Bulk or Consolidated e-Way Bill invoices

1.7.3 Update e-Way Bill Information

1.8 Input Tax Credit Set Off against Liability

1.9 GST Tax Payment

1.9.1 Timeline for payment of GST tax

1.9.2 Modes of Payment

 1.9.3 Challan Reconciliation

1.10 Generating GST Returns for Regular Dealers in Tally

1.10.1 GSTR-1

1.10.2 GSTR-3B

1.10.3 GSTR-9 – GST Annual Computation

1.11 Filing GST Returns in Tally

1.11.1 Filing GSTR-1 Returns

1.11.2 Filing GSTR-3B Returns

1.11.3 Filing GSTR-9 Returns - GST Annual Computation

1.12 Generating e-Invoice in TallyPrime

1.12.1 Recording Outward Supply and Generating e-Invoice without e- Way Bill

1.12.2 Recording Outward Supply and Generating e-Invoice with e- Way Bill

1.12.3 E-Invoice Report

1.13 Quarterly Return Monthly Payment Scheme

1.13.1 Creation of Company and Activating GST in TallyPrime

1.13.2 Accounting Intrastate Supply of Goods & Services

1.13.3 Input Tax Credit Set Off against Liability and Tax Payment

1.13.4 Invoice Furnishing Facility(IFF) in QRMP scheme

1.14 Composition Dealer under GST Regime

1.14.1 Introduction

1.14.2 Conditions to be satisfied under the scheme

1.14.3 Creation of Company and Activating GST in TallyPrime

1.14.4 Accounting Intrastate and Interstate Supply of Goods

1.14.5 Generating GST Returns for Composition Dealer in Tally

1.14.6 GST Tax Payment Conclusion Key Takeaways Shortcut Keys Practice Exercises,

Module 17: TallyEssential Level 3, Unit: Tax Deducted at Source

2.1 Introduction to TDS

2.2 Basic Concepts of TDS

2.3 TDS Process

2.4 TDS in TallyPrime

2.4.1 Activation of TDS in TallyPrime

2.5 TDS Statutory Masters

2.6 Configuration of TDS at Different levels

2.6.1 Configuration of TDS at Group level

2.6.2 Configuration of TDS at Ledger level

2.7 Recording TDS Compliant Transactions in TallyPrime

2.7.1 Expenses Partly Subject to TDS

2.7.2 Booking Expenses and TDS deduction on crossing Exemption Limit

2.7.3 Accounting Multiple Expenses and Deducting TDS later

10

2.7.4 TDS on Expenses at Lower and Zero Rate

2.7.5 TDS on Expenses at Higher Rate

2.7.6 Recording Transaction when TDS Exemption limit is not crossed

2.8 TDS Exceptions

2.9 TDS Payment to Department

2.9.1 Resolving Uncertain Transactions

2.9.2 TDS Outstanding

2.9.3 Payment of Tax to the Income Tax Department

2.9.4 Generating TDS Challan (ITNS 281)

2.9.5 Interest Payment to Income Tax Department on Delayed Tax Payment

2.10 TDS Report

2.10.1 Challan Reconciliation

2.10.2 Form 26Q 2.10.3 E-Return

2.11 Changes in TDS rates from 1st April 2021 Conclusion Key Takeaways Shortcut Keys

Practice Exercises

Module 18: TallyEssential Level 3

Unit: Management of Business Data

3.1 Introduction

3.2 Exporting data in available formats

3.3 Export and Import of Data

3.3.1 Export and Import of Masters from one company to another in XML format

3.3.2 Export and Import of Transactions from one company to another in XML format

3.3.3 Exporting Reports to MS Excel

3.3.4 Exporting Reports to PDF

3.4 Open Database Connectivity (ODBC)

3.5 Printing of Company Logo on Vouchers, Invoices & Reports. Conclusion Shortcut Keys

Certification Process:

Candidates must appear for an online objective-based examination after the completion of the course. Certificates will be issued based on the merits of the examination Certificate issued.