Paid Days Reversal through Timesheet Adjustment with statutory Ignore/Recovery

Overview

The Paid Days Reversal functionality allows payroll administrators to reverse employee paid days either:

• Individually through manual timesheet adjustment, or

• In bulk through Excel import.

This ensures correct payroll processing when adjustments are required due to absenteeism, incorrect time entries, or compliance-related corrections.

1. Manual Adjustment (One by One)

Step 1: Navigate to Timesheet Adjustment

• Go to Timesheet>>>Processed Timesheet>>>select client and Load Show processed Timesheet
  

Step 2: Search Employee

• Select the Employee 

• Click on the Update timesheet Adjustment details button
  

Step 3: Enter Adjustment Details

• Enter the No. of Paid Days applicable as per reversal
  

• Select one of the Options:

  • Ignore Statutory
    

  • Recover Statutory
    

Step 4: Save Adjustment

• Click Update

• System confirms adjustment saved successfully
  
  

2. Bulk Adjustment (Excel Import)

Step 1: Go to Bulk Import

• Navigate to Timesheet>>>Import option>>>Timesheet Adjustment import
  

Step 2: Download Template

• Click Download sample Excel Template
  

   

  Employee No	Month Year	Pay Period	Loss Of Pay	Credit Note Without Statutory Amount Reversal	Credit Note With Employer Statutory Amount Recover From Employee Payment	Credit Note With Markup Reversal	Recover Employer PF	Recover Employer ESI	Recover Employer LWF	Refund Income Tax

Step 3: Fill Template

• Enter data for each employee:

  • Employee Code

  • Payroll Period

  • LOP

  • Reversal Option Yes or No (Ignore / Recover)

     

    Employee No	Month Year	Pay Period	Loss Of Pay	Credit Note Without Statutory Amount Reversal	Credit Note With Employer Statutory Amount Recover From Employee Payment	Credit Note With Markup Reversal	Recover Employer PF	Recover Employer ESI	Recover Employer LWF	Refund Income Tax
    166733	Jul-25	0	30	Yes	Yes	No	Yes	No	Yes	No
    166733	Jul-25	0	30	Yes	Yes	No	Yes	No	Yes	No
    168279	Jul-25	0	30	Yes	Yes	No	Yes	No	Yes	No

Step 4: Upload File

• Select completed Excel file and Upload
  
  

Step 5: Validate & Import

• System shows Validation Report (errors, duplicates, invalid data)

• Correct errors if any, re-upload if needed
  

Step 6: Apply Adjustments

• Once validated, click Import

• Adjustments saved successfully
  
  

3. Payroll Processing with Reversal

Step 1: Run Payroll

• During payroll run, system applies reversal entries automatically
  
  

Step 2: Check Impact

• Review:

  • Adjusted Paid Days

  • Salary Component impact

  • Statutory Impact (if selected)

     

  • Transaction No.	Month Year	Employee No	Employee	Processing Months	LOP Reversal Months	Payroll From	Processed Till	Status	Monthly CTC	Actual Period	Pay Period	LOP	Basic Salary	House Rent Allowance	Advance Statutory Bonus	Total Earnings	Employee ESI	Total Deductions	Payable Amount	Employer ESI	Chargable Amount	Management Fees	Bill Amount	Tax	Tax1 Amount	Tax2 Amount	Tax3 Amount	Tax Amount	Invoice Amount
    PRL/1388	July-2025	168279	Damodar Shinde		July-2025(-30.00)	16-Jun-2025	15-Jul-2025	Processed	17,853.00	0.00	(30.00)	30.00	(10,182.00)	(4,733.00)	(1,094.00)	(16,009.00)	(120.00)	(120.00)	(15,889.00)	(520.00)	(16,529.00)	1,000.00	(15,979.00)	IGST	(2,876.22)	0.00	0.00	(2,876.22)	(18,855.22)
    PRL/1388	July-2025	166733	Gautam Kumar Ghaley		July-2025(-30.00)	16-Jun-2025	15-Jul-2025	Processed	17,972.00	0.00	(30.00)	30.00	(10,763.00)	(4,384.00)	(903.00)	(16,050.00)	(121.00)	(121.00)	(15,929.00)	(522.00)	(16,572.00)	1,000.00	(16,022.00)	IGST	(2,883.96)	0.00	0.00	(2,883.96)	(18,905.96)
    									35825	0	-60	60	-20945	-9117	-1997	-32059	-241	-241	-31818	-1042	-33101	2000	-32001		-5760.18	0	0	-5760.18	-37761.18