Build a same-location sales comparison that stays comparable

Same-location sales aim to compare activity at a consistent set of operations across two periods. The result depends on the rule for including a location. A newly opened site, a major relocation or a store closed for renovation may not provide a like-for-like comparison. Write the cohort rule before calculating growth.

Specify the maturity requirement, comparison dates and treatment of temporary closures. There is no need to invent a universal definition for every business. Choose a rule that answers management's question and apply it consistently. If external reporting requirements apply, have the appropriate reporting team review the presentation.

The SEC's guidance on metrics calls for clear definitions and explanation of calculation changes in its public-company context. The same discipline is useful for an internal location measure: a reader should know which operations are included and why a change in the cohort affects the result.

Consider an illustrative business with ten established locations. Those locations generated $5 million in the prior period and $5.2 million in the current period, producing comparable-location growth of 4%. Two new locations add another $800,000, bringing current total sales to $6 million.

Total sales growth is 20% compared with the prior $5 million. Both the 4% and 20% figures can be correct, but they describe different populations. Show the $200,000 increase at established locations separately from the $800,000 produced by openings. This allows management to see the contribution of expansion without attributing it to the existing estate.

Add closures and transfers explicitly. If a location closes, explain whether its prior sales are removed from the comparable cohort and how they appear in the total-growth bridge. The company-wide sales reconciliation should still account for every location, even when the comparable measure excludes some of them.

Two periods of equal calendar length can contain different numbers of open days, weekends or holidays. Record the operating calendar for each location and identify material disruptions. A renovation, weather closure or change in opening hours can affect sales without showing a straightforward change in customer demand.

Decide whether management needs an additional sales-per-open-day view. Label it as a separate measure and preserve the original sales total. Dividing by days does not automatically adjust for the value of a lost Saturday compared with a lost Tuesday, so explain where daily patterns matter.

Avoid excluding every weak period as exceptional. Establish the treatment before reviewing results, and show the effect of exclusions. If a disruption is part of the operating risk management needs to understand, removing it from every headline can make the measure less useful. A separate explanation may be more informative than adjusting the result away.

A new site can attract customers who previously purchased at an established one. The established location's decline may therefore reflect internal transfer as well as a change in market demand. Where evidence permits, examine customer movement, catchment overlap or order-routing changes before concluding that the older operation is deteriorating independently.

Online orders create another boundary. Decide how pickup, local delivery and returns are attributed. If a website order is credited to the pickup location this year but to a central channel last year, the same-location comparison can change without a comparable change in customer purchasing. Preserve the attribution rule and any bridge between old and new methods.

Do not claim precise cannibalization when the evidence cannot identify it. Present observed changes and a supported scenario instead. The operating decision may still require caution about adding capacity near existing locations, but the analysis should distinguish measured transfers from a plausible explanation.

Once the cohort is stable, investigate why its sales changed. A higher average selling price can raise revenue while transaction count falls. A shift toward lower-priced products can reduce revenue even if more customers visit. Use the underlying transaction and product data to explain the movement relevant to management's decision.

For an illustrative location, 10,000 transactions at a $25 average basket produce $250,000 of sales. If transactions fall to 9,500 and the average basket rises to $27, sales become $256,500. Revenue grows 2.6%, while transaction count falls 5%. The higher revenue does not by itself establish an increase in customer visits.

Review contribution and cash consequences separately. Larger baskets can carry different product costs or promotions. Same-location sales growth is an activity measure; it does not demonstrate that each location became more profitable. Keep the metric connected to the operational question without asking it to explain every financial outcome.

Store the included location list, exclusion reasons, source sales and calculation version for each reporting period. A location master file that changes retrospectively can make an old report impossible to reproduce. Preserve enough history to reconstruct the cohort that management actually reviewed.

When a definition changes, explain the reason and quantify the effect where reliable data permits. If an acquisition or system migration prevents a clean comparison, show the limitation rather than inventing an adjusted history. Readers can use a qualified result more confidently than a precise percentage built from incompatible records.

Give the operating team both the company-wide growth bridge and the comparable-location view. The first explains the complete business; the second isolates a defined group. Together they support decisions about existing sites, new openings and channel changes while keeping the underlying populations visible.