50 Hrs Certification Course on GST, Income Tax, Tally.ERP9 & Excel

Last updated: Saturday May 8, 2021

4.8 by 40 Users | 121 Students Enrolled | Languages: Hindi, English

2599 15999

Hurry up, few days left at this price!

What you'll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Understanding Supply and applicability of CGST, SGST, IGST along with B2B & B2C Supply
  • Understanding Input Tax Credit [ITC] and Understanding Reverse Charge Mechanism [RCM] Provisions
  • Discussion on GSTR-3B, GSTR-1 and Discussion on QRMP Scheme
  • Discussion on E-way Bill, Concept of TDS/TCS and How to file GST Return Directly form Tally
  • Practical understanding while Filing GST returns including Annual Return
  • How to File GST Returns from Tally.ERP9
  • Every Practical aspect in Tally.ERP9
  • Accounting With GST in Tally.ERP9
  • How to File Income Tax Returns
  • Practical Aspects of TDS and TCS provisions under Income Tax Act

Course Description

Studycafe has Designed 50 Hrs Certification Course on GST, Income Tax, Tally.ERP9 & Excel for Accountants. This course has been specially designed for Accountants and those persons who want to pursue a career in Accounts Field. This is very effective course for all the persons who are dealing with GSt, Income Tax, Tally, Excel. In this course we have covered  Practical aspects of Every topic and all the faculties are Chartered accountants.

Course Content

Day 1 - Data Cleansing & Date related Calculation Functions :

120 Mins

Alt Function, Excel Smart Shortcuts, Edit Tool Bar, Randomdata, Smart Copy Paste, Smart Paste special, Transpose, now, date function, Format Cell, Concatenate, Trim & Clean, Proper, Upper, Lower, Left, Right, Mid & Len, Filter, Advance Filter, Format Painter.

Day 2 - Advanced Excel Functions :

120 Mins

Concatenate & Text Join, Giving password to excel and back up, Advance Find & Replace, Smart Sorting, Skip Blank, TDS Working Check list, GST Late Fees Calculator, Import 26 AS data and converting in to excel

Day 3 - Advanced Excel Functions :

120 Mins

Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, if functions, Goto Special, Macro of Spell Number, etc.

Day 4 - Advanced Excel Functions :

120 Mins

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup

Day 5 - Advanced Excel Functions :

120 Mins

Table, Pivot Table, Sparkline Chart, Use of Onedrive and Google Sheet, Preperation of Balance Sheet from trial.

Day 6 - Advanced Excel Functions :

120 Mins

Reconcillation of GSTR2A with GSTR3B , Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit, CFO or Management Dashboard, Extract data in Excel from NET, Excel worksheet to corporate (or Tally) database & extract any data that you want, Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments

Day 7 - Basic Concepts & Imp Definition Under GST

120 Mins

• Constitution of India (Provision related to GST)

• Discussion on definition of goods, service, Business, composite and mixed supply, Continuous Supply, taxable supply and non-taxable supply, supplier and recipient, exempt supply and zero-rated supply, NIL rated supplies, consideration and non-monetary consideration.

Day 8 - Levy & Collection of Tax and Concept of RCM

120 Mins

• Definition of supply and all forms of supply and purpose thereof including schedule I, II and III.

• Levy of CGST, SGST & IGST

• Discussion on Composition Scheme

Day 9 - Valuation and Time of Supply Under GST

120 Mins

• Time of Supply Rules

• Valuation Concept and Rules

• Discussion on use of HSN Codes

Day 10 - Registrations Under GST

120 Mins

• Persons liable and not liable for registration

• Special provision relating with casual taxable person & NR taxable person.

• Amendments, Cancellations and Revocations.

Day 11 - Input Tax Credit Provisions Under GST

120 Mins

• Ingredients in section 16

• Purpose and exclusions through section 17- Apportionment of credit & blocked credit

Day 12 - Exports, Refunds & Imports Under GST

