Timesheets to payroll

Converts time records into regular, overtime, and PTO hours, then calculates gross pay for each employee

How it works

Upload a completed payroll register

The shift-level detail and employee-level register submitted to payroll
Add the source files

Raw time entries, the approved time-off export, the employee master with rates, and the payroll rules
Skipper learns the payroll calculation rules

How unpaid breaks are deducted, how hours are rounded, whether overtime is calculated daily or weekly, and what qualifies a shift as an exception
Upload the new time entries each period

Skipper rebuilds the register, lists exceptions for review, and formats the upload to the payroll provider’s requirements

time_entries_202X-06-15_to_202X-06-28.xlsx Clock-in time, clock-out time, break minutes, and job code, with one row per shift
approved_pto_202X-06-15_to_202X-06-28.xlsx Approved time off falling within the same pay period
employee_master.xlsx Department, location, hourly rate, and payroll ID
payroll_rules.xlsx Rounding increment, overtime threshold, and effective dates

payroll_register_202X-06-15.xlsx

Summary Hours and gross pay by department, with the exception count
Time Detail Each shift with raw and rounded hours, the regular and overtime split, and any exception
Payroll Upload Regular, overtime, and PTO hours, hourly rate, and gross pay for each employee
Checks Reconciliation of hours and pay to the source time records