E-lite Institute Of Finance & Management

Module 1 - Compensation And Benefits

1. PAYROLL PROCESSING <ul> <li>The Pay Structure</li> <li>Basic, HRA, DA, Conveyance, Medical Allowance, OT, LTA, Lunch Allowance etc.</li> <li>Salary Break up and Designing CTC.</li> <li>Calculation of Gross , Net Salary & CTC</li> <li>Calculation of Overtime & Leave Encashment.</li> <li>Discussion on Compensation and Benefits.</li> <li>Attendance & Leave Management (CL, EL, SL, and ML)</li> <li>Preparation of Salary Sheet, Pay Slip, Full n Final Settlement.</li> <li>PF Report in Excel sheet</li> <li>ESI Report in Excel sheet</li> <li>Professional Report Tax</li> <li>Live Payroll Software Training (New Topic Added)</li> </ul> 2. TAX PLANNING FOR SALARIED EMP. <ul> <li>LWF Slab Rate</li> <li>PT Slab Rate</li> <li>Income Tax Slab Rate</li> <li>Tax Exemptions of Various Allowances.</li> <li>Tax Deduction under Chapter VI-A</li> <li>(80C, 80D, 80E, 80G, etc.)</li> <li>Rebate U/S 87A</li> <li>Education Cess</li> <li>Routine Tax Planning (Investment Declaration Form)</li> <li>TDS Certificate (Form 16)</li> </ul> 2.1 – 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. Introduction to Excel <ul> <li>Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.</li> </ul> Mathematical Functions <ul> <li>Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal,</li> <li>Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct</li> </ul> Date & Time Function <ul> <li>Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time</li> </ul> Text Functions & Data Validation <ul> <li>Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.</li> </ul> Statistical Function & Other Functions <ul> <li>Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen</li> </ul> Logical Functions <ul> <li>And, Or, If, Iferror, Not, Nested If</li> </ul> Lookup & Reference Functions <ul> <li>VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link</li> </ul> Power Pivot- MIS, Data Analysis & Visualization <ul> <li>Pivot Table, Power Pivot, What-if Analysis, Data Table –One Variable and Two Variables, Data Analysis Using Statistics, Descriptive Statistics, ANOVA, Moving Average, Testing Hypothesis, Measuring Covariance and Correlation, Distribution, Regression, Graphs & Charts, Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall, Import and Export data, Protect/Unprotect sheets/workbooks, Worksheet formatting and Print Display</li> </ul> Data Collection Method <ul> <li>With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality</li> </ul> Analysis Single/Multidimensional Analysis <ul> <li>Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table</li> </ul> Advanced Dashboard in Excel <ul> <li>Overview of Chart types, Chart Formatting, Active X Form Controls, Principle of great dashboard design, Selecting Correct Chart to display data, Interactive Charts with Form Controls, Combo box, Check Box, Scroll Bar and Radio Button, Interactive Dashboard with Form Controls, Form Controls for reports automation, Data Models using Power Pivot</li> </ul> Two Live Report Development in Advanced Excel:-(Real World Data)

Module 2 - Statutory and HR Compliance

a. Employees’ Provident Fund (EPF) <ul> <li>EPF, VPF, RPF, etc.</li> <li>Computation of Monthly PF Contribution</li> <li>Computation of Interest & Penalty</li> <li>Computation of Monthly Pension</li> <li>Computation of EDLI Amount</li> <li>Penalty & Interest</li> <li>COVID-19 pandemic</li> </ul> Practical Session (Workshop) <ul> <li>Online Registration of Establishment</li> <li>Online Generation of UAN</li> <li>Online Submission of KYC</li> <li>Online ECR Generation</li> <li>Online Bulk Exit</li> <li>Online SharmSuvidha Portal</li> <li>PF Report in Excel Sheet</li> <li>Registers and Records</li> <li>Various Forms (EE and ER), Display & Return</li> </ul> Payment of Bonus <ul> <li>Calculation of Bonus</li> <li>Calculation of Available, Allocable Surplus</li> <li>Computation of Set-on & Set-off</li> <li>Penalty</li> </ul> Practical Session (Workshop) <ul> <li>Various Forms</li> <li>Bonus Calculation Sheet</li> <li>Bonus Payment Registers & Records</li> <li>Annual Return</li> <li>Display</li> </ul> b. Employees’ State Insurance (ESI) <ul> <li>Computation of Monthly ESI Contribution</li> <li>Computation of Interest & Penalty</li> <li>ESI Benefits (Medical, Maternity, Funeral etc.)</li> <li>Contribution Period & Benefit Period</li> <li>Penalty & Interest</li> <li>COVID-19 pandemic</li> </ul> Practical Session (Workshop) <ul> <li>Online Registration of Establishment</li> <li>Registration of Branch/ Sub-Code</li> <li>Online Generation of TIC/E-Pehchan/IP</li> <li>Online IP Mapping with Aadhaar</li> <li>Online Challan Generation</li> <li>Online SharmSuvidha Portal</li> <li>Accident Register and Records</li> <li>ESI Report In Excel Sheet</li> <li>Registers and Records</li> <li>Various Forms (EE and ER), Display & Return</li> </ul> d.Payment of Gratuity <ul> <li>Calculation of Gratuity</li> <li>Maximum Gratuity & Taxability</li> <li>Group Gratuity Policy</li> </ul> Practical Session <ul> <li>Various Nomination Forms</li> <li>Gratuity Claim Form</li> <li>Display</li> </ul>

