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!

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?


--
VBAvirgin
------------------------------------------------------------------------
VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327
View this thread: http://www.excelforum.com/showthread...hreadid=521419

You'll need to have a look at this:

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=521419

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/te...CT011377091033

Thanks!

"VBAvirgin" wrote:


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?


--
VBAvirgin
------------------------------------------------------------------------
VBAvirgin's Profile: http://www.excelforum.com/member.php...o&userid=16327
View this thread: http://www.excelforum.com/showthread...hreadid=521419