Supplier Audit Schedule (Free Excel)

Last audit, next audit, and what is still open

A supplier audit can slip by months when the last and next dates sit in different files, or when findings from the last audit stay open with no due date. This schedule keeps them on one row per audit. The supplier quality audit checklist covers what to look at during the audit; this file covers when.

What is in the file

Settings: an as-of date (blank means today) and an interval in months, used only on rows where the interval is blank. The 12 months are our own default, not from a standard; change them.
Log: ref, supplier, site or process, audit type (system, process, product, other), owner, interval, last audit on, next planned on, done on, findings open, finding actions due by.
Due by interval fills in: last audit on plus the interval. Days past planned runs from next planned on to the as-of date, for audits not done.
A separate check column. The status never hides it, and a row can show several notes, joined with a semicolon.
Counts under the log: rows logged, rows per status, rows with a check note, rows past due and not done (any status), a line that should read 0 (rows not in any status), and findings open. No score and no ranking of suppliers.

How the status is worked out

In this order; the first match wins:

Status	When
Enter ref	The row has an entry but no ref. It still counts.
Enter supplier	Supplier is blank.
Done, findings open	A done-on date is entered and findings open is above 0.
Done	A done-on date is entered.
Set an interval	The row interval and the Settings interval are both blank.
Enter planned date	Next planned on is blank.
Past planned date	The as-of date is after next planned on.
Enter owner	Owner is blank.
Planned	None of the above.

Check column notes, each followed by "worth a check", on any row whatever its status:

Planned date passed, not done
Past the interval due, not done
Planned after the interval due
Last audit after next planned
Finding actions open past due
Findings open with no action due date
No owner
Interval blank, Settings default used
Done before last audit
Done date after the as-of date

So a row still missing its ref or supplier shows that fill-in step, and the check column still says when the audit is past its planned date.

After a Done row, add a new row for the next audit.

Example (fictional)

Made-up suppliers, extract, as of Thursday 22 October 2026, Settings interval 12 months:

Ref	Supplier	Interval (months)	Next planned on	Due by interval	Status	Days past planned	Check
S-01	Alpha Castings	12	Tue 13 Oct 2026	Wed 14 Oct 2026	Done, findings open		Finding actions open past due: worth a check
S-02	Beta Plastics	12	Wed 30 Sep 2026	Thu 17 Sep 2026	Past planned date	22	Planned date passed, not done: worth a check; Past the interval due, not done: worth a check; Planned after the interval due: worth a check
S-03	Gamma Springs	24	Wed 10 Mar 2027	Thu 11 Mar 2027	Enter owner	0	No owner: worth a check
S-04	Delta Seals		Wed 18 Nov 2026	Thu 21 Jan 2027	Planned	0	Interval blank, Settings default used: worth a check
S-05	Epsilon Fasteners	12	Wed 13 May 2026	Thu 10 Jun 2027	Past planned date	162	Planned date passed, not done: worth a check; Last audit after next planned: worth a check

Worth a check each month

Past planned date (marked in red), and any row whose check column says not done.
Findings open past their action due date, or with no due date at all.
Planned dates later than the interval allows, and last audit dates after the next planned date.
Audits with no owner.

From supplier results to the schedule

A supplier with a repeat 8D, a rising count in the supplier PPM log or open actions in the supplier corrective action follow-up log may be worth an earlier audit. That is your call; the schedule does not rank or rate suppliers. When a supplier sends an 8D, check the 8D report before you reply.

Your own procedure and your customers decide how often each supplier is audited. The schedule is a planning aid; it does not decide for you.

Advisory template, in English. Not a customer decision.