Multi-VMS Payroll Calculator with 50-State Compliance
⨠Enhanced Demo - Now with PDF Support!
Overtime Rules Engine
š All 50 States Supported: This system includes overtime rules for all U.S. states, including special provisions for daily OT (CA, AK, CO, NV) and unique thresholds (KS 46hrs, MN 48hrs).
Employee Management
Employee List
Name
ID
Pay Rate
State
Daily OT Rule
Weekly OT Rule
No employees added
VMS Format Mapper
š§ Smart Column Mapping: Upload a CSV or PDF to see its columns, then drag them to the appropriate fields. The system can match employees by either ID or Name (handles "First Last", "Last, First", or partial matches). Save templates for different VMS systems (Fieldglass, Beeline, etc.)
š
Upload CSV or PDF to map columns
CSV Columns Detected
Drag columns to fields on the right ā
Target Fields
Drop CSV columns here
Saved Templates
Import Timesheets
Accepted Formats:
CSV Files: Employee ID (or Name), Date, Hours columns required
PDF Files: Automatically extracts text and attempts to parse timesheet data
Name formats: Handles "First Last", "Last, First", or partial name matches
Optional columns: PTO Hours, Sick Hours (excluded from OT calculations)
š” Smart Name Matching:
System automatically handles "Alice Johnson", "Johnson, Alice", "ALICE JOHNSON", and partial matches. No need to standardize formats across VMS systems!
ā California Compliance:
CA employees MUST have daily hour breakdowns. PTO/Sick hours should be separate columns.
š
Upload Timesheet CSV or PDF
Supports: Daily totals, Pre-calculated OT, PDF text extraction
Import Preview
0
Time Records
0
Employees
Unknown
Format Detected
ā
Compliance Check
Employee (Matched)
Date
Hours
Type
Calculate Payroll
Calculates Total Gross Pay based on state-specific overtime rules.
Payroll Results
Employee
Regular Hrs
OT/DT Hrs
FLSA HrsOBBBA
PTO/Sick Hrs
Regular Pay
OT/DT Pay
PTO/Sick Pay
Total Gross
Actions
No calculations yet
Daily Breakdown
Date
Day
Worked
PTO/Sick
Regular
OT
DT
Daily Pay
Exception & Compliance Report
š Automated Exception Detection: This report flags potential issues requiring review before finalizing payroll.