if you can not read it please dont comment, just skip.

Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Accounting 213: Lab #8 for Chapter 9 - Payroll Accounting Name: Instructions: 1) use the information in Part A to complete the Payroll Register Table in Part B. Remember to use formulas when there is a calculation call reference 2) Using the information in the Payroll Register complete January & Decembar journal entries for both employer wages withholdings and employer only taxes fuse coll references NOTE in the pieces, we have provides you wth the formulas for a first period tlecause there is no data in the cells as you begin the assignment, the out of the calculation As you complete the rest of the table, you will see the results in the picole change. You will need to copy the formules in these Joruary cells from the first pened into the brequent period Part Tax Rates and Maximum Taxable Amounts: annual salary of employee subject to tax Social Security - FICA (DASDI 6.20% 5142.800 Soow Security Medicare 45 Unemployment PUTA DON Ununployment SUTA 545 $7.000 37.000 Previous Next Dashboard Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 Information for Employee Ima Wallpaldi Monthly grote pay $13.500 Monthly tax table Federa $3,425 State $800 Monthly an insurance 5750 Monthly life insurance 5100 Monty trement savings $2.500 Part B: Payroll Register Cumulative Name: Imma Wellpald gross pay Withholdings Calendar Cross pay Federal State Health Life year-to-date subject to Monthly Soc. SecMedicare income income Insurance Insurance Retirement Total with Month Gross pay tax Tax Premium Premium savings holdings January February March April to Sociales pay Previous Next Dashboard Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 epaid Federal Store $13.500 53,425 $800 $750 5100 $2.500 Irma Wellpad Cumulative Name: gross pay Calendar Gross pay year-to-date subject to Monthly Social Sec. Gross pay Monthly Monthly Sos. See Medicare Withholdings Federal State Health Income Income Insurance Insurance Retirement Tax tax Premium Premium savings Payroll subject tounen ployment Total with holdings IAS pay FUTA SUTA Previous Next Dashboard SRE Calendar To Do Notifications Inbox Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 Social See Gross pay Premium Premium savings holdings ay pl Month |January February March April May June July August September October November December Total XXXXXXXXX Part Journal Entries Record the payroll entry for payment to trma and related withholdings amounts on employee pays) Record the payroll taxes paid solely by the empl FICA match & unemployment en Previous Next Dashboard Calendar To Do Notifications Inbox ployment FUTA SUTA Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Social Sec Gross pay Tax Premium Premium savings holdings pay 30 SO 50 50 50 50 50 SO 50 50 KOOXXXOOXXX Record the payroll entry for payment to me and related withholdings amounts on employee pays Record the payroll taxes paid solely by the employer (PIGA match & unemployment taxes) Previous Next Dashboard SRE Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Record the payroll entry for payment to ma and related withholdings Record the payroll taxes paid solely try the employer famounts on employee pay sub) IFICA match & unemployment taxes Ste kample on page 347 in text See example on page 34 in text For the month of January For the month of January For the month of December For the month of December Previous Next Dashboard SRE Calendar To Do Notifications Inbox Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Accounting 213: Lab #8 for Chapter 9 - Payroll Accounting Name: Instructions: 1) use the information in Part A to complete the Payroll Register Table in Part B. Remember to use formulas when there is a calculation call reference 2) Using the information in the Payroll Register complete January & Decembar journal entries for both employer wages withholdings and employer only taxes fuse coll references NOTE in the pieces, we have provides you wth the formulas for a first period tlecause there is no data in the cells as you begin the assignment, the out of the calculation As you complete the rest of the table, you will see the results in the picole change. You will need to copy the formules in these Joruary cells from the first pened into the brequent period Part Tax Rates and Maximum Taxable Amounts: annual salary of employee subject to tax Social Security - FICA (DASDI 6.20% 5142.800 Soow Security Medicare 45 Unemployment PUTA DON Ununployment SUTA 545 $7.000 37.000 Previous Next Dashboard Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 Information for Employee Ima Wallpaldi Monthly grote pay $13.500 Monthly tax table Federa $3,425 State $800 Monthly an insurance 5750 Monthly life insurance 5100 Monty trement savings $2.500 Part B: Payroll Register Cumulative Name: Imma Wellpald gross pay Withholdings Calendar Cross pay Federal State Health Life year-to-date subject to Monthly Soc. SecMedicare income income Insurance Insurance Retirement Total with Month Gross pay tax Tax Premium Premium savings holdings January February March April to Sociales pay Previous Next Dashboard Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 epaid Federal Store $13.500 53,425 $800 $750 5100 $2.500 Irma Wellpad Cumulative Name: gross pay Calendar Gross pay year-to-date subject to Monthly Social Sec. Gross pay Monthly Monthly Sos. See Medicare Withholdings Federal State Health Income Income Insurance Insurance Retirement Tax tax Premium Premium savings Payroll subject tounen ployment Total with holdings IAS pay FUTA SUTA Previous Next Dashboard SRE Calendar To Do Notifications Inbox Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet3 Sheet1 Sheet2 Social See Gross pay Premium Premium savings holdings ay pl Month |January February March April May June July August September October November December Total XXXXXXXXX Part Journal Entries Record the payroll entry for payment to trma and related withholdings amounts on employee pays) Record the payroll taxes paid solely by the empl FICA match & unemployment en Previous Next Dashboard Calendar To Do Notifications Inbox ployment FUTA SUTA Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Social Sec Gross pay Tax Premium Premium savings holdings pay 30 SO 50 50 50 50 50 SO 50 50 KOOXXXOOXXX Record the payroll entry for payment to me and related withholdings amounts on employee pays Record the payroll taxes paid solely by the employer (PIGA match & unemployment taxes) Previous Next Dashboard SRE Calendar To Do Notifications Inbox G Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet1 Sheet2 Sheet3 Record the payroll entry for payment to ma and related withholdings Record the payroll taxes paid solely try the employer famounts on employee pay sub) IFICA match & unemployment taxes Ste kample on page 347 in text See example on page 34 in text For the month of January For the month of January For the month of December For the month of December Previous Next Dashboard SRE Calendar To Do Notifications Inbox