+ Reply to Thread
Results 1 to 2 of 2

Excel Template for Canadian Payroll

  1. #1
    Registered User
    Join Date
    12-30-2020
    Location
    Victoria, BC
    MS-Off Ver
    2019
    Posts
    1

    Excel Template for Canadian Payroll

    Hi I was wondering if anyone had a payroll template for Canada (BC) that would calculate the deductions as well as make it simple to add new employees and keep track of their year long hours etc. i've got something that isn't very good in excel and leads to a lot of mistakes and was hoping to start the new year with something better but I just don't know how to do this in excel. Right now I just copy the last pay periods' sheet to a new sheet and replace all the dates and if I have to add a new employee I insert new rows but it leads to alot of errors. If anyone has anything they are using that they could share I would be really grateful.
    Thanks,
    Kerry

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,837

    Re: Excel Template for Canadian Payroll

    It would be easier to help and test possible solutions if you could attach a copy of your file so we can see what you have so far. Include any macros you are currently using. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel formulas to calculate netpay for canadian payroll
    By onlineathome in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2021, 02:51 AM
  2. Calculating YTD Figures for Canadian payroll
    By Mybudjake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2015, 11:35 AM
  3. Payroll template for Canada
    By Luanne in forum Excel General
    Replies: 9
    Last Post: 06-02-2015, 02:31 PM
  4. [SOLVED] *wanted* Payroll template with Canadian deduction catagories
    By RLSaSSy in forum Excel General
    Replies: 1
    Last Post: 02-27-2012, 01:18 PM
  5. Canadian Payroll Deduction Formulas
    By markhenick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2009, 01:13 PM
  6. Payroll calculator template
    By Eagle View Construction in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 09:06 PM
  7. [SOLVED] Payroll Calculator Excel Template
    By Eagle View in forum Excel General
    Replies: 0
    Last Post: 04-30-2005, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1