Hotel360 Hotel360User Guide

Stock

Introduction

The Stock tab shows how much of each item you have on hand in your department. Storekeepers and managers use it to see what is running low, to book in a delivery (on the Basic plan), to correct the count after a stock take, and to write off spoiled goods.

Open POS > Stock. The tab shows only to users with the See the Stock tab permission. Raw materials are not listed here. They are managed under Suppliers (see Inventory and Raw Materials).

The Stock List

The list shows the items of the department you are working in:

Column Meaning
Name The item and its size or variant
Order Level The quantity at which you should reorder (set on the product)
Quantity What is on hand now, added up across all deliveries
Unit The unit, for example "pcs" or "kg"

A row turns red when the quantity is at or below the order level. That item is due for a restock. Combination items (several products sold together) are never shown in red, because their stock comes from their parts.

Type in Search products to find an item by name. The list shows 10 rows per page.

Receiving Stock

How you receive depends on your plan:

  • Basic plan: press Receive Stock on this tab.
  • Premium plan: there is no Receive Stock button. You receive goods against a purchase order. See Suppliers and Purchase Orders. If you try anyway you see Receiving stock directly is not available on your plan. Use Purchase Orders.

Receiving needs the Receive stock permission.

  1. Press Receive Stock.
  2. In Item Name, start typing and pick the item.
  3. Type the Quantity (at least 1) and the Total Price you paid for that quantity (at least 1).
  4. Press the + button. The item is added to the list below with its Buying Price.
  5. Repeat for other items. Remove a line with the red bin button.
  6. Press Save changes. You see Stock updated successfully.

The Buying Price is the total price divided by the quantity, rounded to 2 decimals. For example 120 sodas for Ksh 6,000 gives a buying price of Ksh 50 each.

Each delivery is kept as its own batch with its own buying price. Sales use the oldest batch first (FIFO), so your cost of goods matches what you actually paid. The delivery is also recorded as "Direct receive" and shows in the Stock Received report. See Stock Reports.

Physical Stock Take

A stock take compares what the system says with what you count on the shelf. Press Physical Stock Take. The button shows for users who have the Receive stock permission and also either Stock take and write-offs or Sell the difference (the window is only useful with one of them).

  1. In Item Name, pick an item. Type the counted Quantity and press the + button.
  2. The list shows the Name, the system Quantity, an Actual Stock box with your count (you can change it there) and a Difference (system - counted) column.
  3. The Difference column shows a number: the system quantity minus your count.
    • A green number means the system has more than you counted. Some stock is missing.
    • A red number means you counted more than the system says.
    • No colour means they agree.
  4. When all items are in, choose Balance Stock or Sell the Difference (below).

Note

Only add the items you actually counted. Items you leave out are not changed.

Balance Stock

This makes the system match your count, up or down. Use it after an honest recount. It needs the Stock take and write-offs permission.

  • If you counted more, the extra is added to the oldest batch.
  • If you counted less, the shortfall is removed from the oldest batches first.

You see Stock balanced successfully. The change is written to the audit trail with the old and new figures for each item, for example "Cola 500ml: 40 → 37 (-3)".

Sell the Difference

This treats a shortfall as sold stock. The missing units are booked as a sale instead of a loss. It needs the Sell the difference permission.

For every item where the system has more than you counted, the system:

  1. Takes the shortfall out of stock, oldest batch first.
  2. Creates one bill in your department for the shortfall at each item's selling price.
  3. Marks that bill as paid with the payment method "stock_adjustment".

For example the system says 40 colas and you count 37. Three are billed at the selling price, say Ksh 80 each, for a bill of Ksh 240. Items where you counted more than the system are ignored.

If there is nothing short you see No differences found to sell. On success you see Stock adjustment recorded successfully.

Warning

Sell the Difference creates a real paid bill and counts as sales in your reports. Use it only when you agree the shortfall was sold and the money is in the till. For stock that was spoiled or broken, use Record Spoilage instead.

Recording Spoilage

Use this to write off stock that has gone bad, such as milk that expired. It lowers your stock and is recorded as a loss in the reports. It needs the Stock take and write-offs permission.

  1. Press Record Spoilage.
  2. Pick the Item and type the Quantity. Fractions such as 0.5 are allowed. Press the + button.
  3. The list shows Item, Spoiled Qty and In Stock. If you add the same item twice, the quantities are added up.
  4. Type the Reason, at least 3 characters, for example "Expired".
  5. Press Write Off Spoilage. The button is off until at least one item is listed.

You see Recorded spoilage for 2 item(s). The stock is taken from the oldest batch first, and the cost of what was lost is recorded.

You cannot write off more than you have. The window says Only 3 in stock for Fresh Milk 500ml. If one item fails when you save, its own message is shown and the others still go through.

Permissions at a Glance

What you want to do Permission needed
See the Stock tab See the Stock tab
Receive Stock (Basic plan) Receive stock
Open Physical Stock Take Receive stock, plus Stock take and write-offs or Sell the difference
Balance Stock, Record Spoilage Stock take and write-offs
Sell the Difference Sell the difference

Buttons you are not allowed to use are hidden. Your administrator sets permissions in Administration. See Users, Roles and Settings.