Track Planned, Quoted and Actual Apartment Moving Expenses

Use one row per expense and give each amount its own column. Each row should hold the first estimate, the provider's quote, the amount you approve as your plan and the final actual total. Next to those amounts, record what you have paid, what is still due, when it is due and where the receipt is. This lets you see at any point where the move is running over plan, what payments are coming up and which costs you can document. The same layout works on paper, in Excel or in Google Sheets.

Ledger columns to set up

Column	What goes in it
A – Expense ID	A short unique code, such as MOV-01, so payments and receipts can be matched to the right row
B – Category	The section the cost belongs to, such as professional moving, self-moving or other expenses
C – Item / provider	What the cost is and who is charging it
D – Estimated amount	Your own early guess, before any provider has priced the job
E – Quoted amount	The figure from the quote you selected
F – Quote date / reference	The date and quote or order number, so the agreed figure can be traced
G – Approved planned amount	The amount you commit to in your budget, which is usually the quote plus anything you knowingly add
H – Actual total	The final charged amount once it is known
I – Variance	Actual total minus approved planned amount
J – Amount paid	Everything paid so far toward this row
K – Balance due	Actual total minus amount paid
L – Due date	When the next or final payment is owed
M – Payment date	When you last paid
N – Receipt reference	Invoice number, email subject or file name of the receipt
O – Refundable deposit (Y/N)	Marks deposits you expect to get back

Leave an amount blank when you don't know it yet, and highlight the cell or add a follow-up note. Do not type zero. A zero looks like a confirmed free item and quietly lowers your totals, while a blank stays visibly unfinished.

Group rows into categories with subtotals

Janice Burtis's moving budget method lists each cost on its own row under an expense category and adds a subtotal for each section. It separates professional-moving costs, self-moving costs and other expenses. Copying that separation in column B makes the subtotals meaningful. It also lets you compare a hired move against a do-it-yourself move before you commit, without mixing in costs that apply either way.

To decide which rows you need, check your actual arrangements against the cost areas raised in Bellhops' move-out budgeting guide. Treat the list as prompts. Not every move incurs every item.

• Moving services or rental transport
• Packing supplies
• Storage
• Travel to the new apartment
• Housing deposits
• Utility setup
• Initial household purchases for the new place

Add first-month rent only if you are tracking the total cash required to move in, and label that row clearly as move-in rent. Ongoing rent, groceries and other recurring household costs belong in your regular monthly budget, not in this ledger.

How estimated, quoted, planned and actual amounts fill in over time

• Early planning: enter rough figures in Estimated amount for every row you expect to need. Leave unknowns blank and flagged.
• After choosing a provider: do your offer-by-offer comparison on a separate sheet. Copy only the selected quote's amount into Quoted amount and its date and reference number into column F.
• When you commit: set Approved planned amount. This is the baseline that variance is measured against, so change it only if you deliberately change the plan.
• When money leaves your account: update Amount paid and Payment date, and record the receipt reference in the same sitting.
• When the final bill arrives: enter Actual total. Variance and Balance due then show whether the item ran over and what is left to pay.

Calculation rules

These formulas assume headers are in row 1 and the first expense is in row 2, using the column letters above. The same functions work in Excel and Google Sheets. Each formula returns a blank instead of a misleading number when its inputs are missing.

Variance (I2):        =IF(OR(G2="",H2=""),"",H2-G2)
Balance due (K2):     =IF(H2="","",H2-J2)

Total tracked cash outlay:   =SUM(H2:H200)
Refundable deposits:         =SUMIF(O2:O200,"Y",H2:H200)
Non-deposit spending:        =SUMIF(O2:O200,"N",H2:H200)
Total variance:              =SUM(I2:I200)

A positive variance means the item cost more than planned (unfavorable). A negative variance means it came in under plan.

• Count a deposit or advance payment once. If you pay part of a moving service upfront, record that as a payment against the service's row, not as a separate expense. Otherwise the same money is counted twice.
• Keep refundable deposits in your total cash outlay, because you still need that money on hand. Track them separately from nonrefundable spending, because you should get them back.
• For upcoming payments, keep a due-date view. Filter to rows where Balance due is greater than zero and sort by Due date, so the next payment is always at the top.

Worked example (hypothetical)

This illustrative example uses invented figures to show how the columns interact. It is not a price guide.

Item	Approved planned	Actual total	Variance	Paid	Balance due	Refundable
Moving service	$600	$660	+$60	$150	$510	N
Packing supplies	—	$80	—	—	—	N
Housing deposit	—	$1,200	—	—	—	Y

The moving service ran $60 over plan. The $150 advance is recorded as a payment against that row, which leaves $510 due. It is not added as an extra expense. Across the three rows, total tracked cash outlay is $1,940. Of that, $1,200 is a refundable deposit and $740 is non-deposit spending.

Keeping the ledger reliable

• Save each receipt or invoice with a file name that starts with the Expense ID, so column N points to something you can find.
• Check the due-date view each time you book a service or receive a new bill.
• Fill in any blank flagged amounts before move day, and finish the Actual total column once the last bills arrive.
• When a refundable deposit comes back, note the date and amount returned in the deposit row's notes, so you can confirm it was refunded in full.