Payroll Output & Reconciliation
X-in-X-out reconciliation, guarantee floors, and Workday integration — Phil Step 10
$324K
12
$2,840
2.1 hrs
X-in-X-out Reconciliation
$4.2M commissionable sales flowing through 5 streams to $324K total payout
Payout Flow Breakdown
Guarantee Floor Calculation
hourly_minimum_enforcementWhen commission falls below the hourly minimum, the guarantee floor kicks in automatically
| Associate | Commission Earned | Hourly Guarantee | Floor Applied | Final Payout |
|---|---|---|---|---|
| Sarah Kim | $1,240 | $1,450 | YES | $1,450 |
| Chris Nakamura | $980 | $1,200 | YES | $1,200 |
| Tyler Morrison | $2,100 | $1,400 | NO | $2,100 |
Hours-to-Commission Reconciliation
Selling hours from Workday mapped against commission output — delta determines guarantee eligibility
| Associate | Selling Hours | Hourly Rate | Min Guarantee | Actual Commission | Delta |
|---|---|---|---|---|---|
| Sarah Kim | 80 | $18.13 | $1,450 | $1,240 | -$210 |
| Chris Nakamura | 76 | $15.79 | $1,200 | $980 | -$220 |
| Tyler Morrison | 82 | $17.07 | $1,400 | $2,100 | +$700 |
| Diana Okafor | 78 | $16.67 | $1,300 | $1,850 | +$550 |
| Roberto Diaz | 72 | $16.39 | $1,180 | $1,420 | +$240 |
Note: Negative deltas trigger automatic guarantee floor. Selling hours sourced from Workday time management feed (EIB import).
Payroll Integration Status
Workday IntegrationRecords Processed
3,247
Errors
0
Batch ID
CL-2026-PP04-001
Last Run
Mar 31, 06:00 UTC
Integration Timeline
Commission Calc
T+0
Guarantee Check
T+1hr
EIB Export
T+2hr
Payroll Submit
T+4hr
Payout Distribution by Component
How $324K total payout breaks down across commission streams
Payroll Integrity
The X-in-X-out reconciliation ensures every dollar is traceable from commissionable sale to payroll submission. Guarantee floors are calculated automatically using Workday selling hours, eliminating the manual spreadsheet process that previously required 12 hours of payroll admin time per cycle. EIB feeds are generated in Workday-native format, ready for direct import.