ROE Hours Log Excel - Free Template

1. Open the ROE Hours Log sheet and enter each pay period for every employee. Use the same format every time: start date, end date, pay date, employee ID, and name.
2. Fill in the hour fields for regular, overtime, vacation, sick, and other paid time. If you pay 80 regular hours and 8 overtime hours, the sheet gives you a clean total to review.
3. Check the employee’s province, employment status, and ROE reason code. That makes it easier to support the record if Service Canada asks for details later.
4. Review gross earnings and insurable earnings before you file or issue the ROE. A small mismatch, such as $1,840.00 gross but $1,795.00 insurable earnings, is easier to fix now than after year-end.
5. Use the Employee Summary sheet to compare employees across periods. It helps you see who has 160 hours, who has extra sick time, and who needs a correction.
6. Read the Instructions sheet before you start, then save a copy for each payroll cycle. That keeps your workbook clean and reduces accidental overwrites.

The people who need this file are usually the ones who get the call right before a deadline. That can be a sole proprietor with 4 staff, a payroll clerk in a 25-person shop, or an office manager who has to pull hours after a layoff, resignation, or seasonal shutdown.

When the log becomes necessary

You usually reach for it when an employee stops working and you need a clean record of insurable hours and paid time. If one employee had 80 regular hours, 8 overtime hours, and 4 vacation hours in a two-week period, that is the kind of detail that belongs in the log before you create the ROE.

Why the sheet is useful in real payroll work

The ROE Hours Log sheet gives you a single place to track province, employment status, and ROE reason code alongside the numbers. The Employee Summary sheet helps you compare a worker who averaged 72 hours per pay period against another who hit 160 hours in the month, which is exactly the kind of difference you need to see before payroll questions start.

For most employers, the practical rule is simple: keep payroll records long enough to prove what you reported, and organize them so they can be produced quickly. The CRA expects business records to be kept for six years after the end of the last tax year they relate to, and that is the right record-retention standard to apply to hours, pay details, and supporting notes.

Why the numbers in this sheet matter

An ROE is not just a form; it is supported by the pay records behind it. If an employee earned $1,840.00 gross in a period but only $1,795.00 counts as insurable earnings, you need a workbook that shows the difference clearly instead of forcing you to reconstruct it from memory.

What to keep in the workbook

The safest practice is to keep the pay period dates, pay date, hours by type, earnings, and a reason code in the same file. That way, when you have 12 employees on alternating two-week cycles, you can still trace a single ROE back to the exact payroll run without hunting through separate files or old emails.

The most common mistake is mixing up paid hours with insurable hours. A payroll file that shows 80 worked hours but forgets 8 hours of vacation pay can leave you with an ROE that understates the employee’s paid time and creates a correction later.

Small errors become expensive fast

If you have 15 employees and you correct even 2 ROEs after the fact, you can burn half a day just matching pay dates, hours, and totals. A second problem is inconsistent naming or missing employee IDs, which makes it harder to prove that the 2026-01-01 to 2026-01-15 period belongs to the right person when you are under pressure.

What usually breaks first

Another failure point is the notes column being left blank. When an employee has sick hours, overtime, or other paid hours in a short pay period, a short note such as includes sick day is often enough to save you from re-checking old timesheets and supervisor emails later.

The easiest way to keep this workbook alive is to tie it to something you already do every pay cycle. For example, update the ROE Hours Log right after payroll is approved, not at month-end when the details are already fading.

Simple habits that keep it current

• Copy the prior pay period and change only the new dates, which saves time when you run 26 biweekly payrolls a year.
• Use the same employee ID and reason code every time so the summary sheet stays consistent.
• Review the data check column before you close the period, especially if one employee suddenly drops from 80 hours to 0.
• Keep one workbook per calendar year so you do not mix 2026 payroll data with last year’s records.

When a spreadsheet is no longer enough

If you are handling payroll for 50+ employees, multiple provinces, or frequent status changes, you may outgrow Excel and need payroll software that links directly to source deductions and ROE preparation. Until then, a disciplined workbook is a practical way to keep hours, notes, and summary totals in one place.