Retail dashboard builder
Sales against plan, like-for-like growth, footfall, conversion and stock for a store estate. Change the numbers to yours and download the slide.
New here? — takes 2 minutes.
Retail dashboard
Like-for-like growth
Gross margin
Sales per sq ft
Annualized
Net sales vs plan ($m)
Sales by category, September
Like-for-like growth by store (%)
Stock alerts
| Item | Category | Stores out | Weeks cover | Action |
|---|---|---|---|---|
| Queen duvet, 10.5 tog, critical | Home | 6 | 0.8 | Expedite PO |
| Kids rain boots, serious | Apparel | 4 | 1.2 | Transfer stock |
| Wireless earbuds, warning | Electronics | 2 | 2.1 | Reorder |
| Halloween decor, warning | Seasonal | 0 | 11.4 | Markdown plan |
Edit widget
Your data
4 Retail Sales Dashboard templates
Every template opens as a finished dashboard. Pick the closest one, then change anything.
Metrics and how to calculate them
The KPIs these templates are built on, with the formula behind each one.
- Like-for-like sales growth
- Sales this period ÷ sales in the same period last year − 1, counting only stores open in both periods.
- Sales per square foot
- Net sales ÷ selling floor area in square feet, usually annualized.
- Conversion rate
- Transactions ÷ store footfall × 100.
- Average basket
- Net sales ÷ number of transactions.
- Gross margin
- (Net sales − cost of goods sold) ÷ net sales × 100.
- Sell-through
- Units sold ÷ (units sold + units on hand) × 100, measured over the season.
- Weeks of cover
- Stock on hand at cost ÷ average weekly sales at cost.
- Shrink
- Inventory lost to theft, damage and errors ÷ net sales × 100.
How to make your Retail Sales Dashboard
Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.
- 1
Pick your dashboard
Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as Retail sales overview and Store comparison. Each opens finished, with example figures.
- 2
Change the numbers
Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.
- 3
Use your own data
Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.
- 4
Download PDF, PowerPoint, Excel and more
Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.
- 5
More options: add widgets, brand it, share
More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.
Common questions
What KPIs should a retail dashboard include?
Net sales against plan, like-for-like growth, gross margin, footfall, conversion and average basket cover most trading reviews. Add stock cover and sell-through for merchandise decisions.
How do I compare stores fairly?
Use like-for-like growth and sales per square foot rather than raw sales, since those adjust for store age and size. The Store comparison template ranks stores on both.
Is there a version for a supermarket?
Yes. The Supermarket template tracks weekly sales against last year, basket size, fresh waste and on-shelf availability by department.
Can I add data from my POS system?
Export sales by store, week or category from your point-of-sale reports as CSV and upload it on the matching chart, then download the dashboard as PowerPoint or Excel.
Goes well with this — from our other free tools
The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.

SlideTeam