Stock Reports
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 or date range.
| Menu item | Answers the question |
|---|---|
| Item Transaction Summary | "Where did my products go?" |
| Daily Stock Summary – Horizontal | "On this day, 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 changes were made, and why?" |
Item Transaction Summary
How to open it: Inventory › Item Transaction Summary
Every product movement for one store in the dates you choose. Choose the Store, Date From and Date To (they open on the 1st of this month and today), then click Show transactions. The list stays empty until you do.
Each row is a movement of one product on one day, and its Transaction Type says what kind it was:
| Transaction Type | Meaning |
|---|---|
| Sales | Products sold to customers. Returned bills are left out |
| Issue | Products issued to staff |
| Transfer In | Stock received from your other stores |
| Transfer Out | Stock sent to your other stores |
| Direct Purchase | Stock you bought from a vendor |
| Inventory Update | Stock corrections, for example from Current Inventory. Stock removed shows as a negative number |
| Consumption | Product used up by services, from Bill of Materials |
| Column | Meaning |
|---|---|
| Transaction Date | When it happened |
| Item Name / Barcode | The product |
| Quantity | How many moved |
| Transaction Type | What kind of movement it was (see above) |
| Sales Cost (MRP) / Purchase Price | Price per piece |
| Total Sales Cost / Total Purchase Cost | Quantity × price |
The last row adds up everything showing, stock in and stock out together. Filter Transaction Type to one kind before you read the total. This report shows movements, not balances: see Current Inventory for what you have now.
Daily Stock Summary – Horizontal
How to open it: Inventory › Daily Stock Summary › Horizontal Daily Stock Summary
One row per product for a single day, reading from left to right like a stock register. Choose the Store and the Date, then click Show stock. The date opens on yesterday; you can't pick today because the day isn't finished. Every product is listed, even ones that didn't move.
| Column | Meaning |
|---|---|
| Item Name, Category, Sub Category, UOM | The product |
| Opening Quantity | The stock saved when the store started its day on this date. It shows 0 if the store didn't start its day |
| Purchase Quantity | Added by purchases dated this day, free quantity included |
| Inventory Update Quantity | Added or removed by stock corrections made this day |
| Transfer In Quantity | Received from your other stores, counted on the day it was confirmed |
| Total Inwards | Opening quantity plus purchases, corrections and transfers in |
| Transfer Out Quantity | Sent to your other stores |
| Employee Issue Quantity | Given to staff |
| Sales Quantity | Sold on bills this day. Returned bills are left out |
| Sales Cost | The product's current selling price at this store, not the price on each bill |
| Total Outwards | Transfers out plus products issued and sold |
| Closing Quantity Balance | Total Inwards minus Total Outwards |
| Total Sales Amount | Sales Quantity × Sales Cost |
| Is Transaction | Ticked when stock came in or went out. A correction that only reduces stock doesn't tick it |
💡 Filter Is Transaction to only see products that actually moved. To trace one product across several days, use the Vertical Daily Stock Summary.
Daily Stock Summary – Vertical
How to open it: Inventory › Daily Stock Summary › Vertical Daily Stock Summary
The same information, but as a list of movements. Handy when you want to trace a single product through the month. Choose the Store, Date From and Date To (Date From can go up to yesterday), then click Show movements. Only products that moved are listed.
Each kind of movement gets its own row, so one product can have several rows on the same day. Purchases at different prices also get a row each.
| Column | Meaning |
|---|---|
| Date | The day the movement happened |
| Item Name, UOM | The product |
| Transaction Type | Purchase, Inventory Update (a stock correction), Transfer In, Transfer Out, Sales or Employee Issue |
| Inwards Quantity | How many came in. A correction that reduced stock shows here as a minus |
| Inwards Rate | For purchases, the purchase price. For corrections and transfers in, the product's current selling price at this store |
| Total Inwards Amount | Inwards Quantity × Inwards Rate |
| Outwards Quantity | How many went out |
| Outwards Rate | The product's current selling price at this store |
| Total Outwards Amount | Outwards Quantity × Outwards Rate |
Item Min Qty Summary
How to open it: Inventory › Item Min Qty Summary
Your reorder list. It lists every product with a minimum quantity at the store (you set it per store in Item Master) and compares it with what you have now. Choose a store and the list loads straight away. There are no dates: it always shows your stock right now.
| Column | Meaning |
|---|---|
| Product Name | The product |
| Current Quantity | What you have now, after sales and products issued to staff |
| Minimum Quantity | The least you want to keep at this store |
| Required Quantity | Current Quantity minus Minimum Quantity. A minus means you're short: with 6 in stock and a minimum of 10 it shows -4, so order 4. Zero or more means you have enough |
The list is sorted with the biggest shortage first, so start at the top.
💡 Set a Minimum Quantity for every product you don't want to run out of. Otherwise it can't appear here.
Stock Audit Summary
How to open it: Inventory › Stock Audit Summary
A record of stock changes for the store: corrections made in Current Inventory after a physical count (one by one or with the bulk update), stock added by purchases and bulk purchase imports, and stock taken back out by purchase returns. You can't change anything here.
Choose a store and its entries from the last 90 days load straight away. To look further back, change Date From and Date To and click Show corrections.
| Column | Meaning |
|---|---|
| Date | When the change was made |
| Item Name | The product |
| Old Quantity | The stock just before the change |
| New Quantity | The amount that was added, or removed if it has a minus. It's the change, not the new stock level: with an Old Quantity of 10 and a New Quantity of -2, the stock became 8 |
| Remarks | The reason given. Purchases show their invoice or purchase order number |