120 Mins

• Detailed Discussion on Relevant Sections of IGST Act

• Filing of Bond and LUT

• Discussion on SEZ, EOUs

Day 13 - GST Returns: GSTR-1, GSTR3B & QRMP Scheme

120 Mins

• Discussion on GSTR-1, GSTR-3B, QRMP Scheme

• Discussion on Eligibilty & new updates of QRMP Scheme

• Filing GST Return with Tally

Day 14 - GST Returns: GST Annual Return

120 Mins

• Discussion on GST Annual Return

• Filing GST Return with Tally

Day 15 - E-Invoicing & E-Way Bill

120 Mins

• Process of generating E-Invoice and E-Way Bill

• Procedure its applicability

• Document to be carried with goods in movement

Day 16 - Penalties & Assessment

120 Mins

• Discussion on Assessments

• Departmental Audits

Day 17 - Fundamentals of Tally.ERP 9 and TallyPrime

120 Mins

Fundamentals of Tally.ERP 9 and TallyPrime, Accounting Masters in Tally.ERP 9 and TallyPrime

Day 18 - Tally.ERP 9 Shortcuts & Entries

120 Mins

Tally.ERP 9 Shortcuts, Advance Entries in Tally.ERP 9 like, RCM, Import, Export, SEZ, Ineligible Goods.



Day 19 - Advanced Features in Tally.ERP 9 and TallyPrime

120 Mins

Advanced Features in Tally.ERP 9 and TallyPrime which includes Auto Invoice Series, Tally Back up & Restore, Bank Reconciliation

Day 20 - Difference Between Tally.ERP9 and TallyPrime

120 Mins

Difference Between Tally.ERP9 and TallyPrime, Technological Advantages of Tally.ERP 9, Tally.NET and Remote Capabilities, Email Facility in Tally

Day 21 - Application Management and Controls

120 Mins

Application Management and Controls, Splitting of Company, Creation of Cost Centre, TDS & TCS Provisions, Tally Controls.

Day 22 - How to File GST Returns from Tally

120 Mins

How to File GST Returns from Tally, Tally.ERP9 Audit Features, How to Export Tally Data using ODBC

Day 23 - Clause by Clause Analysis of ITR-1,

120 Mins

• Applicability & issues of ITR-1,

• Significance of proper & correct filling of fields in the ITRs

• New fields and changes made in ITR-1,

• Discussion on important provisions pertaining to ITR-1,

• When to File ITR 1

Day 24 - Detailed Explanation of ITR-2 & ITR-4

120 Mins

• Applicability & issues of ITR-2 & ITR-4

• Significance of proper & correct filling of fields in the ITRs

• Discussion on important provisions pertaining to ITR-2 & ITR-4

• New fields and changes made in ITR-2 & ITR- 4

• How to File Balance Sheet and Profit & Loss Account in ITR 2

• Can ITR 3 be filed without the Balance Sheet

• Significance of GST Turnover and Return in ITR-2 and ITR- 4

Day 25 - Critical Analysis on ITR-5, ITR-6 & ITR-7

120 Mins

• Applicability & Issues in Filing of ITR-5, ITR-6 & ITR-7

• Significance of proper & correct filling of fields in the ITRs

• Discussion on important provisions pertaining to ITR-5, ITR-6 & ITR-7

• New fields and changes made in ITR-5, ITR-6 & ITR-7

Day 26 - Overview of TDS Provisions Under Section 192 to Section 196

120 Mins

👉 Overview of TDS Provisions Under Section 192 to Section 196

👉 Form 15G and Form 15H relevance and its Applicability.

👉 What is Lower Tax Deduction Certificate and How to apply for lower deduction of TDS TCS as per Section 197.

Day 27 - Overview of TDS Provisions Under Section 192 to Section 196

120 Mins

👉 Detailed discussion on Section 192, 194C, 194I, 194J.

