excel payroll calculator for canadians

[Guest]

Can anyone advise me on how to setup a payroll calculator in excel that would
automatically deduct income tax, CPP, and EI. I've looked at the MS template
and it is great. Is it possible to create a template like it, but have it
calculate the necessary canadian deductions.

Any help or a template would be great.
Thanks!

 

[VBAvirgin]

Can you post the link to the template you mentioned, so I can have a
look.
Am I correct in my understanding, you want to be able to, for example,
input a monetary amount, and have the neccessary deductions calculated?
Is that right?

 

[Cutter]

You'll need to have a look at this:

http://www.cra-arc.gc.ca/E/pub/tg/t4127-jan/t4127-e.pdf

 

[Guest]

Hi,

You are correct in that I would like to input the gross earnings and deduct
EI, CPP and Income Tax. It is a bi-weekly pay schedule. I know that EI is
1.87%. I do use CRA's TOD, which will calculate these deductions
automatically. However, I would like to create an excel template.

The link for the ms template is
http://office.microsoft.com/en-us/templates/TC061011771033.aspx?CategoryID=CT011377091033

Thanks!