Skip to main content
Timeclock and payroll

How pay is calculated

Payroll turns each employee's punches into day, night, Sunday and holiday hours, finds the overtime, prices every kind of hour, then adds allowances and takes off deductions.

Last updated 26 days ago

This page explains what payroll does when a pay period is calculated or recalculated, so you can predict a figure and choose the right settings. It describes the Colombian rules in most detail, because several steps apply only to a Colombian rule group: one whose Country is Colombia.

Before you start: the settings named here live on the employee form, on the rule group and on the employee's schedule. Changing one affects the next calculation, not periods you have already calculated.

From punches to hours

  1. Each clock in is paired with its clock out. The clock out the timeclock recorded against the clock in (its pairing link) is used first. Otherwise a clock in takes the next unused clock out, as long as no other clock in comes in between and the clock out is no more than 24 hours later. A clock in with no clock out is not paid, and a session longer than 24 hours is never paid as one session. The calculation notes on the employee's row then say how many clock ins or clock outs were left unpaired (Punch gaps), so fix those punches in Reconcile and recalculate. A clock in with nothing after it is just a shift that is still open, and a clock out at the very start of the period that ends a shift begun in the previous period is expected; neither is reported as a gap. See The payroll wizard.
  2. Pay is figured from the time between a clock in and the clock out that follows it. Days and times are read in your organization's time zone.
  3. A shift that crosses midnight is cut at midnight into one piece for each calendar day.
  4. Each piece is placed in one of four groups. It is either a weekday or a Sunday or holiday, and either day or night.

The night window comes from the employee's rule group, in Night Shift Start and Night Shift End. If the rule group does not set them, the window is 19:00 to 06:00. The two fields appear on the rule group form when Apply Night Differential is checked. If you clear that box and save, the times are removed and the window is 19:00 to 06:00, which is still used to decide which hours are night hours, for example for the night overtime tiers. A holiday is a date in the Holiday Calendar assigned to the rule group.

Every group is then split again into regular hours and overtime hours, which gives eight kinds of hours in all.

Lunch is measured from the lunch start and lunch end punches between a clock in and a clock out. A single lunch counts for at most 2 hours. Break punches are recorded for information and are not subtracted. The calculation screens show the result in three columns: Time at Work, Lunch/Break and Paid Hours.

Find the overtime

Three settings on the employee form decide which hours are overtime. Overtime Calculation Mode is on the Admin Hub form only.

  • Weekly Hours Threshold, the hours a week before overtime starts. For a Colombian rule group, a threshold that is blank or 40 is replaced by the rule group's default weekly threshold. No form shows that default. It is 42 on a group made with Colombia Template and after the defaults backfill (the ordinary week since July 15, 2026), and 40 on a group you create by hand, where a blank or 40 threshold stays 40. A Colombian rule group that holds no default at all uses the statute's ordinary week for the dates being paid, which is 42 hours from July 15, 2026.
  • Overtime Calculation Mode. Period-Wide (recommended for bimonthly) counts overtime only above the weekly threshold times the number of weeks in the period. Per-Week (FLSA-compliant) measures each Monday-to-Sunday week on its own. A Colombian employee left on Period-Wide is measured per week as well, whatever the field shows, because the rule group's per-week default is on and no form shows that default either.
  • Use Contractual OT Threshold. In Per-Week mode, the weekly threshold becomes the contracted hours of the week: for a Fixed employee schedule the days times the hours a day, for an Alternating one the hours of that week of the rotation, and otherwise the employee's Expected Weekly Hours, or 40 when that is blank.

Lunch time is subtracted before hours are compared with the threshold.

In a Colombian rule group a second test runs as well: hours above 8 in one day, after lunch, are overtime even when the week stays under the threshold. Payroll uses the larger of the two results.

The overtime hours are then spread over the four groups in proportion to the hours worked in each. A long weekday can therefore produce a little Sunday or night overtime. The worked example below shows this.

Price the overtime

Overtime pay is the hours times the hourly rate times the multiplier for that kind of hour. These rates are all-inclusive: the night or Sunday surcharge is not added on top of them.

OvertimeEmployee fieldColombian value
Weekday dayOvertime Multiplier1.25
Weekday nightNight OT Multiplier1.75
Sunday or holiday daySunday Day OT Multiplier (HEDDF)2.15
Sunday or holiday nightSunday Night OT Multiplier (HENDF)2.65

The Colombian values are what the Colombian defaults set for a new employee (the Sunday and holiday rates follow the Sunday surcharge: they were 2.0 and 2.5 before July 2026, and they move again on July 1, 2027). They are ordinary settings that you can change, and they are only set for an employee when someone applies them; see Colombian payroll defaults backfill. The three night and Sunday fields are on the Payroll Employees page, not on the Admin Hub form. Overtime Calculation Mode, Sunday Multiplier, Allow Stacked Multipliers, Calculate pay from salary, Variance Threshold (%) and Variance Threshold (Hours) are on the Admin Hub form only.

