Parts spreadsheet built on the phase plan
Parts spreadsheet structure: phase gates, vendor notes, fitment risk, restock policy, and install timing. Not a fantasy BOM that funds ten phases at once.
A parts spreadsheet should tell you what to buy, when to buy it, and how to verify it fits before installation. Most parts spreadsheets are aspirational part-number dumps that fund the whole build at once and punish every mid-course correction.
The difference is whether the spreadsheet serves the phase plan or replaces it.
A working spreadsheet locks the phase first and buys second. An aspirational spreadsheet is a shopping list with formulas.
What the spreadsheet is not
Not a complete BOM for the finished vehicle. Not an interchange reference. Not a vendor price comparison that updates daily. Not a trophy list of what NOS you want to own.
Those are different documents. This is an operator’s checklist: phase-gated, fitment-aware, with return risk and install timing baked in.
The restoration phases guide covers the gate system. This essay covers the spreadsheet that enforces it.
The columns that matter
Column 1: Phase gate
Which phase needs this part. Not “eventually.” Not “nice to have.” The phase name that must be open before money moves.
Examples:
- Disassembly
- Metal / structure
- Mechanical hard parts
- Paint / body
- Reassembly / trim
No phase listed means no order. If I can’t name the phase, I’m not ready to spend.
Column 2: Part description
Real description, not poetry. Include: what it is, what it does, where it mounts. Enough that future-you doesn’t have to decode “bezel kit” six months later when three bezel kits are staged on different shelves.
Example: “Door glass channel, driver front, upper run, repro weatherstrip” beats “door seal kit.”
Column 3: Fitment notes / risk
Any known mid-year split, option-driven variance, or measurement requirement. This is where you write “verify glass is seated before ordering channel” or “cab is 1972, bed measures like 1970, order bed parts separately.”
If the part has a fitment trap, the trap goes here before the order, not after the return.
Column 4: Vendor / source
Which vendor. Include return policy if it’s harsh or unusual: “Vendor A, 25% restock, no returns after 14 days” tells you more than “Vendor A.”
If you’re splitting an order to reduce return risk, you’ll see it here when two risky parts land with two different friendly vendors instead of one package deal with a bad policy.
Column 5: Part number / listing reference
Vendor part number, listing URL, or enough detail to re-find it. Not because the number is sacred. Because when the part arrives wrong, you need proof of what they claimed.
Column 6: Price (with return cost)
Actual price plus the restock fee if you return it. A $100 part with a 25% restock fee is a $125 decision if fitment is uncertain.
I add return shipping to this column when the vendor doesn’t cover it. A $15 part that costs $22 to return is not a $15 risk.
Column 7: Order date / received date
When you ordered, when it arrived. Useful for tracking lead times and for proving you returned it within the window when a vendor gets selective about dates.
Column 8: Install phase / timing
When this part actually gets installed. Often later than the phase that needs it ordered.
Example: “Order in mechanical phase, install after paint cures” keeps you from handling fresh brightwork with dirty gloves or stacking parts in the bay during metalwork.
Column 9: Status
Ordered, received, inspected, staged, installed, returned. One word. No essays.
If something is “on hold pending measurement,” that’s a status. It tells you not to order the next dependent part until this one clears inspection.
What this structure prevents
1. Out-of-phase buys
If the phase gate column is empty or says “someday,” the order doesn’t happen. That’s the rule.
2. Forgotten fitment traps
Writing “verify hole spacing before paint” in the fitment column means you check before the panel goes to the booth. Skipping the note means you find out after clear coat that the bezel is early and the panel is late.
3. Return amnesia
When vendor and return policy are written next to the price, you remember that the cheap source has a 30% restock fee. That memory changes the order, or at least changes the measurement discipline before install.
4. Duplicate orders
Status tracking shows what’s already on the shelf. I’ve watched people order the same weatherstrip kit twice because the first one went into a box and the spreadsheet said “not received.”
A minimal starting template
You don’t need pivot tables or conditional formatting. You need:
| Phase | Part description | Fitment notes | Vendor (return policy) | Part number | Price + return cost | Order date | Install timing | Status |
Fill the phase column first. Everything else serves the phase.
How this connects to the one-page intake
The printable intake is the decision document: vehicle identity, phase plan, known fitment risks, vendor policies, order gates. The spreadsheet is the transaction log that executes it.
Intake says: “Do not order trim until paint is cured and panels are dimensionally stable.”
Spreadsheet enforces: trim items have phase gate “Reassembly / trim” and install timing “after booth, 30-day cure.”
They’re not the same document. The intake is strategy. The spreadsheet is operations.
What I don’t track here
I don’t track consumables (sandpaper, solvents, tape) unless they’re big purchases or phase-gated (paint system, undercoating).
I don’t track fasteners in detail unless they’re visible or have a specific finish requirement.
I don’t track tools.
Those are different lists. This spreadsheet is for parts that have a fitment risk, a return risk, or a phase dependency.
The simplest gate
Before you add a line to the spreadsheet, finish this sentence:
“I am ordering this part in [phase], installing it in [phase or timing], and if it’s wrong, returning it costs [amount] under [vendor policy].”
If you can’t finish the sentence, you’re not ready to add the line.
Bottom line
A parts spreadsheet matches the phase plan when every line has a phase gate, a fitment note, and a return-cost price. Everything else is optional.
Build the spreadsheet to serve the phases, not to document the fantasy of the finished car.
The Phase Plans series covers sequencing and gates. Log the high-level phase decisions on the printable intake before you populate the spreadsheet.
Keep reading
- One-page restoration intake before you buy
- Phase a restoration so parts don’t sit
- Budget the phase, not the fantasy car
- Print the phase budget one-pager before the next order.