Multi-Level BOM Checker & Cost Rollup
Check Excel and CSV bills of materials for hierarchy errors and conflicting part data. Flatten purchase quantities and calculate unit and batch BOM costs.
Drop your BOM here
XLSX, XLS or CSV · up to 4 MB and 5,000 data rows
How to Analyze a Multi-Level BOM Step-by-Step
- Upload a BOM and pick the worksheet and header row.
- Map the part number, quantity per parent, and level columns. Add unit costs for BOM cost analysis.
- Review hierarchy errors and conflicting prices or descriptions in the audit tab.
- Check the flattened purchase BOM and set a batch quantity to see production totals.
- Unlock the full report and export your audit, purchase BOM, and indented costing to Excel.
Flat vs. Indented BOM Cost Rollup
| Flat BOM | Indented BOM | |
|---|---|---|
| Hierarchy | Each row belongs to the product | Rows can belong to subassemblies |
| Quantity | Use the listed quantity per product | Multiply quantities along each parent chain |
| Purchasing | Combine repeated part numbers | Combine extended quantities across assemblies |
| BOM costing | Add each line’s known cost | Roll up leaf part costs through the hierarchy |
BOM checker FAQ
What BOM file formats can I upload?
Upload an XLSX, XLS, or CSV file up to 4 MB with up to 5,000 BOM data rows.
How do I analyze a multi-level BOM in Excel?
Map part number, quantity, and level. Use outline paths such as 1.2.1 or integer levels starting at 0, then review the audit and rollup.
How does the BOM checker handle repeated part numbers?
It combines purchase quantities for each part number and flags different descriptions or unit prices across rows.
How does missing unit cost affect the rollup?
Missing prices are flagged. The cost summary shows known costs and the share of purchase parts with missing prices.
What is free and what costs a credit?
Preview and sample export are free. A full upload report and Excel export cost one credit. The first-login trial covers up to 50 BOM data rows and 65 nonempty worksheet rows.
SpecRivet assists with BOM review. Verify quantities, costs, and flagged issues before relying on results for purchasing or production. To the extent permitted by applicable law, SpecRivet’s total liability for a claim is limited to the amount you actually paid for the credit pack associated with that claim. Mandatory rights and liabilities that cannot lawfully be limited still apply.