How to Create a Moving Budget Spreadsheet (With Template)

Why You Need a Moving Budget (Not Just a Quote)

A moving quote tells you what the movers will charge. A moving budget tells you what the entire relocation will actually cost. These are different numbers.

The Gap Between the Quote and the True Cost

The average local moving quote in Ottawa covers labour, truck, and basic materials. It doesn’t cover:

• Packing supplies you buy yourself
• Cleaning your old place (or hiring cleaners)
• Utility setup fees and deposits at the new address
• Food for moving day (and probably the day before and after)
• Pet boarding if your animal can’t be underfoot during the move
• Storage if there’s a gap between move-out and move-in
• Parking permits for the truck
• Tips for the crew

For a 2-bedroom apartment move quoted at $1,200, the true all-in cost is typically $1,800–$2,400 once everything is tallied. That 50–100% gap catches people off guard.

Costs People Forget About

Beyond the common extras, these line items routinely blindside movers:

• Lock rekeying at the new home ($150–$300)
• Window coverings if moving to a new-build or empty condo ($500–$2,000+)
• Address change costs — redirected mail is $25–$100 depending on service
• Lost wages if you take a day off to supervise the move
• Childcare for young kids on moving day
• Insurance deductible if anything gets damaged

A budget spreadsheet surfaces all of these before they hit your bank account. If you want to understand where the big fees come from, our guide on avoiding hidden moving fees breaks down the estimate side of the equation.

Moving Budget Categories

Moving Company Fees

This is your biggest line item. Break it into sub-categories:

• Base rate (hourly × estimated hours, or flat fee)
• Travel time (if charged separately)
• Fuel surcharge (fixed fee or percentage)
• Stair fees / long-carry charges (if applicable)
• Packing service (if hiring full-service)
• Specialty item charges (piano, hot tub, gun safe)

Get this information from your itemized estimate. If your mover hasn’t given you an itemized breakdown, request one — a single lump-sum number isn’t enough to budget against. For help getting a reliable, detailed estimate, see our guide on getting an accurate moving quote.

Packing Supplies

If you’re packing yourself:

ItemEstimated QuantityUnit CostTotalSmall boxes15–20$2–$4$30–$80Medium boxes15–20$3–$5$45–$100Large boxes5–10$4–$7$20–$70Wardrobe boxes2–4$12–$18$24–$72Packing tape (rolls)4–6$4–$6$16–$36Bubble wrap / packing paper2–3 rolls$15–$25$30–$75Mattress bags1–3$8–$15$8–$45

Total estimate: $175–$475 for a 2–3 bedroom home.

Cut this to near-zero by sourcing free materials. LCBO boxes, grocery store banana boxes, and Ottawa Buy Nothing groups cover most needs without spending a dollar.

Insurance and Valuation Coverage

Your mover includes basic valuation coverage — typically $0.60 per pound per item. That means a 50-lb lamp is covered for $30, regardless of its actual value.

For meaningful protection:- Enhanced valuation from your mover — $150–$400 depending on declared value- Third-party moving insurance — $200–$600 for full replacement-value coverage- Check your homeowner’s or renter’s insurance — some policies cover belongings in transit

Add whichever option you choose to the spreadsheet.

Cleaning (Old Home and New Home)

Cleaning TaskDIY CostProfessional CostOld home deep clean$30–$80 (supplies)$200–$400New home pre-move clean$20–$50 (supplies)$150–$300Carpet cleaning (old home)Rental: $50–$75$200–$350

If your lease requires professional cleaning, that’s a non-negotiable budget item. Get quotes from two cleaning companies before assuming a number.

Utility Connections and Deposits

• Hydro Ottawa setup fee: $0 (no fee, but ensure the account transfer is confirmed)
• Enbridge gas: $0 transfer fee for existing accounts
• Internet setup/tech visit: $0–$100 depending on provider
• Water heater rental transfer: Verify with your current provider
• Canada Post mail forwarding: $25 (3 months domestic) to $104 (12 months)

For a full utility checklist, our utility setup guide covers exactly what to connect and when.

Food, Travel, and Incidentals

Budget for:- Meals on moving day ($50–$100 for the family, possibly more if treating helpers)- Coffee runs for the crew ($15–$30)- Gas if driving between locations multiple times ($20–$50)- Unexpected supplies — extra tape, garbage bags, zip ties ($20–$40)

Storage Fees (If Applicable)

If there’s a gap between your move-out and move-in dates:

• Self-storage (5×10 unit): $100–$200/month
• Mover’s warehouse storage: $150–$300/month
• Portable container (stored): $150–$250/month

