The clipboard by the mixing vessel
A 50 kilo batch of moisturiser is on the schedule. The compounder prints the batch sheet from a Word template, writes the batch number at the top, and works through it: weigh phase A, record the lot number of the glycerin, heat to temperature, add phase B, homogenise, cool, add preservative and fragrance at the right point, check pH and viscosity, sign each step. Later someone types the key figures into a spreadsheet.
Six months later a stockist reports a customer complaint about a jar. Finding the batch record means going through box files in the office.
Why paper records cause trouble
Paper batch records are a sensible start. They become a problem as the range grows, because every step depends on someone copying correctly and filing correctly.
- The batch sheet template can drift from the current formula if someone edits one and not the other.
- Weighings are written by hand, and a transposed number is easy to miss.
- Raw material lot numbers are copied from the container and sometimes skipped when busy.
- In-process checks are written but not compared with the limits you set until someone reviews the sheet.
- Finding a batch record means knowing which box file it is in.
What the paper costs
Errors on a batch sheet are found late, if at all, often at review after the product is filled. Missing lot numbers make it hard to answer questions about a batch later. Review and filing take time from the person who should be planning the next production. And when a retailer, a brand client or your own quality person asks for a batch record, the search takes a morning.
What your batch records need to contain is for you and your own quality or regulatory adviser to decide. We do not give advice on that. We make the records you decide on quicker to complete, harder to get wrong and easy to find.
Digital batch records we build
- Batch record templates are generated from the approved version of each formula, so the steps, phases and quantities always match the formula in use.
- The batch size is entered and quantities are scaled automatically.
- On a tablet at the vessel, the compounder is guided step by step. Where the scale can connect, weights are read directly; otherwise they are entered and checked against the target with the tolerance you set.
- Raw material containers are scanned, recording the lot number and flagging any lot that is on hold, not yet released or past its date in your records.
- In-process checks such as temperature, pH and viscosity are entered and compared with your limits, with anything outside flagged for a named person to decide on.
- Each step is signed by the person who did it, and the finished record is reviewed and approved in the system, then stored by batch number with everything attached.
| Step | Paper sheet | Digital record |
|---|---|---|
| Template | Word file, may lag the formula | Generated from the approved formula |
| Weighing | Handwritten | Read from the scale or checked on entry |
| Raw material lots | Copied by hand | Scanned, with status checked |
| In-process checks | Reviewed later | Compared with your limits as entered |
| Finding it later | Box files | Search by batch number |
What changes in the production room
The compounder follows the screen rather than a sheet, and errors are caught at the step where they happen. The person reviewing batches checks exceptions rather than every line. When anyone asks about a batch, the full record, with lot numbers and checks, comes up by searching. As you add products, you add formulas, not new paperwork.
Is this your production room?
- Batch sheets are printed from Word templates.
- Weighings and lot numbers are written by hand.
- Batch records are reviewed days after the batch is made.
- Finding an old batch record means searching box files.
- You have found a batch sheet that did not match the current formula.