Top customers for selected week
Highest weekly sales values
Lowest customers for selected week
Lowest positive weekly sales values
Customers who did not order
Includes the reason recorded on the MASTER sheet
| Account | Customer | Previous week | Reason |
|---|
Weekly movement
Largest decreases and increases
Largest decreases
Largest increases
Customer sales analysis
Search by customer name or account code
Select a customer to view their sales profile.
Customer weekly sales
Weekly sales across the selected date range
Customer details
Latest ordering information and follow-up context
- Account code
- —
- Customer
- —
- Reason for not ordering
- No reason recorded
- Previous week
- R0
- Week-on-week difference
- R0
- Two consecutive no-order weeks
- No
- Four-week incremental decline
- No
- Sales unit
- —
Monthly sales
Spend and average by month
| Month | Sales | Weeks with sales |
|---|
Top 50 customers
Ranked by total sales in the selected date range
| Rank | Account | Customer | Total sales | Monthly average | Unit |
|---|
Unit 20 vs Unit 21
Sales contribution for selected date range
Weekly unit sales
Weekly comparison and percentage contribution
Monthly unit sales report
Unit sales values and percentages by month
| Month | Unit 20 sales | Unit 20 % | Unit 21 sales | Unit 21 % | Total |
|---|
No order for 2 consecutive weeks
Customers requiring immediate follow-up
| Account | Customer | Current | Previous | Reason |
|---|
Four-week incremental decline
Sales decreased in each of the last four weeks
| Account | Customer | Week 1 | Week 2 | Week 3 | Week 4 |
|---|
Average monthly spend below R20,000
Based on the selected date range
| Account | Customer | Monthly average | Total sales | Reason |
|---|
Customers with an upward overall trend
Positive weekly regression trend across the selected range
| Account | Customer | Total sales | Trend per week |
|---|
All weekly decreases
Current week compared with previous week
| Account | Customer | Current | Previous | Difference | Change % | Reason |
|---|