Developing a ISO 9001:2015 Internal Audit Plan and Schedule

Jen, I believe the "missing" tab is the CA Log. Columns A through AQ are 0.13" wide and greyed out, not allowing the preparation of the drop-down menus.

My employer is transitioning to ISO 9001:2015 and our ISO Mgmt Rep recently retired with those duties being transferred to me. In addition to updating our audit program, I have found that our CA logging is in need of an upgrade. I was fortunate to find this forum and this spreadsheet in particular to kill both birds, but I have so far not been able to use the CA log.

JCMetz said:

Jen, I believe the "missing" tab is the CA Log. Columns A through AQ are 0.13" wide and greyed out, not allowing the preparation of the drop-down menus.

My employer is transitioning to ISO 9001:2015 and our ISO Mgmt Rep recently retired with those duties being transferred to me. In addition to updating our audit program, I have found that our CA logging is in need of an upgrade. I was fortunate to find this forum and this spreadsheet in particular to kill both birds, but I have so far not been able to use the CA log.

Click to expand...

Welcome to the Cove!

Those columns have formulas in them and so are obscured from view - so the formulas cannot be altered.

Did you see the Instructions - NC Tracking Log tab? It shows how to set up the dropdown menus in the CA Tracking Log.

Jen,
Sorry about that, I did not look closely enough to the cell locations on the instruction page. Now on the entering the info. Thank you!

Jen, I really appreciate your spreadsheet and hope to use it for our internal audit system.

I am stuck on the Problem Type / Subclassification drop down menu. What would go in that column? Could you provide some examples to help me understand?

Thanks again!

We all seem to agree, the internal audit must cover all clauses of the new 2015 standard to pass the Transition Audit. When creating the Audit Plan/Program to accomplish this effort, we are allowed to use the results of previous audit for planning purposes. We know the standard allows this. Does this include using previous audit reports from your own Registrar? Can I use a Registrar created audit report as evidence of WHY I selected NOT to audit a certain element of the QMS ... because the Registrar audit report shows that element to be compliant. Has anyone tried this and been successful?

WOW thank you for this.

MrPhish said:

We all seem to agree, the internal audit must cover all clauses of the new 2015 standard to pass the Transition Audit. When creating the Audit Plan/Program to accomplish this effort, we are allowed to use the results of previous audit for planning purposes. We know the standard allows this. Does this include using previous audit reports from your own Registrar? Can I use a Registrar created audit report as evidence of WHY I selected NOT to audit a certain element of the QMS ... because the Registrar audit report shows that element to be compliant. Has anyone tried this and been successful?

Click to expand...

Do we? I've not seen any need to cover ALL the clauses and indeed there isn't. Much of the standard hasn't changed - except terminology. If the previous audit program was effective, why go over everything when 80% hasn't changed - even the standard (9.2.2) gives a clue here.

Yes, you MIGHT consider the CB audit results - if they are any good. I've seen a lot of rubbish findings recently. Using a CB auditor's lack of findings to justify why you don't need to audit anything isn't "risk based thinking" - it's careless, IMHO. You're supposing your auditor knows anything about you from a (very) short visit. Scary.

Chris B said:

Jen, I really appreciate your spreadsheet and hope to use it for our internal audit system.

I am stuck on the Problem Type / Subclassification drop down menu. What would go in that column? Could you provide some examples to help me understand?

Thanks again!

Click to expand...

This response is way overdue, I am sorry.

Problem type can be various conditions you identify within the man-material-machine-method-mother nature groups. It is different from root cause because it is a symptom that could actually have more than one cause. It is just a classification. If you find you have a lot of equipment issues, you could look at that as a potential continuous improvement topic and start investigating what these clusters of nonconformities have in common.

I hope this helps!

Jen Kirley said:

In case it helps, I am attaching my revised QMS Audit Program Manager Toolkit.

This audit program tool kit has been updated for the ISO 9001:2015 standard. It is designed to help with process auditing, and includes a risk-based Corrective Action log that charts results in a number of categories. This tool kit can be formatted to suit other quality standards by adding subclauses to the Audit Planner sheet.

Feel free to adapt it for your own use, but please remember this tool kit is copyright protected against redistribution and sale.

Click to expand...

How can I purchase this toolkit.....it's great! Could you email information for how to purchase the kit?

Pamela Adams
[email protected]

Hello Pamela,

Please feel free to download and use the QMS Audit Program Manager Toolkit for free. I have shared it with the community in order to help people where and how I can. The QMS and integrated QMS/EMS versions are in the Post Attachments List:
Post File Attachments Listing