| Month | Gross Rev | Returns | Net Rev | Amzn Fees (P&L) | Advertising | Net Settlement | Net Margin | Status |
|---|
| Month | Revenue Earned | Cash Received | Timing Difference | Cash as % of Rev | Running AR Balance | Note |
|---|
† AR Balance = cumulative (Revenue Earned − Cash Received). Positive = money earned but not yet in bank (Amazon still holding). Does not net COGS or advertising — pure Amazon settlement timing. TCS/TDS (₹1,000–6,000/month) reduces Cash Received but is recoverable from tax filings.
| Item | P&L (Accrual) | Cash Flow | Difference | Why |
|---|
| SKU | Brand | Type | Units | Revenue | ASP | Amazon Fees | FBA Fees | Mkt Fees | COGS/unit | Total COGS | Gross Profit | Ad Spend | Net Profit | Margin % |
|---|
Source: Amazon Date Range Transaction Report (All Unified Reports — Transaction type). Fees = actual charged amounts (selling fees + FBA fees + other transaction fees). COGS/unit = Sathya's sheet (only accurate field from that source). True Profit excludes advertising spend (shown in Monthly Detail tab). Rows without COGS show ₹0 — update COGS array when Sathya confirms. Coverage: Apr 2026 – Jul 2026.
SHEET_COGS array in the data file.
| SKU | Brand | MRP | Selling Price | COGS/unit | Ref % | Ref/unit | Close/unit | FBA/unit | Net/unit | Net Margin % |
|---|
| SKU | Brand | Units | Revenue | COGS/unit | Total COGS | Amzn Fees | Ads | Net | Margin |
|---|
Projections start from Jul 2026 actuals. Adjust assumptions below.
| Month | Gross Rev | Net Rev | Fees | Ads | Net | Margin |
|---|
Monthly revenue, fees, COGS and gross profit aggregated by brand · Mar–Jul 2026
SKUs where gross margin is below the threshold or gross profit is negative. Sorted by gross profit (worst first). Uses actual Amazon fee data.
| SKU | Brand | Month | Units | Revenue | Amazon Fees | COGS | Gross Profit | Margin % | Issue |
|---|
| Source | What it provides | Coverage | How to refresh |
|---|---|---|---|
| Amazon Business Reports Seller Central → Reports → Business Reports → Sales & Traffic By Month |
Gross Revenue (Ordered Product Sales), Units Ordered, Sessions, Conversion Rate | Jan 2026 – present | Download CSV from Seller Central. Set date range Jan 1 → today. Replace file and update grossRevenue values in dashboard. |
| Settlement Flat Files V2 Seller Central → Payments → All Statements → Download Flat File |
All fees (referral, closing, FBA), refunds, reimbursements, TCS/TDS, Easy Ship, net transfer amount. Each file covers one 7-day settlement window. | Jan – May 2026, Aug 2026 (partial). ⚠ Apr, May, Aug fees incomplete — FBM orders with 14–21 day holds settle in later files. Net settlement verified: Aug exact match ✓, Mar within 1.4% ✓. | Download per settlement period from All Statements. For complete April fee data, also download the May–June flat files (they contain April FBM orders). Transaction amount-descriptions: "Commission" = referral fee, "Fixed closing fee" = closing fee, "FBA Weight Handling Fee", "FBA Pick & Pack Fee". |
| Windsor.ai — Amazon SP connector Same SP-API as Seller Central; auto-synced daily |
Fees, settlement data, and OPS for months where flat files aren't manually downloaded | Jun – Jul 2026 fees; all months OPS cross-check | Auto-refreshes. For the current partial month, data is preliminary — Amazon SP-API has a ~72h attribution delay before recent orders are finalized. |
| Metric | Definition | Formula / Source |
|---|---|---|
| Revenue | ||
| Gross Revenue | Total value of all orders placed by customers in the calendar month, at the price they paid. This is the number Amazon Seller app shows as "Total Sales." Includes B2B and B2C. Does not deduct returns, fees, or cancellations. | Amazon Business Reports → Ordered Product Sales column. Grouped by order date (not ship or settlement date). |
| Returns & Refunds | Cash refunded to customers for returned or cancelled orders in the month. Amazon initiates the refund; it is debited from your settlement. | Settlement Flat File V2: rows where transaction-type = Refund, summed as a positive deduction. Source: amount field. |
| Net Revenue | Gross Revenue after removing what was refunded. Represents money earned from orders that were not returned. | Gross Revenue − Returns & Refunds |
| Amazon Platform Fees | ||
| Referral / Commission Fee | Amazon's selling fee — a percentage of the item sale price charged per order. Varies by category (typically 5–15% for chemicals/pool care). This is Amazon's primary revenue from sellers. | Flat File V2: transaction-type = Commission, amount-type = ItemFees. |
| Closing Fee | A flat per-item fee charged on top of referral fees. Common on media and certain product categories on Amazon India. | Flat File V2: transaction-type = Commission, amount-description = ClosingFee. |
| FBA Pick & Pack | Fee Amazon charges to pick your product off the shelf and pack it for shipment when fulfilling an FBA order. Depends on product size/weight tier. | Flat File V2: FBAPerUnitFulfillmentFee or FBAPickAndPack amount-description rows. |
| FBA Weight Handling | Weight-based component of the FBA fulfilment fee. Charged separately from pick & pack for heavier items. Your 5 kg and 15 kg products attract significant charges here. | Flat File V2: FBAWeightBasedFee amount-description rows. |
| FBA Inbound Freight | Amazon's charge for receiving and processing inventory into the FBA warehouse (inbound shipment handling). Only charged when you send stock to FBA warehouses. | Flat File V2: FBAInboundTransportationFee rows. |
| FBA Storage | Monthly fee Amazon charges for storing your inventory in their fulfilment centres. Billed around the 7th–15th of each month for the prior month's average daily inventory. | Flat File V2: FBAStorageFee rows. |
| Easy Ship Fee | Fee for orders fulfilled via Amazon Easy Ship — you pack the product, Amazon's courier picks up and delivers. Applies to self-fulfilled (MFN) listings where you opt into Easy Ship. | Flat File V2: EasyShip or EasyShipCharge amount-description rows. |
| Reimbursements | Credits Amazon pays back to sellers — typically for FBA inventory lost or damaged in the warehouse, or for overcharged fees. Positive figure (reduces cost). | Flat File V2: transaction-type = ADJUSTMENT, amount-type = ItemWithheldTax or REVERSAL_REIMBURSEMENT rows. |
| Tax Withholdings | ||
| TCS / TDS | Indian statutory deductions. TCS (Tax Collected at Source) — Amazon collects 1% of net sales on behalf of the government; you claim it back when filing GST returns. TDS (Tax Deducted at Source) — Amazon deducts 1% of your settlement for income tax, claimable when filing IT returns. Neither is a business cost — both are recoverable — but they reduce your actual cash received each period. | Flat File V2: amount-description = TaxWithheld, TCS-CGST, TCS-SGST, TCS-IGST rows. |
| Marketing | ||
| Advertising Spend | Sponsored Products / Sponsored Brands / Sponsored Display spend on Amazon Ads. Charged separately from fees and debited directly from your settlement balance. | Flat File V2: transaction-type = Advertising rows. Cross-referenced with Amazon Ads console. |
| Promotions | Discount amounts funded by you for Lightning Deals, coupons, or percentage-off promotions. Amazon passes the discount to the customer and debits your account. | Flat File V2: transaction-type = Promotion or amount-type = Promotion rows. |
| Summary Metrics | ||
| Gross Profit | Revenue remaining after Amazon's platform fees are deducted. Represents what you keep before spending on advertising, promotions, tax withholdings, and your own costs (COGS, logistics, overhead). | Net Revenue − Referral − Closing − FBA Pick&Pack − FBA Weight − FBA Inbound − FBA Storage − Easy Ship + Reimbursements |
| Net Settlement | The actual rupee amount Amazon transfers to your bank account each settlement cycle (every 7–14 days). This is what hits your bank. It is not a profitability metric — it includes TCS/TDS deductions (recoverable) and timing differences between order month and settlement date, which is why it can look very different from Gross Profit month to month. | Flat File V2: the "Transfer" row at the end of each settlement period. Grouped and summed by calendar month of the transfer date. |
| Contribution Margin | Gross Profit after also deducting advertising, promotions, and TCS/TDS. The margin left to cover COGS, shipping to warehouse, overhead, and actual profit. The most useful operational metric for evaluating monthly performance. | Gross Profit − Advertising − Promotions − TCS/TDS |
| Topic | Detail |
|---|---|
| Order date vs settlement date | Gross Revenue is reported by order date (when the customer clicked Buy). Fees and net settlement are grouped by posted date (when Amazon processed the transaction). A January order may appear in a February settlement. This creates an inherent timing mismatch between revenue and fee rows — it's not an error, it's how Amazon's system works. |
| TCS & TDS are not costs | Both are fully recoverable through GST and Income Tax filings. They reduce cash in the short term but are credited back on filing. They are shown in the dashboard for cash-flow visibility, not as true expenses. |
| Partial month — attribution delay | Amazon's SP-API (used by Windsor.ai) has a ~72h window before recent orders are fully attributed and finalized. The current month's figures in the dashboard are understated by up to 2–3 days of sales. Always download a fresh Business Report from Seller Central for the most accurate current month total. |
| Jun–Jul fees sourced from Windsor.ai | Settlement Flat Files for Jun and Jul have not yet been manually downloaded. Fee rows (referral, FBA, advertising etc.) for those months come from Windsor.ai's Amazon SP connector, which pulls from the same SP-API as Seller Central. Windsor and Business Reports are confirmed to match exactly for all completed months (Jan–Jul). |
| ⚠ Apr, May, Aug fees are understated — FBM settlement delay | Root cause: Settlement Flat Files group transactions by posted date (settlement date), not order date. FBM (Fulfilled by Merchant) orders carry a 14–21 day payment hold: Amazon waits for delivery confirmation before releasing funds. This means an FBM order placed in April will have its referral fee appear in a May or June settlement file, not April. Impact: April's flat files captured ~32% of April's revenue (₹1.4L of ₹4.2L). The ₹7,540 referral fee shown is severely understated — the actual figure is likely ₹33,000–38,000. May is also affected (~51% coverage). August is partial-month data only. Why Jan–Mar are fine: Those months had lower FBM revenue and the coverage gap is smaller. Jun–Jul use Windsor.ai which aggregates across all settlement periods regardless of order date, so those figures are accurate. Fix: Download all settlement flat files from Seller Central → Payments → All Statements. For April accuracy you need May and June flat files too (to capture April FBM orders that settled in those months). Look for settlement periods dated May 1–June 30 and filter by posted-date to find April-ordered items. |
| Net Settlement ≠ Gross Profit | Net Settlement is the cash Amazon sent to the bank. Gross Profit is an accrual metric. The gap exists because: (1) TCS/TDS is deducted from settlement but is recoverable, (2) orders placed late in a month settle in the next month, (3) advertising is charged in settlement but shown separately in the P&L. |
| COGS not included | Cost of Goods Sold (your product cost, packaging, inbound shipping to warehouse) is not in the main P&L — it is tracked separately in the COGS Calculator tab. Net Settlement is the closest to "cash in hand after Amazon" but does not reflect true profitability until COGS is deducted. |
| Aspect | P&L (Accrual Basis) | Cash Flow (Settlement Basis) |
|---|---|---|
| When recognised | When the customer places the order (order date) | When Amazon transfers money to the bank (settlement date — 7–21 days after delivery) |
| Revenue source | Amazon Business Reports → Ordered Product Sales | Settlement Flat File → Transfer rows (total-amount in file header) |
| Fees | Estimated or actual by order month. Jan/Feb/Mar: settlement flat files. Jun/Jul: Windsor.ai. Apr/May/Aug: estimated ~9% referral + 4.5% closing of net revenue | What Amazon deducted in each settlement window — may include fees from prior-month orders that settled late |
| Best for | Understanding business performance — which month generated how much revenue and margin | Bank reconciliation, working capital, understanding actual cash position on any date |
| FBM impact | FBM revenue appears in order month regardless of delivery timing | FBM cash arrives 14–21 days after delivery — April orders may appear in May/June settlement |
| TCS / TDS | Not in P&L — these are recoverable statutory deductions, not business costs | Deducted from settlement, but fully recovered via GST and IT return filings |
| Advertising | Shown as an accrual expense in the period ads ran | Debited from settlement balance in the same period — generally matches P&L |
| Brand | Revenue | COGS | Amazon Fees | Gross Profit | GP% | Ad Spend* | Net After Ads | Net Margin |
|---|
| Product Family | Brand | Sizes in Family | Jul Rev (all sizes) | Jul Units | Jul GP | GP% | PPC Strategy at Family Level |
|---|
| SKU / Product | Brand | Stage Now→Target | Tipping Status | Jul Rev | ACOS 📊 | BSR Est. 📊 | Reviews 📊 | Target Rev | Ranking Strategy |
|---|---|---|---|---|---|---|---|---|---|
|
ZYAX_CM_CM90_5KG
Pool stabiliser 5KG · FBM only
|
Zyax |
2 → 4
|
Near Tipping | ₹2,09,300 | Check SC | Check SC | ₹5,00,000 | Priority #1. Convert CM90 5KG to FBA — Prime badge will boost CVR ~15–20%. Set up exact-match PPC on "pool stabiliser", "pool salt", "cyanuric acid pool". 8–10 priority KWs. Target TACoS below 15% in 90 days. Watch for organic rank jump on pool-season KWs. | |
|
G8-2IRU-DOU0
Snake Maxx Repellent 5KG · FBA + FBM
|
Snake Maxx |
3 → 5
|
Near Tipping | ₹1,06,516 | Check SC | Check SC | ₹2,00,000 | Strong FBA traction already — ₹94K FBA revenue signals page-1 potential. Target "snake repellent granules", "snake away", "snake repellent for home". Graduate keywords once ranking top-5 organic. Check if TACoS is falling — could already be in flywheel. | |
|
ZYAX_CM_CM90_15KG
Pool stabiliser 15KG · FBM
|
Zyax |
2 → 4
|
Pre-Tipping | ₹68,316 | Check SC | Check SC | ₹1,50,000 | ⚠ High ACOS 45.6% — pause campaigns with no conversion data. Audit listing CVR first. Lower bids to target break-even ACOS (~30%). Check if 15KG SKU has enough reviews for credibility on high-value purchase. Minimum 30 reviews before scaling PPC. | |
|
VPF&UPIN1L
Vetro Power F&UP 1 Litre · FBA
|
Vetro Power |
2 → 4
|
Near Tipping | ₹55,020 | Check SC | Check SC | ₹2,00,000 | FBA listing — good position. Focus on "fabric softener", "fabric conditioner", "all-in-one liquid detergent" keyword cluster. Get to 100 reviews before aggressive bid scaling. Run Vine if eligible. Target TACoS <18% in 60 days. | |
|
VPF&UPIN250
Vetro Power F&UP 250ml · FBA
|
Vetro Power |
2 → 4
|
Near Tipping | ₹61,036 | Check SC | Check SC | ₹2,00,000 | Ideal trial/entry-size SKU. High-conversion potential with lower price point. Use as halo for 1L upsell. Target "fabric care" + "softener trial pack" KWs. Main image test recommended — 250ml SKUs are image-driven purchases. | |
|
VPF&UPIN5L-FBM
Vetro Power F&UP 5 Litre · FBM
|
Vetro Power |
1 → 3
|
Pre-Tipping | ₹34,650 | Check SC | Check SC | ₹1,00,000 | ⚠ 54.1% ACOS — PPC treadmill. Pause, audit listing CVR. 5L is bulk-buyer segment — check if main image shows value/quantity clearly. Fix CVR before re-spending. Consider FBA inbound for this size to win Buy Box and improve conversion. | |
|
ZYAX_PMpHDOWN_5L
pH Down 5 Litre · FBA
|
Zyax |
2 → 4
|
Near Tipping | ₹15,248 | Check SC | Check SC | ₹1,00,000 | ✓ Excellent ACOS 11.6% — already showing flywheel signal. This SKU may already be at tipping point. Double budget here. Check if organic rank is climbing without PPC — if TACoS is falling, graduate top keywords and harvest margin. Target "pH minus pool", "pH reducer pool water" KWs. | |
|
FS_MSCPLUS_1L
Flagstone Fix Stone Cleaner Plus 1L
|
Flagstone Fix |
1 → 3
|
Early Launch | ₹5,288 | Check SC | <10 est. | ₹50,000 | Niche product — low competition in "stone cleaner" / "mild stone cleaner" / "flooring cleaner" category. Get 30 reviews first (Vine). Then exact-match PPC on 6–8 KWs. FBA needed to compete seriously. ₹50K/mo target is achievable in 4–6 months with proper launch. | |
|
FABER_PRO_YSONE
Faber Pro Anti-Slip · FBA
|
Faber |
1 → 3
|
Early Launch | ₹5,932 | Check SC | <10 est. | ₹1,00,000 | FBA listing — good start. Anti-slip products: "anti slip bathroom tiles", "anti slip floor treatment" are viable KWs with low competition. ₹30K/mo target requires 30+ reviews and exact-match PPC. ₹1L/mo possible by Month 4–5 of focused launch investment. | |
|
SNAKEMAXX_5KG
Snake Maxx Repellent 5KG · FBM variant
|
Snake Maxx |
1 → 3
|
Early Launch | ₹22,118 | Check SC | Check SC | ₹80,000 | Seasonal SKU (pre-monsoon peak). Use G8-2IRU-DOU0 reviews as social proof anchor. Consolidate SNAKEMAXX_ variants under parent ASIN if not already done — review pooling accelerates rank. Activate PPC in Feb–April for monsoon season window. |
| Month | Revenue | COGS | Amazon Fees | Gross Profit | GP% | Est. Ad Spend | Net Profit | Net Margin | MoM Growth | Status |
|---|
| Brand | Jul 2026 Revenue | Jul % | Target Revenue | Target % | Growth Needed | Key Drivers |
|---|---|---|---|---|---|---|
| Zyax | ₹5,13,839 | 56.8% | ₹20,00,000 | 40% | 3.9× | CM90 range, pH Down 5L, Pool Maxx 5L scale |
| Vetro Power | ₹2,22,860 | 24.6% | ₹17,50,000 | 35% | 7.9× | F&UP range expansion, premium bundles, PPC scale |
| Snake Maxx | ₹1,28,634 | 14.2% | ₹6,00,000 | 12% | 4.7× | G8-2IRU-DOU0 scale (FBA + FBM), SNAKEMAXX bundles |
| Faber | ₹9,946 | 1.1% | ₹3,00,000 | 6% | 30.2× | FABER_PRO_YSONE & FABER_PRO_SM scale, new SKU launches |
| Flagstone Fix | ₹5,288 | 0.6% | ₹1,00,000 | 2% | 18.9× | MSC Plus 1L FBA scale, add 5L variant |
| Others | ₹24,793 | 2.7% | ₹1,50,000 | 3% | 6× | Classify & grow or exit low-margin SKUs |
| Total | ₹9,05,360 | 100% | ₹50,00,000 | 100% | 5.5× |
| Risk | Severity | Mitigation |
|---|---|---|
| Zyax heavily seasonal — 57% of revenue, drops post-pool season | High | Aggressively scale Vetro Power and Faber in off-peak months. Target Zyax ≤45% of revenue mix by ₹50L. |
| ACOS runaway on scale — CM90 15KG at 45.6%, VPF&UPIN5L-FBM at 54.1% | High | Pause or restructure high-ACOS campaigns. Target blended ACOS ≤20%. |
| Working capital constraint — 5× revenue jump needs 5× inventory investment | High | Phase growth to 2–3 months runway. Prioritise FBM for new SKUs to test before FBA commitment. |
| Amazon fee increases — FBA storage + referral fees can erode margins on bulk/heavy SKUs | Medium | Run FBM/FBA profitability comparison per SKU quarterly. CM90 range: test FBA for 1KG, keep FBM for 5KG+. |
| CM90 range SKU concentration — single product family ~23% of total revenue | Medium | Expand pH Down, Pool Maxx, and SMRLS as supporting pillars. Build reviews on newer SKUs. |
| COGS creep — as volume scales, supplier pricing negotiation critical | Low | Renegotiate at each 100-unit/month threshold. Target COGS% <35% at ₹50L volumes. |