An image of an employer reviewing payroll reconciliations.
Payroll

How to do payroll reconciliation: A 6-step guide for Canadian employers


Key Takeaways

  • Payroll reconciliation is an accounting process that confirms that employee pay, deductions, and remittances match your records before filing with the CRA or Revenu Québec.

  • Reconciling every pay period helps prevent penalties, keeps payroll requirements top of mind, and avoids year-end T4 corrections.

  • A structured 6-step checklist makes payroll reconciliation manageable and repeatable.

  • Integrated payroll and accounting software, like QuickBooks Online, can reduce errors and simplify reporting.


  • Payroll problems usually show up when something doesn’t line up. A missed deduction, a wrong pay rate, or a remittance that doesn’t match your Canada Revenue Agency (CRA) account can create stress quickly. 

    In Canada, small payroll errors can ripple into penalties, cash flow issues, or T4 corrections at year-end. For these reasons, payroll reconciliation deserves more attention than it typically gets.

    In this guide, we’ll walk you through what payroll reconciliation means in Canada, why it matters for CRA and Revenu Québec compliance, and how to reconcile payroll in 6 practical steps every pay period.

    What is payroll reconciliation?

    Payroll reconciliation is the process of comparing your payroll register, deductions, and remittances to ensure everything matches before and after you pay employees.

    What you need to check:

    • Gross pay is calculated correctly.
    • Deductions like CPP or QPP, Employment Insurance (EI) or Quebec Parental Insurance Plan (QPIP), and income tax are accurate.
    • Company contributions match employee withholdings.
    • Remittance amounts align with your CRA or Revenu Québec payroll account.
    • General ledger amounts reflect what was actually paid.

    For example, if an employee earned $2,600 in a pay period but received $2,000 in net pay, payroll reconciliation ensures the $600 difference is properly allocated to income tax, CPP, EI, taxable benefits, or other deductions. 

    Every dollar must be accounted for across your payroll reconciliation report. If the totals don’t balance, something is off. You can also use tools like the CRA online payroll calculator to double-check deductions if you’re unsure whether your withholdings line up with current rates.

    Why is payroll reconciliation important?

    Payroll reconciliation helps prevent small mistakes from affecting your payroll obligations under CRA or Revenu Québec rules.

    When it comes to payroll, Canada’s compliance standards make regular reconciliation part of responsible financial management.

    Why avoiding small mistakes matters:

    • Protects your cash flow: Catching errors early avoids overpayments or remittance shortfalls.
    • Supports CRA compliance: Payroll deductions must be remitted on schedule under CRA guidelines outlined in the Employers’ Guide – Payroll Deductions and Remittances.
    • Reduces penalty risk: The CRA may apply late remittance penalties ranging from 3% to 10%, and up to 20% for repeat offences.
    • Simplifies year-end reporting: Accurate reconciliation makes preparing T4 slips far smoother.

    In many cases, payroll reconciliation is what prevents a stressful February when T4 summaries must match cumulative remittances.


    Definition of payroll reconciliation for Canadian employers.

    How to reconcile payroll in 6 steps

    Payroll reconciliation works best when it follows a well-defined, repeatable checklist. Each step below focuses on one action and one outcome, making it easier to catch issues before they affect your payroll responsibilities or reporting.

    Step 1: Check your payroll register

    Start the payroll reconciliation process by reviewing your payroll register in full. What your payroll register typically includes:

    • Employee name and Social Insurance Number (SIN)
    • Pay period and pay date
    • Regular hours and overtime hours
    • Pay rate (hourly or salary equivalent)
    • Gross pay
    • CPP or QPP deductions
    • EI or QPIP deductions
    • Federal and provincial income tax
    • Other deductions (benefits, RRSP, garnishments)
    • Net pay

    Look for changes. Did you hire someone new? Did someone receive a raise or bonus? Did an employee go on leave?

    If total payroll costs change unexpectedly, check personnel updates first. Often, the explanation is legitimate. But if it’s not, this is where you’ll catch it.

    Step 2: Approve employee timesheets

    Next, confirm that the hours worked are accurate and approved. Keep completed and accepted time cards to make sure that all hours are entered correctly.

    What to review on employee timesheets:

    • Paid time off
    • Unpaid leave
    • Vacation pay
    • Sick days
    • Overtime
    • Statutory holidays

    In provinces like Ontario or Alberta, overtime thresholds differ. Errors here can affect both wages and compliance.

    If you’re still using paper timesheets, this step may take longer than it needs to. Digital time-tracking systems like QuickBooks Time let you approve hours before payroll runs, reducing the risk of manual errors.

    Step 3: Double-check pay rates

    Check that each employee’s pay rate is up to date and correctly entered. If an employee’s salary information changes (e.g., a raise), it must be updated in the payroll register. 

    Focus on new hires or employees who have received a promotion or a bonus to ensure that the information has been entered correctly.

    For hourly employees, multiply approved hours by the correct rate. For salaried employees, confirm the correct salary allocation per pay period.

    This step determines gross wages. If the gross pay is incorrect, every deduction that follows will also be wrong.

    A good practice: keep documentation for raises, bonuses, and promotions separate, so you can quickly double-check that adjustments were entered correctly.


    A person sitting in front of a laptop computer.

    Payroll made easy

    Simplify your payroll processes and taxes with QuickBooks - effortlessly complete forms and quickly run payroll with auto payroll and direct deposit.

    Step 4: Confirm deductions

    By law, employers in Canada must deduct the required payroll deductions and remittances outlined in the CRA’s Employers’ Guide – Payroll Deductions and Remittances.

    • Canada Pension Plan (CPP) or Quebec Pension Plan (QPP)
    • Employment Insurance (EI) or QPIP
    • Federal and provincial income tax

    You must also match employer portions for CPP or QPP and EI. What employers need to confirm:

    • Deduction rates align with current year thresholds.
    • Company contributions match the required formulas.
    • Remittance totals align with your CRA or Revenu Québec payroll account balances.
    • Any voluntary deductions (private health benefits, group RRSP, union dues) are accurate.

    For example, if your receptionist becomes eligible for new retirement benefits this pay cycle, you must include the additional deduction. Similarly, if one of your employees updates their withholding information, double-check that the updated information is entered.

    This is typically where many businesses use the CRA online payroll calculator to double-check the net pay calculation for an employee with multiple deductions.

    Step 5: Submit your payroll

    Once your figures balance, you can release payroll. That may mean printing cheques or processing direct deposits through your payroll management system.

    What you need to confirm before finalizing payroll:

    • Net pay totals match your payroll register.
    • Direct deposit totals align with your bank funding.
    • Remittance amounts are scheduled correctly.

    With integrated payroll tools like QuickBooks Payroll, a large part of this verification process happens automatically, which can lower the chance of manual mistakes.

    Step 6. Record in the general ledger

    Every payroll run must be recorded in your general ledger. A typical payroll journal entry affects:

    Account Category Example Entries
    Assets Cash (bank account used for payroll payments)
    Expenses Payroll expenses: Wages; Payroll expenses: Employer taxes
    Payroll liabilities CPP payable, EI payable, income tax payable
    Employee deductions/benefits liabilities RRSP deductions, benefit deductions, and other employee withholdings
    Government remittance liabilities Federal and provincial payroll tax liabilities

    Your payroll reconciliation report should confirm that total debits equal total credits. If they don’t, something was misclassified.

    When payroll reconciliation should be done

    Don’t wait until year-end to reconcile payroll. Build it into your routine. While the CRA doesn’t specify the timing of your reconciliations, many employers follow these best-practice checkpoints to stay on top of payroll records:

    • Every pay period: Catch errors immediately.
    • Monthly: Align totals with CRA remittance cycles.
    • Quarterly: Confirm the cumulative payroll liabilities balance.
    • Year-end: Reconcile before preparing T4 slips and T4 summaries.

    Waiting until year-end increases the chance of scrambling to correct past discrepancies.

    Key considerations when reconciling payroll

    Payroll reconciliation isn’t just about matching numbers. For business owners, it plays a much larger role: understanding how payroll affects your overall financial reporting.

    The three areas you need to focus on:

    1. Verifying transactions: Ensure payroll expenses are posted to the correct accounts, such as wages expense or cost of goods sold, if applicable to your business.
    2. Reconciling against budget: Compare actual payroll spending to planned payroll budgets. Unexpected increases may signal overtime, staffing changes, or classification errors.
    3. Reviewing earnings and registers: Confirm that cumulative earnings, deductions, and company contributions balance across all reports. Your payroll reconciliation report should align with remittance records and your ledger.


    How payroll software helps simplify reconciliation

    Manual spreadsheets and disconnected systems increase the risk of errors. When payroll operates separately from accounting, you may spend extra time manually matching numbers. That can introduce version control issues or missed updates.

    Integrated systems like QuickBooks Payroll connect payroll, accounting, and reporting in real time. 

    The key features that support this integration:

    • Connected payroll and accounting entries
    • Real-time payroll reconciliation reports
    • Automated deduction calculations
    • Year-end T4 support
    • Secure role-based permissions

    For businesses with growing reporting requirements, connected systems can make payroll management in Canada easier, especially when compliance standards are strict.

    Take control of your payroll process

    Payroll reconciliation may feel routine, but it plays a direct role in compliance, accurate reporting, and employee trust. Having consistent review processes can help lower the risk of penalties and provide better visibility into labour costs.

    As your business grows, connected tools that support consistent payroll reconciliation can help keep payroll manageable. Payroll software like QuickBooks does just that, maintaining your payroll, reporting, and cash flow in sync throughout the year to simplify your financial oversight.

    Frequently asked questions

    Disclaimer

    Money movement services are provided by Intuit Canada Payments Inc.

    This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by region, province, state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Intuit does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Intuit does not warrant that the material contained herein will continue to be accurate nor that it is completely free of errors when published. Readers should verify statements before relying on them.

    We provide third-party links as a convenience and for informational purposes only. Intuit does not endorse or approve these products and services, or the opinions of these corporations or organizations or individuals. Intuit accepts no responsibility for the accuracy, legality, or content on these sites.


    Related Articles

    Your privacy

    We collect data when you use our website to improve its performance. Doing so also helps us provide a secure, personalized experience. Select 'Accept cookies' to agree or 'Cookies settings' to choose which cookies we use. You can change your preferences anytime by clicking the 'Manage cookies' link in the footer.

    Choose your cookie preferences

    Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.

    These cookies are necessary for the site to function. They also help us keep your data safe.
    These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
    These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
    These cookies help us provide you with relevant communications and ads in our products and on other sites.

    Looking for something else?

    Get QuickBooks

    Smart features made for your business. We've got you covered.

    Firm of the Future

    Expert advice and resources for today’s accounting professionals.

    QuickBooks Support

    Get help with QuickBooks. Find articles, video tutorials, and more.