Spreadsheets

Moving house budget sheet: shifting, deposits and setup costs

Plan a house move with an Excel budget sheet: deposit, brokerage, packers, utility setup, and overlap rent, with quote versus actual and reimbursement flags.

Editorial illustration for Moving house budget sheet: shifting, deposits and setup costs

A moving budget sheet lists every cost of the move in sections, with a quote column filled before you commit and an actual column filled as you pay. Add a flag for who paid and whether your employer has reimbursed it, and the sheet answers two questions at once: what is this move costing me, and how much is still owed back to me.

Which sections should the sheet have?

Use one table with these columns: A Section, B Item, C Quote, D Actual, E Difference, F Paid by, G Reimbursed, H Notes. Group rows under the sections below.

  • Deposit and brokerage: security deposit, brokerage, agreement charges
  • Packers and transport: packing, loading, vehicle, unloading, insurance if offered, tips
  • Utility setup: electricity and gas connections or transfers, internet installation, water
  • New home: cleaning, painting touch-ups, locks, curtains, furniture, appliances
  • Overlap rent: days when you pay both homes
  • Miscellaneous: society charges, parking sticker, lost-day wages

In E2 write =IF(D2="","",D2-C2), so a positive number means you spent more than quoted. Format it with a conditional rule that shades positive numbers red.

How do I calculate overlap rent?

Overlap rent is what you pay for the old home while already paying the new one. Put the monthly rent in a cell, say K1, and the overlap days in K2, then write =K1*K2/30 in the Quote column. If rent is ₹30,000 and the overlap is 15 days, the figure is 30,000 x 15 / 30 = ₹15,000. Your landlord may use a different method, so check the agreement, and put the real figure in Actual when paid.

What does a filled sheet look like?

Here is a made-up move with employer support. Quotes are before the move, actuals after.

ItemQuoteActualPaid by
Security deposit₹90,000₹90,000Me
Brokerage₹15,000₹15,000Me
Packers and transport₹22,000₹24,500Employer
Internet setup₹1,500₹1,500Me
Curtains and fittings₹8,000₹9,200Me
Overlap rent (15 days)₹15,000₹15,000Me

Quotes add up to 90,000 + 15,000 + 22,000 + 1,500 + 8,000 + 15,000 = ₹1,51,500. Actuals add up to 90,000 + 15,000 + 24,500 + 1,500 + 9,200 + 15,000 = ₹1,55,200, so you are ₹3,700 over. That is the sum in column E. Keep the two totals visible at the top of the sheet so you see the overshoot as soon as you open it.

How do I track what the employer owes me?

If your employer reimburses part of the move, put Me or Employer in Paid by for the party who pays the vendor, and Yes or No in Reimbursed. Then use:

=SUMIFS($D$2:$D$40,$F$2:$F$40,"Me",$G$2:$G$40,"No")

This adds up everything you paid yourself that has not been paid back. Policies differ on what is covered, how much, and what proof is needed, so read your relocation letter and keep every bill and payment record together. Whether an amount is taxable or not is a matter for your employer's payroll team or your CA.

Is the deposit a cost or a loan to the landlord?

Treat the refundable deposit as money parked, not spent. Add a tiny second total: =SUMIFS(D2:D40,B2:B40,"Security deposit") for the parked amount, and subtract it from the grand total to see what the move costs once the deposit is set aside. In the example that is 1,55,200 - 90,000 = ₹65,200.

Checklist before the move day

  1. Fill the Quote column for every section before you pay any advance.
  2. Pay by UPI, bank transfer or card where possible, so the record exists on your statement.
  3. Update Actual the same day you pay.
  4. Photograph receipts and store the link in Notes.
  5. After the move, import the statements into SpendixAI if you want the shifting costs filed under one category next to the rest of your year.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports