Inventory Reconciliation
● Final · frozen 30 Sept 2026
SKUs tracked
0
GmbH · D2C
Reconciled
0%
SKUs with gap
0
diff ≠ 0
Net diff
0
units
Total abs gap
0
units
| SKU / Product | Stock BOM | +Restock | Shopify — D2C | Amazon | Internal transfers | Total out | Excluded (info) | Stock EOM | Calc EOM | Diff | Mag. | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DE | FR | PL | UKⓘ | CR | Office | Amazon | Internal | POS | NOT1→ | ||||||||
Showing 0 of 0 rows (GmbH · D2C, September 2026)Tip: Copy for Google Sheets → paste into your sheet.
About this dashboard
Each month, per SKU, this reconciles physical warehouse stock: Calc EOM = Stock BOM + Restock − Units out, then Diff = Actual EOM − Calc EOM. A non-zero diff flags stock that recorded movements don’t explain — for finance/ops to investigate. Product names come from il.odoo_product_template.
Entities & segments
- GmbH · D2C — stock in POZ1+POZ2 (Poznań), reconciled against units shipped from those warehouses (Shopify DE/FR/PL/UK/CR/Office, internal transfers, Amazon). Its small “UK” column is Shopify UK orders that happened to ship from POZ, not the UK entity's sales — see Ltd · D2C for that.
- GmbH · Retail — stock at Dachser (DCH/Stock) from ol.stock_inventory; units out from Retail Bot.
- Ltd · D2C — stock in NOT1 (Nottingham) / MAN1 (Manchester, replaced NOT1 mid-August 2026), reconciled against UK shipments.
- Ltd · Retail — under development.
Retail — data status
Dachser stock snapshots (DCH/Stock) begin 17 Jul 2026, so no month yet has both a start-of-month and end-of-month snapshot. Full BOM→EOM reconciliation for Retail therefore begins with August 2026. Until then the Retail tab shows Retail Bot sales and the latest Dachser stock.
Excluded (D2C, info only)
POS (in-person), cross-warehouse (e.g. UK shipped from POZ), and Retail Bot / non-Hive flows are not subtracted in the D2C Calc.
Shortfall (diff<0) Surplus (diff>0) Matched