Amazon Fee Calculator For Sellers

Amazon is the largest online marketplace in India. Amazon has more sellers than any other marketplace. To register on Amazon is too simple now, it’s just a signup process. You just need to fill GST details, business type, business name, Contact name, Contact number, email id and address. If you are a beginner on Amazon so your first check would be how to list products on Amazon. In this post, I am going to tell you how you can manage Amazon bulk price on amazon seller central very easily with the help of Amazon Calculator which is on Excel sheet based on some formulas. I prepared Amazon Fee Calculator in excel sheet which is very handy and useful for a seller to calculate the revenue or transfer price of each and every product listing. It is difficult for the sellers to manage prices of every listing together in seller central page because you can’t check every component of marketplace fees ( Amazon referral fees, Fixed closing fee, Outward shipping charges and service tax ) quickly in bulk. Amazon.in has its own revenue calculator attached to every ASIN. You can check your marketplace fees except for shipping charges because the shipping charges totally depend upon the packaging dimensions and dead weight whichever is higher that’s why Amazon doesn’t show the shipping charges there. It can be difficult for you to calculate your shipping charges and add them to the shown fee estimate. That’s why Amazon calculator serves the purpose in a very limited way.
Amazon calculator

Amazon price
Amazon Seller Fees

Limited features of Amazon calculator
1. If you want to offer extra off to the customer so you need to update your offer price and mostly seller use the offer price section and it works only with standard price. You can’t see your fess estimate there.
2. You cannot calculate multiple listings revenue at a single time, in short, it doesn’t work in bulk.
3. It doesn’t include shipping charges.
4. It doesn’t reflect the payout after deduction of GST as per your category.

Amazon Calculator In Excel

amazon calculator in excel

With the help of Amazon Calculator, you can overcome from all above issues. You can calculate your accurate payout with no time. You will feel a lot of benefits when you’ll use the excel amazon fee calculator.

Benefits of Amazon Calculator in Excel

1. Easy to use, anyone can use it without any technical knowledge of excel.
2. You can calculate your profit even before GST or after GST.
3. You can manage the pricing of multiple categories at one place.
4. You can manage your whole catalog at a single place and can identify your product through ASIN, SKU and product name together.
5. You can manage multiple tax rate products easily here.
6. You can manage input shipping charges.
7. At last but not least, you can manage the dimensions of your product and weight.
8. You can maintain your sale price very easily here you don’t need to check your offer price one by one.

Few Examples:

SKU Category Commission Tax Rate Cost Price MRP Selling Price
SKU1 21 3 100 799 433
SKU2 15 10 100 799 400
SKU3 17 5 100 799 500
SKU4 20 15 100 799 300
SKU5 10 28 100 799 450

See Below How My Amazon Fee Calculator In Excel Will Work

Amazon calculator In Excel Sheet

Step by Step guide How to use Amazon Fee Calculator

In Column A, you need to put ASIN of every listed product. ASIN (Amazon Standard Identification Number) is the unique combination of an alphanumeric serial number of every listing assigned by Amazon.
In Column B, you need to put SKU (Stock Keeping unit), SKU is the unique code of every product assigned by the seller.
In Column C, you need to put the Category Name on which you deal.
In Column D, you need to put the name of your product according to your requirement or for identification of your product.
In Column E, you need to put category commission rate. Eg. If you deal in Jewellery Category commission rate is 23%. You just need to put 23 without any percentage (%) sign.
In Column F, you need to put GST rate. Eg. If you deal in Jewellery Category tax rate is 3%. You just need to put 3 without any percentage (%) sign.
In Column G, you need to put the cost price of your product.
In Column H, you need to put MRP (Max retail price).
In Column I, you need to put your standard price on which your product commonly sell.
In Column J, It is the column of offer Price it means it is the price which reflects to the customer at Amazon.in website.
In Column K, If you want to charge shipping charges from the customer You need to put shipping charges you want to collect from the customer.
In Column R, S, T, You need to put the packaging dimensions after packing of the product. It must be in cms only.
In Column U, you need to put the dead weight of the product after packing. It must be in gms only.
In Column V, It is the formula based column which automatically calculates the volumetric weight in gms as per Amazon. You don’t need to put any data there.
After filing all required columns mentioned above, columns M, N, O will automatically calculate the transfer price of your listing exact to Amazon payout.
All 3 Columns(M, N, O) will have different transfer price based on the region (Local, Zonal, National).
Column P is the column of profit(Minimum from M, N, O) after deductions of marketplace fees and cost price.
At the End, All 3 Columns(X, Y, Z) will have different transfer price based on the region (Local, Zonal, National) after deduction of sales tax.
Column AA is the column of profit(Minimum from AA, AB, AC) after deductions of marketplace fees and cost price and sales tax or GST.

To get this excel file ping me on WhatsApp no. 7838402246.

49 thoughts on “Amazon Fee Calculator For Sellers

  • Very good thing you have done
    Thanks a ton

    Reply
  • Please send me the file by email.

    Reply
  • Please send the file t omy email for both amazon and flipkart.

    Reply
  • Hi there…
    Please send me the excel file.

    Reply
  • interesting – would like to see how it works

    Reply
  • hey, can you please send the ink

    Reply
  • plz send me the file

    Reply
  • plz send me the file

    Reply
  • Please send me the excel for Amazon INdia as well as FLipkart

    Reply
  • Hi Please email me Amazon Fee Calculator excel

    Reply
  • Can you pls send me this file

    Reply
  • Please share file

    Reply
  • Hi there…
    Please send me the excel file.

    Reply
  • Please Share This File with Me.
    Thanks a Ton

    Reply
  • amazon india marketplace seller margin calculation excel sheet

    Reply
  • Thank you for the info. Please send the excel spreadsheet.

    Reply
  • Please send file… Thanks…

    Reply
  • very interesting , please send me this file

    Reply
  • Please share file,thanks in advance

    Reply
  • Could you pls shear me this file. Thanks in advance

    Reply
  • Please send me Excel file

    Reply
  • Hi there…
    Can you please send me the excel file.

    Reply
  • Great work, please send me the spreadsheet 🙂

    Reply
  • Please send me excel calculator for amazon and flipkart both

    Reply
  • Please send me excel link

    Reply
  • Please share file

    Reply
  • Hi,

    Would like to receive a copy of this file.

    Reply
  • Hi please share the link to the Amazon calculator by email.
    Thank u

    Reply
  • please share the file

    Reply
  • Please share the link

    Reply
  • please share file.

    Reply
  • Please send the excel sheet

    Reply
  • Hi Please email me Amazon Fee Calculator excel

    Reply
  • Please send me the excel for Amazon India as well as FLipkart

    Reply
  • Please send me the price file to my email

    Reply
  • Very goog work, looking forward to test it

    Reply
  • wow, this seems to be easy to compute. Could you possibly send it on my email id

    Reply
  • plz send me the file

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *