How to compare gas station store performance across multiple locations.

Key takeaways

Same-store-vs-baseline beats peer comparison for anomaly detection. A high-volume urban store and a low-volume rural store have different "normal", compare each to itself first.
Use percentage-based KPIs (margin %, variance % of sales) for cross-store comparison. Absolute dollars confuse volume with efficiency.
The eight comparison metrics: inside sales, fuel gallons, fuel margin, cash variance, lottery variance, inventory shrink, expenses, unresolved manager notes. Each maps to a specific operational lever.
Rank stores by exposure (unresolved variance % of sales), not by absolute dollars. A $4k/day store with 10% exposure is a bigger operational issue than a $20k/day store with 2.5% exposure.
Triage follow-up by attribution clarity, not by dollar amount. A pattern with clean shift attribution beats a larger but unattributable variance.

What does “compare store performance” actually mean?

Multi-store owners compare across locations to identify where to spend attention. The answer isn't which store has the highest sales, that's usually obvious. The answer is which store is underperforming against its own baseline, against operational benchmarks, or against the rest of the portfolio.

Three comparison frames matter:

Same-store vs. baseline.The store's current performance against its trailing 30/90-day average. The primary anomaly signal.
Peer comparison. One store against another in the portfolio, normalized for size and store profile. Secondary signal; useful when peer stores are similar.
Industry benchmark. Comparison to NACS or equivalent industry data. Tertiary; useful for periodic calibration but not for daily ops.

Baseline → peer → industry

Comparison order

Same-store-vs-baseline catches anomalies first; peer comparison contextualizes; industry benchmarks calibrate occasionally.

Eight metrics to compare across stores

1. Inside sales (non-fuel revenue)

Daily and weekly inside-store sales by store. The margin lives here, not at the pump. Track per-store vs. baseline and as a percentage of total revenue (inside-sales mix).

2. Fuel gallons per grade

Volume by grade per store. Useful as a sales-mix signal, premium share, diesel share, and as a leading indicator for margin analysis.

3. Fuel margin per grade

Realized margin per grade per store. Compare against target and across the portfolio. Persistent gaps over 3¢/gal flag for pump calibration or wholesale-cost audit.

4. Cash variance

EOD variance per shift, rolled up per store per day. Track as absolute dollars and as a percentage of cash sales. The percentage normalizes for size; absolute is the dollar exposure.

5. Lottery variance

Missing scratcher serials per store, settlement mismatches, commission-vs-tracked discrepancies. Compare per store and per shift attribution.

6. Inventory shrink

Category-level shrink rate per store. Tobacco prioritized. Compare each store's shrink rate to its trailing 90-day average; peer-compare across portfolio.

7. Expenses

Operating expenses (non-COGS) per store, by category. Compare as a percentage of revenue to normalize for size. Vendor concentration in any category over 30% deserves periodic review.

8. Unresolved manager notes

Open items from shift handoffs that haven't closed. Equipment issues, vendor disputes, customer complaints. A store with consistently more unresolved items than peers signals management process problems.

Example: a 5-store comparison table

STORE COMPARISON. Wednesday morning brief

Metric         Store 1   Store 2   Store 3   Store 4   Store 5
Inside $/day   $4,820    $3,210    $5,840    $2,140    $4,150
   vs baseline    -2%      -8%       +1%       -15%     +3%
   (flag)         ok       check    ok         FLAG     ok

Gallons/day    3,420     1,890     5,210     1,420     3,680
   vs baseline    +1%      -4%       +3%       -12%     +2%
   (flag)         ok       ok        ok         FLAG     ok

Fuel margin    17.8¢     16.2¢     18.4¢     14.1¢    17.6¢
   target gap    -0.2     -1.8      +0.4      -3.9     -0.4
   (flag)         ok       ok        ok         FLAG     ok

Cash variance  $-12      $-8       $-47      $-22     $-15
   % of cash      0.4%    0.3%      1.1%      1.4%     0.5%
   (flag)         ok       ok        FLAG       FLAG    ok

Lottery flag   0          0         2         0         0
   (note)         clean   clean     check     clean    clean

