How to check stock value in POS and read the stock reports
How to check stock value in POS: see what your shelves are worth, what moved and why, and which products are low, out or negative.
Short answer To check stock value in POS, open Reports, choose Stock, then choose Stock value. It shows each category's cost, selling price, profit if all of it sold, margin and share. Stock reports are in Basic and Professional. Lite does not include them.
Your shelves hold money, and the stock reports show how much. This guide explains how to check stock value in POS and how to find the products that are low, out or negative. The stock reports are in Basic and Professional. Lite does not include them.
What you need
- Edition: Basic or Professional for the stock reports. See the editions.
- Permission: the permission to see reports. A person without permission to see product cost does not see the cost or profit.
What is the stock value report?
The stock value report shows what your stock is worth, one row for each category. Each row gives the cost, the selling price, the profit if all of that stock sold, the margin and the share. It answers one question: where is the money on your shelves?
How do I check stock value for each category?
To check stock value, open Reports, then Stock, and choose Stock value. Read the row for each category. Cost and profit are left out for people without permission to see them, and value as at a past date is not built yet.
-
Open Reports, then Stock. Go to Reports and choose Stock.
-
Choose Stock value. The report opens with one row for each category.
-
Read each row. The row gives the cost, the selling price, the profit if all of that category sold, the margin and the share.
How do I see what moved one product’s stock?
Use the stock movement report to see how one product’s stock went up and down, newest first. A strip sits over each line. It adds up: opening, plus received, less sold, plus returned, less adjusted, which gives what is on hand.
-
Choose Stock movement. Go to Reports, then Stock, and choose Stock movement.
-
Choose the product. Pick the product in the filter. You can also open a row in any stock report, and that product is already chosen.
-
Read the strip. Check each movement against the strip over it.
How do I find low, out and negative stock?
To find low, out or negative stock, open the Stock reports. Low stock, Out of stock and Negative stock each have a tile. Negative stock is under More. A row in any stock report opens Stock movement for that product.
-
Open Stock. Go to Reports, then Stock.
-
Choose the list you need. Choose Low stock or Out of stock. Choose Negative stock under More.
-
Choose a row. Stock movement opens for that product, with its movements and the strip over them.
Why is a product below zero?
To find out why a product is below zero, open the below-zero list. It shows each product that has gone below zero, when it went below, and the document that took it there. Each line offers Adjust. It is on the Adjustments tab of the Inventory screen, in Lite, Basic and Professional.
Can I export a stock report?
Yes. You can export a report as a spreadsheet, a CSV file or a PDF, and each export is recorded. On the report’s filter bar, choose Export. Export is in Basic and Professional, and a person who is not allowed to export a report does not see the button.
If something is not as you expect
- You want stock value as at a past date. That is not built yet.
- You want value per batch. That is not built yet.
- You want to compare the Low, Out or Expiring tiles with the last period. That is not built yet.
- You want Slow-moving, Expired, Adjustments or Product history tabs. Those are not built yet.
- You want to export a report with chosen columns. There is no column chooser yet.
- A figure looks out of date. Every report says which computers’ data is current. Check that note first.
Next
For how a shop keeps its shelves in order, see inventory software for a small shop. For the reports in one place, see reports and alerts. To count the shelves yourself and apply the difference, see how to count your stock.
Pricing shows what each edition costs. Download SellyPOS to try it.