👉 Detailed discussion on TDS on cash withdrawal from Bank section 194N

👉 Applicability of TDS on E-Commerce operator section 194O

Day 28 - Overview of TDS Provisions Under Section 192 to Section 196

120 Mins

👉 Detailed discussion on Section 192EE, 194G, 194H, 194I, 194I-A, 194-IB, 194-IC, 194-LA,194M, 194N, 194O,

Day 29 - Detailed discussion on Section 195

120 Mins

👉 Detailed discussion on Section 195,

Day 30 - Overview of TCS Provisions under Section 206C

120 Mins

👉 Practical demo and insights of TRACES.

👉 Filing of TDS returns and TCS returns for tax deduction and collection under various sections of this chapter.

👉 What is Lower Tax Deduction Certificate and How to apply for lower deduction of TDS TCS as per Section 197.

👉 Overview of TCS Provisions under Section 206C

👉 Panel consequences in case of default of TDS and TCS provisions under Section 201(1A), 220(2), 234E, 271C, 271H, 40(a)(ia).

FAQ

Who can join 50 Hrs Certification Course on GST, Income Tax, Tally.ERP9 & Excel ?

⭐ Commerce Graduates/CA/CS/CMA/Law students ⭐ Tax professionals whether in JOB or Practice ⭐ Qualified CA/CS/CMA/LLB ⭐ Semi-qualified CA/CS/CMA working in CA Firms or in Industry ⭐ Any other person not covered above can join course if interested.

What will be Language of the Course?

It will be in Mix of English and Hindi Language.

What is the Duration of the Course?

Course Duration will be of more than 50 Hrs.

Whether Course Material will be Provided?

Yes, Course Material will be Provided.

Whether Course Recording will be Provided?

Yes Recording will be Provided for 60 Days.

How Can we Join ths Course?

Please register yourself and pay the fees. After paying fees you can see the Lectures in Course section.

Terms and Conditions

  • Recording will be Valid for 60 Days Only.
  • Fees will not be refunded after purchase of the Course. If you have any query regarding the course please ask in advance.

Requirements

  • Required internet connection. Lectures can be viewed on Mobile or Laptop

This course includes:

  • Hindi, English
  • 50+ Hours of Video Content
  • Recording is Available for 60 Days
  • Studycafe Certificate of Completion
  • Access on mobile or Computer/Laptop
  • Downloadable Material

Certificate to be provided to all the participants.

In case of any Query Please Call us or Whats App

About Authors

CA Deepak Gupta

CA: Practice

Deepak Gupta is a Chartered Accountant having more than 10 years of Experience in the Field of Direct Taxation and Indirect Taxation. He has Vast Corporate Experience and has previously worked with Renowned companies like Ericsson, Wipro and Hero Group. He is also expert of MS Excel & MS PowerPoint, Tally.ERP9, Tally Prime and has taken several webinars on these topics.

CA Manoj Lamba

CA: Practice

CA. MANOJ LAMBA did his graduation in commerce from M.L.N.College,Yamuna Nagar and was first position holder since class +2 to B.Com. He is fellow of Institute of Chartered Accountants of India(ICAI). He is also final pass of Institute of Companies secretaries of India. Beside that, He is also a Law Graduate. He is regularly associated with ICAI since 1999. He has also taking seminars conducted by Yamuna Nagar-Jagadhri Income tax counsel Association, Income tax department, and various other educational institutes and colleges. He has also taking motivational classes for orientation & GMCS program me for CA Students.

CA Pratibha Goyal

CA: Practice

CA Pratibha Goyal is Chartered Accountant qualified in 2016, is a Member of The Institute of Chartered Accountants of India having wide experience in the field of Auditing, Taxation, ROC, GST and Secretarial matters etc. She has written over a thousand articles & has made several videos on topics related to Auditing & Taxation. As a Speaker she has delivered various sessions on various branches of NIRC of ICAI.

Feedback