How to do payroll in excel

Updated April 17, 2017

Many factors are involved in calculating payroll for employees such as wages, different types of tax and insurance deductions. It can become tedious to organise and perform calculations on this data. Microsoft Excel offers templates to keep track of payroll and performs some calculations for you. Using these templates can save time and keep the information organised and easily accessible. Learn how to use a Microsoft Excel template that tracks and calculates payroll based on the input of several fields.

Open a new workbook in Microsoft Excel. Click Office > New.

Type "Payroll" in the "Search Microsoft Office Online for a Template" text field. Double click the "Payroll Calculator" template.

Enter information under the following fields: Name, Hourly Wage, Tax Status, Federal Allowance from W-4, State Tax Percentage, Medicare Tax Percentage, Insurance Deduction and Other Regular Deduction in U.S. Dollars. The Total Taxes Withheld field will be populated automatically, based on the tax data you entered. The Total Regular Deductions field will also be calculated, based on the total of the data you entered for insurance and other regular deductions.

Things You'll Need

  • Microsoft Excel 2007
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Shreya Mehta graduated from the University of Massachusetts with a Bachelors degree in business administration with a double concentration in finance and MIS. She attended Bentley College to obtain a MBA in finance and Masters in IT. She has been working for a financial software company for the past three years as an associate content manager.