Worldover, AI operating system for substance-based businesses

    Free Excel template

    CAPA template for cosmetics and chemical manufacturers

    A free Excel CAPA log and form for corrective and preventive actions. Track every issue from complaint or deviation to root cause, action and effectiveness check, in a format auditors expect.

    Free download

    Download the CAPA template

    Excel file with a CAPA log, single-issue CAPA form, automatic summary and instructions.

    Looking for software for this? See Worldover's chemical QMS software and cosmetic QMS software.

    What's in the template

    How to use it

    1. Log the issue the day it's raised, with the batch or lot affected.
    2. Contain first: quarantine or hold affected stock before investigating.
    3. Find the root cause with 5 Whys or a fishbone and record the evidence.
    4. Separate the corrective action (fix this) from the preventive action (stop it recurring).
    5. Only close once the effectiveness check shows it worked.

    Where the spreadsheet stops

    A spreadsheet can't link a CAPA to the batch record, complaint, supplier or SOP behind it. Worldover's QMS does, with owners, reminders and an approval trail on the same record as production.

    Questions

    What is a CAPA?

    Corrective and preventive action. A corrective action fixes the cause of a problem that has happened. A preventive action stops a similar problem happening elsewhere.

    What should a CAPA form include?

    The problem, affected products and batches, containment, risk assessment, root cause investigation, corrective and preventive actions, owner, due date, effectiveness check, documents updated and QA approval.

    Is CAPA required under ISO 22716?

    ISO 22716 expects deviations and complaints to be investigated and corrective actions taken. A CAPA log is the usual way to show that. Check your own certification requirements.

    When should a CAPA move out of a spreadsheet?

    When evidence sits in email, CAPAs aren't linked to the batch records or suppliers they affect, or reminders depend on one person remembering.