Ready to process

Upload the refund workbook

The dashboard reads Excel or CSV, keeps only Refund Invoice rows from January–September 2026, and builds the Retention Command Center. No helper columns required.

Drop .xlsx / .xls / .csv here

From

Service

Refund Reason

Quarter

Account

30-second brief

How much was refunded?

Refunds

Largest service

—

Highest month

—

Main stated reason

—

What should we investigate?

Export

Filtered extracts for the current view.

Total Refunds

—

Total Refunded Amount

—

Average Refund Value

—

Refund Transactions

—

Highest Refund Service

—

Top Refund Reason

—

Highest Refund Month

—

Number of Refund Reasons

—

Monthly refund performance

January–September. Zero months remain visible.

Month-over-month

Refunds by service

Refund amount by service

Board brief

Executive Insights

Calculated from the uploaded file. Each card separates fact, interpretation, and recommendation.

Fact Interpretation Recommendation

Refund Performance

Count and amount trends for the nine-month window.

Monthly refund trend

Refund amount trend

Service × Month heatmap

Click a cell to filter by service.

Services

BBC, BCC, CRM and any combined or other services kept separate.

Service × Reason matrix

Quarterly Intelligence

Q4 is shown as Not Available Yet and excluded from calculations.

Quarterly refund count

Quarterly refund amount

Refund Reasons

Exact reason texts after spacing cleanup only. Nothing is invented.

Reason profile

Count and amount by reason

Ranked line view of the top reasons. Hover a point to read the full reason text.

Volume

Refund count by reason

—

Financial impact

Refund amount by reason

—

Reason trend

Service × Reason heatmap

Pareto analysis

#	Reason	Count	Amount	% Count	% Amount

Retention & Compliance Action Center

Drivers are operational hypotheses from the stated reason text. Causality is not claimed.

Reason / theme	Service	Count	Amount	Possible driver	Recommended investigation	Recommended action	Suggested owner	KPI

Refund Reduction Playbook

No financial savings are invented. Each initiative is tied to evidence in the current extract.

Refund Priority Matrix

High frequency / High impact

High frequency / Low impact

Low frequency / High impact

Low frequency / Low impact

Account Retention Portfolio

Names come only from the file. Nothing is invented.

Account	ACC	Refunds	Amount	Latest	Top reason	Service	Trend

Account Action Tracker

Eight local slots stored in this browser via localStorage.

Account	Last contact	Method	Topic	Service discussed	Customer response	Next follow-up	Status	Notes

WhatsApp Outreach Center