📊 Business Analytics Dashboard

PLATFORM
FINANCIAL YEAR
No data loaded

MTR Files (B2B + B2C)

Upload one or more MTR CSV files from Seller Central → Reports → Tax → Monthly Tax Report. Both B2B and B2C files accepted. You can upload multiple months at once.

📄

Click or drag MTR CSV files here

Accepts: MTR_B2B-*.csv, MTR_B2C-*.csv

Payment / Settlement Report

Download from Seller Central → Reports → Payments → All Statements → Custom Date. Upload one or more files. Handles Amazon's 13-row header automatically.

💳

Click or drag Payment Report CSV here

Accepts: .csv or .xlsx

Ad Spend (Monthly)

Financial Year:

Enter total Amazon.in ad spend (SP + SB + SD) per month excluding GST. Values auto-save on every change.

ℹ How uploads work

Data is saved in your browser automatically — no need to re-upload every time you open this file.
Each upload adds to existing data (deduped). Drop April files now, May files next month — they accumulate.
Drop multiple MTR files at once (e.g. B2B + B2C for the same month, or multiple months together).

☁ Cloud Sync — Active

Connected to Supabase. Data syncs automatically on every change. Opens fresh from cloud on any device, any browser — no setup needed.

Step 1 — Manage Categories

Add all your product categories first. "Combo" is built-in and auto-assigned to all combo SKUs. Then go to Step 2 to map SKUs.

Combo (built-in)

Step 2 — SKU → Product + Category Mapping

Map each Amazon SKU → product name → category. For combo SKUs use Step 3 below.

⚡ Unmapped SKUs in uploaded data:

Step 3 — Combo Definitions

Define what each combo SKU contains. Auto-assigned category = Combo. Revenue splits by COGS ratio across components.

Monthly COGS per Product

Enter cost per unit (₹, GST-exclusive) for each product each month. If a product has no entry for a given month, the most recent previous month's value is used automatically (shown in grey).

Upload MTR + payment data, then click Run Reconciliation.
Upload data and click Calculate P&L.

🧮 Inputs

Commission %, FBA fee, discount % pulled from this month's actuals

Auto-filled from reference month. Edit to test scenarios.

📌 Quick Scenarios

Test COGS levels and see margin impact instantly

Contribution Margin Waterfall

Select a product and reference month to begin.

Analysis Chart

Upload Daily Sales Report

Export from Shopify: Analytics → Reports → Sales by product. Download CSV for today. Supports any CSV with product title, quantity, and sales columns.

🛍

Click or drag Shopify daily CSV here

Accepts: .csv

Report Settings

Uses COGS rates you've entered for this month.

📋
No daily report uploaded yet
Upload a Shopify "Sales by product" CSV above to see the daily breakdown.