Purchase Solution

Payroll Tax Entries in Excel

Not what you're looking for?

Ask Custom Question

(Payroll Tax Entries) The payroll of Auber Corp. for September 2008 is as follows: Total payroll was $495,000. Pensionable (CPP) and insurable (EI) earnings were $375,000. Income taxes in the amount of $90,000 were withheld, as was $9,000 in union dues. The employment insurance tax rate was 1.80% for employees and 2.52% for employers and the CPP rate was 4.95% for employees and 4.95% for employers.

Instructions:
(a) Prepare the necessary journal entries to record the payroll if the wages and salaries paid and the employer payroll taxes are recorded separately.
(b) Prepare the entries to record the payment of all required amounts to the CRA and to the employees' union.
(c) For every dollar of wages and salaries that Auber commits to pay, what is the actual payroll cost to the company?
(d) Discuss any other costs, direct or indirect, that you think would add to the company's costs of having employees.

Purchase this Solution

Solution Summary

This solution answers various questions regarding payroll tax entries in Excel.

Solution Preview

Dear student,
Solution to your problem is provided in a separate excel file attached herewith.It contains the ...

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Operations Management

This quiz tests a student's knowledge about Operations Management

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Learning Lean

This quiz will help you understand the basic concepts of Lean.