Upload Files for Comparison

The quarterly facility review export from Simple PBJ (e.g., 2026_quarter_2_facility_932930_REVIEW.csv)
The raw timeclock punch export for the same quarter (e.g., RawPunchReport.csv)
Payroll earnings export to verify PBJ hours were actually paid (e.g., payroll_earnings.csv)
What This Tool Does
  • Cleans the REVIEW CSV (removes header rows and termination dates) for Simple PBJ import
  • Compares raw punch hours vs PBJ reported hours vs payroll paid hours per employee per day
  • Flags discrepancies: double lunch deductions, unpaid hours, exempt employees shorted, missing records, and more
  • Downloads cleaned REVIEW CSV and comparison results CSV