Ctrl+K

HR & Payroll Reports

JobNext provides 41 reports across three report folders that cover the full spectrum of HR, payroll, and payslip analytics. These reports give you visibility into workforce composition, leave management, statutory compliance, payroll costs, and salary disbursement across the organization.

HR Analytics 0:19
Payroll Analytics 0:19
Payslip Analytics 0:19
HR Analytics Deep Dive 0:39
Payroll Analytics Deep Dive 0:38
Payslip Analytics Deep Dive 0:38
Report Folder Report Count Coverage
HRAnalytics 28 Staff details, leave management, documents and compliance, statutory summaries (ESI, PF, PT, TDS)
PayrollAnalytics 11 Payroll abstracts, attendance register, salary allocation, overtime, gratuity, settlements
PayslipAnalytics 2 Payslip generation — site-wise and staff-wise views
How to Access

Navigate to Analytics & Reports → HR & Payroll Reports. Reports are organized into the three folders listed above. Most reports accept Region and Division filters to narrow results to a specific business segment.

Complete Report Inventory

The table below lists all 41 reports grouped by functional category. Use it as a quick reference to find the right report for your need.

HR Analytics — Staff & Workforce (7 reports)

# Report Name Purpose
1 Staff Details Comprehensive staff information covering personal, employment, and assignment data
2 Employees Joined New joiner listing within a specified date range
3 Resigned Employees Separated/resigned employees within a date range
4 Skills Inventory Staff skills, certifications, and completed training courses
5 Phone Usage Staff phone billing compared against monthly usage limits
6 Employees Expected Return From Leave Staff currently on leave with upcoming return dates
7 Employees Not Returned From Leave Staff whose return date has passed without check-in (absconder tracking)

HR Analytics — Leave Management (10 reports)

# Report Name Purpose
8 Leave Balance Current leave balance per employee per leave type
9 Leave Balance Detail Detailed leave balance breakdown sourced from the HR linked server
10 Leave Balance Report Comprehensive view showing Opening, Earned, and Used balances per leave type
11 Leave History Full leave request history including settlement status
12 Leave In a Period All leaves falling within a specified date range
13 Leave Register Summary of days applied and approved, broken down by month
14 Leave Register Detail Detailed leave register per staff member per month
15 Leave Salary Leave salary accrual details for staff
16 Leaves Due Leave balances by leave type within a financial period
17 Employees Going On Leave Upcoming approved and pending leaves

HR Analytics — Documents & Compliance (4 reports)

# Report Name Purpose
18 Document Expiry Lists staff documents approaching or past their expiry date
19 Document List Complete inventory of all staff documents with issuing authority details
20 Employee Dependent Documents Documents held for employee dependents, filterable by status (Active, Leave, Separated)
21 Employee Missing Documents Identifies staff missing required documents, grouped by employee group

HR Analytics — Statutory (7 reports)

# Report Name Purpose
22 ESI Summary Employee State Insurance summary showing both employee and employer contributions
23 PF Summary Provident Fund summary with employee contribution, employer contribution, and VPF
24 PT Summary Professional Tax summary per employee
25 TDS Details Monthly Tax Deducted at Source details per employee
26 India Income Tax Annexure I Monthly TDS breakup per employee with PAN number
27 India Income Tax Annexure II Comprehensive annual tax computation including income slabs, surcharge, and education cess
28 PaySlip View Site Wise SubReport Payslip sub-report used in site-wise payslip views (embedded child report)

Payroll Analytics (11 reports)

