HR Payroll

HR Payroll

Avenirhub offers HR payroll training program for candidates that refers to the business management especially for those who are looking to build a career in the field of HR payroll processing. HR Payroll training is a basic aspect and very significant of any HR department in a business organization and where the operator is required to calculate the salaries of his employees after making all deductions and compensating accurately and timely. The course is committed to help students understanding all the legal compliance & statutory, learning the effective tools to make payroll processing very easy and effective.

The role of Avenirhub in aim payroll processor is to assist participants in obtaining a good job in any well-established company by giving them sufficient training and needing expertise again to execute tasks.

Why do you need HR payroll?

  1. As we all know that it is mandatory for every business organization to process the payroll of employees in a more timely and precise manner and thus they employ professional payroll operators for the requirement.
  2. You will be made an integral part of the human resources department for how to calculate the salary structure of the industry and the exact salary of many employees working for the company.
  3. It states that a HR payroll operator has a huge scope as it offers job opportunities to many.
  4. While doing your job you’ll learn about many Indian provisions act and laws of business.
  5. You will become irreplaceable and highly important personnel for the company as you will be taking care of their monetary transactions and even a single error can result in a disastrous situation.
  6. Since, the significance of HR payroll services is so high, the candidate will receive a much higher salary as compared to others.
  7. HR payroll provides better job security and opportunities in the business world, so you do not have to worry about finding yourself a proper job.
  8. You will be able to perform many accounting tasks because you will have specialized accounting skills to execute multiple payroll tasks.

With all these important features and benefits, it would be a wise decision to join a quality HR payroll training course. We Avenirhub are considered the best HR training institute in Lucknow. Enroll for our HR payroll training course in one go and be ready to achieve your ambition you were dreaming of.

HR Payroll Module

Module 1: Statuary and Legal Compliances

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

b. 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
  • Online Challan Generation
  • ESI Report In Excel Sheet
  • Registers and Records
  • Various Forms

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

d. Payment of Gratuity

  • Calculation of Gratuity
  • Maximum Gratuity and Taxability
  • Group Gratuity Policy

Practical Session

  • Various Forms
  • Display
Module 2: Compensation and Benefits


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


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

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

Topics Covered:

Advanced Excel

Lookup 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

Analysis:- Single/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.

Module 3: Corporate IR/Labour Law Compliances


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


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

3. SHWW Act, 2013 (New Topic Added)

  • Sexual Harassment Policy
  • Internal Complaints Committee


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


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

6. FACTORY Act, 1948

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


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


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

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