Company Employee Payroll Calculator Template with HR Dashboards for Excel

Document Sample
Company Employee Payroll Calculator Template with HR Dashboards for Excel Powered By Docstoc
					Your Company Name/Logo                                                                                                                                        Company Employee Payroll List
                                                                                                                                                       http://www.spreadsheet123.com/ExcelTemplates/excel-payroll.html

                                                  Federal                    Federal Income Tax                                      Total Taxes    Insurance    Other Regular   Total Regular Deductions
                              Hourly    Tax                   State Tax                             Social Security   Medicare Tax
Employee ID       Name                          Allowance                   (Percentage based on                                       Withheld     Deduction     Deduction        (Excluding taxes, in       Department
                               Wage    Status                (Percentage)                          Tax (Percentage)   (Percentage)
                                                (From W-4)                    Federal Allowance)                                     (Percentage)    (Dollars)     (Dollars)              dollars)

    1          Adam Jones     $10.00     1          4           2.30%             28.00%                6.30%            1.45%         38.05%        $20.00         $40.00                $60.00              Accounting
    2          Nick Brown     $20.00     1          4           2.30%             28.00%                6.30%            1.45%         38.05%        $17.00         $40.00                $57.00                 R&D
    3          Benny Erwin    $12.00     1          4           2.30%             28.00%                6.30%            1.45%         38.05%        $14.00         $30.00                $44.00            Human Resources
    4                                                                                                                                   0.00%                                              $0.00
    5                                                                                                                                   0.00%                                              $0.00
    6                                                                                                                                   0.00%                                              $0.00
    7                                                                                                                                   0.00%                                              $0.00
    8                                                                                                                                   0.00%                                              $0.00
    9                                                                                                                                   0.00%                                              $0.00
    10                                                                                                                                  0.00%                                              $0.00
    11                                                                                                                                  0.00%                                              $0.00
    12                                                                                                                                  0.00%                                              $0.00
    13                                                                                                                                  0.00%                                              $0.00
    14                                                                                                                                  0.00%                                              $0.00
    15                                                                                                                                  0.00%                                              $0.00
    16                                                                                                                                  0.00%                                              $0.00
    17                                                                                                                                  0.00%                                              $0.00
    18                                                                                                                                  0.00%                                              $0.00
    19                                                                                                                                  0.00%                                              $0.00
    20                                                                                                                                  0.00%                                              $0.00
    21                                                                                                                                  0.00%                                              $0.00
    22                                                                                                                                  0.00%                                              $0.00
    23                                                                                                                                  0.00%                                              $0.00
    24                                                                                                                                  0.00%                                              $0.00
    25                                                                                                                                  0.00%                                              $0.00
    26                                                                                                                                  0.00%                                              $0.00
    27                                                                                                                                  0.00%                                              $0.00
    28                                                                                                                                  0.00%                                              $0.00
    29                                                                                                                                  0.00%                                              $0.00
    30                                                                                                                                  0.00%                                              $0.00
    31                                                                                                                                  0.00%                                              $0.00
    32                                                                                                                                  0.00%                                              $0.00
    33                                                                                                                                  0.00%                                              $0.00
    34                                                                                                                                  0.00%                                              $0.00
    35                                                                                                                                  0.00%                                              $0.00
    36                                                                                                                                  0.00%                                              $0.00
    37                                                                                                                                  0.00%                                              $0.00
    38                                                                                                                                  0.00%                                              $0.00
    39                                                                                                                                  0.00%                                              $0.00
    40                                                                                                                                  0.00%                                              $0.00
    41                                                                                                                                  0.00%                                              $0.00
    42                                                                                                                                  0.00%                                              $0.00
    43                                                                                                                                  0.00%                                              $0.00
    44                                                                                                                                  0.00%                                              $0.00
    45                                                                                                                                  0.00%                                              $0.00




         © 2009 Spreadsheet123.com                                                                                                                                 Company Payroll by Spreadsheet123.com
       Your Company Name/Logo                                                                                                          Payroll Calculator
                                                                                                         http://www.spreadsheet123.com/ExcelTemplates/excel-payroll.html

                                                                                                                                           Period Ending: 09/30/2009

                                         Regular      Vacation                Overtime                                              Taxes and      Other
       Employee ID     Employee Name                             Sick Hours              Overtime Rate   Bonus       Gross Pay                                Net Pay
                                       Hours Worked    Hours                   Hours                                                Deductions   Deduction

           1            Adam Jones          40           8           8           10         $15.00       $50.00       $760.00        $349.18      $20.00      $390.82
           2            Nick Brown          40                                   5          $18.00                    $890.00        $395.65      $20.00      $474.36
           3            Benny Erwin         40                                                                        $480.00        $226.64      $15.00      $238.36
           4                                                                                                           $0.00          $0.00                    $0.00
           5                                                                                                           $0.00          $0.00                    $0.00
           6                                                                                                           $0.00          $0.00                    $0.00
           7                                                                                                           $0.00          $0.00                    $0.00
           8                                                                                                           $0.00          $0.00                    $0.00
           9                                                                                                           $0.00          $0.00                    $0.00
           10                                                                                                          $0.00          $0.00                    $0.00
           11                                                                                                          $0.00          $0.00                    $0.00
           12                                                                                                          $0.00          $0.00                    $0.00
           13                                                                                                          $0.00          $0.00                    $0.00
           14                                                                                                          $0.00          $0.00                    $0.00
           15                                                                                                          $0.00          $0.00                    $0.00
           16                                                                                                          $0.00          $0.00                    $0.00
           17                                                                                                          $0.00          $0.00                    $0.00
           18                                                                                                          $0.00          $0.00                    $0.00
           19                                                                                                          $0.00          $0.00                    $0.00
           20                                                                                                          $0.00          $0.00                    $0.00
           21                                                                                                          $0.00          $0.00                    $0.00
           22                                                                                                          $0.00          $0.00                    $0.00
           23                                                                                                          $0.00          $0.00                    $0.00
           24                                                                                                          $0.00          $0.00                    $0.00
           25                                                                                                          $0.00          $0.00                    $0.00
           26                                                                                                          $0.00          $0.00                    $0.00
           27                                                                                                          $0.00          $0.00                    $0.00
           28                                                                                                          $0.00          $0.00                    $0.00
           29                                                                                                          $0.00          $0.00                    $0.00
           30                                                                                                          $0.00          $0.00                    $0.00
           31                                                                                                          $0.00          $0.00                    $0.00
           32                                                                                                          $0.00          $0.00                    $0.00
           33                                                                                                          $0.00          $0.00                    $0.00
           34                                                                                                          $0.00          $0.00                    $0.00
           35                                                                                                          $0.00          $0.00                    $0.00
           36                                                                                                          $0.00          $0.00                    $0.00
           37                                                                                                          $0.00          $0.00                    $0.00
           38                                                                                                          $0.00          $0.00                    $0.00
           39                                                                                                          $0.00          $0.00                    $0.00
           40                                                                                                          $0.00          $0.00                    $0.00
           41                                                                                                          $0.00          $0.00                    $0.00
           42                                                                                                          $0.00          $0.00                    $0.00
           43                                                                                                          $0.00          $0.00                    $0.00
           44                                                                                                          $0.00          $0.00                    $0.00
           45                                                                                                          $0.00          $0.00                    $0.00

