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

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.

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

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

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

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

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

• 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.

• 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

• Time of Supply Rules

• Valuation Concept and Rules

• Discussion on use of HSN Codes

• Persons liable and not liable for registration

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

• Amendments, Cancellations and Revocations.

• Ingredients in section 16

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

• Detailed Discussion on Relevant Sections of IGST Act

• Filing of Bond and LUT

• Discussion on SEZ, EOUs

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

• Discussion on Eligibilty & new updates of QRMP Scheme

• Filing GST Return with Tally

• Discussion on GST Annual Return

• Filing GST Return with Tally

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

• Procedure its applicability

• Document to be carried with goods in movement

• Discussion on Assessments

• Departmental Audits

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

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

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

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

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

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

• 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

• 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

• 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

👉 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.

👉 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

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

👉 Detailed discussion on Section 195,

👉 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).