What software and strategies should we use for managing inventory and pricing, particularly for stock held under excise duty bond?
Members recommend a practical approach to inventory management that balances regulatory compliance with cost-effective tooling.
**Inventory software:** - **Xero native inventory system** — members have raised serious concerns about whether the built-in Xero inventory module can properly handle wine and spirits stored under excise duty bond, so validate this thoroughly before relying on it as your sole solution. - **Unleashed** — commonly used by members but flagged as expensive for smaller operations, so evaluate against your budget and complexity needs.
**Pricing and margin calculation:** - **thinkMargin app** — recommended as a useful, accessible tool for calculating margin, cost and price conversions; particularly helpful given the distinction between markup (cost-based) and margin (sell-price-based) that retailers typically prioritise. - Retail margins typically run 30% in the spirits and wine sector, though this varies: premium retailers demand larger margins, convenience stores work on smaller margins for faster-moving products, and margin % is generally higher on wine than spirits. Importantly, retailers focus on cash margin (absolute pounds/pence), not just percentage—so a high-value product like Louis XIII may carry lower percentage margin but higher cash margin than lower-priced stock.
**Stock management around regulatory changes:** - Pre-buy stock before duty increases or regulatory changes take effect (monitor news for lobbying outcomes, as these can affect timing). - Coordinate with your warehouse team in advance, as many businesses will be doing the same and capacity/timelines will be tight. - Expect wholesalers and big producers to post new price lists on the effective date, with across-the-board increases of a few pounds per bottle likely.
**Caveats:** If you hold stock under excise duty bond, standard inventory software may not be fit-for-purpose—test any system thoroughly before committing. Margin calculations depend heavily on your product category and rate of sale, so use thinkMargin or similar tools to model your specific scenario rather than assuming the 30% benchmark applies uniformly.
Was this helpful?
This answer was distilled from the Kindred Collective community.
Got a question of your own?
Join the Collective to ask the community directly and unlock the full directory.
Join Kindred Collective