Company Financial & SKU Intelligence

Live Reconciliation Engine

Multi-Portal Audit •

Loading…
Drag & Drop Workbooks here (Transaction File.xlsx, plus optionally Inventory.xlsx and Portal SKU.xlsx)
Reads sheets Sales, Return, Payment, Masters, Single SKU, Combo SKU and recomputes every figure
Same engine as published data
Marketplace Channels Click to isolate channel
Gross GMV (Sales) Billed
—
Net Sales: — —
Portal Deductions —
—
Base Fees: — Fee GST: —
Bank Settlement Realized
—
Realization: — —
Units & COGS Margin Excl. GST
—
Orders: — AOV: —

Multi-Portal Financial & Payout Comparison

Gross GMV vs. Marketplace Deductions (incl. GST) vs. Realized Bank Settlement

Grouped Bar

Marketplace Fee Anatomy

Commission, Shipping, PG & Fixed fees breakdown

Customer Return Diagnostics (Root Causes)

Reverse logistics driver analysis & claim frequency

—

Category Net Revenue & Velocity

Net revenue excl. GST by category; combo revenue split by component cost

—

Monthly Sales, Refunds & Settlement Trend

By order month: gross sales, customer refunds and net settlement

—

Marketplace Channel Settlement Summary

Summary of Sales, Returns, Portal Deductions, GST, and Net Bank Settlements

Portal / Marketplace Orders Gross GMV (₹) Returns (₹) Net Sales (₹) Portal Fees (₹) Fee GST (₹) Net Settlement (₹) Take Rate % Realization % Recon Status

Granular Order Reconciliation Drilldown

Inspect individual order transactions, deductions, SKU details, and UTR settlement status

Order Number Portal SKU / Item Gross GMV (₹) Returns (₹) Net Deductions (₹) Net Payout (₹) UTR / Ref Status Action
1

Top 10 High-Velocity Revenue SKUs

By net revenue excl. GST, after returns

Velocity Rank
Rank Product Name Category Avg MRP (₹) Cost Price (₹) Net Units Net Revenue (₹) Gross Margin %

Inventory Stock Threshold & Alerts

Closing stock = opening + inward − sold + returned (company-wide)

—

Combo Bundle Decomposition (BOM Exploder)

Top combos by revenue in the current filter, resolved into component SKUs

—