ZenotiHelp

Inventory costing and valuation

ZTZenoti Docs Team Updated September 4, 2026 6 min readGuide

Audience: Finance, controllers, and inventory managers who reconcile stock value, analyze margin, or decide which valuation lens to use when reading inventory reports.

Understanding how Zenoti calculates inventory cost is essential for accurate financial reporting, margin analysis, and procurement decisions. This article explains the costing methods Zenoti uses, the valuation options available in reports, and how these calculations affect your financial data.


On this page


Before you begin

  • You must have access to inventory reports to view cost and valuation data.
  • Your organization's costing method is configured at the system level and applies to all centers. Switching between the perpetual weighted average and the 3-month moving average is a Zenoti Support-initiated change; it is not a self-service setting.
  • To access reports that display cost data, your role must have the relevant report permissions under Inventory in the Reports(V2) section or under View Inventory Reports in the Inventory Manager section — see Inventory permissions FAQ.

How Zenoti calculates cost

Zenoti tracks the cost of each product at each center. The cost value drives stock valuation in reports, margin calculations, and the cost of goods analysis.

Perpetual weighted average cost (default)

The perpetual weighted average cost method recalculates the unit cost every time new stock is received. It combines the value of existing stock with the value of the incoming delivery, then divides by the total quantity on hand.

Formula:

New average cost = (Existing stock value + Incoming delivery value) / Total quantity on hand

"Incoming delivery value" is the PO line unit price multiplied by the delivered quantity. Discounts applied at the PO-line level are included; freight and taxes are not (they are captured on the tax invoice, not in the stock cost).

Example: A center has 10 units at $5 each ($50 total). A purchase order delivers 5 units at $8 each ($40). The new average cost is ($50 + $40) / 15 = $6 per unit.

This method is intended to align with GAAP guidance on inventory costing and is the default for organizations on the current inventory platform. It provides a smoothed cost that reflects your actual procurement spending over time. Finance and controller teams should validate alignment with their local accounting standards.

3-month moving average (legacy)

The 3-month moving average method calculates cost by averaging purchase prices over the most recent 3 calendar months of delivery transactions. This method is retained for backward compatibility with organizations that have not migrated to the current inventory platform.

Example: A product had three deliveries in the trailing 3 calendar months — 10 units at $4, 20 units at $5, and 10 units at $6. The 3-month moving average is ((10 × 4) + (20 × 5) + (10 × 6)) / (10 + 20 + 10) = $5 per unit.

If your organization still uses the 3-month moving average, the cost shown in reports may differ from the perpetual weighted average, especially when purchase prices fluctuate frequently. Migration from 3-month moving average to perpetual weighted average is not self-service. Contact Zenoti Support for assistance changing costing methods on an existing organization. Support evaluates the change on a case-by-case basis.

Stock value display options in reports

When you run inventory reports such as the current stock report, inventory aging report, or inventory value report, you can select from six options to determine how stock value is displayed:

Display option How it calculates value
Perpetual Weighted Average Cost Uses the running average cost recalculated at each stock receipt. This is the default and most commonly used option.
3-Month Moving Average Averages purchase prices over the most recent 3-month period.
Last Purchase Price Uses the price from the most recent purchase order delivery.
Sale Price Uses the center-specific sale price for each product.
MSRP (or your configured retail price label) Uses the organization-level retail price. This is a retail price field, not a costing method.
Manual Cost Uses a manually configured cost value, if one has been set for the product.

The display option you choose affects the stock value column in the report but does not change the actual cost stored in the system. It is a reporting filter that lets you view your inventory through different financial lenses.

Note: Only the first three options (Perpetual Weighted Average Cost, 3-Month Moving Average, and Last Purchase Price) represent actual costing methods. Sale Price, MSRP, and Manual Cost are alternative price-based views for analysis purposes. Manual Cost is set per product on the Product Master screen.

The Cost of Goods Report always uses the organization's default costing method (perpetual weighted average on the current platform, 3-month moving average on the legacy platform) regardless of the display-option selector.

Negative-to-positive FIFO correction

When a product's on-hand quantity goes from negative (caused by retroactive adjustments, for example) back to positive, Zenoti applies a FIFO-based correction: the average cost is reset to the price of the lot that brought the balance positive. The Cost of Goods Report records this correction in an Offset column so auditors can see the before-and-after values.

This is the only situation where the system uses a FIFO-based mechanic. The ordinary costing flow is perpetual weighted average (or 3-month moving average on legacy).

For details, see Cost of goods report and Negative inventory FAQ.

Impact on financial reports

Use this table to decide which report pairs with which lens:

Report Lens it uses Notes
Current stock report Perpetual weighted average cost (legacy orgs: 3-month moving average) No display-option selector (perpetual weighted average cost only)
Stock ledger report Selected display option Shows transaction-level movement with per-row cost
Inventory aging report Selected display option Aging buckets valued with the chosen lens
Cost of goods report System default only (perpetual weighted average or legacy 3-month moving average) Ignores the selector; includes the Offset column for FIFO corrections
Inventory value report Legacy report — system default No display-option selector
Audit and reconciliation reports System default Used to value audited and reconciled stock

Tip: When comparing inventory reports across periods or centers, ensure you use the same stock value display option for consistency.

Which option should I use?

  • For accounting / balance-sheet reporting: Perpetual Weighted Average Cost. This is the default and aligns with standard inventory accounting.
  • For margin analysis on recent procurement: Last Purchase Price — shows the most recent cost paid.
  • For buyer planning against retail pricing: Sale Price or MSRP — shows what the stock would sell for at its current retail price.
  • For comparison against a manually set benchmark: Manual Cost — uses a value set per product on Product Master.
  • For legacy-platform organizations: 3-Month Moving Average — mirrors the system default for those organizations.

Where you see this in the UI

  • Value per unit — On stock adjustment and audit screens, the field labelled Value per unit reflects the unit cost calculated by the active costing method (perpetual weighted average by default for current-platform organizations). When you add stock via Adjust stock, you can override the value per unit using one of the cost-basis options described above; when you remove stock, the value per unit is fixed at perpetual weighted average and is not editable.
  • Stock-value display options — On the Current stock report, Stock ledger report, and Inventory aging report, the value column reflects the display option you select from the report filter. The display option does not change the underlying perpetual weighted average — it changes only how the value is shown for analysis.

Concepts

Reports

Troubleshooting

Was this article helpful?
Your feedback helps us improve our documentation.