Bill of Materials Template

Every component needed for a build with quantity, unit cost, extended cost and order status, tied to suppliers and their lead times.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Construction

Tables

Components, Suppliers

Fields

23

Views

grid, kanban, cards, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Components

14 fields · 6 sample rows

  • BOM (Grid)
  • Ordering board (Kanban)
  • Catalogue (Cards)
  • Cost breakdown (Dashboard)
ComponentTextPart no.TextCategorySingle selectSpecificationTextQuantityNumberUnitSingle selectUnit costCurrencyWastagePercentExtended costFormulaSupplierLink to another tableLead time (days)LookupOrder statusSingle selectNeeded byDatePhotoAttachment
ISMB 200 steel beamST-200StructuralIS 2062 E250, 6 m48.00nos₹18,500.002%₹9,05,760Jindal Steel Traders7Ordered29 Nov 2026
HSFG bolts M20 × 80FB-2080FastenersGrade 8.8, galvanised600.00nos₹42.005%₹26,460Unbrako Distributors3Received24 Nov 2026
FRLS copper wire 2.5 sq mmEL-25Electrical90 m coil, red40.00nos₹2,350.000%₹94,000Havells Dealer — Pune4To order14 Dec 2026
CPVC pipe 25 mmPL-25PlumbingSDR 11, 3 m length220.00nos₹310.005%₹71,610Astral Pipes Depot10Backordered3 Dec 2026
Vitrified floor tile 600×600FN-66FinishesMatt, ivory950.00sqm₹685.008%₹7,02,810Kajaria World14To order29 Dec 2026
Tile adhesiveCN-TAConsumablesC2TE, 20 kg bag190.00bag₹540.003%₹1,05,678Kajaria World14To order29 Dec 2026
Field details
Component · Text
Part no. · Text
Category · Single select
Structural, Fasteners, Electrical, Plumbing, Finishes, Consumables
Specification · Text
Quantity · Number
Unit · Single select
nos, m, kg, sqm, bag, litre, set
Unit cost · Currency
INR
Wastage · Percent
Extended cost · Formula
ROUND({Quantity} * (1 + {Wastage}) * {Unit cost}, 0)
Supplier · Link to another table
Links to Suppliers
Lead time (days) · Lookup
Lead time (days) via Supplier
Order status · Single select
To order, Ordered, Partly received, Received, Backordered
Needed by · Date
Photo · Attachment

Suppliers

9 fields · 5 sample rows

  • Suppliers (Grid)
SupplierTextContact personTextPhonePhoneEmailEmailLead time (days)NumberRatingRatingComponentsLink to another tableLines suppliedCountOrder valueRollup
Jindal Steel TradersManoj Agarwal+91 98220 44001[email protected]74/5ISMB 200 steel beam1₹9,05,760
Unbrako DistributorsLeena Pinto+91 98200 5500235/5HSFG bolts M20 × 801₹26,460
Havells Dealer — PuneSachin More+91 98230 6600344/5FRLS copper wire 2.5 sq mm1₹94,000
Astral Pipes DepotImran Shaikh+91 98500 77004103/5CPVC pipe 25 mm1₹71,610
Kajaria WorldNeeta Joshi[email protected]144/5Vitrified floor tile 600×600, Tile adhesive2₹8,08,488
Field details
Supplier · Text
Contact person · Text
Phone · Phone
Email · Email
Lead time (days) · Number
Rating · Rating
Components · Link to another table
Links to Components
Lines supplied · Count
Order value · Rollup
sum of Extended cost via Components

Bill of Materials Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates