Rehab Project Tracker

A rehab goes sideways in the gaps: a contractor says the budget is fine while the actuals say otherwise, a draw is released before the milestone is really done, and the schedule lives in three people's heads. Flippers, BRRRR investors, and owner-builders managing their own crews all hit the same wall around week three, when spend, draws, and dates stop lining up.

This workbook keeps all of it in one file. The Scope of Work sheet lists 60 common line items from interior demo through contingency, each with budget, actual, an automatic variance, and a status dropdown; totals, lines complete, and percent of budget spent calculate at the bottom. The Contractors sheet compares three bids across 12 trades and picks the low bid per trade with a formula, then sums the low bids. The Draw Schedule tracks 10 milestones from mobilization to retainage release with percent of total and cumulative drawn, plus drawn-to-date and remaining. The Timeline sheet turns a start and end date for each of 16 phases into day counts and a 26-week Gantt bar built from formulas, with conditional formatting that shades the bars and flags Blocked and Done rows. The Punch List holds 40 items with room and an Open/Done/N/A dropdown and counts open items. In total the file carries 560 formulas across 5 sheets.

The result is a single source of truth you can hand to a lender, partner, or contractor and defend line by line. To start: open Scope of Work and enter your budget per line, leaving unused lines at zero. Then enter the three bids you collected on the Contractors sheet and copy the winning contractor name into the Hired column. Finally, type a start and end date for each phase on Timeline and the Gantt fills itself.