1) complete the entire pay cycle process by calculating gross to net
a) Sandra works in British Columbia and is paid on a semi-monthly basis. She has a claim code of 1 on both her TD1 and TD1BC. She has the following type of earnings, benefits & deductions. She will not max out on CPP or EI this pay and will have full deductions. Please use 2019 rates for your calculation and show not only the deduction value but also the pensionable, insurable and taxable amounts on which they were based.
i) Regular $3200
ii) Holiday Pay $250
iii) Group Life – Employer paid Taxable benefit $15
iv) Employee RRSP contribution $200
Her employee matches her EI at a non-reduced rate (1.4) and additionally pays employer health tax at a rate of 1.95%. The pay ending is July 31st and all amounts will be paid to third parties for the month. The monthly amounts will be exactly double for month end reporting purposes.
Calculate gross to net, employee premiums and record all applicable accounting entries in the tables below:
Journal Entry #4786
Date: July 31, 2019
Account Name
Account No.
Debit
Credit
Regular Pay
30000-601
Holiday Pay
30000-602
CPP Contributions Payable
20000-203
EI Premiums Payable
20000-205
Federal Income Tax Payable
20000-206
Provincial Income Tax Payable
20000-206
RRSP Payable
20000-210
Payroll Clearing (Net Pay)
20000-218
Total
To record wages expense for pay period July 31, 2019.
Journal Entry #4787
Date: July 31, 2019
Account Name
Account No.
Debit
Credit
Payroll Clearing (Net Pay)
20000-218
Payroll Cash
10000-100
Total
To record payment to employees for pay period ending July 31, 2019
Journal Entry #4788
Date: July 31, 2019
Account Name
Account No.
Debit
Credit
CPP Employer
30000-610
EI Employer
30000-611
Group Life
30000-301
British Columbia – EHT
30000-450
CPP Contributions Payable
20000-203
EI Premiums Payable
20000-205
Group Life Payable
20000-223
EHT Accrual
20000-225
Total
To record employer’s portion of CPP Contributions, EI Premiums, EHT and Group Life Expenses for pay period ending July 31, 2019
Journal Entry #4789
Date: July 31, 2019
Account Name
Account No.
Debit
Credit
CPP Contributions Payable
20000-203
EI Premiums Payable
20000-205
Federal Income Tax Payable
20000-206
Provincial Income Tax Payable
20000-206
Group Life Payable
20000-223
EHT Accrual
20000-225
RRSP Payable
20000-210
Payroll Cash
10000-100
Total
To record remitting to third parties for the month ending Date: July 31, 2019
· Include a cover page with the course code and course name, the assignment number, the title of your assignment, your student ID, your name, the instructor’s name, and the date the assignment is created.
· Font should be either Calibri or Arial, 11pt. Text must be double spaced but table may be single spaced.
· You must cite all your sources of information using APA formatting.
· Create a separate reference page that lists all of your sources that you have cited in text. Sources include software used. Also, personal communications from a professional in the field count as a reference source. For citation and referencing examples, see https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html