EMPLOYEES & PAYROLL Module Setup and Processing 7-439 Challenge Exercise 07 C7-3, Tool Shed Company (EMPLOYEES & PAYROLL, PAYABLES and COMPANY Modules) The company sells assorted tools and saw blades to both wholesale and retail customers. This exercise is a review of the EMPLOYEES & PAYROLL, PAYABLES and COMPANY modules. 1 Refer to Exercise 1-16 to unzip the 07 7C-3 Tool Shed.exe file. 2 > Open the 07 7C-3 Tool Shed file. Payroll information: . All employees are paid as noted in the information below. Overtime is paid at time and a half (regular pay plus / regular pay). Vacation pay (4%) is retained from hourly and commission employees, until the employee takes a vacation. Vacation pay is not calculated for salaried employees. The El rate is 1.4% times the employee deductions. It is assumed that the employee is exempt from the Employee Health Tax (EHT). Union Dues are deducted from hourly and commission employees' paycheques. The company has a pension plan. The Company allows employees to receive a payroll loan up to $500.00 for extenuating circumstances. The loan is repayable by all employees at $30.00 per pay. There are no outstanding loans. . . January Pay Dates: Hourly and commission employees are paid weekly on Friday. Salaried employees are paid bi-monthly (15th and 31st). Weekly: Medical Pension Union Dues Safety Shoes January 3rd January 10" January 17th January 24h January 31 Bi-Monthly: January 15th January 31 Deductions per pay period: Hourly employees: Commission employees: Salary employees: 3 > Record and Post the following transactions for January. Change employee "A-LAST NAME, First Name" to your own name before processing. Jan 2 Received "Memo Sal-Rev" from the owner to reverse the December 319 payroll accrual in the amount of $1,500 for all employees. (The total accrual for wages and salaries was accrued in Salaries Expense at Dec 31, 2024.) Jan 3 Process a payroll cheque run for 15 payroll of month. Note: A-LAST NAME, First Name worked 40 hours + 4 hours overtime, and Canon, Marisa worked 40 hours and earned $450 in commissions. Canon, Marisa phoned this morning requesting one week off for personal reasons and asked for her vacation pay. Released total vacation pay owing (40 hours) as of January 3". Did not deduct for medical plan or union dues. Jan 6 7-440 Learning Sage 50 Premium Accounting 2018.0 Jan 7 A-LAST NAME, First Name brought his paycheque to the office. It was confirmed there was an error with the paycheque. In addition to 40 regular hours First Name should have been paid for 5 overtime hours. Prepare the necessary reversing and correcting entries. (Use the approach presented in your textbook.) Issue a replacement cheque (next available cheque number) for the correct amount to YOUR ACTUAL LAST, First Name. Jan 10 Hourly payroll for the week ending January 10th is recorded. A-LAST NAME, First Name worked 40 regular hours. Jan 13 Canon, Marisa returned to work today. She was approved for a staff loan of $500.00 as her car motor needed repairs. Issue next cheque. Jan 13 Issued next cheque to the Receiver General for the EI, CPP and Income Tax payable balances outstanding at January 18, 2025. Jan 15 Bi-monthly salary payroll for January 15'h is recorded. Jan 17 Process a payroll cheque run for the weekly pay period: A-LAST NAME, First Name worked 40 regular hours plus 2 overtime hours. Canon, Marisa worked 32 hours and earned commission of $623. Jan 24 January Pay Dates: Weekly: January 3" January 10 January 17th January 24h January 31 Bi-Monthly: January 15th January 31 Process a payroll cheque run for the weekly pay period: A-LAST NAME, First name worked 40 hours, no overtime. Canon, Marisa worked 40 hours this week and earned $500 commission. Jan 31 Process the payroll cheque run for ALL employees. Note: A-LAST NAME, First Name worked 32 regular hours. Canon, Marisa worked 36 hours for $580 commission. 4> Print the reports indicated below after you have inputted the transactions. a) Journal Entries All (No corrections) for the period of the entries. b) Payroll Journal Entries, with Corrections to Jan 31. c) Balance Sheet at Jan 31. d) Income Statement. e) Employee Detail (all employees for month of January). f) Cheque Log at Jan 31. CamScanner EMPLOYEES & PAYROLL Module Setup and Processing 7-439 Challenge Exercise 07 C7-3, Tool Shed Company (EMPLOYEES & PAYROLL, PAYABLES and COMPANY Modules) The company sells assorted tools and saw blades to both wholesale and retail customers. This exercise is a review of the EMPLOYEES & PAYROLL, PAYABLES and COMPANY modules. 1 Refer to Exercise 1-16 to unzip the 07 7C-3 Tool Shed.exe file. 2 > Open the 07 7C-3 Tool Shed file. Payroll information: . All employees are paid as noted in the information below. Overtime is paid at time and a half (regular pay plus / regular pay). Vacation pay (4%) is retained from hourly and commission employees, until the employee takes a vacation. Vacation pay is not calculated for salaried employees. The El rate is 1.4% times the employee deductions. It is assumed that the employee is exempt from the Employee Health Tax (EHT). Union Dues are deducted from hourly and commission employees' paycheques. The company has a pension plan. The Company allows employees to receive a payroll loan up to $500.00 for extenuating circumstances. The loan is repayable by all employees at $30.00 per pay. There are no outstanding loans. . . January Pay Dates: Hourly and commission employees are paid weekly on Friday. Salaried employees are paid bi-monthly (15th and 31st). Weekly: Medical Pension Union Dues Safety Shoes January 3rd January 10" January 17th January 24h January 31 Bi-Monthly: January 15th January 31 Deductions per pay period: Hourly employees: Commission employees: Salary employees: 3 > Record and Post the following transactions for January. Change employee "A-LAST NAME, First Name" to your own name before processing. Jan 2 Received "Memo Sal-Rev" from the owner to reverse the December 319 payroll accrual in the amount of $1,500 for all employees. (The total accrual for wages and salaries was accrued in Salaries Expense at Dec 31, 2024.) Jan 3 Process a payroll cheque run for 15 payroll of month. Note: A-LAST NAME, First Name worked 40 hours + 4 hours overtime, and Canon, Marisa worked 40 hours and earned $450 in commissions. Canon, Marisa phoned this morning requesting one week off for personal reasons and asked for her vacation pay. Released total vacation pay owing (40 hours) as of January 3". Did not deduct for medical plan or union dues. Jan 6 7-440 Learning Sage 50 Premium Accounting 2018.0 Jan 7 A-LAST NAME, First Name brought his paycheque to the office. It was confirmed there was an error with the paycheque. In addition to 40 regular hours First Name should have been paid for 5 overtime hours. Prepare the necessary reversing and correcting entries. (Use the approach presented in your textbook.) Issue a replacement cheque (next available cheque number) for the correct amount to YOUR ACTUAL LAST, First Name. Jan 10 Hourly payroll for the week ending January 10th is recorded. A-LAST NAME, First Name worked 40 regular hours. Jan 13 Canon, Marisa returned to work today. She was approved for a staff loan of $500.00 as her car motor needed repairs. Issue next cheque. Jan 13 Issued next cheque to the Receiver General for the EI, CPP and Income Tax payable balances outstanding at January 18, 2025. Jan 15 Bi-monthly salary payroll for January 15'h is recorded. Jan 17 Process a payroll cheque run for the weekly pay period: A-LAST NAME, First Name worked 40 regular hours plus 2 overtime hours. Canon, Marisa worked 32 hours and earned commission of $623. Jan 24 January Pay Dates: Weekly: January 3" January 10 January 17th January 24h January 31 Bi-Monthly: January 15th January 31 Process a payroll cheque run for the weekly pay period: A-LAST NAME, First name worked 40 hours, no overtime. Canon, Marisa worked 40 hours this week and earned $500 commission. Jan 31 Process the payroll cheque run for ALL employees. Note: A-LAST NAME, First Name worked 32 regular hours. Canon, Marisa worked 36 hours for $580 commission. 4> Print the reports indicated below after you have inputted the transactions. a) Journal Entries All (No corrections) for the period of the entries. b) Payroll Journal Entries, with Corrections to Jan 31. c) Balance Sheet at Jan 31. d) Income Statement. e) Employee Detail (all employees for month of January). f) Cheque Log at Jan 31. CamScanner