RL-1 Reconciliation Excel - Free Template

1. Open the Employee Data sheet and enter each employee’s payroll details line by line. Use one row per person so you can reconcile them cleanly later.
2. Move to Reconciliation Checks and review the totals against your payroll reports. If one employee is off by even $25.00, the sheet makes the difference obvious.
3. Use the RL-1 Summary sheet to confirm the final amounts you plan to report. This is where you check that the totals agree before filing.
4. Follow the Instructions sheet if you need the workflow in order. Keep it open the first time you use the file so you do not skip a step.
5. Correct any mismatches in the source data, not in the summary. That keeps the numbers traceable and easier to defend at year-end.
6. Save a copy for each filing cycle. In practice, that means one clean workbook for each payroll year or amendment.

You reach for this template when payroll numbers need to line up before RL-1 slips go out in Quebec. That usually happens at year-end, after a retroactive pay change, or when a payroll export from 12 or 24 pay periods does not match the summary you expected.

Who uses it in practice

A sole bookkeeper at a 15-person shop uses it to compare taxable benefits, Quebec Pension Plan deductions, and other payroll amounts before filing. An office manager at a plumbing company might be checking a crew of 4 technicians and 1 apprentice after a bonus run added $1,200.00 to the gross pay.

What the workbook is for

The Employee Data sheet captures the details, the Reconciliation Checks sheet tests the numbers, and the RL-1 Summary sheet pulls the final totals together. If you are reconciling 20 employees and one person is missing a $42.50 deduction, the mismatch shows up before you send anything to Revenu Québec.

A practical example

Say you have 18 employees, each with an average of $2,400.00 in taxable pay for the period. That gives you $43,200.00 to tie out, and even a 0.5% variance means a $216.00 difference worth fixing before filing.

That same year-end review often leads into employment expense tracking, where the figures behind deductions and allowances need to match the records used for filing.

Revenu Québec expects the numbers behind an RL-1 to be traceable back to payroll records, not just copied from a summary report. Keep the supporting detail for at least the CRA-style six-year retention period, because payroll records often need to survive well past the filing date.

What must line up

Your reconciliation should tie employee pay, tax withheld, Quebec Pension Plan contributions, and other amounts back to the totals you plan to report. If you are filing for 9 employees and one has a $78.00 taxable benefit that was missed, the summary will be wrong even if the rest is perfect.

Why the separation matters

This workbook splits data entry, checks, and summary so you can see where the problem starts. That is better than editing a single tab, because a fix in one cell can quietly break the total somewhere else.

Practical rule for the year-end close

For a small payroll, I prefer a simple reconciliation workbook over a big ERP export when the team is under 50 employees and the issue is year-end cleanup. At that size, a clean spreadsheet is faster than re-running a payroll system report three times and hoping the numbers settle.

The most common problem is a mismatch between the payroll register and the summary line on the slip. A missing taxable benefit of $150.00, a double-entered bonus, or a late source deductions adjustment can throw off the whole filing.

Small errors, real cost

If you miss one employee’s Quebec tax withholding by $37.00 and the error repeats across 24 pay periods, you are no longer looking at a rounding issue. You are looking at a real reconciliation gap that can take an hour or more to trace back through payroll reports and bank records.

Why manual fixes go wrong

People often patch the summary instead of correcting the source data. That creates a second problem in month-end or year-end, because the numbers no longer agree with the general ledger, the payroll journal, or the T4/RL filing package.

A field example

On a 6-person office payroll, one employee’s bonus was entered twice at $500.00. The mistake was only $500.00, but it took 45 minutes to unwind because the gross pay, taxable benefits, and tax withheld all had to be rechecked line by line.

The easiest way to keep this file alive is to tie it to something you already do, such as the last payroll run of the month or the year-end slip review. If you wait until filing week, the workbook becomes a catch-up job instead of part of your routine.

Three habits that make it stick

• Copy the prior period’s file and clear only the new input rows, so you are not rebuilding the structure every time.
• Review the checks on the same day you import payroll data, while the source report is still open.
• Use simple status marks to flag variances above $1.00, because tiny differences are easy to miss in a long list.

When to move on from Excel

If you are running 100+ employees, correcting retro pay every cycle, or managing multiple departments with separate approval steps, a payroll system will be easier than a spreadsheet. For a small Quebec payroll, though, this workbook stays practical because it is fast to update and easy to explain.