Bill of Materials report
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Audience: Center admin, inventory manager, service-operations manager
The Bill of Materials (BOM) report lists every product consumed against a service appointment, with planned-versus-actual quantities and provider attribution. Use it to validate the true cost of service delivery, identify over-consumption or waste, and spot products that are routinely added by providers but missing from the standard service-product mapping.
The BOM report is a legacy report, listed on the Reports Dashboard under Reports > Inventory > Bill Of Materials; its row offers Try New Version. It is generated from the same consumption data captured by the Track product consumption for services workflow.
Note β disambiguation among related reports:
- This report (BOM) β per-appointment breakdown comparing planned vs. actual consumption per service.
- Product consumption report β center-level OR organization-level summary by product (no per-appointment detail).
Use BOM for forensic analysis of a specific service's consumption; use Product consumption for product-summary trend analysis.
Data refresh: Real-time on Refresh. Data appears once the appointment is closed (the report keys off appointment-completion, not invoice closure).
On this page
- Before you begin
- Open the report
- Filter and date range
- Understand the data
- Columns
- Use cases
- Troubleshooting
- Related articles
Before you begin
Permission: Bill of Materials under View Inventory Reports in the Inventory Manager section of the security role β required to access the BOM report.
- Required setup β Service-product consumption mappings (BOM) MUST be configured for the services you want to analyze. See Track product consumption for services. Per, appointments performed against services with NO BOM mapping are excluded entirely from the report β they do not appear with blank planned values.
- The center has recorded at least one completed appointment with a mapped consumable product in the date range you intend to analyze. Empty result sets usually mean no consumption was recorded OR no BOM mappings exist, not a permissions or filter issue.
- For batch-tracked products, batch and expiry management is configured so the report can attribute consumption to specific batches. See Configure batch and expiry management.
Open the report
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory > Bill Of Materials.
- Set the date range and any additional filters β see Filter and date range.
- Click Refresh.
- To export, click the Excel or CSV icon.
Filter and date range
| Filter | Effect |
|---|---|
| Date range | Restricts the report to appointments completed within the selected range. The report uses the appointment's service date, not the date consumption was recorded. |
| Center | Restricts the report to a single center. The center selector at the top of the screen is honored. |
| Service Category | Restricts the report to a service category. |
| Service | Restricts the report to one or more services. |
| Employee (Therapist column) | Restricts the report to consumption recorded against a specific provider. |
| Product | Restricts the report to a single product. |
| Manually Added | Restricts the report to consumption rows the provider added manually (not part of the standard service mapping). |
Tip: For monthly BOM analysis, set the date range to the calendar month and leave Service, Provider, and Product unfiltered β then sort by Variance to surface the largest planned-vs-actual deltas across the whole center.
Understand the data
Planned vs. actual
The core insight is the comparison between Planned Quantity (Qty To Be Used) and Actual Quantity (Qty Used):
- Actual > Planned β Over-consumption. Providers used more product than the standard mapping specifies. Action: Adjust the BOM mapping on the service's PRODUCTS tab (Master data > Services > [Service]) if the mapping is now stale, or train providers on dosage if the mapping is still correct.
- Actual < Planned β Under-consumption. Less product was used than expected. Action: The provider may be conservative with high-cost product, or the mapping may be too generous; review the mapping value or audit provider technique.
- Actual = Planned β Consumption matches the standard.
- Actual = 0 with Planned > 0 β Auto-checkout was blocked at appointment close (typically because on-hand stock was insufficient at the appointment center). Action: Treat as a stock-replenishment signal, not as a no-consumption appointment β replenish at the center before the next service.
Manually-added flag
A row with Manually Added = Yes indicates the provider added the product to the appointment outside the standard mapping. Frequent manual additions for the same product on the same service are a signal that the mapping should be updated β see Track product consumption for services.
Tracked Automatically vs. Manually Added β value combinations
These two flags can independently be Yes or No, including both Yes (a default-tracked product was ALSO marked manually added during the appointment, e.g., when the provider added an extra unit beyond the auto-tracked default):
| Tracked Automatically | Manually Added | Meaning |
|---|---|---|
| Yes | No | Standard auto-checkout from the BOM mapping (the typical case). |
| No | Yes | Provider added the product manually during the appointment; no BOM mapping for it. |
| Yes | Yes | Auto-checkout fired AND the provider manually added additional units. |
| No | No | Should not occur in this report (excluded β no consumption recorded). |
Batch attribution
For batch-tracked products, the report shows the specific batch that the provider selected at consumption. Batch attribution supports First Expiry First Out (FEFO) audits β sort by Service Date and Batch Number to confirm providers are dispensing from the oldest batch.
Cost basis
The Cost column uses Perpetual Average Cost at the time of consumption β that is, the cost recorded in inventory at the moment the appointment was closed. This reflects the org's costing-method setting (Perpetual Average Cost or FIFO). It is NOT sale price and NOT the most-recent receipt cost. See Cost of goods report for the costing-method documentation.
Service unit semantic
Per, Qty To Be Used = service-product-mapping planned quantity Γ number of service units on the invoice. One service line = one service unit. For non-standard duration variants (e.g., a 90-minute service mapped from a 60-minute master), the scaling depends on whether the variant is a separate SKU or a multiplier of the master service; the join uses the invoice-line quantity, not duration.
Columns
The exact column headers shown on the report follow the live UI. Body prose in this article uses Provider for the role; the column header is the verbatim UI label Therapist.
| Column | Description |
|---|---|
| Service Date | Date the appointment was completed. |
| Center | Center where the appointment was delivered. |
| Service | Service that was performed. |
| Therapist | Provider attributed to the consumption (verbatim UI column header per code). For multi-provider services, attribution depends on the appointment-module split rule (β). |
| Product Code | Unique code of the consumed product. |
| Product Name | Name of the consumed product. |
| Units | Unit of measure for the product. |
| Qty To Be Used (Planned Quantity) | Planned consumption from the service-product mapping Γ number of service units on the invoice. |
| Qty Used (Actual Quantity) | Actual quantity consumed during the appointment, after any provider overrides. |
| Variance | Actual minus planned. Positive values indicate over-consumption; negative values indicate under-consumption. |
| Cost | Cost of the consumed quantity = Perpetual Average Cost at the time of consumption Γ Qty Used. Reflects procurement cost (not sale price). |
| Tracked Automatically | Whether the product was auto-consumed (from the service-product mapping's Track consumption automatically setting on the service's PRODUCTS tab β Master data > Services > [Service]). |
| Manually Added | Whether the provider manually added this product during the appointment, rather than it being part of the standard mapping. |
| Override Consumption | Whether a service-level or appointment-level consumption override was applied. Overrides are configured per Track product consumption for services and replace the default planned quantity for the affected appointment. |
| Batch Number | (Batch-tracked products only) The specific batch the provider dispensed from. |
| Expiry Date | (Batch-tracked products only) Expiry date of the batch dispensed. |
Worked example
A center wants to investigate over-consumption of a high-cost color product against its standard mapping.
- Set Date range: 2026-04-01 to 2026-04-30.
- Service: Hair Color (60-min).
- Click Refresh.
Sample (4 appointments):
| Service Date | Service | Therapist | Product | Qty To Be Used | Qty Used | Variance | Cost |
|---|---|---|---|---|---|---|---|
| 2026-04-04 | Hair Color (60-min) | Provider A | Hair Color B-3 | 1 | 1 | 0 | $11.05 |
| 2026-04-09 | Hair Color (60-min) | Provider B | Hair Color B-3 | 1 | 1.5 | +0.5 | $16.58 |
| 2026-04-15 | Hair Color (60-min) | Provider B | Hair Color B-3 | 1 | 1.5 | +0.5 | $16.58 |
| 2026-04-22 | Hair Color (60-min) | Provider B | Hair Color B-3 | 1 | 2 | +1 | $22.10 |
Insight: Provider B consistently exceeds the planned 1-unit mapping. Either the mapping is too low for Provider B's technique, OR Provider B is over-applying. Action: review the mapping on the PRODUCTS tab of the Hair Color (60-min) service (Master data > Services), then schedule a coaching conversation with Provider B if the mapping is correct.
The Cost column reflects Perpetual Average Cost at the time of consumption (Example 2 in the Cost of goods report shows how this value is calculated).
Use cases
- Variance investigation. Sort by Variance descending to surface services where actual consumption consistently exceeds planned. Use the result to drive mapping updates or provider-retraining conversations.
- COGS validation. Cross-reference the BOM report's Cost column with the Cost of goods report to validate that service-consumed COGS rolls up correctly into the period's COGS total.
- Provider-level analysis. Filter by Therapist column (Provider) to see consumption patterns for a single provider β identifying outliers (high-variance providers) or new hires who need additional product-handling training.
- Mapping completeness audit. Filter by Manually Added = Yes to find products that providers add on most appointments. These belong in the standard service-product mapping.
- FEFO compliance audit. For batch-tracked products, sort by Service Date and Batch Number β confirm that providers selected the batch with the soonest expiry available at consumption time.
- Retail vs. consumable boundary. Cross-reference with the Inventory traceability report to confirm a consumed unit was correctly classified as service consumption (not as a retail sale).
Troubleshooting
| Issue | Likely cause and fix |
|---|---|
| The report is empty for a date range I expect to have consumption. | The date range is interpreted against the service date (appointment-completed date), not the date consumption was recorded. Widen the range, or verify appointments were marked complete in that window. Also check that the Enable auto checkouts for consumable products org setting was on at the time β without it, no consumption events are written. |
| The Therapist column is blank for some rows. | Provider attribution depends on Appointment Book configuration. For multi-provider services, the attribution behavior is governed by the Appointment Book module β see the cancellation/multi-provider notes in Track product consumption for services. |
| Variance is consistently negative for a high-cost service. | The standard service-product mapping is over-specified for that service, or the provider is dispensing less than the mapping calls for. Review the mapping on the service's PRODUCTS tab (Master data > Services > [Service]) and adjust the planned quantity, or audit provider technique. |
| The report does not show the Manually Added column. | The column may be hidden by default in some legacy report layouts. Check column visibility settings, or export to CSV β all columns are included in the export regardless of on-screen visibility. |
| BOM report Cost does not match the Cost of Goods report total for the same period. | The BOM report reflects only service-consumed product. POS (Point of Sale) retail sales and other COGS components are excluded. Cross-reference using the Cost of goods report for full COGS reconciliation. |
| Cannot access the report β "permission denied" or the report does not appear in the menu. | The user lacks Bill of Materials under View Inventory Reports in the Inventory Manager section of the security role. Ask your admin to grant the permission to the user's role. |