Year-end inventory: how to prepare and secure it in a manufacturing SME
A year-end inventory comes down to three steps: prepare, count, validate. Here is how to make each step reliable in a manufacturing SME, avoid discrepancies between the count and the validation, and update your numbering sequences before the new year.
From count to validation: securing your year-end closing
Every year end, the stock recorded in your ERP has to be checked against the stock actually sitting on your shelves.
For a manufacturing SME, the year-end inventory is both an accounting requirement and a demanding logistics operation: raw materials, work in progress, finished goods, sometimes several warehouses. Its reliability determines how stock is valued in the annual accounts.
The difficulty rarely lies in the count itself. It tends to arise beforehand, when the stock configuration no longer reflects the shop floor, and afterwards, when the validation takes place several days after the count. This guide goes through each step, including one that is often left to the last minute: updating numbering sequences at the turn of the year. The legal references cited apply to companies operating in France.
In a nutshell: a year-end inventory means physically counting stock to check that it matches the stock on record, and its reliability depends mainly on three moments, the preparation before the count, the handling of stock movements between the count and the validation, and the archiving once the inventory is validated.
In this article
1. Why the year-end inventory needs preparing
An inventory is the operation used to check the existence and value of stock at a given date, usually the end of the financial year. In France, the Commercial Code requires businesses with commercial status, which includes companies such as SAS, SARL and SA, to carry out this inventory check at least once every twelve months (article L123-12).
What is at stake during the inventory
2. Before the count: make sure the ERP reflects the shop floor
Over the year, the physical layout of the stock changes: new aisles, reassigned locations, an additional warehouse. If the ERP has not kept up with these changes, count lists no longer match what teams find on the floor. A few checks, a few weeks before the chosen date, prevent most difficulties.
Preparation checklist
3. Organizing the physical count
A physical count means recording, item by item and location by location, the quantities actually present. How it is organized depends on the size of the stock and the number of sites, but a few principles apply to most manufacturing SMEs.
Principles of a reliable count
4. Between count and validation: the critical point
In many companies, the count takes place in the last days of December and the inventory is validated in early January. This is one of the most sensitive points of the inventory: between the two dates, operations have resumed and stock movements have been recorded.
If these movements are not handled correctly, the validation compares the count with a theoretical stock that has already changed, and shows discrepancies that do not exist.
Practical tip: run a trial on a small zone a few weeks before year end. This lets you check, with nothing at stake, that the procedure and the ERP settings produce the expected result.
5. Validate, analyze discrepancies and archive
Validation updates the ERP stock with the counted quantities. Before running it, analyzing discrepancies helps distinguish genuine losses or stock errors from data entry anomalies.
The three stages that close the inventory
6. Don't forget your numbering sequences
A numbering sequence is the ERP setting that automatically assigns a number to each new document: customer invoice, manufacturing order, purchase order, delivery note. When this number includes the year, the sequence must be updated at the start of the new financial year.
For example, without this update, an invoice issued in January could carry the prefix FC26 instead of FC27. Depending on the settings, some sequences can be prepared in advance, starting with customer invoices.
The French tax framework for invoices: each invoice carries a unique number, assigned in a chronological and continuous sequence. Two invoices issued in the same year cannot carry the same number, and separate series are allowed when the business justifies them, preferably with a specific prefix for each series (BOFiP, BOI-TVA-DECLA-30-20-20-10).
Numbering that includes the year is a common way to guarantee unique numbers. If in doubt about your numbering scheme, check it with your accountant.
Outside France: inventory frequency, invoice numbering and document retention periods are set by each country's rules. The principles described in this guide remain valid, but check the applicable requirements with your local accountant.
7. What a manufacturing ERP brings to the inventory
An ERP does not count on behalf of your teams, but it determines the reliability of everything around the count. Inventory management in Synoptic ERP supports several types of inventory: rolling, permanent, accounting (which stores the stock position at a closing date) and retroactive (which recalculates the stock position at a past date). Counts can be entered on a handheld terminal by scanning barcodes, and the WMS module allows a detailed inventory down to pallet level.
Already a Synoptic ERP customer? Your usual contact and our support team can help you prepare your inventory and update your numbering sequences.
FAQ: year-end inventory
Is a physical inventory mandatory every year?
Can the inventory be taken on a date other than December 31?
Should stock movements be blocked during the count?
What if the inventory is validated several days after the count?
Does invoice numbering have to restart at zero every year?
What is a rolling inventory?
Sources
Conclusion: a year-end closing that is prepared upstream
A reliable year-end inventory depends less on the day of the count than on everything around it: an up-to-date stock configuration, trained teams, controlled movements between count and validation, and archiving planned from the start. Updating numbering sequences completes this preparation, so the new year starts without corrections.
As publisher and integrator of Synoptic ERP, Proges Plus supports manufacturing SMEs in setting up their stock, training their teams and preparing their year-end closings, from its offices in Lille, Lyon and Nantes.