Module 4 · Core · 9 min read

Stock counts, batches and serial numbers

You will be able to: Run a stock count with Reconciliation and read the value effect; Explain what happens to differences when you post; Choose between batch, expiry and serial tracking for an item; Find expiring batches and individual serial units.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

Books and shelves drift apart: breakage, miscounts, unrecorded sales. A stocktake brings them back together. In Zeyto this is Inventory, Reconciliation: you count, enter what you found, and Zeyto posts only the differences as a stock adjustment.

A New Count form for stock reconciliation with the warehouse picker and a grid for counted quantity, difference and value effect.

Inventory, Reconciliation: enter what you counted and see the difference.

Inventory, Reconciliation: enter what you counted and see the difference.

How a count works

  1. Finish and post every sale, receipt and transfer first. Anything unrecorded will show up as a difference.
  2. Open Inventory, Reconciliation and press + New Count. Pick the Warehouse or leave it empty for all.
  3. Type the Counted Qty for each item you counted. An empty box means not counted and the item is left alone. Type 0 for an item that is gone.
  4. Read Diff (counted minus System Qty), Value Effect (difference times the average cost) and the tiles Differences, Excess and Shortage.
  5. Choose a Reason for each row that differs; it starts as Count shortage or Count surplus.
  6. Press Post Differences. There is no draft: posting is immediate.

Zeyto compares each counted quantity with the live stock at the moment you post, so if something was sold while you were counting, the posted difference is smaller than the one on screen. A surplus comes in at the item's average cost (debit Inventory, credit the offset account). A shortage goes out at cost (debit the offset account, credit Inventory). The adjustment gets an ADJ number and also shows in Stock Adjustments.

The Serials and IMEI screen with a search box for an IMEI or serial number.

Inventory, Serials / IMEI: find a unit and its history.

Inventory, Serials / IMEI: find a unit and its history.
Counting item AThe system holds 120 pieces at an average of AED 11.75. You count 117. Diff is -3 and Value Effect is 3 x 11.75 = 35.25, a shortage. Entry: debit 5100 Inventory Adjustment and Write-off 35.25, credit Inventory 35.25. On another shelf you count 122 against 120: Diff +2, value 2 x 11.75 = 23.50, entry debit Inventory 23.50, credit 5100 for 23.50.
Watch outOnly the rows you can see are posted. Counts typed on rows hidden by the Warehouse or Search filter are left out until you clear the filter. Only items that currently have stock get a row; for found stock of an item with nothing on hand, use an adjustment with Increase. A posted count cannot be amended; use Cancel Document.

Batches, expiry and serial numbers

Three tracking boxes on the item, in Stock Settings and Balances, control how much detail Zeyto keeps.

The Batch Expiry report with the Expiring within filter and the Run button.

Reports, Batch Expiry: what expires soon.

Reports, Batch Expiry: what expires soon.
  • Track Batch: transfers, adjustments and counts then need a Batch No on every line of the item.
  • Track Expiry: those screens also need an Expiry Date on every line.
  • Track Serial / IMEI: for units followed one by one, such as phones. A goods receipt or purchase invoice needs one serial number per unit, and the count of numbers must equal Qty. Each unit appears in Inventory, Serials / IMEI as In Stock, and a sale that names the serial marks it Sold.

The Batch Expiry report lists batches on hand that have expired or will expire within the days you choose, with a minus number of days for expired ones. The Serial / IMEI Register lets you scan a number to find the unit's status, warehouse and history.

TipSet Reorder Level and Reorder Qty on the item so that the Reorder report can tell you what to buy, and set Minimum and Maximum Stock so that the Stock Status report flags BELOW MIN and OVER MAX.

Try it in the demo

  1. Open demo.zeyto.app/demo-app/ and sign in with the public demo user (admin, password demoAdmin123).
  2. Open Inventory, Reconciliation and press + New Count (do not post in a shared demo).
  3. Pick a warehouse, type a counted quantity in one row and watch Diff, Value Effect and the Differences tile.
  4. Open Inventory, Serials / IMEI and try the IMEI / Serial search box.
  5. Open the Batch Expiry report and change Expiring within.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • Count, enter, and post only the differences; empty means not counted.
  • Differences are valued at the average cost and post against the stock adjustment account.
  • Batch, expiry and serial tracking make those details mandatory on stock documents.
  • Serial units move through In Stock, Sold and other statuses.

Check yourself

4 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. In Stock Reconciliation, an empty Counted Qty box means the item is treated as not counted.

2. Which tracking options exist on an item in Zeyto?

Select all that apply.

3. The system shows 120 pieces at an average of AED 11.75 and you count 117. What is the Value Effect?

4. In Stock Reconciliation, if a sale is posted while you are counting, the posted difference is the one that was on screen.

Practice questions for this module · Printable study sheet