Product Stock Summary Report

Product Stock Summary Report

The Product Stock Summary Report gives you a snapshot of your current inventory. It displays the opening balance, stock received, stock used or sold, and the closing balance for each product. This report helps you monitor stock levels and manage purchasing decisions efficiently.

This report is essential for any business that sells or consumes products.

What You Can Track in the Product Stock Summary Report

  • Opening stock at the beginning of the selected date range

  • Quantity received during the period

  • Quantity used or sold

  • Quantity returned, adjusted, or transferred

  • Closing stock at the end of the period

  • Total value of inventory based on quantity and unit cost

How to Access the Product Stock Summary Report

  1. Go to the Reports section from your main menu in the Zylu dashboard

  2. Select Product Stock Summary from the report list

  3. Use the Filters button on the top right to search by category, brand, or stock status.

  4. Toggle Display Low Stock Only to highlight items below their reorder level.

How to Download the Report

Click the download icon at the bottom right of the screen. You can choose to download the file in CSV or PDF format.


Common Columns in the Report

  • Product Name: The item name as configured in your inventory

  • Opening Stock: Quantity available at the start of the report period

  • Stock In: Quantity added during the report period

  • Stock Out: Quantity used, sold, or removed during the period

  • Adjustments: Manual stock changes like expired, damaged, or transferred stock

  • Closing Stock: Final quantity available at the end of the period

  • Unit Cost: Cost per unit of the product

  • Stock Value: Total value of the closing stock (Closing Stock × Unit Cost)

Frequently Asked Questions

Q. What is the Product Stock Summary Report used for?

A. It provides a summary of inventory movement and current stock levels. It helps businesses manage product availability and restocking by showing how much of each item is left and what has been added, used, or adjusted.


Q. Where can I access the Product Stock Summary Report?

A. Go to the Reports section from your Zylu dashboard and select Product Stock Summary.


Q. Can I download the Product Stock Summary Report?

A. Yes. You can download it as a CSV or PDF from the bottom right of the report screen.


Q. What does Opening Stock mean?

A. Opening Stock is the quantity of a product available at the start of your selected date range.


Q. What is Stock In?

A. Stock In refers to the quantity of the product added to inventory during the selected period. This may come from new stock purchases or transfers.


Q. What is Stock Out?

A. Stock Out shows the total quantity used, sold, or otherwise removed from inventory during the reporting period.


Q. What are Adjustments?

A. Adjustments include manual changes made to stock, such as for expired items, damaged goods, stock transfers, or corrections.


Q. What is Closing Stock?

A. Closing Stock is the available quantity at the end of the report period. It is calculated as:
Opening Stock + Stock In - Stock Out ± Adjustments


Q. How is Stock Value calculated?

A. Stock Value = Closing Stock × Unit Cost. This helps you understand the monetary value of inventory still on hand.

    • Related Articles

    • Booking Report

      The Booking Report gives you a detailed record of every booking made in your business — including services, packages, products, memberships, employees involved, payment details, sales breakdown, and outstanding balances. It's one of the most used ...
    • Types of Reports in Zylu and What You Can Track

      Zylu offers a wide range of reports to help you monitor every part of your business—from daily revenue and bookings to inventory, employee performance, and customer behavior. Here's a categorized breakdown of all the reports and what you can use them ...
    • Popular Articles

    • Getting Started with Bookings & Sales on Zylu: A Step-by-Step Guide

      How to Get Started with Bookings & Walk-Ins in Zylu . This guide will walk you through managing bookings, walk-ins, adding new customers, selling services and products, and sending invoices through Zylu. By following these steps, you’ll streamline ...
    • How to send a WhatsApp Campaign for Holiday Discount

      Step-by-Step Guide to Engaging Customers with Festive Offers WhatsApp Campaign In this tutorial, we'll walk you through the process of creating and sending a WhatsApp campaign to promote your holiday discounts. <br> Steps: Log into your Zylu ...
    • Complete Business Verification

      Verifying Your WhatsApp Business Account To fully utilize the features of your WhatsApp Business account, it's essential to complete the business verification process. Follow these simple steps to get started: Initiate Business Verification: If you ...
    • Advanced Training on Zylu Software – Everything You Need to Know

      Welcome to the official Advanced Zylu Software Training! This session is designed to help you unlock the full potential of the Zylu platform — from store setup to automations and reporting. ? Watch the Full Training Video ? Watch Now: ...
    • WhatsApp Business API: Common Reasons for Account Ban or Restriction

      If your WhatsApp Business API account has been banned or restricted, it’s usually due to policy violations or poor user experience signals. To help you stay compliant and maintain healthy communication with your customers, here are the most common ...