Batch material reconciliation: formula and worked example
Reconcile the actual issued quantity with evidenced consumption, received returns, samples and waste on the same quantity basis. Here, 25.000 kg issued minus 24.950 kg of explained destinations leaves 0.050 kg unresolved. A reservation belongs to a separate planning calculation.
In this guide
A 25.000 kg issue leaves 0.050 kg unexplained.
Batch B-440 reserves 30.000 kg of a material and actually receives 25.000 kg. The reservation is planning data. At reconciliation, four evidenced destinations account for 24.950 kg of the physical issue.
Scroll across to see every column →
| Record | Quantity (kg) | Meaning | Included in the physical balance? |
|---|---|---|---|
| Allocation AL-440 | 30.000 | Planned requirement | No; the reservation is not an issue |
| Issue ISS-440 | 25.000 | Material actually supplied to the batch | Source quantity |
| Consumption USE-440 | 22.400 | Actual material used | Yes |
| Return RET-440 | 2.300 | Unused material physically returned | Yes |
| Waste WST-440 | 0.200 | Recorded loss with supporting evidence | Yes |
| Sample SMP-440 | 0.050 | Material removed for a sample | Yes |
| Difference REC-440 | 0.050 | 25.000 minus 24.950 | Unexplained; requires assessment |
22.400 + 2.300 + 0.200 + 0.050 = 24.950 kg. The remaining 0.050 kg has no established destination. The unused 5.000 kg of the reservation is a separate planning reconciliation; it is not missing physical material.
Download this example as CSVTry the material reconciliation calculation
Change the example inputs to inspect the result. This calculator runs on the website and does not change records in Seal.
Review output and next actions
The supported physical balance is short by 0.050 kg. If later evidence resolves it, link that evidence and record a new assessment. A mathematically balanced total is still separate from correct lot identity and batch disposition.
Material reconciliation owner
Trace each destination to its original observation and check for omissions, duplicate entries or mixed units.
Evidence needed: An attributable explanation or an assessed unresolved difference; do not create a balancing waste entry.
Warehouse receiver
Verify RET-440’s 2.300 kg physical receipt and container/location identity.
Evidence needed: Receipt evidence supports the return. Any material-use restrictions are assessed separately.
Planning owner
Resolve the unused allocation independently of REC-440.
Evidence needed: The allocation history explains the unissued 5.000 kg without changing the physical issue.
Open the filled review worksheet
B-440 material reconciliation and outstanding evidence
This is a fictional worked assessment to adapt to your procedure and actual evidence.
Source pack
- Actual issue and destination records for the same batch, material and quantity boundary.
- Evidence of received returns, measured waste and samples; identify any category totals that already include another destination.
- Source
- ISS-440: 25.000 kg physically issued. The 30.000 kg reservation is excluded from the physical balance.
- Explained destinations
- 22.400 kg consumption + 2.300 kg received return + 0.200 kg waste + 0.050 kg sample = 24.950 kg.
- Open physical difference
- 0.050 kg has no supported destination.
- Separate planning item
- 5.000 kg of the reservation was not issued. It is not missing physical material.
Decisions and exceptions
Scroll across to see every column →
| Situation | Response | Consequence |
|---|---|---|
| 30.000 kg reserved; 25.000 kg issued | Reconcile the unused allocation separately | Only 25.000 kg enters this physical balance |
| 0.050 kg has no supported destination | Retain and assess the difference | Do not generate a balancing consumption or waste record |
| Return recorded but not received | Resolve physical handoff evidence | Do not present a planned return as available stock |
Choose the physical boundary of the balance.
Define whether the balance concerns material leaving warehouse stock, arriving in the manufacturing area or being added to the process. The source and destination events must refer to the same boundary. A transfer from one staging location to another is not new material entering a batch when the balance already covers both locations.
Start with the actual source containers and issue events. If more than one lot or unit basis is involved, keep those populations visible before aggregating. A same-name material is not necessarily the same lot, potency basis or quantity definition. Do not let a total obscure an event that cannot be attributed to its source.
Establish what a return and a waste record actually prove.
RET-440 represents 2.300 kg physically returned, with the receiving container and location identified. A planned return or a label printed for it does not establish receipt. Assess any use-status conditions separately: being back in the warehouse does not by itself establish permission for another batch.
WST-440 accounts for a supported 0.200 kg loss. Keep its observation and method of quantity determination available. The sample is a separate 0.050 kg destination. If a procedure’s waste total already includes samples, define that scope and avoid adding the sample a second time. An unexplained difference should not automatically create a waste entry.
Separate physical completeness from posting completeness.
An external ERP can show a transaction as unacknowledged after the physical event has happened. Reconcile that exchange against its destination identity without deleting the consumption event or recording another physical use. Conversely, a posted reservation or issue is not evidence of every actual addition performed during the batch.
Keep the assessed population identifiable at the review point. A late supported return may resolve a difference, but it should become linked additional evidence with a revised assessment. Preserve the earlier 0.050 kg discrepancy and its resolution rather than making the prior review appear to have had evidence it did not have.
Investigate the 50 g with measurements that can resolve it.
Start with the source and destination measurement records, including gross, tare, net, container identity, unit, instrument and observation time. The first question is whether the figures describe the same material at the same boundary. In the illustrative return ticket below, 2.550 kg gross less 0.250 kg tare supports the existing 2.300 kg net return. Copying gross as net would make the explained total larger by 0.250 kg; it would not explain a 0.050 kg loss.
If an original signed measurement instead supports a transcription correction, link that evidence and record a revised assessment. A later reweigh is a new observation: examine intervening sampling, transfers and handling before using it to correct the earlier amount. A convenient numerical difference is not evidence that the earlier reading was wrong.
The 0.050 kg residual is 0.2% of the 25.000 kg issued. That percentage is a description, not an acceptance limit. Use the procedure’s chosen quantity basis, measurement capability and handling criteria to assess the difference. A balance displaying three decimal places does not prove accuracy to one gram. Preserve an explicitly assessed residual when appropriate rather than manufacturing a waste event.
Scroll across to see every column →
| Check | Illustrative evidence | Effect on the assessment |
|---|---|---|
| Return measurement basis | 2.550 kg gross − 0.250 kg tare = 2.300 kg net | Supports RET-440 as written; residual remains 0.050 kg |
| Sample/waste overlap | SMP-440 is included in the waste source list | Remove duplicate attribution only after establishing the actual population; recalculate |
| An original ticket disagrees with transcription | Ticket and container identity support a different recorded net quantity | Review a controlled correction; retain old value and source evidence |
| A reweigh differs by 50 g | Later observation without intervening movement evidence | Investigate the timeline; do not automatically overwrite the original return |
Questions this example raises
Is material reconciliation the same as batch yield?
No. This balance accounts for where an input material went. A yield calculation compares a defined product output with a theoretical or expected output. Decide which quantity each calculation describes before using either result.
What reconciliation difference is acceptable?
Use the process’s established assessment rules, quantity basis, precision and evidence. This guide does not set an acceptable loss percentage. A difference needs a supported explanation or assessment; a zero balance alone does not establish correct identity or release.
Inspect the proposed record fields
Download the proposed field list
Start from the Manufacturing execution blueprint. The fields below are a proposed design for this case, using Seal’s documented field types and references.
Allocation and physical issue
Keep planned demand separate from the event that moves actual material.
- BatchReference
- B-440 as the consuming work context.
- Allocation quantityNumber
- 30.000 kg planned, with its unit and planning revision.
- Issue eventReference
- ISS-440, supported by the actual source-container movement.
- Issued quantityNumber
- 25.000 kg on the agreed net-mass basis.
Material destination event
Attribute each physical quantity once to what happened.
- Event IDText
- A distinct identity for a use, return, sample or evidenced waste event.
- Event kindSelect
- The physical meaning, rather than a general adjustment category.
- Source containerReference
- The container from which this event removed material.
- QuantityNumber
- The actual net quantity and explicit unit.
- Destination evidenceReferences
- The executed step, received return, sample or waste observation.
- Occurred atTime & date
- The event time, distinguishable from a later correction.
Batch material reconciliation
Retain the assessed event population and any unresolved difference.
- Included issuesReference, multiple
- The physical source population covered by this assessment.
- Included destination eventsReference, multiple
- The attributable use, return, waste and sample events.
- Unexplained quantityNumber with formula
- Issued quantity minus the accepted destination totals.
- AssessmentText / References
- The evidence and decision concerning the remaining 0.050 kg.
Seal can connect those events to the batch and the source containers, giving operations and review a common account of where the material went. This fictional case traces a single material across one batch. The quantities are mass on one consistent basis; they are not a product-yield calculation.
Configure one event history and separate review questions.
Use Seal References to connect the batch, source containers and individual material events. Add an Event kind Select field and distinct quantity and evidence fields so the reconciliation can group destinations by meaning. Attach a per-field formula to the difference Number field using the defined event population and unit basis.
A proposed reconciliation Check can require source identity, complete destination evidence and a documented assessment of differences. Configure batch disposition and material-use decisions with their own requirements. A zero arithmetic difference answers one question; it does not establish that the correct lot was used, the operation followed its instruction or the batch is ready for release.
Configuration references
The record design above is illustrative. These product documentation pages explain the Seal capabilities used in it. They open in the signed-in Seal platform.
Acceptance tests
Download these acceptance cases
These are proposed acceptance tests for the configured workflow. They describe expected behaviour to verify, rather than results of a customer implementation.
The planned quantity is mistaken for the source
Input: Change the reservation from 30.000 to 32.000 kg without another physical issue.
Expected: The physical balance still begins at 25.000 kg; only the planning reconciliation changes.
A sample appears in two categories
Input: Include SMP-440 in both sample and waste evidence.
Expected: The assessment identifies the duplicate quantity attribution rather than treating the apparent balance as complete.
An ERP acknowledgement arrives late
Input: Confirm the existing posting for USE-440 after an earlier timeout.
Expected: The exchange history gains its acknowledgement; no second 22.400 kg physical consumption is created.
Apply this to your records
Use one material and a defined physical boundary for the batch. Keep the actual movements, their measurement basis and the difference assessment in one reproducible account.
Download the blank working review
Write your working notes here
Notes stay in this tab and are not submitted. Download them before leaving to keep a copy. Use record references to identify your evidence.
Identify the batch, material, source lots and containers. State whether the balance begins at warehouse issue, manufacturing receipt or process addition. Define the net-mass unit and keep reservations outside the physical source population.
List the issue events included once each, with container identities and supporting observations. Retain gross/tare/net readings where used, their units, instrument and time. Explain any conversion before aggregating.
List actual use, physically received returns, samples and evidenced waste by event ID. Identify the receiving location/container for returns and the quantity evidence for losses. Check that a sample has not also been counted inside waste.
Record source total minus accepted destinations, preserving the residual. Examine the original measurement records, duplicate attribution and late events. Distinguish a supported transcription correction from a later reweigh after possible intervening handling.
Cite the process’s actual assessment criteria and the evidence supporting the conclusion. Name unresolved quantities and owners. List ERP delivery issues separately so a late acknowledgement does not create another physical use or change the balance.
Unanswered sections remain marked ‘Not recorded’ in the download.
Evidence needed to finish
Every included quantity has attributable evidence on the same basis, each event contributes once, and any residual has an explicit assessment. Planning and posting exceptions remain distinct. A zero difference alone does not establish correct lot identity or batch release.
Review the evidence with neil
Reconcile B-440 material from actual issue events to consumption, received returns, samples and evidenced waste. Keep reservations and ERP delivery states separate from physical quantities. Show each source-container event once, calculate the unresolved 0.050 kg, and list any missing destination or unit evidence for the batch reviewer.
Review the proposed output against these deliverables:
- A physical material balance linked to source and destination events.
- Separate planning and external-posting exceptions.
- The evidence needed to resolve the remaining quantity difference.
Configure this process with Seal
Use a representative source record and an exception your current process struggles with. We can work through the record design, review responsibilities and connection requirements with you.
Discuss this workflow with Seal