Custom business systems

How Attendance-Based Payroll Works: A Plain-English Guide for Philippine Businesses

Payroll looks simple from the outside: count the days, multiply by the rate, subtract deductions. Anyone who has run payroll for more than a handful of employees knows it is not. This guide walks through how attendance becomes a payslip, where errors usually creep in, and how a system can make the process predictable.

It is written for business owners and HR staff in the Philippines, but most of it applies anywhere.

From clock-in to payslip

Attendance-based payroll is a chain. Each link depends on the one before it:

  1. Attendance records: clock-in and clock-out times for each employee, for each day in the cutoff.
  2. Time computation: hours worked, lates, undertime and overtime, measured against the employee's assigned shift.
  3. Leave: approved paid and unpaid leave, so an absence is not treated as a no-show.
  4. Gross pay: basic pay plus overtime and allowances, minus late and undertime deductions.
  5. Government contributions and tax: SSS, PhilHealth, Pag-IBIG and withholding tax.
  6. Other deductions: loans, cash advances and company-specific items.
  7. Net pay and the payslip.

A mistake early in the chain, such as a wrong shift or a missing clock-out, flows all the way to the payslip.

Where payroll errors creep in

  • Manual time sheets. Handwritten or retyped times are easy to misread and easy to adjust after the fact.
  • Inconsistent rules. One supervisor rounds lates to the nearest 15 minutes and another does not. Without written rules, payroll changes with whoever computes it.
  • Unrecorded leave or overtime approvals. The approval happened in chat but never reached the payroll file.
  • Outdated contribution tables. Government rates and brackets change. A spreadsheet formula written two years ago does not know that.

Treat government contributions as data, not formulas

SSS, PhilHealth, Pag-IBIG and withholding tax are all based on published brackets and rates, and those tables are updated from time to time. The safest design is to store them as editable tables with effective dates instead of hard-coding numbers into formulas. When a new table takes effect, you add it once and every payroll after that date uses it, while past payrolls stay exactly as they were computed.

This is how the Goodly Trading HRIS works: a bracket-based benefit engine covers SSS, PhilHealth, Pag-IBIG, tax and custom deductions. Whatever system you use, always confirm the current rates with SSS, PhilHealth, Pag-IBIG and the BIR before a payroll run.

Capturing attendance you can trust

Payroll is only as good as the attendance behind it. Common options include biometric devices, kiosks and mobile clock-in. In the HRIS, employees clock in at a face-recognition kiosk that matches faces entirely in the browser, so there is no per-scan cloud fee, and field sales agents clock in by GPS with an impossible-travel check that flags locations too far apart to be real.

Face and location data are personal information, so collect them with the employee's knowledge, keep only what payroll needs, and review your obligations under the Data Privacy Act of 2012.

One system, different rules per company

Groups of companies often share owners but not rules: different shifts, benefit settings and payroll cutoffs. A good system keeps each company's settings separate while running on one platform. The HRIS serves six companies this way, each with its own shifts, benefits and payroll rules, and eight role levels so HR, managers and staff each see only what they should.

Verify before you trust it

Before switching over, run the new system side by side with your current method for at least one full cutoff and compare every line. For the HRIS, payroll output was hand-checked line by line before it replaced the old process. That verification habit is a core part of how I work.

Next steps

If your payroll still depends on retyped time sheets, start by writing down your rules for lates, overtime and leave. That document alone will make your current process more consistent. When you are ready to automate it, read when a business needs custom software, see my custom business systems service, or get in touch.