Stock Reports
Overview
Stock reporting comes from two places. The Stock Movement Report totals each product's stock over a period: what it opened with, what came in, what was sold and what is left. And every stock screen keeps a full history — a ledger of every movement — several of which can be downloaded to a spreadsheet.
Where to look
The ledgers and stock lists are under Products & Inventory › Stock Control.
| You want to know… | Open this |
|---|---|
| Opening, received, sold and closing stock of each product over a period | Sales › POS › Stock Movement Report |
| Every change to a product's stock | Stock Control › Inventory Transactions |
| Every change to a modifier's stock | Stock Control › Modifier Inventory Transactions |
| Every change to an ingredient's stock | Stock Control › Ingredient Transactions |
| Purchase order history and totals | Stock Control › Stock Orders |
| Stock moved between outlets | Stock Control › Stock Orders — the rows that read Transfer from … (Stock Transfers) |
| Current stock of every product, per outlet | Stock Control › Product Inventory |
| Current stock of every ingredient, per outlet, and what it was bought for | Stock Control › Ingredient Inventory |
Each ledger row shows the movement type (in, out or adjustment), the stock before and after it, the reason, the staff member, and the receipt number of the sale behind it, which opens that order. On Inventory Transactions, a row written by a stock order or a transfer shows that order's number instead.
How it works
- The ledgers can be filtered — by outlet, item, type and more. Inventory Transactions and Modifier Inventory Transactions also filter by employee, and Inventory Transactions by category; Ingredient Transactions by reason and by date.
- Product Inventory downloads each outlet's stock of each product — with its code, category, variant and prices — so you can take a current-stock snapshot into a spreadsheet for stock-takes or accounting. The Ingredient list downloads your ingredient set-up (unit, unit price, suppliers, low-alert level), not stock. Ingredient Inventory has no download: its toolbar has only Create.
- Ingredient Transactions downloads its ledger — see below.
Ingredient Transactions
Stock Control › Ingredient Transactions lists every change to an ingredient's stock: Ingredient, Outlet, Receipt №, Type, Quantity (+ for In, − for Out; on an Adjustment, marked ±, it is the level the stock was set to), Stock Before, Stock After, Reason, Notes, Created By and Created At, newest first.
- Start date and End date come first in the filter bar, followed by Outlet, Ingredient, Type and Reason. The dates pick rows by when they were created, to the second; the time starts at 00:00:00 for the start date and 23:59:59 for the end date.
- Click the Ingredient heading to sort A→Z or Z→A. Each ingredient's rows stay newest first, and rows without an ingredient name come last.
- Export, beside Create, downloads the filtered rows as a CSV file named ingredient-transactions_⟨start⟩to⟨end⟩, with the list's columns in your admin language and the rows in the list's sort order. It needs both dates, at most 3 months apart — otherwise it says "Please select both start and end dates (up to 3 months) before exporting.", "The maximum date range is 3 months." or "The start date must be before the end date." A range with no rows still downloads the header row, and more than 50,000 rows is refused: "Too many transactions in this range to download at once. Choose a shorter range."
Stock Movement Report
Sales › POS › Stock Movement Report (/rewardlyPos/stockMovementReport) lists every product that tracks quantity and adds up its stock movements between two dates. Filter by Quick Range or From / To (today by default; up to 3 months), Outlets and Category.
The Summary tab has one line per stock count — a product's shared count (Stock reads Shared (all outlets)), or an outlet's own count where that outlet keeps one — sorted by product name. A line whose tracking is now off says Tracking off:
| Column | What it shows |
|---|---|
| Opening | Stock at the start of the range. |
| Received | Stock that came in on stock orders, including batches made with Make Stock. |
| Manual adj. | Changes made by hand, in the admin or on the POS. |
| Shift resets | Changes made by a quantity that resets each shift. |
| Sold | Units sold. |
| Transferred out | Units sent to another outlet on a stock transfer, less any that were returned. |
| Returned | Units put back by a void, cancellation or refund. |
| Closing | Stock at the end of the range — the live stock when the range runs up to now. |
| Unrecorded | A change that was never written to the stock ledger. |
Closing = Opening + Received + Manual adj. + Shift resets − Sold − Transferred out + Returned. Received, Shift resets, Transferred out and Unrecorded are hidden while every line reads 0. Stock that arrives on a transfer counts under Received at the outlet that receives it.
The Manual adjustments tab lists each manual change on its own line: the Date, the Product, the Stock, the stock Before and After, the Change, who made it (Adjusted By) and where (Where: Admin portal, POS or API). Both tabs have an Excel Download. A range holding too many movements is refused with "Too many stock movements since the start date to report at once. Choose a later start date."
Low-stock visibility
There is one low-stock alert in Rewardly: the Low Alert Stock At threshold on each ingredient. Set it, and at or below that level the ingredient shows a red Low Stock badge in the POS Check Stock screen; no notification is sent. Products and modifiers do not have a low-stock alert — review their current-stock views instead.
Related
- Inventory · Ingredients & Recipes · Suppliers & Purchasing.
- POS & Sales Reports — the Stock Movement Report alongside the sales reports.
- For sales reporting, see Payment Reports.