CO-004 Cost Incurred vs. Deduct Reconciliation

Job 565 — South Elm Street Widening | City of Jenks | CO #004 (-$442,467.24)
Job 565
Step 1 — Drop JCCostEstCT File
📂 JCCostEstCT — Job 565
Drop .xlsx, .csv, or .rpt — auto-detects budget & actual columns
Drop file here or click to browse
What this tool does:
1. Reads your JCCostEstCT file
2. Matches each of the 40 CO-004 pay items to the corresponding Vista phase by item number (phase suffix)
3. Populates budget and actual costs (labor, equip, material, sub) automatically
4. Flags each item: Clean Deduct / Partial / Fully Incurred / 888-999 Phase
5. Exports a completed Excel workbook ready for Bill

Column detection: Looks for Labor, Equipment, Material, Subcontract actual columns. Also captures budget estimate for comparison. You can edit any cell after import.
Step 2 — Review & Edit Actuals
CO-004 Data (from signed change order) Vista Phase Budget ← Actuals from JCCostEstCT (editable) Calculated Notes
# Item Description Unit Vista Phase Code Budget Est $ CO Deduct $ Labor $ Equip $ Material $ Sub $ Total Actual $ % of Deduct Flag Action / Notes