Inventory shrink (last 7d)
                1.8%      2.1%      2.4%      3.6%     1.9%
   (flag)         ok       ok        check    FLAG      ok

Open manager notes
                0         1         0         4         1

ACTION TODAY
  - Store 4: combined flag across sales, gallons, margin, shrink, notes.
    Highest-attention store. Likely operational issue at the store level.
  - Store 3: cash variance + lottery flag. Cross-signal, investigate
    same overnight clerk.

OK FOR REVIEW
  - Stores 1, 2, 5: within their own baseline; no action required.

Store 4 has the most signals, but the percentages matter more than the absolute numbers. Store 4 is $2,140/day in sales (the smallest), but its variance percentages are the highest. That's the operational issue.

Store 3 has the highest absolute cash variance ($-47) but a modest percentage (1.1%). At a $5,840/day store the variance is within reasonable noise. The lottery flag is the real signal at that store.

What should trigger a follow-up

Signal	Action	By when
Single-store multi-signal flag (3+ metrics)	Store-level operational review with manager	Same day
Cross-store same-pattern (same metric, multiple stores)	Portfolio-level cause investigation (vendor change, pricing, policy)	Same week
Single-metric outlier on one store	Manager conversation, watch for second-day repeat	Next morning
Above-portfolio shrink (top-quartile store)	Per-category investigation	Within 1 week
Consistent baseline drift (90-day)	Structural review, staffing, vendor, location, pricing	Monthly

How to avoid spreadsheet chaos at multi-store comparison

Multi-store comparison in a master spreadsheet works at 2–3 stores. At 5+ stores the maintenance overhead exceeds the value. The failure modes:

Per-store formula drift. Each new store adds a column to every roll-up tab. Formula errors compound; baseline comparisons start referencing the wrong cells.

Manual data entry lag.Yesterday's numbers get entered today. By the time the comparison runs, the attribution window is closing.

Permissions break.The owner can't share the portfolio spreadsheet with regional managers without exposing other stores. Either over-share (manager sees everything) or under-share (manager can't do their job).

Frequently asked questions

How do you compare gas station performance across multiple locations?

Track eight metrics per store: inside sales, fuel gallons, fuel margin, cash variance, lottery variance, inventory shrink, expenses, and unresolved manager notes. Compare each store to its own trailing baseline first, peer-compare across the portfolio second. Use percentage-based metrics to normalize for size differences.

Should I compare by absolute dollars or by percentage?

Percentages for cross-store comparison; dollars for exposure ranking. A $4k/day store with 10% variance exposure is a bigger operational issue than a $20k/day store with 2.5% exposure, even though the second has more absolute variance dollars. Percentage normalizes; dollars rank.

What's the difference between baseline and peer comparison?

Baseline comparison is same-store-vs-its-own-history, the primary anomaly signal. Peer comparison is one store vs. another in the portfolio. Use baseline first (catches store-specific anomalies); peer second (contextualizes); industry benchmarks third (calibrate occasionally).

When should I flag a store for follow-up?

Multi-signal flag (3+ metrics out of band on same store) → same-day operational review. Cross-store same-pattern (same metric flagging on multiple stores) → portfolio-level cause investigation within a week. Single-metric outlier → manager conversation, watch for second-day repeat.

How many metrics should I track for comparison?

Eight is a useful balance. Inside sales, fuel gallons, fuel margin, cash variance, lottery variance, inventory shrink, expenses, and unresolved manager notes cover the operational layers that drive most decisions. Beyond eight, comparison fatigue produces no actions.

How often should I run multi-store comparison?

Daily for the high-cadence metrics (sales, EOD variance, lottery exceptions, fuel margin). Weekly for the medium-cadence (inventory shrink, expense run-rate, manager performance). Monthly for trends. The daily cadence preserves shift-level attribution; longer cadences lose it.

Should every manager see the cross-store comparison?

No. The owner sees the portfolio comparison. Regional managers see only their stores. Store managers see their own store and how it ranks against the portfolio (without seeing other stores' specific numbers). Scoping prevents cross-store data leakage while keeping each role contextually informed.