TEMPLATESDOCUMENT CONTROLFree Excel (.xlsx) download

Master Document List Template

An Excel register of every controlled document: number, title, type, owner, current revision, effective date and where it lives. Formulas work out each next review date and flag documents that are overdue or due soon, so the list doubles as your review schedule.

Who this template is for

Document controllers and quality managers in plants that manage controlled documents in shared folders or on paper, and anyone preparing for an audit who needs to show which revision is current.

When to use it

Set it up when you start controlling documents, update it every time a document is released, revised or made obsolete, and check the summary each month and before every audit.

Standards it supports

How to use this template

  1. Inventory your documents — collect every manual, procedure, work instruction, form and external standard you use, one row each.
  2. Give each a number and owner — use one numbering scheme and name a role that owns each document.
  3. Record revision and dates — enter the current revision, effective date and review interval in months; the next review date calculates.
  4. Set the as-of date — the sheet uses today’s date by default; the status column then shows Overdue, Due soon or Current.
  5. Keep it in step with changes — update the row in the same step as issuing a new revision, and reference the ECN or change request.

Tip: Change the due-soon window at the top of the sheet (30 days by default) to match how far ahead owners need to start a review.

What's inside the template

1

Header

Company, list owner, status-as-of date and due-soon window in days

2

Identification

Document number, title, type and origin (internal or external)

3

Control

Owner, current revision and effective date

4

Review schedule

Review interval, calculated next review date and status

5

Location and change link

Where the controlled copy lives and the latest change reference

6

Summary

Totals for all documents, overdue, due soon, current and external

Example: a completed template

Example An excerpt of the list for Example Precision Co., a fictional machine shop, with status as of 2026-07-01 and a 30-day due-soon window. Document numbers and dates are invented for illustration.

Master document list

Doc noTitleRevEffectiveIntervalNext reviewStatus
QM-001Quality manualE2025-03-1012 mo2026-03-10Overdue
SOP-004Control of documented informationC2025-07-1512 mo2026-07-15Due soon
WI-2240Machining: bracket 10-2240B2026-02-0224 mo2028-02-02Current
FRM-012Nonconformance report formA2024-05-0224 mo2026-05-02Overdue
EXT-003ISO 9001:2015 (purchased copy)20152024-01-1036 mo2027-01-10Current

Summary

Total documents5
Overdue2
Due soon1
Current2
External origin1

The math in this Example

How to fill in each field

FieldWhat to enterExample
Doc noUnique and never reused, with a prefix for the document type.SOP-004
TypeManual, procedure, work instruction, form, specification or external standard.Procedure
OriginInternal, or External for customer drawings, standards and supplier documents you must control.External
OwnerThe role responsible for keeping the document accurate and reviewing it.Quality Manager
Current revThe released revision only. Drafts in work do not belong here until released.C
Effective dateThe date the current revision was released for use.2025-07-15
Review interval (months)Your chosen interval. ISO 9001 does not set one; many plants use 12 to 36 months by document type.12
Next review / StatusCalculated: effective date plus interval, compared with the as-of date. Do not type over these cells.2026-07-15 / Due soon
LocationWhere the controlled copy lives: system path, binder or station.QMS share / Procedures
Change refThe ECN or change request behind the current revision.ECN-2026-041

Common mistakes

Frequently asked questions

Does ISO 9001 require a master document list?

Not by name. It requires documents to be identified, version-controlled and available, and a master list is the most common way to show that. Document control software that lists current revisions serves the same purpose.

Should records be on the master document list?

Usually not. Records such as completed forms are evidence, not controlled documents. Many companies keep a separate records retention list showing each record type, where it is kept and for how long.

How often should documents be reviewed?

ISO 9001 does not set an interval. Choose one per document type, and review earlier when a process, product or requirement changes.

How do I control external documents?

List them with their source and the revision you are using, name an owner who checks for updates, and mark them External so they are counted separately.

Why do the status formulas use an as-of date rather than today?

The blank sheet uses TODAY() by default. The cell can be overwritten with a fixed date to reproduce the status on a past date, for example the day of an audit.

See also

COPLAIN AI PLATFORM

Generate yours automatically from your existing docs

When an overdue document comes up for review, run it through Coplain’s Auditor Review to see where it no longer meets your standard before you reissue it.

Generate yours automatically with Coplain →

Related Tools & Templates