1. Prepare the Payroll Register (hint - begin by preparing each individual employee register and auto-add...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Prepare the Payroll Register (hint - begin by preparing each individual employee register and auto-add all employees on a main payroll register sheet for the T4 summary). The schedule will calculate CPP & El for you. You must use the Online Payroll Calculator to calculate Income Taxes. For simplicity, assume each employee is CC1. Remember that the automobile benefit is taxable benefit, but non-cash and & not insurable for El purposes. Employees work Monday-Friday only each week. There is no overtime. Ignore holidays. 2. Prepare a Record of Employment for Employee 458, they are being laid off for shortage of work, return date is unknown. (Use the blank ROE posted in Week 11) 3. Prepare the annual T4 summary for 2023. The amount of remittances for the year = $270,500 (Use the online 'fillable' form from Week 12). 4. Prepare the annual T4's for Employees 450 and 451. (Use the online 'fillable' form from Week 12) 5. Create an internal company checklist to be used when an employee is ending employment with the company. Use suggested points as outlined in our text and the slides from Week 11. 6. Calculate the amount of EHT that is due based on Total 2023 salaries. No wages are exempt. No formal reconciliation is required, simply calculate the amount due. 7. Prepare the journal entries to record the payroll expense in the general ledger for the company for the two-week period ending January 21, 2023. 8. Prepare the journal entries to record the employer's portion of payroll expenses in the general ledger for the company for the two-week period ending January 21, 2023. The WSIB Rate is 1.52. 9. Prepare the journal entry to pay the source deductions from January 2023 payroll that are due February First Day Worked Last Day Bi-Weekly Worked Employee Salary (Non-Cash) Annual Auto Benefit 01-Jan-22 450 2,850.00 7,100.00 02-Mar-22 451 2,300.00 7,300.00 01-May-27 152 2.250.00 7.600.00 15th 2023. 9. Prepare the journal entry to pay the source deductions from January due February 15th 2023 payroll that are 2023. First Last Day Worked Day Worked Employee Bi-Weekly Salary (Non-Cash) Annual Auto Benefit 01-Jan-22 450 2,850.00 7,100.00 02-Mar-22 451 2,300.00 7,300.00 01-May-22 452 3,250.00 7,600.00 30-Jun-22 453 2,100.00 6,900.00 29-Aug-22 454 1,880.00 28-Oct-22 455 3,300.00 25-Dec-22 456 4,700.00 8,300.00 19-Feb-23 457 2,240.00 23-Apr-23 25-Nov-23 458 3,170.00 25-Jun-23 459 3,430.00 Pay Pay Period Period Start Finish Pay Date 25-Dec-22 7-Jan-23 12-Jan-23 08-Jan-23 21-Jan-23 26-Jan-23 22-Jan-23 04-Feb-23 09-Feb-23 05-Feb-23 18-Feb-23 23-Feb-23 19-Feb-23 04-Mar-23 09-Mar-23 05-Mar-23 18-Mar-23 23-Mar-23 19-Mar-23 01-Apr-23 06-Apr-23 02-Apr-23 15-Apr-23 20-Apr-23 29-Apr-23 16-Apr-23 30-Apr-23 13-May-23 18-May-23 04-May-23 14-May-23 27-May-23 01-Jun-23 28-May-23 10-Jun-23 15-Jun-23 11-Jun-23 24-Jun-23 29-Jun-23 25-Jun-23 08-Jul-23 13-Jul-23 9-Jul-23 22-Jul-23 27-Jul-23 23-Jul-23 05-Aug-23 10-Aug-23 06-Aug-23 19-Aug-23 24-Aug-23 20-Aug-23 02-Sep-23 07-Sep-23 03-Sep-23 16-Sep-23 21-Sep-23 17-Sep-23 30-Sep-23 05-Oct-23 01-Oct-23 14-Oct-23 19-Oct-23 15-Oct-23 28-Oct-23 02-Nov-23 29-Oct-23 11-Nov-23 16-Nov-23 12-Nov-23 25-Nov-23 30-Nov-23 26-Nov-23 09-Dec-23 14-Dec-23 10-Dec-23 23-Dec-23 28-Dec-23 1. Prepare the Payroll Register (hint - begin by preparing each individual employee register and auto-add all employees on a main payroll register sheet for the T4 summary). The schedule will calculate CPP & El for you. You must use the Online Payroll Calculator to calculate Income Taxes. For simplicity, assume each employee is CC1. Remember that the automobile benefit is taxable benefit, but non-cash and & not insurable for El purposes. Employees work Monday-Friday only each week. There is no overtime. Ignore holidays. 2. Prepare a Record of Employment for Employee 458, they are being laid off for shortage of work, return date is unknown. (Use the blank ROE posted in Week 11) 3. Prepare the annual T4 summary for 2023. The amount of remittances for the year = $270,500 (Use the online 'fillable' form from Week 12). 4. Prepare the annual T4's for Employees 450 and 451. (Use the online 'fillable' form from Week 12) 5. Create an internal company checklist to be used when an employee is ending employment with the company. Use suggested points as outlined in our text and the slides from Week 11. 6. Calculate the amount of EHT that is due based on Total 2023 salaries. No wages are exempt. No formal reconciliation is required, simply calculate the amount due. 7. Prepare the journal entries to record the payroll expense in the general ledger for the company for the two-week period ending January 21, 2023. 8. Prepare the journal entries to record the employer's portion of payroll expenses in the general ledger for the company for the two-week period ending January 21, 2023. The WSIB Rate is 1.52. 9. Prepare the journal entry to pay the source deductions from January 2023 payroll that are due February First Day Worked Last Day Bi-Weekly Worked Employee Salary (Non-Cash) Annual Auto Benefit 01-Jan-22 450 2,850.00 7,100.00 02-Mar-22 451 2,300.00 7,300.00 01-May-27 152 2.250.00 7.600.00 15th 2023. 9. Prepare the journal entry to pay the source deductions from January due February 15th 2023 payroll that are 2023. First Last Day Worked Day Worked Employee Bi-Weekly Salary (Non-Cash) Annual Auto Benefit 01-Jan-22 450 2,850.00 7,100.00 02-Mar-22 451 2,300.00 7,300.00 01-May-22 452 3,250.00 7,600.00 30-Jun-22 453 2,100.00 6,900.00 29-Aug-22 454 1,880.00 28-Oct-22 455 3,300.00 25-Dec-22 456 4,700.00 8,300.00 19-Feb-23 457 2,240.00 23-Apr-23 25-Nov-23 458 3,170.00 25-Jun-23 459 3,430.00 Pay Pay Period Period Start Finish Pay Date 25-Dec-22 7-Jan-23 12-Jan-23 08-Jan-23 21-Jan-23 26-Jan-23 22-Jan-23 04-Feb-23 09-Feb-23 05-Feb-23 18-Feb-23 23-Feb-23 19-Feb-23 04-Mar-23 09-Mar-23 05-Mar-23 18-Mar-23 23-Mar-23 19-Mar-23 01-Apr-23 06-Apr-23 02-Apr-23 15-Apr-23 20-Apr-23 29-Apr-23 16-Apr-23 30-Apr-23 13-May-23 18-May-23 04-May-23 14-May-23 27-May-23 01-Jun-23 28-May-23 10-Jun-23 15-Jun-23 11-Jun-23 24-Jun-23 29-Jun-23 25-Jun-23 08-Jul-23 13-Jul-23 9-Jul-23 22-Jul-23 27-Jul-23 23-Jul-23 05-Aug-23 10-Aug-23 06-Aug-23 19-Aug-23 24-Aug-23 20-Aug-23 02-Sep-23 07-Sep-23 03-Sep-23 16-Sep-23 21-Sep-23 17-Sep-23 30-Sep-23 05-Oct-23 01-Oct-23 14-Oct-23 19-Oct-23 15-Oct-23 28-Oct-23 02-Nov-23 29-Oct-23 11-Nov-23 16-Nov-23 12-Nov-23 25-Nov-23 30-Nov-23 26-Nov-23 09-Dec-23 14-Dec-23 10-Dec-23 23-Dec-23 28-Dec-23
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...
-
Which step in the recruitment process involves attracting potential candidates to the organization? A. Selection B. Induction C. Job analysis D. Sourcing
-
Consider the de Broglie wavelength of an electron that strikes the back face of one of the early models of a TV screen at 1/10 the speed of light. Show that the electron wavelength is 2.4 10-11 m.
-
A truck transporting material to a factory requires 1 9 0 litres of gas for every trip to cover 1 , 5 0 0 km . How many litres of gas will it require to cover 1 , 9 5 0 km ?
-
Smart Manufacturing Systems Pty Ltds accountant recently prepared the following data from the companys accounting records for the year ended 30 June 2025. Required (a) Prepare a cost of goods...
-
Presented below are selected transactions of Santos Company. Santos sells in large quantities to other companies and also sells its product in a small retail outlet. March 1 Sold merchandise on...
-
Newton's Universal Law of Gravity (NULG) A) Discuss Newton's Universal Law of Gravity (NULG). a. What is required for there to be gravity? b. On what does gravity depend? c. What is the difference,...
-
Which of the following are true for both an operating as well as a financial lease: A. Cancellation clauses are lower for financial leases than operating leases. B. Lessor carries insurance and...
-
From June to September 2022, oil prices in the United States declined by about 35 percent. During these same months, U.S. oil production remained roughly constant, and stocks of oil in storage...
-
In 2018, an unusual situation developed with respect to production of natural gas in the Permian Basin of western Texas and New Mexico. A news article noted the following two facts: i. Shale drillers...
-
Juan Perez argues that Learning how to do business analysis and valuation using financial statements is not very useful, unless you are interested in becoming a financial analyst. Comment.
-
Should the capital budgeting committee accept the internal auditors first and second suggestions, respectively? A. No for Suggestions 1 and 2. B. No for Suggestion 1 and Yes for Suggestion 2. C. Yes...
-
Agricultural and industrial activity have substantially increased the reactive nitrogen content of the atmosphere. To investigate the potential consequences on ecosystems, Stevens et al. (2015)...
-
Analyze the leadership and/or employee performance (such as their engagement, turnover, commitment, well-being) at your workplace and compare it with the positive leadership and Psychological Capital...
-
Refer to Example 9.15. Add the following functionality to this program: Allow the user to enter the cost of a gallon of gas on each trip and use a function, Cost() to calculate the cost of purchasing...
-
Sample size = 81, sample mean = 4.5 km, sample standard deviation = 3.1 km Assume that population means are to be estimated from the samples described. In each case, use the sample results to...
-
n = 100, x = 8.0 ft, s = 2.0 ft Assume that population means are to be estimated from the samples described. In each case, use the sample results to approximate the margin of error and 95% confidence...
-
Margin of error = \($5\), standard deviation = \($20\)
Study smarter with the SolutionInn App