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
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.
-
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.
-
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.
-
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.
-
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.
-
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.
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.
The hardware overview shows which devices work with DezemberHub. To the hardware
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.
| 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
| 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