Negative inventory FAQ
In some situations, a product's on-hand quantity can drop below zero. This article explains what causes negative inventory in Zenoti, the organization setting that controls it, how negative stock affects costing, and best practices for managing it.
On this page
- Before you begin
- What is negative inventory
- The Allow sale at any stock level setting
- How negative stock affects costing
- Best practices
- Related articles
Before you begin
- This article applies to centers that have the Allow sale at any stock level setting enabled.
- Understanding inventory costing and valuation helps provide context for the costing impact described below.
What is negative inventory
Negative inventory occurs when the system records more outflow (sales, consumption, adjustments) than the available on-hand quantity. For example, if a center has 2 units on hand and a sale of 3 units is processed, the resulting on-hand quantity is -1.
This can happen when:
- A product is sold at the point of sale but the stock receipt (purchase order delivery) has not yet been recorded.
- A service consumes products that were not yet received.
- Stock adjustments or returns are processed out of sequence.
- Multiple transactions occur simultaneously at a center with low stock levels.
The Allow sale at any stock level setting
By default, Zenoti blocks sales and consumption when on-hand quantity is zero. The Allow sale at any stock level center-level setting overrides this behavior:
| Setting state | Behavior |
|---|---|
| Disabled (default) | The system prevents POS (Point of Sale) sales and service consumption when the product has zero or insufficient stock at the center. Staff sees a stock validation error. |
| Enabled | The system allows transactions regardless of stock level. On-hand quantity can go negative. |
Centers enable this setting when they prioritize uninterrupted guest service over strict stock enforcement — for example, when deliveries are frequent and stock-outs are temporary. Each center can independently enable or disable this setting.
How negative stock affects costing
When stock is negative, the weighted average cost calculation can produce inflated results. Here is how:
- A product has 5 units at $10 each (stock value = $50).
- Sales reduce the quantity to -3 (the stock value becomes negative or zero while the cost-per-unit calculation is disrupted).
- A purchase order delivers 10 units at $12 each ($120).
Note: The system must reconcile the -3 balance with the incoming 10 units, resulting in 7 units on hand.
In earlier versions of Zenoti, the average cost after this scenario could be significantly higher than the $12 purchase price because the system applied the standard weighted average formula across the negative-to-positive transition.
FIFO-based correction (2024): Zenoti introduced a correction that resets the weighted average cost when stock transitions from negative to positive. The rule is: when a purchase order delivery brings on-hand quantity from negative to positive, the moving average cost resets to the unit price of the incoming lot rather than blending it with the distorted negative-balance cost.
Worked example with the correction:
- A product has 5 units at $10 each (stock value = $50).
- Sales reduce the quantity to -3.
- A purchase order delivers 10 units at $12 each ($120).
- Without the correction, the standard weighted average formula would calculate: ($0 + $120) / (−3 + 10) = $120 / 7 = $17.14 — significantly higher than the actual $12 purchase price.
- With the FIFO-based correction, Zenoti resets the cost: the 3 units that bring the balance from -3 to 0 absorb the incoming $12 cost, and the remaining 7 units are valued at $12 each. The new average cost is $12.00, accurately reflecting the actual procurement price.
Best practices
- Monitor negative balances regularly. Use the Current Stock report with a stock filter of All or Out of Stock to identify products with negative quantities.
- Investigate the root cause. Negative stock usually signals a process gap — delayed PO deliveries, missed receipts, or data entry errors. Address the underlying cause rather than adjusting the stock.
- Receive purchase orders promptly. The longer stock remains negative, the greater the potential impact on cost calculations and financial reports.
- Review cost after receiving stock against negative balances. After a PO delivery brings a product from negative to positive, verify the average cost on the Current Stock report to ensure it reflects expected values.
- Consider disabling Allow sale at any stock level. If negative inventory is frequent and causing reporting issues, evaluate whether strict stock enforcement is feasible for your operation.