Inventory reports
Audience: Inventory managers, finance teams, and admins who consult inventory reports for stock-level visibility, audit history, costing analysis, and reconciliation against external systems.
Zenoti provides inventory reports across two report frameworks: V2 (the modern grid framework, used for the most analytical-heavy reports) and Legacy (the classic reports, still in use for some niche cases). This article is the index β pick the report you need from the tables below, follow the link for filter and column detail, and refer to the Costing methods callout for terminology consistency across reports.
Modern vs legacy permissions. Modern (V2) inventory reports are granted per report under Inventory in the Reports(V2) section of the security role; classic inventory reports are granted by report area under View Inventory Reports in the Inventory Manager section. The two systems are independent β granting one does not grant the other. When configuring roles, set both as needed.
On this page
- Before you begin
- Costing methods used in V2 reports
- V2 inventory reports
- Legacy inventory reports
- Audit-related reports and editing
- Transaction types and states visible in inventory reports
Before you begin
- Ensure you have the required role permissions to access inventory reports.
- Some reports require center-level access. Select the appropriate center before generating a report.
- Editing of delivered orders and of check-outs is restricted to the trailing 90 days. This is a system constraint, not a setting your organization turns on or off. A separate financial lock, if your organization uses one, can restrict editing further.
Permission: The specific action required under the Inventory report permissions group varies by report β see the V2 table below for each report's required permission. See the Inventory permissions FAQ for the full list.
Permission: EditPOLimitless under Inventory β required to edit audit details in the audit history report.
Permission: Approve Reconcile under Inventory β required to approve reconciliation.
Permission: AUDIT_BACK_DATE under Inventory β required to back-date audits.
Costing methods used in V2 reports
Across V2 reports, two costing methods drive the cost columns and filters: Perpetual Average Cost and FIFO (First In First Out). These map to the two values the system uses internally for costing. Use these exact names β drift names like "Average Price", "Average Cost", or "Perpetual Average" without "Cost" are non-standard and should not be used.
Note on Retail Profitability. The Retail Profitability report is a separate V2 report that exposes three Cost-of-Goods-Sold columns side by side in one report β Perpetual Average, Latest Procurement Price, and Configured Purchase Price. These three columns are NOT three values of the costing-method selector; they are three columns the user can compare in one report. Other V2 reports use only the two-value costing-method selector.
V2 inventory reports
These reports are part of the modern reporting framework. All V2 reports use the advanced grid view and support interactive filtering, grouping, and flat-file export. Column sorting and filtering are enabled per column by the report configuration β not every column of every report is sortable or filterable. Pagination is supported; the default page size is 10 rows. For very large result sets, the export is delivered by email rather than downloaded inline.
Permissions for these reports are under the Inventory group in the Reports(V2) section of the security role.
| Report | Description | Permission action |
|---|---|---|
| Current stock report | Real-time on-hand stock quantities and values per product, center, and product type | Current Stock Report |
| Stock ledger report | Transaction-level stock movement log covering all inflow and outflow event types | Stock Ledger Report |
| Inventory aging report | Stock aging analysis with 30/60/90-day inflow buckets and last-quarter outflow for slow-moving identification | Inventory Aging Report |
| Inventory traceability report | Full audit trail with batch, employee, guest, and service tracking for batch-tracked products | Inventory Traceability Report |
| Near-expiry report | Batch-level expiry monitoring with 30, 60, 90, and 180-day buckets | Near Expiry Report |
| Cost of goods report | Per-transaction COGS analysis with weighted average and last-procured-cost comparisons | Cost of Goods Report |
| Retail Profitability report | Retail gross profitability by product β net sales, COGS under three costing views, and gross profit and margin | Retail Profitability Report |
Access V2 inventory reports
You can reach any V2 inventory report directly from the Reports Dashboard, or navigate to it by URL using the report's code.
Navigate to Reports. The Reports Dashboard is the landing page.
In the Inventory section, select the report you want to view.
Set your filter criteria. Available filters vary by report but typically include:
- Centers β Select one or more centers.
- Date range β Choose the reporting period (required for transaction-based reports).
- Product categories β Filter by category or sub-category.
- Vendors β Include specific vendors only.
- Brands β Filter by product brand.
- Business units β Filter by business unit.
- Products β Select individual products.
- Product type β Retail, Consumable, or Both.
- Group by β Group results by a configurable column dimension (available columns vary by report).
- Costing method β Perpetual Average Cost or FIFO (where applicable; see Costing methods used in V2 reports).
The Current Stock, Stock Ledger, and Inventory Aging reports also include stock-value display options:
Display option Description Perpetual Weighted Average Cost Values stock using the running weighted average unit cost across all deliveries. 3-Month Moving Average Values stock using the average unit cost across the most recent three months. Last Purchase Price Values stock at the most recent purchase price on record. Sale Price Values stock at the product's configured sale price. MSRP (or your configured retail price label) Values stock at the manufacturer's suggested retail price, or your organization's equivalent label. Manual Cost Values stock at a manually entered cost where configured. Note: The Cost of Goods report always uses perpetual weighted average costing and does not include the stock-value display option selector.
Apply your filters to load the data.
Use the grid features to sort, filter, resize, group, and paginate results where those options are enabled for the column.
To export the report, select Export and choose the flat-file format. For result sets above the report's row-count threshold, the export is delivered to your email rather than downloaded immediately.
Legacy inventory reports
These reports are available in the classic reports interface. Their permissions are the report-area check boxes under View Inventory Reports in the Inventory Manager section of the security role.
| Report | Description | Permission action |
|---|---|---|
| Inventory value report | Current stock value by product and center (single-center and organization-wide) using configurable valuation methods | Value |
| Inventory sales report | Product sales transactions with quantities, pricing, and guest details | Sales |
| Product consumption report | Products consumed during services at a single center or organization-wide | Consumption |
| Inventory orders report | Purchase order and transfer order history | Orders History |
| Inventory tax report | Tax amounts on inventory purchases and transfers | Taxes |
| Bill of materials report | Component breakdown of kit (product kit) products | Bill of Materials |
| Product returns report | Products returned to vendors or by guests | Returns |
| Online product sales report | Product sales through the consumer-facing Webstore | Online Product Sales |
Audit-related reports and editing
The reports below are on the Reports > Inventory > Audit History filter of the Reports Dashboard. They are referenced from the Inventory audit and physical count and Reconciliation and approval articles for the audit workflow context.
View the Retail Product Expense graph
The Retail Product Expense β Expected vs. Actual graph on the Inventory dashboard shows the amount spent to procure retail products by audit date for the current center.
- Navigate to the Inventory dashboard.
- View the graph for the most recent five audits performed in the last six months for retail and consumable products.
The graph shows:
- Projected Expense β The average cost Zenoti auto-calculates to purchase the product.
- Actual Expense β The average cost actually incurred to purchase the product.
- Stock Value β The value of the stock after the audit is reconciled.
Click the color codes below the graph to show or hide each metric.
Note: To view data for more than five audits, use the Cost of goods report.
Run the List of Audits report
Use the List of Audits report to view audits performed for stock over a period of time at the current center.
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- From the filter, select Audit History.
- Select the List of Audits report.
- Select the filter criteria and click Refresh to view the report.
To export the report, click the Excel or CSV icon.
Filter criteria
| Filter | Options | Description |
|---|---|---|
| Audit Date | 1 month, 2 months, 3 months, 6 months, Custom | The time period during which the audit was performed. |
| Product Type | All, Retail, Consumable | The product types to include in the report. |
| Valuation Method | Average Value | Calculates the value using an average of unit cost over the selected period. |
Column descriptions
| Column | Description |
|---|---|
| Audit Date | The date when the audit was performed. Click the date to view audit details. |
| Reconciled Date | The date when the audit was reconciled. Click the date to view reconciliation details. |
| Quantity Before Audit | The total quantity (store and floor) before the audit was performed. |
| Value Before Audit | The total value (store and floor) before the audit was performed. |
| Audited Quantity | The quantity (store and floor) entered during the audit. |
| Value of Audited | The value of the stock after it is audited, including tax paid on procurement. |
| Reconciled Quantity | The quantity (store and floor) after reconciliation. |
| Value of Reconciled | The value of the stock after reconciliation, including tax paid on procurement. |
Edit an audit
If you submitted an incomplete or incorrect audit, you can edit it based on your role permissions.
Important: You cannot delete an audit after it is submitted. If you do not have edit permissions, ask your manager to adjust quantities during reconciliation.
Important: After you edit and resubmit an audit, you cannot perform another audit for the same product type until the edited audit is reconciled. Financial lock or edit lock restrictions apply regardless of permissions.
Navigate to Reports > Inventory > Audit History.
Select the List of Audits report and generate it with the desired criteria.
Click Edit next to the audit you want to edit.
In the Audit date field, enter the desired audit date. You can edit the date only up to the last audit date.
In the Comments field, enter notes for the reconciler.
Note: The Audit date and Comments fields are only visible if you have the AUDIT_BACK_DATE permission.
Click Save.
Make any corrections to the stock count quantities.
Click Save Changes to save without submitting, or click Submit Audit to submit for reconciliation.
Edit a reconciliation
After reconciling an audit, you can edit the reconciliation if needed β for example, if you received additional stock after reconciling.
Important: After editing a reconciliation, if your organization has enabled approval for reconciliations with unaccounted stock above the threshold, the reconciliation is automatically sent for approval. Inventory managers cannot perform another audit until the reconciliation is approved.
- Navigate to Reports > Inventory > Audit History.
- Select the List of Audits report and generate it with the desired criteria.
- Click Edit next to the reconciliation you want to edit.
- Enter the desired reconciliation date in the Reconcile date field. You can edit the date only up to the last audit date.
- Enter any notes in the Comments field.
- Click Save.
- Make any corrections to the stock counts.
- Click Save Changes to save without submitting, or click Update Reconcile to apply the changes.
Run the List of Audits by Products report
Use the List of Audits by Products report to view audits for a specific product or product category.
Note: To edit audit or reconciliation details, use the List of Audits report instead.
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory > Audit History.
- Select List of Audits by Products.
- Select the filter criteria and click Refresh.
Filter criteria
| Filter | Options | Description |
|---|---|---|
| Audit Date | 1 month, 2 months, 3 months, 6 months, Custom | The time period during which the audit was performed. |
| Product Type | All, Retail, Consumable | The product types to include. |
| Valuation Method | Average Value | Calculates value using an average of unit cost over the selected period. |
| Category | List of product categories | Filter by product category. |
| Subcategory | List of product subcategories | Filter by product subcategory. |
| Product Name, Code, or Barcode | β | Search for a product by name, code, or barcode. |
Column descriptions
| Column | Description |
|---|---|
| Code | The unique identifier assigned to the product. |
| Name | The display name of the product. |
| Quantity Before Audit | The total quantity before the audit. |
| Audited Quantity | The quantity entered during the audit. |
| Reconciled Quantity | The final quantity after reconciliation. |
| Value Before Audit | The total value before the audit. |
| Value of Audited | The value of the audited quantity. |
| Value of Reconciled | The final stock value after reconciliation. |
Transaction types and states visible in inventory reports
Several reports surface transaction-level activity. The following types and states appear in the data:
- Purchase order states β A purchase order can be in Created, Raised, Updated, Partially delivered, or Delivered state, and reaches Reconciled once it is closed for further changes. Partial shipment and partial delivery appear when a vendor ships an order in multiple deliveries instead of one β the Inventory orders report shows the purchase order (PO) with its line items split across delivery rows.
- Transfer order states β Created, Raised, Updated, In transit, Partially delivered, or Delivered.
- Transaction types β Inflows include PO receipt, TO receipt, stock adjustment (add), opening stock, and conversion (in). Outflows include POS (Point of Sale) sale, service consumption, TO dispatch, stock adjustment (remove), conversion (out), return order (when stock is sent back to a vendor), discard (a guest return where the unit is not restocked), and restock (a guest return where the unit is added back to on-hand inventory).
Use the Stock ledger report to see every transaction in chronological order, including the transaction type per row.