Payroll Reconciliation Checklist: Compare Time Records, Payroll Reports, and Bank Payments
payroll reconciliationpayroll auditspayroll errorspayroll approvalspayroll recordkeeping

Payroll Reconciliation Checklist: Compare Time Records, Payroll Reports, and Bank Payments

PPayrolls.online Editorial Team
2026-11-07
6 min read

Use this payroll reconciliation checklist to compare time records, payroll reports, accounting entries, and bank payments before and after payday.

Payroll reconciliation is the process of comparing approved time records, payroll calculations, accounting entries, and actual bank payments. This payroll reconciliation checklist gives small businesses a repeatable pre-payday and post-payday workflow for finding differences in hours, pay rates, deductions, taxes, reimbursements, and payment totals before they become recurring problems.

Overview

A payroll run should produce the same financial story across several records. The approved timesheet or attendance record explains how employees were paid. The payroll report explains the calculation. The accounting or payroll journal explains how the cost was recorded. The bank statement confirms what actually left the business account.

Reconciliation does not mean that every total will appear in the same format. Gross pay, deductions, employer costs, net pay, and bank withdrawals are different measures. The purpose is to confirm that each amount has a reasonable explanation and that the records agree where they should.

Use this workflow for every pay run, whether payroll is processed weekly, biweekly, semimonthly, or monthly. A small business payroll spreadsheet template can help you record the pay period, report totals, reviewer, exceptions, correction status, and approval date. Keep the reconciliation record with the payroll documentation rather than relying only on an email or memory.

Before starting, define the comparison period and gather the relevant records:

  • Approved timesheets, attendance records, PTO entries, and overtime approvals.
  • Employee and contractor payment records, where applicable.
  • The payroll register or payroll summary for the same pay period.
  • Pay stubs or employee earnings detail for unusual or corrected payments.
  • Payroll tax, benefit, garnishment, and other deduction reports.
  • Reimbursement or expense approvals.
  • The payroll journal or accounting entry.
  • The bank statement, payment confirmation, or payment settlement report.

For employee pay statement requirements and useful review fields, see the Pay Stub Template Guide.

What to track

1. Employee-level inputs

Start with the records that drive the calculation. For each worker, compare approved regular hours, overtime, holiday or special hours where applicable, PTO, unpaid time, pay rate, and any authorized changes. Check that the worker appears in the correct pay group and that the pay period dates match the source records.

Do not treat a changed total as an automatic error. A difference may be valid if an employee joined or left during the period, changed rate, used PTO, received a bonus, or had a correction from a previous run. The reviewer should record the reason and the approving person.

2. Payroll report totals

Capture the following totals from the payroll report:

  • Total gross wages and the number of paid workers.
  • Regular, overtime, PTO, bonus, commission, and other earnings categories.
  • Employee deductions, including benefits, retirement contributions, garnishments, or other authorized items.
  • Employer costs shown by the payroll system.
  • Total taxes or withholdings reported by the system.
  • Total net pay and any separate payment batches.

Compare current figures with the prior comparable payroll run, but use the comparison as an investigation prompt rather than a pass-or-fail rule. A larger payroll may reflect hiring, seasonal hours, or a one-time payment.

3. Payroll-to-bank amounts

Match each expected payment batch to the bank activity. Depending on the workflow, this may include employee direct deposits, printed checks, tax payments, benefit payments, reimbursement payments, and payroll service debits. Record the expected amount, actual amount, transaction date, reference or batch identifier, and status.

The bank amount may not equal net pay because a provider can combine fees, tax withdrawals, or other items in a separate transaction. Reconcile each component to a payroll report or approved invoice so that the difference is explained rather than ignored.

4. A practical variance log

Use a simple variance report with these columns:

FieldWhat to record
Pay periodStart and end dates, plus pay date
AreaHours, rate, deduction, tax, reimbursement, journal, or bank payment
ExpectedAmount or detail from the approved source
ProcessedAmount or detail in the payroll report
DifferenceCalculation of the variance
ReasonConfirmed explanation or investigation note
Action and ownerCorrection, follow-up, and responsible person
StatusOpen, approved, corrected, or carried forward

