Hotel360 Hotel360User Guide

Stock Reports

Introduction

Stock Reports shows what came in, what went out and what should be left on the shelf, for the department you are working in. Storekeepers and managers use it to check counts, catch missing stock and plan the next purchase. The End of Day tab, where a day's stock is closed, is also on this page. All tabs only read data, except End of Day, which saves a closure.

Opening Stock Reports

  1. Open Reports > Stock Reports.
  2. Pick a tab. The page opens on Stock Flow. The tabs are Stock Flow, Production Store, Stock Received, Stock Sheet, Spoilage, Restock Order, Purchase Orders and End of Day.

Who can see it:

  • A user with the See all reports permission, or
  • a user with only the See inventory reports only permission. This is the narrower choice for a storekeeper, who then sees Reports with just Stock Reports in it.
  • The page also checks the stock_reports plan feature. It is not on the Premium-only list, so it is open on every plan at the moment.

Note

Most tabs work on one department at a time: the one selected for you at sign-in (or the one you switched to). If a tab looks empty, check you are in the right department first. Restock Order and Purchase Orders are the exceptions.

Stock Flow

Daily Stock Flow. One row for each day in the range, so you can see stock coming in and going out. Set From Date and To Date (the range starts six days ago). The blue note says it shows daily movement, "Stock In (purchases, production, and moves to POS) vs Sold".

Column Meaning
Date, Day The calendar day and its weekday.
Stock In Units added to the sell-stock of this department's products that day, with the number of variants (product sizes or types).
Stock Sold Units on the bills of the day, with the number of variants. Only bills that are cleared or partial count. Pending, held and cancelled bills do not.
Spoiled Units written off as spoiled, with their cost.
Net Change Stock In − Stock Sold − Spoiled. Green when zero or more, red when less.

Period Totals shows Total Stock In, Total Sold, Total Spoiled and Net Change.

Note

This tab always uses calendar days (00:00 to 23:59), even if you have set a business-day rollover. Stock In here also counts production output and moves to POS. The Stock Received tab does not, so the two will not match.

Production Store

For kitchens that keep raw materials in a production store. It shows each material's movement in the range next to what is on hand now. If the department has no production store you see "This department has no production store configured." See Inventory and Raw Materials and Recording Production.

Set From Date and To Date (starts six days ago). Columns:

Column Meaning
Material The raw material. A grey badge such as "2 adj" means that many stock adjustments in the period.
Received Goods received plus transfers in.
Produced Output from production.
Consumed Used in production, including the Auto end-of-day deductions.
Transferred Out Moved to another store.
On Hand What is in the production store now, not at the end of the range. Red when negative.

Rows are sorted by Consumed, highest first. Period Totals shows Received, Consumed and On Hand. Quantities show three decimals.

Stock Received

Stock Received Details. Goods received into your stores for the range, stock items and raw materials. It reads the goods-received records only, so production output and internal moves to POS are left out.

Filters: From Date, To Date, Search (product, variant or reference) and Group By:

  • By Variant (the default): one row per product or variant, with Total Quantity, Avg. Buying Price, Total Value, Entries, Stores and Latest Date.
  • By Store: one row per store with the same figures and a Variants count.
  • Detailed (No Grouping): every receipt on its own line: Date & Time, Store, Product / Variant, Quantity, Buying Price, Total Value and Reference.

Avg. Buying Price is total value divided by total quantity. The bottom box shows Total Quantity, Total Value (Ksh), entries, variants and stores for the whole range, whatever grouping you picked. See Suppliers and Purchase Orders and Stock for how goods are received.

Stock Sheet

The stock sheet compares two End of Day closures to show where stock went. It is the report to use for stock-taking and for finding losses.

  1. Open the Stock Sheet tab.
  2. Choose Opening Snapshot and Closing Snapshot. Each entry is a closed day with the time it was closed, for example "Mar 04, 2026 (18:30)". The two latest are chosen for you.
  3. Optionally type in Search (product name or size).
  4. A blue note confirms "Stock movement from … to …".

If you pick an opening closure that is later than the closing one, the other box moves to match. If no closure exists yet, a red box says "No snapshots available. Please run End of Day closure first." Close a day first (see End of Day).

Note

The sheet measures what happened between the two closing times, not between two dates. If you pick the same closure twice there is no activity, and OPEN and CLOSE are equal.

Reading the Columns

Products are grouped by category, with one table per category.

Column Meaning
BP Buying price: the cost recorded at the opening closure (from the closing one if the product is new).
SP Selling price today.
OPEN Quantity at the opening closure.
ADD Stock added between the two closures.
TOTAL OPEN + ADD.
CLOSE Quantity at the closing closure.
SALE Units sold between the closures (cleared and partial bills).
SPOIL Units written off as spoiled.
VAR Variance: CLOSE − (OPEN + ADD − SALE − SPOIL).
SALES VALUE Units sold × selling price at the time of sale.
C.O.S Cost of sales: units sold × buying price at the time of sale.
GP Gross profit: SALES VALUE − C.O.S.

VAR is the number to watch. Zero means the books match the shelf. A red negative number means stock is missing: you should have had more. A green positive number means you have more than expected, perhaps stock was added but never recorded.

At the bottom, GRAND TOTALS shows Total Sales Value, Total C.O.S and Total GP in KES, and, when they are not zero, Total Spoiled and Total Variance.

Exporting the Stock Sheet

Two buttons sit at the top right: Export to Excel (downloads a file named like stock-sheet-report-2026-03-04-to-2026-03-05.xlsx) and Print (opens a PDF preview). Both are greyed out until two valid closures are chosen.

Spoilage

Spoilage / Wastage. Stock written off as spoiled, expired or damaged. These quantities have already been removed from active stock. Filters: From Date and To Date. This tab uses your business day, like the financial reports.

Columns: Date, Item, Quantity, Unit Cost, Total Cost (red), Reason and Recorded By. Period Totals shows Entries, Total Quantity and Total Cost Lost. The tab only lists write-offs. It cannot record them. Spoilage cost is also taken off profit in Profit & Loss (see Financial Reports).

Restock Order

Daily Restock Order. A suggested shopping list worked out from your own sales of the last 28 days. Use it as a guide, not a rule.

Fields:

  • Stock for day: the day you are buying for. It starts on tomorrow.
  • Till / Department: all departments by default.
  • Days to cover: how many days of sales one order must last (at least 1).
  • Subtract current stock: off by default.

A blue note says what it used, for example "Order sized for Saturday, Mar 07 using a weekday factor of ×1.20 (higher on weekends), from 24 trading day(s) of history (310 bills …)".

How it works for each item:

  1. Avg/day: units sold per trading day in the last 28 days (cleared and partial bills).
  2. Forecast: Avg/day × the weekday factor × Days to cover. The weekday factor compares that weekday with an average day. It is kept between 0.5 and 2.5 and leans toward 1 until the weekday has been seen about three times.
  3. Safety: an extra cushion for days that swing up and down, sized for about a 95 per cent chance of not running out.
  4. Par: Forecast plus Safety, rounded up. This is the level you want to have.
  5. Order: with Subtract current stock off, the whole Par. With it on, an On hand column appears and Order becomes Par less what is on hand (never below zero).

The cards show Items, Units to order, Est. cost (KES, from the last buying price seen on a bill) and Target day.

Note

Leave Subtract current stock off until you trust your stock counts. A wrong count gives a wrong order. With no sales in the window you see "No sales history in the selected window."

Purchase Orders

An overview of the purchase orders you have raised, with what has and has not arrived. It is not limited to your department. Filters: From Date (starts on the first of the month), From Time, To Date, To Time and Status (Pending, Partial, Received). Dates here are plain calendar dates, matched on the day the order was created.

Each order is a box with its number, a status badge, the supplier, Order Date, Received date and Total. Underneath, a table shows Item, Unit, Ordered, Received, Pending (red while above zero), Unit Price and Total. Use Export PDF for a printable copy. With nothing to show you see "No orders found for the selected period". To raise or receive orders, see Suppliers and Purchase Orders.

End of Day

This tab closes a day's stock. "Closing" saves a snapshot of the quantity and average cost of every product in your department. That snapshot is what the Stock Sheet compares. It also tells the Sales & Collections report that a department's day is closed.

Closing a Day

The tab shows End of Day Stock Closure. A green badge says Last closed: …. A yellow one says "No snapshots yet - First closure required".

  1. Count and record everything for the day first: sales, goods received, spoilage and adjustments.
  2. Open Reports > Stock Reports > End of Day.
  3. In Select Date to Close, pick the date. It lists each day after the last closed one up to today, marked (Today) or (Backdate). Before the very first closure only today is offered.
  4. In Day rolls over at, check the time. "When one business day ends and the next begins. 00:00 = plain calendar days."
  5. Optionally add Notes (Optional).
  6. Click Close Today (or Close Selected Date).
  7. In Confirm Stock Closure, click Confirm Closure.

You see "Successfully closed stock for 2026-03-04". When every date is closed the page says "All dates are closed. No pending closures." Recent Closures lists the last five: Date, Closed By, Closed At and Notes.

Days must be closed in order, one after another. You cannot close an earlier day again or skip a day. The messages are "Cannot close 2026-03-04. Already closed up to 2026-03-05." and "Cannot skip dates. Must close 2026-03-05 first."

When the rollover is not 00:00, a blue note explains it: "Reports will treat 04:00 as each day's edge: a day runs from 04:00 to 04:00 the next morning. Late-night and overnight trade (before 04:00) closes with the day before. Bills still count on the day they were rung up." See How Dates and Business Days Work.

Warning

The confirmation says "This action cannot be undone. Ensure all sales and stock adjustments for this date are complete." A closure cannot be edited or removed from this screen.

Warning

Day rolls over at starts at the rollover now in force for this department (a saved one, else the Automatic End of Day time, else 00:00). Leave it alone and closing changes nothing. If you type a different time, closing saves it for this department and it replaces any time set under Automatic End of Day. The field must hold a valid time (hours and minutes), or the closure is refused.

If your department runs Auto production, closing a day first deducts that day's sales from the production store.

Re-running the Production Deduction

Departments on Auto production also get a card, Production Deduction (Auto). Use it after you cancel, edit or add bills for a day that was already closed.

  1. Pick Date to re-run.
  2. Click Re-run production deduction.

A message such as "Deducted 14 materials for 2026-03-04." appears. If some materials ran short it adds "2 shortfall(s) — check the production store." Running it twice is safe: it reverses the earlier run and posts again from current sales. See Recording Production.