ESI Highlighter

Navigation Path

PF & ESI → ESI Highlighter

URL

/pf-esi/esi-highliter

Description

The ESI Highlighter module is used to analyze and highlight Employees’ State Insurance (ESI) contribution applicability and data accuracy across employees. It helps payroll and compliance teams validate ESI deductions before challan generation and statutory filing.

Key Capabilities:

Filter ESI data by employee, client, unit, and designation
Highlight ESI applicability and contribution status
State-wise and branch-wise ESI analysis
Month-wise and year-wise ESI review
Identify employees exceeding ESI wage limits
Detect missing or incorrect ESI deductions
Support ESI statutory compliance verification

1. Page Overview

What is ESI Highlighter?

ESI Highlighter is a pre-compliance analytical tool that highlights ESI-related payroll data. It allows users to verify whether ESI contributions are correctly applied to eligible employees before ESI challan generation.

Key Highlights:

Used before ESI challan generation
Supports multi-employee and multi-unit analysis
Identifies ESI eligibility and exemption cases
Reduces compliance errors and penalties

Typical Use Cases

Validate ESI applicability for newly onboarded employees
Cross-check ESI deductions before monthly filing
Identify employees missing ESI contribution
Review ESI data client-wise or unit-wise
Ensure statutory compliance under the ESI Act

2. Filter Section

The filter section allows granular selection of employees and payroll data for ESI analysis.

Employee

Field	Type	Description
Employee	Multi-select list	Select one or more employees

Features:

Searchable employee list
Multi-select with checkbox
Scrollable list for large datasets

Purpose:

Analyze ESI data at employee level
Verify individual ESI eligibility

Client

Field	Type	Description
Client	Multi-select list	Select client(s)

Features:

Searchable list
Multi-select capability

Purpose:

Client-wise ESI compliance review

Unit

Field	Type	Description
Unit	Multi-select list	Select unit(s)

Features:

Multi-select with checkbox
Displays unit code and name

Purpose:

Unit-wise ESI data analysis

Designation

Field	Type	Description
Designation	Multi-select list	Select designation(s)

Features:

Searchable designation list
Multi-select option

Purpose:

Role-based ESI applicability analysis

State

Field	Type	Description
State	Dropdown	Select state

Purpose:

State-wise ESI compliance verification
Useful when coverage differs by location

Branch

Field	Type	Description
Branch	Dropdown	Select branch

Purpose:

Branch-wise ESI contribution review

Month

Field	Type	Description
Month	Dropdown	Select salary month

Options:

January to December

Purpose:

Review ESI deductions for a specific payroll month

Year

Field	Type	Description
Year	Dropdown	Select salary year

Purpose:

Year-wise ESI compliance analysis
Historical ESI verification

3. Action Buttons

Search

Property	Description
Color	Purple
Action	Fetch ESI highlighted data

Behavior:

Retrieves ESI data based on selected filters
Displays highlighted results for review

Reset

Property	Description
Color	Gray
Action	Clear all selections

Behavior:

Clears all filters
Resets the page to default state
Removes highlighted output

4. Results Section

After clicking Search, the system displays highlighted ESI payroll data.

Highlighted Output

Possible Highlights:

Employees eligible for ESI with correct deduction
Employees missing ESI contribution
Employees exceeding ESI wage ceiling
Employees exempt from ESI
Data mismatches requiring correction

Usage:

Validate ESI data before challan generation
Correct payroll configuration issues
Ensure statutory accuracy

5. Compliance Notes

ESI Highlighter should be used before challan generation
Helps avoid incorrect ESI filing
Reduces risk of penalties and interest
Supports audit and inspection readiness

6. Field Definitions, Usage, and Calculation Logic

The ESI Highlighter is a sophisticated PDF processing tool that bridges the gap between payroll records and statutory ECR (Electronic Challan cum Return) files.

Technical field Definitions (Internal Matching)

Field	Source	Description
ESI Number	`esiNo`	The primary key used to match payroll records with PDF text content.
Employee Name	`empName`	Used for verification and display on the generated summary page.
Employee Code	`empCode`	Internal identifier used to cross-reference `SalaryAutoProcess` records.
Coordinates	`x, y, width, height`	Spatial data extracted from the PDF to position the highlight overlay.

Usage & Highlighting Mechanism

Data Synchronization:
- The system first retrieves all employees matching the selected filters (Client, Unit, etc.) for the specific month/year.
- It collects their ESI Numbers from the SalaryAutoProcess table.
PDF Parsing:
- The backend engine loads the uploaded ESI ECR PDF for that period.
- It performs a deep text-extraction to find the exact spatial coordinates of each target ESI Number.
Highlighter Overlay:
- Using the pdf-lib library, the system draws semi-transparent yellow rectangles over the matching rows in the PDF.
Summary Generation:
- An automated Summary Page is prepended to the document.
- This page lists every highlighted employee, their ESI number, and the page number where they appear in the original document.

Logic & Constraints

Normalization: The system normalizes ESI numbers (removing spaces/hyphens) before matching to ensure high accuracy regardless of PDF formatting.
Exact Match: Only rows containing an exact match for the filtered ESI numbers are highlighted.
ZIP Export: If multiple ECR PDFs are found for the filtered criteria, the system bundles all highlighted versions into a single .zip file for download.

The ESI Highlighter module is a critical validation tool that ensures accurate ESI contribution processing across employees, units, and clients. It helps organizations maintain compliance with ESI regulations by identifying issues early in the payroll cycle.

PF Highliter Forms