Amazon Seller Fee Calculator (Excel & JSON) – India

Selling on Amazon India involves multiple fee components such as referral fees, closing fees, shipping charges, fulfillment fees, and GST.
An Amazon Seller Fee Calculator helps sellers, IT teams, and finance departments estimate net payout accurately before listing products.

This Knowledge Base article explains:

• Amazon India fee structure

• Calculation logic

• Excel-based calculator (ready to use)

• JSON-based calculator (for apps, ERP, CRM, AMC systems)

• Common issues, security, and best practices

Amazon Seller Fee Components (India)

Core Fee Elements

Technical Fee Calculation Logic

Formula (Simplified)

Referral Fee = Product Price × Referral %
Amazon Fees (Pre-GST) =
  Referral Fee + Closing Fee + Shipping Fee + FBA Fee

GST on Amazon Fees =
  Amazon Fees × 18%

Total Amazon Fees =
  Amazon Fees + GST on Amazon Fees

Net Seller Payout =
  Product Price − Total Amazon Fees

Excel-Based Amazon Seller Fee Calculator

Download Ready-to-Use Excel File

?

Excel Sheet Structure

+---------------------------+------------------+
| Product Price (Excl GST)  | ₹10,000          |
| GST %                     | 18               |
| Referral Fee %            | 10               |
| Closing Fee               | ₹25              |
| Shipping Fee              | ₹120             |
| FBA Fee                   | ₹0               |
| GST on Amazon Fees (18%)  | Auto-calculated  |
| Total Amazon Fees         | Auto-calculated  |
| Net Seller Payout         | Auto-calculated  |
+---------------------------+------------------+

Key Excel Formulas (Reference)

Referral Fee
= (ReferralFee% / 100) * ProductPrice

GST on Amazon Fees
= (ReferralFee + ClosingFee + ShippingFee + FBAFee) * 0.18

Total Amazon Fees
= AmazonFees + GSTonAmazonFees

Net Seller Payout
= ProductPrice - TotalAmazonFees

JSON-Based Amazon Fee Calculator (For Applications)

Use Case

• Web calculators

• AMC / CRM systems

• ERP integrations

• Mobile apps

• Internal pricing tools

Sample Input JSON

{
  "product_price": 10000,
  "gst_rate": 18,
  "referral_fee_percent": 10,
  "closing_fee": 25,
  "shipping_fee": 120,
  "fba_fee": 0
}

Sample Output JSON

{
  "referral_fee": 1000,
  "amazon_fees_pre_gst": 1145,
  "gst_on_amazon_fees": 206.1,
  "total_amazon_fees": 1351.1,
  "net_seller_payout": 8648.9
}

Pseudocode (Language-Agnostic)

referral_fee = price * referral_percent / 100
amazon_fees = referral_fee + closing + shipping + fba
gst_on_fees = amazon_fees * 0.18
total_fees = amazon_fees + gst_on_fees
net_payout = price - total_fees

Use Cases

For Sellers

• Price planning before listing

• Margin analysis

• Category comparison

For IT / AMC Businesses

• Hardware resale margin calculation

• Renewal pricing

• CRM-based auto quotation

For Finance Teams

• GST reconciliation

• Settlement verification

• Audit preparation

Step-by-Step Implementation

Excel

1. Download calculator

2. Enter product price & fees

3. Review auto-calculated payout

4. Adjust referral % per category

JSON / Application

1. Capture product inputs

2. Apply fee calculation logic

3. Store results in database

4. Display net payout to user

Common Issues & Fixes

Security Considerations

• Do not hardcode bank details

• Validate numeric inputs

• Restrict calculator access in ERP

• Log pricing changes

• Encrypt stored financial data

Best Practices

• Maintain category-wise referral fee table

• Separate FBA and non-FBA calculations

• Reconcile payouts with Amazon settlement reports

• Version-control calculator logic

• Test calculations monthly

Conclusion

An Amazon Seller Fee Calculator is essential for accurate pricing, margin control, and compliance in the Indian marketplace.
Using both Excel for quick analysis and JSON logic for automation ensures sellers and IT-driven businesses can scale operations confidently while avoiding pricing losses.

#AmazonSeller #AmazonIndia #FeeCalculator #EcommerceIndia #AmazonFBA #GSTIndia #SellerCentral #EcommerceTools #PricingCalculator #OnlineSelling #ITBusiness #AMCServices #EcommerceFinance #RetailTech #MarketplaceFees #AmazonFees #SellerTools #DigitalCommerce #EcommerceAutomation #IndianEcommerce #GSTCompliance #BusinessTools #PricingStrategy #EcommerceAccounting