This guide provides a complete framework for building your renovation budget spreadsheet using Ottawa 2026 pricing benchmarks. We'll walk through every cost category you need to capture, the contingency math that prevents nasty surprises, and the payment schedule structure that protects your money. By the end of this guide you'll have a complete budget framework you can replicate in Excel, Google Sheets, or any budgeting app.
Hard costs are the actual construction costs paid to your contractor. Include: structural/framing labour and materials, electrical (rough-in + finish + ESA fees), plumbing (rough-in + finish + fixtures), HVAC (equipment + installation + commissioning), insulation and vapour barrier, drywall (boarding + taping + texture + paint primer), flooring (subfloor prep + materials + installation), kitchen cabinets and counters, bathroom fixtures and tile, lighting fixtures, doors and trim, finish painting...
Soft costs are often forgotten in initial budgets but typically add 8-15% to hard costs. Include: building permit fee, electrical permit/ESA notification, plumbing permit, HVAC permit, designer or architect fees ($1,500-$8,000 for typical residential work), structural engineering ($800-$3,000 if any structural changes), interior design fees ($2,500-$15,000 for full-service design), heritage approval fees if applicable, surveys (Ontario Land Surveyor at $800-$1,500 for property line confirmation)...
Often forgotten: the cost of NOT being able to use your home or paying for elsewhere. Include: temporary accommodation if displaced (Airbnb $150-$300/night for a typical Ottawa rental), restaurant meals if kitchen is out ($50-$100/day extra for a family of 4), storage for furniture and contents ($200-$500/month for a typical 10x10 unit), pet boarding if needed, increased utility costs (heating an open-walled construction zone in winter), and any home insurance riders for vacant or under-construc...
Every Ottawa renovation budget should include a contingency line of 15-20% of hard costs. The right percentage depends on your home's age and complexity: newer home (post-2000) with predictable conditions: 10-12% contingency. Mid-age home (1970-2000): 12-15% contingency. Older home (1950-1970): 15-18% contingency. Pre-1950 home: 20-25% contingency. Why so much? Old plumbing, original electrical, hidden structural issues, asbestos, lead paint, knob-and-tube, and foundation cracks are routinely di...
Your spreadsheet should also model your payment schedule. Recommended structure for a typical $50,000+ renovation: 10-15% deposit at contract signing. 15-20% at framing/rough-in completion. 20-25% at drywall completion. 20-25% at finishes installed. 10-15% holdback released only after substantial completion AND deficiency list fully resolved. NEVER release final holdback while any item on your written deficiency list remains incomplete. Track each payment against actual milestone verification in...
Build a variance tracking column in your spreadsheet showing budget vs actual for each line item as the project progresses. Update weekly. Flag any line item more than 10% over budget for contractor discussion. Track contingency drawdown carefully — if you've burned 60%+ of your contingency before reaching 50% project completion, you have a scope or pricing problem that needs immediate review.
For homes built before 1950, budget 20-25% contingency on hard costs. The combination of knob-and-tube wiring discoveries, asbestos in old insulation and floor tile mastic, lead paint, foundation cracks, and original plumbing that fails during disturbance typically consumes 18-22% of original budgets in this age category.
Most renovation experts advise against sharing your budget upfront. Instead, share the scope of work in detail and request quotes — let the market reveal pricing. Once you have 3+ quotes, you can negotiate within the established range. Sharing budget first often results in quotes that exactly match it regardless of actual project value.
Soft costs — particularly designer/architect fees, engineering fees, and permit fees. These add 8-15% to hard costs but are routinely omitted from initial homeowner budgets. The second-most forgotten: living costs during the renovation (temporary accommodation, restaurant meals, storage).