Free CSV template

Payroll liability reconciliation

Each payroll liability account, its movement, and what its balance should be: the fastest place to find a missed remittance or a misposted pay run.

Download template

Editable CSV · No email required

Payroll liability reconciliation
1account · opening balance · charged this period
22210 Income Tax Withheld · ·
32220 CPP Payable · ·
42230 EI Payable · ·
52200 Net Pay Payable · ·
62400 Employer Health Tax Payable · ·
Inside the template

Made for the actual work.

  • Opening, charged, remitted and closing for each liability
  • The expected shape of each balance, so a wrong one is obvious
  • Cross-checks for the three most common posting errors

A note on using it

This is a starting point, not a standard. Every business has something in it that does not fit a generic template, and the version worth keeping is the one you have edited. If a line does not answer a question you actually ask, delete it.

Make room for what's next

Clear books. A clearer head.

30-day trial. Card required. Cancel before the first charge.

Try comma