Network Footprint — Year-End Active Trading Points
Oasis footprint
FY22
DR / DB (var)
FY23
DR / DB (var)
FY24
DR / DB (var)
FY25
DR / DB (var)
FY26 ●
DB live
DR = Directors' Report · DB = stores with volume recorded in VOL_MAP for that FY · var = DB − DR · FY26 ● live (no DR baseline yet)
¹Basis of preparation difference — not a restatement.
The DR column represents year-end active trading point counts as disclosed in the audited Directors' Report
(Oasis Water Holdings, year ended 30 April). The DB column is derived independently from operational
volume transaction records (VOL_MAP) and counts any store with at least one litre recorded during the
corresponding financial year. Variances arise from differences in measurement basis rather than error,
and do not constitute a restatement of previously reported figures within the meaning of
IAS 8 — Accounting Policies, Changes in Accounting Estimates and Errors (paras. 41–53).
Specifically: (i) stores commissioned late in a financial year may appear in the DR year-end count
but carry no volume in the DB for that period; (ii) stores dispensing water without formal
year-end commissioning status may appear in the DB but not in the DR. Users should treat the
variance column as a reconciling difference between two independently prepared data sources,
each with a distinct and valid measurement objective.
Volume Growth — Annual & Monthly Trajectory
Annual Volume (Litres)
Monthly Volume — Current vs Prior Year
Toggle
Portfolio Composition
Ownership Split
Volume by Region
Top Performers
Top 10 Stores — All Time
Top 10 Stores — YTD
Bottled Water Volumes
Total Bottles
72.9M
units · FY2026
Still
70.6M
units · 76.8 ML
CSD
2.3M
units · 1.4 ML
Bottled Volume
78.2 ML
78,179,666 litres
% of Network
31.2%
250.7 ML total network
Volume Composition — FY2026
Bottled 78.18 ML · 31.2% 72.9M units · 78,179,666 L
Refill 172.52 ML · 68.8% 172,520,334 litres
Total: 250.70 ML · 250,700,000 litres
Bottled Split by Ownership (pro-rata)
Corporate 31.59 ML · 40.4% 31,589,949 L · 143 stores
Franchisee 46.59 ML · 59.6% 46,589,717 L · 280 stores
Oasis Water Group · Performance by Volume (Litres) · 2020–2026—
Store Performance · All Time
All Stores
Select a store to drill into its performance.
Period
Filter
⌕
— stores
Store Detail
—
—
Total Volume
—
—
Best Month
—
—
Latest Month
—
—
Avg / Month
—
Active months
Growth
—
—
Monthly Volume Trend
Annual Comparison
Filtered Total—— stores
Store Rankings—
Loading…
—
Volume Entry
Update Store Volumes
Search for a store, then add or edit monthly volume records.
Select Store
⌕
Selected Store
Volume Entries
← Select a store first
Filter
⌕
—
Volume Records
Use the filters above to find records.
—
Last 100 Updates
Loading…
Store administration
Store Management
Add, edit or deactivate stores. Director only.
All stores
Filter
Loading…
User administration
Users
Invite users and manage roles. Director only.
All users
Loading…
Store setup
Store Setup
Manage store types and ownership entities — changes update across the entire dashboard instantly.
⚠ One-time setup required. The store_types and/or entities tables are missing. Run the SQL below in your Supabase SQL editor, then refresh:
CREATE TABLE IF NOT EXISTS store_types (
id text PRIMARY KEY,
name text NOT NULL,
color text DEFAULT '#6B7F8C',
description text DEFAULT ''
);
CREATE TABLE IF NOT EXISTS entities (
id text PRIMARY KEY,
name text NOT NULL,
color text DEFAULT '#475569',
description text DEFAULT ''
);
CREATE TABLE IF NOT EXISTS store_statuses (
id text PRIMARY KEY,
name text NOT NULL,
color text DEFAULT '#6b7280',
is_active integer DEFAULT 0,
description text DEFAULT ''
);
-- Allow authenticated users to read/write statuses:
ALTER TABLE store_statuses ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON store_statuses FOR ALL USING (true) WITH CHECK (true);
Store Types
Segment stores by type (e.g. Express, Retail). Used as a filter on dashboards.
Store Statuses
Define valid store statuses (e.g. Open, Closed). The is active flag controls whether stores count as open in KPIs.
⚠ One-time setup: Run this SQL in your SQL editor to create the table and allow writes. Until then, statuses are saved in your browser only.
CREATE TABLE IF NOT EXISTS store_statuses (
id text PRIMARY KEY,
name text NOT NULL,
color text DEFAULT '#6b7280',
is_active integer DEFAULT 0,
description text DEFAULT ''
);
-- Allow authenticated users to read/write statuses:
ALTER TABLE store_statuses ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON store_statuses FOR ALL USING (true) WITH CHECK (true);
Loading…
Regions / Provinces
Define regions/provinces for store assignment. Used as a filter across all dashboards.
⚠ One-time setup: Run this SQL in your SQL editor to persist regions to the database. Until then, regions are saved in your browser only.
CREATE TABLE IF NOT EXISTS store_regions (
id text PRIMARY KEY,
name text NOT NULL,
abbr text,
sort_order integer DEFAULT 0
);
ALTER TABLE store_regions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON store_regions FOR ALL USING (true) WITH CHECK (true);
Loading…
Ownership / Entities
Ownership entities (e.g. Corporate, Franchise). Assigned per store and used as a filter.
ID
Name
Description
Actions
New Region
New Status
Add store
Store ID / Code
Store Name
Region / Province
Store Type
Ownership
Franchisee
Status
Edit
ID
Name
Description
Data Management
Import & Export Store Data
Parse the master XLSX and import into the database, or export the current database contents. Use Wipe & Re-import to delete all existing volume data first.
📥 Import Data
Step 0 · Choose XLSX file
No file selected
Select a franchisee to import one at a time
Parse result
—
Unique stores
—
Volume records
—
FY26 (May25–Apr26)
⚠️ Destructive: ALL rows in store_volumes will be deleted before re-importing. This cannot be undone. Confirm by clicking the red button below.
Log
Choose a file above to begin…
📤 Export Data
Export Data
Download every store, with its monthly volumes, as an XLSX workbook in the same layout the importer expects — you can re-upload this file in the Import Data section above without any changes.
Account
My Profile
Manage your account details and password.
Account Details
—
—
—
—
Changing your email will require confirmation via the new address.
Change Password
Session
Role—
Last sign-in—
Account created—
User ID—
Change User Role
Changing role for
—
Role permissions: Viewer — read-only access to all dashboards Manager — can add and edit volume records Director — full access including user admin
Edit Display Name
Editing name for
—
This only changes what's displayed in the dashboard — it does not affect their email or password.
Add Volume Entry
Invite User
The user can change this after signing in via Forgot Password.