Skip to content

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

Trading overview, 18 stores — Rolling six months to September

Net sales

$3.84m
+1.1% vs plan

Like-for-like growth

+4.2%
+0.9 pts

Gross margin

38.6%
−0.4 pts

Sales per sq ft

$412
+$18

Annualized

Net sales vs plan ($m)

PlanActual
0
1
2
3
4
Plan: 3.5Actual: 3.4
Plan: 3.5Actual: 3.5
Plan: 3.6Actual: 3.7
Plan: 3.7Actual: 3.6
Plan: 3.9Actual: 4.0
Plan: 3.8Actual: 3.8
AprMayJunJulAugSep

Sales by category, September

100% share
Grocery34 34%
Home19 19%
Apparel17 17%
Health & beauty14 14%
Electronics10 10%
Seasonal6 6%

Like-for-like growth by store (%)

Riverside9.1
Oak Park7.4
Harbor Point6.2
Westgate4.8
Millbrook2.3
Cedar Hill-0.6
Eastfield-3.1

Stock alerts

ItemCategoryStores outWeeks coverAction
Queen duvet, 10.5 tog, criticalHome60.8Expedite PO
Kids rain boots, seriousApparel41.2Transfer stock
Wireless earbuds, warningElectronics22.1Reorder
Halloween decor, warningSeasonal011.4Markdown plan

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. 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. 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. 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. 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. 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.