Load a sales file to begin
Drop an .xlsx or .csv anywhere on this page, or choose a file. Every tab in a workbook is read as a separate period.
Expected columns (header row can sit anywhere in the first 25 rows)
| Column | Required | Used for |
|---|---|---|
| Item | Required | Product identity, all product rankings |
| Line value | Requiredor Order total | Sales value, every money figure |
| Order total | Recommended | Order value; falls back to line value + delivery |
| Order No | Recommended | Groups lines into orders; its stamp gives date & time |
| Quantity | Recommended | Units sold, unit price, price consistency |
| Name / Company | Recommended | All customer panels and rankings |
| Wolseley code | Optional | Merging product spelling variants |
| Delivery | Optional | Delivery charge analysis |
Total sales value
—
Top 5
The headline rankings for the selected period
Products by value
Products by quantity
Web customers by spend
Sales over time
Sales value per month, including delivery
Orders by day of week
Which weekdays customers actually buy on
Orders by hour of day
Time of day the order was placed
Top customers
Ranked by total spend, delivery included
Repeat business
How many customers order once, and how many come back
Order size distribution
Number of orders by order total
Top products
Ranked by sales value, delivery excluded
Revenue concentration
Cumulative share of sales value as products are added, best-seller first
Where the money sits
Sales value by unit-price band
Delivery charges
Orders by delivery charge applied
Price consistency check
Products bought in more than one order at unit prices more than 1% apart
All customers
All products
Period A
Period B
Headline change
Period A measured against period B
Trend, side by side
Product movers
Biggest gains and losses in sales value between the two periods
Grew the most
Fell the most
Customer movers
Who spent more, who spent less, who stopped buying