{
 "package": {
  "documents": [
   {
    "doc_id": "d1-f50f6d8f",
    "filename": "Riverside_Lofts_Draw_7.pdf",
    "sha256": "f50f6d8f7ec1b3a05fa571d5924185a629a9e49f7b8ae75e577ecee222d19632",
    "page_count": 2,
    "pages": [
     {
      "doc_id": "d1-f50f6d8f",
      "page": 1,
      "kind": "g702",
      "confidence": 0.97,
      "method": "rules",
      "has_text": true,
      "snippet": "APPLICATION AND CERTIFICATE FOR PAYMENT G702 FORMAT\nTO OWNER: PROJECT: Riverside Lofts, 1200 River Rd APPLICATION NO: 7\nRiverside Lofts Owner LLC APPLICATION DATE: 10/31/2026\nPERIOD TO: 10/31/2026\nFROM CONTRACTOR:\nRiverbend Builders LLC\nCON",
      "group": 0
     },
     {
      "doc_id": "d1-f50f6d8f",
      "page": 2,
      "kind": "g703",
      "confidence": 0.95,
      "method": "rules",
      "has_text": true,
      "snippet": "CONTINUATION SHEET G703 FORMAT\nUse with the Application and Certificate for Payment, containing Contractor's signed certification. APPLICATION NO: 7\nRiverside Lofts, 1200 River Rd APPLICATION DATE: 10/31/2026\nPERIOD TO: 10/31/2026\nSCHEDULED",
      "group": 0
     }
    ]
   },
   {
    "doc_id": "d2-cb06ecb2",
    "filename": "Riverside_Lofts_Draw_7_backup.pdf",
    "sha256": "cb06ecb200239bbff733ec0f594d5f49b61b8df502b00949c250949eacab763c",
    "page_count": 10,
    "pages": [
     {
      "doc_id": "d2-cb06ecb2",
      "page": 1,
      "kind": "sub_summary",
      "confidence": 0.95,
      "method": "rules",
      "has_text": true,
      "snippet": "APPLICATION AND CERTIFICATE FOR PAYMENT DOCUMENT SUMMARY SHEET\nTO CONTRACTOR: PROJECT: APPLICATION NO: 4\nRiverbend Builders LLC Riverside Lofts, 1200 River Rd PERIOD: 10/01/26 - 10/31/26\nFROM SUBCONTRACTOR: CONTRACT NO: SC-RL-010\nSummit Mec",
      "group": 1
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 2,
      "kind": "sub_detail",
      "confidence": 0.9,
      "method": "rules",
      "has_text": true,
      "snippet": "CONTINUATION SHEET DOCUMENT DETAIL SHEET SUBCONTRACTOR'S DETAIL\nUse with the Application and Certificate for Payment, containing Contractor's signed certification. APPLICATION NO: 4\nRiverside Lofts, 1200 River Rd \u00b7 Summit Mechanical Inc APP",
      "group": 1
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 3,
      "kind": "lien_waiver",
      "confidence": 0.9,
      "method": "rules",
      "has_text": true,
      "snippet": "CONDITIONAL WAIVER AND RELEASE ON PROGRESS PAYMENT\nName of Claimant: Riverbend Builders LLC\nName of Customer: Riverside Lofts Owner LLC\nJob Location: 1200 River Rd\nOwner: Riverside Lofts Owner LLC\nThrough Date: 10/31/2026\nUpon receipt of a ",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 4,
      "kind": "lien_waiver",
      "confidence": 0.9,
      "method": "rules",
      "has_text": true,
      "snippet": "UNCONDITIONAL WAIVER AND RELEASE ON PROGRESS PAYMENT\nName of Claimant: Summit Mechanical Inc\nName of Customer: Riverbend Builders LLC\nJob Location: 1200 River Rd\nOwner: Riverside Lofts Owner LLC\nThrough Date: 09/30/2026\nAmount of Check: $16",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 5,
      "kind": "lien_waiver",
      "confidence": 0.9,
      "method": "rules",
      "has_text": true,
      "snippet": "CONDITIONAL WAIVER AND RELEASE ON PROGRESS PAYMENT\nName of Claimant: Summit Mechanical Inc\nName of Customer: Riverbend Builders LLC\nJob Location: 1200 River Rd\nOwner: Riverside Lofts Owner LLC\nThrough Date: 10/31/2026\nAmount of Check: $144,",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 6,
      "kind": "change_order",
      "confidence": 0.85,
      "method": "rules",
      "has_text": true,
      "snippet": "CHANGE ORDER\nCHANGE ORDER NO. 1\nDATE: 06/03/2026\nPROJECT: Riverside Lofts, 1200 River Rd\nDescription: Additional foundation drainage at north wall\nThe Contract Sum will be increased by this Change Order in the amount of $60,000.00\nSTATUS: A",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 7,
      "kind": "change_order",
      "confidence": 0.85,
      "method": "rules",
      "has_text": true,
      "snippet": "CHANGE ORDER\nCHANGE ORDER NO. 2\nDATE: 08/12/2026\nPROJECT: Riverside Lofts, 1200 River Rd\nDescription: Upgrade corridor lighting package\nThe Contract Sum will be increased by this Change Order in the amount of $40,000.00\nSTATUS: APPROVED\nOWN",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 8,
      "kind": "change_order",
      "confidence": 0.85,
      "method": "rules",
      "has_text": true,
      "snippet": "CHANGE ORDER REQUEST\nCHANGE ORDER NO. 3\nDATE: 10/15/2026\nPROJECT: Riverside Lofts, 1200 River Rd\nDescription: Storm sewer upgrade per civil revision 4\nThe Contract Sum will be increased by this Change Order in the amount of $45,000.00\nSTATU",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 9,
      "kind": "invoice",
      "confidence": 0.8,
      "method": "rules",
      "has_text": true,
      "snippet": "ClearView Glazing Inc INVOICE\nInvoice No: CV-2207\nInvoice Date: 10/20/2026\nBill To: Riverbend Builders LLC\nDescription: Storefront glazing units delivered to site, held in trailer\nTotal Due: $85,000.00",
      "group": null
     },
     {
      "doc_id": "d2-cb06ecb2",
      "page": 10,
      "kind": "invoice",
      "confidence": 0.8,
      "method": "rules",
      "has_text": true,
      "snippet": "ClearView Glazing Inc INVOICE\nInvoice No: CV-2207\nInvoice Date: 10/20/2026\nBill To: Riverbend Builders LLC\nDescription: Storefront glazing units delivered to site, held in trailer\nTotal Due: $85,000.00",
      "group": null
     }
    ]
   }
  ],
  "gc_app": {
   "role": "gc",
   "summary": {
    "project": "Riverside Lofts, 1200 River Rd",
    "application_no": "7",
    "application_date": "10/31/2026",
    "period_from": "",
    "period_to": "10/31/2026",
    "owner": "Riverside Lofts Owner LLC",
    "contractor": "Riverbend Builders LLC",
    "contract_for": "Multifamily new construction",
    "contract_no": "",
    "original_contract_sum": "12300000.00",
    "net_change_orders": "145000.00",
    "contract_sum_to_date": "12445000.00",
    "total_completed_stored": "5405000.00",
    "retainage_completed_pct": "10",
    "retainage_completed": "518500.00",
    "retainage_stored_pct": null,
    "retainage_stored": null,
    "total_retainage": "518500.00",
    "total_earned_less_retainage": "4886500.00",
    "less_previous_certificates": "3214700.00",
    "current_payment_due": "1671800.00",
    "balance_to_finish": "7558500.00",
    "amount_certified": null,
    "co_prev_additions": "100000.00",
    "co_prev_deductions": "0.00",
    "co_this_additions": "45000.00",
    "co_this_deductions": "0.00",
    "co_net": "145000.00",
    "signature_placeholders": [],
    "notary_blank": false,
    "architect_blank": null,
    "contractor_sig_blank": false,
    "source": {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 1,
     "line": "G702"
    }
   },
   "lines": [
    {
     "item": "1",
     "code": "",
     "description": "General Conditions",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 0,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "820000.00",
     "previous": "205000.00",
     "this_period": "45000.00",
     "stored": null,
     "total_completed": "250000.00",
     "percent": "30.49",
     "balance": "570000.00",
     "retainage": "25000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 1"
     }
    },
    {
     "item": "2",
     "code": "",
     "description": "Demolition",
     "subcontractor": "Apex Wrecking",
     "kind": "line",
     "section": "",
     "seq": 1,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "210000.00",
     "previous": "210000.00",
     "this_period": "-15000.00",
     "stored": null,
     "total_completed": "195000.00",
     "percent": "92.86",
     "balance": "15000.00",
     "retainage": "19500.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 2"
     }
    },
    {
     "item": "3",
     "code": "",
     "description": "Sitework & Utilities",
     "subcontractor": "Ground Up Civil",
     "kind": "line",
     "section": "",
     "seq": 2,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "640000.00",
     "previous": "380000.00",
     "this_period": "290000.00",
     "stored": null,
     "total_completed": "670000.00",
     "percent": "104.69",
     "balance": "-30000.00",
     "retainage": "67000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 3"
     }
    },
    {
     "item": "4",
     "code": "",
     "description": "Concrete",
     "subcontractor": "Keystone Concrete",
     "kind": "line",
     "section": "",
     "seq": 3,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1450000.00",
     "previous": "1160000.00",
     "this_period": "150000.00",
     "stored": null,
     "total_completed": "1310000.00",
     "percent": "90.34",
     "balance": "140000.00",
     "retainage": "131000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 4"
     }
    },
    {
     "item": "5",
     "code": "",
     "description": "Structural Steel",
     "subcontractor": "Ironclad Steel",
     "kind": "line",
     "section": "",
     "seq": 4,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1180000.00",
     "previous": "640000.00",
     "this_period": "300000.00",
     "stored": null,
     "total_completed": "940000.00",
     "percent": "79.66",
     "balance": "240000.00",
     "retainage": "94000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 5"
     }
    },
    {
     "item": "6",
     "code": "",
     "description": "Framing & Drywall",
     "subcontractor": "Northside Interiors",
     "kind": "line",
     "section": "",
     "seq": 5,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1320000.00",
     "previous": "210000.00",
     "this_period": "260000.00",
     "stored": null,
     "total_completed": "480000.00",
     "percent": "36.36",
     "balance": "840000.00",
     "retainage": "48000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 6"
     }
    },
    {
     "item": "7",
     "code": "",
     "description": "Roofing",
     "subcontractor": "TopLine Roofing",
     "kind": "line",
     "section": "",
     "seq": 6,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "410000.00",
     "previous": "0.00",
     "this_period": "120000.00",
     "stored": null,
     "total_completed": "120000.00",
     "percent": "29.27",
     "balance": "290000.00",
     "retainage": "12000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 7"
     }
    },
    {
     "item": "8",
     "code": "",
     "description": "Windows & Storefront",
     "subcontractor": "ClearView Glazing",
     "kind": "line",
     "section": "",
     "seq": 7,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "760000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": "85000.00",
     "total_completed": "85000.00",
     "percent": "11.18",
     "balance": "675000.00",
     "retainage": "8500.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 8"
     }
    },
    {
     "item": "9",
     "code": "",
     "description": "Plumbing",
     "subcontractor": "Flowright Plumbing",
     "kind": "line",
     "section": "",
     "seq": 8,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "980000.00",
     "previous": "150000.00",
     "this_period": "140000.00",
     "stored": null,
     "total_completed": "290000.00",
     "percent": "29.59",
     "balance": "690000.00",
     "retainage": "29000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 9"
     }
    },
    {
     "item": "10",
     "code": "",
     "description": "HVAC",
     "subcontractor": "Summit Mechanical",
     "kind": "line",
     "section": "",
     "seq": 9,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1240000.00",
     "previous": "180000.00",
     "this_period": "220000.00",
     "stored": null,
     "total_completed": "400000.00",
     "percent": "32.26",
     "balance": "840000.00",
     "retainage": "40000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 10"
     }
    },
    {
     "item": "11",
     "code": "",
     "description": "Electrical",
     "subcontractor": "Bright Line Electric",
     "kind": "line",
     "section": "",
     "seq": 10,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1150000.00",
     "previous": "170000.00",
     "this_period": "160000.00",
     "stored": null,
     "total_completed": "330000.00",
     "percent": "28.70",
     "balance": "820000.00",
     "retainage": "33000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 11"
     }
    },
    {
     "item": "12",
     "code": "",
     "description": "Interior Finishes",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 11,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "890000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "890000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 12"
     }
    },
    {
     "item": "13",
     "code": "",
     "description": "Elevators",
     "subcontractor": "Vertex Elevator",
     "kind": "line",
     "section": "",
     "seq": 12,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "420000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "420000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 13"
     }
    },
    {
     "item": "14",
     "code": "",
     "description": "Contractor Fee",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 13,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "560000.00",
     "previous": "168000.00",
     "this_period": "52000.00",
     "stored": null,
     "total_completed": "220000.00",
     "percent": "39.29",
     "balance": "340000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 14"
     }
    },
    {
     "item": "15",
     "code": "",
     "description": "Insurance & Bonds",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 14,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "170000.00",
     "previous": "85000.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "85000.00",
     "percent": "50.00",
     "balance": "85000.00",
     "retainage": "8500.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 15"
     }
    },
    {
     "item": "16",
     "code": "",
     "description": "Contingency",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 15,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "200000.00",
     "previous": "0.00",
     "this_period": "30000.00",
     "stored": null,
     "total_completed": "30000.00",
     "percent": "15.00",
     "balance": "170000.00",
     "retainage": "3000.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 16"
     }
    },
    {
     "item": "17",
     "code": "",
     "description": "CO #3 Storm sewer upgrade",
     "subcontractor": "Ground Up Civil",
     "kind": "line",
     "section": "",
     "seq": 16,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "45000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "45000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 item 17"
     }
    }
   ],
   "totals": [
    {
     "item": "",
     "code": "",
     "description": "GRAND TOTALS",
     "subcontractor": "",
     "kind": "total",
     "section": "",
     "seq": 17,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "12445000.00",
     "previous": "3558000.00",
     "this_period": "1757000.00",
     "stored": "85000.00",
     "total_completed": "5405000.00",
     "percent": "43.43",
     "balance": "7040000.00",
     "retainage": "518500.00",
     "source": {
      "doc_id": "d1-f50f6d8f",
      "doc_name": "Riverside_Lofts_Draw_7.pdf",
      "page": 2,
      "line": "G703 GRAND TOTALS"
     }
    }
   ],
   "pages": [
    1,
    2
   ],
   "doc_id": "d1-f50f6d8f",
   "doc_name": "Riverside_Lofts_Draw_7.pdf",
   "column_map": {
    "percent": 5,
    "total_completed": 4,
    "stored": 3,
    "this_period": 2,
    "previous": 1,
    "scheduled_value": 0,
    "balance": 6,
    "retainage": 7
   },
   "warnings": [],
   "extracted_by": "rules"
  },
  "other_gc_apps": [],
  "sub_apps": [
   {
    "role": "sub",
    "summary": {
     "project": "Riverside Lofts, 1200 River Rd",
     "application_no": "4",
     "application_date": "",
     "period_from": "10/01/26",
     "period_to": "10/31/26",
     "owner": "Riverbend Builders LLC",
     "contractor": "Summit Mechanical Inc",
     "contract_for": "HVAC",
     "contract_no": "SC-RL-010",
     "original_contract_sum": "1265000.00",
     "net_change_orders": "0.00",
     "contract_sum_to_date": "1265000.00",
     "total_completed_stored": "340000.00",
     "retainage_completed_pct": "10.00",
     "retainage_completed": "34000.00",
     "retainage_stored_pct": "0.00",
     "retainage_stored": "0.00",
     "total_retainage": "34000.00",
     "total_earned_less_retainage": "306000.00",
     "less_previous_certificates": "162000.00",
     "current_payment_due": "144000.00",
     "balance_to_finish": "959000.00",
     "amount_certified": null,
     "co_prev_additions": null,
     "co_prev_deductions": null,
     "co_this_additions": null,
     "co_this_deductions": null,
     "co_net": null,
     "signature_placeholders": [],
     "notary_blank": null,
     "architect_blank": null,
     "contractor_sig_blank": false,
     "source": {
      "doc_id": "d2-cb06ecb2",
      "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
      "page": 1,
      "line": "Sub summary"
     }
    },
    "lines": [
     {
      "item": "1",
      "code": "",
      "description": "Ductwork rough-in",
      "subcontractor": "",
      "kind": "line",
      "section": "",
      "seq": 0,
      "scheduled_value_original": null,
      "adjustments": [],
      "adjustment_labels": [],
      "scheduled_value": "520000.00",
      "previous": "110000.00",
      "this_period": "90000.00",
      "stored": null,
      "total_completed": "200000.00",
      "percent": "38.46",
      "balance": "320000.00",
      "retainage": "20000.00",
      "source": {
       "doc_id": "d2-cb06ecb2",
       "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
       "page": 2,
       "line": "Sub detail item 1"
      }
     },
     {
      "item": "2",
      "code": "",
      "description": "Rooftop units",
      "subcontractor": "",
      "kind": "line",
      "section": "",
      "seq": 1,
      "scheduled_value_original": null,
      "adjustments": [],
      "adjustment_labels": [],
      "scheduled_value": "430000.00",
      "previous": "40000.00",
      "this_period": "60000.00",
      "stored": null,
      "total_completed": "100000.00",
      "percent": "23.26",
      "balance": "330000.00",
      "retainage": "10000.00",
      "source": {
       "doc_id": "d2-cb06ecb2",
       "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
       "page": 2,
       "line": "Sub detail item 2"
      }
     },
     {
      "item": "3",
      "code": "",
      "description": "Controls & balancing",
      "subcontractor": "",
      "kind": "line",
      "section": "",
      "seq": 2,
      "scheduled_value_original": null,
      "adjustments": [],
      "adjustment_labels": [],
      "scheduled_value": "315000.00",
      "previous": "30000.00",
      "this_period": "10000.00",
      "stored": null,
      "total_completed": "40000.00",
      "percent": "12.70",
      "balance": "275000.00",
      "retainage": "4000.00",
      "source": {
       "doc_id": "d2-cb06ecb2",
       "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
       "page": 2,
       "line": "Sub detail item 3"
      }
     }
    ],
    "totals": [
     {
      "item": "",
      "code": "",
      "description": "GRAND TOTALS",
      "subcontractor": "",
      "kind": "total",
      "section": "",
      "seq": 3,
      "scheduled_value_original": null,
      "adjustments": [],
      "adjustment_labels": [],
      "scheduled_value": "1265000.00",
      "previous": "180000.00",
      "this_period": "160000.00",
      "stored": "0.00",
      "total_completed": "340000.00",
      "percent": "26.88",
      "balance": "925000.00",
      "retainage": "34000.00",
      "source": {
       "doc_id": "d2-cb06ecb2",
       "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
       "page": 2,
       "line": "Sub detail GRAND TOTALS"
      }
     }
    ],
    "pages": [
     1,
     2
    ],
    "doc_id": "d2-cb06ecb2",
    "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
    "column_map": {
     "percent": 5,
     "total_completed": 4,
     "stored": 3,
     "this_period": 2,
     "previous": 1,
     "scheduled_value": 0,
     "balance": 6,
     "retainage": 7
    },
    "warnings": [],
    "extracted_by": "rules"
   }
  ],
  "waivers": [
   {
    "claimant": "Riverbend Builders LLC",
    "customer": "Riverside Lofts Owner LLC",
    "owner": "LLC",
    "project": "1200 River Rd",
    "amount": "1672800.00",
    "through_date": "10/31/2026",
    "conditional": true,
    "final": false,
    "signed": true,
    "notarized": null,
    "exceptions_text": "None",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 3,
     "line": "Lien waiver"
    },
    "extracted_by": "rules"
   },
   {
    "claimant": "Summit Mechanical Inc",
    "customer": "Riverbend Builders LLC",
    "owner": "Riverside Lofts Owner LLC",
    "project": "1200 River Rd",
    "amount": "162000.00",
    "through_date": "09/30/2026",
    "conditional": false,
    "final": false,
    "signed": true,
    "notarized": null,
    "exceptions_text": "Disputed retention of $15,300.00 on Application 3",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 4,
     "line": "Lien waiver"
    },
    "extracted_by": "rules"
   },
   {
    "claimant": "Summit Mechanical Inc",
    "customer": "Riverbend Builders LLC",
    "owner": "Riverside Lofts Owner LLC",
    "project": "1200 River Rd",
    "amount": "144000.00",
    "through_date": "10/31/2026",
    "conditional": true,
    "final": false,
    "signed": true,
    "notarized": null,
    "exceptions_text": "None",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 5,
     "line": "Lien waiver"
    },
    "extracted_by": "rules"
   }
  ],
  "change_orders": [
   {
    "number": "1",
    "date": "06/03/2026",
    "description": "Additional foundation drainage at north wall",
    "amount": "60000.00",
    "contract_sum_prior": null,
    "contract_sum_new": null,
    "owner_signed": null,
    "contractor_signed": null,
    "architect_signed": null,
    "status": "approved",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 6,
     "line": "Change order"
    },
    "extracted_by": "rules"
   },
   {
    "number": "2",
    "date": "08/12/2026",
    "description": "Upgrade corridor lighting package",
    "amount": "40000.00",
    "contract_sum_prior": null,
    "contract_sum_new": null,
    "owner_signed": null,
    "contractor_signed": null,
    "architect_signed": null,
    "status": "approved",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 7,
     "line": "Change order"
    },
    "extracted_by": "rules"
   },
   {
    "number": "3",
    "date": "10/15/2026",
    "description": "Storm sewer upgrade per civil revision 4",
    "amount": "45000.00",
    "contract_sum_prior": null,
    "contract_sum_new": null,
    "owner_signed": false,
    "contractor_signed": null,
    "architect_signed": null,
    "status": "pending",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 8,
     "line": "Change order"
    },
    "extracted_by": "rules"
   }
  ],
  "invoices": [
   {
    "vendor": "ClearView Glazing Inc",
    "number": "CV-2207",
    "date": "10/20/2026",
    "amount": "85000.00",
    "description": "",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 9,
     "line": "Invoice"
    },
    "extracted_by": "rules"
   },
   {
    "vendor": "ClearView Glazing Inc",
    "number": "CV-2207",
    "date": "10/20/2026",
    "amount": "85000.00",
    "description": "",
    "source": {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 10,
     "line": "Invoice"
    },
    "extracted_by": "rules"
   }
  ],
  "stored_material_pages": [],
  "insurance_pages": [],
  "unreadable_pages": [],
  "warnings": [],
  "failed_files": [],
  "duplicate_files": [],
  "ai_used": false
 },
 "prior_package": {
  "documents": [
   {
    "doc_id": "d1-4ab19ac2",
    "filename": "Riverside_Lofts_Draw_6.pdf",
    "sha256": "4ab19ac2c9f5986a496b88056841e3f76d17cbf038a49f5d799fdc5b67bed30d",
    "page_count": 2,
    "pages": [
     {
      "doc_id": "d1-4ab19ac2",
      "page": 1,
      "kind": "g702",
      "confidence": 0.97,
      "method": "rules",
      "has_text": true,
      "snippet": "APPLICATION AND CERTIFICATE FOR PAYMENT G702 FORMAT\nTO OWNER: PROJECT: Riverside Lofts, 1200 River Rd APPLICATION NO: 6\nRiverside Lofts Owner LLC APPLICATION DATE: 09/30/2026\nPERIOD TO: 09/30/2026\nFROM CONTRACTOR:\nRiverbend Builders LLC\nCON",
      "group": 0
     },
     {
      "doc_id": "d1-4ab19ac2",
      "page": 2,
      "kind": "g703",
      "confidence": 0.95,
      "method": "rules",
      "has_text": true,
      "snippet": "CONTINUATION SHEET G703 FORMAT\nUse with the Application and Certificate for Payment, containing Contractor's signed certification. APPLICATION NO: 6\nRiverside Lofts, 1200 River Rd APPLICATION DATE: 09/30/2026\nPERIOD TO: 09/30/2026\nSCHEDULED",
      "group": 0
     }
    ]
   }
  ],
  "gc_app": {
   "role": "gc",
   "summary": {
    "project": "Riverside Lofts, 1200 River Rd",
    "application_no": "6",
    "application_date": "09/30/2026",
    "period_from": "",
    "period_to": "09/30/2026",
    "owner": "Riverside Lofts Owner LLC",
    "contractor": "Riverbend Builders LLC",
    "contract_for": "Multifamily new construction",
    "contract_no": "",
    "original_contract_sum": "12300000.00",
    "net_change_orders": "100000.00",
    "contract_sum_to_date": "12400000.00",
    "total_completed_stored": "3558000.00",
    "retainage_completed_pct": "10",
    "retainage_completed": "355800.00",
    "retainage_stored_pct": null,
    "retainage_stored": null,
    "total_retainage": "355800.00",
    "total_earned_less_retainage": "3202200.00",
    "less_previous_certificates": "2416500.00",
    "current_payment_due": "785700.00",
    "balance_to_finish": "9197800.00",
    "amount_certified": null,
    "co_prev_additions": "100000.00",
    "co_prev_deductions": "0.00",
    "co_this_additions": "0.00",
    "co_this_deductions": "0.00",
    "co_net": "100000.00",
    "signature_placeholders": [],
    "notary_blank": false,
    "architect_blank": null,
    "contractor_sig_blank": false,
    "source": {
     "doc_id": "d1-4ab19ac2",
     "doc_name": "Riverside_Lofts_Draw_6.pdf",
     "page": 1,
     "line": "G702"
    }
   },
   "lines": [
    {
     "item": "1",
     "code": "",
     "description": "General Conditions",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 0,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "820000.00",
     "previous": "160000.00",
     "this_period": "45000.00",
     "stored": null,
     "total_completed": "205000.00",
     "percent": "25.00",
     "balance": "615000.00",
     "retainage": "20500.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 1"
     }
    },
    {
     "item": "2",
     "code": "",
     "description": "Demolition",
     "subcontractor": "Apex Wrecking",
     "kind": "line",
     "section": "",
     "seq": 1,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "210000.00",
     "previous": "180000.00",
     "this_period": "30000.00",
     "stored": null,
     "total_completed": "210000.00",
     "percent": "100.00",
     "balance": "0.00",
     "retainage": "21000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 2"
     }
    },
    {
     "item": "3",
     "code": "",
     "description": "Sitework & Utilities",
     "subcontractor": "Ground Up Civil",
     "kind": "line",
     "section": "",
     "seq": 2,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "640000.00",
     "previous": "300000.00",
     "this_period": "80000.00",
     "stored": null,
     "total_completed": "380000.00",
     "percent": "59.38",
     "balance": "260000.00",
     "retainage": "38000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 3"
     }
    },
    {
     "item": "4",
     "code": "",
     "description": "Concrete",
     "subcontractor": "Keystone Concrete",
     "kind": "line",
     "section": "",
     "seq": 3,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1450000.00",
     "previous": "980000.00",
     "this_period": "180000.00",
     "stored": null,
     "total_completed": "1160000.00",
     "percent": "80.00",
     "balance": "290000.00",
     "retainage": "116000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 4"
     }
    },
    {
     "item": "5",
     "code": "",
     "description": "Structural Steel",
     "subcontractor": "Ironclad Steel",
     "kind": "line",
     "section": "",
     "seq": 4,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1180000.00",
     "previous": "420000.00",
     "this_period": "220000.00",
     "stored": null,
     "total_completed": "640000.00",
     "percent": "54.24",
     "balance": "540000.00",
     "retainage": "64000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 5"
     }
    },
    {
     "item": "6",
     "code": "",
     "description": "Framing & Drywall",
     "subcontractor": "Northside Interiors",
     "kind": "line",
     "section": "",
     "seq": 5,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1320000.00",
     "previous": "100000.00",
     "this_period": "110000.00",
     "stored": null,
     "total_completed": "210000.00",
     "percent": "15.91",
     "balance": "1110000.00",
     "retainage": "21000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 6"
     }
    },
    {
     "item": "7",
     "code": "",
     "description": "Roofing",
     "subcontractor": "TopLine Roofing",
     "kind": "line",
     "section": "",
     "seq": 6,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "410000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "410000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 7"
     }
    },
    {
     "item": "8",
     "code": "",
     "description": "Windows & Storefront",
     "subcontractor": "ClearView Glazing",
     "kind": "line",
     "section": "",
     "seq": 7,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "760000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "760000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 8"
     }
    },
    {
     "item": "9",
     "code": "",
     "description": "Plumbing",
     "subcontractor": "Flowright Plumbing",
     "kind": "line",
     "section": "",
     "seq": 8,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "980000.00",
     "previous": "90000.00",
     "this_period": "60000.00",
     "stored": null,
     "total_completed": "150000.00",
     "percent": "15.31",
     "balance": "830000.00",
     "retainage": "15000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 9"
     }
    },
    {
     "item": "10",
     "code": "",
     "description": "HVAC",
     "subcontractor": "Summit Mechanical",
     "kind": "line",
     "section": "",
     "seq": 9,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1240000.00",
     "previous": "120000.00",
     "this_period": "60000.00",
     "stored": null,
     "total_completed": "180000.00",
     "percent": "14.52",
     "balance": "1060000.00",
     "retainage": "18000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 10"
     }
    },
    {
     "item": "11",
     "code": "",
     "description": "Electrical",
     "subcontractor": "Bright Line Electric",
     "kind": "line",
     "section": "",
     "seq": 10,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "1150000.00",
     "previous": "110000.00",
     "this_period": "60000.00",
     "stored": null,
     "total_completed": "170000.00",
     "percent": "14.78",
     "balance": "980000.00",
     "retainage": "17000.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 11"
     }
    },
    {
     "item": "12",
     "code": "",
     "description": "Interior Finishes",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 11,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "890000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "890000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 12"
     }
    },
    {
     "item": "13",
     "code": "",
     "description": "Elevators",
     "subcontractor": "Vertex Elevator",
     "kind": "line",
     "section": "",
     "seq": 12,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "420000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "420000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 13"
     }
    },
    {
     "item": "14",
     "code": "",
     "description": "Contractor Fee",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 13,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "560000.00",
     "previous": "140000.00",
     "this_period": "28000.00",
     "stored": null,
     "total_completed": "168000.00",
     "percent": "30.00",
     "balance": "392000.00",
     "retainage": "16800.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 14"
     }
    },
    {
     "item": "15",
     "code": "",
     "description": "Insurance & Bonds",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 14,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "170000.00",
     "previous": "85000.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "85000.00",
     "percent": "50.00",
     "balance": "85000.00",
     "retainage": "8500.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 15"
     }
    },
    {
     "item": "16",
     "code": "",
     "description": "Contingency",
     "subcontractor": "",
     "kind": "line",
     "section": "",
     "seq": 15,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "200000.00",
     "previous": "0.00",
     "this_period": "0.00",
     "stored": null,
     "total_completed": "0.00",
     "percent": "0.00",
     "balance": "200000.00",
     "retainage": "0.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 item 16"
     }
    }
   ],
   "totals": [
    {
     "item": "",
     "code": "",
     "description": "GRAND TOTALS",
     "subcontractor": "",
     "kind": "total",
     "section": "",
     "seq": 16,
     "scheduled_value_original": null,
     "adjustments": [],
     "adjustment_labels": [],
     "scheduled_value": "12400000.00",
     "previous": "2685000.00",
     "this_period": "873000.00",
     "stored": "0.00",
     "total_completed": "3558000.00",
     "percent": "28.69",
     "balance": "8842000.00",
     "retainage": "355800.00",
     "source": {
      "doc_id": "d1-4ab19ac2",
      "doc_name": "Riverside_Lofts_Draw_6.pdf",
      "page": 2,
      "line": "G703 GRAND TOTALS"
     }
    }
   ],
   "pages": [
    1,
    2
   ],
   "doc_id": "d1-4ab19ac2",
   "doc_name": "Riverside_Lofts_Draw_6.pdf",
   "column_map": {
    "percent": 5,
    "total_completed": 4,
    "stored": 3,
    "this_period": 2,
    "previous": 1,
    "scheduled_value": 0,
    "balance": 6,
    "retainage": 7
   },
   "warnings": [],
   "extracted_by": "rules"
  },
  "other_gc_apps": [],
  "sub_apps": [],
  "waivers": [],
  "change_orders": [],
  "invoices": [],
  "stored_material_pages": [],
  "insurance_pages": [],
  "unreadable_pages": [],
  "warnings": [],
  "failed_files": [],
  "duplicate_files": [],
  "ai_used": false
 },
 "findings": [
  {
   "code": "BUDGET-OVER",
   "severity": "high",
   "category": "Budget",
   "title": "Item 3 Sitework & Utilities: billed beyond lender budget",
   "detail": "Completed $670,000.00 vs approved budget $640,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 3"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": "30000.00",
   "action": "",
   "fingerprint": "a49c7da47aa10c24",
   "review": null
  },
  {
   "code": "BUDGET-SV",
   "severity": "high",
   "category": "Budget",
   "title": "Item 10 HVAC: scheduled value exceeds lender budget",
   "detail": "G703 $1,240,000.00 vs approved budget $1,200,000.00 ('HVAC').",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 10"
    }
   ],
   "expected": "\u2264 $1,200,000.00",
   "actual": "$1,240,000.00",
   "variance": "40000.00",
   "action": "",
   "fingerprint": "61affc863ed71236",
   "review": null
  },
  {
   "code": "SOV-OVER",
   "severity": "high",
   "category": "Budget",
   "title": "Item 3 Sitework & Utilities: billed over 100% of scheduled value",
   "detail": "Completed $670,000.00 exceeds scheduled value $640,000.00 by $30,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 3"
    }
   ],
   "expected": "\u2264 $640,000.00",
   "actual": "$670,000.00",
   "variance": "30000.00",
   "action": "Hold the overage until a change order or reallocation is approved.",
   "fingerprint": "65d6d5b669112f1c",
   "review": null
  },
  {
   "code": "CO-UNAPPROVED",
   "severity": "high",
   "category": "Change orders",
   "title": "Line 2 includes unapproved change orders",
   "detail": "Executed COs total $100,000.00; Line 2 is $145,000.00, which only ties if pending CO(s) #3 ($45,000.00) are included.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 1,
     "line": "G702 line 2"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 8,
     "line": "Change order"
    }
   ],
   "expected": "$100,000.00",
   "actual": "$145,000.00",
   "variance": "45000.00",
   "action": "Remove unapproved change orders from the contract sum until executed by the owner.",
   "fingerprint": "5f7a5e162346ab06",
   "review": null
  },
  {
   "code": "INV-DUP",
   "severity": "high",
   "category": "Invoices",
   "title": "Possible duplicate invoice from ClearView Glazing Inc",
   "detail": "Invoice CV-2207 for $85,000.00 matches another invoice in the package on number.",
   "refs": [
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 9,
     "line": "Invoice"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 10,
     "line": "Invoice"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Confirm the invoice is not billed twice.",
   "fingerprint": "77992acc7b5cadf9",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Apex Wrecking",
   "detail": "Apex Wrecking bills -$15,000.00 this period and was paid $210,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 2"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Apex Wrecking's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "4585accd1540df88",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Ground Up Civil",
   "detail": "Ground Up Civil bills $290,000.00 this period and was paid $380,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 3"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Ground Up Civil's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "29ed7c020e5a2ce0",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Keystone Concrete",
   "detail": "Keystone Concrete bills $150,000.00 this period and was paid $1,160,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 4"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Keystone Concrete's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "18011286ede4c262",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Ironclad Steel",
   "detail": "Ironclad Steel bills $300,000.00 this period and was paid $640,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 5"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Ironclad Steel's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "88755b8b4c7bdcd8",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Northside Interiors",
   "detail": "Northside Interiors bills $260,000.00 this period and was paid $210,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 6"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Northside Interiors's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "5605215f9d402171",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from TopLine Roofing",
   "detail": "TopLine Roofing bills $120,000.00 this period and was paid $0.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 7"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request TopLine Roofing's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "879be5fa47897fd2",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Flowright Plumbing",
   "detail": "Flowright Plumbing bills $140,000.00 this period and was paid $150,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 9"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Flowright Plumbing's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "d26cb531e9dfdadd",
   "review": null
  },
  {
   "code": "WAIVER-MISSING",
   "severity": "high",
   "category": "Lien waivers",
   "title": "No lien waiver from Bright Line Electric",
   "detail": "Bright Line Electric bills $160,000.00 this period and was paid $170,000.00 previously, but no waiver from them is in the package.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 11"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Request Bright Line Electric's conditional (current) and unconditional (prior) waivers.",
   "fingerprint": "572faacee73e1c2e",
   "review": null
  },
  {
   "code": "SOV-COL",
   "severity": "high",
   "category": "Math",
   "title": "G703 GRAND TOTALS \u2014 this period column does not add",
   "detail": "Rows above add to $1,752,000.00; the GRAND TOTALS row shows $1,757,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 GRAND TOTALS"
    }
   ],
   "expected": "$1,752,000.00",
   "actual": "$1,757,000.00",
   "variance": "5000.00",
   "action": "Ask for a corrected continuation sheet; confirm which figure was used to compute the payment.",
   "fingerprint": "f96b242ef7a7232b",
   "review": null
  },
  {
   "code": "SOV-ROW-G",
   "severity": "high",
   "category": "Math",
   "title": "G703 Item 6 Framing & Drywall: completed to date does not foot",
   "detail": "Previous $210,000.00 + this period $260,000.00 + stored \u2014 = $470,000.00; row shows $480,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 6"
    }
   ],
   "expected": "$470,000.00",
   "actual": "$480,000.00",
   "variance": "10000.00",
   "action": "Correct the row and re-issue the continuation sheet.",
   "fingerprint": "7bd7297fd507ff3d",
   "review": null
  },
  {
   "code": "SOV-ROW-G",
   "severity": "high",
   "category": "Math",
   "title": "G703 GRAND TOTALS: completed to date does not foot",
   "detail": "Previous $3,558,000.00 + this period $1,757,000.00 + stored $85,000.00 = $5,400,000.00; row shows $5,405,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 GRAND TOTALS"
    }
   ],
   "expected": "$5,400,000.00",
   "actual": "$5,405,000.00",
   "variance": "5000.00",
   "action": "Correct the row and re-issue the continuation sheet.",
   "fingerprint": "463e73dfe0a94744",
   "review": null
  },
  {
   "code": "PRIOR-L7",
   "severity": "high",
   "category": "Prior draw",
   "title": "Line 7 does not match the prior certificate",
   "detail": "Less previous certificates is $3,214,700.00; prior application line 6 was $3,202,200.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 1,
     "line": "G702 line 7"
    },
    {
     "doc_id": "d1-4ab19ac2",
     "doc_name": "Riverside_Lofts_Draw_6.pdf",
     "page": 1,
     "line": "Prior G702 line 6"
    }
   ],
   "expected": "$3,202,200.00",
   "actual": "$3,214,700.00",
   "variance": "12500.00",
   "action": "Reconcile to amounts actually certified and paid on the prior draw.",
   "fingerprint": "36293bf5355eba69",
   "review": null
  },
  {
   "code": "PRIOR-LINE-RET",
   "severity": "high",
   "category": "Retainage",
   "title": "Item 14 Contractor Fee: retainage released",
   "detail": "Retainage on this line fell from $16,800.00 to $0.00 while completed work rose to $220,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 14"
    },
    {
     "doc_id": "d1-4ab19ac2",
     "doc_name": "Riverside_Lofts_Draw_6.pdf",
     "page": 2,
     "line": "Prior G703 item 14"
    }
   ],
   "expected": "\u2265 $16,800.00",
   "actual": "$0.00",
   "variance": "-16800.00",
   "action": "Confirm the release was approved; otherwise withhold.",
   "fingerprint": "9c30729c9d51aa3f",
   "review": null
  },
  {
   "code": "RET-RATE",
   "severity": "high",
   "category": "Retainage",
   "title": "Retainage under-withheld by $22,000.00",
   "detail": "At the stated 10.0% rate, retainage on $5,405,000.00 completed & stored should be $540,500.00; the application holds $518,500.00 (effective 9.59%).",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 1,
     "line": "G702 line 5"
    }
   ],
   "expected": "$540,500.00",
   "actual": "$518,500.00",
   "variance": "-22000.00",
   "action": "Confirm the retainage terms in the loan/construction contract; if 10% applies to all lines, reduce the payment by the shortfall.",
   "fingerprint": "d958525054eaf573",
   "review": null
  },
  {
   "code": "STORED-DOCS",
   "severity": "high",
   "category": "Stored materials",
   "title": "$85,000.00 of stored materials without support",
   "detail": "1 line(s) bill materials stored but not installed; no bill of sale, storage agreement or insurance for them was found in the package. Only invoice(s) were found (ClearView Glazing Inc CV-2207, ClearView Glazing Inc CV-2207); an invoice alone doesn't show title, location or insurance.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 8"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 9,
     "line": "Invoice"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 10,
     "line": "Invoice"
    }
   ],
   "expected": null,
   "actual": "$85,000.00",
   "variance": "85000.00",
   "action": "Request bills of sale, invoices, proof of insurance and storage location (and photos / inspection) for stored materials.",
   "fingerprint": "43d6122c95e8cc24",
   "review": null
  },
  {
   "code": "SUB-TIE",
   "severity": "high",
   "category": "Sub pay apps",
   "title": "Item 10 HVAC: GC bills $60,000.00 more than Summit Mechanical Inc",
   "detail": "G703 completed to date $400,000.00 vs Summit Mechanical Inc application #4 (10/31/26) $340,000.00. The GC is billing ahead of its subcontractor.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 10"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 1,
     "line": "Summit Mechanical Inc summary line 4"
    }
   ],
   "expected": "$340,000.00",
   "actual": "$400,000.00",
   "variance": "60000.00",
   "action": "Ask the GC to reconcile its line to the subcontractor's application.",
   "fingerprint": "5618bb88dea6c76a",
   "review": null
  },
  {
   "code": "SOV-CONT",
   "severity": "medium",
   "category": "Budget",
   "title": "Item 16 Contingency: contingency drawn",
   "detail": "$30,000.00 this period, $30,000.00 to date on a contingency/allowance line.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 16"
    }
   ],
   "expected": null,
   "actual": "$30,000.00",
   "variance": null,
   "action": "Confirm owner/lender approval of each contingency use.",
   "fingerprint": "bd9d2d35c3133276",
   "review": null
  },
  {
   "code": "SUB-OVER-BUDGET",
   "severity": "medium",
   "category": "Budget",
   "title": "Item 10 HVAC: subcontract exceeds the budget line by $25,000.00",
   "detail": "Summit Mechanical Inc's contract sum to date is $1,265,000.00; the G703 line is budgeted at $1,240,000.00.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 10"
    },
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 1,
     "line": "Summit Mechanical Inc summary line 3"
    }
   ],
   "expected": "\u2264 $1,240,000.00",
   "actual": "$1,265,000.00",
   "variance": "25000.00",
   "action": "Ask how the buyout overrun is funded (contingency, reallocation or borrower equity).",
   "fingerprint": "94386e58c8fd17b3",
   "review": null
  },
  {
   "code": "CO-PENDING",
   "severity": "medium",
   "category": "Change orders",
   "title": "Change order #3 is not executed",
   "detail": "$45,000.00 \u2014 Storm sewer upgrade per civil revision 4. Owner signature not found / status pending.",
   "refs": [
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 8,
     "line": "Change order"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Do not fund work under this change order until it is executed.",
   "fingerprint": "4dc2b83e4e7079ba",
   "review": null
  },
  {
   "code": "WAIVER-AMT",
   "severity": "medium",
   "category": "Lien waivers",
   "title": "Riverbend Builders LLC: conditional waiver amount \u2260 payment due",
   "detail": "Waiver is for $1,672,800.00; the application shows $1,671,800.00 due this period.",
   "refs": [
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 3,
     "line": "Lien waiver"
    },
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 1,
     "line": "G702 line 8"
    }
   ],
   "expected": "$1,671,800.00",
   "actual": "$1,672,800.00",
   "variance": "1000.00",
   "action": "",
   "fingerprint": "3702d0427c783a03",
   "review": null
  },
  {
   "code": "WAIVER-EXCEPT",
   "severity": "medium",
   "category": "Lien waivers",
   "title": "Waiver from Summit Mechanical Inc lists exceptions",
   "detail": "Exceptions: Disputed retention of $15,300.00 on Application 3",
   "refs": [
    {
     "doc_id": "d2-cb06ecb2",
     "doc_name": "Riverside_Lofts_Draw_7_backup.pdf",
     "page": 4,
     "line": "Lien waiver"
    }
   ],
   "expected": null,
   "actual": null,
   "variance": null,
   "action": "Review the excepted amounts before funding.",
   "fingerprint": "3d650f4b3fead7d8",
   "review": null
  },
  {
   "code": "SOV-NEG",
   "severity": "medium",
   "category": "Prior draw",
   "title": "Item 2 Demolition: negative billing this period",
   "detail": "This period is -$15,000.00 against previous billings of $210,000.00. Work previously certified is being reversed or moved to another line.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 2"
    }
   ],
   "expected": null,
   "actual": "-$15,000.00",
   "variance": "-15000.00",
   "action": "Ask the GC why previously certified work is being reversed and where it was re-billed.",
   "fingerprint": "56f3829c719c6d46",
   "review": null
  },
  {
   "code": "RET-ZERO",
   "severity": "medium",
   "category": "Retainage",
   "title": "No retainage held on 1 billed line(s)",
   "detail": "$220,000.00 of completed work carries $0 retainage while other lines are retained: Item 14 Contractor Fee ($220,000.00).",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 14"
    }
   ],
   "expected": null,
   "actual": "$220,000.00",
   "variance": "-22000.000",
   "action": "Confirm these lines are contractually exempt from retainage (e.g. fee, GCs, insurance) or withhold.",
   "fingerprint": "ead48af7161cb62e",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 3 Sitework & Utilities: no Ground Up Civil application in package",
   "detail": "The GC bills $290,000.00 this period on a line performed by Ground Up Civil, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 3"
    }
   ],
   "expected": null,
   "actual": "$290,000.00",
   "variance": null,
   "action": "Request Ground Up Civil's application for this period.",
   "fingerprint": "56b78adb53401935",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 4 Concrete: no Keystone Concrete application in package",
   "detail": "The GC bills $150,000.00 this period on a line performed by Keystone Concrete, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 4"
    }
   ],
   "expected": null,
   "actual": "$150,000.00",
   "variance": null,
   "action": "Request Keystone Concrete's application for this period.",
   "fingerprint": "95d5be07caff03b8",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 5 Structural Steel: no Ironclad Steel application in package",
   "detail": "The GC bills $300,000.00 this period on a line performed by Ironclad Steel, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 5"
    }
   ],
   "expected": null,
   "actual": "$300,000.00",
   "variance": null,
   "action": "Request Ironclad Steel's application for this period.",
   "fingerprint": "8217952e26bca61b",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 6 Framing & Drywall: no Northside Interiors application in package",
   "detail": "The GC bills $260,000.00 this period on a line performed by Northside Interiors, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 6"
    }
   ],
   "expected": null,
   "actual": "$260,000.00",
   "variance": null,
   "action": "Request Northside Interiors's application for this period.",
   "fingerprint": "976807696f9e0bee",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 7 Roofing: no TopLine Roofing application in package",
   "detail": "The GC bills $120,000.00 this period on a line performed by TopLine Roofing, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 7"
    }
   ],
   "expected": null,
   "actual": "$120,000.00",
   "variance": null,
   "action": "Request TopLine Roofing's application for this period.",
   "fingerprint": "49511c81d0aafc9c",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 9 Plumbing: no Flowright Plumbing application in package",
   "detail": "The GC bills $140,000.00 this period on a line performed by Flowright Plumbing, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 9"
    }
   ],
   "expected": null,
   "actual": "$140,000.00",
   "variance": null,
   "action": "Request Flowright Plumbing's application for this period.",
   "fingerprint": "b7a5197b4969d087",
   "review": null
  },
  {
   "code": "SUB-MISSING",
   "severity": "medium",
   "category": "Sub pay apps",
   "title": "Item 11 Electrical: no Bright Line Electric application in package",
   "detail": "The GC bills $160,000.00 this period on a line performed by Bright Line Electric, but no matching sub application was found.",
   "refs": [
    {
     "doc_id": "d1-f50f6d8f",
     "doc_name": "Riverside_Lofts_Draw_7.pdf",
     "page": 2,
     "line": "G703 item 11"
    }
   ],
   "expected": null,
   "actual": "$160,000.00",
   "variance": null,
   "action": "Request Bright Line Electric's application for this period.",
   "fingerprint": "4cdd84fa4747629f",
   "review": null
  }
 ],
 "metrics": {
  "g703_total_completed": "5405000.00",
  "effective_retainage_pct": "9.59",
  "hard_cost_pct_complete": "45.07",
  "application_no": "7",
  "period_to": "10/31/2026",
  "project": "Riverside Lofts, 1200 River Rd",
  "contractor": "Riverbend Builders LLC",
  "owner": "Riverside Lofts Owner LLC",
  "contract_sum": "12445000.00",
  "completed_to_date": "5405000.00",
  "this_period_gross": "1757000.00",
  "retainage_held": "518500.00",
  "current_payment_due": "1671800.00",
  "pct_complete": "43.43",
  "sov_lines": 17,
  "sub_apps": 1,
  "waivers": 3,
  "change_orders": 3,
  "pages": 12,
  "recommendation": "Fund with conditions",
  "recommendation_reason": "High-severity exceptions must be cleared or the payment reduced before funding.",
  "counts": {
   "high": 21,
   "medium": 14
  },
  "potential_reduction": "272000.00"
 },
 "sov_compare": [
  {
   "current": "Item 1 General Conditions",
   "prior": "Item 1 General Conditions",
   "score": 1.35,
   "sv_now": "820000.00",
   "sv_prior": "820000.00",
   "prev_now": "205000.00",
   "done_prior": "205000.00",
   "done_now": "250000.00",
   "flag": ""
  },
  {
   "current": "Item 2 Demolition",
   "prior": "Item 2 Demolition",
   "score": 1.35,
   "sv_now": "210000.00",
   "sv_prior": "210000.00",
   "prev_now": "210000.00",
   "done_prior": "210000.00",
   "done_now": "195000.00",
   "flag": "completed went down"
  },
  {
   "current": "Item 3 Sitework & Utilities",
   "prior": "Item 3 Sitework & Utilities",
   "score": 1.35,
   "sv_now": "640000.00",
   "sv_prior": "640000.00",
   "prev_now": "380000.00",
   "done_prior": "380000.00",
   "done_now": "670000.00",
   "flag": ""
  },
  {
   "current": "Item 4 Concrete",
   "prior": "Item 4 Concrete",
   "score": 1.35,
   "sv_now": "1450000.00",
   "sv_prior": "1450000.00",
   "prev_now": "1160000.00",
   "done_prior": "1160000.00",
   "done_now": "1310000.00",
   "flag": ""
  },
  {
   "current": "Item 5 Structural Steel",
   "prior": "Item 5 Structural Steel",
   "score": 1.35,
   "sv_now": "1180000.00",
   "sv_prior": "1180000.00",
   "prev_now": "640000.00",
   "done_prior": "640000.00",
   "done_now": "940000.00",
   "flag": ""
  },
  {
   "current": "Item 6 Framing & Drywall",
   "prior": "Item 6 Framing & Drywall",
   "score": 1.35,
   "sv_now": "1320000.00",
   "sv_prior": "1320000.00",
   "prev_now": "210000.00",
   "done_prior": "210000.00",
   "done_now": "480000.00",
   "flag": ""
  },
  {
   "current": "Item 7 Roofing",
   "prior": "Item 7 Roofing",
   "score": 1.1,
   "sv_now": "410000.00",
   "sv_prior": "410000.00",
   "prev_now": "0.00",
   "done_prior": "0.00",
   "done_now": "120000.00",
   "flag": ""
  },
  {
   "current": "Item 8 Windows & Storefront",
   "prior": "Item 8 Windows & Storefront",
   "score": 1.1,
   "sv_now": "760000.00",
   "sv_prior": "760000.00",
   "prev_now": "0.00",
   "done_prior": "0.00",
   "done_now": "85000.00",
   "flag": ""
  },
  {
   "current": "Item 9 Plumbing",
   "prior": "Item 9 Plumbing",
   "score": 1.35,
   "sv_now": "980000.00",
   "sv_prior": "980000.00",
   "prev_now": "150000.00",
   "done_prior": "150000.00",
   "done_now": "290000.00",
   "flag": ""
  },
  {
   "current": "Item 10 HVAC",
   "prior": "Item 10 HVAC",
   "score": 1.35,
   "sv_now": "1240000.00",
   "sv_prior": "1240000.00",
   "prev_now": "180000.00",
   "done_prior": "180000.00",
   "done_now": "400000.00",
   "flag": ""
  },
  {
   "current": "Item 11 Electrical",
   "prior": "Item 11 Electrical",
   "score": 1.35,
   "sv_now": "1150000.00",
   "sv_prior": "1150000.00",
   "prev_now": "170000.00",
   "done_prior": "170000.00",
   "done_now": "330000.00",
   "flag": ""
  },
  {
   "current": "Item 12 Interior Finishes",
   "prior": "Item 12 Interior Finishes",
   "score": 1.1,
   "sv_now": "890000.00",
   "sv_prior": "890000.00",
   "prev_now": "0.00",
   "done_prior": "0.00",
   "done_now": "0.00",
   "flag": ""
  },
  {
   "current": "Item 13 Elevators",
   "prior": "Item 13 Elevators",
   "score": 1.1,
   "sv_now": "420000.00",
   "sv_prior": "420000.00",
   "prev_now": "0.00",
   "done_prior": "0.00",
   "done_now": "0.00",
   "flag": ""
  },
  {
   "current": "Item 14 Contractor Fee",
   "prior": "Item 14 Contractor Fee",
   "score": 1.35,
   "sv_now": "560000.00",
   "sv_prior": "560000.00",
   "prev_now": "168000.00",
   "done_prior": "168000.00",
   "done_now": "220000.00",
   "flag": "retainage released"
  },
  {
   "current": "Item 15 Insurance & Bonds",
   "prior": "Item 15 Insurance & Bonds",
   "score": 1.35,
   "sv_now": "170000.00",
   "sv_prior": "170000.00",
   "prev_now": "85000.00",
   "done_prior": "85000.00",
   "done_now": "85000.00",
   "flag": ""
  },
  {
   "current": "Item 16 Contingency",
   "prior": "Item 16 Contingency",
   "score": 1.1,
   "sv_now": "200000.00",
   "sv_prior": "200000.00",
   "prev_now": "0.00",
   "done_prior": "0.00",
   "done_now": "30000.00",
   "flag": ""
  },
  {
   "current": "Item 17 CO #3 Storm sewer upgrade",
   "prior": null,
   "score": null,
   "sv_now": "45000.00",
   "sv_prior": null,
   "prev_now": "0.00",
   "done_prior": null,
   "done_now": "0.00",
   "flag": "new line"
  }
 ]
}