Payroll reconciliation answers a more useful question than whether the monthly total looks reasonable: can the organisation explain how approved employment changes became calculations, payments, statutory settlements and accounting entries? When those records disagree, the difference should have an owner and a documented resolution.
Set up reconciliation as part of the payroll calendar. If it begins only after an employee reports a missing payment, the team is already working backwards under pressure. A consistent monthly routine gives HR and finance a shared record of what was approved, what was paid and what remains open.
Start with the employee population
Compare the payroll register with the active employee list. Verify new starters, leavers, transfers and employees on arrangements that affect pay. Use stable employee identifiers rather than names alone. Similar names, duplicate records and changes in spelling can conceal a mismatch.
For each starter or leaver, check the effective date and approved calculation basis. A person leaving partway through a month may still require an agreed final payment; they should not remain indefinitely on the normal recurring run. Record exceptions rather than removing an employee simply because their status looks unusual.
Explain the movement from last month
Create a bridge from the previous gross payroll to the current one. Show the effect of headcount changes, salary revisions, overtime, bonuses, arrears and reversals separately. This makes a large movement understandable and helps reviewers focus on the items that need evidence.
- Match permanent salary changes to their approvals and effective dates.
- Trace variable pay to authorised timesheets or performance records.
- Check recurring allowances for employees whose assignments have changed.
- Review unusually high, low, zero or negative net payments.
- Confirm that corrections do not repeat an amount already paid.
Reconcile the bank file before release
Compare the number of payments and total net pay in the bank file with the approved register. Check that account changes were independently verified and that rejected or returned transfers from the previous run have been resolved. A matching overall total does not prove that every payment reached the correct person.
Retain the released version of the bank file or an appropriately protected audit record of it. Avoid allowing a reviewer to approve one version while the payment officer uploads another. Where the banking platform supports dual authorisation, align it with the payroll approval responsibilities.
Trace statutory amounts through settlement
For each obligation, compare the register, submitted return and payment receipt for the same period. Keep employee deductions separate from employer contributions where the obligation requires both. Use current KRA guidance and the relevant contribution authority's information when validating calculation settings.
A missing receipt and a calculation mismatch are different problems. The first calls for confirmation that settlement occurred; the second calls for a review of the underlying records and configuration. Treating both as a generic outstanding balance makes resolution slower.
Close the finance ledger
| Record | Compare against | Question to resolve |
|---|---|---|
| Gross earnings | Payroll expense postings | Was the full approved expense recognised? |
| Net pay | Bank settlements and payables | Were all approved payments settled? |
| Deductions and contributions | Statutory liability accounts and receipts | Does the remaining liability have a valid explanation? |
| Corrections | Adjustment approvals | Was the original error reversed correctly? |
Maintain an exception log
Give every difference a reference, amount, explanation, owner and due date. Separate timing differences from errors. A legitimate payment still awaiting settlement needs follow-up, while an incorrect deduction needs correction and, where relevant, an employee explanation. Carry unresolved items into the next review instead of silently resetting the opening balance.
Sign off the final reconciliation with HR and finance, then retain the supporting evidence securely. Repeated exceptions reveal where the upstream process needs improvement. Trinity's Payroll and HR Operations team can help build a practical reconciliation pack and agree the responsibilities around it.
