TallyEssential Certification

Sl. Contents Hours NSDC-QPs

1 TallyEssential Level 3 36 BSC/Q1101- Accounts Executive (Statutory

Table of Content
SKU Name/Chapter Name Hours
TallyEssential Level 3 36
Recap of Level 2 1
Chapter 1: Goods and Services Tax 15
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-invoice to the businesses
1.3.2 Date of implementing GST e-invoicing
1.3.3 Entities exempted for 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 Dealer 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
Chapter 2: Tax Deducted at Source 10
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
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
Chapter 3: Management of Business Data 4
3.1 Introduction
3.2 Exporting of 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
Key Takeaways
Practice Exercises
Chapter 4: Moving to the Next Financial Year 4
4.1 Introduction
4.2 Changing Current Period and continue voucher entry in the same company data
4.3 Company data handling through Export and Import of data
4.4 Split Company Data
4.5 Create a new company and maintain books of accounts for the new financial year
4.6 Creating Group Company Data
4.7 Comparative Final Accounts Reports of Two Companies
Conclusion
Shortcut Keys
Practice Exercises
TallyEssential Addendum on Release 1.1.4 2
1.1 Introduction to e-Invoice Sandbox experience
1.2 Quick access to Tax Analysis and Stock Query
1.3 Enhanced Print, and Export Experience
1.4 Day-Wise breakup for Ledgers
Key Answers for Practice Exercises