Retail_HQ
/Returns & Refunds

Returns & Refunds

Queue, suspicious patterns, and refund velocity.

2 suspicious

Refund queue

RefBranchCashierReasonAmountStatus
RF-2041GwarinpaFatima Y.Item defective42,000Pending
RF-2040Wuse 2Amaka N.Wrong size12,000Approved
RF-2039ApoNgozi E.Customer changed mind22,000Pending
RF-2038Wuse 2Grace O.Duplicate charge8,000Approved
RF-2037GwarinpaFatima Y.No receipt34,000Investigating

Return reasons

Defective34%
Wrong item24%
Changed mind22%
Duplicate12%
Other8%

Refund trend

14 days
1234567891011121314
RefundsSuspicious

Suspicious patterns

  • Fatima Y. — 4 refunds this week, all near end-of-shift
  • L-10 Gwarinpa — 3 refunds without receipt
  • Apo Pharmacy — Pharmacy items refunded after 24hr window
Refund value
₦412k+9%
Refund rate
1.8%
Avg resolution
18h-4h
Open cases
12
Serial refunders
7
Fraud probability
24%

Operational workspace — what is happening

Refund register

Today
RefCustomerBranchReasonValueRiskStage
RFD-4412Adaeze N.Wuse 2Damaged₦18,200LowApproved
RFD-4413Walk-inApoWrong item₦6,400LowApproved
RFD-4414Sani B.Wuse 2Expired₦12,800MediumReview
RFD-4415Walk-inGwarinpaChange of mind₦4,200MediumReview
RFD-4416Repeat #442ApoDamaged₦22,600HighInvestigation
RFD-4417Repeat #518Wuse 2Damaged₦16,400HighInvestigation

Refund lifecycle events

Live feed
  1. Case escalated18:20
    RFD-4416 · fourth claim by same customer
  2. Refund approved16:10
    RFD-4412 · ₦18,200
  3. Root cause logged14:30
    Expired stock at Apo pharmacy
  4. Case resolved11:00
    RFD-4402 closed after review
  5. Pattern alert09:20
    7 serial refunders identified

Investigation queue

6 in queue
RFD-4416 investigation
High risk · ₦22,600
Open
RFD-4417 investigation
High risk · ₦16,400
Open
Expired stock root cause
Apo pharmacy
Open
Serial refunder review
7 customers
Open
Supplier quality claim
Damaged batch
Open
Policy refresher training
All cashiers
Open

Analytics workspace — why is it happening

Refund value vs rate

7 days
MonTueWedThuFriSatSun

Refund reason mix

Damaged38%
Expired22%
Wrong item18%
Change of mind14%
Other8%

Refunds by hour

08101214161820

High-risk products by refund value (₦k)

Ranked
#1
Fresh dairy
96
#2
Bakery
74
#3
Pharmacy OTC
62
#4
Beverages
48
#5
Household
32

Return heat map by branch / reason

Heat map
DamagedExpiredWrongMindOther
Wuse 2
42
18
22
16
8
Gwarinpa
30
14
18
12
6
Apo
24
34
12
8
4

Refund frequency vs customer value

Correlation
VIPLoyalRegularSerialFlaggedRefund frequencyCustomer value (index)

Root cause analysis

Comparative
Root causeCasesValueOwner
Cold chain break18₦96kOps
Expiry management14₦74kInventory
Scanning error11₦42kTraining
Supplier quality9₦58kProcurement

Management workspace — exceptions & approvals

Exception centre

3 open
Seven serial refunders identifiedLoss Prevention
Repeat claimants with four or more refunds in 30 days, all damaged-goods reasons.
Expired stock refunds at ApoInventory
Expiry-related refunds are 2.4x the network average.
Cold chain break casesOperations
18 cases totalling ₦96k linked to temperature excursions.

Pending approvals

Awaiting sign-off
  • Block-list serial refunders
    7 customers
    Review
  • Supplier quality claim
    ₦58k recovery
    Review
  • Cold chain capex
    Apo chiller service
    Review

Manager action queue

Assigned
ActionOwnerDuePriority
Complete high-risk refund investigationsLoss PreventionTodayHigh
Fix expiry rotation at Apo pharmacyInventoryThis weekHigh
Service the cold chain equipmentFacilitiesThis weekMedium
File the supplier quality claimProcurementNext weekMedium

Escalations

Routed upward
Refund fraud exposureEscalated
Estimated ₦2.1M annualised if the pattern continues.

Stock disposition board

· Where returned goods ended up
Return to shelf
412 units
₦2.84M recovered
Return to supplier
96 units
₦1.12M claim raised
Damaged goods
58 units
₦486k written off
Quarantine
31 units
₦298k held
Dispose
22 units
₦164k loss
Repair / repack
18 units
₦96k recoverable
Exchange completed
148 units
₦1.46M retained
Awaiting decision
44 units
₦372k pending