# CAPA Log and Tracker Worksheet

> Source: https://netray.co/tools/capa-log-tracker-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable CAPA register with target days, days open and overdue days calculated for each row, exportable to Excel.

## Category

quality

## Audience

- Quality manager
- Quality engineer
- Management representative

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### CAPA no.

**Key:** capa

**Type:** text

#### Date opened

**Key:** opened

**Type:** date

#### Source

**Key:** source

**Type:** select

**Options:**

- Customer complaint
- Internal audit
- Supplier
- NCR trend
- Process
- Management review

#### Severity

**Key:** severity

**Type:** select

**Options:**

- Low
- Medium
- High
- Critical

#### Owner

**Key:** owner

**Type:** text

#### Status

**Key:** status

**Type:** select

**Options:**

- Open
- Root cause
- Action in progress
- Effectiveness check
- Closed

#### Target days to close

**Key:** target

**Type:** number

**Unit:** days

**Help:** Days allowed from opening to closure under your procedure.

#### Days open

**Key:** open_days

**Type:** number

**Unit:** days

**Help:** Enter the days since opening, or the total days if closed.

#### Days overdue

**Key:** overdue

**Type:** number

**Expr:** max(open_days - target, 0)

**Format:** integer

**Unit:** days

#### Late (1 = yes)

**Key:** late_flag

**Type:** number

**Expr:** if(gt(open_days, target), 1, 0)

**Format:** integer

**Rows:**

**Capa:** CAPA-2026-011

**Opened:** 2026-06-03

**Source:** Customer complaint

**Severity:** High

**Owner:** R. Nakamura

**Status:** Effectiveness check

**Target:** 90

**Open days:** 139

**Capa:** CAPA-2026-014

**Opened:** 2026-07-21

**Source:** NCR trend

**Severity:** Medium

**Owner:** T. Okafor

**Status:** Action in progress

**Target:** 120

**Open days:** 91

**Capa:** CAPA-2026-016

**Opened:** 2026-08-12

**Source:** Supplier

**Severity:** High

**Owner:** J. Alvarez

**Status:** Root cause

**Target:** 60

**Open days:** 69

**Capa:** CAPA-2026-018

**Opened:** 2026-09-02

**Source:** Internal audit

**Severity:** Low

**Owner:** S. Chen

**Status:** Open

**Target:** 180

**Open days:** 48

**Capa:** CAPA-2026-019

**Opened:** 2026-10-20

**Source:** NCR trend

**Severity:** Medium

**Owner:** R. Nakamura

**Status:** Open

**Target:** 120

**Open days:** 0

**Totals:**

#### CAPAs listed

**Key:** capa

**Agg:** count

**Format:** integer

#### Total overdue days

**Key:** overdue

**Agg:** sum

**Format:** integer

#### CAPAs past target

**Key:** late_flag

**Agg:** sum

**Format:** integer

#### Average days open

**Key:** open_days

**Agg:** avg

**Format:** decimal

**Summary:**

#### Share of CAPAs past target

**Key:** late_pct

**Expr:** sum_late_flag / count * 100

**Format:** percent

**Primary:** true

**Description:** Late CAPAs divided by CAPAs listed.

#### Average overdue days per late CAPA

**Key:** avg_overdue

**Expr:** sum_overdue / max(sum_late_flag, 1)

**Format:** decimal

**Notes:** Enter days open as a number so the sheet works offline. In Excel you can replace it with TODAY() minus the opened date after export. Filter closed items out for an open CAPA report.

## Content

**Intro:** A CAPA log is the control panel of a corrective action system. This worksheet keeps each CAPA with source, severity, owner and status, and calculates days overdue so late items stand out. Edit rows, add your own, and export to Excel for management review.

**Sections:**

#### How to use the CAPA log

**Body:** Enter one row per CAPA with its number, opening date, source, severity and owner. Set the target days according to your procedure, for example shorter for high severity and longer for low. Update days open when you review the log, weekly or monthly. The sheet calculates days overdue and flags late items, then summarises the share past target and the average lateness. Sort by overdue days to run your review meeting, and export a copy for the management review pack.

**Bullets:**

- One row per CAPA, one owner per row.
- Set target days by severity.
- Update days open at each review.
- Sort by overdue days before the meeting.

#### Metrics worth tracking

**Body:** Beyond overdue items, useful CAPA measures include average days to close, number opened by source, repeat CAPAs on the same cause, and the percentage verified as effective at first review. A rising count from one source, such as supplier issues, points to a systemic problem. A high reopen rate suggests weak root cause work. Track the age profile too: a few very old CAPAs usually indicate unclear ownership or actions waiting on resources, which management should resolve.

#### Common mistakes

**Body:** Logs often fail because no one owns updating them, so dates are stale. Others mix actions and CAPAs, creating hundreds of rows with little meaning. Another trap is moving the target date whenever an item is late, which hides the problem. Keep the original target and record revisions separately with a reason. Finally, do not close a CAPA at action completion. Add a status for effectiveness check, as in this worksheet, so closure reflects evidence rather than activity.

**Cta:** If your CAPA data should come from ERP quality events rather than manual entry, we can help automate the feed and the overdue report.

**Faq:**

#### What should a CAPA log include?

**Answer:** At minimum: number, date opened, source, description, severity or risk, owner, target and actual dates, status, linked NCRs or complaints, and effectiveness result. This worksheet covers the core columns and calculates overdue days.

#### How often should the CAPA log be reviewed?

**Answer:** Weekly at the quality team level and monthly or quarterly in management review is common. High severity items deserve closer attention. The review frequency should be written into your CAPA procedure.

#### Can I use this as a corrective action log for audits?

**Answer:** Yes as a register, but auditors will also want the underlying CAPA records, root cause evidence and effectiveness checks. Use the log as the index and keep each full record linked by CAPA number.

#### How do I calculate days open automatically?

**Answer:** After exporting to Excel, set days open to TODAY() minus the opened date for open items, and closed date minus opened date for closed ones. The overdue columns will update when you reopen the file.

## Search terms

capa log template, capa tracker excel, capa register template, capa log excel, corrective action log, capa tracking spreadsheet, capa metrics, open capa report

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json