Cost Estimates and Selection Checklists
ERP and payroll integration in Canada: CPP, EI, Quebec and costs
Whether to run payroll inside your ERP or integrate a payroll provider, the Canadian and Quebec deductions involved, integration options, costs and testing.
Most Canadian small and mid-sized businesses do not run payroll inside their ERP. They keep a dedicated payroll service or module that handles source deductions, remittances and year-end slips, and integrate it with the ERP so that payroll journal entries, cost allocations and, where relevant, employee time flow automatically. The choice depends on whether your ERP's payroll (if it has one) is maintained for Canadian and Quebec rules, how many provinces you employ people in, and how much you value one system against a specialist that updates tax tables on its own. Budget for the integration either way: it is a real cost line.
This guide is part of the ERP selection checklist. Amounts are illustrative. For payroll rules, the official sources are the Canada Revenue Agency and, in Quebec, Revenu Québec. Contribution rates and maximums change every year; do not rely on figures in old documentation.
What Canadian payroll involves
| Element | Outside Quebec | In Quebec |
|---|---|---|
| Pension contributions | Canada Pension Plan (CPP), including the second additional contribution (CPP2) on earnings above the first ceiling | Quebec Pension Plan (QPP), with its own additional contributions |
| Employment insurance | EI premiums | EI at a reduced rate, plus Quebec Parental Insurance Plan (QPIP) premiums |
| Income tax withholding | Federal and provincial tax, remitted to the CRA | Federal tax to the CRA; Quebec income tax to Revenu Québec |
| Other employer contributions | Workers' compensation through the provincial board; some provinces levy employer health taxes | Health Services Fund, CNESST, labour standards contribution and, for larger payrolls, the workforce skills development contribution |
| Year-end slips | T4 slips and summary | T4 and RL-1 slips |
| Remitting | CRA, by remitter type and due dates | CRA for federal amounts; Revenu Québec for Quebec amounts |
A business with employees in Quebec and another province deals with two sets of rules and two tax authorities. That alone is a good reason to confirm that whichever payroll system you choose is maintained for both.
Three architecture options
| Option | How it works | Good for | Watch out for |
|---|---|---|---|
| Payroll module inside the ERP | One system, one employee record | Businesses whose ERP vendor maintains Canadian and Quebec payroll and updates tables on time | Not all ERPs sold in Canada include Canadian payroll; check who maintains rules |
| Dedicated payroll provider with integration | Payroll run elsewhere; journal entries and cost allocations imported into the ERP | Most SMBs, multi-province employers | Integration build and upkeep; mapping of GL accounts and departments |
| Payroll provider plus separate time and attendance | Time captured in a third system feeding payroll and job costing | Manufacturers, construction, field services | Three-way data flows; who owns employee master data? |
What the integration must move
- Payroll journal: gross wages, each deduction and employer contribution, net pay, by department, location or project, posted to the right general-ledger accounts.
- Liabilities: source deductions payable to the CRA and Revenu Québec, so remittances reconcile with the ledger.
- Job or project costing: labour cost to work orders, projects or cost centres.
- Time data: hours from the ERP or a time system to payroll, if time is captured outside payroll.
- Employee master data: decide which system is the source of truth for names, departments and cost centres. Avoid two-way editing.
Payroll data is highly sensitive personal information. Limit who in the ERP can see individual pay details; many businesses import payroll journals in summary only. See PIPEDA, Quebec Law 25 and data residency.
Integration costs (illustrative)
| Line (illustrative) | Low | High |
|---|---|---|
| Standard connector subscription, per year | $0 (built-in) | $3,000 |
| Configuration and GL mapping | $1,500 | $6,000 |
| Custom integration (if no connector) | $5,000 | $25,000 |
| Testing over two pay cycles and one month-end | $1,000 | $4,000 |
| Yearly maintenance when either system updates | $500 | $3,000 |
Over five years, a business with a standard connector might spend around $5,000 to $33,000 on the integration, depending on how much custom work is needed: for example a built-in connector with $1,500 set-up + $1,000 testing + $500 a year of upkeep ($2,500 over five years) for the low case, and $3,000 a year for a connector plus $6,000 set-up, $4,000 testing and $1,600 a year of maintenance for the high case ($15,000 + $6,000 + $4,000 + $8,000 = $33,000). Add whichever applies to the TCO estimator.
Testing payroll integration before go-live
- Run at least two pay cycles through both systems in a test environment.
- Reconcile each deduction and employer contribution in the ERP ledger with the payroll register.
- Check departmental and project allocations against expectations.
- Confirm that liability accounts clear when remittances are paid.
- Test a termination, a bonus and a retroactive pay change.
- For Quebec employees, check that QPP, QPIP and Quebec tax amounts post to their own accounts.
- Plan a mid-year switch carefully: year-to-date amounts must carry over for slips. Many businesses switch payroll systems on 1 January to avoid this.
FAQ
Should payroll go live at the same time as the ERP?
Not necessarily. Changing payroll mid-year means moving year-to-date totals; many businesses keep the current payroll provider and integrate it, or switch payroll on 1 January.
Does the ERP need to calculate CPP and EI?
Only if it runs payroll. If payroll is external, the ERP just records the results.
Who is responsible if remittances are wrong?
The employer. Directors can be personally liable for unremitted source deductions, so test thoroughly and reconcile monthly.
Does Quebec require a separate payroll system?
No, but the system must handle Quebec's rules and RL-1 slips, and remittances to Revenu Québec.
Sources
- Canada Revenue Agency — payroll deductions, remitting, T4 slips and current CPP/EI rates
- Revenu Québec — Quebec source deductions, QPP, QPIP, RL-1 slips and employer contributions
- CNESST — Quebec labour standards and workplace health and safety
- Retraite Québec — Quebec Pension Plan
