The tabs
Store Comparison
Store Comparison
Each store side by side, plus revenue against profit per store. This is
where a site with good sales and bad margin stops hiding inside the total.
Product Performance
Product Performance
Product, Units Sold, Revenue, COGS, Gross Profit and Margin. Sort by profit
rather than revenue — the busiest line is often not the one paying the rent.
Category Mix
Category Mix
Revenue and profit by category. Useful for shelf decisions: which category
earns its space.
Fuel Analytics
Fuel Analytics
Variance cause breakdown, margin by grade, and a variance table by date and
tank with the suspected cause and EPA status. See
Fuel.
Making the numbers trustworthy
Analytics is only as good as what has been recorded. Three things account for most odd-looking reports:1
Deliveries that were never checked in
Stock and cost never landed, so margin looks too good.
2
Sales that never imported
Revenue is missing and stock looks too high. Check
Sales Imports.
3
Products with no cost basis
Sold before they were ever received — these show as near-100% margin.
If a store shows no data at all, the usual cause is that no sales have been
imported for it yet.