Your Annual Stocktake Is Hiding Your Losses: Why Food Factories Should Count Less, More Often

By Isaac Muthui, CEO, Tamalaki Business Network Ltd

The stock report says 1,200 bags of sifted maize flour. The storekeeper walks the rack and counts something less. Nobody can say when the gap opened, which lot it belongs to, or whether it is theft, a production over-issue, a dispatch that was never posted, or simply a counting mistake.

So the accountant posts a "stock adjustment" at month-end, the number goes away, and the same gap quietly opens again next month.

This article is for store managers, accountants, production leads and owners of small and mid-sized food and agro factories in Kenya and East Africa: millers, dairies, juice and edible-oil processors, bakeries, snack makers, feed millers and spice or honey packers. It gives you an eight-step stock count reconciliation checklist you can use for a full stocktake or for a weekly cycle count. It is operations guidance, not accounting or tax advice.

Why stock count reconciliation deserves its own routine

A stock count is not just a number for the auditor. In a food factory, the count tells you three things at once:

1. Money: what your raw materials, packaging and finished goods are actually worth.
2. Process health: whether intake, production issues, yields and dispatch are being recorded correctly.
3. Traceability: whether the lots your records say exist are the lots physically on the floor.

When the books and the shelf disagree, one of your other controls has failed somewhere. Reconciliation is how you find out which one.

There is also a records angle. Kenya's Tax Procedures Act, 2015, section 23 requires a person to maintain documents required under a tax law so that tax liability can be "readily ascertained," and to keep them for five years from the end of the reporting period they relate to (subject to the exceptions in the Act). KRA's own eTIMS FAQ points taxpayers back to that same five-year rule. On the food-safety side, EAS 39:2001, the East African code of practice for hygiene in food and drink manufacturing, states in its records clause that records should be maintained of all actions taken to assure the safety of food and kept for a suitable period.

Neither text tells you how to run a stocktake. Together they support a simple floor rule: every stock adjustment should have a count sheet, a recount, a reason and a named approver behind it.

Full stocktake vs cycle count

• Full stocktake: everything is counted at once, usually at month-end or year-end, often with production stopped. Good for a clean baseline. Painful, and it finds problems weeks after they happened.
• Cycle count: a small set of items is counted on a schedule (for example, high-value raw materials weekly, packaging monthly, slow movers quarterly). Problems surface while people still remember what happened.

Most factories benefit from both: a full count to set the baseline, then cycle counts so the next full count holds fewer surprises. The checklist below works for either.

The 8-step stock count reconciliation checklist

1. Freeze or cut off movements for the items being counted

You cannot count a moving target.

• Decide the cut-off time and announce it to stores, production and dispatch.
• Post every receipt (GRN), production issue, production output, transfer and dispatch up to the cut-off before counting starts.
• For a cycle count, stop movements only for the locations or items being counted, not the whole plant.
• Anything that arrives or leaves during the count is kept aside and posted after.

Most "variances" in small factories are timing: a dispatch loaded at 4pm and posted the next morning, or flour issued to the packing line and never recorded.

2. Count blind, by location and by lot

The counter should not see the system quantity.

• Print count sheets (or use a handheld) that list location, item, unit of measure and lot/batch, with the quantity column empty.
• Count in the unit the item is stored in (bags, cartons, litres, kg) and write the unit beside the figure.
• Count partly used bags, open drums and loose packaging separately from full units.
• Count by lot, not just by item. A correct total made of the wrong lots is still a traceability problem.

A count sheet that already shows "expected: 1,200" invites people to find 1,200.

3. Separate the counter from the person who controls the stock

• Use two-person teams where possible: one counts, one records.
• The storekeeper responsible for the stock should not be the only person counting it.
• Rotate who counts which area from one cycle to the next.

This is not an accusation. It is the same separation of duties any auditor will look for, and it protects honest storekeepers.

4. Include every status: released, hold, quarantine, rework, returns and scrap

Stock that is "not really stock" still has to be counted.

• Count items on QA hold, in quarantine, in rework, in the returns bay and awaiting disposal, and record their status on the sheet.
• Make sure the status on the floor (tag, bay, colour) matches the status in your records.
• Count stock at third-party stores, toll processors or in transit as a separate line with its own documents.

A pallet counted as "released" that is physically in the quarantine bay is a finding, even if the total matches.

5. Compare to the system and recount every significant variance

Only now does anyone look at the expected quantity.

• Set a variance threshold before the count (for example, a percentage or a value per item that your finance lead agrees). Items above it get a second, independent recount.
• The recount should be done by a different person, without seeing the first count.
• Confirm units of measure. A 2 kg pack recorded as "1 unit" in one place and "2 kg" in another creates a false variance every time.

