Payroll Template Excel - Free Calculator
Originally published: 03/06/2019 13:19
Last version published: 22/05/2020 10:11
Publication number: ELQ-22760-2
View all versions & Certificate

Payroll Template Excel - Free Calculator

An Excel Payroll Template calculate the cost associated to the operational implication of your team..

How many employees will make up your team? How much will you pay them? Go set up your headcount and calculate their monthly wages.

Free Payroll Template Excel contains the placeholder list of 30 line items.

A placeholder can be a person, or position, or a group of people. Each row specifies their hire and fire dates, annual salary and Full-Time Equivalent count.

Besides, there are also annual salary raise, monthly bonuses and tax rate.

No worries, it works really simple.

For example, you hire a waiter.
They start working right on the restaurant opening date and are to work long-term. No need for firing, so you choose the last date from the list. Let their annual salary be 37000$.

For the first year, let’s assume you will need 2 waiters.

Then during the second year, you may need 3, a year after you will need four.

Annual salary is raised by 5% each year, always starting from the prior year. Add monthly bonus may if it makes sense for you. On top of the salary and bonus, a tax is applied. Let’s assume the tax rate is 10%.

Or, you may hire him as a Part-time employee. In this case, you should enter the hourly rate and the estimated hours per average month.

Having filled the table, you can notice changes in annual salary right in this tab.

Congrats! You have learned how to calculate wages and attend to every small detail in the process.

This Best Practice includes
1 Free Payroll Template Excel

Henry Sheykin offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Michael Xu52(last updated: 19/04/2021 05:56)
  • Ramvir Kumar(last updated: 24/07/2020 15:52)
  • Jordan Karadsheh, MBA(last updated: 23/06/2020 01:45)
    Thumb up!
    I appreciate the time an effort that Herry has taken in this sheet! great work actually and solid.
  • Rayan(last updated: 23/03/2020 11:43)
  • OEUNGMAO(last updated: 12/03/2020 14:16)
    It is good
  • LeonM(last updated: 27/01/2020 10:23)
    Delivers a great result.
    Awesome tool to set up a financial model for a startup. Fast, easy and transparent delivers a great result.
  • jacklg(last updated: 02/11/2019 00:15)
  • Jamal Khan(last updated: 15/08/2019 13:19)
    Hire dates are not working. E.g. If I want to hire CEO in 2020, his salary in 2019 still shows up

More Best Practices from Henry Sheykin

See all

Any questions on Payroll Template Excel - Free Calculator?

The user community and author are here to help. Go ahead!

4.4 / 5 (8 votes)

please wait...