DEMO data. This page reads the synthetic BOF demo dataset, not live fleet records. It is not LIVE operational or financial authority.
WORKBOOK / NON-AUTHORITATIVE payroll grid. Not Prisma Settlement.status. LIVE holds: /settlements
Settlements — workbook grid
Payroll / settlement rows come from the settlement worksheet in the main Excel workbook (prefers env BOF_SETTLEMENTS_SHEET, then Payroll, then Payroll_Clean, then Vercel_Settlements; default public/data/main-source-v2_enhanced_bof_aligned.xlsx, or override with env BOF_MAIN_SOURCE_XLSX), merged into lib/demo-data.json when you run npm run build:data (or npm run merge:settlements for settlements only). This view reads that JSON. Scroll horizontally for all columns.
Payroll earnings include base earnings, approved backhaul pay, and safety bonuses generated from the Safety & Compliance module.
Total base earnings$25,125.00
Total backhaul pay$807.00
Total safety bonus$925.00
Total gross pay$26,857.00
Total deductions$15,796.74
Total fuel reimb.$270.00
Total net pay$11,060.26
Drivers pending or on hold5
| Photo | Name | Driver ID | Gross pay | Total deductions | Net pay | Status | Pending reason | Base earnings | Backhaul pay | Safety bonus | FICA | OASDI | Federal WH | State WH | SDI | FM leave | Family support | Insurance premiums | Credit union | 401(k) contrib. | HSA/FSA health | Health ins. prem. | Life ins. >50k | Fuel reimb. | 401(k) rate | Settlement ID | Export | Settlement doc | BOF generated | Load proof | Claim / RFID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
 | John Carter | DRV-001 | $2,290.00 | $1,198.64 | $1,091.36 | Paid | N/A | $2,100.00 | $65.00 | $125.00 | $141.98 | $33.21 | $412.20 | $80.15 | $10.31 | $15.11 | $0.00 | $214.92 | $0.00 | $68.70 | $114.79 | $0.00 | $0.00 | $0.00 | 3% | STL-001 | — | — | Summary | 501 (1 blocker) | Claim workspace: load L001 |
 | Maria Lopez | DRV-002 | $2,130.00 | $1,294.36 | $835.64 | Pending | Awaiting Receipts | $1,910.00 | $95.00 | $125.00 | $132.06 | $30.89 | $383.40 | $74.55 | $9.58 | $14.06 | $79.68 | $0.00 | $42.09 | $0.00 | $69.33 | $0.00 | $0.00 | $120.00 | 0% | STL-002 | — | — | Summary | — | — |
 | Alex Kim | DRV-003 | $2,275.00 | $1,419.10 | $855.90 | Paid | N/A | $2,155.00 | $45.00 | $75.00 | $141.05 | $32.99 | $409.50 | $79.63 | $10.24 | $15.02 | $0.00 | $0.00 | $30.98 | $136.50 | $0.00 | $0.00 | $0.00 | $0.00 | 6% | STL-003 | — | — | Summary | 503 (2 blockers) | Claim workspace: load L003 |
 | Priya Patel | DRV-004 | $2,133.00 | $1,454.97 | $678.03 | Pending | Awaiting Receipts | $2,020.00 | $88.00 | $25.00 | $132.25 | $30.93 | $383.94 | $74.66 | $9.60 | $14.08 | $0.00 | $0.00 | $32.58 | $0.00 | $0.00 | $0.00 | $0.00 | $150.00 | 0% | STL-004 | — | — | Summary | — | Claim workspace: load L004 |
 | Kenji Tanaka | DRV-005 | $2,400.00 | $1,315.53 | $1,084.47 | Pending | Load Verification | $2,280.00 | $45.00 | $75.00 | $148.80 | $34.80 | $432.00 | $84.00 | $10.80 | $15.84 | $187.05 | $0.00 | $72.68 | $72.00 | $26.50 | $0.00 | $0.00 | $0.00 | 3% | STL-005 | — | — | Summary | 505 (1 blocker) | — |
 | Marcus Chen | DRV-006 | $2,287.00 | $1,521.40 | $765.60 | Paid | N/A | $2,090.00 | $72.00 | $125.00 | $141.79 | $33.16 | $411.66 | $80.05 | $10.29 | $15.09 | $0.00 | $0.00 | $0.00 | $68.61 | $0.00 | $0.00 | $4.94 | $0.00 | 3% | STL-006 | — | — | Summary | 506 (2 blockers) | Claim workspace: load L006 |
 | Sofia Gomez | DRV-007 | $2,158.00 | $996.48 | $1,161.52 | Paid | N/A | $1,975.00 | $58.00 | $125.00 | $133.80 | $31.29 | $388.44 | $75.53 | $9.71 | $14.24 | $246.60 | $146.97 | $0.00 | $107.90 | $0.00 | $0.00 | $7.04 | $0.00 | 5% | STL-007 | — | — | Summary | — | Claim workspace: load L007 |
 | Liam Smith | DRV-008 | $2,271.00 | $1,427.12 | $843.88 | Pending | Load Verification | $2,165.00 | $81.00 | $25.00 | $140.80 | $32.93 | $408.78 | $79.49 | $10.22 | $14.99 | $0.00 | $0.00 | $45.02 | $0.00 | $0.00 | $111.66 | $0.00 | $0.00 | 0% | STL-008 | — | — | Summary | 508 (1 blocker) | Claim workspace: load L008 |
 | Emma Brown | DRV-009 | $2,234.00 | $1,466.06 | $767.94 | Paid | N/A | $2,110.00 | $49.00 | $75.00 | $138.51 | $32.39 | $402.12 | $78.19 | $10.05 | $14.74 | $67.76 | $0.00 | $0.00 | $0.00 | $24.17 | $0.00 | $0.00 | $0.00 | 0% | STL-009 | — | — | Summary | — | — |
 | Noah Wilson | DRV-010 | $2,157.00 | $892.01 | $1,264.99 | Pending | Safety coaching hold | $2,080.00 | $77.00 | $0.00 | $133.73 | $31.28 | $388.26 | $75.50 | $9.71 | $14.24 | $0.00 | $0.00 | $0.00 | $43.14 | $0.00 | $196.15 | $0.00 | $0.00 | 2% | STL-010 | — | — | Summary | 510 (2 blockers) | Claim workspace: load L010 |
 | Olivia Lee | DRV-011 | $2,148.00 | $1,400.08 | $747.92 | Paid | N/A | $2,010.00 | $63.00 | $75.00 | $133.18 | $31.15 | $386.64 | $75.18 | $9.67 | $14.18 | $50.51 | $0.00 | $0.00 | $0.00 | $47.43 | $0.00 | $0.00 | $0.00 | 0% | STL-011 | — | — | Summary | — | — |
 | Robert Johnson | DRV-012 | $2,374.00 | $1,410.99 | $963.01 | Paid | N/A | $2,230.00 | $69.00 | $75.00 | $142.54 | $33.34 | $413.82 | $80.47 | $10.35 | $15.17 | $0.00 | $0.00 | $48.75 | $45.98 | $22.30 | $148.00 | $2.30 | $0.00 | 2.06% | STL-012 | — | — | Summary | 512 (1 blocker) | Claim workspace: load L012 |