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.
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
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.
|SKU||Category Commission||Tax Rate||Cost Price||MRP||Selling Price|
See Below How My Amazon Fee Calculator In Excel Will Work
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.