A log sheet is a page of rows where each row is one thing that was checked or done, written down at the time, by the person who did it. That's all it is, and it's why almost every log looks alike underneath: a date and time, what was checked, the reading or result, the target it's compared with, whether it was within target, what was done if it wasn't, and initials. A temperature log, a cleaning log and a receiving log are the same sheet with the middle columns renamed. Below is a general log sheet with a worked example, ten kinds of log a small food or craft business keeps, how to make one in Word or Excel, and the file.
The short version
- One row for each check, written when it happens.
- Date, time, what, result, target, within target, action, initials.
- The action column is the one that matters. A reading out of range with nothing beside it is a problem on paper.
- A second person reviews the sheet and initials it.
- Cross out mistakes with one line. Don't erase.
- Keep one log for one purpose. A sheet that logs everything gets filled in by no one.
- TaroStack records batches, receiving and counts as they happen. More below.
A general log sheet
A made-up bakery's daily checks.
| Date | Time | What was checked | Result | Target | Within? | Action taken | Initials |
|---|---|---|---|---|---|---|---|
| Nov 16 | 7:10 AM | Bench scale, 500 g check weight | 500 g | 499 to 501 g | Yes | KS | |
| Nov 16 | 7:20 AM | Mixer bowl and hook clean and dry | Done | Done | Yes | KS | |
| Nov 16 | 2:45 PM | Bench scale, 500 g check weight | 503 g | 499 to 501 g | No | Re-zeroed, rechecked at 500 g. Afternoon batches reweighed | ML |
| Nov 17 | 7:05 AM | Bench scale, 500 g check weight | 500 g | 499 to 501 g | Yes | ML |
The third row is what a log is for. The scale read 3 g heavy, the person wrote down what they did about it, and they also dealt with what the bad scale had already touched: the afternoon's batches. A log full of "Yes" proves little. One "No" with a sensible action beside it shows the system working.
The target, 499 to 501 g, is this bakery's own. Yours comes from whatever you're controlling: a recipe's tolerance, your scale's accuracy, or a limit in your food safety plan.
What makes an entry count
- Written at the time. Filling in a week of rows on Friday is easy to spot: one pen, one handwriting, every time on the hour.
- By the person who did it, with their own initials.
- In ink, on paper. A wrong entry gets a single line through it, the correction beside it, and initials.
- Reviewed. A "Checked by" column, initialled by someone else daily or weekly, means a missed check is noticed within days.
- Kept. How long depends on what the log is for. For HACCP records, see how long should HACCP records be kept.
Ten kinds of log
Each of these has its own article and file here.
| Log | What it records | Written |
|---|---|---|
| Temperature log | Readings from coolers, freezers and hot holding, against your limits | At set times each day |
| Receiving log | Each delivery: supplier, items, lot numbers, condition, who accepted it | Each delivery |
| Cleaning log | What was cleaned, with what, and who checked | Each clean |
| Batch record | What was made, from which lots, how much came out | Each batch |
| Cooling log | Time and temperature as cooked food cools | Each cooled batch |
| Waste log | What was thrown out, how much, and why | As it happens |
| Equipment maintenance log | Services, repairs and calibration checks | Each service |
| Pest control log | Inspections, findings, and what was done | Each visit or check |
| Employee training log | Who was trained in what, and when | Each session |
| Shipping log | What left, to whom, and which lots | Each shipment |
Logs for one trade: scale calibration log, soap making log, kombucha brew log, harvest log template. Which records a food business needs at all is in food business record keeping.
How to make a log sheet in Word or Excel
In Word, insert a table with a column for each heading above and about twenty rows. Put the log's name, the place and the month at the top of the page, and a line at the bottom for the reviewer's signature. Set the page to landscape so the "Action taken" column is wide enough to write in. Print a stack.
In Excel, type the headings in row 1, widen the columns, and print with gridlines. A spreadsheet earns its place when the sheet should work something out, or when you want to sort and filter a year of rows by date.
Either way, design it for a pen. Rows tall enough for handwriting, no column nobody will fill in, and one page for one period, so a full page is a finished record you can file.
Get the file
Download the log sheet examples. Two sheets and a read-me: the general log sheet with the bakery's example rows and room for more, and the list of ten logs with what each records. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Paper logs are good at one thing: proving a check was done. They're poor at being searched. When a customer complains about a loaf from three weeks ago, the answer is on four clipboards: the receiving log for the flour, the batch sheet for the bake, the scale log for that morning, the shipping log for where it went. Each is right. None of them points to the others.
How TaroStack does it
TaroStack records the logs that follow the goods, joined up.
Receiving records each delivery, with its supplier, lot and use-by date. That's the receiving log, searchable.
A batch notes the lots it used, automatically, and what it made. Batch records carry your own checklist fields, so the checks your process calls for are recorded with the batch.
What ships is recorded by lot, against the customer.
Every adjustment carries a reason, so the waste log is a report.
Every lot is traced from the supplier's lot to the customers that got it.
| The log | On a clipboard | In TaroStack |
|---|---|---|
| Receiving | A row a delivery | Each delivery, as a lot |
| Batch | A sheet a batch | The batch, with its lots and checks |
| Waste | A tally | Adjustments by reason |
| Shipping | A row a shipment | What shipped, by lot and customer |
TaroStack isn't a temperature log, a cleaning schedule or a pest control record: keep those on paper or in the tool made for them. Receiving, batches, lots and adjustments are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