Module 3 - Corporate IR / Labour Law Compliances

3.1 (a). DISCIPLINARY ACTION/TERMINATION/MISCONDUCT <ul> <li>What’s Disciplinary Action?</li> <li>Definition of Misconduct/Violation of Code of Conduct.</li> </ul> WORKSHOP SESSION <ul> <li>Preparations of Show Cause Notice/Charge Sheet.</li> <li>Domestic Inquiry</li> <li>Termination</li> </ul> 3.1 (c). SHWW Act, 2013 (New Topic Added) <ul> <li>What is Sexual Harassment</li> <li>What is the workplace</li> </ul> WORKSHOP SESSION <ul> <li>Sexual Harassment Policy</li> <li>Internal Complaints Committee (ICC)</li> <li>Local Complaints Committee (LCC)</li> <li>Penalty</li> </ul> 3.1 (e). FACTORY Act, 1948 <ul> <li>Objectives</li> <li>Applicability</li> </ul> WORKSHOP SESSION <ul> <li>Registration and Licensing Procedure</li> <li>Annual Leave with wage</li> <li>Facilities</li> <li>Annual & half Yearly Return</li> <li>Safety-related Provision</li> <li>Registers & Records</li> <li>Various Returns</li> <li>Registers and Records</li> </ul> 3.1 (g). TRADE UNION <ul> <li>Definition</li> <li>Condition/Clause</li> <li>Function</li> <li>Benefits and Drawbacks</li> </ul> 3.1 (i). MINIMUM WAGES Act <ul> <li>Objective</li> <li>Applicability</li> <li>Notification</li> </ul> WORKSHOP SESSION <ul> <li>Registers to be maintained</li> <li>Returns</li> <li>Display(Notice)</li> </ul> Module 3.2 – Fully Practical Legal Calculations Class (Advanced Topic Added) <ul> <li>Design a PMS System</li> <li>Calculation of Full and final settlement</li> <li>Calculations of a Notice period</li> <li>Calculations of LTA</li> <li>Calculations of Medical Reimbursement</li> <li>Calculations of Man days for required of all returns like factory and contractor returns etc.</li> <li>Calculations of Attrition and issue &Control</li> <li>Calculations of absenteeism</li> <li>Calculations of suspension allowance</li> <li>Calculation of Overtime with new rule</li> <li>How to Draft the charge sheet in English for staff</li> <li>How to Draft the Charge Sheet In Hindi for worker</li> </ul> 3.1 (b). CONTRACT LABOUR (REGULATION AND ABOLITION) ACT 1970 <ul> <li>Objective</li> <li>Applicability</li> </ul> WORKSHOP SESSION <ul> <li>Registration & License</li> <li>Returns(Report)</li> <li>Facilities</li> <li>Registers and Records</li> <li>Displays</li> </ul> 3.1 (d). SHOPS & ESTABLISHMENT Act, <ul> <li>Objective</li> <li>Applicability</li> </ul> WORKSHOP SESSION <ul> <li>Registration</li> <li>Conditions of Work</li> <li>Registers to be maintained</li> <li>Displays(Notice)</li> </ul> 3.1 (f). BOWC (Building & Other Constructions Workers) Act, 1996 <ul> <li>Objective</li> <li>Applicability</li> <li>Eligibility conditions</li> <li>The responsibility of the Employer;</li> </ul> WORKSHOP SESSION <ul> <li>The responsibility of the Employer;</li> <li>Registration Procedure</li> <li>Registers, Records, and Returns;</li> <li>A grievance by an employee;</li> <li>The penalty for contravention of the Act</li> </ul> 3.1 (h). INDUSTRIAL DISPUTES Act, 1947 (New Topic Added) <ul> <li>Purpose</li> <li>Scope</li> <li>Forms and Formats</li> <li>Regulatory Body</li> <li>Employer’s Obligation</li> <li>Keywords used</li> </ul> 3.1 (j). APPRENTICESHIP Act, 1961 (New Topic Added) <ul> <li>Objective</li> <li>Contract of Apprenticeship</li> <li>Termination of Apprenticeship Contract</li> </ul> WORKSHOP SESSION <ul> <li>Payment to Apprentices</li> <li>Health, Safety and Welfare of Apprentices</li> <li>Rules and Guideline</li> </ul> Module 3.3 – How to Get Registration with legal Authority (Advanced Topic Added) <ul> <li>Factory Registration/Licensing with full Procedure</li> <li>Contractor Registration/Licensing with Full Procedure</li> <li>Air & water NOC & Consent with Full Procedure</li> <li>Standing Orders Certification with Full Procedure</li> <li>Fire NOC with Full Procedure</li> </ul> Module 3.4 – HR Audit <ul> <li>What is HR Audit</li> <li>Legal Compliance Audit</li> <li>HR Payroll Audit</li> <li>HR Policy Audit</li> <li>How to make the HR Audit Report?</li> </ul>