If Night OT Multiplier is 0, night overtime uses Overtime Multiplier. If a Sunday overtime multiplier is 0, a Colombian rule group uses the ordinary day or night overtime rate plus the Sunday or holiday surcharge. Elsewhere the Allow Stacked Multipliers setting decides how the rates combine.

Add the surcharges on regular hours

These are added to regular hours only, at the hourly rate:

SurchargeHours it applies toAmount
NightRegular night hours, on weekdays and on Sundays and holidaysNight Differential minus 1
SundayRegular Sunday hours that are not holiday hoursSunday Multiplier minus 1
HolidayRegular hours on a holiday dateThe holiday's multiplier minus 1
  • A multiplier of 1 or less adds no night or Sunday surcharge.
  • The rule group's Apply Night Differential and Apply Sunday Premium switch these two surcharges on or off for the whole group: clear one and the group's employees get no night (or no Sunday) surcharge. Overtime rates and the holiday premium are not affected. A group that was saved before these boxes did anything keeps paying both. The group's Default Sunday Multiplier prices the Sunday surcharge for an employee whose own Sunday Multiplier is 1.0 or lower. Otherwise the employee's Night Differential and Sunday Multiplier set the rates.
  • A worked holiday is surcharged once. It is not also treated as a Sunday.
  • The holiday's multiplier is the one set on the holiday in its calendar, or else the employee's Holiday Multiplier. In a Colombian rule group, a Holiday Multiplier of 1 or less is replaced by the Sunday Multiplier.
  • Overtime hours on a holiday use the Sunday and holiday overtime rates above.
  • Holiday bid premium. When an employee has an approved holiday shift bid with an awarded multiplier, the hours worked inside the bid's shift window are topped up to the hourly rate times that multiplier. Payroll first takes off the night, Sunday and holiday surcharges already paid for the same hours. The calculation notes name each bid. See Holiday calendars and holiday shift bidding.

The hourly rate is the employee's Hourly Rate. When pay is calculated from salary (see below), an employee without an hourly rate uses the Base Salary divided by 240, which is 30 days of 8 hours. For an employee paid from salary, the salary share, the overtime and the night and Sunday surcharges are rounded to whole units in any currency. For hourly pay, amounts in Colombian pesos are rounded to whole pesos.

Pay a salary

When an employee has a Base Salary and the Calculate pay from salary option is checked, regular pay does not come from the punches. The option's full label ends with "(ignore timeclock for pay calculation)". It appears on the Admin Hub employee form once Pay Type is Salary and a Base Salary is entered.

Enter the monthly salary in Base Salary, on either employee form. Payroll treats the figure as a monthly amount.

  • Regular pay is the monthly salary times the days in the period divided by the days in the month. Colombian rule groups use a 30-day month, so a semi-monthly period is 15 of 30 days.
  • An employee hired or terminated during the period is paid only for the days employed.
  • Punches still produce overtime and surcharges, which are added to the salary share, and they are checked against Expected Weekly Hours. When Variance Threshold (%) or Variance Threshold (Hours) is set, hours that differ by more than the threshold raise a variance exception.
  • With Auto-Deduct for Missed Time checked, the salary share is reduced for hours under the expected hours, after approved time off, and never below zero.

Pay approved time off

