Net sales
$20,210
Avg transaction
$48
Conversion
24%
Retail Sales Tracker
Daily sales by channel with transactions, average basket and target progress.
4 free retail sales report templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Store Operations, E-commerce Operations and Pricing & Merchandising. Start with Retail Sales Tracker, E-commerce Sales Dashboard by Channel and Retail Store KPI Scorecard: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Net sales
$20,210
Avg transaction
$48
Conversion
24%
Daily sales by channel with transactions, average basket and target progress.
Revenue
$159,850
Average order value
$39
ROAS
7.4
Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.
Sales
$308,840
Conversion rate
14%
Average transaction value
$33
Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.
Overall sell-through
53%
Lines to reorder
4
Lines to mark down
4
Units received and sold by product, with sell-through rate, weeks of cover and a reorder or markdown call.