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
Form Plug-and-play starting point Data Integrity

Worksheet: Injection Sequence Reconciliation

A plug-and-play worksheet to reconcile every injection in an analytical sequence against a documented purpose during second-person review, so orphaned injections and testing into compliance are caught, with the reconciliation math, field definitions, and a filled specimen.

Document type: Form

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 worksheet for reconciling an analytical injection sequence during second-person review. Its single job is to prove that every injection the instrument performed maps to a documented purpose, so an injection that appears on the instrument but nowhere in the reported record, the fingerprint of testing into compliance, cannot slip past. The reviewer counts and accounts. Replace every <<FILL: ...>> placeholder. A filled specimen follows. This is general guidance to adapt, not legal or regulatory advice.

Purpose

Confirm that the total number of injections in the instrument sequence log equals the sum of injections with a documented purpose (samples, standards, blanks, brackets, system suitability, and documented aborts with a reason), leaving zero unexplained. An unexplained injection must be resolved before the result set is accepted.

Field definitions

FieldMeaning
Instrument sequence totalThe count of injections the instrument actually performed, read from the sequence or acquisition log, not the report
Reported sample resultsInjections that produced a reported sample value
Standards / blanksCalibration and reference injections
System suitabilitySST injections
Brackets / check standardsBracketing standards run to bound the sample set
Documented abortsAborted or invalidated injections that carry a contemporaneous recorded reason
Accounted forSum of the above documented purposes
Unexplained gapInstrument total minus accounted-for; must be zero

The reconciliation

FieldEntry
Method / test<<FILL>>
Sample(s) / batch<<FILL>>
Instrument / system ID<<FILL>>
Sequence ID<<FILL>>
Reviewer<<FILL>>
Date<<FILL>>

Count table

SourceCount
Injections in the instrument sequence log<<FILL>>
Reported sample results<<FILL>>
Standards and blanks<<FILL>>
System suitability injections<<FILL>>
Brackets / check standards<<FILL>>
Documented aborts with reason<<FILL>>
Accounted for (sum of documented purposes)<<FILL>>
Unexplained gap (instrument total minus accounted for)<<FILL>>

Resolution of any gap

Injection ID / timestampWhat it wasHow resolvedEvidence
<<FILL>><<FILL>><<FILL: logged equilibration / real sample never reported / other>><<FILL>>

Acceptance criteria

The sequence reconciles when the instrument total equals the accounted-for total and the unexplained gap is zero. Any nonzero gap must be resolved, and if resolution shows a real sample run that never reached the report, the result set is not accepted and the event is escalated as a possible testing-into-compliance concern.

Filled specimen

The following completes the worked reconciliation from the second-person review article. Numbers are illustrative.

Header

FieldEntry
Method / testRelated substances, method M-034
Sample(s) / batchS-2026-1187, batch B-4402
Instrument / system IDHPLC-07
Sequence IDHPLC-07-2607-031
ReviewerA. Patel
Date19 July 2026

Count table

SourceCount
Injections in the instrument sequence log22
Reported sample results8
Standards and blanks5
System suitability injections6
Brackets / check standards0
Documented aborts with reason1
Accounted for20
Unexplained gap2

Resolution of any gap

Injection ID / timestampWhat it wasHow resolvedEvidence
Inj 003, 08:41Column equilibration injection, not logged as a purposeConfirmed against instrument method (2 equilibration injections routine at sequence start); trail shows no result generatedAudit trail, method M-034 setup
Inj 004, 08:49Second equilibration injectionSame as aboveAudit trail

Here the two-injection gap resolved to legitimate, unlogged equilibration injections that produced no result, confirmed in the audit trail. The reviewer documented the resolution and accepted the set. Had either injection been a real sample run whose result was never reported, the set would be rejected and escalated: that is the outcome the worksheet exists to force into the open.

Common findings this worksheet prevents

  • An orphaned injection, a run the instrument performed that appears nowhere in the reported record, never detected because the sequence was never reconciled.
  • Testing into compliance, where unfavorable results were generated then discarded so only the passing run was reported.
  • A reconciliation asserted (“sequence checked”) with no count, so it cannot be verified.
  • Aborted or invalidated injections with no contemporaneous reason, counted as documented when they are not.

How to adapt this worksheet

  1. Add rows for technique-specific injection purposes (for example, sensitivity or resolution solutions).
  2. For dissolution and multi-vessel methods, adapt the count to vessels and the profile rather than injections.
  3. Pair this worksheet with the audit trail review work instruction and the analytical data review record.
  4. Keep the reviewer who reconciles distinct from the analyst who generated the sequence.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.