• Introduction to competency-based HRM
• Understanding competencies ,Functional, core and Managerial
• Framework of setting competencies
• Competency mapping on excel
• Competency evaluation
• ADC exercises
• Understanding competency matrix

• Introduction to the job interview
• Types of interview questions
• The behavioural event interview
• Structure of a behavioural event interview
• Finding the STAR
• Strategies for conducting an effective BEI

This module will help the candidate with the knowledge of Payroll Management. Learn about HR planning, Employee transfer, and the Increment process. Know about the Income under the Head Salaries u/s 17(1) of Income Tax Act 1961. Gain a comprehensive understanding of Reimbursement management, attendance management, and Salary components.

Income Under The Head Salaries u/s 17(1) of Income Tax Act, 1961

• Meaning of Salary, Wages, Annuity and Retirement benefits
• Allowances and type of Allowances
• Valuation of Perquisites and Taxability of Perquisites
• Retirement benefits
• Salary Components in terms of Fixed and Variable:
• Setup Payroll Administration and Functions
• Structure of cost to the company – CTC Annexure
• Bonus Payment and Treatment of Bonus
• Fee and Commission and Overtime Payment
• Taxable and Non-Taxable Payments (Exempted)

Allowances

• Fully taxable allowances
• Partially taxable allowances upto bills produced
• Partially taxable allowances upto limits
• Fully tax exempted allowances

Perquisites

• House to stay
• Car by employer under different conditions 
• Driver by employer
• Medical Insurance
• Superannuation
• Furnishings
• NPS

Employee Provident Fund – PF

• What is a covered establishment?
• PF Wages, Contribution accounts & Rates
• PF Deposit Date                

Employee State Insurance – ESI

• What is a covered establishment?
• Existing Wage Limit, ESI contribution rates, Contribution Periods

Professional Tax – PTAX (PT)

• Professional tax applicability
• Professional tax slab state-wise
• Professional tax calculator
• Professional tax payment & registration

Labor Welfare Fund – LWF

• Labor welfare fund applicability
• Labor welfare fund rate(slabs) state-wise
• Where to deposit Labour Welfare Fund   

Professional Tax – PTAX (PT)

• PT applicability 
• PT slabs statewise
• PT exemptions and calculation

Statutory bonus and Gratuity

• Labor welfare fund applicability
• Labor welfare fund rate(slabs) state-wise

Tax Deduction at Source – TDS

• What is Income-tax?
• Income tax slabs and Income tax Computation 

Deduction (u/s 80C – u/s 80U) of Chapter VI-A of Income Tax Act, 1961

• Deductions under section 80C.
• Deductions under section 80D, 80E, 80U.
• Deductions under section 80DD, 80DDB, 80CD2
• Deductions under section 80G, 80GG, 80GGA,
• Deductions under
• Validation or Examination of Investment Proofs and Reimbursement Claims
• Investment Proofs examination Under section 80C
• Investment proofs examination others
• Expense Bill examination of Reimbursements
• Limit of Deductions and max eligibility up to Pro Rata, Previous Employer Income.
• LTA, HRA, Leave Encashment, and Gratuity Exemption Calculations
  Leave Travel Exemption
• House Rent allowance – HRA Exemption
• Leave Encashment Exemption
• Gratuity Exemption, Exemptions others. 
• Deduction of Interest on Housing Loan u/s 24(b) of Income Tax Act, 1961
  Meaning of House Property
• Essential conditions for taxing income under this head
• Interest on borrowed capital, Standard deductions
• Deductions from income from house Property [Sec.24]
• Calculation format, and Examples

Calculating tax payable from employee salary after all exemptions and deductions

Claim and Reimbursement Management

• Claim Management Module.
• Expense bills Submission.
• Medical Reimbursement, and Travel Reimbursement.
• Type of Reimbursements.
• Disbursement of Claim Reimbursement.

Attendance Management System and Resignation (Full and Final) of Exits

• Time Management System.
• Leave Management System.
• Type of leaves, and Leave without Pay Calculation.
• Full and Final Settlement Input and Calculation.

Gather Payroll Inputs, Setup Employees Information in Payroll System -Razorpay

• The Features of Payroll Processing.
• Employee Profile setup.
• Update Payroll Changes.

Verification and Payroll Checking Step by Step

• Prepaying variance reports of Monthly Payroll Payout.
• Transformation of Payroll inputs.
• Attribution of head-count and cost payout.
• Income Tax deduction and Variance of Income Tax deduction – TDS.
• To give maximum benefit to Employee on investment declaration.
• Ensure Calculation of variance Compliances, PF, ESI, P.TAX, LWF, etc.

Salary Register, Slips, Bank Transfer and Management Information System – MIS

• Overview on salary Slip and Salary Register.
• Management Information Reports – MIS, Variance of Payroll and Cost Center Reports.
• Bank Transfer to the Employee, Cost to Company Reports.

• Types of PMS frameworks
• Selection of PMS framework
• OKR model
• OKR with PPP
• KRA/KPI model goal setting
• Balance scorecard
• KPI framework
• Track the achievement of the KPI
• Report the achievement of the KPI
• Improve the achievement of the KPI

• Concept of performance appraisal
• 9 box grid evaluation
  Bell curve
• Other methods to do appraisal
• Section management
• Design of performance appraisal form
• Using of performance appraisal review form
• Linking appraisal with PMS & competencies

• Making pay ranges with Benchmarking of Salary
• DOING BASELINING TO SETUP TARGETS
• Internal equity, External equity , Individual equity with midpoint progression, pay range spread
• Salary slabs, Pay Parity, Median
• Point plan method for job grading and setting up levels

• Implementing and facilitating a robust succession planning process.
• Build an approach that will allow your organisation to keep its leadership pipeline full and flowing
• 9 box Grid System
• Decision on salary increment pool
• Linking model with L&D

• Introduction to HR Policies
• Vision and Value Alignment in HR policies
• Policy Classification
• Understanding policies and procedures
• Creation of HR Policies
• Structure of HR policies
• Most used HR Policies
• Introduction to some HR agreements / contracts
• Offer letter
• Appointment letter
• Terms of employment, Bonds
• Contracts and service agreements
• Background verification
• Joining formalities
• Leave Management

• Introduction to Learning & Development
• DNA of training – KSA
• Four levels of Skills Development
• Types of learning programs
• Approaches to training
• ADDIE Model (An introduction to the phases
• Analysis
• Design
• Development
• Implementation
• Evaluation (Criteria of evaluation, Methods and Kirkpatrick’s Model)

• Need of HR Budget in an organisation
• Skills required for preparing HR Budget
• HR as a cost centre
• Important aspects to be considered before budgeting
• Step by step guide for creating HR budget
• Important stakeholders to be considered
• Components of HR Budget
• First budget iteration
• Final budget
• How to monitor and measure results
• HR Budgeting best practices

• What is Hr analytics
• 4 steps of Hr analytics
• Types of HR metrics
• Types of HR charts
• Use MS excel to create and automate the
• Make HR Dashboards and understand all the charts that you can draw in Excel
• Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
• Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the HR data
• Knowledge of all the essential Excel formulas required for HR Analytics
• Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
• Discover how to set up Power BI Desktop for optimal HR data analysis.
• Explore various methods to connect Power BI with different data sources, including CSV and SQL databases.
• Manipulate HR data effectively using Power Query Editor, including merging, appending, and managing queries.
• Master advanced data transformation techniques such as splitting columns, replacing values, and using the Group By tool.
• Implement pivoting and unpivoting in Power Query for dynamic data analysis.
• Create robust data models using relationships, understanding cardinality, and utilizing star and snowflake schemas.
• Design insightful HR charts and visuals, including bar, line, pie, and scatter charts, with advanced formatting options.
• Develop proficiency in Data Analysis Expressions (DAX) for creating powerful measures and calculated columns in Power BI.
• Construct interactive and visually appealing HR reports, incorporating elements like slicers, bookmarks, and navigators.
• Apply conditional formatting and advanced analytical techniques to enhance the interpretability and impact of HR reports in Power BI.
• calculation of HR metrics

Understanding the need for HR Policy

• Primary things to keep in mind for creating effective HR Policies
• Developing Policies
• Step by Step process of drafting policies
• Do’s and Don’t’s to follow
• Important aspects once the policy is created
• Internal Template to draft a policy
• Art of successful implementation of policies
• Practical drafting of Policy
• Practical examples and assignments