Worksheet: Yield Reconciliation Calculation

This is a ready-to-use worksheet for calculating yield reconciliation at each stage of a manufacturing batch and for the overall material balance across the batch. It attaches to the executed batch record as supporting evidence for the batch record reviewer and is the working paper behind the yield rows a reviewer checks. Replace every <<FILL: ...>> placeholder with your own specifics. A fully worked specimen follows. Verify every action limit against your own validated process history before relying on it; the limits shown here are illustrative.

Document control header

Instructions

1. Complete one row of Part B for each stage the master record defines a theoretical yield for. Do not skip a stage because the number “looks fine”; every defined stage gets a calculated row.
2. Pull the action-limit range for each stage from the validated process range on file, not from memory or from what feels reasonable. If no validated range exists for a stage, that is itself a gap to raise, not a reason to skip the check.
3. Complete Part C (material balance) for the whole batch, not only the per-stage yields; a set of individually acceptable stage yields can still hide an unaccounted loss across the batch as a whole.
4. Complete Part D (trend check) against the most recent <<FILL: e.g. 10>> batches of the same product and stage before concluding the review; both a yield below action limit and a yield that repeats an identical value batch after batch are findings.

Part A: Batch and formula

Formula, applied at every stage:

Percent yield = (Actual output quantity / Theoretical output quantity) x 100
Percent loss  = 100 - Percent yield

Part B: Per-stage yield reconciliation

Part C: Material balance across the batch

Confirm every unit of material dispensed into the batch is accounted for, not only that the finished-stage yield is within range. This is the check that catches a diversion that no single stage’s yield, by itself, would flag.

Part D: Trend check against campaign history

Part E: Conclusion and sign-off

Acceptance criteria

This worksheet is complete and defensible when all of the following are true:

• Every stage the master record defines a theoretical yield for has a calculated row in Part B; none is skipped.
• Every action-limit range used is a documented, validated range, not an ad hoc judgment.
• The material balance in Part C accounts for the finished product, samples, rejects, and documented process loss, and the residual difference is within a stated tolerance or is explained.
• The trend check in Part D compares this batch to real campaign history, not to a single prior batch or to intuition.
• Any out-of-range result, unreconciled material balance, or suspicious trend has a deviation reference or a documented, evidence-based explanation before the worksheet is signed complete.

References

21 CFR 211.103 (calculation of yield: actual yields and percentages of theoretical yield determined at the conclusion of each appropriate phase of manufacturing, processing, packaging, or holding). 21 CFR 211.192 (investigation of any unexplained discrepancy, including a yield discrepancy, whether or not the batch has already been distributed). ICH Q7, Section 6.7 (production record review, including yield reconciliation, for active pharmaceutical ingredients).

Confirm the current version and clause numbers of each reference before issue.

Filled specimen

The following shows the worksheet completed for an illustrative solid oral dose batch carried through granulation, compression, and coating. The company, batch, and numbers are illustrative; replace them with your own.

Part A:

Part B:

Part C: Material balance

Part D: Trend check

Part E:

The material balance in Part C is what separates this from a simple per-stage check: the batch’s finished-product-plus-documented-loss adds back up to within 0.35 percent of what was dispensed, so the granulation shortfall is accounted for by a specific, referenced filter loss and drying loss, not an unexplained gap. The trend check in Part D independently confirms the granulation stage, not the whole process, is the source of the deviation, which is exactly what the deviation investigation should also conclude.

Common inspection findings this worksheet prevents

• A stage yield calculated but never compared to a validated action-limit range, so a real excursion is accepted as “looks about right.”
• Per-stage yields all individually acceptable while the batch as a whole has an unreconciled material gap, because no one added up product, samples, rejects, and loss against what was dispensed.
• A yield trend never compared to campaign history, so a slow drift across many batches, or a suspiciously identical repeat, goes unnoticed.
• A low-yield stage explained verbally at review with no worksheet or deviation reference behind the explanation.

How to adapt this worksheet

1. Set the worksheet number and governing SOP in the header to match your batch record review procedure.
2. Replace the stage rows in Part B with the actual stages your master record defines theoretical yields for; add or remove rows accordingly.
3. Pull your action-limit ranges and material-balance tolerance from your own validated process history and state their source (validation report, process characterization study) in the worksheet or the governing SOP.
4. If your product’s cumulative yield is not simply the product of per-stage yields (for example where solvent or moisture loss is expected and validated at a specific stage), state the cumulative-yield basis explicitly rather than assuming a straight multiplication.
5. Confirm every regulation in the References section against the current published version before issue.