Sales checked to IL & usage export (.xlsx) — state the sale-date range this file covers; replaces any data already stored in that range
to
📊
No Excel data has been uploaded yet. Use the upload panel above to add your first report.
TOTAL SALES
—
—
CONFIRMED SALES
—
UNCONFIRMED SALES
—
CONFIRMED SALES VALUE (R)
—
TOP PERFORMERS
TOP 5 AGENTS BY CONFIRMED SALES
PACKAGE MIX
BILLING ERRORS — agent carelessness, separate from unconfirmed sales
Recharge amount doesn't match billed amount — the agent captured or charged the wrong figure—
Value affected by these mistakes (R)—
Unconfirmed sales—
Unconfirmed sales value (R)—
AREA LEADERBOARD
AGENT LEADERBOARD
Agent
Area
Sales
Confirmed
Target %
Flagged
Unconfirmed %
Billing Errors
DATA QUALITY
Area not sorted / missing—
Missing ONU Mac—
Missing recharge amount—
AGENTS PER AREA
DUPLICATE-IL AGENT PAIRINGS
Which agents keep showing up on the same duplicated IL numbers, and how often
Agent A
Agent B
Shared duplicate ILs
Sample IL numbers
No duplicate IL numbers shared between two or more agents for this filter.
AGENT SCORECARDS
📅 Agent payments
Pick a date range — payment is confirmed sales × R30 per agent
to
💰
Choose a start and end date, then click Load to see agent payments.
TOTAL CONFIRMED SALES
—
TOTAL PAYMENT (R)
—
📊 Confirmed vs. Inaccurate Customers
Per agent: total visits, total recharges (amount logged), actual sales (confirmed), inaccurate customers (blank order date), duplicates (duplicate IL), amount payable (actual sales × R30), overlap (duplicate AND inaccurate)
to
📊
Choose a start and end date, then click Load to see the pivot table.
TOTAL VISITS
—
TOTAL RECHARGES
—
ACTUAL SALES
—
INACCURATE CUSTOMERS
—
DUPLICATES
—
AMOUNT PAYABLE (R)
—
OVERLAP
—
FLAGGED AGENTS
Agents who keep showing up wherever a MAC address or IL number is shared — the more groups they appear in, the more likely they're the ones behind it
Agent
Same-MAC groups
Same-IL groups
Total
No shared MAC/IL activity found for this filter.
SAME MAC ADDRESS, DIFFERENT IL NUMBERS
One ONU device claimed under more than one IL number — click a row to see the raw sales behind it
ONU MAC
IL numbers
Rows
Sample IL numbers
Agents involved
No MAC address shared across multiple IL numbers for this filter.
SAME IL NUMBER, DIFFERENT MAC ADDRESSES
One IL number claimed against more than one ONU device — click a row to see the raw sales behind it
IL number
MAC addresses
Rows
Sample MAC addresses
Agents involved
No IL number shared across multiple MAC addresses for this filter.