Increased employee pay rates, and employees changed their federal income tax withholding amounts, both effective December 16. There were no changes in filing status or withholding allowances. New Federal Income Tax New Pay Rate Withholding Amt. Ray Kramer $3,650.00 semimonthly $408.00 Jim Adams $21.50 per hour $211.00 $70.00 Nancy Ford $17.80 per hour No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. Listed on nurch order Printed and reviewed payroll time record reports (Doc. No. 21) for Ford and Adams for the time period ended December 31 and prepared the payroll for all three employees, including paychecks. Paychecks are considered "Mailed/Given to Outsiders." Time record reports are filed in the "Accounting" file tab. Recall that federal income tax withholding amounts were listed earlier with employee pay rate increases. Document No. 21 Waren Sports Supply Time Record Report Pay Period Ending 12/31/17 ARNINGS SI Employee: ID # Nancy Ford -AR32 DOB DOH 5/22/1984 10/1/2017 DOY 0823 Date of Terminati ation A Out Hous - Soi Tequ mple or pi Monday Tuesday Wednesday Thursday Friday Date 12/18/2017 12/19/2017 12/20/2017 12/21/2017 12/22/2017 B07 8.05 8:02 7:57 8:10 8:00 16:06 16:00 17:10 17:00 17:33 9.00 9.00 10.05 730 Holiday 300 Monday Tuesday Wednesday 15:30 - TE Ove -ds, ay, sloy 12/25/2017 12/26/2017 12/27/2017 12/28/2017 12/29/2017 17:00 Thursday Friday 9:00 7:30 7:45 8.00 8.00 8.35 8.18 1551 25 30 15:56 22 4576 Approved By: Pay Period Total Pay Period Base Hours Overtime 84.70 80.00 4.70 60223 Employee Signature: Document No. 21 te of Termina Waren Sports Supply Time Record Report Pay Period Ending 12/31/17 Jim Adams ***.**.9833 cupation Employee: ID # DOB DOH 10/1/1988 1/16/2013 Gros Pay Hours 9.17 Day Monday Tuesday Wednesday Thursday Friday Date 12/18/2017 12/19/2017 12/20/2017 12/21/2017 12/22/2017 8:02 8:09 8:06 8:00 7:36 Out 17:12 17:00 17:09 17:30 16:30 8.85 9.05 9.50 8.90 Holiday 16:05 Monday Tuesday Wednesday Thursday Friday 12/25/2017 12/26/2017 12/27/2017 12/28/2017 12/29/2017 8:05 9:00 8:00 8:07 16:00 17:12 17:45 8.00 8.00 7.00 9.20 9.63 2015 Approved By: Pay Period Total Pay Period Base Hours Overtime 80.00 7.30 Employee Signature: 121 /2017 12/31/10 Document No1 PAY RATE HISTORY Ray Kramer $3.400.00 $3.500 DO semmily Jim Adams Endine 11 $20.00 $21.00 hour houny RK 10-1 - 110 SS 11100011 Cam i nos Total 010 10- Nancy Ford $17.00 Hire date hourly 10/1/17 114 1105 15 - 170001 1-30- 1 0 50 145 Cum total de 155 00 12-15-17 12-05-17 89000 27500 408 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Ray Kramer Soc. Sec. No. ***** 2376 Home Address 417 Cherry, Chicago, 0912 Phone No. Employed 4/6/06 Date of Termination Date of Birth 2/15/1974 Occupation Manager Phone Employee's Name Nancy Ford Home Address with Employed 10/1/17 Date of Birth n Date o Occupation Date Hours Worked Federal Income Date Period Regular Overtime Ending Paid Hours 0 - 0 1 - 17 Balance Forward Gross Pay FICA 300000 481 450 69300051250 50 Period Rogue Over Ending Paid Hours 10-01-17 Balance Forward -0- 3,500.00 [26775 350000207 12 7 00 ooloo 5355.00 38.500 28 4725 3 8 500 28 4725 7170 000 569 45.00 10-15-17 10-15-01 48.00 10-31 - 1710 - 31-175.000 Cumulative Annual Total 81.00 850,00 16.00 702 0,42 1744 174656 17455 1521 -15-17 10-15-17 - 31-17 10-3 1-17 Cumulative Annual Total - 15-17 11-15-17 - 30 -17 11-30-17 Cumulative Annual Total 350 000 3 500.00 77.00 0.00 20175 26775 589 0 50 38 500 284725 38500 28 4725 847 000 126 34.50 11-15-17 11-15-17 4400 01-30-111-30-17 5200 Cumulative Annual Total 83,00 88400 3387.00 912 1103 3719 76055 805,35 308701 162 25980 26775 38500 28 4725 13 4 1/8" 16800 1526.60 11679 8800 120 350 000 30 15-17 12-15-17 12-15-17 12-15 -17 Increased employee pay rates, and employees changed their federal income tax withholding amounts, both effective December 16. There were no changes in filing status or withholding allowances. New Federal Income Tax New Pay Rate Withholding Amt. Ray Kramer $3,650.00 semimonthly $408.00 Jim Adams $21.50 per hour $211.00 $70.00 Nancy Ford $17.80 per hour No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. Listed on nurch order Printed and reviewed payroll time record reports (Doc. No. 21) for Ford and Adams for the time period ended December 31 and prepared the payroll for all three employees, including paychecks. Paychecks are considered "Mailed/Given to Outsiders." Time record reports are filed in the "Accounting" file tab. Recall that federal income tax withholding amounts were listed earlier with employee pay rate increases. Document No. 21 Waren Sports Supply Time Record Report Pay Period Ending 12/31/17 ARNINGS SI Employee: ID # Nancy Ford -AR32 DOB DOH 5/22/1984 10/1/2017 DOY 0823 Date of Terminati ation A Out Hous - Soi Tequ mple or pi Monday Tuesday Wednesday Thursday Friday Date 12/18/2017 12/19/2017 12/20/2017 12/21/2017 12/22/2017 B07 8.05 8:02 7:57 8:10 8:00 16:06 16:00 17:10 17:00 17:33 9.00 9.00 10.05 730 Holiday 300 Monday Tuesday Wednesday 15:30 - TE Ove -ds, ay, sloy 12/25/2017 12/26/2017 12/27/2017 12/28/2017 12/29/2017 17:00 Thursday Friday 9:00 7:30 7:45 8.00 8.00 8.35 8.18 1551 25 30 15:56 22 4576 Approved By: Pay Period Total Pay Period Base Hours Overtime 84.70 80.00 4.70 60223 Employee Signature: Document No. 21 te of Termina Waren Sports Supply Time Record Report Pay Period Ending 12/31/17 Jim Adams ***.**.9833 cupation Employee: ID # DOB DOH 10/1/1988 1/16/2013 Gros Pay Hours 9.17 Day Monday Tuesday Wednesday Thursday Friday Date 12/18/2017 12/19/2017 12/20/2017 12/21/2017 12/22/2017 8:02 8:09 8:06 8:00 7:36 Out 17:12 17:00 17:09 17:30 16:30 8.85 9.05 9.50 8.90 Holiday 16:05 Monday Tuesday Wednesday Thursday Friday 12/25/2017 12/26/2017 12/27/2017 12/28/2017 12/29/2017 8:05 9:00 8:00 8:07 16:00 17:12 17:45 8.00 8.00 7.00 9.20 9.63 2015 Approved By: Pay Period Total Pay Period Base Hours Overtime 80.00 7.30 Employee Signature: 121 /2017 12/31/10 Document No1 PAY RATE HISTORY Ray Kramer $3.400.00 $3.500 DO semmily Jim Adams Endine 11 $20.00 $21.00 hour houny RK 10-1 - 110 SS 11100011 Cam i nos Total 010 10- Nancy Ford $17.00 Hire date hourly 10/1/17 114 1105 15 - 170001 1-30- 1 0 50 145 Cum total de 155 00 12-15-17 12-05-17 89000 27500 408 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's Name Ray Kramer Soc. Sec. No. ***** 2376 Home Address 417 Cherry, Chicago, 0912 Phone No. Employed 4/6/06 Date of Termination Date of Birth 2/15/1974 Occupation Manager Phone Employee's Name Nancy Ford Home Address with Employed 10/1/17 Date of Birth n Date o Occupation Date Hours Worked Federal Income Date Period Regular Overtime Ending Paid Hours 0 - 0 1 - 17 Balance Forward Gross Pay FICA 300000 481 450 69300051250 50 Period Rogue Over Ending Paid Hours 10-01-17 Balance Forward -0- 3,500.00 [26775 350000207 12 7 00 ooloo 5355.00 38.500 28 4725 3 8 500 28 4725 7170 000 569 45.00 10-15-17 10-15-01 48.00 10-31 - 1710 - 31-175.000 Cumulative Annual Total 81.00 850,00 16.00 702 0,42 1744 174656 17455 1521 -15-17 10-15-17 - 31-17 10-3 1-17 Cumulative Annual Total - 15-17 11-15-17 - 30 -17 11-30-17 Cumulative Annual Total 350 000 3 500.00 77.00 0.00 20175 26775 589 0 50 38 500 284725 38500 28 4725 847 000 126 34.50 11-15-17 11-15-17 4400 01-30-111-30-17 5200 Cumulative Annual Total 83,00 88400 3387.00 912 1103 3719 76055 805,35 308701 162 25980 26775 38500 28 4725 13 4 1/8" 16800 1526.60 11679 8800 120 350 000 30 15-17 12-15-17 12-15-17 12-15 -17