All information is based on 2017 tax rates
| Payroll Register | |
| Pay Period | 10/01/2017 | | | | | | | | | | | | |
| Pay Date | 10/04/2017 | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
| | Earnings | Deductions | | | |
| Employee Name | Regular Hours | Regular Rate | Regular Earnings | Overtime Hours | Overtime Rate | Overtime Earnings | Total Earnings | FWT | SWT | Social Security | Medicare | Vol. With. | Check Number | Net Pay | |
| |
| Hough, M | 40 | $ 14.00 | $ 560.00 | 0 | $ 21.00 | $ - | $ 560.00 | | | | | | 4711 | $ 560.00 | |
| Finnegan, W | 40 | $ 18.00 | $ 720.00 | 4 | $ 27.00 | $ 108.00 | $ 828.00 | | | | | | 4712 | $ 828.00 | |
| Jones, S | n/a | n/a | $ 5,038.47 | n/a | n/a | n/a | $ 5,038.47 | | | | | | 4713 | $ 5,038.47 | |
| Stewart, F | n/a | n/a | $ 1,807.69 | n/a | n/a | n/a | $ 1,807.69 | | | | | | 4714 | $ 1,807.69 | |
| | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | |
| Totals: | | | | $ 8,126.16 | | | $ 108.00 | $ 8,234.16 | $ - | $ - | $ - | $ - | $ - | | $ 8,234.16 | |
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | |   |
Earnings Income Tax State Income Tax Security Tax Tax Social $65,500.11 $16,606.46 401(k) Deduction Cont. 1st $4,061.07 $3,825.33 $949.78 50 5949.78 o $0 $949.78 $0 2nd quarter $65,500.11 $16 $3,274.96 $195 3rd quarter$65,500.11 $16,606.46 $3,274.96 $195 Francine Stewart Gross Federal State Social Security Tax Tax Quarter Earnings Income Tax Income Tax 1st 2nd quarter $0 3rd Medicare 401(k) Charitable Deduction Cont. so so $0 so SO $1,807.70 $187.83 $88,58 $112.08 S26.21 S36.15 Note that all tax payments and filings are made on the due date. Based on the data provided here, you vwil complete the following 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion 2. Establish and complete the payroll register for each weekly pay period in the fourth quarter. When of each record calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of November 20, Stacey Jones requests that her federal withholding allowances decrease from two to one (Ampersand, Inc, makes this change). Additionally for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Payroll checks are remitted to the employees in the same order (Hough, Finnegan, Jones, Stewart) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in October is check #4711. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage Earnings Income Tax State Income Tax Security Tax Tax Social $65,500.11 $16,606.46 401(k) Deduction Cont. 1st $4,061.07 $3,825.33 $949.78 50 5949.78 o $0 $949.78 $0 2nd quarter $65,500.11 $16 $3,274.96 $195 3rd quarter$65,500.11 $16,606.46 $3,274.96 $195 Francine Stewart Gross Federal State Social Security Tax Tax Quarter Earnings Income Tax Income Tax 1st 2nd quarter $0 3rd Medicare 401(k) Charitable Deduction Cont. so so $0 so SO $1,807.70 $187.83 $88,58 $112.08 S26.21 S36.15 Note that all tax payments and filings are made on the due date. Based on the data provided here, you vwil complete the following 1. Establish an employee earnings record for each of the company's four employees. Complete the top portion 2. Establish and complete the payroll register for each weekly pay period in the fourth quarter. When of each record calculating federal income tax withholding, use the withholding tables where possible, and refer to the percentage method only when necessary. Note that as of November 20, Stacey Jones requests that her federal withholding allowances decrease from two to one (Ampersand, Inc, makes this change). Additionally for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Payroll checks are remitted to the employees in the same order (Hough, Finnegan, Jones, Stewart) each pay period and are written from a bank account that is used solely for these payments. The first payroll check written in October is check #4711. Note that all charitable contributions are deemed to be made on the final day of each pay period. The following information will be required for the completion of these records for the two employees who are compensated via an hourly wage
