Roster Checks Browser-only processing
← All reports

Payroll

Payroll Checks

Review Authorised timesheets for breaks, missing comments or actual times, long shifts and minimum shift lengths. Timesheets with zero net hours are excluded from all checks.

  • Over 6 net hours requires a 30-minute break; over 10 requires 60 minutes.
  • Over 10 net hours requires a comment and actual start, end and length. Employee codes containing C are exempt from the actual start, end and length check.
  • Events containing Agency usage require an employee code containing C.
  • Employee codes containing C must have both Event and Function filled in, regardless of shift length, except when the profile contains CONTRACT.
  • Every timesheet over 12 net hours is flagged.
  • ORDINARY HOURS with Sick in Comments and no actual start, end or length are flagged for shift-type review, except for employee codes containing C.
  • If an employee's combined Authorised net hours across the imported file exceed 76 and they have SICK or LEAVE timesheets, one combined alert is shown per employee code.
  • MEETING requires Area MEETING; TRAINING requires Area TRAINING.
  • For MEETING and TRAINING below 1.5 net hours, extend Pay_End by the hours needed to reach 1.5. Flag if that extended interval overlaps another Authorised timesheet for the same employee on the same start date. A preceding shift ending at the activity's start does not conflict.
  • MEETING and TRAINING of 1.5 net hours or greater only flag actual overlaps. ORIENTATION retains the 30-minute gap check. Touching boundaries do not count as overlaps.
  • FT&PT shifts below 3 hours and Casual shifts below 2 hours are flagged, unless adjacent Authorised shifts for the same employee on the same day exceed that minimum combined.

Minimum-hours checks and adjacent-shift totals include Shift_Type equal to ORDINARY HOURS or containing LEAVE or SICK. Adjacent shifts have a gap from 0 to less than 15 minutes between pay times. Hours use Net_Length (Sum); breaks use Unpaid_Breaks_Length (Sum), where 0.5 = 30 minutes. Other statuses are excluded.

Private by design: your spreadsheet stays in this browser tab. Nothing is saved to a database or uploaded.
Required columns

Status, Employee_Code, Employee, Location, Role, Profile, Shift_Type, Area, Pay_Start (Date-Hour-Minute), Pay_End (Date-Hour-Minute), Actual_Start_Time (Date-Hour-Minute), Actual_End_Time (Date-Hour-Minute), Actual_Length (Sum), Event, Function, Net_Length (Sum), Unpaid_Breaks_Length (Sum), Comments