MTN Afrikan Adage - Staff Portal

Deal Type

Select to begin

➕New / Add SIM

New contracts & additional SIMs

🔄Upgrades & CVM

All upgrade deals including CVM

Brand

Locked

Select...▼

Device

Locked

Select...▼

Package / Plan

Locked

Select...▼

Contract Term

Locked

Select term...▼

Add-on

Locked

📦All

📱No Add-on

➕With Add-on

Max Monthly Price

Locked

R6,200 / month

R52R6,200

👆

Start with Deal Type

Select New/Add SIM or Upgrades & CVM above to begin.

Brand

Select to begin

Select...▼

Device

Locked

Select...▼

Package / Plan

Locked

Select...▼

Contract Term

Locked

Select...▼

Add-on / Freebie

Locked

📦All

📱No Add-on

➕With Add-on

Max Monthly Price

Locked

All prices

R350R7,000+

💼

Business Deals

Select a deal type to begin browsing EBU deals.

Projected Commission (This Month)

R0.00

Estimated · subject to Head Office validation

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

👤 Employee

Select the employee this sale belongs to

📅 Transaction Date *

Date the sale took place

Date	Category	Invoice	MSISDN	Account No.	Package	Term	Subs Ex VAT	Est. Commission	Status
Loading...

Date	Staff Member	Store	Category	MSISDN	Account No.	Invoice	Package	Term	Subs Ex VAT	Dealer Comm	Est. Staff Comm	Status	Logged By
Loading...

Date	Staff Member	Store	Category	MSISDN	Account No.	Package	Term	Status
Click "Show Captured Sales" to load

Staff Member	Store	Con Upg	Con New	EBU Upg	EBU New	Acc	Swap	Total	Est. Comm	Dealer Comm
Loading...

Store	Con Upg	Con New	EBU Upg	EBU New	Acc	Total	Dealer Comm
Loading...

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

Staff Name

WhatsApp Number

Position

Store

📊

Upload Deal Sheet

Upload the monthly MTN Excel deal sheet to update the Staff Price Book

📁

Tap to select Consumer Deal Sheet

Accepts .xlsx / .xlsb — MTN Consumer Deal Sheet

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)

Store

Month

Revenue Target (R 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

📁

Tap to select Business Deal Sheet

Accepts .xlsx — Helios & iLula Business PromoList

Reading file...

🎯

Upload Postpaid Leads File

Monthly MTN Postpaid Leads .xlsx — groups customers by EPPACC into the Leads tab

📁

Tap to select Postpaid Leads File

Accepts .xlsx — MTN Postpaid Leads Distribution Dashboard

⚠️ 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

Sales Month (e.g. March)

Pay Month (e.g. April)

📂

Tap to select Monthly Payroll File

Accepts .xlsx — monthly payroll commission file

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

📂 Upload Excel

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 Sub (R)

Max Sub (R)

Rate (e.g. 0.0575)

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

AWAITING

COLLECTED

IN TRANSIT

DELIVERED

REJECTED

WAYBILL	FROM	TO	REQUESTED BY	STOCK	DRIVERS	STATUS	REQUESTED	COLLECTED	DELIVERED	ACTIONS
Loading...

📅 Monthly Overview

✅ Completed Deliveries

WAYBILL	FROM	TO	DRIVERS	REQUESTED	COLLECTED	DELIVERED
Loading...

🕑 Pending Deliveries

WAYBILL	FROM	TO	DRIVERS	STATUS	REQUESTED	COLLECTED
Loading...

👥 Courier Team

Manage courier manager and drivers — no portal access

NAME	PHONE	ROLE	STATUS	ACTIONS
Loading...

HEAD OFFICE DASHBOARD

MTN Afrikan Adage — Sales Intelligence

Total Contracts

—

This month

Dealer Comm

—

This month

Qualified Commission

—

staff at 80%+ of target

Unqualified Commission

—

staff below 80% — at risk

🏪 Store vs Target

📊 Category Split

⏱️ Required Sales per Worked Day

Per consultant · 180h/month benchmark · off days included

Store	Weekly Hrs	Avg Daily Shift	Working Days	Target	Req / Worked Day

📅 Daily Performance

Contracts & dealer comm per day

📆 Weekly Signups

Last 8 weeks — new vs upgrades

📈 6-Month Trend

🏆 Agent Leaderboard

💰 Top 10 Packages by Commission

#	Package	Count	Staff Comm	Dealer Comm
Loading…

🎯 LEADS INTELLIGENCE ● LIVE

WhatsApp leads & Postpaid base — live snapshot, not affected by the month filter

WA Leads Secured

—

of — received

Postpaid Contacted

—

of — accounts

Legal %

—

of contacted

Collections %

—

of contacted

Lead Return Rate

—

leads upgraded in-store

Repeat Customers

—

customers returning to upgrade

⚡ Leads Secured per Week

WhatsApp leads — received vs secured

⚖️ Postpaid Outcomes

Claimed / contacted accounts only

📦 STAFF PACKAGE MIX

What value each staff member is selling — contracts by monthly subscription band

📊 Price Band Mix per Staff

💸 Value Mix Matrix — All Staff

Staff	< R300	R300–499	R500–799	R800–1199	R1200+	Total	Avg Sub	Monthly Value	Top Package
Loading…

📦 Stock Reservation Tracker

+ New Reservation

Date

Staff Member

Device Name & Model

IMEI — type or scan barcode

Order Number

Reason for 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

Split Shift Trigger

Monthly Target (hrs)

✔ 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

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

Subject

Message

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

—

Detecting location...

📋 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…

🚨

Escalation History

Log and track MTN escalation records

➕ Log New Escalation

First Name *

Surname *

MSISDN *

Milestone *

Transaction Date

SNOW / Reference Number

Notes

📜 Recent Escalations

📊

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…

🎯 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.

⭐ QA CHECK

–

CUSTOMERS

–

SURVEYED

–

PENDING

Loading…

🎫

Query Tracker

Internal audit trail per customer query — every SNOW/SR ticket on one record until properly closed

➕ Log New Customer Query

First Name *

Surname *

Contact Number *

Email Address

SNOW / SR Ticket Number *

Start with Deal Type

Business Deals

Staff Access

Upload Deal Sheet

Commission Rates

Store Targets

Commission Overview

Upload Business Deal Sheet

Upload Postpaid Leads File

Total Sales Report

Update Lead