A Flipkart seller fee calculator should take selling price and add each fee head from your own rate card: commission, fixed fee, collection fee, shipping fee by weight and zone, GST on fees, and reverse shipping on returns. Then deduct TCS and TDS shown in the settlement report. Do not rely on generic rates; confirm the latest terms in Seller Hub or your agreement, then test the output against real settled orders.
What a Flipkart fee calculator must include
Most online calculators give a single blended percentage. That is fine for a rough idea, but it fails when you need to price a SKU or explain why a payout was short. A usable calculator keeps each fee head as a separate column.
- Commission fee: usually linked to category and selling price. Take the percentage or slab from your rate card.
- Fixed fee: a per-order charge that may vary by price band or category.
- Collection fee: a charge tied to payment collection. Check how your rate card defines it.
- Shipping fee: normally driven by weight, dimensions and delivery zone.
- Reverse shipping and return charges: applied when an order comes back, and the rules differ by return type.
- GST on fees: taken from the fee invoice or settlement report, not assumed.
- TCS and TDS: not fees, but they reduce your cash payout. Confirm the treatment with your tax adviser.
Where to get the correct rates
Do not copy rates from a blog, a forum or another seller. Fee structures change by category, seller agreement and effective date. Use these sources in order:
- Your signed seller agreement and any commercial annexures.
- The current rate card in your Seller Hub account.
- Fee breakup columns in your settlement and order reports.
- Your tax adviser, for GST, TCS and TDS treatment.
Add an effective from date next to each rate in your sheet. When Flipkart revises its terms, you can see which orders belong to which rate.
How to model the shipping fee
Shipping is where calculators most often go wrong, because the fee is not a flat percentage. Build it as a lookup, not a formula typed into every row.
- Record the weight of each SKU, including packaging, and the packed dimensions.
- Check whether your rate card uses actual weight, volumetric weight, or the higher of the two.
- Map the delivery zone (local, regional, national or as your rate card defines it) from your dispatch location to the customer pincode.
- Keep a weight-slab table per zone, and pull the fee with a lookup.
If your SKU master carries wrong weights, every shipping estimate will be wrong too. Fix the master data first.
How to model the collection fee
Do not guess the collection fee. Before you add a column, confirm three things in your rate card or agreement:
- What triggers it, for example payment mode or order type.
- What value it applies to: selling price, invoice value or something else.
- Whether it is reversed or retained when the order is returned or cancelled.
Keep the answers as a note beside the column. When someone asks why a particular order has a collection fee, you can point to the clause.
Suggested sheet structure
| Column | Source |
|---|---|
| Order ID, SKU, selling price | Order or sales report |
| Commission %, fixed fee | Rate card, by category and date |
| Collection fee rule | Rate card or agreement |
| Weight slab, zone, shipping fee | SKU master plus shipping lookup |
| GST on fees | Fee invoice or settlement report |
| Expected net payout | Calculated |
| Actual settled amount, difference | Settlement report |
The last two rows matter most. A calculator without an actual-versus-expected column only tells you what should happen.
Test it against real settlements
Pick a sample of settled orders across categories, zones and return cases. Run them through your calculator and compare each line with the settlement report. Differences usually come from outdated rates, wrong SKU weights, a misread collection fee rule, or a genuine over-charge you can raise with the marketplace.
Doing this monthly in a spreadsheet gets heavy as order volume grows. MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed today; Flipkart coverage is a scope discussion, and pricing is a tailored quote.
Worked example
Illustrative example only. The rates and amounts below are assumed for demonstration and are not Flipkart's actual fees. Replace them with figures from your rate card.
| Line | Illustrative amount |
|---|---|
| Selling price | ₹1,000 |
| Commission (assumed 10%) | ₹100 |
| Fixed fee (assumed) | ₹10 |
| Collection fee (assumed 2%) | ₹20 |
| Shipping fee (assumed slab and zone) | ₹60 |
| GST on fees (assumed; take from invoice) | ₹30 |
| Total deductions | ₹220 |
| Expected payout before TCS/TDS | ₹780 |
If the settlement report shows ₹760 before TCS and TDS, the ₹20 gap is the line to investigate. Check the shipping weight slab first, then the collection fee rule.
Questions and answers
Does Flipkart publish a fee calculator for sellers?
Flipkart provides rate cards and fee information inside Seller Hub, and the exact tools can change. Check your account for the current version. Because your agreement and category affect charges, treat any calculator as an estimate and verify it against settled orders.
How is the Flipkart shipping fee calculated?
It generally depends on weight, packed dimensions and delivery zone, but the exact slabs and weight rules sit in your rate card. Confirm whether actual or volumetric weight applies, keep SKU weights accurate, and compare estimates with the fee breakup in your settlement report.
Is the collection fee charged on returned orders?
This depends on your rate card and the return type, so do not assume. Check the collection fee clause in your agreement, then look at returned orders in your settlement report to see whether it was reversed or retained. Raise a ticket if it differs from the terms.
Should TCS and TDS be part of the fee calculator?
Keep them as separate columns because they are tax deductions, not marketplace fees. They affect your cash payout and later credits. Take the amounts from the settlement report and confirm the treatment and current rules with your tax adviser.