How to Make Payroll in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Excel provides a wide range of applications to its users. It is frequently used for data entry, money management, keeping track of things, and budgeting. Consider a situation where a new company wants to prepare its employee payroll. How will it accomplish its task? Well, to aid his problem, today we will discuss how to make payroll in Excel.

What Is Payroll in Excel?

If we want to make the definition short, payroll is the process of disbursing wages to an organization’s employees. It involves compiling employee lists, recording their salaries and payments, tracking working hours, calculating associated taxes and other expenses, figuring out their benefits and pay, etc. Excel allows us to calculate payroll and periodically check it.

How to Make Payroll in Excel: 4 Easy Steps

Let’s assume we have a dataset, namely “United State Steel Corporation”. You can use any dataset suitable for you.

How to Make Payroll in Excel

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.

Step 1: Prepare the Dataset

The very first step to calculate a company’s payroll is to prepare the dataset with the additional information. Look at the image we have attached below.

  • Here, we want to calculate the payroll for “Michael Scott” for his one week of work.
  • To do so, we have to know the values of working hours, hourly pay, commissions, and the benefits received from the company. We will use those values according to our given dataset.

How to Make Payroll in Excel

Step 2: Calculate Gross Pay

To calculate the gross pay, we will take the necessary information from the dataset given previously.

  • In this case, the employee has worked for the company for one month and will now be paid for every week.
  • So firstly, enter the following formula in cell C10.

Here, C6, C7, and C9 contain the values of Hourly Pay, Working Hours/Week, and Commissions respectively.

  • To see the output, press the Enter button.

Calculate Gross Pay

Step 3: Determine Employer Contributions

Every company offers some benefits to its staff members, such as FICA taxes, retirement, insurance amounts, etc. So, we will sum up those values in terms of “employer contributions”.

  • To begin with, write the following formula in cell C15. Here, we use the SUM function to determine employer contributions.
  • Then press the Enter button to see the output result.

Determine Employer Contributions

Step 4: Calculate the Total Accrued Payroll

This is the final step of our procedure. We have calculated gross pay and employer contributions so far. Now it is time to calculate the total accrued payroll.

  • Put the following formula in the cell.

As you have already understood, we use the SUM function to calculate the total accumulated salary. Here, C10, C15, and C17 cells refer to Gross Pay, Employer Contributions, PTO respectively.

  • Now press Enter to see the output.

Calculate the Total Accrued Payroll

Read More: Payroll Exercises in Excel

How to Make a Payroll System with Payslip in Microsoft Excel

An employee receives a payslip, a piece of paper detailing his earnings and the amount of tax deducted, at the conclusion of each week or month. As our title suggests, we will now discuss with you how to make a payroll system with a payslip.

  • Firstly, Enter the given formula in E5.

Here we multiply Pay/Hour to Working Hours/ Week to calculate the Gross Pay.

  • Press the Enter button as we have done below and see the output.

How to Make a Payroll System with Payslip in Microsoft Excel

  • To get the other value, drag the Fill Handle tool from E5 to E10.

How to Make a Payroll System with Payslip in Microsoft Excel

  • Now to calculate the income tax, we take 15% of Gross Pay that one individual has earned in the given time frame.
  • Enter the given formula in the cell.

Here, E5 refers to Gross Pay.

  • Subsequently, press the Enter button

  • Drag the Fill Handle tool to get the other value.

  • Now to calculate the Net Pay, subtract Net Tax from Gross Pay. We can use the following formula in G5 to accomplish the task.
  • Press the Enter button afterward.

  • Lower the cursor to the C10 cell to use the AutoFill tool.

  • Now it’s time to make a payslip in accordance with our payroll. Here, we will make a payslip for one of the employees named “Dwight Schrute”. To do so, enter the following formula in the E8 cell.

How to Make Payroll in Excel

  • Now calculate the Net Pay by entering the following formula in the C8 cell.

How to Make Payroll in Excel

Things to Remember

  • It is to be mentioned that if an employee does extra work in his workplace, don’t forget to do the necessary calculations on your Excel sheet. Those values will be added to Gross Pay.

Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it yourself.

Do it yourself

Download Practice Workbook

You can download and practice the dataset that we have used to prepare this article.


We hope you grasped the process of how to make payroll in Excel. Further, if you have any queries, feel free to comment below, and we will get back to you soon.

<< Go Back to Payroll | Formula List | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mohammad Shah Miran
Mohammad Shah Miran

Mohammad Shah Miran has a professional background spanning over a year at Softeko. Initially starting as an Excel and VBA writer, he authored more than 50 articles for the ExcelDemy project. Currently, Miran is engaged in the LinuxSimply project as a Linux content developer, completed over 40 articles. His analytical approach extends across various domains, including Excel, VBA, Bash scripting, Linux, data analysis, and Python programming. In his leisure time, Miran enjoys watching movies and series or listening... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF