Pavlyuchyk
New Member
- Joined
- Feb 12, 2012
- Messages
- 1
Dear Colleagues,
Has anybody tried and succeeded in creating a spreadsheet where one could enter weekly (bi-weekly, semi-monthly, monthly etc.) wages, and get federal (Ontario) tax exactly the same as in Payroll Deductions Online Calculator at http://www.cra-arc.gc.ca/esrvc-srvce/tx/bsnss/pdoc-eng.html ? Payroll tables seem to be understandable, but when I try to implement payroll table rules in excel formulas, I am able to replicate CPP and EI only, and I am always off from Payroll Deductions Online Calculator in federal and provincial income taxes. Please help.
Kind regards.
Alex
Has anybody tried and succeeded in creating a spreadsheet where one could enter weekly (bi-weekly, semi-monthly, monthly etc.) wages, and get federal (Ontario) tax exactly the same as in Payroll Deductions Online Calculator at http://www.cra-arc.gc.ca/esrvc-srvce/tx/bsnss/pdoc-eng.html ? Payroll tables seem to be understandable, but when I try to implement payroll table rules in excel formulas, I am able to replicate CPP and EI only, and I am always off from Payroll Deductions Online Calculator in federal and provincial income taxes. Please help.
Kind regards.
Alex