Monthly Payroll Template
A monthly payroll template helps businesses calculate employee salaries consistently — accounting for working days, absences, deductions, bonuses, and applicable statutory contributions. For Indian businesses, this includes PF, ESI, professional tax, and TDS where applicable. DeskPanda automates this calculation from attendance data, eliminating the manual spreadsheet work.
Use this template in DeskPanda — FreeWho uses this template
- Processing monthly salary for office and field staff
- Calculating wages for shift-based manufacturing or retail workers
- Managing payroll for mixed teams with different pay structures
- Generating payslips for all employees in one batch
Key fields in this template
Employee Name & ID
Unique identifier for each employee to avoid confusion across payroll runs
Working Days
Total days worked in the month, calculated from attendance records
Gross Salary
Total salary before deductions — typically includes basic, HRA, and allowances
PF Deduction
Employee Provident Fund contribution (12% of basic salary for applicable employees)
Other Deductions
ESI, professional tax, loan repayments, or other applicable deductions
Net Pay
Final amount to be paid to the employee after all deductions
Use this template in DeskPanda — free.
Free for up to 8 users. No credit card. Live in under an hour.
Common questions
Related templates
This template works best inside DeskPanda.
Task management, HR, attendance, payroll, invoicing, and team chat — in one platform. Free for up to 8 users.