Warehouse Inventory Management: Methods and Common Mistakes

Every warehouse manager has lived through the same nightmare: a client order is confirmed in the system, the picker walks to the shelf, and the product is not there. The gap between digital records and physical reality is the most expensive problem in warehouse operations, and it almost always traces back to poor inventory management.

In the Lisbon Metropolitan Area, where logistics costs per square metre keep rising, controlling what enters and leaves a warehouse is no longer optional. This guide covers the methods that work, the mistakes that drain margin, and the legal rules that apply in Portugal.

Management Methods: FIFO, LIFO, FEFO and ABC Analysis

Choosing an inventory flow method determines how goods move from receiving dock to dispatch. The four most common approaches each solve a different problem.

FIFO (First In, First Out) ensures the oldest stock ships first. It is the default choice for perishable goods, pharmaceuticals and any product with a shelf life. In Portugal, FIFO also aligns with standard accounting valuation under SNC (Sistema de Normalização Contabilística), making year-end reporting simpler.

LIFO (Last In, First Out) prioritises the newest stock. It suits raw materials whose price fluctuates sharply, because it matches recent costs against current revenue. However, LIFO is not accepted under IFRS for financial reporting, which limits its use for companies with international obligations.

FEFO (First Expired, First Out) goes one step further than FIFO by sorting stock by expiry date rather than arrival date. Two pallets of the same product that arrived on different days may have different expiry dates. FEFO catches that distinction and is mandatory in food distribution and pharmaceutical logistics.

ABC Analysis classifies every SKU into three tiers based on annual consumption value. Class A items, roughly 20 percent of references, account for about 80 percent of total value and deserve the tightest controls, the most accessible picking locations and the highest count frequency. Class B covers the next 30 percent of references at around 15 percent of value. Class C absorbs the remaining 50 percent of SKUs that together represent only 5 percent of value.

For companies that need to calculate the right warehouse area, ABC analysis also guides layout decisions. Placing A-items closest to dispatch docks shortens travel time and reduces labour cost per order.

The Most Common Mistakes and What They Cost

Inventory errors rarely announce themselves. They accumulate quietly until a stock-out halts production or an overstock ties up cash for months. These are the patterns that appear most often.

Receiving without verification. When inbound goods skip a count-and-inspect step, supplier errors enter the system as correct data. A single undetected short shipment can cascade into weeks of incorrect availability signals.

Manual data entry without validation. Typing quantities into a spreadsheet invites transposition errors. Research from the Warehousing Education and Research Council suggests manual processes carry an error rate between 1 and 3 percent per transaction. At 500 daily movements, that means 5 to 15 wrong records every day.

Ignoring returns processing. Returned goods that re-enter stock without inspection and reclassification contaminate inventory accuracy. In e-commerce warehouse operations, where return rates frequently exceed 20 percent, this is a critical control point.

No defined put-away rules. When operators store incoming goods in the nearest available slot without following a system, products end up in random locations. The result is longer pick times, misplaced stock and inflated cycle count discrepancies.

Delaying write-offs. Damaged or obsolete stock that remains in the system as available inventory distorts purchasing decisions and inflates asset values on the balance sheet. Portuguese tax authorities expect timely write-offs supported by documentation.

Cycle Counting Versus Full Physical Inventory

A full physical inventory means stopping operations, counting every item and reconciling against the system. It is disruptive, expensive and, in many cases, legally insufficient on its own because accuracy decays rapidly after the count.

Cycle counting distributes the effort across the year. Each day or week, a small subset of locations is counted, investigated and corrected. The most common approaches include the following.

ABC-driven cycles. A-items are counted monthly, B-items quarterly and C-items once or twice a year. This concentrates effort where errors are most expensive.

Location-based cycles. Every location in the warehouse is counted on a rotating schedule regardless of what it holds. This catches systematic issues like mislabelled shelves.

Trigger-based counts. A count is initiated whenever an anomaly appears, such as a negative balance, a pick discrepancy or a customer complaint. This reactive method complements scheduled cycles.

The key advantage of cycle counting is that it turns inventory accuracy into a continuous process rather than a yearly event. Warehouses that adopt cycle counting typically reach and sustain accuracy rates above 99 percent within 6 to 12 months.

For operations planning a warehouse relocation, running intensive cycle counts in the months before the move prevents transferring inaccurate data to the new facility.

Technology: WMS, Barcodes and RFID

A Warehouse Management System (WMS) is the backbone of modern inventory control. It automates put-away logic, directs picking routes, enforces FIFO or FEFO rules and maintains a real-time digital twin of every shelf position.

Barcodes remain the most cost-effective identification technology. A basic setup with printed labels and handheld scanners costs a fraction of RFID and delivers immediate accuracy gains. Every receiving, put-away, pick and dispatch event is scanned, eliminating manual entry errors.

RFID (Radio Frequency Identification) enables bulk reading without line of sight. A forklift passing through an RFID portal can register an entire pallet in seconds. The technology excels in high-volume environments where barcode scanning creates bottlenecks, but tag costs and infrastructure investment remain higher.

Integration matters. A WMS that does not connect to the ERP, the transport management system and the e-commerce platform creates data silos. Real-time bidirectional integration ensures that a sale on the website immediately reserves stock in the warehouse and that a goods receipt updates purchasing and accounting simultaneously.

For logistics warehouse operations handling multiple clients, a WMS with multi-tenant capability allows each client's inventory to be managed independently within the same physical space.

Legal Obligations in Portugal

Portuguese law imposes specific inventory obligations that apply to any entity holding goods for commercial purposes.

Annual physical inventory. Article 12 of Decreto-Lei 28/2019 requires taxpayers to perform a physical inventory at least once per year, on the last day of the fiscal year. The result must reconcile with accounting records.

Permanent stock file (Ficheiro de inventário valorizado). Since 2015, companies with turnover above 100 000 euros must maintain a permanently updated, valued inventory file and submit it to the Tax Authority (AT) by 31 January of the following year via the e-Fatura portal. The file must include item description, quantity, unit and total value.

SAF-T reporting. The Standard Audit File for Tax purposes must include stock movement data. Companies using a WMS need to ensure it exports SAF-T-compatible records, particularly for goods receipts, dispatches and internal transfers.

Transport documents. Every movement of goods between warehouses or to a client requires a transport document (guia de transporte) communicated to the AT before the goods leave the premises. This rule applies even to internal transfers between facilities of the same company.

Frequently Asked Questions