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 salary & attendance saved every month?
Create a free account on the AgenticVani salary module — staff list, daily attendance, advances and payslips, all saved for you. No re-typing every month.
Start free — Salary & AttendanceAttendance to payslip, automatically
Stop re-typing last month's hazri. Mark attendance daily and the salary builds itself — overtime, advances and half-days included.
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.
There is a CRM app too
This tool is free and always will be. When you want the same work to happen on its own — every day, for every customer — that is what the app does.
Bolkar bill banao
Say the bill out loud in Hindi, English or a mix, and the app writes it. Nothing to type at a busy counter.
Hinglish mein poocho
“Is mahine kitna kamaya?” — ask your own records a question and get the real figure, never an invented one.
Sheet apne aap backup
The app still backs up to a Google Sheet in your own Drive, every day. You never lose the spreadsheet you trust.
Free plan forever. Voice control and Ask AI are on the paid plans, which start with a 30-day free trial — no card needed.