ISO 9001 2015 Internal Audit Tracker Sample
ISO 9001 2015 Internal Audit Tracker Sample
ISO 9001 2015 Internal Audit Tracker Sample
ukProcess
The process assessment is not a strict requirement in ISO 9001:2015 but it will help to substantiate your audit programme and to introduce
Step 1 Enter the process name(s) in cells 'B27' to 'B48'.
Once you have entered the process name(s), they will copy through to the relevant sections of the remaining worksheets.
Step 2 Assess the criteria for ranking the status of processes.
1= Low All performance indicators, metrics, objectives, audit results, etc. show stability and consistently achieve targets;
2 = Medium Minor problems exist, minor process or product changes planned;
3 = High Poor performance/adverse trends, expected results not achieved;
4 = Critical Metrics are non-conforming. Any process with major audit finding in past 12 months.
Step 3 Assess the criteria for ranking how well the process is performed.
1= Low Consistently applying documented practice, possible benchmark performer;
2 = Medium Current practices conform but are not documented;
3 = High Practices are applied inconsistently;
4 = Critical Practices are non-conforming.
Step 4 Assess the criteria for ranking the importance of processes.
1= Low Little to no risk of adversely affecting customer satisfaction, product quality, delivery, or profitability;
2 = Medium Adverse effect on customer satisfaction, product quality, delivery, or profitability;
3 = High Likely have a significant adverse effect on customer satisfaction, product quality, delivery, or profitability;
4 = Critical Likely cause safety or regulatory compliance issues.
Step 5 The audit frequency indicators will transfer to the other work sheets within this workbook for future r
An audit should be scheduled at least once per year unless otherwise justified;
An audit should be scheduled within 12 weeks and an additional audit within 6 months;
An audit should be scheduled within 4 weeks with an additional audit after 12 weeks and then reoccurring quarterly.
Audit Programme
Step 6 Enter the start and finish date for each planned, or additional audit, based on the frequency shown by
Please note that Columns A, B & C will automatically populate with information form the 'Process Assessment' worksheet.
Only enter information in the grey coloured cells in Columns 'E', 'F', 'G' & 'H'.
The formulas will then colour the relevant date/day cell(s) in the programme.
Please note that all cells between 'I7' & 'I96' to 'ACA7' & 'ACA96' contain a hidden '0' which is required for the 'date cell' shading formula -
Begin auditing your system and processes, using the internal audit checklist.
Audit Findings Tracker
Step 7 From the 'Findings Summary' of the Audit Checklist, copy and paste the grey coloured cells into the co
Please note that Columns 'A', 'B' & 'C' will automatically populate with information from the 'Process Assessment' worksheet.
Remember that when pasting data from the internal audit checklist into the tracker to select 'paste without formatting' from paste options
Audit Findings Charts
Step 8 Copy and paste the charts into your internal audit reports or management review reports.
Please note that the grey coloured columns will automatically populate with data from the 'Audit Findings Tracker' worksheet.
Non-conformity & Corrective Action Tracker
Step 9 Issue corrective actions to process owners. Monitor progress and verify close-out.
Please note: the drop down box menu in Column 'B' is based on the processes that you entered in the 'Process Assessment' worksheet.
ww.iso-9001-checklist.co.ukProcess Assessment
audit programme and to introduce risk based thinking into your audit process.
ng worksheets.
profitability;
y, or profitability;
hin this workbook for future reference during the next steps.
urring quarterly.
nt review reports.
Tracker' worksheet.
close-out.
cess Assessment' worksheet.
www.iso-9001-c
Process Assessment
Step 1 Enter the process name(s) in cells 'B27' to 'B48'.
Once you have entered the process name(s), they will copy through to the relevant sections of the remaining worksheets.
1= Low All performance indicators, metrics, objectives, audit
Step 2 Assess the criteria for ranking the status of 2 = Medium Minor problems exist, minor process or product chan
processes.
3 = High Poor performance/adverse trends, expected results n
4 = Critical Metrics are non-conforming. Any process with major
1= Low Consistently applying documented practice, possible
Step 3 Assess the criteria for ranking how well the 2 = Medium Current practices conform but are not documented;
process is performed.
3 = High Practices are applied inconsistently;
4 = Critical Practices are non-conforming.
1= Low Little to no risk of adversely affecting customer satisf
Step 4 Assess the criteria for ranking the 2 = Medium Minor adverse effect on customer satisfaction, produ
importance of processes.
3 = High Likely have a significant adverse effect on customer s
4 = Critical Likely cause safety or regulatory compliance issues.
Audit frequency indicators will transfer to An audit should be scheduled at least once per year unless othe
Step 5 the 'Audit Programme' and the 'Audit
An audit should be scheduled within 12 weeks and an additional audit within 6 months;
Findings Tracker' for reference.
An audit should be scheduled within 4 weeks with an additional audit after 12 weeks
Perceived Process Ranking
Customer Complaints
Actual No. of Complaints
Quantity
0
0
0
0
2
Any Known Corrective Actions
Internal CA (Audits/N/Cs) External CA (Audits/N/Cs)
Quantity Quantity
0 0
0 0
1 0
2 0
0 1
Process
Status
Indicator
www.iso-9001-checklist.co.uk
s, metrics, objectives, audit results, etc. show stability and consistently achieve targets;
or process or product changes planned;
nsistently;
ming.
ly affecting customer satisfaction, product quality, delivery, or profitability;
ustomer satisfaction, product quality, delivery, or profitability;
ts not achieved;
ajor audit finding in past 12 months.
ible benchmark performer;
ed;
Step 6 Enter the start and finish date for each planned, or additional audit, based on the frequency shown by the indicators.
An audit should be scheduled at least once per year unless otherwise justified;
An audit should be scheduled within 12 weeks and an additional audit within 6 months;
An audit should be scheduled within 4 weeks with an additional audit after 12 weeks and then reoccurring quarterly.
Please note that Columns A, B & C will automatically populate with information form the 'Process Assessment' worksheet.
Only enter information in the grey coloured cells in Columns 'E', 'F', 'G' & 'H'.
The formulas will then colour the relevant date/day cell(s) in the programme.
Please note that all cells between 'I7' & 'I96' to 'ACA7' & 'ACA96' contain a hidden '0' which is part of the 'date box' shading formula - DO NO
Begin auditing your system and processes using the internal audit checklist.
Planned 19-01-16
quarterly.
nt' worksheet.
12-01-16
13-01-16
14-01-16
15-01-16
16-01-16
17-01-16
18-01-16
19-01-16
20-01-16
21-01-16
22-01-16
23-01-16
24-01-16
25-01-16
26-01-16
(Yes/No)
20-01-16 1 day
05-02-16 2 Day
17-02-16 3 Day
27-01-16
28-01-16
29-01-16
25-01-16
30-01-16
31-01-16
01-02-16
02-02-16
03-02-16
04-02-16
05-02-16
01-02-16
06-02-16
07-02-16
08-02-16
09-02-16
10-02-16
11-02-16
12-02-16
08-02-16
13-02-16
14-02-16
15-02-16
16-02-16
17-02-16
18-02-16
19-02-16
15-02-16
www.iso-9001-checklist.co.uk
Audit Findings Tracker
Step 7 Using the 'Findings Summary' section from the Internal Audit Checklist.docx, copy and paste grey the coloured cells into the co
Please note that Columns 'A', 'B' & 'C' will automatically populate with information from the 'Process Assessment' worksheet.
OFI 1
IA001 Quality Management System Minor N/C 1
Major N/C
OFI 1
IA002 Document Control Minor N/C 1
Major N/C
OFI
worksheet.
Context of the Organization
4.2 4.3 4.4 4.4.1 4.4.2
n 4.0
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Sectio
1 1 3
1 2
1 1
1
1 1 3
0
1 1
1 1 2
0
1 1
1 1 3
1 1
0
1 1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Leade
5.1.1 5.1.2 5.2.1 rship
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
1 1
1
1
1 1
1
1 1
1
1
1
1
www.iso-9001-checklist.co.uk
Audit Findings Charts
Step 8 Copy and paste the charts into your internal audit report or management review report.
Please note that the grey coloured columns will automatically populate with data from the 'Audit Findings Tracker' worksheet.
Quality Management System Compliance
Clause
Quality Management System Compliance Charts
Processes Compliance
Total Minor Total Major Total Audit
N/C N/C Findings
Audit Ref. Process Name Total OFI
IA004 Manufacturing 2 4 2 8
4.1 2 2 0
4.2 0 2 0
4.3 1 3 0
4.1
4.2
0
Context of the Organization
2 2 0
2 0
4.4 0 0 1
4.4.1 3 3 1
4.4.2 0 1 0
4.3
1 3
4.4
0 1
4.4.1
3 3
4.4.2
0 1
0
OFI
Minor N/C Major N/C
1
###
5.1.1 6 3 2
Leadership
5.1.2 0 2 0
5.2.1 0 0 0
5.2.2 0 0 0
5.3 1 0 1
5.1.1
5.1.2
0
5.2.1
0
5.2.2
0
6 3 2
2 0
OFI
Minor N/C Major N/C
6.1.1 1 0 0
6.1.2 0 0 1
6.2.1 0 1 0
6.2.2 0 1 1
6.3 0 1 0
6.1.1
6.1.2
0
6.2.1
0
6.2.2
0
6.3
0
Planning
1
1
1
1 1
1
0
OFI
0 Minor N/C
Major N/C
0
7.1.1 1 0 0
Support
7.1.2 0 0 0
7.1.3 0 0 0
7.1.4 0 0 0
7.1.5.1 0 0 0
7.1.5.2 0 0 0
7.1.1
1 0
7.1.2
0
7.1.3
0
7.1.4
0
7.1.5.1
0
7.1.5.2
0
acker' worksheet.
Total Audit
Findings
Process Compliance Chart
Manufacturing
5
Customer
Service
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
<enter process name/description>
0
13
0
1
Non-conformity & Corrective Action Tracker www.iso-9001-checklist.co.uk
Step 9 Issue corrective action reports to process owners to initiate the close-out of any non-conformances. Monitor progress and verify close-out.
Please note: the drop down box menu in Column 'B' is based on the processes that you entered in the 'Process Assessment' worksheet.
CAR Ref. Process Name CAR Type How was it identified?
Version control - using superseded template Department to ensure templates are updated
Item was mis-identified prior to storage Warehousing to investigate and correct labelling errors
Date Assigned Assigned to Target Closed-out
Completion (Yes/No)
01-01-16 Jane Doe 20-01-16 Yes
20-02-16 John Doe 07-03-16 No
How was Close-out Verified? Date Close-out
Verified
Visually confirmed that the correct template is available and is being used 30-01-16