Skip to main content
Dawmly

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 free

Next step: Payroll in Dawmly · Net salary calculator · Overtime sheet

What's in the file

How to use the payroll sheet

  1. Enter the company name and month, then one employee per row.
  2. Carry overtime over from the overtime sheet and lateness from the lateness deduction calculator.
  3. Work out each employee's social insurance and tax with the net salary calculator and type them in.
  4. 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.

Frequently asked questions

Is the payroll sheet free?

Yes, completely free with no signup. It works in Excel, Google Sheets and LibreOffice.

How is net salary worked out?

Net salary = gross pay (basic + allowances + overtime + bonuses) − total deductions (absence and lateness + social insurance + tax + other deductions).

Does the sheet calculate social insurance and tax?

No, they are typed in because they depend on the insurable wage and the tax brackets. Work them out with the free net salary calculator, then copy them over.

Can I add more pay items?

Yes. Insert a column before gross pay or total deductions and extend the total's formula to include it.

Want this to happen automatically for your team? Try the Dawmly employee attendance software: each employee clocks in from their phone with the time and location, free for up to 3 employees.

Keep reading