AI-generated illustrative scene of a warehouse worker in a high-visibility vest scanning plain white cartons on pallet racking.
AI-generated illustrative scene, not an Inveck customer site.

Pharmaceutical Stock Reconciliation: Count by Batch, Expiry and Stock Status

A physical count can match the total on a screen and still miss a serious stock-control problem. One batch may be available for use, another may be awaiting a quality decision, and a third may be close to expiry. Adding them into a single total hides those differences.

Pharmaceutical stock reconciliation means comparing what is physically present with the corresponding records, then investigating differences. The comparison needs enough detail to distinguish the product, batch, location and stock status. The purpose is not to force every number to match. It is to produce a record that the warehouse and quality teams can explain.

This guide covers a practical counting and reconciliation approach. It is not a release procedure, a regulatory compliance assessment or a substitute for the site’s approved procedures.

Start with the question the count must answer

Before counting, agree what the result will be used for. Is the team checking a selected storage area, investigating a discrepancy, or reconciling a wider stock balance?

Define the scope and reference time, then identify the responsible warehouse and quality staff. A useful count record may include:

  • Product name or item code, with the presentation or pack size needed to identify it.
  • Batch number and expiry or retest date, where applicable.
  • Storage location and unit of measure.
  • Stock status, such as released, quarantined, returned or rejected.
  • Physical quantity, count time and the person recording it.
  • The corresponding recorded quantity and any relevant movement references.

Use fields that match the site’s product records and procedures. Do not invent a new status label that could be confused with an existing quality decision.

Keep physical quantity separate from usable quantity

“Present in the warehouse” does not automatically mean “available to distribute.”

WHO’s good storage and distribution guidance says returned medical products should be placed in quarantine on receipt, with their status clear and distribution prevented until a disposition decision is made. It also calls for stock records, periodic reconciliation and investigation of discrepancies.[1]

For a count team, the practical point is simple: record what is there without changing its status. A counter finding a returned carton should not move it into released stock merely because the carton looks intact or its quantity matches a record. Assessment and disposition belong to the authorized people and procedures.

Likewise, do not omit quarantined or rejected stock simply to make the usable-stock total look correct. Include it in the appropriate count scope and keep its status distinct.

Use a batch-and-status table, not just a product total

Consider this hypothetical example. It illustrates a count method, not a customer result or an Inveck screen.

Item Batch Expiry Location Recorded status Recorded cartons Counted cartons
Product A B101 Jun 2027 Released rack R1 Released 40 38
Product A B102 Sep 2027 Released rack R2 Released 30 30
Product A B101 Jun 2027 Quarantine Q1 Returned, awaiting decision 5 7

The overall count is 75 cartons against 75 recorded cartons. At product-total level, nothing appears wrong. At batch, location and status level, there is a shortage of two in the released rack and an excess of two in quarantine.

Illustrative reconciliation table showing equal product totals but separate discrepancies in released and quarantined stock.
Fictional example: an equal product total can hide batch, location and stock-status differences.

That does not prove a transfer occurred. The team should check item and batch identification, movement documents, count accuracy and status records. The two differences may have one cause or separate causes. Do not net them away without evidence.

Protect the count from timing and movement errors

A physical observation and a system quantity taken at different times may not be comparable.

Agree how receipts, issues, transfers and returns will be controlled while the relevant area is counted. Where movement continues, retain the records needed to relate the physical observation to the agreed comparison time. Reconcile each movement once, rather than making an undocumented adjustment to obtain a match.

Check the unit as carefully as the quantity. Cartons, packs and individual units are not interchangeable. If a conversion is needed, use the approved item information and document it. A pack-size misunderstanding can create an apparent discrepancy even when the physical count is correct.

The count must also respect the product’s required storage conditions and the site’s access controls. Do not leave temperature-sensitive products outside controlled storage to make counting easier.

Review expiry information without making release decisions

WHO guidance calls for regular checks to identify stock approaching its expiry or retest date, with appropriate action. It also describes first-expired, first-out stock rotation.[1]

Use the count to flag missing, inconsistent or approaching dates for review. Do not assume that an earlier expiry date alone authorizes a shipment, or that a physical count can determine whether a product remains suitable for use. Those decisions require the site’s applicable controls and qualified staff.

A count record can support the review by making batch, date, location and status information visible. It does not replace quality assessment, environmental records or a validated release process.

Investigate differences before closing the record

For each discrepancy, check:

  1. Was the correct product, batch and location counted?
  2. Were the unit and pack conversion understood?
  3. Were all locations in scope included without double counting?
  4. Do receipts, issues, transfers or returns explain the timing difference?
  5. Is the recorded stock status consistent with the relevant documentation?
  6. Is a recount or quality review required under the site’s procedure?

Record the explanation, supporting references and responsible reviewer. If the cause is unresolved, say so. WHO guidance calls for identifying root causes and taking appropriate corrective and preventive action to reduce recurrence.[1] A quantity correction alone does not establish why the discrepancy happened.

For a broader explanation of how to organize differences, see the inventory variance report guide.

A practical closeout checklist

Before closing the reconciliation, confirm that the record preserves:

  • The original count and the scope and time it relates to.
  • Separate batch, location and stock-status information where needed.
  • Recounts, movement references and unit conversions used in the review.
  • Unresolved exceptions and their assigned owner.
  • Any authorized adjustment or disposition reference, without implying the counter approved it.

Digital counting can help organize observations, remarks and review records. The right tool must still be checked against the site’s actual field, permission and quality-system requirements. Do not assume that a general inventory application is a validated pharmaceutical compliance system.

A useful pharmaceutical stock reconciliation explains both the quantity and the status of the stock. When those are kept separate, the team can see a mismatch that a single total would hide, investigate it properly and leave a record others can follow.

Sources and scope

[1] World Health Organization, Good storage and distribution practices for medical products, WHO Technical Report Series 1025, Annex 7, 2020. Sections 9 (returned goods), 12 (premises, stock rotation and storage conditions), 13 (stock control and rotation), and 17 (documentation). https://www.who.int/docs/default-source/medicines/norms-and-standards/guidelines/distribution/trs1025-annex7-%281%29.pdf

The WHO document is international guidance. This article does not state that it replaces current Indian law, licence conditions, customer requirements or the site’s approved procedures. The example quantities are fictional. No claim is made that Inveck has GMP/GDP validation, electronic-release controls, cold-chain monitoring or a pharmaceutical certification.