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.
Preview Company Payroll Template on DocStoc
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 individually. It also helps compare
the variances to the actual salary paid, last year figures and revenue.
HR Dashboards collects all financial data and creates a simple
and easy to read and analyze dashboards.
The unlocked version of our Payroll Template can be customized to meet the requirements of you business. Current settings will allow
you to add up to 45 employees on your payroll list, but if you
need more than this, than you can simply add more rows to your list or Contact Us if you need any help
doing this. (Free version of this spreadsheet is set for 5 employees only and comes with limited customization abilities)
You can download and use our free company employee payroll template for your personal or company use, but with limited customization abilities and for only 5
Read our Limitation of Use Policy that are applicable to both free and unlocked version of this Payroll Template.
You can also download Employee Payroll Template that works in OpenOffice.org Calc.
>> Download Now
Version: PRT EX 1.0
File Type: .xls
Size: ~566.0 KB
2002(XP), 2003, 2007
Free for personal use
License: View EULA
Buy unlocked version of Company Employee Payroll Template risk free with 60 day full money-back guaranty!
Cost: $24.95USD Download will start after your payment is processed.
Make sure your
browser is pop-up enabled.
How to use Employee Payroll Template?
1. Go to the Employee Information tab of the workbook and enter all necessary information for each of your employees.
(Note: Do not enter anything in to the green columns.)
Name - Name of your employee.
Hourly Rate - The rate that your have agreed to pay to your employee per one our of the working time.
Tax Status, Federal Allowance, State Tax, Federal Income Tax, Social Security Tax,
Medicare Tax - Full information about employee tax can be found on Wikipedia - Employee Taxation in US.
Insurance Deductions - this is usually related to the live insurance or any other insurance that is deducted automatically from your salary.
Other Deductions - section is for any deductions not related to tax or insurance.
2. Payroll Calculator - workbook copies all necessary information about each of your employees from Employee Information list
and awaits for you to input your employee worked, vacation, sick and overtime hours. This information can be copied from the employee timesheet.
3. Individual Pay Stubs or in other words also known as Payslips is the only document that you need to print out and send to your employees with every paycheque.
Links to other Timesheet and Payroll related sites.
Excel Payroll and Timesheet Templates by Spreadsheet123.com
www.office.microsoft.com - Search Microsoft Office Online for more free Payroll Templates.
Share Our Payroll Template
If you have a web site, blog related to Excel, Business Software Recourses or you wish to suggest this payroll template to others, please link to
this page to spread the word about our free Payroll Template for Excel. Please copy and paste the HTML code below.