# AS9100 Internal Audit Programme Planner Worksheet

> Source: https://netray.co/tools/aerospace-internal-audit-programme-planner-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Plan which processes you audit, how often and for how many hours, and see total annual auditor workload.

## Category

aerospace-defense

## Industry

Aerospace

## Audience

- Quality manager
- Internal auditor
- Management representative

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Process or area

**Key:** process

**Type:** text

#### Risk level

**Key:** risk

**Type:** select

**Options:**

- Low
- Medium
- High

#### Last audit result

**Key:** last_result

**Type:** select

**Options:**

- No findings
- Minor findings
- Major findings
- Not yet audited

#### Audits per year

**Key:** freq

**Type:** number

#### Hours per audit

**Key:** hours

**Type:** number

**Unit:** h

#### Annual hours

**Key:** annual

**Type:** number

**Expr:** freq * hours

**Format:** decimal

#### Next audit date

**Key:** next

**Type:** date

**Rows:**

**Process:** Contract review and order entry

**Risk:** Medium

**Last result:** Minor findings

**Freq:** 1

**Hours:** 4

**Next:** 2026-11-10

**Process:** Purchasing and supplier control

**Risk:** High

**Last result:** Major findings

**Freq:** 2

**Hours:** 6

**Next:** 2026-11-17

**Process:** Production and special processes

**Risk:** High

**Last result:** Minor findings

**Freq:** 2

**Hours:** 8

**Next:** 2026-12-01

**Process:** Calibration and measuring equipment

**Risk:** Medium

**Last result:** No findings

**Freq:** 1

**Hours:** 3

**Next:** 2027-01-12

**Process:** Nonconformance and corrective action

**Risk:** High

**Last result:** Minor findings

**Freq:** 2

**Hours:** 5

**Next:** 2026-12-08

**Process:** Document and record control

**Risk:** Low

**Last result:** No findings

**Freq:** 1

**Hours:** 3

**Next:** 2027-02-09

**Totals:**

#### Total audits per year

**Key:** freq

**Agg:** sum

**Format:** integer

#### Total audit hours

**Key:** annual

**Agg:** sum

**Format:** decimal

**Summary:**

#### Auditor days (6 productive hours per day)

**Key:** days

**Expr:** sum_annual / 6

**Format:** decimal

#### Average hours per process

**Key:** avg_hours

**Expr:** sum_annual / max(1, count)

**Format:** decimal

#### Hours including 40% for preparation and reporting

**Key:** with_prep

**Expr:** sum_annual * 1.4

**Format:** decimal

**Primary:** true

**Notes:** Risk levels and frequencies are yours to justify. AS9100 clause 9.2 expects the programme to consider process importance, changes and past audit results. Keep auditors independent of the area they audit.

## Content

**Intro:** AS9100 requires an internal audit programme that takes into account the importance of the processes, customer feedback, changes and the results of previous audits. This worksheet lets you list each process, set its risk and frequency, and see the total annual workload.

**Sections:**

#### How to use it

**Body:** List every process or area in your quality system, including support processes like training and calibration. Rate each for risk, note the last result, and set audits per year and hours per audit. The annual hours column calculates automatically and the summary adds preparation and reporting time. Export to Excel to share the schedule or attach it to management review.

**Bullets:**

- Audit high-risk processes more often than once a year.
- Increase frequency after major findings.
- Plan next audit dates so no month is overloaded.

#### Choosing frequency

**Body:** A common starting pattern is once per year for low-risk processes, twice for medium or those with recent findings, and more for high-risk or customer-sensitive ones like special processes and purchasing. The audit programme should also be revisited after process changes, new customer requirements or an escape. Document the rationale so an auditor from a certification body can see how you decided.

#### Common mistakes

**Body:** Auditing by clause rather than by process, so related requirements are never tested end to end. Letting the same person audit their own area. Scheduling every audit in the last quarter. And forgetting that follow-up of corrective actions also takes time. The 40% allowance in the summary is a planning default, adjust it to your own records.

**Cta:** If audit findings and corrective actions are tracked in separate spreadsheets, we can help link them to your ERP and quality records.

**Faq:**

#### How often must internal audits happen?

**Answer:** AS9100 does not give a fixed number. It requires audits at planned intervals covering the whole quality system, and your programme must consider risk and prior results. Most organisations cover every process at least yearly.

#### Can I audit by process instead of clause?

**Answer:** Yes, and it is the better approach. Process audits follow work from input to output and test several clauses at once, which finds more real problems than clause-by-clause checking.

#### How many hours per audit should I plan?

**Answer:** It depends on process size and risk. Three to eight hours is typical for a site audit of a single process. Use actual time from past audits to adjust the figures here.

#### Who can be an internal auditor?

**Answer:** Anyone trained and competent in the standard and audit technique who is independent of the area audited. Keep training records, since certification bodies ask for evidence of auditor competence.

## Search terms

internal audit programme template, AS9100 internal audit schedule, audit plan excel, internal audit programme planner, process audit schedule template, risk based audit schedule, audit hours calculator, AS9100 clause 9.2 audit programme

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json