Final settlement on exit
Needs reviewExit 2026-09-11: salary prorated to exit date; loan balance deducted $200.00 (cap $200.00); $600.00 still owed, settle outside payroll
6 items need your review. Every decision re-runs payroll and is kept with the period, so it survives re-runs.
Payroll cannot be finalized until the input is fixed and payroll is re-run.
None.
A person decides. Approve as is, or approve with a corrected value.
Exit 2026-09-11: salary prorated to exit date; loan balance deducted $200.00 (cap $200.00); $600.00 still owed, settle outside payroll
Loan installment $400.00 exceeds cap $276.00 (20% of $1,380.00); deducted $276.00, $124.00 carried to next period (balance after: $1,724.00)
Store A row 37 (1002, 2026-09-09, 9:6O, IN, Checkout): Time "9:6O" can't be read. "O" is a letter, not the digit 0. Minute 60 doesn't exist: minutes run from 00 to 59. Paid 8.00 h from the remaining punches; confirm the unreadable punch was not a real break or extra shift.
Time 9:6O can't be read:
Expected format: HH:MM
EmpID=1002, Date=2026-09-09, Time=09:00, Type=IN, Dept=Checkout
EmpID=1002, Date=2026-09-09, Time=17:00, Type=OUT, Dept=Checkout
EmpID=1002, Date=2026-09-09, Time=9:6O, Type=IN, Dept=Checkout
IN at 09:00 at Store A with no OUT. Counted as 0.00 h. Scheduled 09:00-17:00 (8.00 h): suggested 8.00 h
EmpID=1003, Date=2026-09-10, Time=09:00, Type=IN, Dept=Stockroom
3 punches: 09:00, 13:00, 13:30. Looks like a lunch break and a missed clock-out. Suggested 7.50 h, using the scheduled end of 17:00.
employee_code=RV-202, punch_datetime=09/09/2026 09:00 AM, department=Checkout
employee_code=RV-202, punch_datetime=09/09/2026 01:00 PM, department=Checkout
employee_code=RV-202, punch_datetime=09/09/2026 01:30 PM, department=Checkout
Scheduled at Store B ($16.00/h) but clocked in at Store A ($17.00/h). Paid at Store A's rate by default. Difference for this shift: $8.00.
EmpID=1010, Date=2026-09-16, Time=09:00, Type=IN, Dept=Floor
EmpID=1010, Date=2026-09-16, Time=17:00, Type=OUT, Dept=Floor
Decided by a reviewer. Decisions survive re-runs; undo to reopen an item.
None.
Settled automatically by a rule in the rules file. Shown for the record.
Absent, leave record: sick leave (paid per rules)
Resolution: Paid $124.00 leave
Absent, leave record: unpaid leave (unpaid per rules)
Resolution: No pay change
Week 1: $90.00 add-on in regular rate raised weighted rate $15.00 -> $17.00; OT premium on 5.00 h $37.50 -> $42.50 (+$5.00)
Resolution: OT premium recalculated
Week 2: different store rates; OT premium on weighted rate $16.55 (unrounded in the premium) = $33.09
Resolution: Weighted average regular rate
Retirement contribution (percent_of_gross) applied to 18 employees, total $734.00
Resolution: Rate/table from rules file
Company deduction table (table_lookup) applied to 18 employees, total $272.57
Resolution: Rate/table from rules file
IN at 09:01 (row 21) repeats 09:00 (row 20) within 2 min
Resolution: Kept first punch (row 20), dropped row 21
EmpID=1002, Date=2026-09-08, Time=09:00, Type=IN, Dept=Checkout
EmpID=1002, Date=2026-09-08, Time=09:01, Type=IN, Dept=Checkout
Advance installment $150.00 deducted (balance after: $300.00)
Resolution: Installment from loans_advances.csv
Week 1: Store A 32.00 + Store B 12.00 = 44.00 h, 4.00 h over 40.00
Resolution: Hours combined across stores
Week 2: Store A 32.00 + Store B 12.00 = 44.00 h, 4.00 h over 40.00
Resolution: Hours combined across stores
Hired 2026-09-09: salary prorated to 8 scheduled working days = $1,600.00
Resolution: Prorated by scheduled working days
Shift 2026-09-11 22:00 to 2026-09-12 06:00 (8.00 h) crosses midnight
Resolution: Counted as one shift on 2026-09-11
EmpID=1004, Date=2026-09-11, Time=22:00, Type=IN, Dept=Stockroom
EmpID=1004, Date=2026-09-12, Time=06:00, Type=OUT, Dept=Stockroom
Shift 2026-09-13 22:00 to 2026-09-14 06:00 (8.00 h) crosses midnight
Resolution: Counted as one shift on 2026-09-13
EmpID=1005, Date=2026-09-13, Time=22:00, Type=IN, Dept=Checkout
EmpID=1005, Date=2026-09-14, Time=06:00, Type=OUT, Dept=Checkout
Shift 2026-09-20 22:00 to 2026-09-21 06:00 (8.00 h) crosses midnight
Resolution: Counted as one shift on 2026-09-20
employee_code=RV-203, punch_datetime=09/20/2026 10:00 PM, department=Stockroom
employee_code=RV-203, punch_datetime=09/21/2026 06:00 AM, department=Stockroom
These don't change anyone's pay. They're here so you can follow up with the employee.
E07 Harper Lane: absent Thu Sep 17 with no notice and no leave record. One day's pay deducted ($220.00).
E02 Blake Moreno: clocked in 09:30 on Mon Sep 14, 30 minutes after the 09:00 start (grace 10 min).
Resolution: No penalty: attendance penalties are off
EmpID=1002, Date=2026-09-14, Time=09:30, Type=IN, Dept=Checkout
E01 Avery Holt worked 3.5 of 9 scheduled hours on Wed Sep 9. Pay not reduced: partial-day absences can't be deducted from exempt salaried pay. Worth a conversation, or recording it against paid leave.
Resolution: No deduction: exempt salaried pay
EmpID=1001, Date=2026-09-09, Time=08:00, Type=IN, Dept=Floor
EmpID=1001, Date=2026-09-09, Time=11:30, Type=OUT, Dept=Floor