© 2009 Spreadsheet123.com                                                                                                               Company Payroll by Spreadsheet123.com
   [Company Name]
  Employee Name                                              Adam Jones                                        Regular Hours
  Department                                                  Accounting                                       Vacation
  Salary                                                         $760.00
  Regular Hours                                                  $400.00                                       Sick Hours
  Vacation                                                        $80.00                                       Overtime
  Sick Hours                                                      $80.00
                                                                                                               Bonus
  Overtime                                                       $150.00
  Bonus                                                           $50.00


    Period:                   09/30/2009                                             Employee ID          1

    Tax Status                1            Federal Allowance (From W-4)    4         Hours Worked         40
    Hourly Rate               $10.00       Overtime Rate                   $15.00    Sick Hours           8
    Social Security Tax       $47.88       Federal Income Tax              $212.80   Vacation Hours       8
    Medicare Tax              $11.02       State Tax                       $17.48    Overtime Hours       10
    Insurance Deduction       $20.00       Other Regular Deduction         $40.00    Gross Pay            $760.00
    Total Taxes and Regular                                                          Total Taxes and
                              $349.18      Other Deduction                 $20.00                         $369.18
    Deductions                                                                       Deductions

                                                                                     Bonus                $50.00

                                                                                     Net Pay              $390.82




© 2009 Spreadsheet123.com                                                                Company Payroll by Spreadsheet123.com
                                                                                                     Salary & Revenue Forecast
                                                                              Variance                                        Average Salary
                    Current Month                     Actual Paid                                     Number of
  Department        Salary Forecast
                                      Last Year
                                                        Salary
                                                                      vs. Budget     vs. Last Year
                                                                                                      Employees
                                                                                                                          Budgeted         Actual

Accounting                $3,600.00       $3,200.00         $760.00     -$2,840.00      -$2,440.00        1                 $3,600.00          $760.00
Administration            $2,350.00       $2,420.00           $0.00     -$2,350.00      -$2,420.00        0
Customer Support          $5,000.00       $4,780.00           $0.00     -$5,000.00      -$4,780.00        0
Finance                   $4,500.00       $4,520.00           $0.00     -$4,500.00      -$4,520.00        0
Human Resources           $2,000.00       $1,800.00         $480.00     -$1,520.00      -$1,320.00        1                 $2,000.00          $480.00
IT                        $1,200.00       $1,100.00           $0.00     -$1,200.00      -$1,100.00        0
Marketing                 $1,900.00       $1,950.00           $0.00     -$1,900.00      -$1,950.00        0
R&D                       $3,000.00       $2,970.00         $890.00     -$2,110.00      -$2,080.00        1                 $3,000.00          $890.00
Sales                     $2,100.00       $2,135.00           $0.00     -$2,100.00      -$2,135.00        0
Totals                   $25,650.00      $24,875.00       $2,130.00    -$23,520.00     -$22,745.00        3                 $8,550.00          $710.00



                               Revenue                                          Salary
                                                                                    vs. Forecasted    vs. Actual
                      Forecasted         Actual        Budgeted         Actual
                                                                                       Revenue         Revenue
                      $100,000.00     $55,000.00      $25,650.00      $2,130.00         25.65%          3.87%




