Manufacturing · engineering · service companies

Non-conformance report and CAPA register in Excel

Raising an NCR is easy; closing it properly takes a root cause, actions with owners and a check that they worked. The register holds the whole chain for up to 500 non-conformances and puts a cost on each one, so the biggest problems stand out.

  • 500 NCRs with source and severity
  • 5 Whys and fishbone worksheet
  • 1,000 corrections and CAPA actions
  • Cost of poor quality per NCR
Add to basket
NCR & CAPA Register – Dashboard

A look at the sheets

One NCR, start to finish

StageTab
Raise: date, source, severity, process and categoryNCR REGISTER
Analyse: problem statement and 5 WhysROOT CAUSE
Act: correction, corrective and preventive actionsCAPA LOG
Cost: scrap, rework and other costsCOST OF POOR QUALITY

NCR and CAPA prefixes, the labour rate and warning windows are set in SETTINGS.

10sheets
500NCRs · 1,000 actions
0macros

Where the trouble is

TRENDS shows Pareto charts by category and by root cause and the month-by-month trend. COST OF POOR QUALITY uses a parts list of up to 40 items to value scrap, so the cost of each NCR is based on real figures.

Printable for the customer or the audit

NCR REPORT fills in an A4 report for any NCR. 5 WHYS & FISHBONE prints a root cause worksheet for the team meeting, with the problem statement at the top.

Questions and answers

What is the difference between correction and corrective action?
A correction deals with the faulty product itself. A corrective action removes the cause so it does not happen again. A preventive action deals with a potential problem before it occurs.
Does it follow ISO 9001?
It supports the requirements on nonconforming outputs and corrective action, but the register alone does not make you compliant.
Can several actions belong to one NCR?
Yes. CAPA LOG links each action to its NCR, with owner, due date and status.

The file in numbers

  • START
  • SETTINGS
  • NCR REGISTER
  • ROOT CAUSE
  • CAPA LOG
  • COST OF POOR QUALITY
  • NCR REPORT
  • 5 WHYS & FISHBONE
  • TRENDS
  • DASHBOARD
File format
.xlsx
Tabs
10
Capacity
500 NCRs · 300 analyses · 1,000 actions · 40 parts
Requires
Excel 2016+ / Microsoft 365
Macros
None

Close NCRs with the cause found and fixed

Add the NCR register to your basket and continue to payment.

Add to basket