Every calculation follows published GST law and standard accounting principles — so your output is always reliable and filing-ready.
It reads your marketplace sales and returns reports and converts them into a GSTR-1 ready summary — the same tables you fill on the GST portal — automatically, accurately, and without manual data entry.
Before anything is processed, the tool verifies your uploaded files entirely within your browser — checking that the correct report type is uploaded for each platform. Cross-platform mistakes (e.g. uploading a Meesho file in the Amazon slot) are caught and rejected instantly, before payment. This means if the payment screen appears, your files have already passed validation.
B2C State-wise Summary — Net sales to unregistered buyers are grouped by destination state and GST rate slab. IGST applies for inter-state supply; CGST + SGST for intra-state — as per IGST Act, Section 10 (place of supply rules for e-commerce).
Amendments / Returns — Returned orders reduce the taxable value and tax liability for the reporting period. The tool nets off returns against sales per state and GST rate — consistent with GST Rule 59 reporting requirements.
HSN-wise Summary — Taxable value and tax are aggregated by HSN code across all platforms. HSN codes are sourced directly from your marketplace reports — the tool does not assign or modify them.
Document Series — Invoice number range summary as required in GSTR-1. Derived from the transaction data in your reports, covering the selected filing period.
TCS (Tax Collected at Source) — Marketplace TCS deductions (under Section 52 of CGST Act) are identified and separated from taxable turnover, ensuring your GSTR-1 figures are not inflated by TCS amounts.
Your actual profit isn't just "sales minus cost." Marketplace commissions, return losses, TCS deductions, and GST adjustments all eat into your margin. This tool reads your platform settlement reports, applies standard accounting logic, and shows you the real number — per SKU, per platform, and overall.
Settlement reports from each platform have a distinct structure. The tool validates your uploaded file against the expected format for that platform — checking sheet names and required column headers — before payment is requested. Files from the wrong platform or in an unsupported format are rejected immediately with a clear error message.
Net Settlement = Gross Sales − Platform Fees − Shipping Charges − Returns. The tool uses the actual amount credited or payable per your settlement report — not the order value — as the revenue figure.
Cost of Goods Sold is applied only to units actually delivered and not returned — matching the standard matching principle in accounting. Returned units reduce COGS proportionally; optionally, a damage percentage can be applied to unsellable returns.
Return rate is calculated per SKU as returned units ÷ (delivered + returned). This gives you a true return burden figure, not just a raw return count — helping you identify which products are hurting profitability.
TCS (Tax Collected at Source) deducted by the marketplace under Section 52 of CGST Act is identified separately. It is not treated as a cost — it is a recoverable tax credit claimable in your GST return.
Input Tax Credit on your purchase cost (COGS) is estimated based on the GST rate you enter for each SKU. This is an indicative figure — final ITC eligibility depends on your supplier's GSTR-1 filing and should be confirmed with your CA.
We believe in being upfront. The following are not part of the calculation — deduct them manually from your result:
Ad costs are not available in settlement reports — deduct your total ad spend manually for accurate net profit.
Warehouse rent, staff, packaging materials beyond per-unit cost — these are business-level costs outside scope.
Have a question about how a calculation works?
[email protected]