Staff Salary & Attendance Calculator
Enter each staff member's monthly salary and attendance — present days, half-days, overtime hours and any advance — and get the exact net payable for everyone, ready to download as a PDF or Excel/CSV sheet.
Per-day = monthly salary ÷ working days. Half-days count as 0.5. All maths runs in your browser.
Want the attendance + salary google sheet?
We'll send a free Google Sheet that saves and updates itself — no re-typing every time. It lands on your WhatsApp.
Attendance to payslip, automatically
Our CRMs track daily attendance and compute payroll with no spreadsheets and no month-end disputes. From ₹499 one-time.
How salary from attendance is calculated
The tool works out a per-day rate (monthly salary ÷ working days in the month), then pays for the days actually worked. A present day counts as 1, a half-day as 0.5. Overtime is added at your hourly OT rate, and any advance taken during the month is deducted.
So: net payable = (per-day × days worked) + overtime − advance. Setting the correct number of working days for the month (26, 30, etc.) is what keeps it accurate.
Make payroll dispute-proof
Salary arguments usually come from unclear attendance and hand math. Download the payout sheet and share it with staff so everyone sees their present days, overtime, advance and final amount — calculated the same way for everyone.
FAQ
Is the salary calculator free?
Yes — calculate payroll for any number of staff for free. All maths runs in your browser; nothing is uploaded.
How are half-days and overtime handled?
A half-day counts as 0.5 of a working day. Overtime is entered as hours and multiplied by the OT hourly rate you set, then added to the salary.
Can I deduct advances?
Yes — enter any advance taken per staff member and it's subtracted from the net payable.
Can I download the salary sheet?
Yes — download it as a PDF payslip sheet or an Excel/CSV file for your records or accountant.