Free Payroll Register Template (Canada) (Excel)
A payroll register is your complete record of what every employee was paid, and what was withheld, for every pay period — built here specifically around Canadian deductions like CPP and EI. This free template gives you a clean, consistent history to reference for remittances, year-end T4s, or an employee question.
No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Canadian small business owners running payroll without dedicated software
- Bookkeepers maintaining a Canadian payroll history for a client
- Businesses that need a clear record for T4 preparation at year-end
- Anyone switching payroll providers who needs historical Canadian payroll records
What's included
- Per-employee gross pay, CPP, EI, and tax deduction columns
- Pay period and pay date tracking
- Automatic totals across all employees per period
- Built-in AI prompt to review for unusual pay pattern changes
Why use a template instead of starting from scratch?
Payroll software often makes this data hard to export in a clean, readable format for your own reference — and if you run payroll manually, you need somewhere to record CPP, EI, and tax withholding consistently in the first place. This template gives you a straightforward, Canada-specific record either way.
How to Use This Template
Download and open in Excel or Google Sheets
Works identically in either — no macros or add-ins needed.
List every employee for the pay period
Include consistent identifiers so records stay easy to search later.
Enter gross pay, CPP, EI, and income tax withheld
Break these out clearly, since they’re remitted and reported separately.
Review the automatic net pay and period totals
These calculate as soon as gross pay and deductions are entered.
Run the built-in AI prompt periodically
Attach the saved file to ChatGPT or Claude and ask if any employee’s pay pattern looks like it changed unexpectedly.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether any employee’s pay pattern has changed unexpectedly period to period, worth double-checking before finalizing, no accounting background required.
Common Mistakes to Avoid
Not keeping a consistent record if using payroll software
Even with software handling the actual payroll run, keeping your own clean historical log makes T4 preparation and ad hoc questions much faster to answer.
Confusing employer and employee portions of CPP/EI
Both the employee-withheld and employer-matching portions matter for remittance — track them clearly and consistently.
Not reconciling deduction totals against CRA remittances
Payroll tax withholding needs to reconcile with what’s actually remitted — cross-check this register against your remittances periodically.
Relying on spreadsheet tracking alone for compliance
This template is for record-keeping and reference — actual CRA remittance and T4 filing require compliance with current CRA rules, ideally with payroll software or a professional handling that side.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club