Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainManufacturing & OperationsCorrective and Preventive Action (CAPA) Log

SpreadsheetManufacturing & OperationsFree

Corrective and Preventive Action (CAPA) Log

Every CAPA from source to verified closure: root cause, action, owner, due date, effectiveness check and overdue flags.

Shown with sample data

Colour

Corrective and Preventive Action (CAPA) Log

Every CAPA from source to verified closure: root cause, action, owner, due date, effectiveness check and overdue flags.

Open CAPAs
4
Overdue
1
Effectiveness checks due
1
Effective first time
50%
Of CAPAs checked
Entries by source
  • Customer complaint2
  • Internal audit1
  • External audit1
  • Nonconformance1
  • Supplier issue1
  • Process data1
  • Risk review1
Share of entries by source
  • Customer complaint225%
  • Internal audit113%
  • External audit113%
  • Nonconformance113%
  • Supplier issue113%
  • Process data113%
  • Other113%

How to use it

  1. 1Open a CAPA for every significant complaint, audit finding, nonconformance trend or risk.
  2. 2Write the problem as a fact (what, where, how many), then the root cause once it is verified.
  3. 3Set an owner and a realistic due date; the status turns Overdue the day after it passes.
  4. 4Type the closed date when the action is complete; an effectiveness check date 90 days later appears.
  5. 5At the check date, look at the data and set Effectiveness to Effective or Not effective.
  6. 6Review overdue and Check due items at every quality meeting.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Auditors judge a quality system by its CAPA log. Record every corrective and preventive action with where it came from, the problem, the verified root cause, the action, owner and due date. The log counts days open, sets an effectiveness check date 90 days after closure and shows each CAPA as Open, Overdue, Verifying, Check due, Closed or Reopened, so nothing is closed on paper without proof it worked.

Who it’s for

  • ISO 9001, ISO 13485 and IATF 16949 systems
  • Customer complaint and audit follow-up
  • Monthly quality management reviews
  • FDA 21 CFR 820 CAPA records

What’s included

  • CAPA log sheet: One row per CAPA.
  • Summary by Source sheet: The number of entries for each source, calculated from the CAPA log sheet.

How to use it

  1. 1Open a CAPA for every significant complaint, audit finding, nonconformance trend or risk.
  2. 2Write the problem as a fact (what, where, how many), then the root cause once it is verified.
  3. 3Set an owner and a realistic due date; the status turns Overdue the day after it passes.
  4. 4Type the closed date when the action is complete; an effectiveness check date 90 days later appears.
  5. 5At the check date, look at the data and set Effectiveness to Effective or Not effective.
  6. 6Review overdue and Check due items at every quality meeting.

Tips

  • Closing a CAPA is not the same as fixing the problem: always verify effectiveness with data before calling it Closed.
  • If the root cause says "operator error", ask why again. Retraining alone is rarely an effective corrective action.
  • Change the 90 in the Verify by formula if your procedure uses a different effectiveness window.

Questions

What is the difference between corrective and preventive action?

Corrective action removes the cause of a problem that has happened so it does not recur. Preventive action removes the cause of a potential problem before it happens. ISO 9001:2015 folds prevention into risk-based thinking, but many systems still log both.

How long should a CAPA stay open?

Many companies target 30–90 days to implement, plus an effectiveness check period. Complex CAPAs can take longer but should have interim containment and milestone dates.

What counts as an effectiveness check?

Objective evidence the problem has not recurred: defect rates, complaint counts, audit results or process data over a defined period after the action.

Related searchescapa logcapa trackercorrective action logcorrective and preventive actioniso 9001 corrective actioncapa template excel

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
20 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetManufacturing & OperationsFree

Corrective and Preventive Action (CAPA) Log

Every CAPA from source to verified closure: root cause, action, owner, due date, effectiveness check and overdue flags.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Manufacturing & Operations
Sheets
2
Setup
20 min
Level
Intermediate
Price
Free

Your copy is private to you.

More manufacturing & operations templates

View all
Equipment Maintenance Log3 sheets

Overdue

1

Due in 14 days

3

Maintenance spend

$2,875

ABCD
1EquipmentLocationTypeInterval (days)
2Commercial espresso machineFront counterKitchen90
3Walk-in fridgeKitchenRefrigeration180
4DishwasherKitchenKitchen120
5HVAC unitRoofBuilding180
Assets
SpreadsheetManufacturing & Operations

Equipment Maintenance Log

Preventive maintenance due dates from each asset's service history, with overdue alerts, repair and downtime tracking, and maintenance cost by asset and month.

10 min setupPreview
Weekly Production Schedule3 sheets

Attainment

100%

Yield

99%

Downtime

160

ABCD
1DateLineOrder #Product
2Nov 5Line 1MO-871Sourdough loaf 800g
3Nov 5Line 2MO-872Granola bar 40g
4Nov 5Line 3MO-873Oat cookies 12pk
5Nov 6Line 1MO-874Seeded rolls 6pk
Schedule
SpreadsheetManufacturing & Operations

Weekly Production Schedule

Plan production orders by line, day and shift, then record output, scrap and downtime to see attainment, yield and performance by line and day.

10 min setupPreview
OEE Calculator2 sheets

Average OEE

79%

Availability

90%

Performance

90%

ABCD
1DateLineShiftPlanned minutes
2Nov 3Line 1Day450
3Nov 3Line 1Night450
4Nov 3Line 2Day450
5Nov 3Line 2Night450
Shifts
SpreadsheetManufacturing & Operations

OEE Calculator

Overall Equipment Effectiveness by shift: availability, performance and quality, and where time is lost.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