T4 Summary of Remuneration Paid.pdf T4 Statement of Remuneration Paid.pdf BUSI 1019 – Final Assignment – Due Wednesday, December 15, 2021, Work 10% of your Final Mark Please submit via Blackboard as...

1 answer below »
this is a Canada admistration assignment thanks


T4 Summary of Remuneration Paid.pdf T4 Statement of Remuneration Paid.pdf BUSI 1019 – Final Assignment – Due Wednesday, December 15, 2021, Work 10% of your Final Mark Please submit via Blackboard as one PDF document if possible. If unable to combine as one document, please make sure your name and student number is clearly indicated on each document submitted. Required: 1. Prepare the annual T4 summary for 2021. The amount of remittances for the year = $270,500 (Use the fill able PDF posted with the assignment), you will need to create a Salary Payroll Register first to summarize the salaries. Watch for employees that max out on their CPP and EI contributions. Use claim code 1, and Ontario Tax tables 2. Prepare the annual T4’s for Employees 450 and 454. (Use the fill able PDF posted with the assignment) 3. Prepare a Record of Employment for Employee 458, they are being laid off for shortage of work, return date is unknown. (Use the PDF posted with assignment or create your own excel version). Use a standard 40-hour week. 4. Create an internal company checklist to be used when an employee is ending employment with the company. 5. Calculate the amount of EHT that is due based on Total 2021 salaries. No wages are exempt. No formal reconciliation required, simply calculate the amount due. 6. Prepare the journal entries to record the payroll expense in the general ledger for the company for the period ended January 9th, and January 23rd, 2021. No vacations pay to accrue or pay out. 7. Prepare the journal entries to record the employer’s portion of payroll expenses for CPP, EI and WSIB in the general ledger for the company for the period ended January 9th and January 23rd, 2021. The WSIB Rate is 1.95. 8. Prepare the journal entry to pay the source deductions (CPP, EI, and Federal & Provincial Income taxes) from January 2021 payroll that are due February 15th, 2021.     (Non-Cash) First Last   Bi-Weekly Annual Day Day Employee Salary Auto Benefit Worked Worked 450 2,500.00 6,110.00 01-Jan-20   451 2,200.00 6,240.00 02-Mar-20   452 3,000.00 6,500.00 01-May-20   453 1,900.00 5,850.00 30-Jun-20   454 1,750.00   29-Aug-20   455 3,100.00   28-Oct-20   456 4,000.00 7,150.00 27-Dec-20   457 2,700.00   22-Feb-21   458 3,300.00   26-Apr-21 26-Nov-21 459 3,200.00   28-Jun-21   Pay Period Pay Period Pay Start End Date 27-Dec-20 09-Jan-21 13-Jan-21 10-Jan-21 23-Jan-21 27-Jan-21 24-Jan-21 06-Feb-21 10-Feb-21 07-Feb-21 20-Feb-21 24-Feb-21 21-Feb-21 06-Mar-21 10-Mar-21 07-Mar-21 20-Mar-21 24-Mar-21 21-Mar-21 03-Apr-21 07-Apr-21 04-Apr-21 17-Apr-21 21-Apr-21 18-Apr-21 01-May-21 05-May-21 02-May-21 15-May-21 19-May-21 16-May-21 29-May-21 02-Jun-21 30-May-21 12-Jun-21 16-Jun-21 13-Jun-21 26-Jun-21 30-Jun-21 27-Jun-21 10-Jul-21 14-Jul-21 11-Jul-21 24-Jul-21 28-Jul-21 25-Jul-21 07-Aug-21 11-Aug-21 08-Aug-21 21-Aug-21 25-Aug-21 22-Aug-21 04-Sep-21 08-Sep-21 05-Sep-21 18-Sep-21 22-Sep-21 19-Sep-21 02-Oct-21 06-Oct-21 03-Oct-21 16-Oct-21 20-Oct-21 17-Oct-21 30-Oct-21 03-Nov-21 31-Oct-21 13-Nov-21 17-Nov-21 14-Nov-21 27-Nov-21 01-Dec-21 28-Nov-21 11-Dec-21 15-Dec-21 12-Dec-21 25-Dec-21 29-Dec-21
Answered 9 days AfterDec 02, 2021

Answer To: T4 Summary of Remuneration Paid.pdf T4 Statement of Remuneration Paid.pdf BUSI 1019 – Final...

Shivi answered on Dec 11 2021
124 Votes
Sheet1
    Pay Period    Pay Period    450    451    452    453    454    455    456    457    458    459    Pay    Bi-Weekly
    Start    End    1-Jan-20    2-Mar-20    1-May-20    30-Jun-20    29-Aug-20    28-Oct-20    27-Dec-20    22-Feb-21    26-Apr-21    28-Jun-21    Date    Payout
    27-Dec-20    9-Jan-21    2,500    2,200    3,000    1,900    1,750    3
,100    4,000    - 0    - 0    - 0    13-Jan-21    18,450
    10-Jan-21    23-Jan-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    - 0    - 0    - 0    27-Jan-21    18,450
    24-Jan-21    6-Feb-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    - 0    - 0    - 0    10-Feb-21    18,450
    7-Feb-21    20-Feb-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    - 0    - 0    - 0    24-Feb-21    18,450
    21-Feb-21    6-Mar-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,507    - 0    - 0    10-Mar-21    20,957
    7-Mar-21    20-Mar-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    - 0    - 0    24-Mar-21    21,150
    21-Mar-21    3-Apr-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    - 0    - 0    7-Apr-21    21,150
    4-Apr-21    17-Apr-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    - 0    - 0    21-Apr-21    21,150
    18-Apr-21    1-May-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    1,414    - 0    5-May-21    22,564
    2-May-21    15-May-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    - 0    19-May-21    24,450
    16-May-21    29-May-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    - 0    2-Jun-21    24,450
    30-May-21    12-Jun-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    - 0    16-Jun-21    24,450
    13-Jun-21    26-Jun-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    - 0    30-Jun-21    24,450
    27-Jun-21    10-Jul-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    2,971    14-Jul-21    27,421
    11-Jul-21    24-Jul-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    28-Jul-21    27,650
    25-Jul-21    7-Aug-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    11-Aug-21    27,650
    8-Aug-21    21-Aug-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    25-Aug-21    27,650
    22-Aug-21    4-Sep-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    8-Sep-21    27,650
    5-Sep-21    18-Sep-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    22-Sep-21    27,650
    19-Sep-21    2-Oct-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    6-Oct-21    27,650
    3-Oct-21    16-Oct-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    20-Oct-21    27,650
    17-Oct-21    30-Oct-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    3-Nov-21    27,650
    31-Oct-21    13-Nov-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,300    3,200    17-Nov-21    27,650
    14-Nov-21    27-Nov-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    3,064    3,200    1-Dec-21    27,414
    28-Nov-21    11-Dec-21    2,500    2,200    3,000    1,900    1,750    3,100    4,000    2,700    -...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here