GxP Insights

IQ OQ PQ Template in Excel: Structure and Free Guide

How to build a compliant IQ OQ PQ template: the structure of the qualification protocol per EU GMP Annex 15 and PIC/S PI 006-4, minimum contents of Installation, Operational and Performance Qualification, and the most common audit pitfalls.

G GuideGxP 4 min read
✓ Official sources and references ✓ Practical approach ✓ For pharmaceutical professionals
GUIDEGXP · PRACTICAL GMP INSIGHTS
Illustrazione editoriale GuideGxP a colori sul tema GMP: template IQ OQ PQ e protocollo di qualifica delle apparecchiature.

A well-built IQ OQ PQ template is the difference between a qualification package that defends itself in an audit and a stack of signatures that proves nothing. The qualification protocol is the document that demonstrates your equipment, facilities and utilities are installed, operate and perform as intended: if the template is weak, every execution inherits its gaps. In this article we look at how to structure Installation, Operational and Performance Qualification templates in Excel and Word according to EU GMP Annex 15 and the PIC/S recommendations, which minimum contents to include section by section, and the most frequent errors to eliminate before an inspector finds them.

IQ OQ PQ template: what Annex 15 requires

The regulatory reference for qualification templates in Europe is Annex 15 "Qualification and Validation" of EudraLex Volume 4, in operation since 1 October 2015. Section 3 describes the qualification stages for equipment, facilities, utilities and systems: URS, Design Qualification, FAT/SAT where applicable, and then IQ, OQ and PQ. A good template must mirror this cascade logic: each verification in a later stage assumes the previous one is closed or that open deviations have been formally assessed.

From 1 October 2026, PIC/S PI 006-4 also enters into force — the revision of the PIC/S recommendations on qualification and validation (published on 30 July 2026), consolidating the previous recommendations on Validation Master Plan, IQ/OQ, non-sterile process validation and cleaning validation. If your templates still reference PI 006-3, this is the right moment to update them, together with your VMP references.

Whatever the format, every protocol must contain: purpose and scope, references (URS, drawings, P&IDs, supplier manuals), responsibilities, prerequisites, the list of checks with predefined acceptance criteria, deviation handling, and a closing section with outcome and approvals. Acceptance criteria must be defined before execution and approved by QA: a template with open fields like "result acceptable yes/no" and no explicit criterion is the first observation an auditor writes down.

IQ: structuring the Installation Qualification protocol

The IQ documents that the system is installed correctly against specifications and drawings. According to Annex 15, the IQ template should include as a minimum:

  • verification of the correct installation of components, instrumentation, equipment, pipework and services against engineering drawings and specifications;
  • verification of the installation against pre-defined criteria;
  • collection and collation of supplier operating and maintenance instructions;
  • calibration requirements for instrumentation;
  • verification of materials of construction (especially critical for product-contact parts).

For each item, the template should provide a row with: expected documentary reference, value/condition found, acceptance criterion, result, signature and date of both the performer and the verifier. Evidence (material certificates, calibration certificates, data sheets) should be referenced as numbered attachments, not "available upon request".

If you work in QA, validation or engineering, every week in The Pragmatic GMP we break down a topic like this one — templates, checklists and regulatory updates explained in operational terms. Subscribing is free.

OQ: testing at operating limits and worst case

The OQ demonstrates that the system operates as designed across the operating range. Annex 15 requires tests developed from knowledge of processes, systems and equipment, including conditions at the upper and lower operating limits and/or "worst case" conditions. The OQ template must therefore link every test to a URS or DQ requirement: a requirement-to-test traceability matrix is the cleanest way to demonstrate it.

At OQ completion, remember that Annex 15 ties the closure of this stage to the finalisation of operating and cleaning procedures, operator training and preventative maintenance requirements: the template should list them as prerequisites for release to the next stage, so the closing checklist does not depend on the executor's memory.

PQ: performance under real conditions

The PQ verifies performance under normal operating conditions, using production materials, qualified substitutes or simulated product with demonstrated equivalent behaviour, including worst case batch sizes where relevant. Tests must cover the operating range of the intended process. The PQ template should predefine sampling, frequencies and statistical evaluation criteria, plus a documented justification for any simulants used instead of product.

Minimum template contents: comparison table

StageObjectiveTypical checksEvidence to attach
IQInstallation conforms to specifications and drawingsComponents, instrumentation, pipework, utilities, materials of constructionAs-built drawings, material certificates, calibration certificates, supplier manuals
OQOperation as designed across the operating rangeTests at upper/lower limits, worst case, alarms and interlocksTest reports, URS-to-test traceability matrix, deviations and assessments
PQConsistent performance under normal operating conditionsRuns with product or qualified simulant, worst case batch sizes, defined samplingSampling plans, analytical results, simulant justification

Excel or Word? Managing qualification templates

The question always comes up: is a Word or an Excel template better? In practice, both coexist. Word works well for the body of the protocol (purpose, responsibilities, prerequisites, deviation handling, approvals), while Excel is more efficient for IQ verification matrices and OQ test/criterion/result tables, especially on systems with hundreds of items. Two rules apply to both: the template is a controlled document of the quality system, with a code, version and approval cycle; and once printed or executed, completion follows good documentation practices (traceable corrections, no cells locked on pre-filled "pass" values). If the protocol is executed electronically, the system managing it falls under Annex 11 requirements and must itself be validated.

The most common errors in IQ OQ PQ templates

The same defects keep coming up in audits: generic, unmeasurable acceptance criteria ("operates correctly"); templates photocopied from the supplier with no link to the company URS; no structured section for deviations and discrepancies, which end up in emails; execution and verification signed by the same person; attachments cited but untraceable; and protocols approved after execution has already started. Every one of these points is prevented upstream, in the template, without relying on the diligence of the individual executor.

GuideGxP recommendation

Before writing a template from scratch, start from the regulatory framework: re-read Section 3 of Annex 15, map the minimum contents listed above and build a URS → DQ → IQ/OQ/PQ matrix that makes traceability self-evident. Approve templates as controlled documents, define acceptance criteria with QA before execution, and plan the update of your references to PI 006-4 now. For a complete path through qualification, validation and batch release, our Operational Guide to GMP Annexes 1, 15, 16 and 20 includes a requirement-by-requirement analysis of Annex 15 with best practices and ready-to-use toolkits.

Official sources

THE PRAGMATIC GMP · EVERY MONDAY

The GMP topics that matter, in 7 minutes.

One GMP topic, one real-world example and one practical action, based on official sources and inspection trends.
Discover The Pragmatic GMP