Payslip template (Excel)
A ready single-employee monthly payslip in Excel: earnings on one side (basic salary, allowances, overtime pay, bonuses), deductions on the other (absence and lateness, employee social insurance, salary tax, advances and other deductions), automatic totals for gross pay, total deductions and net salary, plus signature lines. Free, no signup.
Preparing individual payslips by hand every month?
Dawmly calculates payroll straight from approved attendance, overtime, lateness and absences, and gives every employee their own itemized payslip in the mobile app (Growth plan). Attendance is free for up to 3 employees.
Start freeNext step: Payroll in Dawmly · Net salary calculator · Payroll sheet (30 employees)
What's in the file
- Employee header: company name, month, employee name, job title, employee ID and department or branch.
- Earnings column: basic salary, allowances, overtime pay and bonuses/incentives, summing automatically to Gross pay.
- Deductions column: absence and lateness, employee social insurance share, salary tax, and advances/other deductions, summing automatically to Total deductions.
- Net pay and sign-off: highlighted Net salary cell, payment date/method, employee and HR/finance signature lines, plus a How to use instructions sheet.
How to use the payslip template
- Enter the company name, month and employee details at the top.
- Fill in earnings (basic, allowances, overtime and bonuses) and absence or advance deductions.
- Calculate the employee's social insurance and salary tax in the net salary calculator and type them into their cells.
- Check the net salary total, record the payment date or method, and print or export as PDF for the employee.
Why are social insurance and tax typed in?
The employee social insurance share (11%) uses the insurable wage between its floor and ceiling, and salary tax follows the Law 7/2024 brackets after the annual exemption. Rather than hiding a formula that could go stale, the payslip leaves those two cells as manual inputs so you can calculate them in the net salary calculator or social insurance calculator and enter the exact figures.