Stock at the end of the period from movements.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Closing stock
—
Formula
Opening stock + receipts − issues ± adjustments
=B2+C2-D2+E2Excel: B2 opening stock; C2 receipts; D2 issues; E2 adjustments (+ or −, optional)
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.