Physical Inventory (Stocktaking)
A physical inventory is the complete recording of all of a company’s assets and liabilities by quantity and value on a given cut-off date – in retail, above all the stock of goods. It is required by law and reconciles the book inventory with the stock actually on hand.
A physical inventory is the complete physical and book-based recording of all of a company’s assets and liabilities on a specific cut-off date. In retail and manufacturing, the stock of goods takes centre stage: every item is counted, measured or weighed and assigned a value. The result is documented in the inventory record and reconciled against the book inventory kept in the system. The physical inventory is therefore the foundation of proper financial statements and mandatory for every merchant subject to bookkeeping requirements.
The obligation to take a physical inventory is anchored in law under Sections 240 and 241 of the German Commercial Code (HGB) as well as Section 140 f. of the Fiscal Code (Abgabenordnung). It requires that an inventory be drawn up at the start of a commercial business and thereafter at the close of each financial year. The physical inventory answers two questions at once: which stocks are actually on hand, and what value do they tie up? The difference between the target (book) and actual stock produces inventory discrepancies, which point to shrinkage, theft, posting errors or spoilage.
At a glance
- Complete recording of all stock by quantity and value on the cut-off date
- Required by law under § 240 f. HGB and § 140 f. AO
- Reconciles the book inventory (target) with the counted stock (actual)
- Methods: period-end, perpetual, shifted and sample-based physical inventory
- Basis for the balance sheet, stock valuation and detection of shrinkage
Why the physical inventory is mandatory
The physical inventory serves two purposes: a legal one and a business one. Legally, it is the prerequisite for the annual financial statements. Only those who know the actual stock can correctly report assets and liabilities on the balance sheet. The Commercial Code obliges every merchant to draw up an inventory at the end of the financial year; the Fiscal Code extends this obligation to tax law. Without a proper physical inventory, the financial statements are open to challenge, and the tax office can estimate stock levels.
From a business standpoint, the physical inventory reveals the truth about the warehouse. Book inventory and real stock drift apart in day-to-day operations – through theft, breakage, spoilage, incorrect postings or unrecorded goods movements. The physical inventory makes these inventory discrepancies visible, quantifies the shrinkage and provides the data basis for a realistic stock valuation. It is therefore also a control instrument for the quality of ongoing inventory management.
Process and components of a physical inventory
A physical inventory runs through several steps. First, the counting area is prepared: the warehouse is tidied, goods are clearly assigned and operations are stopped as far as possible so that no movements distort the stock during counting. Counting teams then physically record every item – traditionally on count sheets, today mostly by handheld scanner or app. The recorded quantities are captured, compared with the book inventory and any discrepancies are reported.
The result of the physical inventory is the inventory record: a detailed stock list that itemises every position by type, quantity and value. On this basis, stocks are valued – in retail usually under the lower-of-cost-or-market principle. Inventory discrepancies are analysed, documented and written off. The entire process must be documented in such a way that a knowledgeable third party can retrace it; this verifiability is also a GoBD requirement for electronically maintained stock records.
Target-actual comparison and inventory discrepancy
The core of every physical inventory is the target-actual comparison: the book inventory kept in the system (target) is set against the counted stock (actual). If the actual deviates from the target, an inventory discrepancy arises. A negative value points to shrinkage, a positive one to posting errors or unrecorded receipts. The discrepancy is corrected so that the system stock afterwards matches reality.
Physical inventory methods at a glance
The law permits various methods, as long as completeness and verifiability are preserved. The period-end physical inventory records all stock close to the balance sheet date – the classic approach, but often tied to a business interruption. The shifted physical inventory allows the physical count within three months before or two months after the cut-off date, with the stock projected forward or back to the cut-off date by calculation.
The perpetual physical inventory spreads counting across the entire year: every item is recorded at least once a year, for example when the reorder point is reached or at zero stock. It requires seamless warehouse bookkeeping. The sample-based physical inventory, finally, relies on recognised mathematical-statistical methods and extrapolates from a sample to the total stock – permissible under § 241 HGB if its informative value corresponds to that of a complete count.
Which method fits?
Small warehouses with a manageable range do well with the period-end physical inventory. Large distribution warehouses with a high number of items and short operating breaks often rely on the perpetual or the sample-based physical inventory, because these disrupt ongoing operations less and spread the effort across the year. The choice of method therefore depends on the size of the range, the warehouse structure and the quality of inventory management.
The physical inventory in the ERP system
An ERP or inventory management system significantly lowers the effort of a physical inventory. It keeps the book inventory continuously and can provide count lists or mobile capture dialogues for counting. Items are recorded by barcode via handheld scanners or tablets, and the counted quantities flow directly back into the system. The target-actual comparison happens automatically, discrepancies are reported per item, storage location or batch and can be written off in bulk.
Modern systems support all common methods: they lock the affected storage locations against postings during the period-end physical inventory, log every count with date and operator during the perpetual physical inventory and deliver the statistical evaluation for the sample-based physical inventory. Because every stock change is logged in an audit-proof manner, the verifiability required by the GoBD is ensured. Cleanly maintained item master data is the prerequisite here: without unambiguous item numbers, units and storage locations, no reliable physical inventory can be carried out.
Distinction: physical inventory, inventory record and inventory management
Physical inventory, inventory record and inventory management are often confused, yet they denote different things. The physical inventory is the activity – the process of counting, measuring and valuing. The inventory record is the result – the written stock list produced by the physical inventory. Inventory management, in turn, is the ongoing book-based updating of stocks in the system, which supplies the target values between two physical inventories.
The three interlock: inventory management supplies the target stock, the physical inventory determines the actual stock, and the inventory record documents the result. The better the ongoing inventory management, the smaller the inventory discrepancies and the less effort the physical inventory requires. A perpetual physical inventory is only possible at all if inventory management is seamless – here, ongoing posting and sample-based counting merge into one continuous process.
Example
Example: online retailer with 8,000 items
A sporting-goods e-commerce retailer ran its physical inventory for years as a classic period-end count between the years: the shop was shut down for two days and the entire team counted on paper lists. Even so, high inventory discrepancies remained after the count, because goods were still being moved between counting and capture and transcription errors crept in on the lists.
After switching to the perpetual physical inventory in the ERP system, every item is now recorded across the year – triggered when the reorder point is reached or at zero stock, scanned via a mobile device. The counts flow directly into the target-actual comparison, discrepancies become visible immediately and are corrected per storage location. The result: no more business interruption, significantly smaller discrepancies and a stock figure that is reliable at any time as a basis for the balance sheet and reordering.
Frequently asked questions
Related services
Sources
Questions about Physical Inventory (Stocktaking) in your ERP project?
We advise vendor-neutrally – and implement it ourselves on request.