1
Deal Type
Select to begin
New / Add SIM
New contracts & additional SIMs
Upgrades & CVM
All upgrade deals including CVM
2
Brand
Locked
Select...▼
3
Device
Locked
Select...▼
4
Package / Plan
Locked
Select...▼
5
Contract Term
Locked
Select term...▼
6
Add-on
Locked
All
No Add-on
With Add-on
7
Max Monthly Price
Locked
Start with Deal Type
Select New/Add SIM or Upgrades & CVM above to begin.
1
Brand
Select to begin
Select...▼
2
Device
Locked
Select...▼
3
Package / Plan
Locked
Select...▼
4
Contract Term
Locked
Select...▼
5
Add-on / Freebie
Locked
All
No Add-on
With Add-on
6
Max Monthly Price
Locked
Business Deals
Select a deal type to begin browsing EBU deals.
My Sales Summary (This Month)
Consumer
0
New
0
Upgr
EBU
0
New
0
Upgr
0 sales · My records only
Target Progress
Loading target...
Log a Sale
Select the employee this sale belongs to
Date the sale took place
⚠️
Estimated Commission
The commission figures shown below are estimates only based on sales you have recorded on this portal. All commissions are subject to validation and approval by Head Office before payment. Final figures may differ.
🎯 Target requirement: Sales Consultants must meet their monthly sales target to qualify for commission. Commission will not be paid if the target is not achieved.
My Recorded Sales
| Date | Category | Invoice | MSISDN | Account No. | Package | Term | Status |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
⚙
ADMIN PORTAL
MTN Afrikan Adage
👤 Staff Profiles
UPDATE REQUESTS
Loading…
EDIT A STAFF PROFILE
📋 Stock Take Dates
Set the stock take date per store per month. The roster generator reads these dates automatically. Stock take day = all staff on full shift, minimum 5 at Boardwalk and 6 at Walmer Park.
Staff Access
Manage who can log in to the Staff Price Book
📥 Import from Google Sheets
Pull existing staff from the current Google Sheet, fill in position & store, then save to MySQL.
| # | Staff Member | WhatsApp Number | Position | Store | Geofence | ||
|---|---|---|---|---|---|---|---|
| Log in to view staff | |||||||
Upload Deal Sheet
Upload the monthly MTN Excel deal sheet to update the Staff Price Book
Reading file...
Commission Rates
Flat rates per category with validity periods
| Category | Plan | Rate | Valid From | Valid To | |
|---|---|---|---|---|---|
| Log in to view rates | |||||
Store Targets
Monthly revenue targets per store (ex VAT)
Commission Overview
View all agent commissions and mark as paid
| Staff Member | Phone | Sales | Total Revenue | Commission | Action |
|---|---|---|---|---|---|
| Select a month to view | |||||
Upload Business Deal Sheet
Upload the MTN EBU/Business Excel deal sheet
Reading file...
Upload Postpaid Leads File
Monthly MTN Postpaid Leads .xlsx — groups customers by EPPACC into the Leads tab
⚠️ Activating a new file automatically archives the previous month's leads. All rows are written to MySQL — nothing is stored in the browser.
Total Sales Report
Upload the monthly payroll Excel file to auto-generate the report
Upload the monthly payroll Excel file to generate the report
💹 Commission Tier Table
Commission % = Subscription × Term × Rate. Editable below. Changes apply immediately on save.
| Min (R) | Max (R) | Rate (%) | Valid From | Valid To |
|---|
📦 Package & Subscriptions
Define plans for Consumer and EBU/Business. These feed the Package/Plan dropdown in Log a Sale.
| Category | Package / Plan | Subs excl. VAT (R) |
|---|
🏢 Dealer Commission Tiers
| Min | Max | Rate | % | |
|---|---|---|---|---|
| Loading... | ||||
🎯 Store Targets
Store target is worked out automatically: staff × individual target. Set the individual line target, then the staff count per store — the store target updates live.
🚚 Courier Management
Log, track and manage inter-store deliveries
PENDING
0
AWAITING
0
COLLECTED
0
IN TRANSIT
0
DELIVERED
0
REJECTED
0
📅 Monthly Overview
✅ Completed Deliveries
🕑 Pending Deliveries
👥 Courier Team
Manage courier manager and drivers — no portal access
Head Office Dashboard
Sales performance overview representative data
Total Sales
—
14% vs last month
Revenue
—
8.3% vs last month
Contracts
—
11.2% vs last month
Dealer Comm
—
7.6% vs last month
Target Achievement
—
6% vs last month
Sales Trend
ContractsDealer Comm
Sales by Category
Top Performing Stores
| Store | Sales | Revenue | Target | Achievement |
|---|
Top Performing Consultants
| Consultant | Sales | Dealer Comm | Revenue |
|---|
Leads Intelligence
125Total Leads
39Contacted
31%Conversion
7%Follow-up
4%Uncontacted
Contracts by Store
Store Performance Overview
| Rank | Store | Sales | Revenue | Target | Achievement |
|---|
📦 Stock Reservation Tracker
+ New Reservation
| Date | Staff | Device | IMEI | Order # | Reason | Status | |
|---|---|---|---|---|---|---|---|
| Loading reservations... | |||||||
🕐 Staff Shift Tracker
Active: 0
Completed: 0
On Lunch: 0
Tap a pin to see active agents at that location
📋 Staff List
| Staff Member | Store | Sign On | Lunch Out | Lunch In | Sign Off | Duration | Status |
|---|---|---|---|---|---|---|---|
| Select a date to load shifts. | |||||||
📅 Staff Shift Roster
⚙️ Roster Rules
✔ Rules:
Stock take = full day, min 5 (Boardwalk) / 6 (Walmer)
· 45h/week BCEA cap · Max 4 consecutive work days
· Max 2 consecutive days off · Min 175h · Max 180h/month
· Weekend off alternates monthly
· Min 3 open & 3 close
· Sunday ×1.5
🕒 Trading Hours (editable per store)
Mon – Sat
to
to
to
Comma-separated dates. If "Public holiday open" is off, the store is closed (staff marked Public Holiday, paid). If on, staff work the PH hours at ×2 premium.
⚖️ Worked hours = trading hours minus a 1-hour unpaid lunch (so 08:30–18:00 = 8.5h).
Wendy works across Boardwalk, Walmer Park and Kenako as additional cover. Click any cell in her row to assign a store for that day.
Select a store and month, then click Generate.
EBU
Commission Stats
⚡ Spiv Claims
via ecentive
| # | Submitter | Approved | Incentive | Top Brand | Channel |
|---|
Total Spiv Incentive
Approved only · paid via ecentive (separate from payroll)
📝 Log a Request
Your request will be sent via WhatsApp to management. You will be contacted once reviewed.
--:--:--
Not Signed In
Hours Worked
0m 00s
On Lunch
0h 00m
Lunch Out
—
Lunch In
—
📋 Today's Shift Log
No entries yet today.
🏠
Welcome
Your day at a glance
🕑 Your Shift
Not signed on
Remember to sign on at the start of your shift.
Pending Queries
Loading…
📢
Head Office Announcements
Official notices from Head Office
Loading…
🆘
Helpdesk
Guides for common problem areas
Loading…
🚶
Foot Traffic Analysis
Logging visits
🏦
Banking Recon
Daily store reconciliation
💰 Cash on Hand
Enter the cash physically in the store for this store. Banking a deposit below reduces this amount.
💵 Cash Banking
Recording a deposit subtracts it from cash on hand for the store.
Store DER (expected)
Enter the figures from the Store DER. Expected terminal amounts are computed below.
Expected AA Terminal
R0
Invoices − Credit Notes − Payflex
Expected MOMO Terminal MTN
R0
MTN Payment
Expected Terminal Total
R0
= DER terminals − Payflex
Captured take-ins (actual)
R0
R0
👥
Customer Master
Account reference list for customer profiling
Upload account list (.xlsx)
File must have two tabs: EPPIX and ILULA. Column 1 = account number, column 2 = customer / company name.
Names are cleaned automatically (spaces trimmed, Title Case). Existing accounts update; new ones are added.
| Account No | Customer / Company | Source | Actions |
|---|---|---|---|
| Loading… | |||
📈
Customer Value Prop — Dealer OGR
Ongoing revenue & contract base per customer
Customers
Loading…
● Numbers highlighted in red are no longer listed on the latest month uploaded.
● Green = new this month.
● Upgradeable = term date within 4 months.
💸
Staff Commissions
Live projected commission & qualification per consultant
| Staff | Store | Consumer New / Upg |
EBU New / Upg |
Contracts / target |
Avg Sub | Progress | Projected Comm | Qualifies |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Qualification = reaching 80% of the individual store target (the same rule each consultant sees on their home screen). Avg Sub = average monthly subscription per contract. Figures are live from logged sales and estimated — subject to Head Office validation.
🔗
Useful Links
Quick access to systems, tools & resources
Loading…
💰
Profitability — Rent‑a‑Desk
Each consultant must cover their seat
How this reads: Profit proxy = dealer commission earned on that consultant’s sales. Cost = salary + desk cost.
Net contribution = profit − cost. Ratio = profit ÷ cost (below 1.0× = doesn’t cover the seat).
Judge the trend, not one month. Use figures as evidence in a fair PIP process — not as an automatic reason to dismiss.
| Consultant | Store | Contracts | Profit (Dealer) | Salary | Desk | Total Cost | Net Contribution | Ratio | Trend (6m) | PIP | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||
Active & Recent PIPs
🚨
Escalation History
Log and track MTN escalation records
➕ Log New Escalation
📜 Recent Escalations
Loading...
📊
Finance Stats
Line Commissions · Ongoing Revenue · SIM Swaps — Admin & Owner only
📂 Upload Monthly Files (click to expand)
—
YTD Deals
—
YTD Upgrades
—
YTD New Acts
—
YTD SIM Swaps
—
YTD Line Comm
—
YTD Sub Revenue
—
YTD Swap Comm
—
YTD Total Commission
Monthly Commission Trend
Monthly Deals (Upgrades vs New Acts)
Monthly Performance Comparison
| Month | Deals | Upgrades | New Acts | SIM Swaps | Line Comm (excl) | Sub Revenue | Swap Comm | Total |
|---|---|---|---|---|---|---|---|---|
| Select year and click Refresh | ||||||||
Store Performance
| Store | System | Deals | Upgrades | New Acts | Line Comm | Sub Revenue |
|---|---|---|---|---|---|---|
| Load a month above | ||||||
🟡 EPPIX Store Performance (line_comms_1 — Helios)
| Store | Deals | Upgrades | New Acts | M2M | VLC | Line Comm (excl) |
|---|---|---|---|---|---|---|
| Select a month above to load EPPIX store breakdown | ||||||
💬
WhatsApp Leads
–
Total
–
New
–
Today
→ Scroll right to see all columns
| # | Type | Customer | Phone | Best Time | Status | Received | Actioned At | Contacted By | Notes | Chat | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||||
Update Lead
🌐
Website Leads
–
Total
–
New
–
Today
→ Scroll right to see all columns
| # | Type | Customer | Phone | Interest | Address | Best Time | Status | Received | Actioned At | Assigned To | Notes | Contact | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||||||
Update Lead
🎯 UPGRADE BASE
–
ACCOUNTS
–
UNCLAIMED
–
MINE
Loading…
⏳ You have 3 days from the day you claim a lead to work it. If no outcome is logged within 3 days, the lead returns to the pool for others to claim.
📲 BOT & LOGIN REPORTS
Admin only · every bot payment-link request and every successful staff login.
💳 Bot Payment Requests
🔐 Staff Login Report
💳 PAYFLEX build 16
Enter an amount, generate a payment, and let the customer scan the QR code in-store. Payments update automatically.
New payment
The customer QR code will appear here.
📋 CONTRACT ADVISOR
Enter the Deal ID from iLula, or filter by OEM and device.
Look up by Deal ID
Or filter by device
⭐ QA CHECK
–
CUSTOMERS
–
SURVEYED
–
PENDING
–
NOT REACHED
Loading…
↩️ FTU RETURNS
Scan or type the IMEI
🎫
Query Tracker
Internal audit trail per customer query — every SNOW/SR ticket on one record until properly closed
➕ Log New Customer Query
🛠️
System Issues
DebiCheck mandates, EPPIX errors, activation failures — tracked to resolution with a full audit trail
➕ Log New System Issue
👤 Affected Customer (optional — start with the ID number)
👤 MY PROFILE
Loading the Deals Editor…
📦 BASE PACKAGES
Admin only · the data & minutes each plan includes. Deal Search matches a deal’s plan name against these entries (longest match wins) to show the Base Package and calculate Base + Promo totals. Edits apply portal-wide the moment you save.
Add a Base Package
Loading…
Dealer KPI Tracker
MTN Eastern Cape · bonus awarded per KPI, per store, at 80%+ for the quarter
💹 Commission Dashboard
Dealer contribution & profitability · target ratio 2.5× · Admin only
How this reads: Gross Sub Comm = total subscription commission ex VAT. Dealer Comm = the total dealer commission captured on the consultant’s live sales.
Required Gross Sub = (Salary × 2.5) ÷ 0.07. Profitability Ratio = Dealer Comm ÷ Salary. Target = 2.5×.
Gap to Target shows green when met and red when short. ASPUL = average monthly subscription per contract.
By Store
Dealer Contribution by Consultant
Profitability Ratio by Consultant
Gross Subscription by Store
Salary vs Dealer Contribution
Consultant Detail
| Loading… |
🏆 Consultant Performance
Contracts, dealer commission & CSP commission paid · Admin only
Source: the uploaded Total Sales Report (
TSR_YYYY-MM.json) — the same data behind Commission Stats.
CSP Commission is only paid when the consultant qualifies (total contracts ≥ 80% of target). Months not qualified contribute R0.
QTD/YTD sum each month in the period independently, so qualification is assessed month by month.
Consultant Detail
| Loading… |
🔎 Deal Search
MTN deal ID catalogue — only deals valid today are shown by default.
–Live deals
–Consumer
–Business
–Last upload
Search deals
Select all · Clear
⚖️ Compare deals
🗂️ Deal Browser
Browse the MTN deal catalogue with filters — live deals only.
Select all · Clear
Select all · Clear
Select all · Clear
Select all · Clear