Company Employee Payroll List

By Spreadsheet123 Free to try

Developer's Description

Employee Payroll Calculator Template for Microsoft Excel with HR Dashboards that is designed for small business. As the owner of the small business myself, I needed to have a Payroll System to pay my employees and at the same time be able to analyze financial data. Of course before I came up with the idea of making this payroll calculator, I have created dozens of individual timesheet templates as well as used few of well known payroll templates from Microsoft, which was a big help, but it also was taking a long time to calculate all of it individually. I needed something much more powerful than just a simple timesheet or a payroll to allow myself to safe some time and money. I've decided to use the simple employee list spreadsheet, that I was using to keep track of the employees, their tax deduction and hourly rates, as a template to create a Simple Payroll System. The payroll template, that is available for you to download contains five parts: Employee List, Payroll Calculator, Individual Payslips, which can be printed on the standard printer, HR Dashboards and Salary and Revenue Forecast. This worksheet works well together with our weekly timesheet template and timesheet with breaks template. Company Employee Payroll Template is fully customizable and easy to use in any business. Employee list contains all relevant information about each of your employee including employee ID, hourly rates, tax status, federal tax allowance, state tax, medicare tax, social security tax and any other deductions, department that can be assigned individually. Payroll Calculator contains all data copied from Employee List and only awaits for user to enter hours (from Timesheet) in to the fields to calculate employees weekly or monthly salary. Individual Pay stubs section of the workbook helps you to print a pay stubs for your employees to include it with their pay cheque. Budget section of this template helps to make predictions of payable salary for each department individually. It also helps compare the variances to the actual salary paid, last year figures and revenue. HR Dashboards collect all financial data and creates a simple and easy to read and analyze dashboards.

Full Specifications

What's new in version 1.0


Date Added October 15, 2009
Version 1.0

Operating Systems

Additional Requirements Microsoft Excel


Total Downloads 13,285
Downloads Last Week 0
Report Software

Related Software

Microsoft Excel logo

Microsoft Excel

Microsoft Excel

QI Macros SPC Software for Excel

Free to try
QI Macros SPC Software for Excel
Microsoft Excel 2007 logo

Microsoft Excel 2007

Microsoft Excel 2007
Free Excel Password Recovery logo

Free Excel Password Recovery

Free Excel Password Recovery

Get the best price on everything

Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.