Keep sensitive payroll files access-controlled. A reconciliation log should identify the issue clearly without exposing more personal information than the reviewer needs.

Cadence and checkpoints

Before payroll is submitted

  1. Confirm the pay period, pay date, and employee population.
  2. Collect approvals for timesheets, overtime, PTO, bonuses, commissions, and reimbursements.
  3. Compare hours and rates with the source records.
  4. Review new hires, terminations, leave changes, and compensation changes against the related personnel documentation.
  5. Check unusual deductions, negative net pay, duplicate earnings, missing employees, and unexpected employees.
  6. Run a preliminary payroll report and compare gross pay, deductions, taxes, employer costs, and net pay with expectations.
  7. Document exceptions and obtain approval before submission.

This is the point to stop and investigate a material or unexplained difference. Submitting first and asking questions later can make corrections harder to trace.

After payroll is submitted

  1. Save the final payroll register, reports, approvals, and correction notes.
  2. Confirm that payment batches were accepted and identify failed, rejected, returned, or held payments.
  3. Compare the final payroll totals with the accounting entry or payroll journal.
  4. Match bank transactions to expected employee, tax, benefit, reimbursement, and fee payments.
  5. Review any post-submission adjustment and link it to the original pay run.
  6. Close the reconciliation only when every material variance has an explanation, owner, and status.

At month-end, summarize open items by pay period and confirm that payroll costs posted to the correct accounting categories. At quarter-end and year-end, include the reconciliation in the broader compliance review. The Payroll Compliance Checklist for Small Businesses can help place pay-period controls alongside recurring quarterly and year-end tasks.

How to interpret changes

A payroll variance report is useful only when it leads to a specific question. Review differences by category instead of looking only at the final total.

PatternQuestions to ask
Hours changedWas a timesheet edited, PTO approved late, or overtime entered twice?
Gross pay changedDid a rate, bonus, commission, classification, or worker status change?
Net pay changedDid a deduction, benefit, garnishment, tax setting, or one-time payment change?
Employer cost changedDid payroll-related costs rise with wages, or is an item posted in the wrong category?
Bank amount differsIs there a separate fee, tax debit, rejected payment, or combined transaction?
Accounting balance differsWas the journal posted in the correct period and with the correct payroll totals?

Classify each issue as a source-data error, calculation issue, payment issue, accounting issue, or expected business change. Then retain evidence: the approved timesheet, change request, payroll report, bank reference, or correction confirmation. Avoid overwriting the original record. A dated correction log preserves the audit trail and shows what changed, why it changed, who approved it, and when it was resolved.

For contractors, keep the reconciliation separate from employee payroll while connecting it to the same payment-control process. Check that the invoice was approved, the payment amount matches the invoice, and the payment is recorded for year-end reporting review. The Contractor Payment Workflow Template covers the supporting steps from documentation through payment records.

When to revisit

Use the checklist every pay period and review the process at least monthly. A monthly review should identify repeated variances, late approvals, frequent manual corrections, and bank transactions that are difficult to match. If the same issue appears more than once, update the workflow or spreadsheet rather than treating it as a normal exception.

Revisit the checklist immediately when you change payroll software, pay frequency, bank accounts, benefit deductions, approval roles, accounting categories, or employee-data processes. Also review it when you add a new type of compensation, reimbursement, contractor payment, or payment method. The process should reflect the reports your current systems actually produce.

At quarter-end and year-end, use the closed pay-period reconciliations to support broader payroll reviews. Confirm that open corrections are resolved, failed payments are followed up, and records are retained according to your internal policy and applicable requirements. The Year-End Payroll Checklist provides a separate framework for year-end forms and reconciliations.

To put this into practice, create one reconciliation record for the next pay run. Assign a preparer and reviewer, complete the pre-submit checks, save the final reports, match the bank activity after payment, and close every exception with a documented explanation. Consistent repetition is what turns payroll reconciliation from a last-minute inspection into a reliable compliance control.

Related Topics

#payroll reconciliation#payroll audits#payroll errors#payroll approvals#payroll recordkeeping
P

Payrolls.online Editorial Team

Payroll and Operations Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.