How to Prepare Payroll in Excel
Download the Excel Payroll Calculator template., Extract the Excel Payroll Calculator template., Save a copy of the template to use as your business payroll., Prepare the payroll for your business., Access the payroll, or pay stubs for your...
Step-by-Step Guide
-
Step 1: Download the Excel Payroll Calculator template.
Click on the Microsoft Office link featured in the Sources section of this article to access the download link for the Excel Payroll Calculator template.
Scroll down on the Microsoft Office website and click on the link that reads "download the Payroll Calculator template" within the "Download the template" section.
Click on the green "Download" box located to the right, then click on the "Accept" button after reviewing the Microsoft Service Agreement.
Click on "Save" when the dialog box appears prompting you to download the file.
Navigate to the location or folder on your computer in which you want to save the Payroll Calculator template, then click "Save." The template will be saved to your computer in a compressed format. -
Step 2: Extract the Excel Payroll Calculator template.
Navigate to the location on your computer where you recently saved the Payroll Calculator template, then open the file.
Follow the prompts to extract the template from its compressed format.
When the file opens, it will automatically be opened in Excel.
Depending on the features and version of your computer's operating system, you may be prompted to click "Extract," or to use a utility feature such as Winzip to extract the template. , Point to "File" in your Excel toolbar, then select "Save As" to turn a copy of the template into a payroll workbook for your business.
Navigate to the folder or location on your computer where you want to access your payroll file in the future, and enter a name for your workbook.
Click on "Save" to finish creating your payroll workbook. , Your workbook should still be open within Excel.
Complete the "Employee Information" worksheet.
By default, this worksheet will already be open on your screen.
You will be prompted to enter the names of your employees, their pay rate, and their tax information such as withholding and deductible amounts.
Complete the "Payroll Calculator" worksheet.
To access this worksheet, click on the "Payroll Calculator" tab on the bottom of your Excel workbook session.
You will be prompted for specific time sheet information; such as the hours your employees have worked, the amount of overtime worked, and the amount of vacation hours and sick leave. , Click on the "Individual Pay Stubs" tab located at the bottom of your payroll workbook next to the "Payroll Calculator" tab.
This worksheet contains formulas and functions that extract the data you previously entered and will display this data in the form of pay stubs, or net pay, for each of your employees. -
Step 3: Save a copy of the template to use as your business payroll.
-
Step 4: Prepare the payroll for your business.
-
Step 5: Access the payroll
-
Step 6: or pay stubs for your employees.
Detailed Guide
Click on the Microsoft Office link featured in the Sources section of this article to access the download link for the Excel Payroll Calculator template.
Scroll down on the Microsoft Office website and click on the link that reads "download the Payroll Calculator template" within the "Download the template" section.
Click on the green "Download" box located to the right, then click on the "Accept" button after reviewing the Microsoft Service Agreement.
Click on "Save" when the dialog box appears prompting you to download the file.
Navigate to the location or folder on your computer in which you want to save the Payroll Calculator template, then click "Save." The template will be saved to your computer in a compressed format.
Navigate to the location on your computer where you recently saved the Payroll Calculator template, then open the file.
Follow the prompts to extract the template from its compressed format.
When the file opens, it will automatically be opened in Excel.
Depending on the features and version of your computer's operating system, you may be prompted to click "Extract," or to use a utility feature such as Winzip to extract the template. , Point to "File" in your Excel toolbar, then select "Save As" to turn a copy of the template into a payroll workbook for your business.
Navigate to the folder or location on your computer where you want to access your payroll file in the future, and enter a name for your workbook.
Click on "Save" to finish creating your payroll workbook. , Your workbook should still be open within Excel.
Complete the "Employee Information" worksheet.
By default, this worksheet will already be open on your screen.
You will be prompted to enter the names of your employees, their pay rate, and their tax information such as withholding and deductible amounts.
Complete the "Payroll Calculator" worksheet.
To access this worksheet, click on the "Payroll Calculator" tab on the bottom of your Excel workbook session.
You will be prompted for specific time sheet information; such as the hours your employees have worked, the amount of overtime worked, and the amount of vacation hours and sick leave. , Click on the "Individual Pay Stubs" tab located at the bottom of your payroll workbook next to the "Payroll Calculator" tab.
This worksheet contains formulas and functions that extract the data you previously entered and will display this data in the form of pay stubs, or net pay, for each of your employees.
About the Author
Elizabeth Morgan
Experienced content creator specializing in pet care guides and tutorials.
Rate This Guide
How helpful was this guide? Click to rate: