Template, CAD 27

Payroll and remittancetracker.

Log each pay. The workbook calculates CPP, the second CPP contribution and EI with the yearly maximums, totals what you owe the CRA each month and gives you T4 totals at year end. Income tax comes from the CRA's free calculator and is typed in.

Get it for CAD 27 What is inside

Price: CAD 27, one time
Opens in: Google Sheets and Excel
Built by: Salman Feroz, CPA, CMA and team
Code word: PAYROLL

Payroll and remittance tracker: a real screen from the workbook, with sample figures — A real screen from the template, shown with sample figures.

What is inside

6 parts, one workbook

Inputs are marked in colour. Everything else calculates. The first sheet is a one-page guide.

01Employee listIncluded
02Pay run log: CPP, CPP2 and EI calculated, with yearly maximumsIncluded
03Employer cost of every payIncluded
04Monthly remittance totals with due datesIncluded
05Year-end T4 box totals by employeeIncluded
062026 CPP and EI rates page you can updateIncluded

Who it is for

Payroll and remittance tracker: who gets the most from it

Every pay run and every remittance date, in one place.

Built by The Accounting Doc team in Pickering, Ontario, from the working files we use with clients.

Employers with one to ten staff
Owners paying themselves a salary
Bookkeepers keeping a second record of payroll

Get the payroll and remittance tracker for CAD 27

CAD 27, one time. Tell us where to send it and we email you a secure payment link. The workbook is delivered to your inbox once it is paid.

Employee list
Pay run log: CPP, CPP2 and EI calculated, with yearly maximums
Employer cost of every pay
Monthly remittance totals with due dates

Payroll and remittance tracker: your questions

What does the payroll and remittance tracker cost?

CAD 27, one time. No subscription. You pay through a secure payment link and the file is emailed to you.

What do I need to open it?

It is a workbook that opens in Google Sheets (File, Import, Upload) and in Excel 2016 or later. No macros, so nothing to enable.

Can I use it for more than one business?

Yes, for your own businesses. Please do not resell or redistribute the file.

What if it does not fit my business?

Reply to the delivery email and tell us what is missing. We will point you to the right template or adjust the approach with you.

Is this accounting or tax advice?

No. It is a working tool. Your own numbers and decisions should be reviewed with your accountant, and we are glad to be that accountant.