Help CenterAnalytics / Inventory analysis / In-out-stock report

How are opening, inbound, outbound and closing calculated?

Page Analytics / Inventory analysis / In-out-stock reportUpdated 2026-10-25
Short answer

Opening + inbound − outbound = closing. Closing is worked back from the current book stock by removing movements after the end date; inbound and outbound are the units of each movement type in the period, not counting order locks, releases or cost adjustments. Days follow each warehouse's local time.

In short

Opening stock + inbound − outbound = closing stock

Closing stock = current book stock − inbound after the end date + outbound after the end date

Stock means units physically in the warehouse

Opening and closing stock are the units actually in the warehouse, including units already locked by orders. For your own warehouses the book is the total stock; for third-party warehouses it is the latest synced quantity plus movements not yet reconciled.

What counts as inbound and outbound?

  • Inbound: purchase, transfer, return, manual and adjustment inbound, plus units a third-party warehouse sync found above the book (stock sync correction).
  • Outbound: sale, transfer, manual and adjustment outbound, plus units a third-party warehouse sync found below the book.
  • Order locks, releases and cost adjustments do not move physical units and are not counted.

Each inbound and outbound type can be added to the table from the column settings.

Which day does a movement count on?

Days follow each warehouse's own local time. For example, a Thai warehouse uses Thai time, so an outbound at 11:30 pm counts on that day.

Why is there no data for a third-party warehouse before a certain day?

A third-party warehouse starts its book on its first stock sync; movements before that are not recorded. When that day falls in the selected dates, a line above the overview shows it, and opening stock is taken from that day.

Seeing which movements make up a number

Click Details at the right end of a row to see that product day by day: opening, each inbound type, each outbound type and closing. Click a quantity to open the raw movements of that type on that day (time, warehouse, type, units, reference number, note); their units add up to the number you clicked.

An example

(Made-up numbers, only to show the calculation.)

  • A product has 50 units in the book now; after the end date 10 units came in by purchase and 6 went out by sale, so closing = 50 − 10 + 6 = 46;
  • In the selected dates 30 units came in by purchase and 2 by return, and 20 went out by sale;
  • Opening = 46 − 32 + 20 = 34.