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

Checklist: Hybrid Record Reconciliation and Second-Person Review

A runnable per-record checklist for reconciling the paper and electronic halves of a hybrid record: count, identity, value, time and sequence, audit trail, exceptions, and the signature link, each item stating what it tests for, with Pass, Fail, and NA columns, escalation triggers, a signoff block, and a filled specimen.

Document type: Checklist

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 checklist for one hybrid record, run by the second-person reviewer before the record is used to support any decision. It executes the reconciliation defined in the hybrid record control and reconciliation SOP and turns it into a set of questions with a recorded answer, so that a reviewer’s signature is backed by visible evidence rather than by assertion. Replace every <<FILL: ...>> placeholder, set your document numbers, and route the checklist through your normal document control. A filled specimen follows. Verify each cited regulation against the current source before you rely on it, and adapt this to your own processes rather than treating it as legal or regulatory advice.

The single rule that shapes the whole checklist: start from the electronic side and make the paper account for it. Starting from the paper only ever confirms that the paper is complete, and the paper is the half designed to look complete.

Document control header

FieldEntry
Document titleHybrid Record Reconciliation and Second-Person Review Checklist
Document number<<FILL: CL-ID, e.g. CL-QA-031-01>>
Parent SOP<<FILL: SOP-ID for hybrid record control and reconciliation>>
Version<<FILL: version, e.g. 1.0>>
Effective date<<FILL: effective date>>
Document owner<<FILL: role, e.g. Head of Quality Assurance>>
Applies to<<FILL: roles performing second-person review of hybrid records>>

When to use this checklist

Run it once per hybrid record, at the point of second-person review, before the result, batch step, or dataset is used to support a decision. Run it in full for every record from a hybrid classified High criticality in the hybrid inventory register. For Medium and Low criticality hybrids, run the sections your procedure specifies and record the sections marked NA with the reason. Do not run it retrospectively as a paperwork exercise weeks after the activity; the value of the check comes from the operator still being available to explain an exception.

Before you start

Have all of the following in hand. If any item is missing, stop and record the reason; a reconciliation performed without the electronic source is not a reconciliation.

ItemWhere it comes from
The paper half in original form, all pagesThe executing area, not a photocopy unless the copy is certified
The governing electronic record, opened in the system<<FILL: system name>>, with read access for the reviewer
The audit trail for the activity periodSame system, exported or viewed on screen
The hybrid inventory entry, including the declared governing record<<FILL: register document number>>
The applicable method, batch record instruction, or protocolDocument control
Any deviation, investigation, or change record cited on either half<<FILL: quality system name>>

How to complete

  1. Enter the record identification block.
  2. Work sections A to G in order. Do not skip forward; the count check in section B changes what you look for in every later section.
  3. Mark each item Pass, Fail, or NA. NA requires a reason on the same line. A blank is not an answer.
  4. Any Fail stops the review at that point for that item and routes to section H. Continue the remaining items so the full picture is captured, but do not sign the record as reconciled.
  5. Complete the exception log, the disposition, and the signoff.

Record identification

FieldEntry
Activity and record identifier<<FILL>>
Hybrid inventory reference<<FILL: HYB-ID>>
Declared governing record<<FILL: electronic / paper / split-field>>
Electronic system and identifiers<<FILL>>
Paper form or record number, pages<<FILL: form ID, page N of M>>
Activity date and time window<<FILL: from>> to <<FILL: to>>
Executed by<<FILL>>
Reviewer<<FILL>>
Review date<<FILL>>

Section A: setup and provenance

#CheckWhat it tests forPassFailNAEvidence or comment
A1The hybrid inventory entry exists and its declared governing record matches what you are treating as governing todayThat the record is a recognised, controlled hybrid and not an undeclared one
A2You opened the governing electronic record in the system, not a printout or an export someone handed youOriginal: review of a copy cannot detect what the copy omitted
A3You started this review from the electronic sideEffectiveness of review: paper-first review confirms only paper completeness
A4The paper half is the original controlled form, all pages present, page numbering reads “N of M” and reaches MComplete: a removed page is only detectable against a stated total
A5The controlled form number is within the issued range for this activity per the form issuance recordComplete: an unissued or unreconciled form is an uncontrolled record
A6The applicable method, instruction, or protocol version cited on the record is the version that was effective on the activity dateAccurate: execution against a superseded instruction

Section B: count

#CheckWhat it tests forPassFailNAEvidence or comment
B1The number of electronic events in the period equals the number of paper entriesComplete: the primary detector of missing or added activity
B2The count includes blanks, standards, controls, system suitability, and bracketing entries, not only reportable samplesComplete: partial counting hides discarded work
B3Every aborted, failed, cancelled, or terminated electronic event appears on the paperComplete: aborted runs absent from paper is the classic testing-into-compliance pattern
B4Every repeat or re-run on either half is present on both, and each repeat states why it was repeatedComplete and Accurate: an unexplained repeat is an untested result selection
B5Any machine-generated sequential counter runs without a gap across the periodComplete: a counter gap is discarded data until demonstrated otherwise
B6Where a counter gap exists, the explanation is recorded on the record and is consistent with the electronic evidenceComplete: an explanation asserted verbally is not evidence

Section C: identity

#CheckWhat it tests forPassFailNAEvidence or comment
C1Each electronic result maps to exactly one paper entry using the machine-generated identifier named in the inventoryAttributable and Complete: prevents silent swapping of results between records
C2No electronic event lacks a paper counterpart (no orphan on the electronic side)Complete: an orphan electronic event is activity nobody recorded
C3No paper entry lacks an electronic counterpart (no orphan on the paper side)Accurate: a paper entry with no electronic source may be transcribed from nowhere
C4The identifier on the paper was copied accurately, character for character, from the electronic outputAccurate: a mistyped identifier breaks the link the whole control depends on
C5The record identifier appears on every page of the paper half, not only the first or the signature pageOriginal: prevents a page being substituted or a signature page being transferred
C6Sample, subject, batch, or material identity on the paper matches the electronic record exactly, including any suffix or preparation designatorAccurate: identity mismatch is a result assigned to the wrong thing

Section D: value

#CheckWhat it tests forPassFailNAEvidence or comment
D1Every value transcribed from the electronic source to paper was verified against the source during this reviewAccurate: transcription without verification is the most common error class in hybrids
D2Transcribed values match to the full number of significant figures reported by the system, with no silent roundingAccurate: rounding introduced at transcription changes reported results
D3Units on paper match the units the system reportedAccurate: unit substitution is a recurring root cause in real investigations
D4Calculations performed on paper were independently recalculated during this reviewAccurate: the arithmetic is part of the record
D5Where no transcription occurs because the output is attached or printed directly, the attachment is the actual output for this record and is legibleOriginal and Legible: attached but unreadable is a failed record
D6Any value that appears on both halves is identical on bothConsistent: divergence between halves is the defining hybrid failure

Section E: time and sequence

#CheckWhat it tests forPassFailNAEvidence or comment
E1The order of events on paper matches the order recorded electronicallyConsistent: reordering after the fact
E2Each paper entry time falls within the corresponding electronic event window, not before itContemporaneous: an entry timed before its event was written from expectation, not observation
E3No block of paper entries carries a single identical time or handwriting pattern suggesting end-of-shift completionContemporaneous: backfilling from memory
E4The instrument or system clock was not changed during the activity period, per the audit trailContemporaneous: an unlogged clock change makes sequence unprovable
E5Where paper and electronic clocks are independent, the recorded offset between them is within <<FILL: acceptable offset, e.g. 5 minutes>>Consistent: an uncontrolled offset defeats sequence reconstruction
E6Any late entry on the paper carries both the event time and the entry time, with a reasonContemporaneous: the controlled late entry is acceptable, an undisclosed one is not

Section F: audit trail

#CheckWhat it tests forPassFailNAEvidence or comment
F1The audit trail was enabled and complete for the entire activity period, with no gap or disabled intervalComplete: a gap invalidates every downstream check
F2Deletions of data, files, sequences, or samples in the period are identified, and each is explained on the paper record or in an approved deviationComplete: undisclosed deletion is a data integrity event, not a documentation issue
F3Reprocessing, re-integration, manual integration, and method or sequence edits are identified and each carries a recorded reasonAccurate: undisclosed reprocessing is the finding this whole control exists to catch
F4Each recorded reason was assessed against the method or instruction, not merely noted as presentEffectiveness of review: a reason that nobody evaluated is decoration
F5Renamed, copied, or relocated files in the period are identified and explainedOriginal: renaming is how a failing result becomes an unremarkable one
F6User account, role, or privilege changes in the period are identified and were authorisedAttributable: privilege escalation during the activity window
F7Every electronic action in the period resolves to a named individual, and that individual matches the person who signed the paper for the same stepAttributable: the shared-login failure mode

Section G: exceptions

#CheckWhat it tests forPassFailNAEvidence or comment
G1Every aborted, repeated, out-of-sequence, or invalidated event is explained on the recordComplete: exceptions are where reconciliation is most often skipped
G2Every correction on paper follows the single-line cross-out convention, leaving the original legible, with initials, date, and reasonLegible and Original: obliteration reads as concealment
G3Every correction that affects a value appearing on both halves was propagated to both halves and cross-referencedConsistent: a one-sided correction creates a permanent discrepancy
G4Every deviation, investigation, or out-of-specification reference cited on either half resolves to a real, retrievable recordAvailable: dangling references are common and easy to check
G5No blank mandatory field remains, and every intentionally blank field carries a justified NA rather than being left emptyComplete: an empty field cannot be distinguished from an omitted step
#CheckWhat it tests forPassFailNAEvidence or comment
H1Every signature carries the printed name of the signer, the date, and the stated meaning of the signingSignature manifestation, consistent with 21 CFR 11.50
H2The reviewer signature meaning explicitly includes reconciliation and review of the electronic audit trailEffectiveness of review: a meaning that omits this permits paper-only review
H3Every signature and initial resolves to an entry in the specimen signature registerAttributable
H4The paper identifies the specific electronic record it approves by the machine-generated identifier, so the signature could not be transferred to a different recordSignature and record linking, consistent with 21 CFR 11.70, which covers handwritten signatures executed to electronic records
H5The signed page is the substantive page or is bound to it by page numbering and the record identifier, not a detachable standalone cover sheetSignature and record linking: a liftable signature page is a weak link
H6Execution and review were performed by different individuals, and the reviewer did not perform the work being reviewedIndependence of the second-person check
H7Where the electronic system supports it, the electronic record notes that a paper approval exists and where it is filedAvailable: the electronic record is otherwise silently missing half its approval history

Exception log

Record every Fail and every NA that required a reason. One row per item.

Item #What was observedClassification (see below)Immediate actionDeviation or event referenceNotified to, date
<<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>

Escalation triggers

Apply the classification below and act accordingly. Notify Quality Assurance the same working day for any classification other than “control functioned”.

What was foundClassificationAction
A transcription error found and corrected by this checkControl functionedRecord, trend, no deviation
A transcription error that did not affect any result or decisionDocumentation errorDeviation, retraining, trend for a pattern
A transcription error that changed a result, a calculation, or a dispositionSignificantDeviation with impact assessment; widen the review to the surrounding period
Reconciliation was not performed previously although the halves agreeProcedural failureDeviation; the control was absent and agreement this time is not evidence the control works
A gap in a counter, a sequence, or page numbering that nobody can explainPotential lost dataInvestigate as potentially discarded data until demonstrated otherwise
An orphan electronic event with no paper tracePotential lost dataInvestigate; do not close on the basis that the paper looks complete
Any Fail on F2, F3, F5, F6, or F7 that cannot be explained from the recordPotential data integrity eventEscalate immediately per <<FILL: SOP-ID for data integrity events>>. Do not close as a routine deviation. Preserve the electronic evidence before further work on the system.
Any Fail on H4 or H5Signature link weaknessDeviation; assess whether prior records share the same weakness

Affected data is not released or used until every exception is resolved and dispositioned.

Disposition and signoff

FieldEntry
Total items applicable<<FILL>>
Pass<<FILL>>
Fail<<FILL>>
NA (with reasons recorded)<<FILL>>
Overall outcomeReconciled / Reconciled with exceptions closed / Not reconciled, held
Data released for useYes / No, with reason
Reviewer name, signature, date<<FILL>>
Signature meaning<<FILL: e.g. "Reviewed the governing electronic record including its audit trail, performed reconciliation per SOP-QA-031, and dispositioned all exceptions">>
QA approval name, signature, date (required where any Fail was recorded)<<FILL>>

Acceptance criteria

The reconciliation is acceptable when all of the following hold:

  • The reviewer opened the governing electronic record and its audit trail, and the review began there.
  • Count, identity, value, time and sequence all reconcile, and every difference was investigated and dispositioned rather than noted.
  • Every critical audit trail entry in the period was identified and its recorded reason was assessed, not merely observed to exist.
  • Every electronic action resolves to a named individual matching the paper signature for the same step.
  • Every signature carries a printed name, a date, and a stated meaning that includes reconciliation and audit trail review.
  • No item is blank. Every NA carries a reason.
  • A different qualified person could repeat this checklist from the record alone and reach the same conclusion.

References

21 CFR 211.68, 211.180, 211.194. 21 CFR Part 11, in particular 11.10, 11.50 (signature manifestations), and 11.70 (signature and record linking, including handwritten signatures executed to electronic records). EU GMP Annex 11 (Computerised Systems) and EU GMP Chapter 4 (Documentation). FDA guidance, Data Integrity and Compliance With Drug CGMP, Questions and Answers (December 2018). MHRA GXP Data Integrity Guidance and Definitions (March 2018). PIC/S PI 041, Good Practices for Data Management and Integrity in Regulated GMP/GDP Environments.

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


Filled specimen

The following shows the checklist completed for an example standalone chromatography workstation with a paper analyst worksheet. Only the items with something to say are reproduced in full; the remainder passed with the evidence noted. Company, names, and numbers are illustrative.

Record identification

FieldEntry
Activity and record identifierAssay by HPLC, finished product, batch A-2274, worksheet WS-4471
Hybrid inventory referenceHYB-001
Declared governing recordElectronic (dynamic chromatographic data with audit trail)
Electronic system and identifiersCDS standalone workstation HPLC-07, sequence SEQ-2607-118, result IDs 4471-01 to 4471-12
Paper form or record number, pagesControlled worksheet CF-QC-114 no. WS-4471, pages 1 to 3 of 3
Activity date and time window12 July 2026 08:14 to 12 July 2026 15:52
Executed byA. Patel
ReviewerT. Nwosu
Review date13 July 2026

Selected item results

#ResultEvidence or comment
A3PassReview started from the CDS sequence and audit trail; worksheet retrieved second.
B1Pass12 electronic injections, 12 worksheet rows.
B2PassCount comprises 2 blanks, 3 standards, 6 sample injections, 1 aborted run.
B3PassInjection 07 aborted on a pressure fault at 11:26; recorded on worksheet page 2 and repeated as injection 08.
B5PassResult IDs run 4471-01 to 4471-12 with no gap.
C2PassNo orphan electronic events.
C4PassSequence name and all twelve result IDs verified character for character against the worksheet.
D1PassSix reported sample results verified against the electronic source during this review.
D2PassValues transcribed to the same significant figures the system reported.
E2PassEach worksheet entry time falls inside the acquisition window for its injection.
E4PassNo clock change in the audit trail for the period.
F1PassAudit trail enabled and continuous 12 July 06:00 to 13 July 06:00.
F3PassOne manual integration on result 4471-09, reason recorded as a shoulder on the trailing edge, integrated to the valley per the method.
F4PassManual integration assessed against the method-defined integration approach; the parameters used are consistent with it. Assessment recorded on worksheet page 3.
F7FailAll twelve acquisitions are attributed inside the CDS to the individual account of A. Patel, which matches the worksheet signature. However, the operating system login is shared across three analysts, so file-level actions outside the application are not attributable. Known gap, logged as HYB-001 gap 1.
H2PassReviewer signature meaning printed on the worksheet includes reconciliation and audit trail review.
H4PassWorksheet carries the sequence name and result IDs on every page.
H6PassExecuted by A. Patel, reviewed by T. Nwosu.

Exception log

Item #What was observedClassificationImmediate actionDeviation referenceNotified to, date
F7Operating system login shared across three analysts on HPLC-07; application-level attribution intactKnown open control gap, not a new eventConfirmed the compensating control is operating: card-access room log CF-QC-009 shows only A. Patel entered the instrument room during the acquisition window. Recorded against HYB-001 gap 1.N/A, tracked as inventory gap with remediation target 31 December 2026M. Haddad (QA), 13 July 2026

Disposition

FieldEntry
Total items applicable37
Pass36
Fail1 (F7, known open gap with an operating compensating control)
NA0
Overall outcomeReconciled with the known gap confirmed under compensating control
Data released for useYes
ReviewerT. Nwosu, signed, 13 July 2026
Signature meaningReviewed the governing electronic record including its audit trail, performed reconciliation per SOP-QA-031, and dispositioned all exceptions.
QA approvalM. Haddad, signed, 14 July 2026

What makes this specimen defensible is not that it is clean, because it is not. The aborted injection is visible on both halves and linked to its repeat. The manual integration carries a reason that the reviewer actually assessed against the method rather than noting that a reason was present. And the one Fail is an honest recording of a known gap, with evidence that the compensating control operated on this specific day, rather than a Pass awarded because the gap is already on a list somewhere. A reviewer who had signed only the worksheet would have seen eleven tidy results and no evidence that a twelfth injection ever existed.

Common inspection findings this checklist prevents

  • The reviewer signed the paper record but cannot demonstrate that the electronic audit trail was ever opened.
  • Aborted, repeated, or reprocessed runs exist electronically and appear nowhere on the paper record.
  • A gap in a printout counter, a result ID series, or worksheet page numbering is present and unexplained.
  • Values were transcribed from the electronic source with no independent verification, and an error changed a reported result.
  • A manual integration or reprocessing carries a reason that nobody evaluated against the method, so the reason exists but the review did not.
  • A correction was made on one half of the record and never propagated to the other.
  • Ink signatures approve electronic records with nothing linking the signature to the specific record it approves.
  • The same person executed and reviewed the work, so the second-person check never happened.
  • Review records are complete and uniformly clean across a period in which the system logged aborted runs, which tells an inspector the review is a formality.

How to adapt this checklist

  1. Set your document number and point the parent SOP field at your real hybrid control procedure.
  2. In section C, replace the generic phrase “machine-generated identifier” with the actual identifier each of your systems produces. Doing this once per system, in the hybrid inventory register, and then citing it here keeps the two documents consistent.
  3. Set the acceptable clock offset in E5 from your time synchronisation procedure rather than picking a number here.
  4. Decide which sections apply to Medium and Low criticality hybrids and state that mapping in the parent SOP, so reviewers are not making that judgement per record.
  5. If your hybrid is a paper batch record dependent on a historian, add items under section B and F that name the specific electronic extracts the reviewer must attach: the trend for the batch window, the alarm and event list, and the operator action log.
  6. If your hybrid is clinical, replace the sample and injection language in sections B and C with subject, visit, and form identifiers, and add an item confirming that the fields designated as direct data capture in the source data agreement were not also recorded on paper.
  7. Print the reviewer signature meaning on the form itself rather than relying on the reviewer to write it, and check that the existing form has room for it.
  8. Confirm every regulation in the references section against the current published version before issue.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.