Basement finishing budget spreadsheet: quotes, change orders and contingency

Finishing a basement can hide surprises behind the walls: moisture, old wiring, low ducts. A budget sheet that separates what you planned from what you have agreed to pay shows how much of the contingency the overruns have used.

General information only, not financial, construction or legal advice. Contingency, holdback and payment-split percentages are your own inputs, and payment and deposit rules vary by contract and by state or province; check yours. Names and numbers in the example are invented.

What changes for this kind of project

In this example the basement splits into framing and drywall, electrical and a plumbing rough-in, while you handle the flooring, paint and permit yourself. The Budget tab gets one row per scope line, and each line names one contractor, or none when you buy the item yourself.

Where the walls and ceiling hide things, a line can run over its budget. A change order for ductwork or an uneven wall is logged once, with a status, and only an approved one moves into Committed. That keeps a pending idea from quietly raising a line you have already agreed to.

A worked example: Basement finish, 700 sq ft

Invented numbers, to show the shape. Settings on Start Here: contingency 15% (an example value you set), total project budget $37,000.

The contingency pool is $5,550 ($37,000 x 15%). That leaves $31,450 to share out as line budgets. The lines below add up to $31,400, so $50 is unallocated.

Change orders on the Change Orders tab. Only Approved rows move into Committed:

What the summary shows

• Committed: $30,370. Paid: $17,150. Unpaid commitment: $13,220.
• Contingency used: $1,370, what each line's committed total goes above its line budget, added up. Contingency left now: $4,180.
• Pending exposure (Proposed change orders): $380. Contingency left if every proposed change order were approved: $3,800.

Where each piece goes in the workbook

1. Start Here: Type the total project budget, the contingency percentage and your list of contractors. The percentages are example values you overtype; the pool and the unallocated amount are worked out for you.
2. Budget: One row per scope line with a unique Line ID, the room, the contractor, the line budget and the accepted quote. A line with no accepted quote yet reads Not committed until you type one.
3. Change Orders: Log each change against its Line ID with an amount and a status. Approved rows raise Committed, Proposed rows count as pending exposure and Rejected rows count nowhere.
4. Payments: Log each payment with its Line ID and invoice reference. The tie-out check on this tab tells you if a payment has a blank or misspelled Line ID and never reached a Budget row.

Two formulas worth a cell of their own

• Committed for one room: =SUMIFS(Budget!$K$6:$K$65,Budget!$B$6:$B$65,"Basement") returns $25,470 on this example.
• Contingency used, the sum of the Overrun now column: =SUM(Budget!$S$6:$S$65) returns $1,370.

Four tracking tips

1. Give each separately quoted job its own scope line, even when one contractor does two of them. Here the same crew quotes framing with insulation and drywall separately, so they get separate lines and separate flags.
2. Park a basement bathroom on its own Room value. The plumbing rough-in then shows up separately in the room summary, so you can see whether the bathroom or the open space is driving the spend.
3. Leave owner-bought lines with no contractor. The Contractors tab then lists only the firms you named, and the lines you buy yourself are totalled in a separate row at the bottom.
4. Look at Contingency left if all pending approved before you say yes to a proposed change order. It shows what would be left in the pool if you approved every open request.

Questions

Where do I put the permit fees?

Add a scope line in the Permits & fees category with no contractor, a line budget and the fee as the accepted quote. Log the payment against that Line ID so it shows as paid.

Can I track a basement finish and the rest of the house together?

The workbook holds one project per file. Keep the basement as its own copy, or give the other rooms their own Room values in the same file if you treat the whole job as one budget.

Related renovation guides

• Renovation budget by room spreadsheet: SUMIFS per room, with an overrun flag
• Renovation contingency tracker: how much contingency is left
• Renovation change order tracker: a spreadsheet for homeowners

More renovation budget guides

• Renovation budget spreadsheets by room and project type
• Budget for adding a new bathroom: rough-in, fixtures and permits
• Attic conversion budget: handling structural surprises
• Deck budget spreadsheet: material upgrades and impact on contingency
• Exterior renovation budget: comparing roofing, siding and window bids
• Fixer upper budget: everything at once, commit as quotes arrive
• Garage conversion budget: multiple trades and owner-bought materials
• Home addition budget: design, permits, general contractor and utilities
• Laundry and mudroom remodel budget: owner-bought appliances and small change orders
• Owner as general contractor: budget, payments and milestones per trade
• Primary suite renovation: bedroom, bathroom and closet with separate trades
• Whole house renovation budget: kitchen, bathroom and living spaces