I need the employee earning subsidairy ledger updated for each of the employees. I posted a picture of the format for each. (please anser in the format I gave)

December NO 20 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,700.00 semimonthly $415.00 Jim Adams $22.50 per hour $233.00 Nancy Ford $18.20 per hour $ 74.00 PL No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. EMPLOYEE EARNINGS SUBSIDIARY LEDCT Soc. Sec. No. Phone No. ***.**.2376 781-3565 Employee's Name Ray Kramer Home Address 417 Cherry, Chicago, 60912 Employed 4/6/06 Date of Termination Date of Birth 2/15/1974 Occupation Manager Date Hours Worked Period Regular Overtime Gross Ending Paid Hours Hours Pay 10-01-17 Balance Forward 630 00 00 481950 10-05-17 00 -15-17 3 500 00 10-31-17 10-30-17 350 000 Cumulative Annual T 17 00 00 00 Federal Income Tax 693000 5125050 26775 26775 51355.00 38.500 284125 38500 28 4125 770 000 569 45.00 01-05-17 01-15-17 01-30-17 11-30-17 Cumulative Annual Total 350000 350 000 7710 00 00 26775 38500 284125 26775 38500 284125 518.9.0.5081470.00_6263450 12-15-17 12-15-17 3 500 002677538500 28 4125 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's N vee's Name Jim Adams Address 2522 Longfello Soc. Sec. No. Longfellow, Chicago 60823 Date of Termination Occupation Accounting Clerk Home Addr employed_1/16/13 e of Birth 10/1/1988 Phone No. ***_**_9833 351-5874 Date of Birth Date Hours Worked Period Regular Overtime Ending Gross Pay 10-01-17 Federal Income Tax 31027 13 51 10 10-15-17 10-31-17 Paid Hours Hour 17 Balance Forward 2832 62 432000 2987511 115-1110-05-17 8 000 1-1710-31 -17 185955 9.00 14226 191.00 152029 2275 88 Cumulative Annual Total 4 7411 29000 1810T 3.148.99 4.80 8.00 332 06.11 15-17 01-15-17 8 800 12170 224805 171.97 K111-30 -17 8800 1430229 845075.83 284.00 1192.08 29600 182662 Cumulative Annual Total 3496795388.00 36824.87 825 EL 7 12-15 -17 8800 006022134016932 27500 176908 Nancy Ford lovee's Name 101 ***.**-4832 351-5251 Home Address Employed Date of Birth 10/1/17 5/22/1984 Soc. Sec. No. ss1018 Whittier, Chicago 60823 Date of Termination Phone No. Occupation Clerk Hours Worked Regular Overtime Gross Paid Hours Hours FICA 1-o- -0- Date Period Federal Income Ta Net Pay Pay Ending 1-17 Balance Forward -0- -0- 02 10-05-17 10-05-17 48.00 10-31-17 10 - 31 - 175 000 Cumulative Annual Total 8 16,00 850.00 1666.00 6242 6503 127145 74656 174.55 152.1111 11-15-17 11-05-17 4 900 11-30-17 11-30-17 5200 Cumulative Annual Total 833 00 88400 3/38300 16373 6762 25.8.80 160 55 1 103 8 05 35 3719 1308701 12-15-17 12 - 15 - 17 8 800 120 1526 6011679 168.00 13 4 1 81 December NO 20 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,700.00 semimonthly $415.00 Jim Adams $22.50 per hour $233.00 Nancy Ford $18.20 per hour $ 74.00 PL No accounting entries are necessary, but you must update the pay rate history information in the Employee Earnings Subsidiary Ledger. EMPLOYEE EARNINGS SUBSIDIARY LEDCT Soc. Sec. No. Phone No. ***.**.2376 781-3565 Employee's Name Ray Kramer Home Address 417 Cherry, Chicago, 60912 Employed 4/6/06 Date of Termination Date of Birth 2/15/1974 Occupation Manager Date Hours Worked Period Regular Overtime Gross Ending Paid Hours Hours Pay 10-01-17 Balance Forward 630 00 00 481950 10-05-17 00 -15-17 3 500 00 10-31-17 10-30-17 350 000 Cumulative Annual T 17 00 00 00 Federal Income Tax 693000 5125050 26775 26775 51355.00 38.500 284125 38500 28 4125 770 000 569 45.00 01-05-17 01-15-17 01-30-17 11-30-17 Cumulative Annual Total 350000 350 000 7710 00 00 26775 38500 284125 26775 38500 284125 518.9.0.5081470.00_6263450 12-15-17 12-15-17 3 500 002677538500 28 4125 EMPLOYEE EARNINGS SUBSIDIARY LEDGER Employee's N vee's Name Jim Adams Address 2522 Longfello Soc. Sec. No. Longfellow, Chicago 60823 Date of Termination Occupation Accounting Clerk Home Addr employed_1/16/13 e of Birth 10/1/1988 Phone No. ***_**_9833 351-5874 Date of Birth Date Hours Worked Period Regular Overtime Ending Gross Pay 10-01-17 Federal Income Tax 31027 13 51 10 10-15-17 10-31-17 Paid Hours Hour 17 Balance Forward 2832 62 432000 2987511 115-1110-05-17 8 000 1-1710-31 -17 185955 9.00 14226 191.00 152029 2275 88 Cumulative Annual Total 4 7411 29000 1810T 3.148.99 4.80 8.00 332 06.11 15-17 01-15-17 8 800 12170 224805 171.97 K111-30 -17 8800 1430229 845075.83 284.00 1192.08 29600 182662 Cumulative Annual Total 3496795388.00 36824.87 825 EL 7 12-15 -17 8800 006022134016932 27500 176908 Nancy Ford lovee's Name 101 ***.**-4832 351-5251 Home Address Employed Date of Birth 10/1/17 5/22/1984 Soc. Sec. No. ss1018 Whittier, Chicago 60823 Date of Termination Phone No. Occupation Clerk Hours Worked Regular Overtime Gross Paid Hours Hours FICA 1-o- -0- Date Period Federal Income Ta Net Pay Pay Ending 1-17 Balance Forward -0- -0- 02 10-05-17 10-05-17 48.00 10-31-17 10 - 31 - 175 000 Cumulative Annual Total 8 16,00 850.00 1666.00 6242 6503 127145 74656 174.55 152.1111 11-15-17 11-05-17 4 900 11-30-17 11-30-17 5200 Cumulative Annual Total 833 00 88400 3/38300 16373 6762 25.8.80 160 55 1 103 8 05 35 3719 1308701 12-15-17 12 - 15 - 17 8 800 120 1526 6011679 168.00 13 4 1 81