1. Kladana
  2. Inventory Management
  3. Inventory Control

Stock report

Successful inventory control hinges on knowing what products you have in your stock and how many of them you have. Regular monitoring of your stock is the key to efficient inventory management.

To monitor the level of your stock use the Stock report. The Stock report can be performed in three variants:

Go to the Inventory → Stock and click By Products, By Warehouses or By Bins to select the preferable report variant. stock report.png

Use the filters to find the stock balance you exactly needs. You can sort the data:

  • by Product and Product variants,
  • by Warehouse,
  • by Stock,
  • by Storage Bin,
  • by Date and time,
  • by Supplier.

Products Stock Report

The report shows you the stock of all the products at all the warehouses in the selected period of time. You can find out all detailed information about the total quantity of products in stock and total inventory value.

  1. In the Kladana workspace, select Inventory → Stock.
  2. Click By Products.
  3. Every product or product variant is displayed in a separate row. If you want to check all transactions related to the item, click on the row. stock_report_in_detail.png

For each item, the app displays the following stock details:

  • On hand. The total quantity of items that you currently have in your warehouses.

  • Committed. The total quantity of items reserved by customer orders.

  • Awaiting. The total quantity of items that you’ve ordered but haven’t received yet.

  • Available. The total quantity of items including awaiting and committed stock.

  • Minimum Stock. The level of an item below which the stock on hand should not fall.

  • Sale Price. The price you decided to sell the item for. By default, the app displays the main sale price. You can also choose another sale price to be displayed.

  • Total Cost. The total amount you’ve paid for all product units you currently have in stock.

  • Average Cost. The cost of one unit of product. It is calculated as the total cost of an item divided by the number of units of that item you have on hand.

  • Sales Amount. The sum of money earned from sales.

  • Inventory Days. The average number of days the company holds products before selling them. You can learn more about how inventory days are calculated.

Inventory days calculating

There are a few ways to calculate inventory days. Most apps use the common formula including the cost of average inventory. In Kladan, days of inventory are calculated differently according to the formula: Inventory_Days-_formula.png

Example

You’ve received 2 orders of 100 books each. The first order arrived on 08/10. The second order arrived on 08/22.

You’ve sold 50 books from the first order and only 25 after receiving the second one. Then, on 08/25 you check the stock balance.

Using the formula we have: ((25 — 10) × 50 + (25 — 22) × 75) ÷ 125 = 7,8, where:

50 — unsold inventory before receiving the second order,

75 — unsold inventory after receiving the second order,

125 — quantity on hand.

This way inventory days are calculated more accurately and dead stock is prevented.

If the Stocks report shows unexpected results, see Why actual stock cost may differ from estimated before contacting support.

Choose sale price to display in the report

You can choose the sale price which will be displayed in the Stock report.

  1. In the Kladana workspace, select Inventory → Stock.
  2. Click By Products.
  3. Click settings_icon.png and customize the report, if necessary.

Warehouses Stock Report

The report shows the quantity of product units located at each of your warehouses. stock report_by warehouses.png

By default, the app displays product quantities without separating them by variants. You can change this setting if necessary.

  1. In the Kladana workspace, select Inventory → Stock.
  2. Click By Warehouses.
  3. If you want to see the quantity of product variants in each warehouse, click settings_icon.png and select Split by variants checkbox.

Bins Stock Report

The report displays the quantity of product units located in the storage bins of your warehouses. stock report_by bins.png

By default, the app doesn’t separate them by variants. You can change this setting if necessary.

  1. In the Kladana workspace, select Inventory → Stock.
  2. Click By Warehouses.
  3. If you want to see the quantity of product variants in each warehouse, click settings_icon.png and select Split by variants checkbox.

There are more settings related to the Stock report you need to know:

  • Print stock reports in Excel, PDF, Open Office Calc.
  • Receive automatic reports by email
  • Restock to minimum level
  • Add items to cart for order or shipment
  • Set flexible sale process

See also

Cart

Reorder Point

How to reset the stock