Overview

Multi-Marketplace Operations • Amazon India, Flipkart, Meesho & D2C • Timezone: Asia/Kolkata (IST)

Data Mode: Seeded Demo Tenant (CSV Import Active | Live Marketplace APIs Unconfigured)Export Reconciliation CSV
Gross Order Value
₹16,490.00
Across 8 multi-channel orders
Expected Net Settlement
₹9,780.74
Net of contracted fees, 18% GST, 1% TCS & 1% TDS
Actual Bank / UTR Settled
₹7,186.07
Verified from settlement batches
Unreconciled / Underpaid Gap
₹2,594.67
4 orders require dispute / review
Delayed Settlements (>SLA)
1 Order(s)
Breached 7–10 day marketplace payout SLA

Settlement Reconciliation & Unified Order Ledger

Matches orders, partial settlements, commission/shipping slabs, 18% GST on fees, TCS/TDS, and return reversals without concealing differences.

Channel & Order IDDate & StatusSKU & QtyGross ValueExpected Fees + TaxExpected NetActual SettledDiscrepancy (Δ)Recon StatusEvidence-Backed Discrepancy ExplanationAudit Action
Amazon India
408-7712904-1120341
Internal: CS-ORD-2026-0001
2026-10-05
DELIVERED • PREPAID
WRC-AUD-101
SonicPulse ANC Wireless Earbuds Pro (×1)
₹1,799.00₹391.44₹1,407.56₹1,407.56
1 tranche(s)
₹0.00MATCHEDVerified exact match against contracted SKU fee card & statutory TCS/TDS.
Flipkart
OD32948102938471000
Internal: CS-ORD-2026-0002
2026-10-06
DELIVERED • COD
WRC-FIT-202
FitVibe AMOLED Smartwatch Series 5 (×1)
₹2,399.00₹530.85₹1,768.15₹1,711.51
1 tranche(s)
₹56.64MISMATCH
  • Shipping / Weight Slab Fee Variance: Charged ₹118.00 vs contracted slab ₹70.00 (excess ₹48.00). Check volumetric weight dispute.
Meesho
MSH-9981204412
Internal: CS-ORD-2026-0003
2026-10-07
DELIVERED • PREPAID
WRC-BAG-404
UrbanNomad Water-Resistant Laptop Backpack 28L (×2)
₹2,498.00₹259.46₹2,238.54₹2,238.54
1 tranche(s)
₹0.00MATCHEDVerified exact match against contracted SKU fee card & statutory TCS/TDS.
Amazon India
408-8834120-9948122
Internal: CS-ORD-2026-0004
2026-10-08
DELIVERED • PREPAID
WRC-AUD-101
SonicPulse ANC Wireless Earbuds Pro (×2)
₹3,598.00₹782.86₹2,815.14₹1,407.56
1 tranche(s)
₹1,407.58PARTIALLY MATCHED
  • Commission Fee Variance: Charged ₹215.88 vs expected ₹431.76 (12%). Difference: ₹-215.88.
  • Shipping / Weight Slab Fee Variance: Charged ₹65.00 vs contracted slab ₹130.00 (excess ₹-65.00). Check volumetric weight dispute.
  • Partial Settlement Received: Settled gross ₹1799.00 of ₹3598.00. Remaining payout balance of ₹1407.58 pending next settlement cycle.
Flipkart
OD32949918273645112
Internal: CS-ORD-2026-0005
2026-10-04
DELIVERED • PREPAID
SLA Breached (17d)
WRC-BAG-404
UrbanNomad Water-Resistant Laptop Backpack 28L (×1)
₹1,349.00₹401.45₹947.55₹0.00
0 tranche(s)
₹947.55MISSING
  • Delayed Settlement: 17 days elapsed since order date (exceeds FLIPKART 10-day payout SLA). Expected ₹947.55 not yet received.
Amazon India
408-9100234-5512908
Internal: CS-ORD-2026-0006
2026-10-09
RETURNED • PREPAID
WRC-FIT-202
FitVibe AMOLED Smartwatch Series 5 (×1)
₹2,499.00₹232.46-₹232.46-₹285.56
1 tranche(s)
₹53.10MISMATCH
  • Unreversed Commission on Customer Return: Marketplace charged ₹45.00 instead of reversing commission to ₹0.00.
Meesho
MSH-9985519023
Internal: CS-ORD-2026-0007
2026-10-11
RTO • COD
WRC-BAG-404
UrbanNomad Water-Resistant Laptop Backpack 28L (×1)
₹1,249.00₹0.00₹0.00-₹129.80
1 tranche(s)
₹129.80UNDER REVIEW
  • RTO Reverse Shipping Penalty Deducted: Marketplace deducted ₹110.00 on an undelivered Courier Return (RTO).
Amazon India
408-9940112-3319044
Internal: CS-ORD-2026-0008
2026-10-16
DELIVERED • PREPAID
WRC-ACC-505
GaNFast 65W Type-C PD Wall Charger (×1)
₹1,099.00₹262.74₹836.26₹836.26
1 tranche(s)
₹0.00MATCHEDVerified exact match against contracted SKU fee card & statutory TCS/TDS.

SKU & Marketplace Profitability Engine (Transparent Formula Breakdown)

Formula: Net Sales = Gross Sales − Discounts − Refunds | Gross Profit = Net Sales − COGS | Contribution Margin = Gross Profit − Fees − Packaging − Return Losses | Net Profit = Contribution Margin − Ad Spend

Export Profitability Excel (.xls)
Internal SKU & ProductChannelNet UnitsGross SalesNet SalesProduct COGSGross ProfitMP Fees + Pkg + ReturnsContribution MarginAd SpendEst. Net Profit
WRC-AUD-101
SonicPulse ANC Wireless Earbuds Pro
AMAZON_IN36 / 42₹71,960.00₹63,564.00₹23,040.00₹40,524.00 (63.75%)₹16,570.50₹23,953.50 (37.68%)₹4,200.00₹19,753.50 (31.08%)
WRC-FIT-202
FitVibe AMOLED Smartwatch Series 5
FLIPKART24 / 28₹64,773.00₹56,076.00₹22,080.00₹33,996.00 (60.62%)₹15,935.00₹18,061.00 (32.21%)₹3,100.00₹14,961.00 (26.68%)
WRC-BAG-404
UrbanNomad Water-Resistant Laptop Backpack 28L
MEESHO48 / 55₹64,948.00₹59,952.00₹23,040.00₹36,912.00 (61.57%)₹7,905.00₹29,007.00 (48.38%)₹1,450.00₹27,557.00 (45.97%)
WRC-HOM-303
AeroBrew Stainless Pour-Over Coffee Kettle 1L
AMAZON_IN29 / 31₹35,970.00₹34,321.00₹11,890.00₹22,431.00 (65.36%)₹8,230.00₹14,201.00 (41.38%)₹1,800.00₹12,401.00 (36.13%)
WRC-ACC-505
GaNFast 65W Type-C PD Wall Charger
⚠️ Incomplete Cost Data: Purchase Cost (COGS) Missing
AMAZON_IN18 / 19₹20,881.00₹19,582.00MISSING₹19,582.00 (100%)₹5,020.00₹14,562.00 (74.36%)₹950.00₹13,612.00 (69.51%)