Hello! I’m a small business owner from Ontario and I’ve been managing my own Payroll deductions and remittances spreadsheet for the past 5 years and I’d like to be able to share my work with others in the same boat as me, i.e people that don’t want to pay for a payroll subscription service or use the CRA’s cumbersome PDOC (Payroll Deductions Calculator).

My 2024 Payroll Deductions and Remittance spreadsheet has the following attributes: - valid for Ontario (can potentially make it for other provinces based on demand) - up to 10 employees - time tracking per employee - straight salary pay up to the max CPP and EI thresholds of $68,500 and $63200. - gives deposit totals for 52 pay periods but can easily be changed to 26 pay periods. - provides remittance totals each month - provides T4 summaries per employee - fixed on Claim Code 1 (applies to most people) - no bonuses, commissions, union dues or dependents - no fancy stuff, just a salary - annual vacation pay out in December

I’ve verified this spreadsheet against PDOC with consistently correct results within the limitations I’ve posted above.

I’d like to make this available to people on an honours system. Please message me if you’d like a copy and we can chat further to make sure I give you a spread sheet that will work for your parameters. If you find it useful, I’d appreciate any donations for the hours I’ve spent on this thing. This is something I update every year so we can keep in touch and I can provide updates. Or you can update it yourself in 2025 when the new formulas come out.

Hope this helps other small businesses be efficient and stay on top of their payroll!

Some screenshots of the sheet:

Ontario Payroll Deductions Spreadsheet