Click days to toggle: Present → Absent → Paid Leave → Present
Present
Absent
Paid leave
Sunday
Enter present days and paid leave used for each employee this month.
Employee
Working days
Present days
PL used
PL balance
LOP
📊
Drop Excel file here or click to browse
Columns: Name | Present Days | Paid Leave Used
Excel format: Column A = Employee Name, Column B = Present Days, Column C = Paid Leave Used (optional, default 0).
Download the template to get the correct format.
Summary —
All employees
Add new employee
Personal details
Monthly fixed deductions
Monthly gross = Annual CTC ÷ 12, split as Basic 50% + HRA 30% + Special Allowance 20%. LOP deduction = (Gross ÷ Working days) × LOP days. LOP days = Working days − Present days − PL used (capped at PL balance).
Settings
Company details
Leave policy
Employees use paid leave first. Once PL balance is 0, absent days become LOP and salary is deducted proportionally.