60 Hrs Certification Course on GST, Income Tax, Tally Prime & Excel

Last updated: Monday June 28, 2021

4.9 by 43 Users | 152 Students Enrolled | Languages: Hindi, English

2999 25999

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
  • How to File GST Returns from Tally.ERP9

Course Description

Studycafe has Designed 60 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 - General Discussion & Clause by Clause Analysis of ITR-1

120 Mins

• General Discussion on Filing of ITR's

• 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 2 - General Discussion & Clause by Clause Analysis of ITR-1

120 Mins

• General Discussion on Filing of ITR's

• 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 3 - General Discussion & Critical Analysis on ITR-2

120 Mins

General Discussion & Critical Analysis on ITR-2

Day 4 - General Discussion & Critical Analysis on ITR-2

Mins

General Discussion & Critical Analysis on ITR-2

Day 5 - Critical Analysis on ITR-4

Mins

Critical Analysis on ITR-4

Day 6 - Critical Analysis on ITR-3, ITR 5 & ITR-6

120 Mins

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

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

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

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

Day 7 - Critical Analysis on ITR-7

120 Mins

Critical Analysis on ITR-7

Day 8 - Tax Audit Applicability & Legal Provision of Sec 44AB

120 Mins

• Tax Audit Applicability & Legal Provision of Sec 44AB

Day 9 - • Form 3CA and Form 3CB & Applicability of SA 700

120 Mins

• Form 3CA and Form 3CB & Applicability of SA 700

Day 10 - Clause By Clause Analysis of Points 1-20 of form 3CD

120 Mins

Clause By Clause Analysis of Points 1-20 of form 3CD

Day 11 - Clause By Clause Analysis of Points 21-44-of form 3CD

120 Mins

Clause By Clause Analysis of Points 21-44-of form 3CD

Day 12 - Clause By Clause Analysis of form 3CD

120 Mins

• Clause By Clause Analysis of form 3CD

Day 13 - Clause By Clause Analysis of form 3CD

120 Mins

• Clause By Clause Analysis of form 3CD

Day 14 - 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 15 - 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 16 - Valuation and Time of Supply Under GST

120 Mins

• Time of Supply Rules

• Valuation Concept and Rules

• Discussion on use of HSN Codes

Day 17 - 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 18 - Input Tax Credit Provisions Under GST

120 Mins

• Ingredients in section 16

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

Day 19 - 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 20 - 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 21 - GST Returns: GST Annual Return

120 Mins

• Discussion on GST Annual Return

• Filing GST Return with Tally

Day 22 - 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 23 - Penalties & Assessment

120 Mins

• Discussion on Assessments

• Departmental Audits

Day 24 - 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 25 - Advanced Features in Excel :

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 26 - 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 27 - Advanced Excel Functions :

120 Mins

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,

Day 28 - Advanced Excel Functions :

120 Mins

Table, Vlookup, Hlookup, X Lookup Funcation, How to Create Pivot Table, USe of Pivot Table Pivot Table, Advance Pivot Table Features, Pivot Charts, Sparkline Chart,

Day 29 - Advanced Excel Functions :

120 Mins

Preperation of Balance Sheet from trial, 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, Reconcillation of GSTR2A with GSTR3B ,

Day 30 - Fundamentals of Tally Prime

120 Mins

Fundamentals of Tally Prime, Accounting Masters in Tally Prime,Tally Prime Shortcuts, Difference Between Tally.ERP9 and TallyPrime,

Day 31 - Tally Prime Shortcuts & Entries

120 Mins

Purchase and Sales Entries with GST, Advanced Features in Tally Prime which includes Auto Invoice Series,

Day 32 - Advanced Features in Tally Prime

120 Mins

Advance Entries in Tally Prime like, RCM, Import, Export, SEZ, Ineligible Goods, How to pass entries for TDS, How to deduct TDS Automatically

Day 33 - Difference Between Tally.ERP9 and TallyPrime

120 Mins

Tally Back up & Restore, Technological Advantages of Tally.ERP 9, Tally.NET and Remote Capabilities, Email Facility in Tally, How to add the logo in invoices, Backup, Restore & Splitting of Company,

Day 34 - Application Management and Controls

120 Mins

Bank Reconciliation, Audit feature of How to Check who has passed the entry, Extract Report from tally in Excel with TALLY ODBC Server, Export and Import GL from XML File.

Day 35 - How to File GST Returns from Tally & How to Merge Group Companies in Tally

120 Mins

How to File GST Returns from Tally, Tally.ERP9 Audit Features, How to Generate JSON File of E-way Bill, How to Create Cost Centres, Cost Categories in Tally, How to merge branch and HO in Tally, How to Merge Group Companies in Tally

FAQ

Who can Join this Course?

⭐ 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 is the Duration of the Course?

Course will be of more than 60 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 make the fees.

Terms and Conditions

  • Recording will be Valid for 60 Days Only.
  • At one Time Lecture can be seen Either on Mobile or Desktop.

Requirements

  • Need to Have Active Internet Connection
  • Lecture will be played either on Mobile, Laptop or Desktop.

This course includes:

  • Hindi, English
  • 5 Hours of Video Content
  • Recording is Available for 30 Days
  • Studycafe Certificate of Completion
  • Access on mobile or Computer/Laptop

Certificate to be provided to all the participants. Certificates will be sent on your email id.

In case of any Query Please Call us or Whats App

About Authors

Studycafe

CA: Business

Studycafe
(4.7)

This Account belongs to the Administrator of Studycafe.

Feedback