A Case Study
By Steven Willey, Capcon
The Challenge
When concerns were raised around stock performance at a UK city-centre hotel, the issue was not immediately obvious. The numbers were there, but they were not telling a clear story.
Variances were inconsistent. Wastage appeared unusually high. Confidence in the data had started to decline, not because there was no information, but because the information could not be relied upon to explain what was happening.
Stock takes were being completed, and systems were in place, but the outputs were not supporting decision-making. Management were left with reports that raised questions rather than answered them.
This is a familiar position in many hospitality operations. The data exists, but without consistency and control behind it, it becomes difficult to interpret, and even harder to act on.
Understanding the Problem
A detailed investigation was carried out, not simply to identify discrepancies, but to understand the root causes behind them.
It quickly became clear that the issue was not a lack of effort. The team were engaged and active. The problem lay in how processes were being applied day to day.
Fundamental controls were not being followed consistently. Weekly cellar balances, designed to highlight issues early, were being completed sporadically rather than as part of a routine. As a result, problems were only becoming visible at the point of full stock takes, by which stage they were harder to trace and resolve.
Stock movements presented another challenge. Transfers between cellar and outlets were often recorded after the fact, sometimes days later. This created timing gaps that distorted theoretical stock positions and made variance analysis unreliable.
At the same time, revenue was being entered regularly, but without meaningful reconciliation between systems. This left differences between stock and sales data unexplained and unchallenged.
More concerning were the patterns identified within wastage and pipe cleaning records. Standardised figures were being applied across multiple products and reporting periods, creating a consistency that did not reflect operational reality. In some cases, wastage was attributed to products that were not even sold in the relevant outlets. Pipe cleaning records also failed to align with external contractor reports, further reducing confidence in the integrity of the data.
Delivery controls and petty cash handling added to the issue. Missing invoices, misapplied transactions and limited reconciliation back to procurement systems meant that the full stock picture could not be verified with confidence.
Individually, each of these issues might have been manageable. Together, they created a system where the data could not be trusted, and where genuine issues were difficult to isolate.
Rebuilding Control
The focus was not on applying quick fixes, but on restoring clarity and consistency to the process.
This meant returning to the fundamentals of stock control and ensuring they were applied properly.
Structured weekly cellar balances were reintroduced, supported by interim stock checks to provide regular visibility. Requisition processes were simplified and reinforced to ensure stock movements were recorded accurately and in real time. Revenue and stock systems were brought into closer alignment through consistent reconciliation, allowing discrepancies to be identified and addressed promptly.
Wastage and pipe cleaning allowances were reset based on actual activity rather than estimated or standardised figures. This ensured that reporting reflected reality rather than assumption.
Delivery processes and petty cash controls were also tightened, improving traceability and reducing the risk of errors or omissions.
The changes themselves were not complex. The impact came from applying them consistently.
The Outcome
As these controls were re-established, the quality of the data improved quickly.
Variances became clearer and more meaningful. Patterns could be identified with confidence. Management discussions shifted from questioning the accuracy of the numbers to understanding what the numbers were saying and what actions were required.
The result was not just improved audit outcomes, but a more controlled and accountable operation. Stock management moved from being a reactive process, driven by periodic checks, to a reliable management tool that supported day-to-day decision-making.
A Wider Lesson
This case reflects a broader reality across hospitality.
Stock issues are rarely the result of a single failure. They are usually the product of small inconsistencies in process that build over time. When those processes are not applied consistently, even good systems and regular reporting cannot compensate.
What makes the difference is not more data, but better control of how that data is created.
How Cacon Helps
If your stock results are inconsistent, difficult to explain, or not supporting decision-making, the issue may not be the system or the reporting.
It may be the underlying process.
Capcon works with hospitality operators to review, strengthen and restore stock control. If this reflects your current position, get in touch to arrange a review.
