How to Make Payroll in Excel in USA

This wikiHow teaches you how to calculate payroll for employees in the US using Microsoft Excel. Creating a payroll spreadsheet from scratch is an exhausting process, but luckily Microsoft has a payroll template for Excel on both Windows and Mac computers.

Table of Contents

Create payroll

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/92/Prepare-Payrpl-in-Excel-Step-1-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-1-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/92/Prepare-Payrpl-in-Excel-Step-1- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-1-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Open Payrpl Calculator website. Go to https://templates.office.com/en-us/Payrpl-calculator-TM06101177 using your computer’s web browser.

This spreadsheet is a free Excel template from Microsoft.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/99/Prepare-Payrpl-in-Excel-Step-2-Version-3.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/99/Prepare-Payrpl-in-Excel-Step-2- Version-3.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-2-Version-3.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Download . This blue button is near the bottom of the window. The template will begin downloading to your computer.

Depending on your browser, you may need to choose a save location and then click Save first before the file will download.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/03/Prepare-Payrpl-in-Excel-Step-3-Version-3.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/03/Prepare-Payrpl-in-Excel-Step-3- Version-3.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-3-Version-3.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the template. Double-click the downloaded Excel file to open the template in Excel.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a8/Prepare-Payrpl-in-Excel-Step-4-Version-3.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a8/Prepare-Payrpl-in-Excel-Step-4- Version-3.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Enable Editing . This button is located in the yellow bar at the top of the Excel window. The Excel file will be unlocked for you to edit.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8f/Prepare-Payrpl-in-Excel-Step-5-Version-4.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-5-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8f/Prepare-Payrpl-in-Excel-Step-5- Version-4.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-5-Version-4.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Save document. Before you edit the template, press Ctrl + S (Windows) or ⌘ Command + S (Mac), enter a name for the file (eg “Payroll 5.12.2018”) and click Save . This is to ensure that the payroll sheet is automatically saved as a second file. Then you can start calculating the salary.

Enter employee information

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/05/Prepare-Payrpl-in-Excel-Step-6-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-6-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/05/Prepare-Payrpl-in-Excel-Step-6- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-6-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Click Employee information. The title is in the lower left corner of the Excel window. This is to ensure that you are on the Employee Information worksheet.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/39/Prepare-Payrpl-in-Excel-Step-7-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/39/Prepare-Payrpl-in-Excel-Step-7- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-7-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Add employee name. Enter the employee’s name in the first blank box in the “Name” column.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d3/Prepare-Payrpl-in-Excel-Step-8-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-8-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d3/Prepare-Payrpl-in-Excel-Step-8- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter the hourly rate. Enter the amount this employee is paid by the hour in the first blank box of the “Hourly Wage” column.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/11/Prepare-Payrpl-in-Excel-Step-9-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/11/Prepare-Payrpl-in-Excel-Step-9- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter employee tax information. Make sure you have your employee’s tax information, then fill in the box below the following headings:

Tax Status – Tax status. This number (usually “1”) is shown on the employee’s W-2.
Federal Allowance – Federal allowance. This is the number that identifies the employee’s tax bracket and is usually shown on the W-4.
State Tax (Percentage) – Your state’s taxable percentage.
Federal Income Tax (Percentage) – The percentage of federal income tax under the employee tax bracket.
Social Security Tax (Percentage) – Current Social Security tax percentage.
Medicare Tax (Percentage) – The current U.S. government percentage of Medicare taxes on care for seniors over 65.
Total Taxes Withheld (Percentage) – Percentage of total tax withheld. This field will be calculated automatically after you fill in other tax fields.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7c/Prepare-Payrpl-in-Excel-Step-10-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7c/Prepare-Payrpl-in-Excel-Step-10- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Determine employee deductions. This will depend on the employee’s benefits, investments, etc.:

Insurance Deduction (Dplars) – Insurance deductible. This is the dollar amount you keep for insurance.
Other Regular Deduction (Dplars) – Other regular deductions or kickbacks of any money you keep.

Payroll calculation

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/51/Prepare-Payrpl-in-Excel-Step-12-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/51/Prepare-Payrpl-in-Excel-Step-12- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Click the Payrpl calculator tab at the bottom of the page. The sheet will open.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/72/Prepare-Payrpl-in-Excel-Step-13-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/72/Prepare-Payrpl-in-Excel-Step-13- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Find staff. Identify the first employee for whom you entered information on the Employee Information page. Their names will be at the top of this page.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fd/Prepare-Payrpl-in-Excel-Step-14-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fd/Prepare-Payrpl-in-Excel-Step-14- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter the number of working hours. In the “Regular Hours Worked” column, enter the number of hours this employee worked (such as 40 ) during the pay period.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ec/Prepare-Payrpl-in-Excel-Step-15-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ec/Prepare-Payrpl-in-Excel-Step-15- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Add vacation or sick time as needed. If your employees have used vacation or sick time, note the corresponding hours they took off in the “Vacation Hours” or “Sick Hours” columns.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c2/Prepare-Payrpl-in-Excel-Step-16-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c2/Prepare-Payrpl-in-Excel-Step-16- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Enter overtime and rate. If your employees have overtime (for example, over 40 hours per week), enter the number of overtime hours in the “Overtime Hours” column, then enter the overtime rate (in dollars) in the “Overtime” column Rate”.

Overtime pay rates are typically 150 percent higher than the employee’s normal rate (“one and a half times”).

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/db/Prepare-Payrpl-in-Excel-Step-17-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/db/Prepare-Payrpl-in-Excel-Step-17- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-17-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Add deductions (if any) at the end. In the “Other Deduction” column, enter the dollar amount of a deduction that is different from regular deductions.

For example, if the employee took a deduction to purchase equipment, you’ll need to enter the amount here for a one-time payment.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ae/Prepare-Payrpl-in-Excel-Step-18-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ae/Prepare-Payrpl-in-Excel-Step-18- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-18-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Review employee paychecks. The “Net Pay” column will show the employee’s actual amount; If the number seems reasonable, then you’ve calculated the employee’s salary.

You can also check pre-tax amounts in the “Gross Pay” column.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Prepare-Payrpl-in-Excel-Step-19-Version-2.jpg/v4-728px-Prepare-Payrpl- in-Excel-Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Prepare-Payrpl-in-Excel-Step-19- Version-2.jpg/v4-728px-Prepare-Payrpl-in-Excel-Step-19-Version-2.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight” :410,”licensing”:”<div class=”mw-parser-output”></div>”}

Calculating salary for other employees. For each person listed in the “Employee Name” field, you need data to determine their actual wages.

You can check the employee’s payslip in the PAYROLL PAYSTUBS or Individual Paystubs tab at the bottom of the page after the calculation is complete.

Advice

Once you’ve finished calculating a pay period, it’s a good idea to save the sheet before deleting and creating a new payroll.

Warning

Do not delete any preformatted cells (such as cells with pre-formulated formulas) as this will cause the payroll spreadsheet to fail.

Steps

Create payroll

Enter employee information

Payroll calculation

Advice

Warning

Related Posts