How to Calculate Payroll on Spreadsheets

Jupiterimages/ Images

If you are responsible for payroll for your organization or company, you will find that a spreadsheet is a valuable tool to calculate hours worked, pay rates, deductions and taxes for all of the employees in the company. For Microsoft Excel, Microsoft has a pre-designed template that you can use for this. For other spreadsheet applications, you can still open the spreadsheet in the other program, such as Microsoft Works and Lotus. No matter what you use a s spreadsheet application, the payroll spreadsheet is a quick and simple way to keep up with payroll.

With Microsoft Excel

Go to the Microsoft Office website.

Download the Payroll Calculator template.

Double-click on the downloaded template to have it open in Microsoft Excel.

Fill in the necessary cells for the employee information and current tax rates. Do not change any of the shaded cells because they are calculated cells, meaning that they have functions included in them to automatically calculate payroll taxes and amounts.

Click on the "Payroll calculator" worksheet tab at the bottom of the screen. Fill in the information about the employees' hours worked, overtime hours, overtime rate, vacation hours and sick time. Do not change the shaded areas. As you enter the information in the other areas, you will see the numbers in the shaded areas change. This means that they contain functions that calculate payroll based on the wage and tax information you already entered.

Open in Other Programs

Open the template in Microsoft Excel.

Click on the "File" tab and then click on "Save As."

Click on the drop-down arrow next to "File Type As" and choose the format for the type of spreadsheet you will be using for this file. Excel supports several spreadsheet applications.

Click the "Save" button to finish converting the template. Close the Excel window and open the other spreadsheet application. Open the spreadsheet you just converted by clicking on "File" and then "Open."