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

A look at the sheets

DASHBOARD

5 WHYS & FISHBONE

NCR REPORT

TRENDS
One NCR, start to finish
| Stage | Tab |
|---|---|
| Raise: date, source, severity, process and category | NCR REGISTER |
| Analyse: problem statement and 5 Whys | ROOT CAUSE |
| Act: correction, corrective and preventive actions | CAPA LOG |
| Cost: scrap, rework and other costs | COST 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