Multi-VMS Payroll Calculator with 50-State Compliance & OBBBA Tax Tracking
✨ 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).
🇺🇸 OBBBA Compliance (2025)NEW
One Big Beautiful Bill Act: New federal law allows workers to deduct FLSA-mandated overtime premium from their taxable income at year-end. This tool tracks which overtime qualifies:
FLSA-Qualifying OT: Hours worked over 40/week (federal threshold) - Premium is tax deductible up to $12,500/$25,000
Non-Qualifying OT: State daily OT that doesn't exceed 40 hrs/week (e.g., CA employee works 10hrs Mon, 6hrs Tue-Thu = 34hrs total) - NOT tax deductible
Important: Overtime is still subject to normal withholding during payroll. The deduction is claimed on the employee's tax return. Employers must report the qualified premium separately on W-2 Box 14. PTO/Sick time is excluded from OT calculations but included in gross pay.
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 with separate tracking of FLSA-qualifying overtime for OBBBA tax reporting.
Payroll Results
🇺🇸 OBBBA Tax Summary (2025)
Total FLSA-Qualifying Premium Pay:$0.00
What this represents: The 0.5x premium portion of overtime hours worked beyond 40/week (FLSA threshold). This overtime was subject to normal tax withholding during payroll. W-2 Reporting: Report this amount separately in Box 14 as "FLSA OT Premium" so employees can claim the deduction on their tax return. Employee Tax Benefit: Workers can deduct this from taxable income (up to $12,500 individual / $25,000 joint filing) when filing their Form 1040. Note: This is a year-end tax deduction, not a payroll withholding exemption. Employees who want less tax withheld during the year must file a new W-4.
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.