Payroll template for Canada

**Luanne** · 03-15-2013, 10:10 PM

I am in need of a payroll template that is Canadian. Does anyone know where I can find one?

**FDibbins** · 03-16-2013, 12:48 AM

Hi and welcome to the forum

You will have to be way more specific than that. Just because it has to work in Canada, doesnt say anything about what it needs to do, or how it needs to do it

**Toonies** · 03-16-2013, 02:34 AM

what are your required fields for your template

**Luanne** · 03-16-2013, 07:14 AM

it needs to be able to calculate gross and net pay, CPP, EI, TAX and other deductions (Medical, Union dues, Pension, etc...). Also calaulate sick time and vacation time.

**Toonies** · 03-16-2013, 07:51 AM

Wow have you got an example that you can post

**scottbeattie** · 01-29-2015, 01:16 AM

Luanne,
I have been working on something like what you're looking for, for about four years (self taught in vba) but it works.
I've worked it out to calculate with 2 pennies of the CRA tables and the PDOC. If you're interested please send me a private post.

**FDibbins** · 01-29-2015, 01:18 AM

scott, we do not answer questions in private on this forum, the whole purpose is for everyone to help, and everyone to learn.

@ Luanne, do you have something you have started on yet, that you could share with us?

**scottbeattie** · 01-29-2015, 02:52 AM

Originally Posted by FDibbins

scott, we do not answer questions in private on this forum, the whole purpose is for everyone to help, and everyone to learn.

@ Luanne, do you have something you have started on yet, that you could share with us?

Sorry about the private posts then.
I do have something that will help. Please let me know if you want to give it a test run.
BTW, currently it only calculates for 2015 for non-Quebec taxes.
If you need something from previous dates. We can work on it if you need the calculations.

**jantonio** · 06-02-2015, 11:52 AM

Can you please share or send me a private post? I would be interested in seeing the file.

Thank you!

**protonLeah** · 06-02-2015, 02:31 PM

Originally Posted by jantonio

Can you please share or send me a private post? I would be interested in seeing the file.

Don't Private Message, Visitor message or email Excel questions to moderators or other members. All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.