Cold chain · Free Excel template

Reefer Vehicle Qualification and Temperature Mapping Record

An Excel record for mapping the temperature inside a refrigerated truck or van and qualifying it for temperature-sensitive products. Paste the readings from up to 16 data loggers, and each test sheet finds the warmest and coldest positions, counts the minutes out of range and gives a result. A vehicle record collects the summer, winter and hold-over tests into one qualification status.

Free: enter your name, email and job title and we email you the file. It works in Excel 2019 or later, Microsoft 365, Google Sheets and LibreOffice Calc, with no macros.
  • 11 sheets, no macros
  • Five tests with automatic results
  • Calibration and re-mapping due dates
safee-reefer-temperature-mapping-record-en.xlsx
SheetTest typePayloadMinutes out of rangeWarmest positionColdest positionResult
Test 1Summer, maximum loadMaximum0P10 — 7.5 °CP03 — 3.3 °CPass
Test 2Summer, minimum loadMinimum10P10 — 9.3 °CP03 — 3.5 °CFail
Test 3Winter, maximum load
Test 4Winter, minimum load
Test 5Hold-over (unit off)Minimum30 to first excursionPass
Example results for a 2 to 8 °C product. Test 2 failed because the rear door position went above 8 °C during a long door opening.
What's in the file

One record per vehicle, from logger layout to qualification status

You set the logger positions once, paste the readings after each test, and the record keeps the results, the calibration of every logger and the date of the next study in one workbook.

  1. 01

    Vehicle record

    Body and refrigeration unit details, products and required range, the results of all five tests, the qualification status, hold-over time, approved positions for routine probes, zones not to load and signatures.

  2. 02

    Logger positions

    Up to 16 positions with zone, height, the logger in each one and its calibration status. The example layout covers supply and return air, product near the delivery air, in restricted airflow, near the walls and near the door.

  3. 03

    Tests 1 to 4: seasonal mapping

    Summer and winter, each at maximum and minimum load. Each sheet calculates min, max, mean and minutes out of range for every position, the warmest and coldest positions, and the result.

  4. 04

    Test 5: hold-over

    The unit is switched off after the temperature settles at the mid-range set point. The sheet calculates the minutes until the first product position leaves the range.

  5. 05

    Calibration register

    Each logger with its accuracy, last calibration, certificate, next due date and status. Each test flags loggers whose calibration expired before the test date.

  6. 06

    Re-mapping and settings

    Next study date for each vehicle, with triggers such as a replaced unit that bring it forward. Settings hold the range, interval and allowances, and the sources with the date they were checked.

What is temperature mapping of a refrigerated vehicle?

Temperature mapping measures the temperature at many points inside a space over a set period, to find the warmest and coldest spots. SFDA's guideline defines it as a three-dimensional study of temperature distribution. In a refrigerated vehicle, the study shows how the temperature near the unit differs from the temperature by the rear door, on the floor and inside a full pallet, in hot and cold weather and with different loads.

Qualification uses the mapping to show that a vehicle keeps products within their range on real routes. The result also tells you where to put the probes you use every day: at the warmest and coldest positions the study found.

What does SFDA require for temperature monitoring in vehicles?

SFDA's Guideline of Good Storage and Distribution Practices (OPS-G-112, version 2.1, 4 February 2024) covers medicines for human and veterinary use, active substances, excipients and cosmetics. Its Vehicle and Transport section says:

  • Item 14: electronic monitoring devices that can be linked to the authority's systems, activated from dispatch until the shipment arrives, distributed at different locations and heights according to the approved temperature mapping, regularly calibrated, and linked to the receiving and issuing records of each shipment.
  • Items 15 and 22: temperature and humidity records kept for the shelf life of the product plus one year, and made available for inspection by SFDA.
  • Item 4: modern technology such as GPS should be used where possible to protect products in the vehicle.

The guideline does not set the number of loggers, the logging interval, the calibration interval or how often to repeat the mapping. Those come from your quality procedures and the product owner. For food, the guideline does not apply, so check your authority's current requirement.

How to qualify a refrigerated vehicle, step by step

The method in this template follows the World Health Organization technical supplement Qualification of refrigerated road vehicles (Supplement 11 to Technical Report Series 961, Annex 9, May 2015).

  1. Check the vehicle first: body and unit details, insulation and cooling performance, and that maintenance is up to date.
  2. Calibrate the loggers and record each one with its certificate.
  3. Run a static mapping before road tests to find the likely warmest and coldest positions.
  4. Run four field tests on a typical worst-case route with drops and door openings: maximum and minimum load in the warmest season, and maximum and minimum load in the coldest season.
  5. Run a hold-over test: settle the temperature at the mid-range set point, switch the unit off, and record how long until a product position leaves the range.
  6. Approve the result: qualified when all four field tests pass. WHO treats the vehicle as provisionally qualified after the first two tests, so full qualification can take up to six months.

Where should data loggers go in a reefer truck?

WHO lists the minimum recording points: outside ambient, refrigeration air delivery and return, product near the delivery air, product in areas of restricted airflow, product near the walls and product near the doors. The example layout in the template covers these with 14 positions and leaves two spare. Fix loggers inside the product packaging where you can, and keep the warmest and coldest positions attached to the load until the last drop. Mark supply and return air as not counting for acceptance, because they measure air, not product.

How does the record calculate the result?

Minutes below range = readings below the low limit × logging interval Minutes above range = readings above the high limit × logging interval Minutes out (test) = logging times when any product position is out × interval Warmest position = product position with the highest reading Coldest position = product position with the lowest reading Test result = Pass when minutes out ≤ allowed and every logger was in calibration on the test date Hold-over time = first excursion time − unit switch-off time Qualified = summer and winter tests at maximum and minimum load all pass

The allowed minutes out of range is 0 by default, which matches the WHO acceptance criterion that product temperatures stay in range for the whole route. The 2 to 8 °C range, the 5-minute logging interval, the 12-month calibration and re-mapping intervals are examples on the Settings sheet; replace them with your own.

Worked example: one summer test fails at the rear door

A 7-meter refrigerated truck carries medicines at 2 to 8 °C with a set point of 5 °C. Fourteen loggers record every 5 minutes over 24 hours in July, with outside temperatures up to 46 °C.

  • Test 1, maximum load: the warmest position is the rear door (P10) at 7.5 °C during drops, and the coldest is near the delivery air (P03) at 3.3 °C. No product position leaves the range: Pass.
  • Test 2, minimum load: with one pallet, a long door opening at the third drop takes P10 to 9.3 °C. Two readings are above 8 °C, so 2 × 5 = 10 minutes out of range: Fail.
  • Test 5, hold-over: after the unit is switched off, the first product position passes 8 °C after 30 minutes. That is the time the driver has to restart the unit or move the load.
  • Status: Not qualified until the failed test is repeated. The quality team fits a strip curtain at the rear door, marks the first 30 cm behind the door as a zone not to load, and repeats Test 2.

Common mistakes in reefer temperature mapping

  • Testing an empty truck only. Load changes airflow; WHO asks for maximum and minimum payload.
  • Testing in one season. A truck that holds 5 °C in winter can fail on a summer afternoon.
  • Loggers out of calibration. A study with an expired logger cannot support the result.
  • Measuring air instead of product. Supply air is far colder than the pallet next to the door.
  • Skipping door openings. Drops are where most excursions start, so the test route needs them.
  • Never repeating the study. A new unit, body repairs or unexplained readings mean the old map no longer applies.

What the template does not cover

The record calculates the study you run; it does not read loggers or connect to SFDA systems. It assumes all loggers start together and use the same interval. Ranges, allowances, calibration and re-mapping intervals come from the product owner and your quality system, and requirements change, so check your authority's current requirement. The record supports your qualification report; it does not replace your quality procedures. For daily excursions on each shipment, use the Cold Chain Temperature Excursion Log.

Related Safee solution

Watch the warmest and coldest positions on every trip

After the study, Safee's Temperature module takes readings from one or more sensors per vehicle, so you can fit probes at the positions the mapping found. The Temperature in Range alarm fires when a sensor leaves the range for longer than the time tolerance you set, and the Temperature Explorer exports current and past readings to Excel.

  • Several sensors per vehicle, each with its own type, name and color.
  • Temperature in Range alarm with time and temperature tolerance, everywhere or inside or outside geofences.
  • Fridge Door module with up to 8 door sensors and an open-door report.
  • Thermo King Explorer with set point, return and discharge air temperatures and unit alarms.
FAQ

Questions about reefer qualification and temperature mapping

Want readings from the warmest and coldest positions on every trip? Talk to Safee.

What is the difference between temperature mapping and qualification?

Mapping measures the temperature at many points to find the warmest and coldest spots. Qualification uses mapping and other tests to show that the vehicle keeps products in range on real routes, in both seasons and with different loads.

How many data loggers do I need for a reefer truck?

Neither SFDA nor WHO sets a fixed number. WHO lists the minimum points to cover: ambient, supply and return air, product near the delivery air, in restricted airflow, near the walls and near the doors. The example layout uses 14 positions; a longer trailer may need more.

Does SFDA require temperature mapping of vehicles?

SFDA's GSDP guideline asks for monitoring devices placed according to the approved temperature mapping, and for records kept for the shelf life plus one year. It does not set how the vehicle mapping is done, so the template follows the WHO method. Check your authority's current requirement.

How often should a refrigerated vehicle be re-mapped?

Neither guideline sets a fixed interval. Set one from your risk assessment, and repeat the study after a body modification, a new refrigeration unit or unexplained changes in routine readings. The Re-mapping sheet tracks both.

What is a hold-over test?

A test of how long the load stays in range after the refrigeration unit stops. WHO describes it as a temperature-control failure test: settle the temperature at the mid-range set point, switch the unit off and time the first excursion.

Can I use the template for frozen products?

Yes. Change the range on Settings, for example to −25 to −15 °C, or on each test sheet. All statistics and results follow the range you enter.

Does the file work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. In Excel it needs Excel 2019 or later, or Microsoft 365. It also works in LibreOffice Calc.

Next step

Keep the mapped positions under watch

Bring your mapping results, and we will show you how Safee reads several temperature sensors and door sensors on each refrigerated vehicle and alerts you when one leaves the range.

Related tools and templates

More for refrigerated transport

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top