Module 4 - Learning & Organizational Development (Advanced Topic Added)

<h3>Learning & Organizational Development</h3> <ul> <li>Build Core and Functional Competency Frameworks</li> <li>Learning Need Analysis/ Module Design/ Budgeting / Calendar</li> <li>Assessment Processes & Feedback Analysis</li> <li>ROI Measurement</li> <li>Organizational Diagnosis/Assessment</li> </ul>

Module 5 - HR Policies (New Topic Added)

HR Policies <ul> <li>Why Policies, Steps to Frame HR Policy?</li> <li>HR Policy Framework/Checklist</li> <li>Attendance Policy</li> <li>Leave policy</li> <li>LTA & Reimbursement Policy</li> <li>Code of Ethics & Business Conduct</li> <li>Email, Internet & Computer use Policy</li> <li>Confidentiality & Non-Disclosure Policy</li> <li>Effective Retention Policies</li> </ul>

Module 6– HR -Business Partner (Advanced TopicAdded)

HR -Business Partner <ul> <li>Contributions of HR from Business Perspective?</li> <li>Review & Analyze Business Unit Data</li> <li>Employee Budgeting and Man Power Planning</li> <li>Workforce Planning, Succession Planning, Career</li> <li>Architecture Program and Skills Assessment</li> <li>Attrition Issues & Control</li> </ul>

Module 7 - Employee Relationship Management Workshop Session

Employee Relationship Management Workshop Session <ul> <li>Joining Formalities and Relieving Procedure</li> <li>Exit Interviews</li> <li>Employee Engagement</li> <li>Communication Downward, Upward, Horizontal</li> <li>Gamification and Modern age engagement activity</li> <li>BE open to coach and mentor</li> <li>BE Open to new Idea and Initiative</li> <li>Human Resource Round Table</li> <li>Practical Role Play for Employee Relationship Building</li> <li>Grievances</li> </ul>

Module 8- Interview

Interview <ul> <li>Interview Handling</li> <li>Skills Landing Interview Technique</li> <li>Mock Interview</li> <li>Win-Win Situation</li> </ul> <ul> <li> </li> </ul>

Module 9–SAP HCM