Illustration (not real customer data): a mill's system shows 400 bags of a 50 kg raw maize lot; the first count finds 380. The recount finds the 20 "missing" bags sitting in the cleaning section, issued to production on a paper slip that was never posted. The variance was a posting gap, not a loss.

6. Find the root cause before you adjust anything

An adjustment without a reason teaches nobody anything. For each confirmed variance, check in order:

• Timing: receipts, issues or dispatches around the cut-off that were posted late or early.
• Production: issues recorded against the wrong batch, or yields that do not match the recipe. This links directly to batch costing and yield tracking.
• Intake: GRN quantities that were never weighed or counted at the gate. See the supplier intake checklist.
• Dispatch: loads sent without the delivery note being posted, or short picks never corrected. See the finished goods dispatch checklist.
• Expiry and damage: stock written off on the floor but not in the books. This is where FEFO and batch expiry tracking pays off.
• Unit-of-measure or item-code errors.
• Unexplained loss, which should be escalated, not buried.

Write the reason code next to each variance.

7. Approve adjustments with a named person, a reason and a value

• Every adjustment carries: item, lot, location, system quantity, counted quantity, difference, value, reason code and approver.
• Set approval limits: small values approved by the store or production lead, larger ones by finance or the owner.
• Never let the person who counted also approve the write-off of the same stock.
• Post adjustments with the count date, not the date someone got around to it.

If the only record of a write-off is "stock adj Oct" in a journal, you will not be able to explain it later to a buyer, an auditor or KRA.

8. Keep the evidence and track variances over time

• File signed count sheets, recount sheets and the approved adjustment list together, by count date. Given the five-year record rule in section 23 of the Tax Procedures Act, plan to keep them at least that long, and ask your accountant about anything longer.
• Track variance by item and reason across counts. The same item showing a loss every week is a process problem, not bad luck.
• Feed what you learn back into intake, production recording and dispatch.

Illustration (not real customer data): a juice processor runs weekly cycle counts on its top 20 packaging items. For three weeks running, 500 ml bottle caps show a small shortfall with reason "production over-issue." The fix is not a bigger adjustment; it is recording cap rejects on the filling line so the issue quantity matches what was actually used.

Habits that make reconciliation stick

• Count often, count small. A weekly count of your ten highest-value items beats a heroic annual stocktake.
• Post before you count. No count starts while yesterday's slips are still in someone's pocket.
• Count lots, not just totals. Your next mock recall depends on it.
• Reason codes are mandatory. "Other" should be rare and reviewed.
• Share the trend, not the blame. Show the store and production teams the variance chart every month.

Where an ERP helps

Paper count sheets and a spreadsheet can work for a small store with few items. It gets hard when you have many lots, several warehouses, partial bags and stock on hold.

FactoraERP keeps stock by item, lot, location and status, records receipts, production issues, output and dispatch as they happen, and supports blind count sheets, recounts, variance reason codes and approval of adjustments, so each adjustment links back to a count and a named approver. See factoraerp.com.

Free download: eTIMS readiness checklist for factories

Stock movements, adjustments and invoices increasingly have to tell the same story for Kenyan manufacturers. If you want a free eTIMS readiness checklist for factories, sign up for the FactoraERP Insights newsletter at https://isaacmuthui.substack.com. You will get practical operations notes for food and agro manufacturers. No spam; unsubscribe anytime.

FAQ

What is stock count reconciliation?
It is the process of comparing physically counted stock with the quantities in your records, recounting significant differences, finding the root cause of each variance, and posting approved adjustments with a reason and a named approver.

How often should a food factory count stock?
Many factories do a full stocktake at period-end and cycle counts in between: high-value or fast-moving raw materials more often, slow movers less often. Choose a schedule your team can actually keep.

What is a blind count?
A count where the counter does not see the expected system quantity, so the figure written down is what is physically there rather than what the report says should be there.

Should we adjust the system to match the count straight away?
Only after a recount confirms the difference and the root cause is recorded. Adjusting immediately hides posting errors that will repeat.

How long should we keep count sheets?
Section 23 of Kenya's Tax Procedures Act, 2015 sets a general five-year retention period for documents required under a tax law, with exceptions. Treat count sheets and adjustment approvals as part of that record set and confirm specifics with your accountant.

Can a small factory do this without software?
Yes. Pre-printed blind count sheets, a cut-off rule, a recount threshold, reason codes and a signed adjustment list cover the basics. Software helps when lots, locations and volumes outgrow paper.

---

Isaac Muthui, CEO, Tamalaki Business Network Ltd

---

Originally published on the FactoraERP blog: https://factoraerp.com/en/blog/stock-count-reconciliation-checklist-food-factories-kenya