Inventory Management

Year-end inventory count: no more surprises

In this article

Nori.mx7 min read

CYCLE COUNTa little every dayand blindVariance sheetNP-1042shortNP-2210overNP-0375shortCause?Adjusted, no causeRecording gap above3 %of inventory costCFF art. 83

Every December the same thing happens in plenty of border plants. The year-end shutdown is used for the count, tags go out, people count all weekend and on Monday the variance sheet arrives. One part number is short, another is over, and nobody can explain either one.

The adjustment gets made because the books have to close. The cause never turns up because twelve months have gone by. And in January the system starts drifting away from the floor again, same as last year.

The annual count is not the problem. It is the only moment of the year when someone compares the system against reality, which is why everything that piled up comes out at once.

What the law asks of you at year end

For a Mexican company, the Income Tax Law (Ley del ISR) asks for two things that meet here. Article 76, section IV, requires taking an inventory of stock on hand as of the end of the fiscal year. And section XIV of the same article requires inventory control under a perpetual inventory system: the records have to know how much there is at any moment, not once a year.

The regulations of the Federal Tax Code (Reglamento del Código Fiscal) spell it out. Article 33, part B, section XV, requires inventory records that identify each unit or type of goods, their increases and decreases, and the stock at the start and end of each month and at fiscal year end.

The Federal Tax Code (Código Fiscal) sets the limit. Its article 83 treats as an infraction, among other things, omitting or altering the record of stock when the amount exceeds 3% of inventory cost, and also failing to follow the inventory control procedure that tax rules require.

Read together, the law does not ask for a well-run annual count. It asks for records that were right all year, and the December count is where that gets checked. We are not accountants: how this applies to your company is for yours to confirm. What we can tell you is what the system has to do so that conversation is short.

If your plant runs under an IMMEX program there is one more layer. Anexo 24 inventory control has to account for every temporarily imported piece, so a count variance turns into a question about customs entries. We already wrote about what Anexo 24 demands from your software.

Why the December count almost never matches

Variances are almost never theft. They are movements that happened on the floor and never reached the system, or reached it wrong. These are the ones we see most:

  • Consumption deducted by formula. The system backflushes raw material from the bill of materials when finished goods are reported. If the line used more than the bill says, through scrap or a process change, the difference stays on the floor and the system never hears about it.
  • Scrap nobody records. Whatever is thrown out without a transaction still exists in the system.
  • Late transactions. A receipt entered on Monday for something that arrived on Friday leaves the system two days behind. If the count lands in between, the variance exists on paper and not on the floor.
  • Units of measure. Bought by the kilo, received by the box, consumed by the piece. One wrong conversion factor creates variances every day without anyone moving anything.
  • Material that is not yours or not available. Consignment, quality hold, transfers between warehouses. If it is not kept apart, it gets counted where it does not belong.
  • Locations that only exist in someone’s memory. The total can match and still nobody finds the part. We covered it in when a maquiladora needs a WMS.

None of these is hard to fix on the day it happens. The problem is finding it eleven months later.

What the surprise costs

  • The count weekend. Plant down, people on overtime and, if something does not match, a recount.
  • The adjustment with no cause. You adjust to close, and the adjustment is a number someone signs without being able to explain it. If the variance is large, it is exactly the line an auditor asks about.
  • A year of decisions on the wrong number. You bought what was actually over and ran short of what the system said you had. That never shows in the December adjustment, but it has already been paid for.
  • The same adjustment next year. If nobody found the cause, the variance comes back.

Count a little every day

Plants where December brings no surprises do not count better once a year. They count a little every day. It is called cycle counting and it works like this:

  • Rank by importance. A few parts carry almost all the value or almost all the movement. Count those often; the rest less often.
  • Count blind. The counter does not see what the system says. If they see it, they tend to find that number.
  • Investigate every variance the same day. While the cause is fresh: the receipt nobody entered, yesterday’s scrap, the conversion factor. Fix the cause, not just the number.
  • Adjust with a reason and a signature. Every adjustment records why it was made and who approved it. At year end, that log is the explanation you do not have today.

The year-end count still happens, because the law requires an inventory at year end. What changes is that it stops being a search and becomes a confirmation.

What you can do before December

There are a few weeks left. Not enough to change systems, but enough to make this close go better:

  • Set the cutoff. Day and time when receiving and shipping stop, and who signs off. Whatever arrives later waits.
  • Clear the backlog before the cutoff. Receipts, returns, scrap and transfers.
  • Separate what does not count as yours. Consignment, quality hold and customer material, with visible tags.
  • Check the conversion factors on your highest-moving part numbers.
  • Start counting your highest-value parts now. Two or three weeks of cycle counting before the annual count tell you where the variances will be.
  • Decide the recount rule. Above what variance a location gets counted again, and who reviews it.

Where a system comes in

All of the above can be done with discipline and spreadsheets. The hard part is keeping it up for twelve months, and that is where a system helps:

  • Capture on the floor, with a scanner and at the moment it happens, not at the end of the shift.
  • Scheduled, blind cycle counts, from a terminal or a phone.
  • Adjustments with a reason, approval and a log, which at year end read as an explanation and not a mystery.
  • Stock at the start and end of each month, as the regulations ask, without building it by hand.

We recently put a warehouse system with scanning terminals into production for an industrial multinational; the case is written up for whoever makes the call. If you want to see how it would look with your inventory, a twenty-minute call is enough to go over how you count today, and then there is a free prototype you test with a sample of your data. If it does not convince you, it stops there.

And if you are not sure yet whether yours is a system problem or a process problem, Chira asks about your operation and tells you in writing.

References

Related service

Inventory Management

No unexpected stockouts and no capital asleep in excess inventory.

See the service

Articles on this service

Receiving · sortable sheetLotProductQtyReceivedFromCilantro6 casesPeppersQueso frescoTomatoes8 data points per lot at receivingFDA askshand it over in24 hoursEnforcedJul 202028Keep 2 years

Inventory Management

Which lot was the cilantro you sold?

The FDA traceability rule asks for the lot of peppers, fresh cheeses, cilantro and other foods, and for it within 24 hours. What data to keep and from when.

6 min read

By balance1,200piecesfrom which entry?In layers, by customs entryMarch entrytemporary import400June entrytemporary import500Exported in Augustinside finished goods280Scraphas to reconcile too20

Inventory Management

Annex 24: what it asks of your inventory system

It is not a report you run at month end. It is a way of recording every movement that most inventory systems were never designed to handle.

6 min read