70 Hrs Certification Course on GST, Income Tax, Tally Prime, Excel & E-Mail Writing

• 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

• 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

General Discussion & Critical Analysis on ITR-2

General Discussion & Critical Analysis on ITR-2

Critical Analysis on ITR-4

• 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

Critical Analysis on ITR-7

• Tax Audit Applicability & Legal Provision of Sec 44AB

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

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

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

• Clause By Clause Analysis of form 3CD

• Clause By Clause Analysis of form 3CD

• Clause By Clause Analysis of form 3CD

• 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

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, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,

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,

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 ,

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

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

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

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,

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.

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

1. Introduction to Business Emails

2. Salutation in an Email

3. Formatting of your Emails

4. Effective subject lines

5. Other components in an email

1. Opening and closing structures an email

2. Body of the email

3. Email attachments

4. Polishing your emails

5. Email etiquette at workplace