2-Year Internal Audit Programme

4. Please note that Column 'A' will automatically populate with information from the previous worksheet.

5. Enter the begining date of the audit programme in Cell G5 - Note: Date must be a Monday! The remaining dates in Row 5
will automatically update. Enter the audit's 'start' and 'finish' dates in the grey coloured cells in Columns C and D, the duration
is calculated in Column E and the bars in the programme are updated.

6. Please note that all date range cells in Columns G to ACA1 contain a hidden '0' which is part of the 'date box' shading
formula - Do not delete!

7. Begin auditing your management system and its processes using the internal audit checklists and process audit report
templates.

Week 1 Week 2 Week 3 Week 4 Week 5

M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T
Audit Complete?

16-Mar-20
17-Mar-20
18-Mar-20
19-Mar-20
20-Mar-20
21-Mar-20
22-Mar-20
23-Mar-20
24-Mar-20
25-Mar-20
26-Mar-20
27-Mar-20
28-Mar-20
29-Mar-20
30-Mar-20
31-Mar-20
Duration

01-Apr-20
02-Apr-20
03-Apr-20
04-Apr-20
05-Apr-20
06-Apr-20
07-Apr-20
08-Apr-20
09-Apr-20
10-Apr-20
11-Apr-20
12-Apr-20
13-Apr-20
14-Apr-20
15-Apr-20
16-Apr-20
Process Name Audit Type Start Date Finish Date (If yes enter audit
(Days)
report Ref.)

Planned 16-Mar-20 21-Mar-20 5 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Additional 25-Mar-20 26-Mar-20 2 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
QMS & Processes
Additional 30-Mar-20 04-Apr-20 5 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 0 0
Additional 06-Apr-20 08-Apr-20 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0
Planned 09-Apr-20 14-Apr-20 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0
Additional 15-Apr-20 20-Apr-20 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
Business Planning
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Sales & Marketing
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
QA/QC Management
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Business Review & Improvement
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Operational Planning
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Order/Quote Fulfillment
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0