Stocktaking

Stocktaking in shoe and fashion retail

Stocktaking in DezemberHub counts a branch in full or in sections, reads the count files from your MDE devices as TXT, CSV or XLSX and values the stock at the net purchase price, the list purchase price less up to five discounts. DezemberHub is the ERP system with POS and AI assistant for shoe, fashion, and sports retail in the DACH region.

  • Full stocktake, partial stocktake and spot check
  • Variance list per size
  • Valuation at net purchase price on the reference date
STK-20261115-0912 Offen Vollinventur · Standort GEZÄHLT 42 / 120 Positionen Positionen Barcode, Artikel- … 1 5312163 gezählt 3 von 3 ARTIKEL BUCHBESTAND GEZÄHLT Fernlauf 5 · 42 5312163 3 3 Weitsicht 3 · 41 5471423 2 2 Kammlinie 2 · 43 5581108 2 –

How does stocktaking work in DezemberHub?

Five steps from setup to posting. POS and inventory management are the same system, so the stocktake knows every sale that happens during the count.

  1. Create stocktake

    You choose the branch, full stocktake or sample count and, if you wish, a subset via the item filter: product groups including subgroups, brand, season or supplier. Counting covers the whole location, shelf by shelf or by reference.

  2. Set the count start

    The target stock is read at the configured count start. DezemberHub offsets sales and other movements between the count start and the count for each item, even if the shop stays open during the count.

  3. Count

    You upload the count files from your MDE devices, scan with the handheld scanner or enter quantities manually. The same file is only counted once, even under a different name.

  4. Check differences

    The variance list shows target, actual and difference per size, in units and at purchase price. For each line you decide: accept the actual or keep the target. The stocktake can only be completed once every variance line has been decided. The list is available as a PDF with item image and as an Excel file.

  5. Complete and post

    On completion, DezemberHub posts all differences in one step, all or nothing. Several partial stocktakes can be posted to a common reference date within one count cycle. For each branch, the count cycle shows the remaining stock not yet covered by any partial stocktake and creates the count order for it with one click.

How do I prepare the stocktake?

A stocktake begins a few days before the counting. You settle these points beforehand so that the variance list stays short in the end.

  • Set the reference date

    For several partial stocktakes you create a count cycle with a common reference date.

  • Divide up the areas

    Split the count by product group, brand, season, supplier or shelf so that each team counts a clearly defined section.

  • Check negative stock

    The negative stock report shows, per branch, all sizes whose stock is below zero. What you clear up beforehand you do not have to look for in the variance list later.

  • Complete picking lists

    As long as picking lists are open in a branch, DezemberHub neither starts nor completes a stocktake there.

  • Get the counting devices ready

    Handheld scanner, Android handheld or mobile data terminal, charged and with empty memory.

  • Assign the counting teams

    Decide who counts which area. Each team can load its own count file into the stocktake.

Devices for counting

What is used to count during stocktaking?

Counting is done with a handheld scanner, an Android handheld or an MDE device.

Handheld scanner

You scan the number or EAN. One scan counts one; if needed, you type in the quantity for the next code.

Example drawing: wireless handheld scanner at a shelf with shoe boxes

Can I count with my existing MDE devices?

Yes. You keep using the MDE devices you already count with today for stocktaking, as well as for goods receipt and stock transfers. Devices from Opticon, Metrologic, Datalogic, Zebra, ARTDEV and many more can be connected.

You load the device's count file directly into the stocktake: TXT, CSV or XLSX with one barcode per line, optionally with the quantity in the second column. The classic export format of handheld scanners with header and branch records is also recognised and cleaned up. Several files per stocktake are possible, and each one can be switched on and off individually.

Example drawing: MDE devices with keypads, as used in many shops.

How is stock valued during stocktaking?

The basis is the purchase price. DezemberHub keeps it in three fields that always match: two of the three values give the third.

List purchase price
The purchase price according to the supplier's price list, optionally per size.
Discounts
Up to five discounts per price, which you name per supplier, such as basic discount, volume discount, pre-order discount or complaint discount. They are applied one after the other. If an item has no discount of its own, the supplier's discount applies.
Net purchase price
The list purchase price less the discounts. Stocktaking values the stock at this price.
Sample calculation: running shoes from Lindtaler Sport Net purchase price = list purchase price × (1 − discount), stock value = net purchase price × stock. Fictitious values for illustration.
Model List purchase price Discount Net purchase price Stock Stock value
Fernlauf 5 82,00 € 12,5 % 71,75 € 12 Pair 861,00 €
Weitsicht 3 86,00 € 12,5 % 75,25 € 8 Pair 602,00 €
Kammlinie 2 92,00 € 12,5 % 80,50 € 6 Pair 483,00 €
Total 26 Pair 1.946,00 €

What does the stocktaking valuation show?

The stocktaking valuation report shows the book stock of each branch on the selected reference date, valued at the net purchase price that applied on that day, plus the total across all branches. Goods in transit between branches count towards the destination branch. You select all or individual branches.

