Real-Time Analytics

Product Profitability Matrix

Instantly evaluate Net Profitability and true Margin Percentages for every unique SKU. Import your e-commerce TCS sales spreadsheet (`tcs_sales.xlsx`) to start.

Import TCS Report

Drag and drop your file here

Supports Excel (.xlsx, .xls) or CSV reports

Expects or derives:
  • SKU (Unique Product Identifier)
  • Invoice Value (Sales total per record)
  • Taxable Value (Estimate fallback provided)
  • Tax Amount (GST liability calculation)

Formula & Methodology

Marketplace Costs:

Estimated as 10% of total taxable value to account for referrals, shipping handling, and variable commissions.

Net Profit:

Profit = Revenue - Tax - Marketplace Fees

Margin %:

Calculated as (Net Profit / Total Revenue) ร— 100.

๐Ÿ“Š

No Report Analyzed Yet

Import your e-commerce platform's TCS report to get granular per-SKU profitability matrices, margin analytics, and visual charts.

โœ“

Secure Local Analysis

We value your privacy. All Excel parsing, computation, and analysis happen directly in your browser using local client storage. No financial rows are ever transmitted to external web servers.

โœ“

Dynamic Column Discovery

Our analyzer dynamically scans column headers in your uploaded reports to automatically discover SKU names, gross values, CGST/SGST/IGST breakdown, and transaction status.