All use cases

Investigate a material-balance discrepancy.

Trace a material discrepancy across ERP transactions, batch records and warehouse receipts. Check identities and quantities, rule out false matches and prepare a source-linked report.

Book a demo
Illustration of a seal beside a balance and mixing vessel, with a red thread connecting ingredients to prepared solution bottles.
You

Batch 205 is 1 kg short after the transfer. Can you trace the discrepancy?

neil

I can account for 99 of the 100 kg charged.

1 kg
still unexplained

The , and records total 99 kg after unit conversion. That leaves a gap—not proof of process loss.

I’d check for an unrecorded return or transfer next.

What is included in this balance?

One bulk-transfer step for material MIX-17, batch 205: 100 kg charged, then product collected, samples removed and vessel residual weighed. Quantities use the same mass basis. No reaction, drying or evaporation is included in this example.

96% product recovery and 99% accounted mass are different measures. I haven’t been given the approved limits, so neither percentage is a pass/fail decision.

You

Make a chart and write this up for Quality.

neil

Here’s the draft, with the material balance, source references and the evidence to request next. You can take the chart into your review too.

Batch 205 / Material balance

Where the 100 kg went

Remaining 4 kg · expanded below

Gap

Finding

The records account for 99 of the 100 kg charged. The remaining 1 kg is unexplained—not a demonstrated process loss.

Read the reconciliation

Draft for Quality review.

100−(96 + 1 + 2)=1 kg

Finding

The supplied records account for 99.0 kg, leaving 1.0 kg unexplained. Keep that difference visible until supporting evidence or an authorised correction is recorded.

Assessment

The accounting boundary starts with CHARGE-205's 100 kg. OUTPUT-205 records 96,000 g of product and SAMPLE-205 records 1,000 g of samples: 96 kg and 1 kg respectively. LOSS-205 contributes a further 2 kg of documented residual. These distinct output streams total 99 kg. Product recovery is 96%, while total accounted mass is 99%—the two measures answer different questions. The remaining 1 kg is an unexplained difference, not an additional measured loss.

Method

Used the recorded 100 kg charge as the accounting boundary, not an inventory issue quantity. Matched the four supplied records to batch 205 and converted the product and sample quantities from grams to kilograms. Counted each recorded output once; no estimated loss or balancing adjustment was added.

Scope and limits

One bulk-transfer step for material MIX-17, batch 205: 100 kg charged, then product collected, samples removed and vessel residual weighed. Quantities use the same mass basis. No reaction, drying or evaporation is included in this example.

Product recovery is 96%; accounted mass is 99%. The approved reconciliation limits and measurement uncertainty have not been supplied. This report identifies a discrepancy; it does not classify a yield failure or declare either percentage acceptable.

Evidence to request

Request return and transfer transactions for batch 205. Verify the material, quantity and destination, then check that any returned quantity is not already included in the product or equipment residual.

Work to take forward

  1. Normalise quantities only where conversion evidence is available.
  2. Match batch, material and container identities; separate posted movements, draft requests, physical receipts and duplicate references.
  3. Prepare a chart and investigation report with excluded matches, the remaining discrepancy and specific evidence requests for review.

Evidence in scope

  • Batch charges, intermediate transfers and recovered quantities
  • Samples, returns and documented process losses
  • Approved calculation basis and unit/density references

Your team’s decision

The process reviewer checks the calculation basis and assesses any discrepancy. neil does not create a process-loss entry to force the balance to close.

Sources

You

There are two 1 kg returns in the ERP extract. Can either explain it?

neil

The quantities match, but the records tell different stories.

RET-204 belongs to another batch. RET-205 names batch 205 and container C-205-R, but it is only a request—not a posted movement or a warehouse receipt.

I’d request the receipt and net weigh record for C-205-R. Until then, I wouldn’t use either entry to close the gap.

You

Here’s the warehouse receipt. Does it match the return request?

Warehouse receiptWH-205 1,000 g

Batch 205 · MIX-17 · C-205-R. Received into quarantine Q-02 at 15:40 UTC, cross-referenced to RET-205.

neil

Yes. WH-205 matches the batch, material and container in RET-205. Its 1,000 g net weight equals the requested 1 kg.

These are two records of one possible return. I’d count the physical quantity once, subject to verification of the receipt and weigh record.

99 kg + 1 kg return = 100 kg

The receipt could explain the material gap; the ERP request still needs resolving. Neither tells us why the posting was missed, or approves the quarantined material for use.

I’ve kept the original finding and drafted an additional assessment with the matching evidence and unresolved work.

What still needs to happen?
Warehouse
Verify WH-205 against the source weigh record, container identity and physical receipt. Confirm this quantity is not included in OUTPUT-205 or LOSS-205.
Inventory control
Resolve RET-205’s unposted status and cross-reference WH-205. Do not count the request and receipt as two returns.
Quality
Review the original discrepancy, the additional evidence and the approved reconciliation limits before accepting the assessment.
This demo uses prewritten replies.

Batch charge record

CHARGE-205

Material charged

100 kg

Batch
205
Used in reconciliation
100 kg
Full source record
Recorded evidence
100 kg; batch charge record
Accounting boundary
One bulk-transfer step for material MIX-17, batch 205: 100 kg charged, then product collected, samples removed and vessel residual weighed. Quantities use the same mass basis. No reaction, drying or evaporation is included in this example.

Now bring your own batch.

Start with a case your team has already reviewed. Ask neil to reconcile the records, then compare the sources, findings and follow-up work.

Book a demo
Take this prompt with you
Investigate this batch’s material-balance discrepancy. Confirm the accounting boundary, reconcile the measured quantities, and check candidate returns against batch, material, container and transaction status. Show what remains unexplained and prepare a report with the source references and evidence to request next.
Browse all use cases