# Report Name Purpose
29 Detailed Payroll Abstract Detailed payroll breakup grouped by Employee Group, Business Unit, Camp, Region, and Job
30 Staff Salary Details Salary details broken down by welfare type, job assignment, and month
31 Payroll Welfare Allowances All payroll welfare items segmented by type: earnings, deductions, employer contributions
32 Job wise Salary Allocation Detailed Salary cost allocation broken down by job/project
33 Overtime Analysis Overtime hours and cost analysis per employee
34 Attendance Register Daily attendance with hours worked (uses temporary tables and CTEs)
35 All Employee Details Full employee details across all departments and statuses
36 Gratuity Gratuity accrual tracking per employee based on tenure and salary
37 Airtickets Accrued Air ticket accrual liability per employee
38 Settlement Register Leave settlement and final settlement register for separated employees
39 Staff Expenses Ledger-wise Staff-related expenses posted to finance, grouped by ledger account

Payslip Analytics (2 reports)

# Report Name Purpose
40 PaySlip View Site Wise Generates payslips grouped by site/job for bulk printing
41 PaySlip View Staff Wise Generates individual payslips per staff member showing earnings, deductions, employer contributions, and leave balance summary

Key Reports in Detail

Staff Details

The Staff Details report is the most comprehensive workforce report. It consolidates personal information, employment data, department and designation, job/project assignment, and region/division classification into a single output. Use this report for headcount analysis, workforce planning, and audit preparation.

Tip

Export Staff Details to Excel for further slicing by cadre, department, or nationality. The report includes all active, on-leave, and separated staff — filter by status to focus on the segment you need.

Leave Balance

The Leave Balance report shows the current balance per employee per leave type (annual, sick, casual, etc.). Three variants are available:

  • Leave Balance — Quick summary of current balances
  • Leave Balance Detail — Granular breakdown sourced from the HR linked server
  • Leave Balance Report — Full view with Opening, Earned, and Used columns per leave type

Use Leave Balance reports at month-end to identify employees with low or zero balances, and cross-reference with Leave History and Leaves Due reports for trend analysis.

Employees Joined & Resigned

These two reports track workforce movement. Employees Joined lists all new hires within a date range, while Resigned Employees lists all separations. Together they provide a clear picture of attrition rates and hiring velocity. Both reports accept date range, region, and division filters.

Payroll Summary (Detailed Payroll Abstract)

The Detailed Payroll Abstract is the primary payroll cost report. It provides a complete breakup of earnings, deductions, and employer contributions grouped by multiple dimensions:

  • Employee Group
  • Business Unit
  • Camp
  • Region
  • Job/Project

This report uses an optimized stored procedure (version 3) for fast execution even with large payroll datasets. Pair it with the Job wise Salary Allocation report to understand project-level labor costs.

PaySlip