An employee who is paid by the hour is paid for approved paid time off at their Hourly Rate. Before this was added, a week of approved vacation produced a row of zero for an hourly employee. An employee paid from salary is not paid anything more: the salary already covers those days.

  • Which requests. An approved request that draws on the PTO, Personal or Expiring Time balance. A request on the Unpaid balance is not paid, and neither is a request that is still pending, rejected or canceled. Incapacity leave is not paid here either: it has its own rule, below. A request left without a balance is read as PTO, as it is when it is approved.
  • Leave entries in the Admin Hub. A leave entry is paid on the same terms when it is approved, Paid Leave is checked and its Leave Type is not Unpaid Leave. Its Hours are paid at the hourly rate, and an entry that runs across two pay periods is shared out by calendar day. A day that an approved request already covers is not paid a second time through an entry, so recording the same days both ways pays them once. The exception, in a Colombian rule group only, is an entry whose Leave Type is Sick Leave (or Maternity or Paternity, the other incapacity types an entry can carry): it is not paid as leave at the full hourly rate but follows the incapacity rule below, as an incapacity request does. In any other rule group a checked Sick, Maternity or Paternity entry is paid at the full hourly rate like the other types. Vacation, personal, expiring-time and the other paid types are paid at the full hourly rate everywhere.
  • Shifts the wizard filled in for those days. When a period is paid early, the wizard fills in projected shifts. If leave is approved or added afterwards for a day that already has a projected shift, the projected shift is left out of the calculation and the day is paid as leave only. Real punches on a leave day still count, so a half day of leave with the other half worked is paid for both. Recalculate the employee after you approve or add leave: the preview marks the employee as needing it.
  • How many hours. The Hours on the request, which is what the approval took off the balance. A half day of 4 hours is paid as 4 hours. A request that runs across two pay periods is shared out by calendar day, and the shares add up to the hours of the request, so nothing is lost and nothing is paid twice at the boundary. Leave dated before the employee's hire date or after their termination date is not paid.
  • It is not worked time. Leave never counts toward an overtime threshold, adds no night, Sunday or holiday surcharge and is in none of the worked hours (Hours, Regular Hours, Days Worked). A day of leave is still a day not worked for an allowance such as transport, which is not paid for it.
  • It is salary. The pay is part of Regular Pay and of gross pay. The rules based on gross pay, such as health and pension, are therefore calculated on it, and so are accruals such as Prima and Cesantías.
  • Away for the whole period. An employee with approved leave and no punches at all is still paid the leave.
  • Where you see it. The calculation notes say how many hours were paid and from which balances. The Summary step lists Paid Time Off (in Regular Pay) among an employee's pay components, the Excel workbook has Paid Time Off Hours and Paid Time Off Pay (in Regular Pay) as the last two columns of its Summary sheet and a Paid Time Off line on the employee's tab, and the paystub prints Paid Time Off on its own line, with the Regular Pay line left for the hours worked. If you edit an employee's hours in the Summary grid, the leave pay stays in Regular Pay.

If you used to pay an hourly employee's leave with a manual adjustment, remove that adjustment before you recalculate the period, or the leave is paid twice.

Allowances, deductions and employer costs

The rule group's rules are applied in order:

  1. Allowances first. A rule with Add to gross pay (allowance) checked adds to gross pay. A fixed monthly allowance, such as a transport allowance, is cut to the length of the period. It is then reduced for days not worked. When the employee has an employee schedule with work days, the allowance is the monthly amount times the paid days of the period, less the rostered days missed, divided by the days in the month. A holiday and a day that has not happened yet are never counted as missed. The reduction for days not worked applies only when the employee has clock-ins in the period. Without a schedule that lists work days, payroll assumes a 6-day week in a Colombian rule group, and elsewhere uses the employee's Expected Weekly Hours divided by the schedule's hours a day, or by 8 when there is no schedule.
  2. Deductions and contributions next. A percentage rule based on gross pay uses gross pay minus the allowances marked Exclude from deduction base (IBC), so those allowances stay out of social security bases.
  3. Manual adjustments last. A bonus is added to gross pay and a withholding or loan payment is deducted.

A rule with Salary Conditions applies only when the employee's monthly salary is inside the band. The monthly salary is the Base Salary, or for an hourly employee the hourly rate times 240 in a Colombian rule group and times 160 elsewhere. Progressive brackets, such as the solidarity pension fund, use this.

Net pay is gross pay minus deductions. Burdened cost is gross pay plus the employer-paid costs. See Payroll rule groups.

Incapacity leave

Approved incapacity leave inside the period is priced by the pay percentage stored on the leave request, or 66.67% when the request has none. In the payroll wizard, Add Incapacidad fills that percentage from the type: 100% for Maternity and Paternity, 66.67% for General and Work Related. It refills it when you change the type, unless you have set the percentage yourself, and the request is paid at the figure it shows. What that means depends on how the employee is paid:

  • An employee paid from salary already receives those days in the salary, so for each day of leave payroll takes off the daily rate (the monthly salary divided by 30) times the share not paid. The amount taken off is recorded with the calculation, so editing the row in a grid does not hand it back (a row calculated before this was recorded needs a recalculation first).
  • An employee paid by the hour is not clocked on those days and earns nothing for them, so payroll adds the share that is paid: the days of leave times the employee's day (the Hours Per Day of the schedule, 8 when it states none) times the Hourly Rate times the pay percentage. It is its own line in the calculation notes (Incapacity pay) and on the paystub (Incapacity Pay). The pay is part of Regular Pay, so it is in the contribution base and the accrual bases, and the grids keep it when you edit hours. It is never worked time: it adds no hours, no overtime and no night, Sunday or holiday surcharge.

Incapacity leave is never also paid as paid time off, whatever time-off balance it names. Only the days of the employment count: a request that runs past a termination date, or starts before a hire date, is priced for the days the person was employed.

