Cost Estimates, Worked Examples and Selection Checklists
Manual payroll vs payroll software: when does switching pay back for a Canadian small employer?
A worked payback calculation for moving from spreadsheets and the CRA calculator to payroll software, with ramp-up and break-even headcount.
Moving from manual payroll (a spreadsheet, the CRA's Payroll Deductions Online Calculator, hand-typed bank transfers and year-end slips prepared by you or your accountant) to payroll software usually pays back within the first year once you have more than a handful of employees, because the software takes over the repetitive work: deductions, year-to-date maximums, remittance totals, ROEs and T4s. For one or two salaried employees paid monthly, the saving can be too small to justify a subscription. The way to know is a simple payback calculation with your own hours and fees, as worked below and in the payback calculator.
This guide is part of the payroll software selection checklist. The employer is an invented composite; prices and hours are illustrative.
What manual payroll really costs
| Task | Manual | With payroll software |
|---|---|---|
| Calculate each employee's deductions | PDOC per employee per run, copy to spreadsheet | Automatic |
| Track CPP, CPP2 and EI year-to-date maximums | Spreadsheet formulas you maintain | Automatic |
| Vacation pay accrual and payout | Spreadsheet | Automatic by rule |
| Pay employees | Online banking transfers one by one, or cheques | Direct deposit file or automatic |
| Pay stubs | Typed or templated | Generated, often in a portal |
| Remittance total and payment | Add up, pay by due date | Report or automatic remittance |
| ROEs | Built by hand in ROE Web from your records | Generated from pay history |
| T4 slips and summary | Web Forms by hand, or accountant fee | Generated and filed |
| Corrections | Rework spreadsheets, amend slips | Adjustment run |
The hidden cost of manual payroll is error risk: a missed CPP exemption for an employee who turned 18, an EI maximum crossed and not stopped, a remittance paid three days late. Each can trigger a CRA assessment or penalty; see payroll penalties.
Worked example: 18 employees paid biweekly
An Ottawa café group's owner runs payroll for 18 hourly employees every two weeks (26 runs).
Today, manual:
- 4 hours per run × 26 = 104 hours
- remittances, ROEs, T4 preparation and corrections: 20 hours a year
- total 124 hours × $45 loaded cost = $5,580
- accountant fee for year-end slips: $900
- current yearly cost: $6,480
With payroll software (illustrative):
- 1 hour per run × 26 = 26 hours, plus 6 hours of admin = 32 hours × $45 = $1,440
- subscription: $2,400 a year
- new yearly cost: $3,840
Net yearly saving: $6,480 − $3,840 = $2,640.
One-time switching cost: vendor setup $900, plus 20 hours of the owner's time for data entry and training at $45 = $900. Total $1,800.
Payback: with savings growing 3% a year, the first year's $2,640 exceeds $1,800, so payback comes at 1,800 ÷ 2,640 ≈ 0.68 years, about eight months. Over three years, the savings are $2,640 + $2,719.20 + $2,800.78 = $8,159.98, so the net saving is about $6,360 after the one-time cost. These are the calculator's default inputs.
Ramp-up: the first months save less
People rarely get the full time saving from the first pay run. A more cautious version assumes half the saving in the first three months:
- months 1–3: 50% of $220 a month = $110 a month → $330
- months 4–12: $220 a month → $1,980
- year 1 saving: $2,310
Payback then moves from about eight months to about nine: after three months $330 is recovered, and the remaining $1,470 takes 1,470 ÷ 220 ≈ 6.7 more months, so about 9.7 months. Still well under a year in this example.
Break-even headcount
The saving grows with headcount because manual time grows per employee, while software costs grow more slowly. A rough illustrative break-even, with a subscription of $40 base + $6 per employee a month and manual time of 12 minutes per employee per run (biweekly) at $45 an hour:
| Employees | Manual time cost a year | Software cost a year | Difference |
|---|---|---|---|
| 2 | 2 × 0.2 h × 26 × $45 = $468 | $40 × 12 + 2 × $6 × 12 = $624 | −$156 |
| 4 | $936 | $768 | +$168 |
| 10 | $2,340 | $1,200 | +$1,140 |
| 25 | $5,850 | $2,280 | +$3,570 |
In this illustration, software saves money from about three or four employees, before counting year-end fees avoided or errors prevented. Your own numbers will differ; a monthly pay cycle halves the manual time, and a plan without a base fee lowers the break-even.
What not to count
- Revenue gains you cannot link to payroll. Payroll software rarely increases sales.
- Time you would not actually redirect to anything useful. If the owner's saved hour is spent on nothing, the cash saving is zero; count only outside fees saved in that case.
- Grants you have not been approved for. Most payroll software purchases are not funded; enter $0 unless you hold an approval letter.
When manual payroll can still make sense
- One or two salaried employees, monthly pay, one province, low turnover.
- The owner is comfortable with the PDOC and keeps a reliable spreadsheet.
- Fewer than six slips a year, so paper or Web Forms filing is simple.
Even then, a low-cost payroll module or no-base-fee plan may be worth it for the remittance reminders and ROEs alone. For the next step after payback, compare options over three years in the three-year TCO guide and pick the right software type.
FAQ
Does the payback include the cost of fixing past errors?
Not in the default example. If you know you paid a penalty or spent time on amended slips last year, add that to the yearly saving, but only for errors that software would actually have prevented.
What loaded hourly cost should an owner use?
Use what the time is worth in your business: the wage you would pay someone to do it, or the value of the work the owner would do instead. Use the same rate before and after.
Is payroll software a deductible business expense?
Subscription fees are generally a deductible business expense. GST/HST charged is usually recoverable as an input tax credit for registrants. Ask your accountant about your situation.
Can I switch from manual payroll mid-year?
Yes, but you will need to enter year-to-date earnings and deductions for each employee so maximums and T4s are right. A quarter start, or 1 January, is easiest. See switching payroll providers mid-year.
Sources
- Canada Revenue Agency — Payroll Deductions Online Calculator, remitting, T4 Web Forms
- Employment and Social Development Canada — ROE Web
- Justice Laws Website — Income Tax Act record-keeping rules
- National Payroll Institute — training for people running payroll