spreedsheet 1
Ely0817
Payroll.xlsxDocumentation
| Irene's Scrapbooking World | ||
| Payroll Information | ||
| Created by: | Irene Watson | |
| On: | 2-Feb | |
| Last Updated by: | ||
| On: | ||
| Purpose of workbook: | To compile payroll data to be used by Wipson & Lynn in | |
| calculating and preparing payroll. | ||
| How to use this workbook: | Enter the hours worked and voluntary deductions for each employee | |
| on the Payroll Register worksheet. | ||
| Assumptions: | If any of the base assumptions change regarding tax status, allowances, health | |
| plan choice, etc., unprotect the worksheet and update the relevant data. | ||
| Tax status | Valid status: Married, Single. Include head of household and Divorced under single | |
| Allowances | Any whole number greater than or equal to 0 | |
| Insurance plans | Valid plans listed in cells Payroll register L22:24 - Single, Family or none | |
| Contribute to 401K | Value TRUE listed if person is contributing to 401K - contribution rate given in cell H21 | |
| Rate per Hour | Hourly pay rate in dollars | |
| Overtime Rate | Overtime is assumed to be 150% of an employee's regular pay rate. | |
| Overtime Hours | Overtime is paid on all hours worked in excess of 80 hours per semi-monthly pay period |
Payroll Register
| Irene's Scrapbooking World | ||||||||||||||
| Payroll Worksheet | ||||||||||||||
| For the Pay Period Ended January 29, 2016 | ||||||||||||||
| Name | SSN | Tax Status | Allowances | Insurance Plan | Contribute to 401K | Pay Rate per Hour | Overtime Rate | Hours Worked | Gross Pay | 401K Deduction | Taxable Wages | Health Insurance | Other Deductions | Other Deductions Comments |
| Anderson, Marsha | 501-85-7894 | Married | 2 | Family | TRUE | 17.50 | 26.25 | 92.00 | 1,715.00 | 64.31 | 1,650.69 | 101.20 | 15.00 | United Way |
| Campbell, Titus | 502-76-7891 | Married | 4 | Family | TRUE | 25.00 | 37.50 | 80.00 | 3,000.00 | - 0 | 3,000.00 | 101.20 | ||
| Franks, Alice | 473-75-7789 | Single | 1 | Single | FALSE | 19.50 | 29.25 | 80.00 | 2,340.00 | - 0 | 2,340.00 | 52.75 | ||
| Hansen, Belinda | 472-85-1237 | Maried | 3 | Family | TRUE | 22.50 | 33.75 | 72.00 | 2,430.00 | - 0 | 2,430.00 | 101.20 | ||
| Jackson, Thomas | 471-99-4587 | Single | 1 | Single | TRUE | 25.00 | 37.50 | 87.50 | 2,281.25 | - 0 | 2,281.25 | 52.75 | ||
| Limesand, Edna | 991-87-7789 | Single | 2 | No | TRUE | 17.25 | 8.63 | 40.00 | 345.00 | - 0 | 345.00 | ERROR:#N/A | ||
| Petters, Sally | 501-45-1298 | Divorced | 2 | FAMLY | FALSE | 41.50 | 62.25 | 60.00 | 3,735.00 | - 0 | 3,735.00 | ERROR:#N/A | ||
| Richardson, Denise | 502-23-8989 | Single | 1 | Single | TRUE | 13.00 | 19.50 | 80.00 | 1,560.00 | - 0 | 1,560.00 | 52.75 | 50.00 | Court-ordered child support |
| Watson, Irene | 472-19-6547 | Married | 4 | Family | TRUE | 21.50 | 32.25 | 102.50 | 2,445.63 | - 0 | 2,445.63 | 101.20 | 50.00 | United Way |
| Totals | ||||||||||||||
| Valid Withholding Tax Statuses: | 401K Deduction Percentage: | Health Insurance Plan Options: | ||||||||||||
| Single Debra Gross: Irene:This status includes head-of-household and divorced. | 3.75% | Plan Type | Deduction per Pay Period | |||||||||||
| Married | Family | $101.20 | ||||||||||||
| Single | $52.75 | |||||||||||||
| None | $0.00 |
