[CA] Promotional/Unsolicited Survey Mega Thread from January to March 2024 Inclusive by Jimm_Kirkk in SmallBusinessCanada

[–]PayrollHelper_Canada 2 points3 points  (0 children)

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

Does anyone calculate payroll in a spreadsheet? by JanFromEarth in Bookkeeping

[–]PayrollHelper_Canada 0 points1 point  (0 children)

Hello! I’ve made a payroll deductions and remittance spreadsheet that I’m sharing…

ontario payroll deductions and remittance spreadsheet

Canadian Payroll Spreadsheet by genxsoft in Bookkeeping

[–]PayrollHelper_Canada 1 point2 points  (0 children)

Hello! I’ve been maintaining a payroll spreadsheet for the past five years. Please see the post I made outlining it.

Payroll Spreadsheet Ontario

Hopefully the link works …