Batch production records for small makers: what to track and why

If you make products in batches — chocolate, candles, skincare, soap, baked goods, preserves — keeping proper batch production records is one of the most important things you can do for your business. It protects you legally, helps you control your costs, and gives you the information you need to improve your products over time.

Yet most small makers start with a notebook or a spreadsheet and find, as their business grows, that neither quite fits the job. Here’s what batch records are actually for, what you need to include, and how to get properly organised.

Why batch records matter

Traceability. If a customer reports a problem, or a supplier tells you one of their ingredient lots was contaminated, you need to be able to answer one question quickly: which of my finished batches used that ingredient? Without records, you either recall everything or recall nothing. With proper records, you can identify the affected batches precisely.

Legal requirements. In the UK and EU, food businesses and cosmetics producers are required to maintain traceability records. The rules vary by product type, but the principle is the same: you must be able to trace ingredients forward to the finished product and backward from the finished product to the ingredient source.

Cost control. Do you know what your most recent batch actually cost to make? Not what you budgeted — what it actually cost, using the prices you paid last time you restocked? Batch records tied to your ingredient prices give you the answer every time.

Quality and consistency. When a batch turns out particularly well — or not as expected — records let you go back and see exactly what you used, in what quantities, on what date. That’s how you reproduce success and diagnose problems.

What to record for each batch

• A unique batch code. A consistent format like CHOC-2026-0042 or CANDLE-JUN-001 lets you find any batch instantly and reference it on labels.
• Date of production. The date the batch was made, not the date it was packaged or sold.
• The recipe or formula used, including the version if you have more than one.
• Each ingredient: name, the supplier lot or batch number from the delivery, the quantity used, and the ingredient’s expiry date.
• Quantity produced: how many units, or the total net weight of the batch.
• Who made it. For a one-person business this is obvious, but it’s worth recording.
• Any observations. Anything unusual about this batch — a different supplier, a substitution, an equipment issue.

Why ingredient lot numbers matter so much

When a food safety or cosmetics ingredient issue arises, it almost always involves a specific delivery — a specific lot number — rather than an ingredient in general. If you record which lot of shea butter, which batch of cocoa mass, or which delivery of fragrance oil went into each of your batches, a problem with one delivery narrows your concern to a handful of batches rather than everything you’ve ever made.

This is not a theoretical concern. Ingredient recalls happen regularly across the food and cosmetics industries. Makers who can respond quickly and precisely are far better placed than those who have to guess.

How most small makers get started — and where they get stuck

Most small makers begin with a paper notebook. It works, up to a point. The problem is that notebooks can’t be searched. Finding which batches used a particular ingredient lot means leafing through every page.

Spreadsheets are a step up. A well-designed spreadsheet can capture all the fields above and can be searched. The problem comes when you need to link information across sheets — the ingredient inventory, the batch records, the sales data — and the spreadsheet starts growing into something that takes longer to maintain than it saves.

The next step is purpose-built software that links all of this together: ingredients link to recipes, recipes link to batches, batches link to sales. When an ingredient price changes, every product’s cost updates. When you need to trace a lot number, the answer is one search away.