Payroll sheet template (Excel)
A ready monthly payroll sheet in Excel: for each employee enter basic pay, allowances, overtime and bonuses, then absence and lateness deductions, social insurance and tax, and it works out gross pay, total deductions and net salary, with a column for signing on receipt. Free, no signup.
Doing payroll by hand every month?
Dawmly runs payroll from real attendance: lateness, absence, overtime, social insurance and salary tax, with a payslip for each employee. Try it free for 14 days with every feature.
Start freeNext step: Payroll in Dawmly · Net salary calculator · Overtime sheet
What's in the file
- The monthly sheet: 30 employees with name, job title, basic pay, allowances, overtime and bonuses.
- Deductions: absence and lateness, the employee's social insurance share, salary tax and other deductions.
- Automatic sums: gross pay, total deductions and net salary per employee and for the company, with prepared, checked and approved fields.
How to use the payroll sheet
- Enter the company name and month, then one employee per row.
- Carry overtime over from the overtime sheet and lateness from the lateness deduction calculator.
- Work out each employee's social insurance and tax with the net salary calculator and type them in.
- Check the net pay, then print the sheet so each employee signs for their pay.
Why are social insurance and tax typed in?
The employee's social insurance share (11%) is worked out on the insurable wage between a floor and a ceiling, and salary tax uses the Law 7/2024 brackets after the exemption. So the sheet does not guess them with a formula that could be wrong: work them out in the net salary calculator and the social insurance calculator, then type them in.