Loss of Pay (LOP) is the salary deduction applied when an employee is absent without approved leave, or has exhausted their leave balance. The core formula is simple - per-day salary (monthly gross ÷ days in month) multiplied by LOP days - but applying it correctly across a real payroll sheet, for dozens of employees with different absence stretches and month boundaries, is where manual Excel work breaks down.

This tool splits each employee's LOP period into individual, HRMS-ready date rows - the format most HR systems expect for bulk upload, rather than a single date-range entry most systems can't parse directly.

A common example: an employee is on LOP from 28 March to 3 April. Since payroll runs on a calendar-month basis, this needs to be split into two entries - 4 days in March, 3 days in April - each attributed to the correct payroll cycle.

Priority date protection flags overlapping absence records instead of silently double-counting a day. Duplicate overlap guarding ensures the same date is never written twice for one employee across multiple rows.