Food lot stock movement register
Explain the quantity and location of each food lot through receipts, use, transfers, losses and adjustments.
- Lot and opening balance
- Actual movements
- Reconciliation
Per event and review · Includes example records and blank register rows
One check.
One clear answer.
Record product, supplier lot and internal identifier without replacing the original code.
Tap an answer to continue
Interactive example · No account needed
A quick check.
Then back to your day.
A clear starting point
Make it your own
Start right here
A little structure.
A more confident shift.
Explain the quantity and location of each food lot through receipts, use, transfers, losses and adjustments.
Make it specific to your site.
Agree units and movement types. Record one lot and one movement per row; use a shared reference for paired transfers.
Food lot stock movement register
Site: ____________________ Date: ______________
Completed by: _____________ Reviewed by: _____________
Working register
Fictional worked example. Use the blank rows for your own records.
| Movement ID | Date / time | Product | Lot | Movement type | From | To / production batch | Quantity | Unit | Evidence / reason | Operator |
|---|---|---|---|---|---|---|---|---|---|---|
| MOV-01 | Example date 08:00 | Ingredient A | ING-A | Production use | STORE-01 | PREP-1 | 8 | kg | BATCH-01 | Operator A |
01Lot and opening balance
Record product, supplier lot and internal identifier without replacing the original code.
Record opening balance, unit, stock location and count date.
Reference the receipt or preceding verified closing balance.
02Actual movements
Record movement reference, date, time and operator.
Record from/to locations, movement type, actual quantity and unit.
Link ingredient use to the production batch; distinguish ingredient mass from finished-product output.
Record loss, return or adjustment with reason and authorisation.
03Reconciliation
Calculate expected closing stock using consistent units.
Record actual count, difference and investigation reference.
Assign unresolved differences to an owner and document the review.
Close the loop
Reconcile opening stock + receipts − use − dispatch − loss ± adjustments to closing stock. Investigate differences and preserve correction history.
Kivloo · kivloo.app/template-library/lot-stock-movement-register
How to use the downloaded checklist
Open the CSV in your spreadsheet app. Adapt the checks, enter your approved criteria and add any missing site requirements. Use the result, action, owner, due date and verification columns to document follow-up.
Keep the original observation when a check fails. Record the corrective action and verification separately so the full sequence remains clear.
Ready for a
digital everyday?
Create your own digital templates in Kivloo and keep site reports and photo evidence together.