A BOM template withthe columns that matter.

Assembly, component, quantity per unit, cost, vendor — the recipe format that scales from one product to a catalog, in Excel or Google Sheets.

Download for Excel Download CSV

Free · No email required · Works in Google Sheets

bill-of-materials-template.xlsx

	A	B	C	D	E	F	G	H
1	Assembly	Component	Part #	Qty per unit	Unit cost	Line cost	Vendor	Notes
2	Wall-Mount Bracket	Steel Plate 6″×8″	PRT-0113	1	$14.20	$14.20	Calder Steel
3	Wall-Mount Bracket	Hex Bolt M8	PRT-0341	4	$0.35	$1.40	Bexley Tool Co.
4	Wall-Mount Bracket	Powder Coat — Black	SVC-0027	1	$6.00	$6.00	Foundry & Co	Outsourced
5

What's in the template.

One row per component, grouped by assembly

Qty-per-unit and unit cost with a line-cost column

Vendor column so reordering has a first call

Example assembly filled in so the format is obvious

How to use it well.

One assembly, many rows

Group component rows under each assembly name. Sub-assemblies get their own group.

Keep costs current-ish

Stale unit costs quietly rot your quotes. Date your last price check in Notes.

Multiply for a build

Line cost × build quantity tells you material cost per run — the number quoting needs.

When the spreadsheet becomes the problem.

A spreadsheet BOM can't see your stock — it answers "what's in it?" but never "can we build 40 right now?" Live BOMs compute shortages and draft the POs.

See TrackFinch BOM software

More free templates.

Work Order TemplateThe fields a real shop needs.Maintenance Log TemplateEvery service event with date, work performed, parts, cost, and next-due.Preventive Maintenance Schedule TemplateEvery machine, every recurring task, and the two dates that matter: last done and next due.

Frequently asked questions

What does a bill of materials include?

Every component in a product with quantity per unit — done properly, also part numbers, unit costs, and vendors. See our plain-English guide: what is a bill of materials?

How do I handle sub-assemblies in a spreadsheet?

Give the sub-assembly its own row group, then reference it as a single component line in the parent. It creaks — which is exactly why multi-level BOMs eventually move to software.

Will this import into TrackFinch?

Yes — the columns match the importer on purpose. Your spreadsheet BOMs become live BOMs in one pass.

Runs on the same ledger.

Everything in TrackFinch shares one source of truth — start anywhere, the rest is already connected.

MRP softwareBOMs, purchasing, and material planning on the same ledger as the floor.Asset tracking softwareEvery tool with a status, a location, and a history — QR checkouts included.Work order softwareJobs your crew can update from any phone, with materials already reserved.

Or skip the spreadsheet era entirely.

Import this exact format into TrackFinch and the sheet becomes a live system. Free for 14 days.

Start free trial Book a demo

Free for 14 days · Full access · Cancel anytime