Why can't FLEX calculate cash-in-lieu or export to Spectrum?
Opening Cash-in-Lieu Run (/prevailing-wage) shows a placeholder page
instead of a calculator. That's deliberate, not a bug or a missing feature
that slipped through.
What's actually missing
The CIL formula, the method for blending overtime across pay classes, and the exact Spectrum import format all have to come from a working session with payroll before anything computes a dollar figure. These numbers feed certified payroll, so a wrong guess carries real compliance exposure — FLEX shows the open questions rather than a calculator that looks finished but is guessing.
What is built
Everything that doesn't depend on those answers:
- Wage tables (jobs, pay classes, effective-dated base/fringe rates, CSV import/export, change history) — see Jobs & Rates and Change History.
- Hours Review (
/hours-review) — loads an HCSS hours export and matches each line to a wage table entry, bucketing what doesn't match (job not in FLEX, job with no rates, an uncovered classification, hours dated before any rate took effect). It only matches — it never multiplies a rate by hours.
Where to see the open questions
Cash-in-Lieu Run lists the specific questions payroll needs to answer:
the calculation itself (the CIL formula, where "actual benefit cost" comes
from, the OT-across-classes method), the data (which export column
actually carries the classification — the sample HCSS export has it
sitting in a free-text Message field rather than Wage_Code or
Pay_Rate_Code), and the workflow (human review before export, or
straight-through). Nothing here moves until that session happens.
In the meantime, loading the wage tables in Jobs & Rates is real, useful work — it doesn't depend on any of the open questions.