Drop the weekly workbook here
.xlsx · sheets “Retail Qty TY” (pieces sold) and “Waste TY” (waste €, converted to units at SKU RRP) · store number from row 3, product code from the end of column A
Files this week
2
Sales + waste
Rows received
481
Match rate
99.4%
478 matched to master data
Open exceptions
3
Resolve before week close
Upload history
Batches received for week 30
| File | Type | Uploaded by | Received | Rows | Matched | Exceptions | Status |
|---|---|---|---|---|---|---|---|
| Retail_Actual_Sales_W30_2026.xlsx | Sales | s.devoy@keelings.ie | 2026-07-27 08:14:00 UTC | 254 | 252 | 2 | Needs review |
| Retail_Waste_Details_W30_2026.xlsx | Waste | e.flynn@keelings.ie | 2026-07-27 08:29:00 UTC | 227 | 226 | 1 | Needs review |
Exceptions
Rows that could not be matched to a store or SKU — these are excluded from the stock balance until resolved
| Source | Store number (raw) | Product code (raw) | Value / units | Reason | Action |
|---|---|---|---|---|---|
| Sales | 9911 | 383779 | €218.40 | Store number not found in master data | |
| Sales | 1703 | 999123 | €96.50 | Product code not found in master data | |
| Waste | 8801 | 363946 | 12 | Store number not found in master data |