Independent and not affiliated with the FDA, MHRA, ISPE, PDA, or any agency. Get the appgoutham@madhadi.com
madhadi.comData Integrity & GxP Quality
Browse all topics -> Articles Templates & Procedures Learning paths GlossaryScenariosToolsRegulatory ReferencesLearning PathsTopics About Start here
Log Plug-and-play starting point Supply Chain & GDP

Log: Distribution Chain-of-Custody and Condition Reconciliation

A plug-and-play log that reconciles every custody handoff in a shipment's journey against the temperature logger span, closing the gap between a clean-looking custody trail and a condition record with an undetected hole, with a worked specimen.

Document type: Log

Read and copy the template below into your own quality system. It is a generic starting point for your own internal use, provided as is, with no warranty; see the Terms and License. Adopting it does not by itself create compliance.

This is a ready-to-use log for reconciling custody continuity against condition (temperature) continuity for a single shipment, the check that catches the gap a clean-looking custody trail can hide. Custody continuity and condition continuity are two separate proofs; this log forces both to be checked together, per shipment, not assumed from a tidy-looking dispatch record alone. Replace every <<FILL: ...>> placeholder with your own specifics. A worked specimen follows.

Instructions

Complete one log per shipment requiring chain-of-custody assurance (high-value, temperature-sensitive, or controlled product, per your risk classification). Populate the handoff rows from the WMS, TMS, and carrier tracking systems, then reconcile against the logger span in the summary section.

Field table

FieldFormatRequiredCompleted byWhen
Shipment / dispatch record number<<FILL>>YesLogisticsAt dispatch
Logger serial<<FILL>>YesLogisticsAt dispatch
Logger start time (configured)Date/time, time zone statedYesWarehouse operatorAt activation
Handoff eventFree text (e.g. dispatch scan, carrier pickup, hub arrival, hub departure, delivery scan)YesSystem of record per eventAt each handoff
Handoff timeDate/time, time zone statedYesSystem of recordAt each handoff
Releasing party (name or ID)<<FILL>>YesSystem of recordAt each handoff
Receiving party (name or ID)<<FILL>>YesSystem of recordAt each handoff
Source system<<FILL: WMS / TMS / carrier track / logger portal>>YesReviewerAt reconciliation
Logger read-out time and final spanDate/time range, time zone statedYesReceivingAt receipt
Reconciliation outcomeContinuous / gap identifiedYesReviewerAt reconciliation
Gap description, if anyFree text: duration, which boundary (before first handoff, between handoffs, after last handoff, before logger start, after logger stop)Yes if gap foundReviewerAt reconciliation
EscalationQuality event reference, if a gap was foundYes if gap foundReviewerAt reconciliation

Retention

Retain with the shipment record per the records retention schedule, for not less than <<FILL: retention period>>.


Filled specimen

Completed for the custody-gap worked example used in the parent article, shown here with a genuine gap so the log format is visible in both outcomes.

Handoff table:

Handoff eventTimePartySource system
Dispatch scan2026-06-10 06:05 EDTWarehouse, J. RiveraWMS
Carrier pickup2026-06-10 06:40 EDTCarrier driver, badge 8841TMS
Hub arrival2026-06-10 11:10 EDTCarrier hubCarrier track
Hub departure2026-06-10 19:55 EDTCarrier hubCarrier track
Delivery scan2026-06-11 23:30 EDTReceiver, M. OseiWMS

Reconciliation summary:

FieldEntry
Shipment numberSHP-2026-11842
Logger serialTL-2291847
Logger start time (configured)2026-06-10 12:00 EDT
Logger read-out time and final span2026-06-11 23:32 EDT; span 2026-06-10 12:00 to 2026-06-11 23:32
Reconciliation outcomeGap identified
Gap descriptionCustody trail is continuous from dispatch (06:05) through delivery (23:30), but the logger did not start until 12:00, leaving a six-hour window (06:05-12:00) with no temperature evidence even though custody looks unbroken
EscalationQuarantine pending investigation; deviation DEV-2026-0198 raised against the activation SOP

The custody trail alone would have passed review; it is unbroken from dispatch to delivery. The reconciliation against the logger span is what surfaces the six-hour condition gap, which is the finding that actually matters for a temperature-sensitive product.

Common inspection findings this log prevents

  • A custody trail reviewed and accepted as continuous without ever being checked against the logger span.
  • A logger start time later than the dispatch time, with the resulting gap unnoticed because no one reconciles the two records against each other.
  • Handoff events recorded by generic accounts (“courier,” “warehouse”) with no individually attributable party.
  • A reconciliation performed only when something already looks wrong, rather than as a routine step on every shipment in scope.

How to adapt this log

  1. Set the risk-based criteria for which shipments require this reconciliation (temperature-sensitive, high-value, controlled substance, or any shipment flagged for a chain-of-custody requirement in your quality system).
  2. Pull handoff times directly from source systems, not from a manually retyped summary, so the reconciliation reflects the actual system records.
  3. Standardize time zone reporting across every source system referenced, or convert everything to UTC before reconciling, since most apparent gaps are really unresolved time zone differences.
  4. Route any identified gap to your deviation or quality-event system immediately; do not let the log sit as a passive record with an unresolved gap noted but not escalated.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.