Closing Stock: Formula, Worked Example and Count Checklist

Closing stock is the inventory remaining at a defined period-end. Calculate the quantity from opening stock and recorded movements, reconcile it to a physical count, then apply the appropriate valuation policy separately.

A factory needs more than a single total. Keep the item, unit, store, ownership and cut-off time attached to the balance. Raw material in stores, material already issued to a job and finished goods awaiting dispatch belong to different operating records. Adding them without a clear scope can count the same material twice.

Calculate one item in one unit

For a chosen store, closing quantity equals opening quantity plus receipts and returns into that store, less issues and other recorded outward movements, with approved adjustments included once. Use pieces with pieces, kilograms with kilograms, and money with money. A purchase value cannot be subtracted from a consumption quantity.

The book closing balance is 75 pieces. Suppose a count at the same cut-off finds 73. The variance is 73 − 75 = −2 pieces. Record that difference for investigation; changing the balance immediately would hide whether the cause was a count error, late issue or missing receipt.

Investigate the difference before adjusting it

1. Recount the item in the same unit, including opened packs and the relevant bins.
2. Check the last receipt, issue, return and transfer documents around the cut-off. Compare the physical movement time with the posting time.
3. Confirm that stock under inspection or marked damaged has been counted in the correct location and status.
4. Check whether material moved to production or another store. Reconcile both sides of a transfer.
5. Record the reason, evidence and approving owner before posting a correction.

A store-to-store transfer reduces one store and increases another; it does not by itself reduce the company-wide quantity of that item. An issue to production changes the operating location or inventory category. It is not automatically a sale or a physical loss.

Keep WIP, ownership and valuation visible

Identify material on open jobs, finished output not yet received into stock and company-owned material held by subcontractors. Keep customer-owned material distinguishable from your own. Finance can then determine which balances belong in the period-end inventory under the applicable policy.

Quantity reconciliation and valuation answer different questions. The IFRS Foundation's IAS 2 summary explains cost and net realisable value within that accounting framework. Your finance team should apply the standards and policies that govern your business, including the treatment of WIP and damaged stock. A stock count alone does not establish their financial value.

Keep the closing balance connected to daily work

In Optiwise inventory, maintain item codes and unit conversions, record store receipts, issues and transfers, and review stock through the same operational records used by purchasing and production. This gives the month-end review a movement trail to examine. Our stock and ageing dashboards help the team identify items that need attention before the close.

Use the inventory tracking record for the event detail and the average inventory worksheet when the question is stock held over a period rather than at its end.

Questions from manufacturing teams

Is closing stock always usable stock?

No. The closing quantity can include stock under inspection or damaged stock. Keep physical quantity, availability status and valuation distinct.

Should a physical-count difference be posted immediately?

Recount and check cut-off documents first. Record the explanation and approval, then post the justified correction with its reference.

Does a transfer reduce total company stock?

A transfer between your own stores normally moves the quantity between locations. Reconcile the source and destination rather than treating it as consumption.

For your next close, choose one item and one store and reconcile every movement to the cut-off. Bring that record to an Optiwise demo to walk through the stock workflow.