Bill of Materials (BOM) Template

An editable BOM workbook with column guidance, revision history and best practice

A bill of materials is the single list that tells purchasing what to buy, the assembler what to place and the reviewer what was intended. This template gives you a BOM layout that assemblers can read directly: one line per unique part, reference designators that match the schematic and placement file, a full manufacturer part number, approved alternates and a clear do-not-place flag.

Download the workbook, delete the example rows and paste in the export from your CAD tool. The PDF explains what each column is for, the rules that keep a BOM consistent with the design data, and how to control revisions so the BOM, Gerbers and placement file always describe the same board.

What is inside

  • Workbook sheet BOM with 14 columns, each with a header note
  • Generic example rows for resistors, capacitors, an IC, a connector and a DNP part
  • Revision history sheet for recording every BOM change
  • Instructions sheet summarising how to fill in and release the BOM
  • Column-by-column guide explaining what goes in each field
  • Checklist to run before sending the BOM for a quote or a build

Contents

  1. What a good BOM does
  2. Column guide
  3. Rules that keep the BOM consistent
  4. Revision history and release
  5. Before you send the BOM
  6. Notes and limits

Formats: PDF document, Excel workbook, CSV (BOM sheet). Sign in to download for free.

Related courses

Discuss your project

Email support@aavico.com or use Get in Touch when the website finishes loading.