© 2009 Spreadsheet123.com                                                                                          Company Payroll by Spreadsheet123.com
                          Forecasted vs. Actual Salary                                                                        Payroll Breakdown
    $5,000.00
    $4,500.00                                                                                                                    Sales
    $4,000.00                                                                                                                     R&D
    $3,500.00
    $3,000.00                                                                                                               Marketing
    $2,500.00                                                                                                                        IT
    $2,000.00                                                                                                        Human Resources
    $1,500.00
    $1,000.00                                                                                                                 Finance
      $500.00                                                                                                        Customer Support
        $0.00                                                                                                           Administration
                                                                                                                           Accounting

                                                                                                                                       $0.00    $500.00 $1,000.00

                Current Month Salary Forecast       Last Year         Actual Paid Salary                   Regular Hours          Vacation           Sick Pay     Overtime    Bonus



                                   Employee Count                                                                         Number of Employees
    $25.00-$30.00                                                                                            Sales
                                                                                                             R&D
    $20.00-$25.00                                                                                       Marketing

    $15.00-$20.00                                                                                               IT
                                                                                                  Human Resources
    $10.00-$15.00                                                                                         Finance

     $5.00-$10.00                                                                                Customer Support
                                                                                                    Administration
           <$5.00                                                                                      Accounting

                     0             0.5          1               1.5               2        2.5                       0           0.2           0.4          0.6       0.8      1        1.2




                                                                                    Salary Distribution
    $1,000.00
     $900.00
     $800.00
     $700.00
     $600.00
     $500.00
     $400.00
     $300.00
     $200.00
     $100.00
       $0.00




© 2009 Spreadsheet123.com                                                                                                                                               Company Payroll by Spreadsheet123.com
                       Total Growth    Regular                                           Number of      Average Total Sick Avarage Sick
   Department             Salary        Hours
                                                 Vacation Sick Pay Overtime   Bonus
                                                                                         Employees       Salary   Days         Days
Accounting                   $760.00     $400.00   $80.00    $80.00 $150.00    $50.00                 1 $760.00          1             1
Administration                 $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0
Customer Support               $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0
Finance                        $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0
Human Resources              $480.00     $480.00    $0.00     $0.00   $0.00     $0.00                 1 $480.00          0             0
IT                             $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0
Marketing                      $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0
R&D                          $890.00     $800.00    $0.00     $0.00  $90.00     $0.00                 1 $890.00          0             0
Sales                          $0.00       $0.00    $0.00     $0.00   $0.00     $0.00                 0                  0

                                                                                                      Employee
                                                                                         Salary P/H
                                                                                                       Count
                                                             $0.00    $5.00     0       <$5.00               0
                                                             $5.00   $10.00     0       $5.00-$10.00         0
                                                            $10.00   $15.00     2       $10.00-$15.00        2
                                                            $15.00   $20.00     2       $15.00-$20.00        0
                                                            $20.00   $25.00     3       $20.00-$25.00        1
                                                            $25.00   $30.00     3       $25.00-$30.00        0




© 2009 Spreadsheet123.com                                                                                      Company Payroll by Spreadsheet123.com
                   END-USER LICENSE AGREEMENT
                                                                                              For more timesheet templates
                                                                                               visit: Spreadsheet123.com


                                                                                  © 2009 Spreadsheet123.com.All rights reserved
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that
covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com.

By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the terms
of this EULA.

TEMPLATES LICENSE

This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual
property laws and treaties. Each TEMPLATE is licensed, not sold.

1. GRANT OF LICENSE.
This EULA grants you the right to download the TEMPLATES free of charge for personal use or for your company use.
You may customize this Payroll Template with you personal or company information and use it for your business
requirements and with your employees but you may not remove or alter any logo, trademark, copyright, hyperlinks,
disclaimers, terms of use or other proprietary notices within the TEMPLATES.
You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value
without written permission of SPREADSHEET123.COM

2. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the
terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.

3. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS
ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED
 “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL
WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED
WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE
AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,
INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS
OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS

4. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential
damages, so the above limitation may not apply to you.




   © 2009 Spreadsheet123.com                                                               Company Payroll by Spreadsheet123.com

				
DOCUMENT INFO
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 paycheque. Budget section of this template helps to make predictions of payable salary for each department individual
BUY THIS DOCUMENT NOW PRICE: $24.95 100% MONEY BACK GUARANTEED
PARTNER Spreadsheet123 Ltd
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.