A day of incapacity is paid once. For an employee paid by the hour, a projected shift on a day of incapacity (one the wizard filled in from the schedule) is left out of the calculation, so the day pays only the incapacity share. For an employee paid from salary the projected shift stays, because it stands in for the hours the reduction is about. Real punches are never left out: if an employee paid by the hour has a full day of real punches on a day of incapacity, they are paid for the hours worked plus the incapacity share (an Admin Hub entry is paid the share of its type: two thirds of a day for Sick Leave, a full day for Maternity or Paternity; a request is paid the percentage it carries, so a Maternity or Paternity request left at its default is a full day, a request at 100% is a full day, and a request at any other percentage is that share of the day). The wizard lists such a day under Paid leave and punches on the same day and holds the period until you resolve it.

In a Colombian rule group, an Admin Hub leave entry of type Sick Leave (or Maternity or Paternity) that is approved (or used) and has Paid Leave checked is treated as incapacity leave, so the same rule applies however the leave is entered. An entry has no pay percentage field, so it is taken at the statutory share of its type: 66.67% for Sick Leave (a general illness; the calculation notes call it General) and 100% for Maternity and Paternity. An entry counts its Hours, not whole days: a 4-hour entry is half a day for an employee paid from salary, and four hours at the share for an employee paid by the hour. Like an incapacity request, it excuses no missed hours of a salaried employee, and for an employee paid by the hour it removes a projected shift on its days. A day that an approved request already covers is not counted again through an entry. If you need a different percentage, enter the leave as Add Incapacidad in the payroll wizard, which asks for it. An entry with Paid Leave left unchecked is neither paid nor reduced. In any other rule group these entries are not incapacity: a checked one is paid at the full hourly rate like any other paid leave entry.

An example in a Colombian rule group: an employee paid 10,000 an hour, with an 8-hour day, works 40 hours and has one day of Sick Leave. Pay is 400,000 for the hours worked plus 53,336 for the day (8 hours x 10,000 x 66.67%), 453,336 in all, more than the same week with no entry. The same day entered for an employee paid 3,000,000 a month takes 33,330 off the salary (100,000 a day x the 33.33% not paid).

Who is calculated

Payroll calculates active employees who were hired on or before the end of the period and who were not terminated before it began. Punches by a HaloPSA agent count only when the payroll employee is linked to that agent. An agent with punches and no linked payroll employee gets no row.

A worked week

Jane is paid by the hour in Colombian pesos at 10,000 an hour. She was set up before the July 2026 changes, so she has the earlier Colombian values: 1.25, 1.75, 2.0 and 2.5 for overtime, 1.35 for Night Differential and 1.75 for Sunday Multiplier. Her weekly threshold is 44 and she took no lunch punches. One week, she works:

DayShiftHoursKind of hours
Monday08:00 to 16:008Weekday day
Tuesday08:00 to 16:008Weekday day
Wednesday08:00 to 18:0010Weekday day
Thursday20:00 to 04:00 on Friday8Weekday night, 4 hours on Thursday and 4 on Friday
Sunday08:00 to 14:006Sunday day
  1. Hours. The week has 26 weekday day hours, 8 weekday night hours and 6 Sunday day hours: 40 in all.
  2. Overtime. 40 hours is under the weekly threshold of 44. Wednesday is 2 hours over 8, so the daily test finds 2 hours. Payroll uses the larger result: 2 overtime hours.
  3. Spread. The 2 hours are spread in proportion to the hours worked. Weekday day takes 26/40, which is 1.3 hours. Weekday night takes 8/40, which is 0.4 hours. Sunday day takes 6/40, which is 0.3 hours. The regular hours left are 24.7, 7.6 and 5.7: 38 in all.
  4. Pay.
LineHoursCalculationPay in COP
Regular pay3838 × 10,000380,000
Weekday day overtime1.31.3 × 10,000 × 1.2516,250
Weekday night overtime0.40.4 × 10,000 × 1.757,000
Sunday day overtime0.30.3 × 10,000 × 2.06,000
Night surcharge7.67.6 × 10,000 × 0.3526,600
Sunday surcharge5.75.7 × 10,000 × 0.7542,750
Gross pay478,600

The rule group's allowances and deductions are then applied to this gross pay. The employee's gross pay, deductions, net pay and cost per employee appear in the preview and summary steps of the wizard and in Pay periods.

Projections run the same calculation

A payroll projection is not a separate estimate. It runs the steps on this page over the punches, or over shifts built from the employee's schedule, for each pay period the range touches, and shows the result without saving anything. The same punches, rules, approved leave and settings therefore give the same gross pay, deductions, employer costs and burdened cost in a projection and in the calculated period, including the approved paid time off an hourly employee is paid. A projection leaves out what only a real period has: the manual adjustments, and the punch exceptions and balances a calculation writes. Accruals such as Prima and Cesantías go to a balance in both, so a projection shows them in their own column and keeps them out of the employer costs and the burdened cost.