Printed, the valuation is a summary list: one page per branch with risk groups 1 to 5 in rows, the deduction in % and the stocktaking value per group, the seasons in columns, plus one page with the total across all branches. The same figures are available as a CSV file.

  • Valuation at your own price list with purchase price including freight and customs, or with a markup on the net purchase price
  • Average net purchase price from goods receipts if no price is stored for an item

Write-downs by risk group and season age

In DezemberHub, write-downs can be controlled freely per season, manufacturer, colour and item. In the stocktaking valuation they act as percentage deductions from the net purchase price: each item carries a risk group from 1 (very low) to 5 (very high), and the season age results from the item's season and the reference date.

The deduction table comes with default values, and you can set it freely to your own percentages.

  • Risk group per item, from 1 very low to 5 very high
  • Season age: the last eight seasons up to the reference date, plus old stock, standard and newer seasons
  • You assign individual seasons to a fixed column; permanent seasons and items without a season run under standard
  • For items without a risk group, a separate row with deductions is available on request
Deductions by risk group and season age Product default values in percent, freely adjustable. Excerpt with five of eleven columns for the reference date 31.12.2026, season names as examples.
Risk group Old stock Standard HW 25 FS 26 HW 26
1 very low 50 % 0 % 10 % 5 % 0 %
2 low 50 % 5 % 15 % 10 % 5 %
3 normal 50 % 5 % 10 % 5 % 0 %
4 high 50 % 10 % 30 % 20 % 15 %
5 very high 50 % 10 % 30 % 20 % 15 %

Example: Fernlauf 5 is in risk group 3 and belongs to the season FS 26. With a 5 % deduction, the stock value of €861.00 results in a stocktaking value of €817.95.

Frequently asked questions about stocktaking

How do the counts get from the MDE device into the stocktake?

You transfer the counts from your MDE devices into the DezemberHub stocktake as a count file: TXT, CSV or XLSX with one barcode per line; a second column can contain the quantity. The classic export format of handheld scanners with header and branch records is recognised and cleaned up. Several files per stocktake are possible, and the same file is only counted once. For goods receipt and stock transfers, DezemberHub also reads the MDE device directly, by cable or by infrared.

What happens to sales during stocktaking?

DezemberHub reads the target stock at the configured count start. Sales and other movements between the count start and the time an item was counted are offset for each item. Because POS and inventory management are the same system, the stocktake knows every POS sale. Goods receipts and stock transfers posted during the count are also offset for each item. If a POS sale arrives later, DezemberHub recalculates the affected line before completion.

Do I have to count exactly on the reference date?

No. In DezemberHub you create a count cycle with a reference date and count the partial stocktakes on the days that suit your business. If you count after the reference date, DezemberHub posts the differences to the reference date. If the reference date is still in the future, posting takes place on the day of completion. The stocktaking valuation reads the book stock as of the reference date.

How do I find errors in the count?

For each count file, DezemberHub shows you how many scans were matched to an item and which barcodes are unknown. Scans of items outside the scope of the stocktake are listed separately and are not counted. In the variance list you filter by differences, uncounted and unexpected items as well as by decided and open lines. You add missing pieces in the manual count.

What happens to negative stock during the stocktake?

Before the stocktake, you find negative stock in DezemberHub in the negative stock report, per branch and size. A counted quantity is never negative. If you accept the actual stock in the variance list, the counted quantity applies after completion. Only positive stock counts in the stocktaking valuation.

Can I cancel a stocktake?

Yes, as long as it is open. A cancelled stocktake posts nothing in DezemberHub. Counts, decisions and count files remain readable, and the branch is free for a new stocktake.

Can I count only individual product groups or brands?

Yes. You narrow down a partial stocktake with the item filter, for example by product groups including subgroups, brand, season or supplier. Several partial stocktakes can be combined into one count cycle, which posts all differences to a common reference date.

How does DezemberHub calculate the net purchase price?

The net purchase price is the list purchase price less the discounts, such as basic discount, volume discount, pre-order discount or complaint discount. Up to five named discounts are possible per price, and they are applied one after the other. List purchase price, discount and net purchase price always match: two of the three values give the third.

How do I control write-downs in the stocktaking valuation?

In the DezemberHub stocktaking valuation, write-downs are percentage deductions from the net purchase price. They depend on the item's risk group, from 1 (very low) to 5 (very high), and on the season age relative to the reference date. The deduction table comes with default values and can be set freely, and individual seasons can be assigned to a fixed column.

Try it out. No commitment.

30 days free with all features. No payment details, no appointment, no automatic renewal.

Still using another system? Your data comes with you. How the switch works

Personal advice, no hold music, no sales pressure.

or

Request a Callback

Something went wrong. Please try again.

or start for free
Get started for free

30 days free, no payment details. No automatic renewal.

Thank you!