If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel payroll calculator for canadians
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! |
#2
|
|||
|
|||
excel payroll calculator for canadians
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 |
#3
|
|||
|
|||
excel payroll calculator for canadians
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 |
#4
|
|||
|
|||
excel payroll calculator for canadians
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 5 and Excel 2000 question. | Naveen Mukkelli | General Discussion | 1 | March 3rd, 2006 09:05 AM |
Need suggestions for some uses of Ms Excel | Bible John | General Discussion | 1 | February 27th, 2006 05:30 PM |
How do I write a formula in excel that calculates payroll? | Excel overtime formula | Worksheet Functions | 3 | October 29th, 2005 10:52 PM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |