ZenotiHelp

Current stock report

ZTZenoti Docs Team Updated October 19, 2026 9 min readReference

Audience: Inventory managers and finance teams who need visibility into on-hand stock and stock value across one or more centers.

The Current Stock report shows real-time inventory quantities and values across your centers. Use it to see how much stock you have on hand, identify products running below alert levels, and compare stock value across centers, categories, vendors, and brands.

This report is part of the modern reporting framework with full sorting, filtering, grouping, column resizing, and flat-file export.


On this page


Before you begin

  • You must have the appropriate report permission to access this report.

  • Select the center or organization scope before generating the report.

  • The Current Stock item in the Inventory menu (under Retail and under Consumable, or your organization's label for consumables) opens this report only when your organization has Enable partial audit of products turned on. With that setting off, the same item opens the legacy Current stock screen. This report is always available from Reports > Inventory > Current Stock to anyone with the permission below. See Set up audits.

    Important: Enable partial audit of products cannot be turned off once it has been turned on. Before turning it on, read the confirmation message, which names this report: you will see the latest version of the Current Stock report (version 2), and the value calculation method in that report changes to the perpetual average method.

  • No recent stock count is required. This report loads however long ago your centers last completed a stock count. The 3-month audit requirement applies only to the legacy Current stock screen. If that screen will not load, use this report.

  • The Perpetual Average Cost valuation used for the Stock Value column is intended to align with GAAP guidance on inventory costing, so finance teams can use this report as an input to period-end inventory valuation (confirm treatment with your accounting advisors).

Permission: Current Stock Report under the Inventory group in the Reports(V2) section of the security role β€” required to access the Current Stock report.

Admin path: Configuration > Security > Security Roles > [your role] > Reports(V2) > Inventory > Current Stock Report

Run the report

Navigation: Reports > Inventory > Current Stock.

  1. Navigate to Reports. The Reports Dashboard is the landing page.
  2. In the Inventory section, select Current Stock.
  3. Choose the center or organization scope from the scope selector at the top of the page.
  4. Apply filters as needed and select Refresh.

Filters

The following filters are available. Apply one or more, then select Refresh to update the grid.

Filter Options Description
Center List of centers Filter stock by one or more centers.
Product type All, Retail, Consumable Filter by product classification.
Category List of product categories Filter by product category.
Sub-category List of sub-categories Filter by product sub-category.
Vendor List of vendors Filter by vendor association.
Brand List of brands Filter by product brand.
Stock filter All, In Stock, Out of Stock, Below Alert Filter by stock status relative to alert levels.
Search Free text Search by product name, code, or barcode.

Column descriptions

The following columns are shown by default:

Column Description
Center Name The name of the center the stock is held at (shown when viewing organization-wide).
Product Code The unique product identifier.
Product Name The product name.
UOM The unit of measurement (Unit of Measure β€” UoM) for the product (ml, oz, pieces, and so on).
Product Type Whether the product is classified as Retail, Consumable, or both.
Brand The product brand.
Vendor The associated vendor name.
On-Hand Quantity The combined quantity currently on hand. This is the aggregate value β€” the report does not expose separate Store or Floor quantity columns.
Stock Cost The total cost of the on-hand quantity, calculated using the Perpetual Average Cost.

The following additional columns are available and can be added to the report:

Column Description
Category The product category.
Sub-Category The product sub-category.
Sale Price The product sale price at the center.
Stock Value On-Hand Quantity multiplied by Perpetual Average Cost (the running weighted average cost per unit).
Alert Level The configured reorder minimum level (the critically low threshold; your organization may have renamed this label).
Optimum Level The configured desired stock level (your organization may have renamed this label).
Default Order Qty The default order quantity for auto-purchase order generation (your organization may have renamed this label).
Barcode The primary product barcode.
Latest Procurement Price The price from the most recent purchase order delivery for this product.
Configured Purchase Price The purchase price configured in the vendor-product association.
Tax The tax amount applicable to the current stock value.
Perpetual Average Cost The running weighted average cost per unit.
Purchase Price Incl Discount The effective purchase price after vendor discounts, excluding tax.
Stock Cost (Purchase Price) The total stock value calculated using the configured purchase price (quantity Γ— purchase price).
Stock Cost (Last Procured) The total stock value calculated using the last procured cost (quantity Γ— last procured cost).
Last Audited On The date when the most recent physical audit included this product at this center.
Last Audited By The staff member who performed the last audit for this product.
Product Color The color variant, if applicable.
Product Size The size variant, if applicable.
Mapped Vendors A comma-separated list of all vendors associated with this product at this center.

Note: The Current Stock report shows aggregate On-Hand Quantity only. It does not include Store quantity or Floor quantity as separate columns, regardless of whether your organization uses the legacy store-and-floor model or the unified on-hand model. Separate Store and Floor quantity breakdowns appear only in legacy inventory screens β€” not in this report. The Stock Ledger report and the Inventory Aging report share this same behavior: all three V2 reports show aggregate on-hand quantities only.

Grouping

You can group the report by one of the following dimensions:

  • Center Name β€” Group stock by center.
  • Product Name β€” Group multiple rows for the same product (for example, when viewing organization-wide).
  • Category β€” Group by product category.
  • Sub-Category β€” Group by product sub-category.
  • Brand β€” Group by product brand.
  • Vendor β€” Group by vendor association.
  • Business Unit β€” Group by the product's business unit (when business units are configured for your organization).

Grouping displays subtotals per group and allows expanding or collapsing group rows.

Tip β€” large date ranges: When you run the Current Stock report for a date range longer than one year, the inline render may be slow or truncated. Use the Email button instead β€” Zenoti generates the report asynchronously and delivers it as a downloadable file to the requester's email.

Store and floor quantities

Zenoti tracks inventory at two locations within each center:

  • Store β€” Back storage or warehouse area. Products are received here from purchase orders and transfers.
  • Floor β€” Treatment rooms, display areas, and other customer-facing locations. Products are moved from the store to the floor for use.

The Current Stock report itself reports a single stock quantity per product β€” it carries no separate Store/Floor breakdown columns in any configuration. The store/floor split (for organizations still on the legacy model) is visible on the audit grid and legacy inventory screens, not in this report.

Tip: If you see unexpected discrepancies between store and floor quantities, run an inventory audit to align physical counts with system records.

Reconciliation rule β€” on-hand quantity totals must match

For organizations that use both the V2 Current Stock report and the legacy inventory screens, the following rule holds regardless of which screen you are on:

The On-Hand Quantity total in the V2 Current Stock report must equal the combined Store Quantity plus Floor Quantity shown in the legacy Inventory Value report for the same product, center, and date.

This is not a separate feature β€” it is the mathematical identity that defines On-Hand Quantity: On-Hand = Store + Floor. If the totals do not agree, the cause is one of the following:

  • A filter mismatch (for example, one screen includes inactive products and the other does not).
  • A timing difference (the V2 report is real-time; the legacy report answers a point-in-time date).
  • A product type scope mismatch (the legacy screens are separate for retail and consumable; the V2 report covers both β€” filter to one product type to compare).

If all three are accounted for and the totals still differ, run the Stock ledger report for the product to find the movement that explains the gap. This reconciliation rule also applies when reviewing the same product across the Stock Ledger report and the Inventory Aging report β€” all three V2 reports use the same On-Hand Quantity figure.

Note: This reconciliation rule is also relevant when reviewing data from legacy inventory screens such as the legacy Inventory Value report (which shows Store Qty and Floor Qty columns) or the legacy consumption report (which shows Opening Qty Store and Opening Qty Floor columns). Those Store/Floor columns are present only in the legacy screens, never in this report. Use the sum of Store + Floor from the legacy screen to reconcile against On-Hand Quantity here.

Comparing this report with the legacy current stock report

If your organization still has the legacy Current stock screens, the two can show different numbers, and which number differs tells you whether anything is wrong.

Quantities should agree. On-hand quantity is the same stock counted by both, so a genuine difference in quantity is a real discrepancy worth investigating β€” run the Stock ledger report for the product to find the movement that explains it.

Values may differ, and usually should. The two reports compute value differently and the legacy figures are point estimates: the legacy report derives its Value column from a Value by method you choose, while this report exposes Perpetual Average Cost and FIFO (First In First Out β€” FIFO). Organizations on the current platform also default to a different costing method from legacy organizations. A difference in value with matching quantities is expected and is not a fault. For period-end valuation, use this report rather than the legacy one β€” see Inventory costing and valuation.

Neither the legacy report nor this report shows Store Qty or Floor Qty as separate columns. The Store/Floor quantity breakdown is not part of either version of the Current Stock report. If you need to see store and floor quantities separately, use the legacy inventory screens (such as the legacy Inventory Value report or the legacy consumption report), which retain those columns.

Compare like for like before concluding anything. Three differences between the reports produce mismatches that mean nothing:

  • The legacy report is per center and has no organization-wide total. Compare one center at a time.
  • The legacy report answers a Stock As On date, while this report is real-time. Use today's date on the legacy report, or accept that any movement since then explains the gap.
  • The legacy screens are separate for retail and consumable. This report covers both, so filter it to one product type to match.

Once those three are aligned, the rule holds: a quantity difference is real, a value difference is not. For the exact identity to check when the quantities do not agree β€” whether you start from this report or from the legacy screen β€” see Reconciliation rule β€” on-hand quantity totals must match.

A center showing 0.00 across the board, rather than for a single product, is a different situation. If a single center β€” especially one that was recently opened, or recently had configuration changes made to it β€” shows zero quantity and zero stock cost for every product in this report while the legacy screens for that same center show real numbers, this is not a reporting discrepancy to reconcile product by product. It typically means that center's data has not yet been brought into the reporting pipeline behind this report (for example, right after a new center is provisioned, or during an in-progress migration). You may also see an on-screen alert indicating the center's data is not synced. Contact Zenoti Support with the center name β€” this is resolved on Zenoti's side, not by any setting available to you.

Export the report

To export the report:

  1. Click the Export button above the grid.
  2. Select the export format (CSV or flat file).
  3. The export respects any active filters, grouping, and column configuration.
Was this article helpful?
Your feedback helps us improve our documentation.