Most retail businesses are swimming in data. The EPOS system logs every transaction. The e-commerce platform tracks every click, every basket, every abandoned checkout. The stock system knows what came in and what went out. Put it all together and there is, theoretically, a detailed picture of what is happening across the business, by product, by location, by hour of the day. The problem is not a shortage of data. The problem is that almost none of it is being used to make decisions.
What tends to happen instead is this. The business knows its total weekly revenue, because that comes through the till system automatically. It knows its year-on-year comparison, because the accountant mentions it at year-end. And it has a vague sense of which products are popular, because the team on the shop floor can tell you which shelves need restocking first. Beyond that, the data sits in the system, exported into spreadsheets that nobody has time to analyse, or extracted into reports that present volume without context. Revenue is up. Margin? That is harder to answer. Why footfall was down last Thursday? Nobody is quite sure.
This is the gap that an experienced Finance Director fills in retail. Not by becoming a data analyst, but by asking the questions the data can actually answer, and connecting those answers to the commercial decisions the business needs to make. The EPOS system is not chaos. It is a library that nobody has organised.
What you will learn
Why volume of data is not the same as financial visibility, and what the gap between them costs the average retail business.
The four categories of insight that management information from an EPOS system should be generating for your leadership team.
How sales mix analysis reveals the true picture of margin, and why it so often surprises the businesses that run it for the first time.
What stock turn analysis tells you about cash efficiency, and where slow-moving inventory quietly compounds the problem.
Why footfall versus conversion is the metric most physical retailers ignore, and what it reveals about operational performance that revenue figures never can.
How multi-channel businesses can start to build a coherent financial picture when their data lives in three different systems and speaks three different languages.
The Data Problem Is Not What You Think
When retail business owners talk about their data problem, they usually mean one of two things. Either they feel they do not have enough information, or they feel overwhelmed by the information they do have. In practice, both complaints describe the same underlying issue: the data exists, but it is not connected to decisions.
There is a specific pattern to this. Monthly management accounts, when they arrive at all, show revenue and cost at a level of aggregation that is useful for compliance but not for trading decisions. The P&L says gross margin was 38% last month. What it does not say is that margin on clothing was 47%, margin on footwear was 29%, and the footwear category grew as a proportion of the mix, which is why overall margin slipped despite higher revenue. Those details exist in the EPOS system. Nobody extracted them into a format the MD could act on.
The same problem appears in stock management. The business knows its total stock value because the balance sheet requires it. What it does not know, week to week, is which categories are turning quickly and which are sitting for ninety days before they move. The cash tied up in slow-moving stock is not visible on the P&L. It appears on the balance sheet, but nobody is reviewing the balance sheet with enough frequency or granularity to catch it. By the time it becomes a problem, the buying decision that caused it was made six months ago.
None of this is a technology failure. The systems are capable. What is missing is someone whose job is to ask the right questions of the data, consistently and frequently enough that the answers change decisions before the month is already gone.
The EPOS system is not the problem. It is a filing cabinet full of answers. The question is whether anyone in the business has time to look up the right ones, and whether they know which questions to ask.
Four Categories of Insight Your Data Should Be Generating
Before getting into the specific metrics, it is worth establishing what useful actually means in this context. Useful data is data that changes a decision. If a number is extracted, presented, reviewed, and then filed without anyone changing anything as a result, it was not useful. It was just reporting.
The categories of insight that genuinely drive retail decision-making fall into four areas, and a well-structured management information framework should be generating all four on a regular basis:
Margin by category, product, or channel: understanding where the profit is actually coming from, not just where the revenue is. These are often very different places, and the gap between them is where pricing and buying decisions improve.
Stock efficiency: how quickly inventory is turning, where cash is tied up, and which lines are becoming a liability rather than an asset.
Traffic and conversion: for physical retailers, the relationship between footfall and transactions. For online businesses, the equivalent metrics of sessions, add-to-basket rates, and checkout completion. Both tell you about the effectiveness of the customer experience rather than just the outcome.
Channel and location performance: for multi-site or multi-channel businesses, the comparison between how each site or channel is performing against the others, and against its own prior periods. This is where the operational conversations get grounded in financial reality.
These are not sophisticated analytics. They are the basic financial questions any experienced retail FD would ask in the first week of a new engagement. The reason they often go unanswered is not that the tools are unavailable. It is that nobody has been given the responsibility of asking them.
Sales Mix Analysis: Where the Margin Picture Actually Lives
Sales mix analysis is the practice of understanding not just how much you sold, but what you sold and what that combination means for margin. It is one of the most revealing analytical exercises in retail, and one of the least commonly done.
The reason it matters is straightforward. Retail businesses rarely have a single margin. Different product categories, different price points, different channels, all carry different gross margins, and the total margin in any given month is the weighted average of everything the business sold. If the mix shifts towards lower-margin products or categories, the total margin falls even if revenue holds or grows. This is a pattern that catches a lot of retail businesses by surprise, because they are watching the revenue line and assuming the margin line will follow it. It often does not.
A clothing retailer with three categories, occasionwear, casualwear, and accessories, was seeing consistent revenue growth over a two-year period. The total gross margin, however, had slipped from 44% to 39% without any obvious explanation. The analysis showed that accessories, which carried margins above 60%, had shrunk as a proportion of sales from 28% to 17%, while casualwear, with margins around 35%, had grown significantly. The business had been celebrating the revenue growth without noticing that the mix shift was quietly eroding the margin beneath it. Nobody had been wrong, exactly. The buying team had responded to customer demand. The marketing team had promoted what sold. But the cumulative financial effect had not been visible until someone looked at the mix rather than the total.
Running this analysis does not require sophisticated software. It requires a clear categorisation structure in the EPOS system, a regular extract of sales by category, and someone who will look at the margin by category rather than the margin in aggregate. A Finance Director builds this into the monthly rhythm as a matter of course. Without that, the mix can shift materially over a quarter before anyone notices the consequence in the numbers.
Revenue growth is not the same as margin improvement. A business can sell more and earn less if the mix is moving in the wrong direction. Watching the total obscures the movement underneath.
Stock Turn: The Silent Cash Drain
Stock turn is the rate at which inventory moves through the business. A business with high stock turn is converting its investment in goods into revenue quickly. A business with low stock turn is carrying inventory for longer, which means tying up cash that could be deployed elsewhere, and accumulating the risk that slow-moving stock will eventually need to be marked down or written off.
Most retail businesses know their stock turn at a headline level. Fewer track it at category or SKU level, which is where the insight actually lives. A business might have an overall stock turn of eight times per year that looks perfectly acceptable, while concealing a sub-category turning twice per year sitting alongside one turning twenty times. The headline hides the problem because the fast-moving lines flatter the aggregate. The cash is tied up in the slow ones.
There are several specific questions worth asking about stock turn that most businesses do not ask regularly:
Which categories or SKUs have not turned in the last sixty days, and what is the total cash value tied up in them?
What is the relationship between stock turn and margin by category? High-margin lines that also turn quickly are the engine of the business. High-margin lines that turn slowly deserve attention. Low-margin lines that turn slowly are a problem that compounds.
Where are the reorder points set, and are they based on actual turn rates or on historical habits that predate changes in customer behaviour?
What happens to margin when slow-moving stock is eventually discounted? Is the markdown cost being tracked and reported, or does it disappear into the cost of goods without being attributed to the original buying decision?
This last point is particularly important. Markdowns are often treated as a fact of retail life rather than as a cost of poor buying decisions. When they are tracked properly, category by category and season by season, they reveal patterns in the buying process that are genuinely fixable. The financial controls that make this visible are not complicated. They require consistency of categorisation, regularity of review, and someone who cares about the number enough to ask the uncomfortable question when a category starts to age.
Footfall vs Conversion: What the Revenue Figure Cannot Tell You
For physical retailers, footfall and conversion are the two numbers that sit behind every revenue figure. Footfall is how many people walked through the door. Conversion is what proportion of them bought something. Revenue is the product of both, combined with average transaction value. When revenue changes, the first question should always be: which of these three things changed?
The reason this matters is that each answer points to a completely different intervention. Falling footfall is a marketing or location problem. Falling conversion is an in-store experience or product availability problem. Falling average transaction value is a pricing or upselling problem. All three produce the same symptom on the revenue line, which is why looking at revenue alone provides almost no guidance on what to do next.
A high-street homeware retailer had seen revenue fall across its two busiest stores over a six-month period. The initial assumption, shared by the management team and the area managers, was that footfall had declined as customers shifted spend online. The analysis told a different story. Footfall was actually flat, within a few percentage points across both locations. Conversion had dropped significantly, from 34% to 21% in one store and from 31% to 24% in the other. People were coming in. They were not buying. The problem was not acquisition. It was something happening in the store itself: product range, pricing, stock availability, or customer experience. The intervention that followed was focused in entirely the right place because the data was cut correctly.
Most EPOS systems can provide transaction counts. Most door counters or footfall tracking systems can provide visitor numbers. The calculation is simple. The insight is significant. And yet it is a metric that a surprising number of retail businesses either do not track or do not review regularly enough to act on. Bringing it into the weekly trading dashboard alongside revenue and margin turns it from an interesting observation into an operational tool.
Footfall tells you about your marketing. Conversion tells you about your shop. Average transaction value tells you about your range and your team. Revenue tells you the outcome of all three. Reading the outcome without understanding the components is like checking the temperature without knowing whether the heating is on or the window is open.
Multi-Channel Retail: Building a Coherent Picture Across Disconnected Systems
For businesses trading across physical stores, an e-commerce platform, and potentially marketplaces like Amazon or wholesale channels, the data problem is compounded by the fact that the information lives in different systems with different reporting conventions, different margin structures, and different cost bases. The store uses an EPOS system. The website runs on Shopify or Magento. The marketplace has its own seller portal. None of them talks to the others, and the finance team is extracting reports from each one separately and trying to stitch them together in a spreadsheet that takes a day to produce and is out of date before it is finished.
The starting point for making this manageable is not to find one system that consolidates everything, though that is the eventual goal for most businesses at sufficient scale. The starting point is to agree on a consistent set of metrics that will be tracked across all channels in the same format, with the same definitions, on the same cadence. Revenue is obvious. Gross margin by channel is less obvious but more important: the margin on a direct website sale is very different from the margin on a marketplace sale after fees, and treating them as equivalent distorts every decision about where to invest in growth.
There are a handful of channel-level comparisons that a Finance Director will establish as non-negotiable in a multi-channel business:
Gross margin by channel after all channel-specific costs: marketplace fees, payment processing, shipping, packaging, and returns handling. This is the number that tells you which channel is actually profitable, not just which generates the most revenue.
Return rate by channel and category: online businesses often have return rates that dwarf those in physical stores, and the cost of returns is frequently underestimated because it sits in logistics costs rather than being attributed to the channel that generated it.
Customer acquisition cost by channel: how much is being spent on marketing, advertising, or platform fees to generate each new customer in each channel? Combined with average lifetime value, this tells you where the business should be allocating its growth investment.
Stock allocation efficiency: is the right inventory in the right place? A multi-channel business that runs out of stock online while sitting on surplus in stores, or vice versa, is leaving margin on the table through allocation decisions that could be improved with better visibility.
None of these metrics require expensive middleware or a data warehouse. They require clear definitions, a consistent process for extracting and reconciling data across systems, and the discipline to review them on a regular cycle. The FD’s role is to establish that discipline and ensure the numbers are being used to make decisions, not just to fill a reporting template that nobody challenges.
From Data Noise to Commercial Signal
The retail businesses that use their data well are not necessarily the ones with the most sophisticated technology. They are the ones where someone has taken the time to define what matters, establish a consistent way of measuring it, and build the discipline of reviewing it often enough that the numbers inform decisions rather than just record outcomes.
That is, at its core, a finance leadership function. Not a data science function. Not a technology project. An experienced outsourced FD who has worked across retail businesses knows which metrics tend to reveal the most useful things, how to structure the extraction so it does not consume the entire finance team’s week, and how to present the findings in a way that the commercial team can act on without needing a course in data analysis first.
The EPOS system is already doing the hard work. It is logging every transaction, every product, every location, every hour of the day. The question is whether any of that is being turned into insight. If the answer is not really, a conversation is a sensible place to start.
To find out how we can help your business scale its finance function, call today on:
