Audit trail review checklist for Part 11 systems
A working worksheet for one system and one review period: how often to review by risk, the eight event types to read, the findings and what happened to each, and a record the reviewer and a second person sign. It reads § 11.10(e) and FDA's 2018 data integrity Q&A, and says where our practice fills the gap. New to the subject? Start with what an audit trail is.
The tool
Review one system, one period
Pre-filled with a QC lab's September review of its HPLC data system. Change any field, or clear it to a blank worksheet. Your entries stay in this browser only.
Review status
Complete
Reviewed, signed, and checked by a second person. 8 of 8 event types reviewed; 4 findings, 3 sent on to a deviation, CAPA or change control.
Step 1The system and the period
Step 2How often to review
System-level trail review
Monthly
Risk score 5 of 6. Logins, settings and other system events across every record, reviewed on this interval.
- Record-level trail
- With each record, before it is approved. FDA's 2018 Q&A: where the rule sets the review point for the data, apply the same frequency to its audit trail.
The score and the intervals are our practice, not a rule. Part 11 sets no review cadence.
Step 3What to review
01Records created
record level, § 11.10(e)New sequences, sample sets and results in the period. Each one carries a named user and a time stamp.
02Records modified
record level, § 11.10(e); § 211.68(b)Edits to sample IDs, weights, dilutions and results. The old value is still visible, the editor is authorized, and a reason is entered.
03Records deleted
record level, § 11.10(e)Deleted files, injections, results or sequences. Each one needs a documented reason; ask why the role could delete at all.
04Reprocessing and manual integration
record level, 2018 Q&A, Q1.c and Q14Which integration parameters changed, who changed them, the written reason, and that every processed result is kept for review.
05Aborted or incomplete injections
record level, 2018 Q&A, Q12 and Q13Aborted, incomplete or extra injections, and sample injections in test, prep or equilibration runs. Each one is investigated and justified.
06Failed logins and access attempts
system level, 2018 Q&A, Q1.c and Q5Failed and locked-out logins, logins at odd hours, and any generic or shared account used to change data.
07Setting and configuration changes
system level, 2018 Q&A, Q1.c; § 211.68(b)Changes to processing methods, user roles and rights, the audit trail setting itself, and the system clock or time zone.
08Signatures
record level, §§ 11.50, 11.70Each result signed with name, date and time, and meaning, and no result changed after its review or approval signature.
Step 4Findings and outcomes
Finding 1
Finding 2
Finding 3
Finding 4
Step 5Sign-off
Typed names here are a draft. The signature that counts is the one on the printed record or the e-signature in your quality system.
Audit trail review record
- System
- QC HPLC chromatography data system, 3 instruments, 9 users, own server
- Records in scope
- Release and stability assays and related substances run in the period
- Period
- 2026-09-01 to 2026-09-30
- Record-level trail
- With each record, before it is approved
- System-level trail
- Monthly (score 5 of 6: criticality high, controls partial, impact direct; our practice, not a rule)
- Status
- Complete. Reviewed, signed, and checked by a second person.
| Event type | In period | Outcome | Note |
|---|---|---|---|
| Records created§ 11.10(e) | 46 | Nothing to report | 46 sequences, 612 injections, every one under a named user. |
| Records modified§ 11.10(e); § 211.68(b) | 9 | Found, raised | 9 sample-weight edits with reasons; 8 match the balance printout, 1 does not (finding 2). |
| Records deleted§ 11.10(e) | 0 | Nothing to report | Analyst roles cannot delete; no deletions by admins either. |
| Reprocessing and manual integration2018 Q&A, Q1.c and Q14 | 14 | Found, raised | 13 reprocessings cite the integration SOP; 1 manual integration has no reason (finding 1). |
| Aborted or incomplete injections2018 Q&A, Q12 and Q13 | 3 | Found, explained | 2 pump pressure faults in the instrument log, 1 vial not found; each re-injected per SOP. |
| Failed logins and access attempts2018 Q&A, Q1.c and Q5 | 21 | Found, explained | 21 failed logins, each followed by the same user's good login; 1 lockout (finding 4). |
| Setting and configuration changes2018 Q&A, Q1.c; § 211.68(b) | 2 | Found, raised | Related-substances method edited by an analyst who also holds admin rights (finding 3). |
| Signatures§§ 11.50, 11.70 | 46 | Nothing to report | Every result signed by analyst and reviewer; none changed after the review signature. |
Findings (4)
| No. | Event and record | What the trail shows | Outcome |
|---|---|---|---|
| 1 | Reprocessing and manual integrationSeq 0917-03, injection 12, lot 26-0412 | Impurity B manually integrated with no reason entered; result 0.14% against a 0.15% limit. | Deviation raisedDEV-26-118 |
| 2 | Records modifiedSeq 0922-01, sample 4 | Weight changed from 50.12 mg to 50.21 mg; the balance printout reads 50.12 mg. | Deviation raisedDEV-26-121 |
| 3 | Setting and configuration changesProcessing method RS-07, version 3 to 4 | Integration threshold changed outside change control by an analyst holding admin rights. | CAPA raisedCAPA-26-030 |
| 4 | Failed logins and access attemptsUser qc-analyst-3, 2026-09-09 | Locked out twice after a password expiry; reset by IT ticket, no data activity in between. | Explained and closed in the review |
Reviewed by
Meaning: Audit trail reviewed for the period above
Name: J. M.
Role: QC senior analyst
Date: 2026-10-03
Signature:
Second-person check
Meaning: Review checked and approved
Name: S. K.
Role: QA specialist
Date: 2026-10-06
Signature:
GxP Deck audit trail review worksheet. General information, not regulatory advice.
What an audit trail review is
A person reads the system's own record of who created, changed or deleted data, and decides whether each change was authorized, explained and still visible. § 11.10(e) requires the trail itself: “secure, computer-generated, time-stamped audit trails to independently record the date and time of operator entries and actions that create, modify, or delete electronic records”, where “record changes shall not obscure previously recorded information.” It sets no review schedule. That expectation comes from the predicate rules and from FDA's 2018 data integrity Q&A, which says “audit trail review is similar to assessing cross-outs on paper when reviewing data.”
The Q&A splits trails in two: those that track “creation, modification, or deletion of data (such as processing parameters and results)” and those that track “actions at the record or system level (such as attempts to access the system or rename or delete a file).” They get read by different people at different times.
| Trail | What it holds | Who reads it | When |
|---|---|---|---|
| Record level | Changes to the data behind one result: entries, edits, reprocessing, deletions, signatures. | Whoever reviews the record under the predicate rule, as part of that review. | With the record, before it is approved, where a rule sets that point. |
| System level | Actions across records: logins and failed attempts, file renames and deletions, role and setting changes. | Someone who does not generate the data, often QA or the system owner (our practice). | On an interval you set from risk, written in your procedure. |
For what a trail has to capture in the first place, and how long it is kept, read what an audit trail is in GxP. For where § 11.10(e) sits among the other controls, see Part 11 requirements, section by section.
How to use this worksheet
- Step 1The system and the period
- One worksheet per system. The period runs from the last system-level review to today; name the records it covers.
- Step 2How often
- Answer the rule question first, then rate the three risk factors FDA names. The interval is a starting point for your procedure, not a verdict.
- Step 3What to review
- Filter the trail by date and work down the eight event types. Count what you see, pick the outcome word, and say where the evidence is. If a create, modify or delete event is Not trailed, that is a § 11.10(e) gap for the Part 11 compliance checklist, not a review finding.
- Step 4Findings
- Every Found, raised event needs at least one finding, and every finding not closed in the review needs a number from your deviation, CAPA form or change control. The status line will not read Complete until both are true.
- Step 5Sign-off
- Print the record and sign it, or attach it to your quality system and sign there. Check that the e-signature shows name, date and time, and meaning with the signature manifestation check. The written procedure that makes this routine fits in an SOP template of its own.
How often: the rule first, then risk
FDA's 2018 Q&A answers this in two steps. First: “If the review frequency for the data is specified in CGMP regulations, adhere to that frequency for the audit trail review.” For a QC lab that point is the second-person review of § 211.194(a)(8), which wants the initials or signature of a second person “showing that the original records have been reviewed for accuracy, completeness, and compliance with established standards”; for batch records it is the quality unit's review before release under § 211.192.
Second, where no rule sets the point, “determine the review frequency for the audit trail using knowledge of your processes and risk assessment tools,” and the risk assessment “should include evaluation of data criticality, control mechanisms, and impact on product quality.” Its footnote names the risks to data as “the potential to be deleted, amended, or excluded without authorization or without detection,” and gives instrument operational status, instrument communication logs and alert records as trails that may suit a risk-based frequency.
Common misreading
Part 11 does not require audit trail review. § 11.10(e) requires the trail, kept as long as the record and available to FDA; the review comes from the predicate rules and the 2018 guidance. In the EU, Annex 11 § 9 says audit trails should be “regularly reviewed”, set by risk; the Annex 11 vs Part 11 mapping lines the two up.
The worksheet turns the three factors into a score from 0 to 6 and the score into an interval. The bands below are our practice for a small lab, not FDA's; write your own into the procedure and say why.
| Score | System-level trail | Record-level trail, no rule |
|---|---|---|
| 5 to 6 | Monthly | With each record |
| 4 | Quarterly | With each record |
| 3 | Quarterly | A monthly sample |
| 1 to 2 | Every six months | A monthly sample (2) or periodic review (1) |
| 0 | Yearly | At each periodic review |
Criticality, controls and impact each score 0, 1 or 2. Where a rule sets the review point, the record-level trail follows the rule whatever the score.
Whatever you choose, the Q&A sets the test: your approach “should ensure that CGMP requirements are met, appropriate controls are implemented, and the reliability of the review is proven.” A review that always reads Nothing to report on a busy system does not prove much.
Worked example: September on a QC HPLC data system
A QC lab runs release and stability testing on three HPLC instruments feeding one chromatography data system on its own server, with nine users. Two senior analysts also hold admin rights, so controls are partial; the data decides batch release, so criticality is high and impact direct. Score 5 of 6: the system-level trail is reviewed monthly, and the record-level trail with each record, before it is approved, because § 211.194(a)(8) already sets that point for lab records. This is the 2026-09 system-level review.
| Event type | In period | Outcome | What the reviewer wrote |
|---|---|---|---|
| Records created | 46 | Nothing to report | 46 sequences, 612 injections, every one under a named user. |
| Records modified | 9 | Found, raised | 9 sample-weight edits with reasons; 8 match the balance printout, 1 does not (finding 2). |
| Records deleted | 0 | Nothing to report | Analyst roles cannot delete; no deletions by admins either. |
| Reprocessing and manual integration | 14 | Found, raised | 13 reprocessings cite the integration SOP; 1 manual integration has no reason (finding 1). |
| Aborted or incomplete injections | 3 | Found, explained | 2 pump pressure faults in the instrument log, 1 vial not found; each re-injected per SOP. |
| Failed logins and access attempts | 21 | Found, explained | 21 failed logins, each followed by the same user's good login; 1 lockout (finding 4). |
| Setting and configuration changes | 2 | Found, raised | Related-substances method edited by an analyst who also holds admin rights (finding 3). |
| Signatures | 46 | Nothing to report | Every result signed by analyst and reviewer; none changed after the review signature. |
Nothing to report: the events are there and in order. Found, explained: closed in the review with a reason. Found, raised: written up as a finding. Not trailed: the system does not record this event.
| No. | Event and record | What the trail shows | Outcome |
|---|---|---|---|
| 1 | Reprocessing and manual integrationSeq 0917-03, injection 12, lot 26-0412 | Impurity B manually integrated with no reason entered; result 0.14% against a 0.15% limit. | Deviation raisedDEV-26-118 |
| 2 | Records modifiedSeq 0922-01, sample 4 | Weight changed from 50.12 mg to 50.21 mg; the balance printout reads 50.12 mg. | Deviation raisedDEV-26-121 |
| 3 | Setting and configuration changesProcessing method RS-07, version 3 to 4 | Integration threshold changed outside change control by an analyst holding admin rights. | CAPA raisedCAPA-26-030 |
| 4 | Failed logins and access attemptsUser qc-analyst-3, 2026-09-09 | Locked out twice after a password expiry; reset by IT ticket, no data activity in between. | Explained and closed in the review |
Result: Complete. 4 findings, 3 sent on. Finding 1 matters most: a manual integration with no reason, on an impurity just under its limit. FDA's 2018 Q&A says that for most lab analyses reprocessing “should not be regularly needed”, and that when chromatography is reprocessed, written procedures must be followed and each result kept for review. Finding 3 is the cheapest to fix for good: take admin rights away from the people who generate the data.
What a chromatography reviewer looks for
FDA's audit trail definition uses an HPLC run as its example: the trail “should include the user name, date/time of the run, the integration parameters used, and details of a reprocessing, if any,” and “documentation should include change justification for the reprocessing.” These are the patterns worth stopping on.
- Q&A, Q14Reprocessing with no reason, or one injection processed several times until the result moves. Every processed result has to be kept for review, not only the last.
- Q&A, Q12Aborted or incomplete injections nobody looked into. FDA says they "should be captured in audit trails and should be investigated and justified."
- Q&A, Q13Actual samples injected in test, prep or equilibration runs, or used for system suitability outside a written procedure. FDA calls the first, used to disguise testing into compliance, a violative practice.
- §§ 11.10(e), 11.70A result edited after it was signed, or a signature that sits on a version older than the result it approves.
- Q&A, Q5Changes made under a shared or generic login. A shared read-only account is fine for viewing; it cannot carry a change or a second-person review.
- Q&A, Q1.c; § 11.10(e)The trail switched off, the system clock moved, or files renamed and deleted at the system level, outside the application's own record.
Inspection risk
“All data—including obvious errors and failing, passing, and suspect data—must be in the CGMP records that are retained and subject to review and oversight.” A trail that shows a failing injection quietly replaced by a passing one is exactly what that sentence rules out.
If your data system cannot filter its trail by event type or show reprocessing side by side, the review gets slow and patchy; see how chromatography data systems compare on audit trails. To test one record against all of ALCOA at once, use the ALCOA+ record check.
Where the rule says so
The rule text and guidance this worksheet is built from, each read on the date shown.
- 21 CFR Part 11, Electronic Records; Electronic Signatures (eCFR), National Archives and FDAread 2026-10-22
- Data Integrity and Compliance With Drug CGMP: Questions and Answers (guidance, December 2018), FDAread 2026-10-22
- 21 CFR Part 211, CGMP for Finished Pharmaceuticals (eCFR), National Archives and FDAread 2026-10-22
- EudraLex Volume 4, Annex 11: Computerised Systems (2011), European Commissionread 2026-10-22