How to Prepare a BOM File: Template and Common Mistakes
A good bill of materials (BOM) is the foundation of a fast and accurate sourcing process. A messy or incomplete BOM leads to wrong part matches, delays and inaccurate cost estimates. In this article we cover step by step how to prepare a clean BOM file.
Essential columns a BOM should have
- MPN (manufacturer part number): the most reliable key for matching; it must be present.
- Manufacturer/brand: clarifies things, since the same MPN can exist across different manufacturers.
- Quantity: the number of times each item is used in the product.
- Reference (designator): the position on the board such as R1, C3 (optional but useful).
Use the MPN correctly
The heart of a BOM is the MPN. Using the full MPN instead of a general description ("10k resistor") ensures the correct part is matched. Write MPNs exactly, character for character, with their suffixes; a one-character difference means a different part.
File format and template
Prepare the BOM as Excel (XLSX) or CSV, with the first row as the header row. Column names can be in English or your own language — the system detects them automatically. Using a consistent template gives the same result every time you upload the file. You can upload the list you prepare directly to the BOM tool.
Common mistakes
- Writing only a general description instead of the MPN (makes matching harder).
- Combining several parts on a single line.
- Leaving the quantity column blank or writing it as text.
- Forgetting the header row or naming columns inconsistently.
Revision and version tracking
A BOM is a living document; it's updated as the design changes. Marking each version with a revision number and date keeps you from confusing which board was built with which bill of materials. Producing with the wrong BOM version is one of the most expensive and most common mistakes.
Why does a good BOM save time?
A clean BOM with full MPNs requires almost no manual correction during pricing and sourcing; an incomplete or ambiguous BOM means researching each item one by one. A well-prepared list from the start saves hours on projects with hundreds of items and lowers the chance of error.
Frequently asked questions
What should I write if I don't know the MPN?
Write the manufacturer + full part description as much as possible; the most likely candidates are suggested during matching, and you can pick the right one.
Excel or CSV?
Both are supported. Excel is more readable; CSV is practical for transfer between systems.
What happens after I upload the BOM?
Parts are matched, price/stock is retrieved and missing/risky items are flagged; you see the total cost on a single screen.
Conclusion
A clean BOM starts with full MPNs, clear quantities and a consistent template. By uploading the list you prepare to the BOM tool, you can price it in minutes and find alternatives for risky items with the cross-reference tool.