CHECK YOUR STOCK MOVEMENT REPORT
Monitor Inventory With Ease Using The Stock Movement Report. Track Stock Levels, Value, Sales, And Trends Across Products, Branches, And Suppliers
Want to keep a sharp eye on your inventory? Here’s how to dive into your Stock Movement Report like a pro:
Where to Find It:
- Go to Reports from the left side menu
- Under the POS section, click on Stock Movement Report
What You’ll See:
You’ll get a detailed breakdown with 10 columns (customizable to your liking!):
➡️ Click on the small table icon (top right of the report) to add/remove columns for better clarity.
Let’s go through each column:
- POS Item Name – The name of the product
- Brand – The brand linked to the item
- Category – Product category (e.g., Supplements, Apparel, etc.)
- Non-Stock – Shows "Yes" if it's a non-stock item (e.g., service or digital item)
- Opening Balance – Initial stock added when the item was first created
- In – Total quantity added to stock after the opening balance
- Out – Total quantity removed/sold
- End Balance Stock – Current quantity after In & Out movements
- Stock Value – Cost of the remaining stock (what it cost you, not what you sell it for)
- Sale Value – Revenue earned from selling this item
⚙️ Report Options:
You can further customize the view by using these filters:
- Group by Branch – Break it down per location
- Group by Supplier – Analyze based on your vendors
- Show Non-Stock – Include/exclude non-stock items
- Show Detailed – Toggle more granular data
Export & Search:
✅ Export the report to Excel anytime by clicking the Export button on the top right – perfect for printing or sharing
🔍 Search Box available at the top to quickly find specific items in large inventories
🔄 Pro Tip: Use this report to track inventory trends, identify top-selling products, and spot restocking needs before they become an issue. It’s all about staying one step ahead