Payroll Calculator

Calculate salary for a selected month using working-day method. You can include public holidays (database), add manual holiday dates, specify worked date-range or present days, and deduct advances.

Employee

Month

Weekend Option

Include public holidays from DB (These dates are stored in the public_holidays table.)

Manual Holiday Dates (optional) Accepts many formats; will normalize to YYYY-MM-DD.

Advance Deduction (Rs.)

Worked From (optional)

Worked To (optional)

Or Present Days (number)

Notes (optional)

Recent Salary Logs

ID	Employee	Month	Gross	Net	Created
1	Amir Shahzad	2025-08	Rs. 3538.48	Rs. 3538.48	2025-09-01 16:37:33

Quick Admin Tips

Add employees into the employees table (name + monthly_salary).
Add public holidays into the public_holidays table to auto-exclude them for any month.
If you prefer automatic PDF payslips, I can add a "Generate Payslip" button next.