Part of the LIMS software guide
Downloadable template · Control plan

Excel quality control sheet: downloadable control plan template.

A single Excel workbook, with no macros, to describe your checks once, enter your results as you go and calculate the compliance status by formula. With its limits, documented.

Getting a workable template is what this download is for: the Excel quality control sheet template offered here brings together the tabs, columns, formulas and drop-down lists needed to describe your checks on raw materials, finished products and suppliers, then record their results in a single file. It is written for food manufacturers - quality, purchasing and production teams - who need to organise and trace their checks, not for the testing laboratory that performs the measurements and issues the reports. Below you will find the exact content of the file, the six-step method to adapt it, its limits and the most common design mistakes.

Key points
  • A single Excel workbook, organised into six tabs: parameters, control plan, results, non-conformities, dashboard, version log.
  • The plan is described once; results are entered as you go; the compliance status is calculated by formula.
  • Thresholds and frequencies are stored in the Parameters tab, not copied into every line: one update is enough.
  • The template can be used as is for one site, a few product families and a small team sharing the same file.
  • Beyond that, the limits are known and documented below: threshold history, multi-site entry, re-keying of reports, readability at audit.

What the file contains: tabs, columns, formulas and drop-down lists

The file is a single Excel workbook, with no macros and no external connections, so any team can open it. Each tab has a distinct role: describe once, enter often, summarise automatically.

TabContentWhat it is for
ParametersReference lists: product families, suppliers and origins, process steps, types of check, units, sampling plans (n, c, m, M), thresholds, threshold source and effective dateSingle source for drop-down lists and lookup formulas
Control planOne line per control point: step, hazard, parameter monitored, threshold, frequency, method, owner, expected recordReference document for the plan, to be versioned
ResultsOne line per sample or measurement: date, batch or work order reference, control point, result, calculated status, corrective actionEvidence of checks and basis for the dashboard
Non-conformitiesDeviation found, probable cause, corrective action, owner, due date, closure dateTracking of deviations and how they are handled
DashboardCompliance rate by step and by family, open deviations, number of checks enteredMonthly management with no manual reprocessing
Version logDate, author, nature of the change, scope concernedHistory of file updates

The columns of the Control plan tab

ColumnExpected contentExample entry
Control point IDUnique, stable identifier used by the formulasMPC-01
StepGoods-in, storage, work in progress, finished product, dispatchRaw material receipt
Product familyDrop-down list fed from the Parameters tabFlours
Supplier / originDrop-down list, or “internal” for a process checkSupplier A, France
Hazard or parameterMicrobiological, physico-chemical, sensory, documentaryMycotoxins (deoxynivalenol)
MethodIn-house method or reference of the laboratory's methodLaboratory method, reference copied from the report
Warning threshold / blocking thresholdValue triggering closer monitoring, value that blocks, with unitWarning at 80% of the maximum level, blocking at the maximum level
Threshold sourceRegulation, customer specification or internal specificationRegulation (EU) 2023/915, Annex I
UnitDrop-down list (CFU/g, mg/kg, °C, pH…)µg/kg
Sampling planNumber of units sampled and maximum number of units allowed (n and c)n = 5, c = 0
FrequencyInterval or rate triggering the checkOne analysis per batch for a new supplier, then one per quarter
OwnerFunction responsible for sampling or measurementGoods-in quality manager
Associated recordDocument produced: report, reading sheet, supplier certificate of analysisLaboratory test report
Threshold effective dateStart date of validity of the value entered01/01/2026

The columns of the Results tab

ColumnExpected contentEntry mode
Sampling dateActual date of measurementManual entry
Batch or work order referenceIdentifier of the material or product concernedManual entry
Control point IDLink to the Control plan tabDrop-down list
Measured resultNumerical value, or “not detected” / “below the limit of quantification”Manual entry
UnitUnit of the resultDrop-down list
Applicable thresholdThreshold in force on the sampling dateLookup formula
Compliance statusCompliant, alert, non-compliant or to be determinedFormula
DeviationAutomatic flag when a limit is exceededFormula
Corrective actionLink to the Non-conformities tabDrop-down list
OperatorFunction of the person who entered the dataDrop-down list
Source documentName of the report or reading sheetManual entry
CommentInformation useful to the reviewerFree text

Ready-to-use formulas and drop-down lists

  • Threshold lookup: VLOOKUP (or XLOOKUP in recent versions) retrieves the thresholds and unit from the control point ID, avoiding any manual copying.
  • Compliance status: an IF formula compares the result with the two threshold levels and returns a single state - compliant, alert (warning threshold exceeded), non-compliant (blocking threshold exceeded), or to be determined when the result or threshold is missing. This closed vocabulary is essential to keep pivot tables accurate.
  • Indicators: COUNTIFS and SUMIFS calculate the compliance rate by step, by family and by month, directly in the dashboard.
  • Drop-down lists: data validation points to ranges in the Parameters tab, with labels that are strictly identical from one tab to another.
  • Conditional formatting: colour-coding of status and deviations to spot the lines to handle at a glance.
  • Structured table: the Control plan and Results tabs are converted into named tables, so that formulas and charts automatically follow added rows.
Free templateExcel quality control plan template

Six tabs, formulas and drop-down lists, no macros.

A single Excel workbookDescribe once, enter often, summarise automatically
ParametersReference lists, thresholds, source and effective date
Control planOne line per control point, versioned
ResultsOne line per sample, status calculated by formula
Non-conformities · Dashboard · Version logDeviation tracking, monthly management, change history
Control point IDThreshold and effective dateCalculated statusSource document

The control point ID links the tabs: the threshold is entered only once, in Parameters, and read by formula everywhere else.

How to adapt this quality control plan template to your business

The template does not replace the work of definition: it makes it visible and reusable. Allow half a day for a limited scope, more if thresholds have to be re-entered point by point.

  1. Define the scope before opening the file. List the process steps concerned (goods-in, storage, work in progress, finished product, dispatch), the product families and the suppliers to cover. A broad scope produces a file nobody fills in; better to start with one production line or one family, then extend.
  2. Start from what exists rather than from scratch. Gather your current plan, your reading sheets and the laboratory's reports. Every point already checked must appear in the Control plan tab with its associated record, otherwise the file will describe a theoretical plan that does not match practice.
  3. Fill in the Parameters tab first. Families, suppliers, steps, units and status lists are the foundation of the drop-down lists and formulas. Until these lists are frozen, entries in the other tabs generate diverging labels.
  4. Distinguish regulatory threshold from internal threshold. Some thresholds derive from applicable regulations - for example the microbiological criteria and sampling plans in Annex I to Regulation (EC) No 2073/2005, or the maximum residue levels in Regulation (EC) No 396/2005 - others are stricter internal thresholds, set by your hazard analysis under Article 5 of Regulation (EC) No 852/2004. Note the source of each value in the dedicated column: during a plan review, the question “where does this threshold come from?” always comes up.
  5. Enter thresholds, frequencies and sampling plans with your own values. The file contains no pre-filled values: each threshold, frequency and plan (n, c, m, M) is to be entered according to your products, tolerances and methods. The logic for building them is detailed on our sampling plan page.
  6. Test, then lock a version. Enter three to five real results, check that the calculated status matches what you expect, correct the formulas if needed, then name the version (for example an effective date) and appoint a function responsible for updates. A file with no designated owner degrades within weeks.
Method

To build the plan before filling in the file, follow the method: Quality control plan: method and examples.

The limits of an Excel file and when it becomes unmanageable

Excel remains an excellent starting point: everyone can read it, it can be changed without IT and costs nothing to roll out. Its limits appear when volume, number of sites or audit requirements change scale - and they appear quickly.

SymptomWhat happens in the fileConsequence
Re-keying reportsEach result is copied by hand from a PDF, sometimes dozens of parameters per reportTime spent, transcription errors, “not detected” results forgotten
Number of rowsBeyond a few thousand result rows a year, calculations slow down, files get duplicated and dashboards mix extracts from different datesWrong indicators and loss of trust in the file
Multi-site entryEach site works on its own copy, consolidation is done by copy-paste or by emailSeveral versions of the truth, overwritten entries, late arbitration
Threshold historyA threshold changed in the Parameters tab recalculates old results with the new valueA non-compliant result can become compliant retroactively: traceability is lost
Regulatory thresholdsThe annexes to the pesticide and contaminant regulations are amended several times a year; the file does not knowStatuses calculated on an outdated version
Audit and verificationNo reliable change log, no rights management by function, a file circulating as an attachmentImpossible to say who entered what, when, and on which version of the plan
Linked documentsReports, reading sheets and supplier certificates remain in separate foldersThe link between the result and its evidence breaks as soon as someone changes job

Four signs it is time to change tools

  • Two or more sites enter data in the same plan, even at different times.
  • Thresholds change during the year and you have to explain each change in the quality review.
  • An audit or official control, under Regulation (EU) 2017/625, asks for the full history: plan version, effective date, associated results.
  • You spend more time re-keying and consolidating files than analysing deviations.

What Tracklab does - and what it does not

Tracklab takes over the most costly part of the file: re-keying and comparing results. The platform gathers test reports from your suppliers and laboratories, extracts the results, including “not detected” parameters, and calculates a compliance status for each parameter: compliant, alert, non-compliant, or “to be determined” when information is missing. Thresholds come from your internal standards, with a warning level and a blocking level, and from four European regulations built in and kept up to date by Tracklab (pesticides, contaminants, microbiological criteria, plastic materials in contact with food). Each status keeps the threshold, regulation, its version and the date applied: the history is traceable and auditable. The laboratory's conclusion remains displayed alongside, and your teams can change a status by giving a reason.

Tracklab calculates and traces; the decision stays with your quality teams. It tracks the coverage of your analyses (frequency and date of the last analysis per product × supplier pair), calculates the compliance status of each parameter against your regulatory and internal standards, and keeps the threshold, regulation and date applied. For details, see Tracklab's LIMS software page.

On your own reports

To see the compliance calculation applied to your own test reports, book a meeting with the Tracklab team.

The most common design mistakes

The most common mistakes concern the structure of the file rather than the values entered: a threshold copied line by line, a single threshold with no warning level, a file with no version log.

MistakeWhat it causesFix
Mixing the plan and the results in a single tabThe plan, which must be stable, is rewritten at every entry; the history disappearsTwo separate tabs, linked by the control point ID
Copying the threshold into each result lineAny change of threshold requires line-by-line correction, with omissionsThreshold stored in the Parameters tab, read by formula
A single threshold levelA result close to the limit and an exceedance are treated the same wayTwo levels: warning and blocking
Leaving free text entry for families, suppliers and unitsSimilar but different labels, incomplete pivot tables, invisible duplicatesDrop-down lists from a single source
Forgetting the effective date of thresholdsA changed threshold applies retroactively to earlier results“Valid from” and “valid to” date columns
Entering only detected parametersImpossible to prove that a substance was tested forAlso enter “not detected” and results below the limit of quantification
Building the dashboard on fixed rangesNew rows are not taken into account, figures freezeStructured tables and formulas such as COUNTIFS
Not linking the result to its source documentImpossible to find the report or reading sheet if a question arisesMandatory “source document” column, with a defined storage location
Tracking deviations in another fileCorrective actions lost, deviations reopened without anyone knowingNon-conformities tab in the same workbook, with due date and owner; see the non-conformity report
Naming the file without a version or dateTwo people believe they are working on the master copy, with no way of proving itVersion log and explicit naming convention

Useful regulatory texts

The texts below underpin the requirements cited on this page; always consult their current consolidated version on EUR-Lex.

  • Regulation (EC) No 852/2004, Article 5: permanent procedures based on HACCP principles, including setting critical limits, monitoring and record-keeping - consolidated text on EUR-Lex.
  • Regulation (EC) No 2073/2005, Annex I: microbiological criteria and sampling plans expressed as n, c, m and M - consolidated text on EUR-Lex.
  • Regulation (EC) No 396/2005: maximum residue levels of pesticides - consolidated text on EUR-Lex.
  • Regulation (EU) 2017/625: framework for official controls and documentary checks in the agri-food chain - text on EUR-Lex.
Before / after

The Excel file, then software takes over.

Excel remains an excellent starting point. Its limits appear with volume, number of sites and audit requirements.

Excel file

When volume grows

With Tracklab

What the platform takes over today

  1. Excel file: Each report re-keyed by hand from a PDF

    With Tracklab: Reports gathered and extracted, “not detected” included

  2. Excel file: A changed threshold recalculates old results

    With Tracklab: Threshold, regulation, version and date kept for each status

  3. Excel file: Several copies of the file across sites

    With Tracklab: Laboratory conclusion displayed next to the calculation

Frequently asked questions

Excel template: your questions.

Where can I find a quality control plan in PDF?

The template is provided in Excel format, because only formulas can recalculate a status and indicators. A PDF version remains useful for circulating a frozen plan to an auditor or an external department: the Control plan tab can be exported from Excel with its date and version number in the footer. The PDF then serves as a dated copy, not a working file.

What is the difference between an Excel quality control sheet and a control plan?

The control sheet records a measurement on a given date: who sampled, what, what result. The control plan describes all the points to check, with their thresholds, frequencies and responsibilities. The template offered contains both levels in two separate tabs, linked by the control point ID.

How many control points can this template handle?

The file imposes no technical limit: the constraint is organisational. With a single person updating it and a controlled volume of entries, several hundred lines remain comfortable; as soon as several sites enter data or thresholds change often, the Parameters tab is no longer enough to ensure a reliable history.

Do you have to fill in the thresholds and frequencies yourself?

Yes. No values are pre-filled: thresholds, frequencies, sampling plans and intervals depend on your products, tolerances and methods. The example values on this page are only illustrations: replace them with your own, to avoid unintentionally reusing a value that does not match your process.

When should you move away from Excel?

When the file stops being a working tool and becomes something to consolidate: several sites, many reports to re-key, changing thresholds, a need for a complete history at every review or audit, evidence scattered across folders. At that stage, the template remains useful as a specification of what a centralised tool must contain.

Laboratory analyses module · demo on your data

And when Excel is no longer enough?

Tracklab calculates the compliance status of each parameter in your reports, against your thresholds and the regulations, and keeps a trace of it. The decision stays with your quality teams.

Our clients

Reliable supplier data, managed with Tracklab.

Their quality and purchasing teams collect, control and leverage their supplier data with Tracklab.

150+

companies supported

40,000+

suppliers referenced

90,000+

products and ingredients

Customer testimonial · Bouvard
“Tracklab has eliminated the blind spots that existed in our document monitoring. Every document is analysed, every change is detected and every decision is traceable. This has enabled us to take a real step forward in terms of professionalism and credibility, particularly with auditors and customers.”
EVEllen V.Quality Director, Bouvard Pro
CyberVadis
CyberVadis Excellence rating

Independent assessment of our cybersecurity framework and of the protection of the data entrusted to Tracklab.

They use Tracklab

  • Somapro
  • Jean Niel
  • La Fournée Dorée
  • Nautilus
  • Cérélia
  • Will&Co
  • Neta
  • Diffusions Aromatiques