Quality Control
As needed
Nonconformance Report Log (Free Excel Template)
A nonconformance report log that keeps every NCR for a month on one sheet, from the date a problem was found to the check that the fix worked. The defect rate is calculated for you, and a row stays open until the effectiveness check is filled in.
Excel (.xlsx) · 4 sheets · Updated 2026-10-21
Enter your company name, name, and business email, and we will email you the download link.
Who is this nonconformance report log for?
- Quality managers who track nonconforming product and corrective actions
- Production supervisors who need to see open NCRs and who owns them
- Small manufacturers that want a simple NCR and CAPA log before buying quality software
When to use it
Add a row each time a nonconforming part or lot is found, at incoming inspection, in process, at final inspection, or from a customer complaint. Use one sheet per month, and review the open rows at your monthly quality meeting.
What's included
The template includes the following. Delete anything you do not need.
- Header for site, who keeps the log, and period
- NCR number, date found, where found, part name and number, lot
- Description of the nonconformance, qty nonconforming, qty inspected, and an automatic defect rate
- Probable root cause and containment (interim action)
- Disposition drop-down: use as is, rework, repair, scrap, return to vendor
- Corrective action, completion date, effectiveness check, and owner
- Rules for handling nonconforming parts on the Instructions sheet, and a sign-off block
- A filled-in sample sheet and a print layout for US Letter
Preview the Excel file
This is the actual file. Use the tabs below to switch between the 4 sheets. How to mark each result is explained on the "Instructions" sheet.
| A | |
|---|---|
| 1 | Nonconformance Report Log (NCR and Corrective Action) |
| 2 | |
| 3 | ■ Source |
| 4 | Worker Library https://worker-library.com/templates/nonconformance-report-log/ |
| 5 | Request a template or an extra item: https://worker-library.com/contact/ |
| 6 | |
| 7 | ■ Sheets in this workbook |
| 8 | "Entry Sheet" … The sheet you fill in on a computer. Landscape layout. |
| 9 | "Sample (Filled In)" … A filled-in example. Use it as a guide to how each column is written. |
| 10 | "Print (Letter)" … For printing and filling in by hand. Taller rows, and the column headings repeat at the top of every page. Set up for US Letter. |
| 11 | |
| 12 | ■ How to use |
| 13 | 1. Fill in the site, who keeps the log, and the period at the top. |
| 14 | 2. When a nonconformance is found, tag and hold the parts, then add a row with the next NCR number, the date, where it was found, and what was found. |
| 15 | 3. Enter the qty nonconforming and qty inspected. The defect rate fills in by itself. |
| 16 | 4. Write the containment and the disposition. Then find the root cause and write the corrective action with an owner and a due date. |
| 17 | 5. After the action, check that the problem did not come back and write the date and result. Only then is the row closed. |
| 18 | |
| 19 | ■ What to do when you find a nonconforming part (read before you start) |
| 20 | When you find it, do not move it on. Put a red "Hold / Nonconforming" tag on it, move it to the hold area, and do not release it until the disposition is decided. |
| 21 | Tell the next process and shipping right away. Report first, write second. Parts can move on while you are still writing. |
| 22 | Containment means stopping bad parts from getting out. It is a stopgap until the corrective action is in place, so write a due date. |
| 23 | A row with a blank effectiveness check is not closed. Once a month, review only the rows with blanks. |
| 24 | |
| 25 | ■ Adapting it to your site |
| 26 | • Add a column for a CAPA number if corrective actions are tracked in a separate system. |
| 27 | • Add a column for cost (scrap, rework hours) if you report the cost of poor quality. |
| 28 | • Add a "Source" drop-down (incoming, in-process, final, customer) to sort the log by where problems are found. |
| 29 | |
| 30 | ■ Things to watch |
| 31 | • This is a general nonconformance log template. It is not a form from any customer, standards body, or agency. |
| 32 | • How you handle and record nonconforming product depends on your quality system (for example ISO 9001 if you are certified) and your customer's quality requirements. |
| 33 | • A "Use as is" disposition accepts parts outside the spec. Get approval from the person allowed to sign it, and from the customer if they require it. |
| 34 | • Do not close a row when the action is done. Close it when the effectiveness check shows the problem did not come back. |
| 35 | |
| 36 | ■ About this template |
| 37 | A free inspection template from Worker Library. |
| 38 | You may copy, edit, and print it for use in your own organization. Add or delete items as you need. |
| 39 | Please do not redistribute or sell the template itself. |
| 40 | |
| 41 | ■ Important notice |
| 42 | This template organizes common inspection items for reference. It is not an official form issued by OSHA or any other authority, and using it does not by itself show compliance. |
| 43 | Which inspections are required, how often, and how long records must be kept depend on the equipment, industry, size of the operation, and location (federal, state, and local rules can all apply). |
| 44 | Check the regulations and standards that apply to you, the manufacturer's instructions, and a qualified or competent person. |
| 45 | Worker Library accepts no liability for any loss arising from the use of this template. |
| 46 | Regulations change. Check the source page above for the latest version. |
| 47 | |
| 48 | ■ Updated |
| 49 | 2026-10-21 (reviewed every 3 months) |
| 50 | |
| 51 | ■ About Worker Library |
| 52 | Worker Library publishes free Excel inspection checklists, logs, and forms for maintenance, safety, and quality teams. |
| 53 | All templates: https://worker-library.com/templates/ |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Nonconformance Report Log (NCR and Corrective Action) | |||||
| 2 | Site | Log kept by | ||||
| 3 | ||||||
| 4 | NCR number | Date found | Where found (process / machine) | Part name / number | Lot | Nonconformance (what was found) |
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | (17 more blank rows) | |||||
| 10 | Inspected by | |||||
| 11 | ||||||
| 12 | ||||||
| 13 | Notice: This is a general-purpose inspection record. It is not an official government form and does not by itself show compliance with OSHA or any other regulation or standard. | |||||
| 14 | Which inspections you need, how often, and how long to keep records depend on your equipment, industry, and location. Check the regulations that apply to you, the manufacturer's instructions, and a qualified person. | |||||
| 15 | Worker Library accepts no liability for any loss arising from the use of this template. Regulations change; check the source page for the latest version. | |||||
| 16 | Worker Library https://worker-library.com/templates/nonconformance-report-log/ Updated 2026-10-21 | |||||
This preview shows the first 6 of 16 columns. The downloaded file contains everything.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Nonconformance Report Log (NCR and Corrective Action) [SAMPLE] | |||||
| 2 | Site | Acme Manufacturing, Plant 2 | Log kept by | J. Davis (Quality) | ||
| 3 | ||||||
| 4 | NCR number | Date found | Where found (process / machine) | Part name / number | Lot | Nonconformance (what was found) |
| 5 | NCR-26-029 | 08/05/2026 | CNC machining L-07 | Bearing housing AH-2200 | P26-0805 | Bore over upper limit (2.3637 in, USL 2.3634 in) |
| 6 | NCR-26-030 | 08/05/2026 | Incoming inspection | Ball bearing 6205-2RS | BR-0805 | Dents on outer ring (3 pcs) |
| 7 | NCR-26-031 | 08/07/2026 | Paint line | Cover CV-540 | P26-0806 | Paint runs (5 pcs) |
| 8 | ||||||
| 9 | ||||||
| 10 | ||||||
| 11 | ||||||
| 12 | (14 more blank rows) | |||||
| 13 | Inspected by | |||||
| 14 | ||||||
| 15 | ||||||
| 16 | Notice: This is a general-purpose inspection record. It is not an official government form and does not by itself show compliance with OSHA or any other regulation or standard. | |||||
| 17 | Which inspections you need, how often, and how long to keep records depend on your equipment, industry, and location. Check the regulations that apply to you, the manufacturer's instructions, and a qualified person. | |||||
| 18 | Worker Library accepts no liability for any loss arising from the use of this template. Regulations change; check the source page for the latest version. | |||||
| 19 | Worker Library https://worker-library.com/templates/nonconformance-report-log/ Updated 2026-10-21 | |||||
This preview shows the first 6 of 16 columns. The downloaded file contains everything.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Nonconformance Report Log (NCR and Corrective Action) | |||||
| 2 | Site | Log kept by | ||||
| 3 | ||||||
| 4 | NCR number | Date found | Where found (process / machine) | Part name / number | Lot | Nonconformance (what was found) |
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 | ||||||
| 9 | (17 more blank rows) | |||||
| 10 | Inspected by | |||||
| 11 | ||||||
| 12 | ||||||
| 13 | Notice: This is a general-purpose inspection record. It is not an official government form and does not by itself show compliance with OSHA or any other regulation or standard. | |||||
| 14 | Which inspections you need, how often, and how long to keep records depend on your equipment, industry, and location. Check the regulations that apply to you, the manufacturer's instructions, and a qualified person. | |||||
| 15 | Worker Library accepts no liability for any loss arising from the use of this template. Regulations change; check the source page for the latest version. | |||||
| 16 | Worker Library https://worker-library.com/templates/nonconformance-report-log/ Updated 2026-10-21 | |||||
This preview shows the first 6 of 16 columns. The downloaded file contains everything.
File details
| Format | Excel (.xlsx) |
|---|---|
| Works with | Microsoft Excel 2016 or later, Excel for Microsoft 365, Google Sheets, LibreOffice Calc |
| Paper | Print areas set for US Letter |
| Sheets | Instructions / Entry Sheet / Sample (Filled In) / Print (Letter) |
| Macros | None |
| File size | About 19 KB |
| Updated | 2026-10-21 |
How to use the nonconformance report log
- Fill in the site, who keeps the log, and the period at the top.
- When a nonconformance is found, tag and hold the parts, then add a row with the next NCR number, the date, where it was found, and what was found.
- Enter the qty nonconforming and qty inspected. The defect rate fills in by itself.
- Write the containment and the disposition. Then find the root cause and write the corrective action with an owner and a due date.
- After the action, check that the problem did not come back and write the date and result. Only then is the row closed.
Adapting it to your site
- Add a column for a CAPA number if corrective actions are tracked in a separate system.
- Add a column for cost (scrap, rework hours) if you report the cost of poor quality.
- Add a "Source" drop-down (incoming, in-process, final, customer) to sort the log by where problems are found.
Before you use it
Please read
- This is a general nonconformance log template. It is not a form from any customer, standards body, or agency.
- How you handle and record nonconforming product depends on your quality system (for example ISO 9001 if you are certified) and your customer's quality requirements.
- A "Use as is" disposition accepts parts outside the spec. Get approval from the person allowed to sign it, and from the customer if they require it.
- Do not close a row when the action is done. Close it when the effectiveness check shows the problem did not come back.
- This template is provided as-is for reference. Worker Library is not liable for any loss arising from its use. Regulations change, so check the update date on this page.
Nonconformance Report Log FAQ
What is a nonconformance report (NCR)?
An NCR is a record that a part, material, or product does not meet its requirements. It describes what was found, how many parts are affected, what was done with them, and the corrective action to stop it from happening again.
What should a non conformance report template include?
Most NCR forms include an NCR number, date, part and lot, a description of the problem, quantity, root cause, containment, disposition, corrective action, owner, and a check that the action worked. This log has a column for each.
What are the usual NCR dispositions?
Common dispositions are use as is, rework, repair, scrap, and return to vendor. Use as is and repair usually need approval because the part does not fully meet the spec.
What is the difference between an NCR and a CAPA?
An NCR records one nonconformance and what was done with the affected parts. A CAPA (corrective and preventive action) is the process of finding the root cause and making sure it does not happen again. This log keeps both on the same row.