-----------------------------------------------------------------------------------------------------------------------------
Disclaimer: This article is only for the latest version of Zenoti Reports. Do not compare the data in this version with the data in the previous version.
-----------------------------------------------------------------------------------------------------------------------------

The Stock Ledger report retrieves detailed information on the movement of stocks at your centers. Use this report to compute the perpetual cost value of your stocks as well as to reconcile the movement of stocks and their respective costing amounts.

Note: You will see this report on the dashboard only if you have the Edit Lock (90 days) option enabled for your business.

This article contains the following sections:

Navigation

  1. In Zenoti, from the main menu, click the Reports tab.
    The Reports Dashboard page opens.

  2. Click Try the New Version.

3. Search for and open the report.
The Stock Ledger report opens on a new tab.

4. Depending on your requirement, select the desired filters.
Note: You can view the report only for those centers to which you have access.

5. Click Refresh.
The report is generated based on the selected filters.

Filter Criteria

Filter Name

Options

Description

Centers

  • All

  • List of centers

Enables you to view the report for all centers or for only the selected centers.

Stock Costing Method

  • Perpetual Average Cost

Filter the cost of goods data for a particular method of stock costing.

Transaction Date

  • Yesterday

  • Today

  • Last 7 days

  • Last 14 days

  • This Month

  • 2 Months

  • 3 Months

  • 6 Months

  • 1 Year

  • Custom

Enables you to select the day or date range on which the product was sold, consumed, or restocked.

Product Type

  • All

  • Retail

  • Consumable

Filter the cost of goods data for the required type of product: retail, consumable, or both.

Product Search

You can search for the required product by typing any of these details:

  • Product Name (auto-suggested)

  • Product Code

  • Bar Code

Enables you to search for all the transactions related to a specific product at the selected centers.

Category

  • All

  • List of categories

Enables you to view the report data for all product categories or for only the selected product categories.

Column Descriptions

Column Name

Description

Additional Information

Center Code

Code of the center in which the transaction was performed.

Transaction Type

Depending on the following types of transactions, the ledger is created:

  • Sale

  • Refund and Restock

  • Service Consumption

  • CheckOut for Consumption

  • Added from Audit

  • Decreased from Audit

  • Stock In from Purchase Order

  • Purchase Order Return

  • Stock-In from Transfer Order

  • Stock-Out from Transfer Order

  • Purchase Order Return

  • Stock In from Transfer Order Return

  • Stock Out from Transfer Order Return

  • Stock-In from Bundling

  • Stock-In from UnBundling

  • Stock-Outfrom Bundling

  • Stock-Out from UnBundling

  • Stock-In from Conversion

  • Stock Out from Conversion

Transaction Date

Day on which the product was sold, consumed, or restocked.

Center Name

Name of the center in which the transaction was performed.

Product Code

Code of the product that was included in the transaction.

Product Name

Name of the product that was included in the transaction.

Product Category

Category of the product that was included in the transaction.

Product Type

Type of the product that was included in the transaction: either Retail or Consumable.

Note: For Product Type as Both, the stocks are maintained separately. As a result, Product Type can either be Retail or Consumable for a specific transaction.

Initial Stock

For a given product type and for a given center, Initial Stock is the total quantity of the product that was available before the transaction took place.

Initial Cost

For a given product type and for a given center, Initial Cost is the total cost of the available product before the transaction took place.

Description

Details of the transaction.

  • Sale: Details of the invoice.

  • Refund and Restock: Details of the invoice and restocked quantity.

  • Service Consumption: Details of the service for which the product was consumed.

  • Check-Out for Consumption: Details of the product that was manually checked out for consumption.

  • Added from Audit: Details of the unaccounted product that was added after reconciliation.

  • Decreased from Audit: Details of the unaccounted product whose quantity decreased after reconciliation.

  • Purchase Order: Details of the product and quantity purchased from a vendor or a center acting as a vendor that is displayed in the Purchase Order.

  • Purchase Order Return: Details of the product and quantity returned to the vendor or a center acting as vendor that is displayed in the Purchase Order.

  • Stock-In from Transfer Order: Details of the product and quantity procured from another center by using a Transfer Order.

  • Stock-Out from Transfer Order: Details of the product and quantity transferred to another center by using a Transfer Order.

  • Stock In from Transfer Order Return: Details of the product and quantity returned from another center by using a Transfer Order Return.

  • Stock Out from Transfer Order Return: Details of the product and quantity returned to another center by using a Transfer Order Return.

  • Stock-In from Bundling: Details of the product and quantity increased due because of Bundling.

  • Stock-In from UnBundling: Details of the product and quantity increased because of UnBundling.

  • Stock-Out from Bundling: Details of the product and quantity decreased because of Bundling.

  • Stock-Out from UnBundling: Details of the product and quantity decreased because of Bundling.

  • Stock-In from Conversion: Details of the product and quantity increased because of Conversion.

  • Stock Out from Conversion: Details of the product and quantity decreased because of Conversion.

Stock-In

This field displays all transaction stock quantities if the type of the specific transaction leads to an increase in the stock.

Stock-Out

This field displays all transaction stock quantities if the type of the specific transaction leads to a decrease in the stock.

Transaction Cost

Cost of the transaction depending on the perpetual average cost method.

Balance Quantity

Remaining quantity of the stock that is available after the transaction has been completed.

Balance Stock Cost

Cost of the remaining stock quantity that is available after the transaction, depending on the costing method.

Did this answer your question?