Match Executive Summary purchases (O:R) against deliveries (I:K) per gas station. Purchases live in Executive Summary columns
O:R, deliveries in I:K. The Executive Summary is read only —
results are written to the matching spreadsheet.
production
Each bordered block is one purchase. The purchase columns
(A–I) are filled on the block's first row only; the delivery
columns (J–L) repeat for every delivery that purchase covers.
Columns M–R hold the invoice lines.
✅ Total Match — every amount bound, within 1000 L.
❌ No Match - Liters differ — the purchase and its deliveries are more than
1000 L apart; the delta cell is highlighted and Remarks says why. Worth investigating.
❌ No Match — a delivery with no purchase behind it.
❌ No Match - Purchase only — a purchase with no delivery.