ZenotiHelp

Stock ledger report

ZTZenoti Docs Team Updated September 5, 2026 5 min readReference

Audience: Finance teams, inventory managers, and auditors who need a transaction-level audit trail of every stock-changing event.

The stock ledger report provides a transaction-level view of all stock movements in your organization. Every event that changes inventory — purchases, deliveries, transfers, checkouts, conversions, adjustments, audits, returns, and bundles — appears as a line item in the ledger, giving you a complete audit trail of how stock levels changed over time.

This report is part of the modern reporting framework and uses the advanced grid view with full sorting, filtering, column resizing, and aggregation support.

Navigation: Reports > Inventory > Stock Ledger.

Before you begin

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

Permission: Stock Ledger Report under the Inventory report permissions group — required to access the Stock Ledger report.

Run the report

  1. Navigate to Reports. The Reports Dashboard is the landing page.
  2. In the Inventory section, select Stock Ledger.
  3. The report opens in the V2 grid interface.

Filters

Configure the following filters to narrow the report data:

Filter Description
Centers Select one or more centers to include.
Date range The time period for transactions.
Categories Filter by product category.
Brands Filter by product brand.
Product types Retail, consumable, or all.
Vendors Filter by vendor.
Subcategories Filter by product subcategory.
Business units Filter by business unit.
Transaction types Filter by specific transaction types (PO delivery, transfer, checkout, adjustment, audit, conversion, bundle, return, etc.).
Products Search for specific products.
Costing method Select Perpetual Average Cost or FIFO (the two values of the StockCostingMethods enum). The cost columns recalculate based on the selected method.
Search Free-text search across product name and code.
Group column Group results by a selected dimension (center, category, vendor, etc.).

Report columns

The stock ledger report contains 34 columns covering transaction details, quantities, and values. The default columns, in order, are:

Column Description
Transaction Date The date when the stock movement occurred.
Center Code The short code identifying the center.
Center Name The name of the center where the transaction occurred.
Product Code The product's unique code.
Product Name The product involved in the transaction.
Product Category The product's category.
Product Type Whether the product is "Retail" or "Consumable".
Brand The product brand name.
Initial Stock The stock quantity before this transaction was applied.
Initial Cost The total stock cost before this transaction.
Transaction Type The type of transaction (PO Delivery, Transfer In, Transfer Out, Checkout, Adjustment, Audit, Conversion, Bundle, Unbundle, Return, Opening Stock).
Description A short description of the transaction.
Stock-In The quantity of stock added by this transaction (for PO deliveries, transfer in, adjustments adding stock, etc.).
Stock-Out The quantity of stock removed by this transaction (for checkouts, transfer out, adjustments removing stock, etc.).
Transaction Cost The monetary value of this transaction, based on the selected costing method.
Balance Quantity The running stock quantity after this transaction.
Balance Stock Cost The running stock cost after this transaction.

Additional columns

Beyond the default columns above, the report also includes these columns (visible via column show/hide):

Column Description
Unit Cost The cost per unit at the time of the transaction.
Total Value The total value of the transaction (quantity multiplied by unit cost).
Vendor The vendor associated with the transaction (for PO-related entries).
Batch Number The batch or lot number (for batch-tracked products).
Reference Number The PO, TO, or adjustment reference number.
User The user who performed the transaction.
Sub-Category The product's sub-category.
Business Unit The business unit the product belongs to.
Transfer Center For transfer orders, the source or destination center name.
Service Name For consumption transactions, the service during which the product was used.
Bundle Code For bundle/unbundle transactions, the bundle product code.
Conversion Code For conversion transactions, the conversion reference code.
Checkout Code For checkout transactions, the checkout reference code.
Invoice No The invoice number for the transaction.
Purchase Price The configured purchase price for the product.
Perpetual Average Cost The running weighted average cost per unit at the time of the transaction.
Action Quantity The absolute quantity changed (always positive).
Product Vendor The vendor mapped to the product.

Transaction types reference

The stock ledger tracks 23 distinct transaction types:

# Transaction Type Direction Description
1 Sale Outflow Product sold to a guest at the point of sale.
2 Refund and Restock Inflow Product returned by a guest and added back to stock.
3 Service Consumption Outflow Product consumed automatically during a service appointment.
4 Checkout for Consumption Outflow Product manually checked out for internal use.
5 Added from Audit Inflow Stock quantity increased as a result of audit reconciliation.
6 Decreased from Audit Outflow Stock quantity decreased as a result of audit reconciliation.
7 Stock In from Purchase Order Inflow Stock received from a vendor via PO delivery.
8 Stock Out from Purchase Order Outflow Stock deducted due to a PO correction or reversal.
9 Stock In from PO Return Inflow Stock returned to inventory from a cancelled vendor return.
10 Stock Out from PO Return Outflow Stock sent back to vendor via a return PO.
11 Stock In from Transfer Order Inflow Stock received at a center from a transfer order delivery.
12 Stock Out from Transfer Order Outflow Stock dispatched from a center via a transfer order.
13 Stock In from TO Return Inflow Stock returned from a transfer order return (inbound).
14 Stock Out from TO Return Outflow Stock sent back via a transfer order return (outbound).
15 Stock In from Bundling Inflow Bundle (kit) product added to stock after assembly.
16 Stock In from Unbundling Inflow Component products added to stock after disassembly.
17 Stock Out from Bundling Outflow Component products deducted from stock during assembly.
18 Stock Out from Unbundling Outflow Bundle product deducted from stock during disassembly.
19 Stock In from Conversion Inflow Stock added to the target type (retail or consumable) during conversion.
20 Stock Out from Conversion Outflow Stock deducted from the source type during conversion.
21 Added from Adjustment Inflow Stock quantity increased via a manual adjustment.
22 Decreased from Adjustment Outflow Stock quantity decreased via a manual adjustment.
23 Stock In from Cross-Center Retail Refund Inflow Stock restocked at a different center than where the original sale occurred.

Grouping

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

  • Center — group transactions by center.
  • Category — group by product category.
  • Sub-Category — group by product sub-category.
  • Brand — group by product brand.
  • Vendor — group by vendor association.

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

Report features

This report supports the standard V2 grid features (sort, filter, resize, reorder columns; pagination; column show/hide; flat-file CSV export). Numeric columns aggregate to sum totals in the footer. For framework-wide grid behaviors, see Inventory reports — Access V2 reports.

Worked example

A center receives a PO delivery, then makes a sale, then performs an audit. The ledger shows:

Date Transaction Type Inflow Outflow Balance
Day 1 Opening Stock 100 0 100
Day 2 Stock In from Purchase Order 50 0 150
Day 3 Sale 0 3 147
Day 4 Decreased from Audit 0 2 145

The running Balance Qty represents the on-hand quantity after each transaction, computed per product per center, sorted by Transaction Date. Back-dated transactions (allowed for audits with the AUDIT_BACK_DATE permission) cause the running balance to recompute for affected dates.

Video: Stock Ledger Report (1:26) — Overview of the Stock Ledger report.

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