Lager-Logistik Berlin

Guide

Warehouse inventory: methods overview

Unless exempt (Section 241a HGB), merchants must draw up an inventory at the end of each financial year (Section 240 HGB). Besides the year-end count, Section 241 HGB allows simplifications: statistical sampling with recognised methods, perpetual inventory and counts moved before or after the date.

Stocktaking establishes stock by type, quantity and value. Many know it as a count once a year; the German Commercial Code, however, allows several routes as long as they follow proper accounting principles and reliably establish stock by type, quantity and value. Which method fits depends on stock, warehouse organisation and bookkeeping. If your goods are stored by a provider, stocktaking remains your task where you are obliged to take stock; the provider supplies the count and a stock confirmation.

As of: · Editorial team: Lager-Logistik Berlin

At a glance

MethodIn briefBasis
Year-end countphysical count on or close to the balance sheet dateSection 240 HGB
Count before or after the datecount up to three months before or two months after the date, rolled forward or back to the dateSection 241(3) HGB
Perpetual inventorystock updated continuously, physical counts spread over the yearSection 241(2) HGB
Statistical samplingstock derived from samples with recognised statistical methods, same information value requiredSection 241(1) HGB

The methods and their prerequisites

MethodPrerequisiteAdvantageDrawback
Year-end countcount on or close to the balance sheet date; if counted on another day, reconcile movements to the date with recordseasy to understandmany staff on a few days
Count before or after the datecount up to three months before or two after, rolled forward or back in valuecount outside peak timescalculation effort for the roll-forward
Perpetual inventoryreliable continuous stock records, each item counted at least once a yearcounting spread over the yearrequires well-kept stock records
Statistical samplingrecognised statistical method, same information value as a full countonly part is countedmethod must be professionally sound

Who must take stock

Section 240 of the German Commercial Code obliges merchants to draw up an inventory when starting their business and at the end of each financial year. Smaller sole traders may be exempt under Section 241a HGB if they stay below certain turnover and profit thresholds. Whether the exemption applies is a matter for your tax adviser – for planning the count in the warehouse, all that matters is whether and on which date counting is required.

Example: perpetual inventory with a warehousing provider

A retailer has around 300 items stored with a provider. Instead of counting everything on 31 December, about 25 items are physically counted each month and reconciled with the book stock; differences are cleared at once. By year-end every item has been counted at least once, and the provider confirms the rolled-forward stock. Whether this method is permitted for your accounts depends on the reliability of the stock records – your auditor decides. How counting and confirmation work with us is described under stocktaking and stock control.

Preparing a year-end count

  • Fix count date and counting unit (pallet, package, item)
  • Freeze or clearly separate movements on the count day
  • Issue count sheets without target quantities (blind count)
  • Have differences recounted at once
  • Agree your auditor's attendance in advance
  • Stock confirmation with date and signature

How a year-end count works in a warehouse

  • Set date and responsibilities, inform the auditor
  • Stop or clearly separate movements on the count day
  • Divide count areas, count in pairs
  • Count blind and record results
  • Reconcile with book stock, recount differences
  • Sign the stock confirmation, document differences

Common causes of stock differences

CauseCountermeasure
Receipt booked, goods not yet put awaybook only after put-away
Mix-up of similar itemsclear location and item labels
Unreported removalremoval only against an order
Counting errorscount in pairs, recount on discrepancy

Key terms

  • Stocktaking: physical or record-based count of stock
  • Inventory list: record of assets and liabilities by type, quantity and value
  • Book stock: stock according to records
  • Stock difference: gap between counted and booked stock
  • Blind count: count without knowing the target quantity

Which stocktaking method fits? Decision table

Which method is permissible and sensible is for you to settle with your tax adviser or auditor. The warehouse supplies the count and the stock data the method requires.

SituationObvious methodRequirement
Few items, short shutdown possiblecount on the reporting datecount on or close to the balance sheet date
Financial year-end in peak seasonadvanced or postponed stocktakingcount within the last three months before or first two months after the reporting date, with value roll-forward or roll-back
Many items, no shutdown possibleperpetual inventoryreliable stock records and a physical check at least once per financial year
Very large range of similar itemssample-based stocktakinga recognised mathematical-statistical method

Count sheet: what it should contain

  • location and item number
  • item description and counting unit (piece, carton, pallet)
  • field for the counted quantity – without pre-printed book stock (blind count)
  • batch or date where relevant
  • name of the counter, date, time
  • note for damaged or blocked goods

Resolving stock differences properly

A difference between count and book stock is at first just a pointer. Before writing it off, check the usual causes: open receipts or dispatches on the count day, items mixed up on neighbouring locations, wrong counting units or booking errors from earlier transactions. Only what remains after a recount and a document check is a real difference. How stock is reported on an ongoing basis is shown in stocktaking and stock control.

Goods held by a warehousing provider: confirmation for the accounts

Goods held by a warehousing provider must still be accounted for under your company's applicable stocktaking procedures. A written stock confirmation from the warehouse keeper as at the reporting date is common, together with any required physical counts, which you or your auditors can attend. Settle before year-end what format the confirmation should take, whether batches and blocked goods are shown separately and by when it must be available. What your auditors require in detail is for you to agree with them.

Counting yes, valuation no

This overview does not replace tax or legal advice. A provider storing your goods does not value them; valuation and accounting are the responsibility of the company to which the goods are attributable in its accounts.

Questions and answers: Inventory methods overview

What inventory methods are there?

The year-end count, the count moved before or after the date, perpetual inventory and statistical sampling. Section 241 of the German Commercial Code governs the simplifications.

What is perpetual inventory?

A method where stock is updated continuously and each item is physically counted at least once in the financial year – spread over the year instead of on one date.

Who takes the inventory of goods held by a warehousing provider?

The company to which the goods are attributable is responsible. The provider counts and confirms the stock, which that company takes into its inventory.

When must stocktaking take place?

At the end of each financial year unless exempt; with the simplifications of Section 241 HGB also moved before or after, or spread over the year.

What is the difference between stocktaking and the inventory list?

Stocktaking is the act of counting, the inventory list its result: the record by type, quantity and value.

What is a blind count?

A count in which the counter does not know the book stock, so they do not unconsciously count towards the expected figure.

What should I do about stock differences?

First check causes – open movements on the count day, mix-ups, counting units, earlier booking errors – and recount. Only the remaining difference is written off.

What is a warehouse keeper's stock confirmation?

A written statement by the warehouse keeper of the stock of your goods at a reporting date. It serves as evidence for the annual accounts when the goods are not on your own premises.