Skip to main content
Dawmly

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 free

Next step: Payroll in Dawmly · Net salary calculator · Payroll sheet (30 employees)

What's in the file

How to use the payslip template

  1. Enter the company name, month and employee details at the top.
  2. Fill in earnings (basic, allowances, overtime and bonuses) and absence or advance deductions.
  3. Calculate the employee's social insurance and salary tax in the net salary calculator and type them into their cells.
  4. 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.

Frequently asked questions

Is the payslip template free?

Yes, completely free with no signup. It opens in Microsoft Excel, Google Sheets and LibreOffice Calc.

How is this different from the payroll sheet template?

The payroll sheet holds up to 30 employees in one monthly register. This payslip template formats one employee's earnings and deductions side by side on a single printable page.

Does the payslip compute social insurance and salary tax?

No. Social insurance and salary tax are typed in because they depend on the insurable wage limits and tax brackets. Work them out in the net salary calculator and copy them over.

What formulas does the payslip use?

Plain arithmetic only: Gross pay = basic + allowances + overtime + bonuses, Total deductions = absence and lateness + social insurance + salary tax + advances and other deductions, and Net salary = Gross pay − Total deductions.

Want payslips generated from real attendance? Try the Dawmly attendance app, free for up to 3 employees.

Keep reading