Select Dashboard
Month
📊 Overview
🏪 Store Performance
🛒 Products
✦ AI Insights
⬆ Upload
🚪 Sign out
Viewing Data restricted to your access level
Overview · May 2026
All Stores
Loading…
—
Snapshot
Week Sales
—
—
GP%
—
vs Budget
—
Transactions
—
Trading Days
—
FY Performance · Month by Month
Actuals vs budget · Full financial year
How Budget Pace Works The % of pace metric explained — used across all views on this dashboard ▾ Click to expand explanation
Loading dashboard…
Director Notes & Action Items
Visible to all users · Anyone can comment
Loading…
Store Performance · May 2026
All Stores
Loading…
—
Stores
Click store name to drill down
Loading…
← Store Performance
Zone Summary Report · —
—
—
Quarterly trend — sales vs budget
Store performance
Aqua Vida Group · Oasis Water Sales Dashboard
AI Insights
Executive Commentary & Ask AI
AI-powered analysis of your live store data — group-wide, not scoped to one store
✦  Ask AI
Query your live store data
Stores where ASP/L dropped vs last year Top store this month Stores below budget Best GP% stores Which stores are not reporting? Month vs prior month Stores where ASP/L improved vs last year Litre achievement by store
Product Performance · —
Products
Top selling products by quantity, GP% and stock on hand
—
🔍
✦ AI Product Commentary
Click Generate to produce an AI commentary on product performance, trends and stock levels.
✦  Ask AI
Query product data
Top selling product this month Products with low stock Best GP% products Worst GP% products Products sold across most stores
Products by Category · MTD
Loading…
Admin · Products
Product Categories
Define categories, colours and keyword rules. Products are matched to categories automatically — pin individual products to override.
Categories
Loading…
Select a category on the left to manage its products
Store dashboard
—
—
Chart
Chart
Month-end forecast
Budget progress & GP analysis
Risk signals (latest)
Quarterly trend — sales vs budget
Daily log
DaySales RPrev mo.Δ MoMGP%#Trans
Top sellers · MTD
Add / override day Enter a day not yet in the log, or override parsed values
Saved.
Store Documents
No documents uploaded yet.
Daily report upload
Upload Store PDFs
Select multiple files at once — each is auto-parsed and saved to the shared database.
Upload daily PDF
Store
Drop PDFs here or click to browse
Multiple files supported · Auto-detects store from company code
Upload log
Loading…
Director · PDF bulk import
PDF Bulk Import
Upload a store's Daily Dashboard PDF to extract 3 months of sales history in one go. Saves directly to Prior Year Data.
Upload PDF
📄
Drop PDF here or click to browse
IQ Retail Daily Dashboard — extracts 3 months from page 3
Prior year data coverage
Loading coverage…
Budget management
Monthly Budgets
Enter monthly budgets per store
Saved.
FY2027 budgets Blank or zero = no budget set
User management
Users
Invite users and assign roles. Only directors can access this page.
All users
Loading…
Store administration
Store Management
Add, edit or remove stores. Director only.
All stores
Loading…
Alert configuration
Daily Alert Settings
Director receives one summary email at 9am covering all stores. Adjust thresholds below.
Alert thresholds
Alerts enabled
Turn all daily alert emails on or off
Alert email Receives all daily alerts
Send time All times UTC+2 (SAST) · FY runs May–Apr
Alert trigger thresholds
💰 Cash variance (R) Alert if |variance| exceeds this amount
🚫 Line voids MTD Alert if monthly voids exceed this count
📉 Budget behind (%) Alert if store is more than X% behind pace
⚠️ Negative GP items Alert if this many or more items sell below cost
🎯 GP% target Group-wide gross profit % target used across all views
Weekly summary email Every Monday 9am
A structured week-in-review covering all zones and stores. Sent automatically every Monday morning alongside the daily alert.
Group KPIs
This week sales, MTD achievement, WoW change
Zone breakdown
Per-zone sales, MTD vs budget, store count
🏆 Top 5 stores
Highest sales this week with WoW trend
⚠️ Bottom 5 stores
Lowest sales this week — needs attention
📈 Most improved
Biggest positive week-on-week movers
📉 Most declined
Biggest negative week-on-week movers
How daily alerts work

Every morning at the configured time, the system automatically checks all 46 stores and sends a single summary email to the alert address.

📄 Missing upload
Flags any store that has not uploaded a daily PDF by the alert time.
📉 Behind budget pace
Compares actual MTD sales to expected budget pace for the day of the month.
💰 Cash variance
Flags stores where the till count differs from IQ system value by more than the threshold.
⚠️ Negative GP items
Flags stores selling any product below cost price.
🚫 Line voids MTD
Flags stores with high month-to-date void counts — a potential fraud or training indicator.
If no alerts are triggered, you still receive a short "All clear" email so you know the system ran.
Store management
Store Management
Manage zones, categories and store types — changes update across the entire dashboard instantly.
Zones
Categories
Store Types
Segment stores by type (e.g. Retail, Wholesale). Available as a filter on dashboards.
Entities
Legal or trading entities (e.g. Aqua Vida, Winelands, West Coast). Assigned per store and used as a filter across dashboards.
IDNameDescriptionStoresActions
Prior year comparison data
Prior Year Data
Enter prior year monthly sales per store. Used for YoY comparisons across the dashboard.
Historical data
Actual litres dispensed per store
Actual Litres
Enter actual litres dispensed per store per month. Used to calculate ASP/L (Average Selling Price per Litre).
Actual litres
Enter actual litres dispensed (whole numbers). Used to calculate ASP/L = MTD Sales ÷ Actual Litres.
Water exchange subscriber data
Water Exchange
Enter Active Subscribers per store per month for the Water Exchange programme.
Active subscribers trend
Active subscribers
Enter one Active Subscribers value per store per month (whole numbers). This is a point-in-time count, not a cumulative total.
Debtor invoice analysis
Accounts Receivable
Upload tax invoice PDFs and analyse customers, products, and invoice history per store.
Upload invoices
🧾
Drop invoice PDFs here or click to browse
Select multiple files at once — all will be parsed and previewed before saving
Summary —
Sales & invoices over time
Top customers
Top products
Customers
Click a row to see that customer's invoices.
Products
Stock Management
On hand = cumulative stock transferred to this depot minus cumulative quantity invoiced, as of the date shown above. Compare against the "On Hand" column on Store Performance's Top Sellers card for a sense check — differences can point to wastage, unrecorded transfers, or invoices not yet captured here.
Invoices
Click a row to see line items.
Upload quality control
Parse Verifier
Drop a Daily Dashboard PDF to verify what the parser will extract — before or after uploading.
Drop PDF to verify
🔍
Drop PDF here or click to browse
Runs the same parser used during upload — shows every field with pass/fail
Verification results
📋
No PDF loaded yet
Drop a Daily Dashboard PDF on the left to see results here.
Director · Configuration
Chart Builder
Define graphs that appear in store views. Changes apply to all users.
Saved graphs
Loading…