# Nonconformance Log and Pareto Worksheet (Excel Export)

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

## Short answer

Log nonconformances by defect code with quantity, unit cost and cost of the event, then total them to see which codes drive the loss.

## Category

quality

## Industry

Discrete Manufacturing

## Audience

- Quality manager
- Quality engineer
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### NCR no

**Key:** ncr

**Type:** text

#### Date found

**Key:** date

**Type:** date

#### Part number

**Key:** part

**Type:** text

#### Defect code

**Key:** code

**Type:** select

**Options:**

- Dimensional
- Surface finish
- Material
- Assembly
- Documentation
- Packaging
- Other

#### Found at

**Key:** area

**Type:** select

**Options:**

- Receiving
- In process
- Final inspection
- Customer

#### Qty affected

**Key:** qty

**Type:** number

#### Unit cost

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Rework hours

**Key:** rework_hr

**Type:** number

**Unit:** h

#### Labor rate per hour

**Key:** hr_rate

**Type:** number

**Format:** currency

#### Event cost

**Key:** loss

**Type:** number

**Expr:** qty * unit_cost + rework_hr * hr_rate

**Format:** currency

**Help:** Scrap value plus rework labor. Add other costs in the notes.

**Rows:**

**Ncr:** NCR-0412

**Date:** 2026-10-02

**Part:** BRK-4410

**Code:** Dimensional

**Area:** Final inspection

**Qty:** 18

**Unit cost:** 22.5

**Rework hr:** 4

**Hr rate:** 38

**Ncr:** NCR-0413

**Date:** 2026-10-05

**Part:** HSG-7720

**Code:** Surface finish

**Area:** In process

**Qty:** 40

**Unit cost:** 14.2

**Rework hr:** 10

**Hr rate:** 38

**Ncr:** NCR-0414

**Date:** 2026-10-07

**Part:** SFT-2210

**Code:** Material

**Area:** Receiving

**Qty:** 60

**Unit cost:** 9.8

**Rework hr:** 0

**Hr rate:** 38

**Ncr:** NCR-0415

**Date:** 2026-10-12

**Part:** BRK-4410

**Code:** Dimensional

**Area:** Customer

**Qty:** 6

**Unit cost:** 22.5

**Rework hr:** 8

**Hr rate:** 38

**Ncr:** NCR-0416

**Date:** 2026-10-15

**Part:** ASM-9005

**Code:** Assembly

**Area:** In process

**Qty:** 12

**Unit cost:** 61

**Rework hr:** 6

**Hr rate:** 38

**Ncr:** NCR-0417

**Date:** 2026-10-19

**Part:** HSG-7720

**Code:** Documentation

**Area:** Final inspection

**Qty:** 0

**Unit cost:** 0

**Rework hr:** 3

**Hr rate:** 38

**Totals:**

#### Total pieces affected

**Key:** qty

**Agg:** sum

**Format:** integer

#### Total rework hours

**Key:** rework_hr

**Agg:** sum

**Format:** number

#### Total event cost

**Key:** loss

**Agg:** sum

**Format:** currency

#### Largest single event

**Key:** loss

**Agg:** max

**Format:** currency

**Summary:**

#### Average cost per NCR

**Key:** avg_event

**Expr:** sum_loss / count

**Format:** currency

**Primary:** true

#### Rework labor per NCR

**Key:** rework_share

**Expr:** sum_rework_hr / count

**Format:** number

**Notes:** To build the Pareto, export to Excel, sort by Defect code, sum the event cost for each code with a pivot table, sort descending and add a cumulative percent column. The codes that reach about 80% of the cost are your vital few.

## Content

**Intro:** Most plants keep a nonconformance log in Excel and then spend an afternoon building a Pareto from it. This worksheet gives you the log with cost per event already calculated, so you can see which defect codes are costing the most.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per NCR. Pick a defect code from the list, record where the problem was found, then enter the quantity, unit cost, rework hours and labor rate. The event cost column multiplies quantity by unit cost and adds rework hours times the rate, so every row shows its own loss. Totals and the average cost per NCR update as you edit. Replace the sample rows with your own, add more rows as the month goes on, and export to Excel or CSV when you want to pivot or share the data.

**Bullets:**

- One row per NCR, not per piece
- Use a short fixed list of defect codes
- Record where the defect was found
- Count rework hours as well as scrap value

#### Why rank by cost, not count

**Body:** A Pareto by count shows which defects are frequent, but a rare defect on an expensive assembly can cost more than a hundred cosmetic marks. Ranking by event cost points the corrective action effort where the money is. The usual rule says about 80% of the loss comes from about 20% of the causes, though the real ratio varies. Run the Pareto by defect code first, then by part number, then by where the defect was found, to see whether the problem is a process, a product or a supplier.

#### Worked example

**Body:** In the sample rows, dimensional defects on BRK-4410 appear twice and include a customer-found event, with 24 pieces and 12 rework hours in total. Priced at unit cost plus labor, that code dominates the month. A pivot of event cost by code would put Dimensional first, which tells the quality team to open a corrective action on the boring process rather than spreading effort over every code.

#### Common mistakes

**Body:** Teams often use free-text defect descriptions, so the same fault appears under five names and the Pareto splits it. Another mistake is omitting customer-found events or hours spent on investigation, which hides the true cost. Finally, a log kept separately from the ERP drifts out of date. If your ERP records rejections by reason code, export those and compare them with the log each month, since the quantity and cost fields usually exist already.

**Cta:** If your NCR data lives in the ERP, Netray can build a read-only Pareto report from rejection reason codes and costs, refreshed daily.

**Faq:**

#### How many defect codes should I use?

**Answer:** Between 8 and 15 is practical. Too few hides patterns, and too many splits the same fault across codes. Review the list yearly and keep an Other code that you check regularly.

#### How do I build a Pareto chart from this log?

**Answer:** Export to Excel, make a pivot table with defect code as rows and event cost as values, sort descending and add a cumulative percent column. Plot costs as bars and the cumulative percent as a line.

#### Should the log include internal scrap and customer returns?

**Answer:** Yes, both, with the found-at column telling them apart. Customer-found events carry extra cost such as freight, sorting and credit notes, which you can add to the rework hours or notes.

#### How often should I review the log?

**Answer:** Weekly for open items and monthly for the Pareto. A monthly review that feeds the management review under ISO 9001 or AS9100 is common practice.

## Search terms

nonconformance log excel, NCR log template, nonconformance register template, defect pareto worksheet, pareto analysis excel quality, nonconformance tracking spreadsheet, quality defect log template, NCR tracking log

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