canadian payroll

[keetch]

I have downloaded the payroll template, and it is perfect for me however i cant seem to get the ontario canada rates in there, i really really want to use this, please help me
sue

 

[Tazguy37]

Where did you get it from? Kinda hard to tell what's going on without more details.

 

[keetch]

i downloaded it from
http://office.microsoft.com/en-us/templates/TC061011771033.aspx?CategoryID=CT062100761033

 

[Tazguy37]

You mean these rates?:

06101177.xlt
	F	G	H	I
1
2	StateTax(Percentage)	FederalIncomeTax(PercentagebasedonFederalAllowance)	SocialSecurityTax(Percentage)	MedicareTax(Percentage)
3	1.50%	1.00%	1.00%	1.45%
Employee Information

Just type them in those cells. The sheet will recalculate everything based on those.

 

[keetch]

no I mean the provincial, federal tax and C.P.P and E.I. I tried to change the formulas already present but cant get the proper end result
Sue

 

[Tazguy37]

no I mean the provincial, federal tax and C.P.P and E.I. I tried to change the formulas already present but cant get the proper end result
Sue

Which cells are those, and what do the formulas say? I have zero clue what those abbreviations mean.

 

[keetch]

do you know fo the download that I am refering to? the percentages are as follows
provincial tax 6.05%
federal tax 16%
C.P.P 4.95%
E.I is 1.98%
I especially like the way the download is split up into 3 sections of employee info, payroll calculator, and individual paystub. I want to be able to just plug in the numbers and print a paystub with YTD figures.
Sorry to be such a pain
Sue

 

[rexknightly]

Hi.... could you please share the template... I went to the site and they've removed the file.
thanks,
Rex

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here https://appsource.microsoft.com/en-us/product/office/WA104381516?src=website&tab=Overview

 

[naharwals]

Hi & welcome to MrExcel.
Have a look here https://appsource.microsoft.com/en-us/product/office/WA104381516?src=website&tab=Overview

its not working any more