• Keep one row per item variant, with a fixed opening count
• Record later replenishment and non-sale removals separately
• Calculate expected closing stock: opening + replenishment - net units sold - other removals
• Enter the physical count and investigate any difference before repacking
• Compare actual net sales with the standard-price calculation, keeping discount and refund evidence