The Problem with Single-Level BOMs and Excel
Most Indian SME manufacturers store their finished-product structure in three places at once: a master in Excel, line items in Tally invoices, and the real version in the production supervisor's head. Tally was built as accounting software, not manufacturing software — its BOM is a single-level posting shortcut, not a product tree. As soon as your finished good has even two layers of sub-assembly, the real BOM moves to a spreadsheet and Tally is left holding only the invoice trail.
The cost shows up in three ways:
- Margins are wrong by 4–15% because sub-assembly cost roll-ups are calculated by hand.
- Material is ordered late or in excess because MRP can’t explode the BOM automatically.
- Engineering changes are lost because there’s no version control on the Excel file the floor uses.
For a deep dive into why this happens, read Multi-Level BOM Explained — Why Single-Level Bills of Materials Break.
What OEMup’s Multi-Level BOM Does
Unlimited assembly depth
Build BOM trees as deep as your product needs — finished good → sub-assembly → sub-sub-assembly → raw material. No artificial cap on levels.
Phantom assemblies
Mark transient assemblies as phantom so they explode at MRP time without creating a stock posting. Keeps your store room realistic and your costing accurate.
Alternate components per line
Define primary + alternate components per BOM line so production can substitute when a supplier is short, without breaking the BOM or the cost roll-up.
BOM versioning with effective dates
Every revision is a new version with an effective-from date. Manufacturing orders on older versions keep using that version, so historical costing and the audit trail stay clean.
Manufacturing-order & MRP linkage
Raise a manufacturing order and OEMup explodes the BOM, calculates material requirements and allocates stock — without a single Excel paste.
Costed BOMs with roll-up
Material, labour and overhead cost roll up through every level. Actuals from production feed back so you see planned vs. actual cost per finished unit, automatically.
OEMup vs Tally + Excel — for BOM Specifically
| BOM Capability | OEMup | Tally + Excel | Zoho Inventory |
|---|---|---|---|
| Multi-level (sub-assemblies) | ✓ Unlimited depth | ✗ (Excel only) | ~ Composite items (1 level) |
| Phantom assemblies | ✓ | ✗ | ✗ |
| Alternate components | ✓ | ✗ | ✗ |
| BOM versioning | ✓ Effective-from dates | ✗ (file naming only) | ✗ |
| Manufacturing-order linkage | ✓ Auto-explode at MO | ✗ | ✗ |
| Costed BOM with actuals | ✓ Planned vs actual | ~ Manual | ✗ |
| GST e-invoice on BOM-driven invoices | ✓ Native | ~ Via Connector | ✓ (via Books) |
Who This Is For
OEMup’s multi-level BOM is built for Indian SME manufacturers who outgrew Tally + Excel but can’t justify SAP. Typical fits:
- Pump and motor manufacturers — multi-stage assemblies with bearings, shafts, impellers, housings; alternate components per region.
- Auto-component fabricators — engineering changes are constant; versioning is non-negotiable.
- Compressor and pneumatics shops — phantoms for assemblies that pass straight to the next operation.
- Engineering and tool-room manufacturers — one-of-a-kind BOMs per job, costed per manufacturing order.
- Chemical and FMCG packaging — recipes with alternate raw materials when supplier prices move.
See your real BOM running on OEMup in 20 minutes
Book a free demo. Bring a sample BOM (Excel is fine) and we’ll set it up live on a sandbox account, including version history, costing, and a sample manufacturing order.
Book Free Demo →Frequently Asked Questions
What is a multi-level BOM?
Why is Tally’s BOM not enough for manufacturers?
Does OEMup support phantom and alternate components?
Can I version my BOMs as the product evolves?
How does the BOM link to manufacturing orders and costing?
Related: Multi-Level BOM Explained (full guide) · MRP Explained · Capacity Planning for Small Factories · Best Tally Alternative for Manufacturers · All Features