ChefSums: Recipe Costing & GP

Free fridge and freezer temperature log sheet (UK, Excel and printable PDF)

Download the free template ↓

A fridge and freezer temperature log is the sheet where you write down the temperature of every fridge, chilled display and freezer at each check, initial it, and note what you did when a reading was out. This free one covers a month for five units with a morning and an afternoon column each; in the Excel version, fridge readings above 5°C turn amber, above 8°C red, and freezer readings above -18°C amber.

The limits printed on it come from the Food Standards Agency's Safer Food, Better Business pack and Food Standards Scotland's CookSafe: fridges and chilled displays set at 5°C or below so that chilled food stays at 8°C or below, and frozen food kept at -18°C or below. The sheet also counts the readings, the readings over the limit and the opening checks left blank, and its second page has a probe check and what to do when a reading is out. The printable PDF is a blank month on one A4 page plus a worked example. The log supports, and does not replace, your food safety management system.

Download the free template (.xlsx)

Direct download — no email address, no sign-up. Opens in Excel, Google Sheets and Numbers.

Download the printable PDF

Worked example: the first four days of November

The file opens with four days already filled in for five units. Each cell shows the morning and afternoon readings in °C:

DayWalk-in fridgeLarder fridgeGrill fridgeDessert fridgeUpright freezerInitialsNotes
13 / 44 / 54 / 53 / 4-20 / -19AB
23 / 44 / 44 / 93 / 3-19 / -20CDGrill 9°C: door left open. Food 6°C. Shut, 4°C by 17:30
32 / 43 / 54 / 53 / 4-15 / -19ABFreezer -15°C: delivery going in. Food hard. -19°C by 10:30
43 / 44 / 43 / 5(blank) / 4-20 / -20CDDessert fridge missed at opening; 4°C at 14:00

The grill fridge's 9°C on day 2 turns red because it is above 8°C. A cabinet reading is the air, so the cook probed between packs: the food was at 6°C. The door was shut and the fridge was back to 4°C by 17:30, and the note records all of it. The freezer's -15°C on day 3 turns amber because it is above -18°C; it was taken while a delivery was going in, the food was still hard, and the next reading was -19°C.

The larder fridge reads 5°C on days 1 and 3 and is not flagged, because the sheet flags readings above 5°C, not at it. On day 4 nobody took the dessert fridge reading at opening, so the "Missed AM" line under that unit shows 1. The totals for the four days read 39 readings, 2 over the limit and 1 opening check missed.

How to fill it in

  1. Name each unit and set its type. Up to five units across the top. Pick Fridge or Freezer from the drop-down under each name; the type decides which limit the readings are checked against. A chilled display counts as a fridge.
  2. Check the limits at the top. 5°C for fridges and -18°C for freezers are filled in. If your food safety system sets a colder limit, change the figure and the flags follow it. The 8°C food limit that turns readings red should stay as it is.
  3. Take the opening reading. Check every unit at least once a day, starting with your opening checks, and type the number only (4, not 4°C) so the sheet can count it.
  4. Take a second reading later in the day. CookSafe advises checking fridges again at another part of the day, which is what the PM column is for. Avoid checking straight after the door has been open for a while or during a defrost cycle.
  5. Initial the day and note anything out of range. Write what the reading was, what you found and what you did. Page 2 of the sheet lists the steps: check again, probe the food, move it if the unit is not holding, throw away chilled food that has been out of chill for more than four hours.
  6. Sign off the month and check the probe. Put a name in Signed off at the end of the month and log the probe check on page 2. Copy anything from the notes column into your food safety diary.

The temperatures on the sheet, and where they come from

Air temperature and food temperature

The display or dial on a fridge shows the air temperature inside the cabinet. That is fine for day-to-day checks, but check it now and then against a probe or fridge thermometer, and when a reading is high, probe the food itself between packs with a clean, disinfected probe. That is why day 2 in the example has two figures in the note: 9°C on the display and 6°C in the food.

The monthly probe check

A probe that reads wrong makes every food check you do with it wrong. Check it as often as the maker's instructions say, or regularly, for example once a month: in iced water it should read between -1°C and 1°C, and in boiling water between 99°C and 101°C. If it is outside either range, replace it or send it back to the maker to be calibrated. The second page of the sheet and of the PDF has room to record it.

Open it in Google Sheets or print it

Upload the .xlsx to Google Drive and open it with Google Sheets. The counts use COUNT, COUNTIF and SUMPRODUCT and the flags are conditional formatting, all of which Google Sheets supports. In Excel it prints on A4 portrait: the month on page 1, the probe check and the out-of-range steps on page 2. For a pen-and-paper log on the fridge door, print page 1 of the PDF; flagged readings in its worked example have a heavy border as well as a colour, so they still read on a black and white printer.

Questions people ask

What temperature should a commercial fridge be in the UK?

Set it at 5°C or below. That is the FSA's advice for fridges and chilled displays, so that chilled food stays at 8°C or below, which is the legal limit in England, Wales and Northern Ireland and the recommended limit in Scotland.

What temperature should a freezer be?

Frozen food should be kept at -18°C or below. Safer Food, Better Business and CookSafe both give that figure, and it is the freezer limit on this log.

How often should fridge temperatures be checked?

At least once a day, starting with your opening checks, according to Safer Food, Better Business. CookSafe advises checking every fridge, chill and freezer at the start of the working day and the fridges again later in the day. The sheet has an AM and a PM column for each unit.

How long should I keep temperature records?

Neither Safer Food, Better Business nor CookSafe gives a fixed period; CookSafe says records "must be kept for a reasonable period of time". Ask the environmental health team at your local council what they expect for your business.

Do I still need my Safer Food, Better Business diary?

Yes. This log supports your food safety management system and does not replace it. When something goes wrong, SFBB asks you to write down what happened and what you did in your diary, so copy anything from the notes column across.

Can I log more than five units?

Yes. Copy the sheet once for each further group of five units and name each copy, for example "Fridges 1 to 5" and "Fridges 6 to 10".

When you outgrow it

The same layout comes as a kitchen cleaning schedule and a mise en place station checklist, and the allergen matrix and stock take template cover two more jobs on paper. When you want the money side of the kitchen too, the free food cost calculator works out cost per portion and GP, and the ChefSums recipe tool scales a recipe and prints a prep sheet.

Stop guessing your margins. Price any dish in seconds with the free food cost calculator, or get a ready-made Excel costing template for your whole menu — built by a working chef.

Run the free calculator → · See the templates → · Save your recipes free →

Occasional costing tips. Unsubscribe any time. Privacy