11.a – Introduction on ERP and SAP <ul> <li>Introduction to ERP & SAP</li> <li>Overview on SAP HR Sub Modules</li> </ul> 11.c – Personnel Administration <ul> <li>Integration setting with OM and PA</li> <li>Enterprise structure- Definition and Assignment</li> <li>Company</li> <li>Company Code</li> <li>Personnel Area</li> <li>Personnel Sub Area</li> <li>Personnel structure – Definition and Assignment</li> <li>Employee Group</li> <li>Employee Subgroup</li> <li>Number Ranges for Employee personnel numbers-internal & External with Feature Setup</li> <li>Customizing User Procedures:</li> <li>Configuration of Personnel actions –Info group – Action Menu</li> <li>Hiring</li> <li>Promotion</li> <li>Transfer</li> <li>Organizational Re- assignment</li> <li>Termination</li> </ul> 11.e – Indian Payroll <ul> <li>Introduction to payroll- HR domain process and SAP HCM Process-discussion on understanding the same</li> <li>Payroll area and Control Record (with Retroactive Accounting)</li> <li>Generation of payroll periods – period and date modifiers (with different country fiscal year settings) – Relevancy of this Time management</li> <li>Payment date setup and modifications</li> <li>ESG for CAP and PCR</li> <li>Pay scale structure</li> <li>Pay scale Area</li> <li>Pay scale type</li> <li>Pay scale Group</li> <li>Pay scale level</li> <li>Wage Types- concept, types & use of wage types</li> <li>Primary wage types</li> <li>Secondary Wage types</li> <li>Features used in payroll Wage types characteristics</li> <li>Valuation of wage type Direct § Indirect</li> <li>Wage type model and defaulting of WT model</li> <li>Configuration of basic pay info type</li> <li>Concept of Annual salary and configuration and applicability to the relevant countries</li> <li>Other payroll info types configuration – General and country specific</li> <li>Payroll processing in SAP system</li> <li>INDIA- Statutory Configuration on TAX, PF, ESI, Professional TAX.</li> <li>Other Statutory configuration on exemptions, HRA, Car & Conveyance etc.,</li> <li>Understanding of Indian Payroll driver, payroll schema & India specific Payroll functions in SAP HCM</li> <li>India specific reports and subsequent payroll activities.</li> <li>Checking of payroll results</li> <li>Understanding and customizing the Remunerations statement</li> <li>Subsequent payroll activities:</li> <li>Bank transverse process/Cash/Cash Payment o FICO posting from HR and Finance Perspective.</li> </ul> 11.b – Organizational Managemen <ul> <li>CPlan version –Definition and setting of New plan Versions</li> <li>Organizational Management Introduction</li> <li>Structure in SAP HCM</li> <li>Objects</li> <li>Relationships</li> <li>Structure of Relationships</li> <li>Syntax of Relationship</li> <li>Methods of Creating Org. Structure</li> <li>Simple Maintenance</li> <li>Expert Mode</li> <li>Organizational and Staffing</li> <li>Info type in OM</li> </ul> 11.d – Time Management <ul> <li>Introduction to time management – time management process in HR</li> <li>Public Holidays – configuration of different types of Holidays</li> <li>Holiday Calendar with Business scenarios – Applicability with Enterprise Structure</li> <li>Factory Calendar in HR Perspective</li> <li>Work Schedules</li> <li>Break Schedule</li> <li>Daily work Schedules (with Variantswith Business Scenarios)</li> <li>Period work schedules</li> <li>Day types and Day type selection rules</li> <li>Introduction to Absences and Attendance</li> <li>Absences quotas Configuration</li> <li>Counting Rules for Absences/Attendances</li> <li>Deduction Rules</li> <li>Assignments of different rules in Absences/Attendances.</li> </ul> 11.f – Recruitments <ul> <li>Introduction to Recruitment</li> <li>Workforce requirement and Advertisement</li> <li>Media</li> <li>Recruitments instruments</li> <li>Address for recruitments instruments</li> <li>Applicant Administration</li> <li>Personnel Officer</li> <li>Applicant Structure</li> <li>Applicant Group, Range & Unsolicited Applicant Group</li> <li>Applicant selection</li> <li>Applicant Status text</li> <li>Overall and Vacancy status</li> <li>Applicant Status reason</li> <li>Permissibility of Status reason to status</li> <li>Applicant Data</li> <li>Creating of new advertisement</li> <li>Receipt of application</li> <li>Application Actions</li> <li>Transferring of applicant data to personnel Administration</li> </ul>

Module 10 Project Process in SAP HCM implementation

Project Process in SAP HCM implementation <ul> <li>Preparation of projects in ASAP methodology</li> <li>Roles and Responsibilities of the Consultants in different phases of project</li> <li>Understanding the HCM specific process in HCM implementation.</li> </ul>

Module 11 Reporting Tools OR SAP HCM Report

Reporting Tools OR SAP HCM Report <ul> <li>Reporting Tools OR SAPHCM Report</li> <li>Technical Knowledge</li> <li>Introduction to ABAP program with Table and field</li> </ul>

Module 13 Basics of HR Analytics

Basics of HR Analytics <ul> <li>Predictive Analytics Overview</li> <li>Comprehensive Analytical HR Framework Overview</li> </ul>

Module 14 to 19 – HR Psychometric Test

Module – 16 <ul> <li>Showpiece with 5W’s of Psychometric Test</li> </ul> Module – 17 <ul> <li>Outline of Psychology & Psychometric Assessment Overview</li> <li>Impact of Fair Assessment</li> </ul> Module 18 <ul> <li>Tests for character – The PSI</li> <li>PSI- A Brief History</li> <li>How to Analyze the PSI Test</li> <li>Different Personality Types</li> <li>Uses of PSI</li> </ul> <ul> <li>Psychology Basics involving renowned psychologist</li> <li>Psychometric Assessment</li> <li>Understanding the Psyche/Mind</li> <li>Understanding Competence</li> <li>What & why to Assess</li> <li>Establish Fair Psychometric Assessment</li> </ul> Module 19 <ul> <li>Understanding of some of widespread tools with administration & Score card</li> <li>MBTI</li> <li>FIRO B</li> <li>DISC</li> <li>RIASEC</li> <li>16 PF</li> </ul>

Module 15 Project Preparation (SAP)

Project Preparation <ul> <li>Assignment based on the Module discussed above</li> </ul>

HR Payroll Training Programme Modules

Advanced HR Payroll and Analytics Training Modules