Skip to main content

Stock Reports

← Back to Inventory

These reports help you understand how your stock moves: what came in, what went out, and what's running low. Each one lets you pick a store and, where it makes sense, a date range.

Menu itemAnswers the question
Item Transaction Summary"Where did my products go?"
Daily Stock Summary – Horizontal"What was my opening stock, what came in, what went out, and what's left?"
Daily Stock Summary – Vertical"Show me every stock movement, day by day"
Item Min Qty Summary"What do I need to reorder?"
Stock Audit Summary"What stock corrections were made, and why?"

Item Transaction Summary​

📺 Watch: Item Transaction Summary

How to open it: Inventory › Item Transaction Summary

Product movements for the store in your chosen dates — products sold, products issued to staff, and stock received from your other stores.

ColumnMeaning
Transaction DateWhen it happened
Item Name / BarcodeThe product
QuantityHow many
Sales Cost (MRP) / Purchase PricePrice per piece
Total Sales Cost / Total Purchase CostQuantity × price

Daily Stock Summary – Horizontal​

📺 Watch: Horizontal Daily Stock Summary

How to open it: Inventory › Daily Stock Summary › Horizontal Daily Stock Summary

One row per product, reading from left to right like a stock register:

ColumnMeaning
Opening QuantityStock at the start
Purchase QuantityAdded by purchases
Inventory Update QuantityAdded or removed by stock corrections
Transfer In QuantityReceived from your other stores
Total InwardsEverything that came in
Transfer Out QuantitySent to your other stores
Employee Issue QuantityGiven to staff
Sales Quantity / Sales CostSold to customers
Total OutwardsEverything that went out
Closing Quantity BalanceWhat's left
Total Sales AmountValue of what was sold
Is TransactionTicked if the product had any movement at all

💡 Filter Is Transaction to only see products that actually moved.


Daily Stock Summary – Vertical​

📺 Watch: Vertical Daily Stock Summary

How to open it: Inventory › Daily Stock Summary › Vertical Daily Stock Summary

The same information, but as a list of movements — one row per product per day, showing Inwards Quantity, Inwards Rate, Total Inwards Amount, Outwards Quantity, Outwards Rate and Total Outwards Amount. Handy when you want to trace a single product through the month.


Item Min Qty Summary​

📺 Watch: Item Min Qty Summary

How to open it: Inventory › Item Min Qty Summary

Your reorder list. Products whose stock has fallen to the minimum quantity you set in Item Master, with:

ColumnMeaning
Product NameThe product
Current QuantityWhat you have now
Minimum QuantityThe least you want to keep
Required QuantityHow many to order to get back up to the minimum

💡 Set a Minimum Quantity for every product you don't want to run out of — otherwise it can't appear here.


Stock Audit Summary​

📺 Watch: Stock Audit Summary

How to open it: Inventory › Stock Audit Summary

A record of stock corrections for the store — for example those made in Current Inventory after a physical count.

ColumnMeaning
DateWhen the correction was made
Item NameThe product
Old QuantityThe stock before the correction
New QuantityThe amount that was added (or removed, if negative)
RemarksThe reason given