Amazon Seller Fee Calculator (Excel & JSON) – India

📅 09 Jan 2026 📂 General 👁 302 views

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

Fee Component	Description
Product Price	Base selling price (excluding GST)
GST on Product	Category-based GST (5%, 12%, 18%, 28%)
Referral Fee	% charged by Amazon per category
Closing Fee	Fixed fee per unit
Shipping Fee	Weight & distance-based
FBA Fee	Fulfillment + storage (optional)
GST on Amazon Fees	18% GST applied on Amazon charges

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

Amazon_Seller_Fee_Calculator_India.xlsx

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

Download calculator
Enter product price & fees
Review auto-calculated payout
Adjust referral % per category

JSON / Application

Capture product inputs
Apply fee calculation logic
Store results in database
Display net payout to user

Common Issues & Fixes

Issue	Cause	Fix
Wrong payout	Incorrect referral %	Use category-wise rates
GST mismatch	Wrong GST slab	Verify HSN
Negative margin	High shipping/FBA	Reprice product
Settlement mismatch	Rounding	Match Amazon reports
Fee changes	Policy update	Update calculator quarterly

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

Amazon seller fee calculator Amazon fee calculator India Amazon payout calculation Amazon referral fee India Amazon GST calculation Amazon closing fee Amazon shipping fee India Amazon FBA fee India Amazon seller Excel calculator Amazon pricing to