The material is neither on the shelf nor finished. It still needs an account.
For Plant heads, production planners and manufacturing managers · Understand the problem
TL;DR — what you’ll learn
- Keep material issued to production distinct from material actually consumed or completed.
- Identify unfinished stock by batch, stage, location and measurement basis.
- Reconcile the physical state with production and inventory events at the same cutoff.
- Keep quantity evidence separate from finance's approved valuation treatment.
The warehouse issued ingredients before midnight. Finished packs will be posted after the morning shift begins. The overnight report shows a large consumption gap because it has no place for the product still in the tank. The material is present; the reporting model has omitted its current stage.
How should food manufacturers account for material that remains in production at the reporting cutoff?
Work in progress is unfinished production within a defined process boundary. Its record should identify the batch, current stage, quantity basis and relevant status. A dependable account explains issued material through completed output, returns, recorded losses and what remains in process, without counting any quantity twice.
- 01Record the issued materialRun, lot and quantity
- 02Capture intermediate positionsOutput, returns and WIP
- 03Review the cut-off accountQuantity and valuation basisIs the remaining WIP evidenced?YesApprove the WIP balanceNoInvestigate the physical position and missing production events.
- 04Approve the WIP balanceRetain unresolved exceptions
Illustrative information flow. The article explains the evidence, exceptions and responsible decisions. Diagram: NextEdge Labs.
Choose useful stages instead of inventing a location for every step
The right level of WIP detail depends on the decisions the team needs to make. A batch may need records at mixing, intermediate holding and packing, while another process has a simpler boundary. Identify where quantity, status or responsibility changes enough to justify a record.
ERPNext work-order documentation includes a WIP warehouse relationship as part of its production model. That is one implementation approach. The site's process design still needs to explain what the WIP record represents and when material enters or leaves it.
Source: Frappe / ERPNext · Work-in-progress warehouse and production material stages. Reference details
Reconcile a simple unfinished batch
Assume an illustrative compatible quantity basis with 500 kilograms issued. At cutoff, 360 kilograms are recorded in completed output, 100 kilograms remain measured in process, twenty kilograms are returned unused and ten kilograms are recorded as loss. Those events explain 490 kilograms, leaving ten unresolved.
The quantity account should show the unresolved balance rather than assigning it automatically to WIP. Using WIP as the balancing figure makes the report add up while avoiding the physical question. If the remaining quantity is estimated under an approved method, identify the estimate and its basis separately.
| Outcome | Quantity |
|---|---|
| Completed output | 360 kg |
| Measured WIP | 100 kg |
| Unused material returned | 20 kg |
| Recorded loss | 10 kg |
| Unexplained difference | 10 kg |
| Total issued | 500 kg |
A tank level and a stock unit may not be directly comparable
The operation may observe level or volume while inventory uses mass. Use the qualified, approved measurement and conversion approach relevant to the material and equipment. Retain the basis and time. Do not convert a rough visual observation into a precise kilogram figure without disclosing how it was obtained.
Process changes can also affect the appropriate comparison. Added water, evaporation, multiple outputs or intermediate transfers may need their own account. Production and finance should agree the boundary with the process owner before using WIP quantities in yield or cost reporting.
Prevent the same material appearing in two stages
A production completion should move the relevant account from unfinished to completed according to the system's defined transactions. If a manual WIP sheet remains unchanged after finished output posts, the report may count the material twice. Link the stage movement and preserve the supporting batch reference.
The opposite failure occurs when issue immediately removes material from every inventory view until final completion. Keep the intermediate state visible, with its current owner and status. A batch can be physically in process but awaiting a quality or production decision; the WIP record should not imply that it is available for ordinary dispatch.
Separate physical quantity from financial valuation
Finance determines how the business values unfinished production under its approved policy and system configuration. The physical account supplies evidence about quantity and stage; it does not by itself establish the appropriate cost treatment. Keep material, conversion and any estimation assumptions visible in the financial view.
A later measurement or production correction can change the account. Preserve the cutoff snapshot and link the correction rather than silently replacing the earlier record. This lets the controller distinguish new evidence from a transaction that belonged to another period.
Start with the batch that crosses a shift boundary
Choose a run that is routinely unfinished at handover and follow it through the next completion. Compare the warehouse issues, physical stage quantity, production record and returns. Ask the incoming shift to explain the next action using the record alone.
An initial automation can assemble those events and flag missing stage confirmations. It should not fabricate WIP from the residual difference. The useful result is an account that remains explainable across the reporting cutoff, with unresolved quantities assigned to an owner.
Summary
WIP makes the middle of the production account visible. Its value depends on a defined stage, measurement basis and cutoff, with no duplicate counting. Keep the physical evidence reliable so planning, quality and finance can apply their own authorised decisions to the same unfinished work.
What to do next
- Select a batch that crosses a shift or month-end boundary.
- Reconcile issued material with output, returns, loss and observed WIP.
- Define the event that moves the quantity into its next stage and test a late correction.
Recognise this problem in your operation?
Tell us where the records or handovers break down. We can discuss the process, data and software questions worth examining first.
Sources and further reading
Sources checked 15 October 2026. The worked examples and software evaluation suggestions are NextEdge Labs’ editorial analysis.
- Work OrderFrappe / ERPNext · Online product documentation, accessed October 2026
Illustrates production orders, material requirements and warehouse stages. The proposed operating controls remain specific to the business.
Visual credits
AI-generated illustration created for NextEdge Labs; it does not depict a client facility. Workflow diagram by NextEdge Labs. Icons from Lucide (ISC licence).
