# GMP SOP Periodic Review Tracker Worksheet > Source: https://netray.co/tools/gmp-sop-periodic-review-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An SOP register with owner, review interval, days since last review and an overdue flag, ready to export to Excel. ## Category compliance-legal ## Industry Pharmaceutical ## Audience - QA document control - Quality manager - Department head ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### SOP number **Key:** sop **Type:** text #### Title **Key:** title **Type:** text #### Owner **Key:** owner **Type:** text #### Department **Key:** dept **Type:** select **Options:** - Production - QC - QA - Engineering - Warehouse - Microbiology - Regulatory #### Review interval (days) **Key:** interval **Type:** number #### Days since last review **Key:** since **Type:** number #### Days remaining **Key:** remaining **Type:** number **Expr:** interval - since **Format:** integer #### Overdue (1 = yes) **Key:** overdue **Type:** number **Expr:** if(lt(interval - since,0),1,0) **Format:** integer #### Next review due **Key:** next **Type:** date **Rows:** #### Deviation handling **Sop:** QA-014 **Owner:** Head of QA **Dept:** QA **Interval:** 730 **Since:** 410 **Next:** 2027-08-25 #### Line clearance **Sop:** PR-102 **Owner:** Production manager **Dept:** Production **Interval:** 730 **Since:** 780 **Next:** 2026-09-01 #### Balance calibration check **Sop:** QC-231 **Owner:** QC lead **Dept:** QC **Interval:** 365 **Since:** 120 **Next:** 2027-06-20 #### Quarantine and release of materials **Sop:** WH-007 **Owner:** Warehouse manager **Dept:** Warehouse **Interval:** 730 **Since:** 300 **Next:** 2028-01-10 #### Preventive maintenance of autoclave **Sop:** EN-045 **Owner:** Engineering lead **Dept:** Engineering **Interval:** 365 **Since:** 400 **Next:** 2026-08-15 **Totals:** #### Overdue SOPs **Key:** overdue **Agg:** sum **Format:** integer #### SOPs in register **Key:** sop **Agg:** count **Format:** integer **Summary:** #### Percent overdue **Key:** overdue_pct **Expr:** if(gt(count,0),sum_overdue/count*100,0) **Format:** percent **Primary:** true **Notes:** Review intervals are set by your quality system, often one to three years depending on risk. Update days since last review each time you open the file, or replace it with the review date and calculate in Excel. ## Content **Intro:** Overdue SOPs are a common audit finding because nobody owns the calendar. This tracker gives document control a single list showing the interval, how long since each review and which SOPs are late. **Sections:** #### How to use the tracker **Body:** List every effective SOP with its owner and department. Enter the review interval from your document control SOP and the days since the last review or approval. The sheet shows days remaining and flags overdue lines, plus the percentage overdue in the summary. Export to Excel and send the overdue list to each owner at the start of the month. Add the date of the next review as a plain text reference. **Bullets:** - Use one row per controlled SOP version, not per file - Add a column in Excel for the change control number if the review leads to revision #### What the rules say **Body:** GMP regulations do not fix one interval. EU GMP Chapter 4 expects documents to be regularly reviewed and kept up to date, and 21 CFR 211.100 requires written procedures to be reviewed and approved by the quality control unit. Your interval is a risk based choice that you document. Critical procedures, such as aseptic processing or deviation handling, are often reviewed more often than general housekeeping SOPs. #### Common mistakes **Body:** Teams often extend the review date by email without a record, or treat a review as done when the owner simply signs without reading. A periodic review should confirm the SOP matches current practice, regulations and any linked changes since the last review. If no change is needed, record that conclusion and keep evidence. Do not let reviews bunch up; spread the due dates over the year. **Bullets:** - Do not allow silent extensions - Review the SOP against deviations raised since the last review - Check the referenced forms and annexes still exist **Cta:** If your document control lives in SharePoint, an ERP module or a DMS and you want automatic reminders and overdue dashboards, Netray can build it around your existing system. **Faq:** #### How often should SOPs be reviewed? **Answer:** There is no universal figure. Two years is common for routine procedures and one year for critical or high risk ones. Define it in your document control SOP and be able to justify the choice during an inspection. #### Is an overdue SOP a deviation? **Answer:** Many sites treat it as a quality system event or a deviation, especially when it is critical. At minimum it needs an owner, a new due date and a reason. Follow your own procedure for classification. #### Can I use the same tracker for forms and work instructions? **Answer:** Yes, as long as each controlled document is listed. Add a type column in your Excel copy if you want to filter forms, work instructions and SOPs separately. #### What counts as a periodic review? **Answer:** A documented confirmation that the content is still accurate, complies with current regulations and matches actual practice. Where changes are needed, it should trigger a change control and a new revision. ## Search terms sop review tracker excel, sop periodic review schedule, document control register template, gmp sop master list, sop review due date tracker, sop review log format, quality document register --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json