Add a deposit (often one month) if using self-storage.

Building Your Spreadsheet Step by Step

Column Structure

Set up your spreadsheet with four columns:

CategoryEstimated CostActual CostDifferenceMoving company — base rate$1,200Moving company — stair fee$100Packing supplies$200…………TOTAL$X,XXX$X,XXX$X,XXX

The “Difference” column is where the real value lives. It tells you exactly where your estimates were wrong — useful information for anyone you know who’s planning a future move.

Using Google Sheets or Excel

Google Sheets is ideal because:- You can access it from your phone on moving day- Multiple people (partner, roommate) can update it simultaneously- It auto-saves — no risk of losing your work

Create a single sheet with your budget categories. Use a dropdown or colour-coding for status: Estimated, Paid, Pending.

Adding Formulas for Totals and Variance

Keep it simple:- Column D (Difference): =C2-B2 — shows over/under for each line- Bottom row (Totals): =SUM(B2:B25) for estimated total, =SUM(C2:C25) for actual total- Conditional formatting: Highlight any row where Actual exceeds Estimated by more than 20% (this is your early warning system)

Ottawa-Specific Costs to Include

Parking Permits for Moving Trucks

If you’re moving in a dense area — the Glebe, Centretown, Sandy Hill, ByWard Market, Old Ottawa South — street parking for a 26-foot truck is not guaranteed. You may need:

• City of Ottawa temporary parking permit — Apply through ottawa.ca for a reserved space near your address. There’s no fee for the permit itself, but you’ll need to post temporary no-parking signs 24 hours before.
• Private lot fees — Some buildings require you to pay for use of a loading dock or parking pad ($50–$200).

Budget $0–$200 depending on your location. Downtown and condo moves are at the higher end.

Condo Elevator Booking Fees

Many Ottawa condos charge a refundable deposit ($200–$500) for moving-day elevator access. Some also charge a non-refundable booking fee ($50–$150). The deposit is returned if the elevator and common areas aren’t damaged.

Check with your condo management before creating your budget. For elevator-specific tips, our guide to moving into a high-rise condo in Ottawa covers the process.

Seasonal Pricing Differences

Moving in July? Budget 15–25% more for labour than the same move in January. Ottawa’s peak moving season runs May through September, with the absolute peak in the last week of June and first week of July.

Off-season savings are real. If your timeline is flexible, a January or February move can save hundreds.

Tips to Stay Under Budget

Build a 10% Buffer

No matter how thorough your spreadsheet is, something will cost more than expected. A 10% buffer above your estimated total gives you room to absorb surprises without panic.

If your estimated total is $2,500, set your mental ceiling at $2,750. If you come in under, that’s money back in your pocket.

For a broader look at how to keep your entire move affordable, our guide on affordable moving options in Ottawa covers strategies from full-service to DIY and everything in between.

Track Actuals in Real Time

Update your spreadsheet as you spend. Don’t wait until after the move to total everything up — by then, you’ve already overspent with no chance to adjust.

Set a reminder to update the spreadsheet every evening during the two weeks before your move. On moving day itself, have your partner or a friend update costs as they happen.

Tips for staying on track:- Pay for packing supplies with a debit card to see the exact amount immediately- Save every receipt (photograph them with your phone)- Record the mover’s final bill before they leave — confirm the total matches the estimate

Frequently Asked Questions

Is there a free moving budget template I can download?

Google Sheets has several free moving budget templates. Search “moving budget template” in the Google Sheets template gallery. Alternatively, build one from the structure in this article — it takes 15 minutes and you’ll customize it to your specific move.

How much should I budget for an average Ottawa move?

For a 2-bedroom apartment moving locally: budget $1,800–$2,500 all-in (not just the moving company quote). For a 3-bedroom house: $2,500–$4,000. These numbers include supplies, cleaning, deposits, food, and a buffer.

Should I track my moving expenses for taxes?

If you’re moving for work and your new home is at least 40 km closer to your new workplace, you can deduct eligible moving expenses on your tax return (CRA Form T1-M). Keeping a detailed budget spreadsheet with receipts makes tax filing straightforward.

What’s the biggest unexpected cost in most moves?

Cleaning and repairs at the old home. Many tenants underestimate the cost of returning a rental to move-in condition, and homeowners underestimate pre-sale touch-ups. Budget $200–$500 for cleaning and minor repairs.

Can I use a budgeting app instead of a spreadsheet?

Yes — apps like Mint, YNAB, or even a simple note-taking app can work. The advantage of a spreadsheet is the side-by-side comparison of estimated vs. actual, which purpose-built budgeting apps don’t always support well.