Create your own pay cycle scenario for an Ontario employer

Create your own pay cycle scenario for an Ontario employer (with a company name) who has four employees (with each employee’s name), two of them are paid annual salaries, and the other two employees are paid hourly wages. The four employees are between 20 and 60 years old. The payroll is processed for all the employees on a bi-weekly basis and this pay cycle is for the week ending October 23, 2020. There will be 26 regular pays in the year. 

The pay cycle information required in your payroll scenario: 

➢ Annual salary rates and overtime hours for the two salaried employees; hourly rates, regular and overtime hours for the two hourly paid employees. The employer pays overtime at time and a half for any approved hours worked in excess of 44 hours per week. The employer pays 4% vacation to hourly employees with each pay and accrues 6% vacation for salaried employees. 

➢ A cash non-taxable allowance for all four employees 

➢ A cash taxable allowance for the two hourly paid employees 

➢ A non-cash taxable allowance for all four employees 

➢ Monthly life insurance paid (to the insurance provider) by employer for all four employees 

➢ A provincial court order of $4,800 for one of the employees, calculate the court order deduction from this pay cycle. 

➢ Monthly union dues for all four employees 

➢ The two salaried employees contribute 10% of their regular salary to a Registered Retirement Savings Plan each pay cycle 

➢ The two hourly paid employees have authorized the employer to deduct $30 per month for the Skills Catalyst Fund 

➢ One of the salaried employee’s spouse’s net income is $9,500 in 2020 and he is going to claim the amount; one of hourly paid employee paid $3,500 tuition fees in 2020; and the rest of two employees have Basic Personal Amount only. Determine the Federal and Ontario TD1 Codes for each of the employees. 

➢ The employer’s Ontario Health Tax (OHT) contribution rate is 1.95% (based on total gross taxable earnings) and the current year W.S.I.B. premiums at $1.92 per $100 of assessable earnings. Estimate the employer Ontario Health Tax (OHT) contribution and WSIB premiums on this pay cycle assuming that all four employees’ gross taxable earnings do not exceed the maximum accessible earnings. Part two (80 marks) on Excel spreadsheet Prepare a payroll register and journal entries for both employee and employer on an Excel spreadsheet. Use cell reference (formula) to show your calculations on the payroll register, your assignment would not be marked if no cell references (formula, calculations) being used. In addition to the basic pay cycle specific information, you are required to include the following column in your payroll register: Gross Earnings, Pensionable Earnings, Insurable Earnings, Gross Taxable Earnings, Net Taxable Earnings, CPP, EI, Federal and Ontario Taxes, other deductions and Net Pay in your Excel payroll register. Show all your calculations on the Excel spreadsheet not on the Word payroll scenario document.

How Our Website Works


It has never been easier to place your order. Fill in the initial requirements in the small order form located on the home page and press “continue” button to proceed to the main order form or press “order” button in the header menu. Starting from there let our system intuitively guide you through all steps of ordering process.


All your payments are processed securely through PayPal. This enables us to guarantee a 100% security of your funds and process payments swiftly.


Next, we match up your order details with the most qualified freelance writer in your field.


Once we have found the most suitable writer for your assignment, they start working on a masterpiece just for you!


Once finished, your final paper will be available for download through your personal dashboard. You will also receive an email notification with a copy of your paper attached to it. Sometimes, the writer may leave a note for you about the order in case there is any additional information that they need to give you.

Leave a Reply

Your email address will not be published.