Price: $19.95

Document provided by...: www.spreadsheet123.com; (Learn more...); Spreadsheet123 is your ultimate guide to the world of Excel. Every template that you could need for business, real estate, budgeting, personal and corporate finance can be found on this site. In addition, there are Excel calculators, tutorials and links. Visit www.spreadsheet123.com for all of your spreadsheet needs.

About This Document: 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 paycheque.

Budget section of this template helps to make predictions of payable salary for each department individual