The process has six steps: define pay rules, close the attendance period, resolve exceptions, convert attendance into payable values, add allowances and deductions, then preview and finalize payroll.
What is attendance-based payroll?
Attendance-based payroll is a method of calculating employee pay directly from attendance records. Check-in and check-out times, approved leave, absences, late arrivals and overtime determine how many days or hours are paid in each pay period.
When attendance and payroll are managed in separate tools, someone has to export attendance totals, check them and type them into a payroll sheet. This manual handoff is where most payroll errors start. A connected process removes the handoff, so approved attendance becomes a direct input to payroll.
Why does manual payroll take so long?
Most of the time spent on payroll goes into preparing data rather than calculating pay.
Task | Why it slows payroll down |
|---|---|
Collecting data | Attendance, leave and overtime are stored in different places |
Fixing gaps | Missing check-outs and unrecorded leave need to be investigated |
Re-entering totals | Figures are copied by hand from one tool to another |
Correcting payslips | Errors found after payment need adjustments in the next cycle |
Each of these tasks becomes shorter, or disappears, when attendance feeds payroll directly.
What data does payroll need from attendance?
Before payroll can run from attendance, these records must be complete and approved for the pay period:
Attendance data | How payroll uses it |
|---|---|
Days present | Confirms the days to be paid |
Approved paid leave | Counts as paid days and reduces leave balances |
Unpaid leave and absences | Deducted from pay at the daily or hourly rate |
Late arrivals and early exits | Applied according to company policy |
Overtime hours | Added to gross pay at the agreed overtime rate |
Public and company holidays | Paid days that are not counted as absences |
Working days in the month | Used to calculate the daily rate |
How to run payroll from attendance data in 6 steps
Step 1: Define your pay rules
Payroll can only use attendance data correctly if every attendance event has a clear rule. Document the following in your HR policy and payroll settings:
Working days: whether monthly salary is divided by working days or calendar days
Shifts and grace time: shift start times and the number of minutes before an arrival counts as late
Leave types: which leave is paid or unpaid, and the annual quota for each type
Late arrivals: whether repeated lates affect pay, leave balance or neither
Overtime: who is eligible, how it is approved and the rate it is paid at
Holidays: which public and company holidays are paid
Step 2: Close the attendance period
Set a fixed cut-off date for each pay period. After the cut-off, attendance for that period is reviewed and locked, and any later changes move to the next cycle. A cut-off prevents attendance figures from changing while payroll is being processed.
Step 3: Resolve attendance exceptions
Clear every gap in the attendance record before payroll uses it:
Missing check-ins or check-outs: employees submit a correction request and managers approve or reject it
Pending leave requests: every request for the period is approved or rejected
Late arrivals and early departures: confirm they are accurate before rules are applied
Work from home days: confirm they are recorded according to policy
The result should be a complete attendance summary for each employee showing days present, absent, on leave, late and overtime.
Step 4: Convert attendance into payable values
Apply the pay rules from Step 1 to the approved attendance summary to calculate:
Paid days: days present plus paid leave plus paid holidays
Unpaid days: unapproved absences and unpaid leave
Overtime pay: approved overtime hours multiplied by the overtime rate
Policy adjustments: the agreed effect of late arrivals or early exits
For salaried employees paid by working days, the daily rate is calculated as:
Daily rate = Monthly salary ÷ Working days in the month
Unpaid days are deducted at the daily rate. Overtime is usually paid on an hourly rate derived from the daily rate.
Step 5: Add allowances, deductions and requests
Attendance determines part of the payslip. Add the remaining items for the period:
Allowances and bonuses
Income tax based on applicable tax rules
Provident fund or pension contributions, where they apply
Loan instalments and salary advances
Leave encashment and approved salary changes
Collect advance salary and loan requests through a form with an approval step, so approved amounts are already recorded when payroll runs.
Step 6: Preview, finalize and pay
Review a payroll preview before finalizing. Check:
Employees whose net pay changed significantly from the previous period
New joiners and leavers with partial months
Unusually high overtime or unpaid-day totals
Once the preview is correct, finalize payroll, issue payslips and send payment instructions to the bank. Store the attendance summary with the payroll records so any payslip can be explained later.
How to calculate salary from attendance: an example
The example below uses illustrative figures for a salaried employee paid by working days. Actual rules for overtime, lates and deductions depend on company policy and local labor law.
Inputs for the month
Item | Value |
|---|---|
Monthly salary | $3,000 |
Working days in the month | 22 |
Days present | 19 |
Approved paid leave | 2 days |
Unapproved absence (unpaid) | 1 day |
Approved overtime | 6 hours at 1.5× the hourly rate |
Standard working day | 8 hours |
Calculation
Item | Calculation | Amount (USD) |
|---|---|---|
Monthly salary | 3,000.00 | |
Daily rate | 3,000 ÷ 22 | 136.36 |
Unpaid absence | 1 day × 136.36 | -136.36 |
Overtime | 6 h × (136.36 ÷ 8) × 1.5 | +153.41 |
Adjusted gross pay | 3,017.05 |
Tax, provident fund, loan instalments and other deductions are then applied to the adjusted gross pay to calculate net pay. Every figure in the calculation traces back to an approved attendance record, which makes payslips easier to verify.
How Work Mentor connects attendance and payroll
Work Mentor manages attendance, leave and payroll in one platform, so attendance data does not need to be exported or re-entered.
Payroll step | What Work Mentor provides |
|---|---|
Pay rules | Attendance settings for shifts, holidays, working days, leave types and yearly leave quotas; payroll settings for salary division, payslip items, tax rules and provident fund |
Attendance capture | Check-in from a laptop, phone or tablet, with an attendance register showing check-in and check-out times, working hours, breaks, late minutes and overtime |
Exceptions | Attendance correction requests and leave requests that managers approve or reject from the dashboard |
Policy automation | Workflow rules that act on attendance patterns, such as deducting leave or sending a notification after a set number of late check-ins |
Monthly review | An attendance summary showing present, absent, late, early departures, leave, work from home and overtime for each employee |
Payroll run | Payroll preview by month and employee, payslips and bank transfer letters, plus advance salary, loan, leave encashment and salary change requests |
Payroll features vary by plan. See Work Mentor pricing for details.
Common mistakes to avoid
No attendance cut-off date. Attendance that can change at any time means payroll never fully closes.
Filling attendance gaps from memory. Unverified corrections are the most common cause of payslip disputes.
Unwritten pay rules. Rules that are not documented are applied inconsistently each month.
Skipping the payroll preview. Large changes in net pay are easier to correct before payment than after.
Re-entering attendance totals between tools. Every manual copy adds a new opportunity for error.
Attendance-to-payroll checklist
Use this checklist each pay period:
Pay rules for working days, leave, lates, overtime and holidays are documented
The attendance period is closed on a fixed cut-off date
Missing check-ins and pending leave requests are resolved
Approved attendance is converted into paid days, unpaid days and overtime
Allowances, tax, provident fund, loans and other items are added
Payroll is previewed, finalized and stored with the attendance summary
Related guides
From Timesheet to Paycheck to Invoice: how approved hours feed payroll and client billing
Tracked Hours to Client Invoices: the billing side of the same process
Employee Attendance Management: The Complete Guide for SMBs: how to keep attendance records accurate
Run payroll from approved attendance. Work Mentor connects attendance, leave and payroll in one workspace. Start with Work Mentor
