How to Use Microsoft Excel for Payroll

Written by kara page
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Microsoft Excel for Payroll
Microsoft Excel is an ideal program for keeping track of and calculating payroll information. (number background image by kuhar from Fotolia.com)

Excel, one of the programs in the Microsoft Office suite, is widely used by individuals and companies to create spreadsheets, charts and graphs. No matter what type of business you're in, it's important to keep careful track of your payroll information, and Excel is a useful program for this type of organisation. Microsoft offers a free, downloadable payroll template for those with Excel 2003 or later versions. The template simplifies the process of entering your payroll information and performing calculations.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Navigate to the Microsoft Office Payroll Calculator template page (see Resources) and click "Download," then "Accept." Excel will automatically open to the template when the download is complete.

  2. 2

    Fill out the columns with the information according to the headings above each column. The date you enter will include employee names and IDs, hourly wages, state tax percentage, insurance deductions and other relevant tax deduction information. As you enter the data, Excel will automatically calculate the figures in the "Total Taxes Withheld" and "Total Regular Deductions" fields.

  3. 3

    Click "Payroll Calculator," which is near the bottom of the spreadsheet. Enter the requested information about the employees' hours, including overtime, and the calculator will provide you with the total net pay for each employee.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.