Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer question 4. Question 3 is answered and showed below. Thank you Appendix A - General Ledger structure Account number is made up of

image text in transcribedimage text in transcribedimage text in transcribed

Please answer question 4. Question 3 is answered and showed below. Thank you

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Appendix A - General Ledger structure Account number is made up of department and object XXXXX-YYYYY XXXXX = Department YYYYY Object Department Name General Ledger Distribution CADM 20000 100% CALL 61120 10% 20000 30% 71000 60% FNDC 61120 100% PAMB 71000 100% Object General Ledger Description 50110 Wages 50210 CPP 50220 EI 50230 EHT 50250 WSIB 50270 OMERS 50290 Benefits Example: Wages for department PAMB would be account 71000-50110Appendix B -Employer Costs CPP 1 X employee cost EI 1.4 X employe cost EHT 1.95% of employment income box 14 WSIB Dept: CALL , 1.96% of employment income box 14 Dept: FNDC, 6.4% of employment income box 14Question #3 Below is information for some of our employees. The figures provided under the payroll register have already been verified as accurate. The Dental benefit deducted from an employee represents 25% of the total cost for benefits. The other 75% is covered by the employer. Additonal reference tables are also included: Appendix A defines the general ledger structure along with a break down of specific object codes and departments Appendix B defines rates for various employer costs. Review the payroll register and confirm/correct the figures included in the attached T4 report. Payroll Register Name Dept T4 Baker, John FNDC Paycode Description Current Units Current Dollars YTD Units YTD Dollars Baker, John Earnings 1REG Regular Earnings 35.00 700.00 ,680.00 33,600.00 Box 14 Employment Income 36,400.00 2FVATK Vacation Taken 140.0 2,800.00 Box 16 CPP Deducted 1,637.46 Total Earnings 35.00 700.00 1,820.00 36,400.00 Box 18 El Deducted 651.12 Taxable Benefit Box 20 RPP Contributions 1,800.00 6LIFE Life Insurance Benefit 1.00 15.00 12.00 180.00 Box 22 Income Tax Deducted 8,675.00 Total Taxable Benefit 1.00 15.00 12.00 180.00 Box 40 Other Taxable Benefit 180.00 Deductions 7CPP Canada Pension Plan 1.00 28.73 26.00 1,637.46 Employer CPP Assessed 1,637.46 7EI Employment Insurance 1.00 12.73 26.00 651.12 Employer El Assessed 911.57 7TAX Income Tax 1.00 150.00 26.0 8,675.00 EHT Accrued 709.80 7SDN single Dental 12.00 108.00 WSIB Accrued 2,329.60 70MERS OMERS Pension 1.00 52.91 26.00 1,800.00 Total Deductions 4.00 244.37 116.00 12,871.58 Net Pay 455.63 Name Dept T4 Young, Joe CALL Paycode Description Current Units Current Dollars YTD Units TD Dollars Young, Joe Earnings RE Regular Earnings 28.00 980.00 1,764.00 61,740.00 Box 14 Employment Income 63,700.00 2SKFT Sick Paid 100% 7.00 245.00 56.00 1,960.00 Box 16 CPP Deducted 2,217.60 Total Earnings 35.00 1,225.00 1,820.00 63,700.00 Box 18 El Deducted 786.76 Taxable Benefit Box 20 RPP Contributions 5,255.00 6LIFE Life Insurance Benefit 1.00 15.00 12.00 180.00 Box 22 Income Tax Deducted 12,534.00 6CAR Vehicle Benefit 1.00 126.00 26.00 3,276.00 Box 40 Other Taxable Benefit 3,456.00 Total Taxable Benefit 2.00 141.00 38.00 3,456.00 Deductions Employer 2,217.60 7CPP Canada Pension Plan 1.00 50.95 26.00 2,217.60 Employer El Assessed 1,101.46 7EI Employment Insurance 1.00 24.31 26.00 786.76 EHT Accrued 1,242.15 7TAX ncome Tax 1.00 150.00 26.00 12,534.00 WSIB Accrued 1,248.52 FDNF Family Dental 12.00 312.00 70MERS OMERS Pension 1.00 155.00 26.00 5,255.00 Total Deductions 4.00 390.27 116.00 21,105.36 Net Pay 834.73Question #4 Below is the general ledger trial balance as of December 31st for the wages and benefits accounts. Based on the Payroll register in Question #3 along with the updated employer costs in the T4 section and the information in Appendix B, verify the values included in the trial balance and explain any variances. Unadjusted Revised Trial Balance as of December 31st Total Totals Variances 61120-50110 FNDC-Wages 43,295.60 61120-50210 FNDC-CPP 1,859.22 61120-50220 FNDC-EI 729.80 61120-50230 FNDC-EHT 2,022.85 61120-50250 FNDC-WSIB 2,472.75 61120-50270 FNDC-OMERS 2,325.50 61120-50290 FNDC-Benefits 139.20 20000-50110 CADM-Wages 20,146.80 20000-50210 CADM-CPP 665.28 20000-50220 CADM-EI 330.44 20000-50250 CADM-WSIB 394.88 20000-50270 CADM-OMERS 1,576.50 20000-50290 CADM-Benefits 93.60 71000-50110 PAMB-Wages 40,293.60 71000-50210 PAMB-CPP 1,330.56 71000-50220 PAMB-EI 660.88 71000-50250 PAMB-WSIB 789.75 71000-50270 PAMB-OMERS 3,153.00 71000-50290 PAMB-Benefits 187.20 Total 122,467.41

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental accounting principle

Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta

21st edition

1259119831, 9781259311703, 978-1259119835, 1259311708, 978-0078025587

Students also viewed these Accounting questions