Two payslip reports support salary slip generation:

  • PaySlip View Site Wise — Groups payslips by site/job for bulk printing. Uses the Site Wise SubReport (HRAnalytics report #28) as a child report.
  • PaySlip View Staff Wise — Generates individual payslips. Each slip includes earnings, deductions, employer contributions, and a leave balance summary.
Payslip Sections

Payslips display welfare items where show_on_payslip = 1 in the payroll welfare configuration. Items flagged as earnings (Earning = 1) appear in the Earnings section, while items flagged as deductions (Earning = 0) appear in the Deductions section. Employer statutory contributions are shown separately.

ESI, PF & PT Summaries

These three statutory reports pull contribution data using configuration-driven welfare codes:

Report What It Shows Configuration Keys
ESI Summary Employee and employer ESI contributions per month payroll.employeeesiwelfarecode, payroll.employeresiwelfarecode
PF Summary Employee PF, employer PF, and voluntary PF (VPF) contributions payroll.employeepfwelfarecode, payroll.employerpfwelfarecode
PT Summary Professional Tax deducted per employee per month payroll.ptwelfarecode

TDS & Income Tax

Three reports cover tax deduction and computation:

  • TDS Details — Monthly Tax Deducted at Source per employee
  • India Income Tax Annexure I — Monthly TDS breakup with PAN number for each employee
  • India Income Tax Annexure II — Comprehensive annual tax computation including income slabs, surcharge, and education cess

Document Expiry

The Document Expiry report lists all staff documents that are approaching or have already passed their expiry date. Filter by date range, region, and division to focus on a specific segment. This report is critical for organizations operating in jurisdictions that require valid work permits, trade licenses, or safety certifications.

Compliance Alert

Run the Document Expiry report weekly. Expired visas, trade licenses, or safety certifications can result in regulatory penalties. Pair this report with Employee Missing Documents to ensure complete compliance coverage.

Common Report Filters

Most HR and Payroll reports share a consistent set of filter parameters. The table below lists the filters you will encounter across the majority of reports.

Filter Applies To Description
Region All reports Restricts results to staff in a specific region. Joins to the staff additional details table.
Division All reports Narrows results to a specific division within the selected region.
Date Range (From / To) Joined, Resigned, Leave, Document Expiry, Payroll reports Defines the reporting period. For payroll reports this corresponds to the salary run month/year.
Employee Group Staff Details, Missing Documents, Payroll Abstract Filters by employee classification group (e.g., permanent, contract, daily wage).
Department Staff Details, Leave reports, Payroll reports Restricts results to a specific department.
Staff Status Dependent Documents, Staff Details Filter by Active, On Leave, or Separated status.
Leave Type Leave Balance, Leave History, Leaves Due Filters leave reports to a specific leave type (annual, sick, casual, etc.).
Salary Run Month/Year Payroll Abstract, Salary Details, Payslip reports Selects the specific payroll run period for payroll and payslip reports.

Best Practices

  • Run Document Expiry weekly — Expired documents can lead to regulatory penalties. Set a recurring reminder to check this report every week and action any expiring items at least 30 days before their expiry date.
  • Cross-reference attendance and payroll — Run the Attendance Register alongside the Detailed Payroll Abstract at month-end. Verify that working days in the attendance report match the days used for salary calculation.
  • Review statutory reports before filing — Generate ESI Summary, PF Summary, and PT Summary before submitting statutory returns. Reconcile the totals against your filing workings to catch discrepancies early.
  • Use region and division filters — For organizations with multiple locations, always apply region and division filters rather than running reports for the entire company. This produces faster results and more focused analysis.
  • Archive payslips monthly — After each payroll run, generate and archive both Site Wise and Staff Wise payslips. These serve as the official salary record and are frequently requested during audits.
  • Track attrition with Joined and Resigned reports — Run these two reports for the same date range to calculate net workforce change. Comparing month-over-month trends helps identify retention issues early.
  • Validate TDS before year-end — Use TDS Details and Income Tax Annexure I/II reports to verify tax computations before issuing Form 16. Corrections after filing are costly and time-consuming.

Frequently Asked Questions

What is the difference between the three Leave Balance reports?

Leave Balance provides a quick summary of current balances per employee per leave type. Leave Balance Detail sources data from the HR linked server and gives a more granular breakdown. Leave Balance Report is the most comprehensive, showing Opening balance, Earned during the period, and Used during the period for each leave type. Use the summary version for quick checks and the detailed versions for audits and reconciliation.

How do I generate payslips for an entire site at once?

Use the PaySlip View Site Wise report under the PayslipAnalytics folder. Select the salary run month/year, then choose the site or job. The report generates payslips for all staff assigned to that site in a single output, ready for bulk printing. Each payslip is formatted as a separate page.

Why do some statutory reports show zero amounts?

Statutory reports (ESI Summary, PF Summary, PT Summary) are driven by configuration keys in the system configuration table. If the welfare codes referenced by keys like payroll.employeepfwelfarecode or payroll.ptwelfarecode are not set up correctly, the reports will return zero values. Contact your system administrator to verify that the welfare code mappings are correctly configured under Administration → Configurations.

Can I track employees who have not returned from leave?

Yes. The Employees Not Returned From Leave report under HRAnalytics identifies staff whose approved leave return date has passed but who have not checked back in. This report depends on the hr.report.onleavestatus configuration key to determine which status codes define "on leave." Use this report alongside Employees Expected Return From Leave for proactive workforce tracking.