Jump to content

  • Quick Navigation

Efficiently documenting Holds, Non-Conformances, Customer Complaints

Share this

  • You cannot start a new topic
  • Please log in to reply
6 replies to this topic


    Grade - MIFSQN

  • IFSQN Member
  • 58 posts
  • 2 thanks

  • Earth

Posted 31 October 2018 - 01:20 PM

Hi all, looking for opinions on how to efficiently document and track the various types on non-conformances that pop up. 


I currently have separate programs/SOPs for: 

- Customer Complaints

- Hold & Release

- Corrective Action Program 


I'm trying to determine the best way to track the documentation needed for these requirements. Currently, the Hold program and the Customer COmplaint program both have individual documents to outline the details -- but also link to a Non-Conformance Report. Each document is numbered (Hold 18-001, NCR 18-002, CC 18-001, etc.) It's just quite a bit to track in separate files and link and so on. 


I'm interested to hear some ideas of how others manage these programs, if they are kept completely separate, and any other tips to make this manageable and efficient, while impactful. 


Thank you! 


    Grade - MIFSQN

  • IFSQN Member
  • 242 posts
  • 61 thanks

  • United States
    United States
  • Gender:Female
  • Location:Wisconsin

Posted 31 October 2018 - 04:51 PM

Hello!  We use a Hold Log, CAPA Log (for all NCs) and a Complaint Log to keep track of each of the three items you described above.  


    Grade - SIFSQN

  • IFSQN Senior
  • 313 posts
  • 126 thanks

  • United States
    United States

Posted 31 October 2018 - 06:44 PM

IMO: You can include all these programs under your Quality Management Policy (if you have one already in place). It just makes it easier to have most (not all) of the standard operation programs and policies under one Umbrella program/document.


However, individual logs will still be needed to report/record any complaints, CAR and Hold/Release.


    Grade - FIFSQN

  • IFSQN Fellow
  • 1,376 posts
  • 980 thanks

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 31 October 2018 - 08:23 PM

You can certainly do all of this if you are fairly proficient in Excel.


It's important to understand that most GFSI audit schemes require that you "trend" some of these things to ensure your process or product is not getting out of control.
In the absence of a "software package" that will do that for you, Excel is probably the best solution.

Even if you are not audited against a GFSI scheme, you should do trending. Otherwise it's just a bunch of data (or pieces of paper) that do you no good.


If you currently do, or choose to do the Excel route, you need to ensure that your "reasons" for nonconformance are standardized. Otherwise it's all a waste of time.
"Too big" and "Out of Spec" may seem like the same thing to the person entering the data, but to an Excel spreadsheet they are two totally different things.



Edited by mgourley, 31 October 2018 - 08:36 PM.


    Grade - AIFSQN

  • IFSQN Associate
  • 28 posts
  • 0 thanks

  • United States
    United States

Posted 20 November 2018 - 05:35 PM

What does your trending Worksheet Look like?

Jim E.

    Grade - MIFSQN

  • IFSQN Member
  • 164 posts
  • 24 thanks

  • Canada
  • Gender:Male
  • Location:Alberta, Canada
  • Interests:Sports of course.
    Food safety for all things eaten not just what we make.
    Being able to see my kids grow up in healthy environment.

Posted 28 November 2018 - 07:29 PM

I think it all depends on what you want to track and trend.  We built a pivot table then made trend charts of the table.  We track and trend complaints by customer, complaint issues and type of complaint (quality, FM and packaging).  It is fun stuff but still learning how to build.  We have also built tracking for in house FM investigations and hold and release.


    Grade - AIFSQN

  • IFSQN Active
  • 42 posts
  • 14 thanks

  • United States
    United States
  • Gender:Female
  • Location:Wisconsin
  • Interests:Helping others succeed in Food Safety! Specializing in Document Control, Corrective Action, Internal Auditing, Risk Assessments, and HACCP.

Posted 08 January 2019 - 05:40 AM

I built a solution using Microsoft Office 365 in PowerApps to track all of my nonconformances.  Take a look at my website it shows photos/screenshots.  It uses PowerApps, Sharepoint and PowerBI to track trends.  The options are pretty much limitless and extremely easy for all users.  The super awesome part is the workflows that help drive each one to completion along with notifications when an item is past due.  I'd love to help let me know if you have any questions.

Peak Quality Consulting http://peakqualityconsulting.com

Office (414) 909-3249


SQF Practitioner

BRC Professional

HACCP Certified

ASQ CQA - Certified Quality Auditor


Thanked by 1 Member:

Share this

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users