;
PAYROLL PROCESSING

  • The Pay Structure
  • Basic, HRA, DA, Conveyance, Medical allowance, LTA, Lunch Allowance etc.
  • Salary Break up and Designing CTC.
  • Calculation of Gross , Net Salary and CTC
  • Calculation of Overtime and Leave Encashment.
  • Discussion on Compensation and Benefits.
  • Attendance and Leave Management (CL, EL, SL, and ML)
  • Preparation of Salary Sheet, Pay Slip, Full n Final Settlement.
  • PF Report in Excel sheet
  • ESI Report in Excel sheet
  • Professional Report Tax
  • Live Payroll Software Training (New Topic Added)
TAX PLANNING FOR SALARIED EMP

  • LWF Slab Rate
  • PT Slab Rate
  • Income Tax Slab Rate
  • Tax Exemptions of Various Allowances.
  • Tax Deduction under Chapter VI-A (80C, 80D, 80E, 80G, etc.)
  • Rebate U/S 87A
  • Education Cess
  • Routine Tax Planning (Investment Declaration Form)
  • TDS Certificate (Form 16)

MS Excel- Lab Session


Objective: Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advanced Excel so that user can Make Advanced Analysis with the help of Those Tools

Topics Covered:


Advanced ExcelLookup and Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.

Text Functions and Data Validation Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.

Logical Functions And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min

Data Management Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality

AnalysisSingle/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,

Advanced Chart, Graph and Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table

Advanced Filter, Validation and Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split. Pivot Table and Charts, Import and Export Data, Protect/Unprotect Sheets/Workbooks, Worksheet Formatting and Print Display.

  • Payment of Bonus
  • Calculation of Bonus
  • Calculation of Allocable Surplus
  • Computation of Set-on and Set-off
  • Penalty
  • Practical Session
  • Registers and Records
  • Return
  • Display

DISCIPLINARY ACTION/TERMINATION/MISCONDUCT

  • What’s Disciplinary Action?
  • Definition of Misconduct/Violation of Code of Conduct.
  • Preparations of Show Cause Notice/Charge Sheet.
  • Domestic Inquiry
  • Termination

CONTRACT LABOUR (REGULATION AND ABOLITION) ACT1970

  • Objective
  • Applicability
  • Registration and License
  • Returns(Report)
  • Facilities
  • Registers and Records
  • Displays

SHWW Act, 2013 (New Topic Added)

  • Sexual Harassment Policy
  • Internal Complaints Committee

TRADE UNION

  • Definition
  • Condition/Clause
  • Function
  • Benefits and Drawbacks

SHOPS and ESTABLISHMENT Act

  • Objective
  • Applicability
  • Registration
  • Conditions of Work
  • Registers to be maintained
  • Displays(Notice)

FACTORY Act, 1948

  • Objectives
  • Applicability
  • Licensing Procedure
  • Employment Conditions
  • Facilities
  • Committees
  • Statutory Appointments
  • Registers and Records
  • Various Returns
  • Various Forms
  • Displays

INDUSTRIAL DISPUTES Act, 1947 (New Topic Added)

  • Purpose
  • Scope
  • Forms and Formats
  • Regulatory Body
  • Employer’s Obligation
  • Keywords used

MINIMUM WAGES Act

  • Objective
  • Applicability
  • Notification
  • Provisions
  • Registers to be maintained
  • Returns
  • Display(Notice)

APPRENTICESHIP Act, 1961 (New Topic Added)

  • Objective
  • Contract of Apprenticeship
  • Termination of Apprenticeship Contract
  • Obligation of Employers Toward an Apprentices
  • Obligation of Apprentices
  • Payment to Apprentices
  • Health, Safety and Welfare of Apprentices
  • Rules and Guideline
  • Employees’ Provident Fund (EPF EPF, VPF, RPF, etc
  • Computation of Monthly PF Contribution
  • Computation of Interest and Penalty
  • Computation of Monthly Pension
  • Computation of EDLI Amount
  • Penalty
  • Practical Session
  • Online Registration of Establishment
  • Online Generation of UAN
  • Online Submission of KYC
  • Online ECR Generation
  • Online Bulk Exit
  • PF Report in Excel Sheet
  • Registers and Records
  • Various Forms
  • Employees’ State Insurance (ESI)
  • Computation of Monthly ESI Contribution
  • Computation of Interest and Penalty
  • ESI Benefits
  • Contribution Period and Benefit Period
  • Penalty
  • Practical Session
  • Online Registration of Establishment
  • Registration of Branch/ Sub-Code
  • Online Generation of TIC
  • Online IP Mapping with Aadhaar
  • ESI Report In Excel Sheet
  • Online Challan Generation
  • Registers and Records
  • Payment of Bonus
  • Calculation of Bonus
  • Calculation of Allocable Surplus
  • Computation of Set-on and Set-off
  • Penalty
  • Practical Session
  • Registers and Records
  • Return
  • Display
  • Payment of Gratuity
  • Calculation of Gratuity
  • Maximum Gratuity and Taxability
  • Group Gratuity Policy
  • Practical Session
  • Various Forms
  • Display