Insurance Claim vs. Rehab Budget Reconciliation
Reconcile an insurance loss estimate against the rehab draw budget so the same repair is never funded twice - once by the loan draw and once by the insurance proceeds.
Manual claim-to-budget cross-referencing - matching a room-by-room adjuster estimate to trade-based budget categories by hand to catch scope the loan draw and the insurance proceeds would both fund - is done in minutes per file, so the duplicate-payment check runs on every claim file instead of only the ones a reviewer has time for
per claim file
What it extracts
12 extraction fields
- Claim File Overview
- A one-look roll-up of the file's identity and headline dollars - property, borrower/insured, carrier, claim number, date and cause of loss, loss-payee status, total budget, and claim RCV/ACV/deductible - so a reviewer can orient before reading the detail.
- Insurance Claim Header
- The claim's header and settlement economics from the loss estimate - RCV, O&P, tax, depreciation (recoverable and total), ACV, deductible, net payable, and the mortgagee/loss-payee clause - re-footed so the lender knows what the carrier pays and when.
- Rehab Budget Header
- The property, loan, and budget metadata from the construction/rehab budget, including the total budget, the construction holdback, and the per-draw retainage rate that govern how escrow is released.
- Rehab Budget Line Items
- Every rehab budget category and its budgeted amount, extracted in the budget's original order - the canonical set of categories the insurance claim is reconciled against.
- Insurance Claim Line Items
- Every itemized repair line from the loss estimate, one row each with room/section, description, quantity, unit, unit cost, and the RCV, depreciation, and ACV that let the lender see covered value net of depreciation.
- Claim-to-Budget Category Mapping
- Bridges the vocabulary gap - maps each granular room-and-material claim line to the trade/material budget category it belongs to, totals covered RCV and ACV per category, and grades the mapping confidence.
- Scope Reconciliation Matrix
- The core line-item reconciliation - each budget category joined to its covered claim amount with the variance, coverage status, matched/budget-only/claim-only status, and a per-row duplicate-payment risk flag, plus a totals row.
- Covered vs. Uncovered Scope Analysis
- Splits the rehab scope into insurance-covered budget, borrower-funded uncovered budget (upgrades and betterments), and claim-only scope the budget omits, and flags uninsured-peril or excluded work.
- Net Duplicate-Payment Exposure
- The single dollar figure the whole workflow exists to catch - the budgeted amount that could be paid twice for the same repairs (loan draw plus insurance proceeds), netted for the deductible.
- Draw Disbursement Recommendation
- The recommended escrow and disbursement action - decision, insurance proceeds to capture into escrow, the budget adjustment for double-funded scope, recoverable depreciation held pending completion, retainage to withhold, and the completion basis for release.
- Reconciliation Findings
- The ranked exception report - every issue the draws team should act on (duplicate-payment risk, coverage gaps, missing loss-payee clause, identity mismatch, low-confidence mappings), Hold-first with dollar impact and a recommended action.
- Reconciliation Memo
- A 200-350 word narrative memo tying the file together for the draws team - identity, budget vs claim totals, the matched/budget-only/claim-only split, the duplicate-payment exposure, the disbursement recommendation, and open items to verify.
Where it fits
Construction / rehab draw administration on a business-purpose renovation loan after an insured property loss
Upstream
A borrower's property suffers an insured loss (wind, hail, fire, water, freeze) during a fix-and-flip or rental-renovation loan. The carrier or public adjuster issues a loss estimate (commonly an Xactimate scope with RCV, depreciation, ACV, O&P, and the deductible), and the lender - named as mortgagee / loss payee - receives the claim documentation alongside the approved construction/rehab budget
This step
Reconciling the insurance claim against the rehab budget before escrow is set and draws are released
Downstream
- Restoration-escrow setup and draw release against verified completion
- Escrow / budget adjustment where insurance covers scope the loan would also fund
- Hold for review or borrower follow-up on coverage gaps and low-confidence mappings
What it needs
Documents
- Insurance loss estimate / adjuster scope (commonly an Xactimate report with RCV, depreciation, ACV, O&P, and deductible)
- Construction / rehab budget (the lender's standardized budget form)
- Insurance policy declarations and the mortgagee / loss-payee endorsement
- Prior draw history and inspection reports for the project, where available
Systems
- Loan origination / servicing system
- Construction-draw management system
- Google Drive
- SharePoint
Prerequisites
- The approved construction / rehab budget for the loan
- The carrier's loss estimate for the same property and loss event
- The loss-payee / mortgagee endorsement confirming the lender's interest in the proceeds
- The per-draw retainage or holdback terms that govern disbursement
What it produces
A completed reconciliation showing the claim-to-budget category mapping, the line-item Scope Reconciliation Matrix (matched, budget-only, claim-only, and duplicate-payment risk per category), the covered-vs-uncovered scope analysis, a single net duplicate-payment exposure figure, a draw disbursement recommendation, a ranked findings list, and a narrative memo for the draws team
Delivered to
- Loan / draw file
- Restoration-escrow record
- Draws-team decision memo
Review model
A draws administrator or loan-operations reviewer reviews the flagged findings, the duplicate-payment exposure, and the cited claim and budget lines before releasing a draw, adjusting escrow, or holding the file.
Who uses it
Volume fit
Works best for
business-purpose lenders and servicers administering renovation-loan draws across a portfolio where insured-loss claims recur and manual claim-to-budget cross-referencing is slow
Too small for
a lender handling only the occasional insured loss, where a one-off manual cross-check is faster than setup
Grounded in
- Actual Cash Value (ACV) vs. Replacement Cost Value (RCV) and recoverable depreciation - standard property-insurance settlement mechanicsverified as of 2026-07-22
- Xactimate estimate structure - line items + Overhead & Profit (typically '10 and 10') + tax = RCV; RCV - depreciation = ACV; ACV - deductible = net payableverified as of 2026-07-22
- Mortgagee clause / loss-payee endorsement (including ISAOA and ATIMA) - lender's right to insurance proceeds after a lossverified as of 2026-07-22
- Construction-holdback / rehab-draw disbursement practice - staged release against verified completion with per-draw retainage (commonly 5% to 10%)verified as of 2026-07-22
Changelog
- July 2026
based on a production deployment at a business-purpose real estate lender
Related agents
Browse all agents →Construction Budget / Affordable-Housing Loan Committee Review
Prepare an affordable-housing construction loan for committee - the GC budget normalized by CSI Division, the full sources-and-uses capital stack with its LIHTC and subsidy layers, cost-per-unit, DSCR, LTC and LTV recomputed against affordable benchmarks, the budget and stack reconciled, and a cited, severity-ranked recommendation.
Appraisal Review
Run every appraisal through a productized USPAP review and classify it Accept, Accept-with-conditions, or Reject, with each finding cited to the report.
Change-in-Terms & Cardholder-Agreement Review
Test a credit card change-in-terms notice against Regulation Z: every changed term summarized, the 45-day advance-notice window and right-to-reject verified, penalty rate increases justified and reevaluation-eligible, and every required disclosure present and cited.
See Insurance Claim vs. Rehab Budget Reconciliation on your documents
We'll run it against a file of yours and walk through every cited field.