Match people and records
Compare the active employee list with attendance using employee IDs and device PINs. Confirm joining dates, salary changes and reporting lines with HR; track unmatched IDs as mapping issues rather than assuming absence.
HR operations guide
A practical attendance-to-payroll reconciliation checklist
Review attendance exceptions, employee IDs, approved leave and work calendars before checking payroll inputs and issuing salary slips.
Use this checklist to reconcile the employee, attendance record, date and policy behind each payroll input. A complete device export is a source record, not a completed payroll review. Keep a redacted copy of the source month and assign an owner to every exception.
A practical attendance-to-payroll reconciliation checklist
Use this checklist to reconcile the employee, attendance record, date and policy behind each payroll input. A complete device export is a source record, not a completed payroll review. Keep a redacted copy of the source month and assign an owner to every exception.
Resolve attendance exceptions
Review missing arrivals or departures, duplicate uploads and manual entries with the source owner before changing a daily record.
Verify leave
Check approved leave against the employee, working date and configured allowance. Keep pending requests visible to the approver before closing the month.
Confirm calendar inputs
Verify working weekends, office hours and monthly late grace. Compare the payroll preview using the selected work calendar; do not assume a fixed 30-day divisor.
Review and approve
Accounts compares the preview with the reviewed source month and documents differences. OPleo can apply workspace-configured progressive annual tax brackets to estimate monthly withholding; validate the tax year, jurisdiction, exemptions and statutory deductions with the responsible tax reviewer. Validate overtime premiums and piece rates separately; issue salary slips only after an owner accepts the inputs. Issuing a slip does not transfer money.
Start with the same employees and month
Choose the organisation and payroll month. Compare the active employee list with the attendance source using employee IDs and device PINs, rather than names alone. Check joining dates, salary changes and reporting lines with HR. Preserve a redacted source copy for the review.
Create an exception list with employee ID, date, source, discrepancy, responsible reviewer and resolution. A terminal entry without a mapped employee is a mapping issue; it does not establish that a different employee was absent.
Resolve attendance and leave exceptions
Compare working dates with recorded attendance. Investigate missing arrivals, departures, duplicate uploads and manual entries. Ask the source owner to establish what happened before changing a daily record.
Check approved leave against the correct employee, working date and allowance. A message saying leave was approved should be reconciled with the actual request record. Keep pending requests visible to the leave approver before closing the month.
Check the calendar before comparing net pay
Confirm working Saturdays and Sundays, office hours and monthly late grace. OPleo derives daily and hourly rates from the selected working calendar. Comparing a calendar-based preview with a sheet using a fixed 30-day divisor can produce a difference even when attendance agrees.
Illustrative arithmetic: PKR 90,000 divided by 26 working days gives PKR 3,461.54 per day. One unpaid day would leave PKR 86,538.46 before other adjustments. This example assumes the day is unpaid; approved leave must first be checked against policy.
Close the review with a named owner
Accounts should compare the preview with the reviewed source month and explain each difference. OPleo can apply configured progressive annual tax brackets to estimate withholding, but the workspace owner must supply the correct jurisdiction and tax-year schedule and a qualified reviewer must confirm exemptions and legal treatment. Record unresolved specialist adjustments separately. Overtime premiums, piece rates and other statutory deductions need explicit validation.
Issue salary slips after the reviewer accepts the inputs and calculation. Creating a slip does not transfer money. Retain the source and review decision under your record policy, and agree how a later correction will be communicated.
Overtime pay estimate from user-supplied inputs; not an OPleo capability →
Questions about hr operations guide
Who owns reconciliation?
HR owns employee and leave data, the attendance owner resolves source exceptions, and accounts reviews the final payroll calculation. Name those people before the cutoff.
Can a correct attendance percentage prove payroll is correct?
No. A percentage does not validate salary, calendar, leave allowance, late grace or specialist pay adjustments.
Bring your real workflow to the demo
Use a redacted example, your attendance setup and the decisions your team needs to make. We can review fit before you move live records.
Book a workflow demo