Allow the addon to start collecting your Amazon seller data for a few hours, and then refresh the profit loss sheet and it will auto populate into the nice and easy to read P&L format you see in the screenshot.
This is the first of two advertising report analysis spreadsheets you can download.
This spreadsheet is built for “search term” reports from your advertising reports page.
The two main exports are for “targeting” and “search term”. Search term are the terms that customers type in and find your products. And because the columns and exports are slightly different, I’ve created two separate versions so you don’t get confused.
I’ve found that ROAS is the best indicator to use when filtering and analyzing your search terms.
ACoS breaks down if you don’t have any sales. You could end up spending $1,000 on a particular keyword, but if there are no sales, it will be blank and you’ll be left in the dark.
Note that this is a manual spreadsheet. So you have to copy and paste the data in from your CSV file. Automation will come later via the addon for Gorilla ROI.
With this seller advertising spreadsheet, you can:
see key stats related to what customers are looking for
see best revenue generating keyword
see lowest and highest ACoS keyword
see top 10 best and worst keywords
see highest spend keyword
This type of analysis should help you figure out where you need to improve, or where your current campaigns are strong so that you can make it even stronger and box out competitors.
How it works
Instructions for this FBA spreadsheet is included in the spreadsheet, but here’s a quick rundown.
Go to Reports > Advertising Reports
Select “Sponsored Products”
Select “Search term”
Select your report period
Create the report and then download the csv
Copy the data from the csv file
Paste it into the FBA template where the tab says “data” or “copydatahere”.
Make sure the column positioning matches the example.
This is the second of the two advertising report analyzer spreadsheets. While the customer search term spreadsheet above looks up the stats for the search terms your customer types in to the search bar, this one looks up the stats related to the keywords you currently have in your campaign.
Return on Ad Spend (RoAS) is the key filtering metric here. Focus on getting a higher RoAS number as it means your return is higher compared to the spend.
The way this spreadsheet has been designed is to make the data easy to understand and without having to click the same filter button so-many-times to do the same thing over and over again.
In order to automate this spreadsheet, it’s built with a lot of complex INDEX() and MATCH() functions. If you don’t know what you are doing, try playing around a little bit and undoing the changes to return it back to normal.
Once you figure out how this spreadsheet and the formulas work, you can create more “widgets” based on criteria you need to look up.
How it works
Instructions for this targeting keyword spreadsheet is included in the spreadsheet, but here’s a quick rundown.
Go to Reports > Advertising Reports
Select “Sponsored Products”
Select your report period
Create the report and then download the csv
Copy the data from the csv file
Paste it into the FBA template where the tab says “data” or “copydatahere”.
Make sure the column positioning matches the example.
Because it’s one of the most sought after and requested spreadsheets. This sales spreadsheet automatically pulls, loads your data and displays it over 25 preset periods.
If you want to get a granular breakdown of your sales performance, look no more.
Just look at the different preset time periods you can pull for your seller sales.
Same day last week
Same day last month
Same day last year
Last 7 Days
Last 14 Days
Last 30 Days
Last 60 Days
Last 12 Months
Last 7 Days Week Ago
Last 7 Days Year Ago
Last 30 Days Month Ago
Last 30 Days Year Ago
Last Week Year Ago
Last Month Year Ago
YYYY-MM (set format as text)
Trying to get this manually to understand and dig into your data will be a nightmare.
The spreadsheet includes the formulas required to get this information from your seller central account data. All you have to do is install the Gorilla ROI addon, activate it and away you go.
With this type of breakdown, it helps you see how your business is doing. Rather than procrastinating or wasting time (which is money) to do it manually or not doing it at all, you can keep track of sales and jump on things that need attention.
If you want to see how deep and granular you can go, check out the preview above. It’s a version that all Gorilla ROI members get along with other special spreadsheets and dashboards to make life easier as an FBA seller.
How it works
This one is not a manual spreadsheet.
There is simply no way you can update this manually. And that’s the point. Data like this should be automated.
Follow the instructions on how to install and add any 3 of your FBA SKUs. FBM is not supported.
Allow the addon to start collecting your Amazon seller data for a few hours and then it will start populating the spreadsheet.
Many software tools for FBA are popping up, but I believe that spreadsheets are necessary to give flexibility to the user.
Subscribing to software is great and there are many tools out there, but seeing how you can customize a car, home and pretty much most products, you should have the flexibility to use your own data in a way that makes sense to you.
You and I have different KPI’s and the point of using spreadsheet tools is to create basic templates that you or your team members can use without interrupting your workflow.
As Google continues to enhance its Google Sheets product, the power of Sheets continues to increase. A few years back, G Sheets could barely do the basics, but today, you have a full-blown spreadsheet application online.
Combine with Google Data Studio, Zapier, Slack and other apps and you have the tools and power to create internal apps and software processes for pennies.
How the spreadsheets are designed
I wrote about how I do spreadsheets here. This article will help as you can see and understand the architecture of the spreadsheets allowing you to extend it and create bigger, better versions of it.
Just remember to separate the data and the display tabs.
In all the free templates I’ve shared with you, there is a tab for entering the raw data, one that processes the data and one that displays the data.
Keep it like that and you’ll see how easy and quick it is to manage and use a spreadsheet, rather than the messy monsters you are likely used to.
What other spreadsheets do you want?
I love creating free Amazon FBA spreadsheet around here. Whether it be for Google Sheets or for Excel, spreadsheets are not going away anytime soon.
Rather than just creating spreadsheet templates that are nothing but some titles, I want to create functional tools for FBA that you can use.
If you have ideas or a request, leave a comment below.
I will continue to make spreadsheets and add them to this free spreadsheets resource page.
Make sure you bookmark it or share it with others. The more demand, the more FBA templates I’ll offer.
Frequently asked questions
Does this work for Excel?
All the Amazon spreadsheets you find here are created for Google Sheets. You can save them as excel format, but there will be formulas that need to be converted to MS excel format. Functions like QUERY() are not supported in Excel and you’ll have to whip out advanced techniques like power queries to run the same thing. Or a lot of VLOOKUPS, INDEX, MATCH functions.
What other spreadsheets and tools do you offer?
We offer a suite of ready to go Business Pro Spreadsheets and documents to improve your FBA operations. Things like forecasting calculators, inventory analysis sheets, manufacturing agreements in Chinese and English and so on. The suite of spreadsheets and docs continue to grow and it is lifetime access for a single payment.
Do you provide support for these spreadsheets?
I’ve created these spreadsheets so that people of any level can use them. I take a software engineering approach to create very easy to use spreadsheets and you will see how easy it is once you open them up. I’ll continue updating these spreadsheets if Amazon changes their reports or formatting.
Do I need the Gorilla ROI addon for these spreadsheets to work?
Not for all. The spreadsheet for product listings and detailed sales performance is best with the addon. The addon is free for any 3 of your FBA SKUs and if you can automate the process, what have you got to lose? Takes a minute to install and if you don’t like it, just uninstall it.
Can I share these spreadsheets with others?
Yes, you can share it with your team, family, friends and whoever else may benefit from having a free Amazon FBA spreadsheet. Please don’t remove the attribution as I have spent a lot of time making these spreadsheets and would hate to take it down if people are found to be claiming they made the spreadsheets.
Do you make custom spreadsheets for Amazon sellers?
No. I do not offer custom services. My team does offer support and custom integration into your existing spreadsheets if you sign up to use Gorilla ROI and purchase the Support and Warranty package found in your account.
This guide is not related to FBA estimated fees or an FBA calculator as there are so many on the internet already.
However, if you are a seller and want a detailed breakdown of every fee and charge that Amazon makes you pay for their services to calculate your cost, profit and loss, this is the place to be.
Let’s not waste any time.
Difference between fees and charges
An important and confusing point to first understand is the difference between a fee and a charge.
They are very similar and some items are used interchangeably.
The main difference:
Amazon seller FEE is when you pay to use a “product” from within the Amazon platform. E.g. a subscription is an FBA software “product” that sellers pay for. Amazon’s warehouse is another product that we pay to use. Fees are considered part of COGS related to selling your product.
Amazon seller CHARGES are expenses for you to request Amazon to perform a service or task on your behalf. It’s not a product, but more of a service. E.g. gift wrapping is a service you pay for to offer to customers. Removal orders are charges and not fees because you are requesting Amazon to perform a service on your behalf. Charges are considered part of operational expenses and not COGS.
Looking for Fee Preview?
If you want to see a preview of your Amazon seller fees for a product, go to Manage Inventory and then click on the “Fee Preview” link and it will show something like this.
Alternatively, you can check the FBA preview report.
Go to Reports > fulfillment > payments
This will bring you to the reports page. Click on “Fee Preview”.
List of Amazon seller fees to discuss
The following is a list of fees and charges that you will pay Amazon for selling on their platform in alphabetical order.
Amazon Imaging Fee
Amazon has launched an imaging service where the seller can have Amazon pull a product from inventory to take a professional looking photo.
Prices range from $50 to $150 depending on the type of product.
Amazon Exclusives Fee
Sellers agree to sell their product or products on Amazon exclusively. No other online marketplace except your own website. Physical stores are allowed.
Amazon will give the seller more visibility and perks within the Amazon ecosystem, but if the product is a hit, you are locked into selling via Amazon only.
Also consider that you will have to pay an additional 5% on all your sales. This includes everything in your inventory that is not listed on Amazon Exclusives. Ouch.
Also known as variable closing fees and is an extra fee that Amazon adds on top of the referral fee. The rate varies depending on whether it is a media product or non-media product.
For media products, it is a fixe rate. For non-media products, the variable fee is based on the shipping weight.
Say you sell a book for $20. The referral fee you pay is 15% which is $3.
The variable closing fee is then another fee on top of that depending on your category.
Cash on Delivery Chargeback
Cash on Delivery is no longer used or accepted. An old transactional item for when people did not, or did not want to use credit cards online.
Also known as referral fee, which is a fee that Amazon charges to all 3rd-party sellers. This is the core fee you need to pay for the privilege of selling on Amazon’s giant platform.
The fee varies greatly with the lowest being 6% for personal computers and 96% for warranties.
If you sell a $1000 PC, then you pay Amazon $60 as a commission.
If you sell a warranty for $100, then you pay Amazon $96.
You can find the amounts paid from your reports section.
Go to Seller central > reports > fulfillment.
You will land on this page with a sidebar for a bunch of information that you can download as csv files.
A shortcut is to go to manage inventory and the fee preview section.
Includes Fresh Inbound Transportation Fee
Global Inbound Transportation Fee
FBA Inbound Shipment Carton Level Info Fee
FBA Inbound Transportation Program Fee
Inbound refers to the shipment that you send to Amazon. It could be coming from you directly or from your manufacturer.
Amazon requires you to provide accurate information related to your inbound shipment to be processed efficiently. If you enter wrong information about your carton information such as the number of boxes, sizes, and weights, you will pay a fee for the information and work that Amazon has to do to correct it.
This applies to the transportation program fee.
If the amount you paid to UPS or the shipping company is not correct, you will be charged extra for the difference.
Say you entered the box as having a dimension weight of 100kgs or 100lbs.
However, UPS scanners measured it as 120kgs or 120lbs. You will pay the extra fee for the difference.
FBA Inventory Disposals
Amazon FBA has inventory storage fees so it makes sense that they also have inventory disposal fees if you want Amazon to dispose your inventory.
It’s also called FBA removal order fees.
There are 2 situations to dispose a product.
We sell in UK, and if we get a return, there is no point in trying to have it shipped back to us in the US. Therefore, we have selected to “dispose” automatically all returned items.
You can manually dispose products. If an item does not sell and it’s cheaper to throw away, you can request Amazon to dispose the inventory. If you sell food products and it expires, you can also dispose of it manually.
When you create a shipment plan to send inventory to Amazon, they will sometimes make you split up your inventory and send it to different fulfillment centers.
This is usually the case when you ship small quantities.
Inventory Placement Service is when you select the option to send your shipment to one destination fulfillment center.
Amazon will then receive it at the FC, split up the quantities and send it to whatever warehouses that need them.
e.g. You are sending 20 cups and the shipment plan says you have to pay for 3 different shipping labels.
One to CA. One to TX. One to NY.
This can be costly.
Or you if you activate the Inventory Placement Fee, you can send everything to a single designated warehouse.
The fees are based on weight. Check the Amazon page for the most up to date and accurate pricing.
FBA Inventory Storage Fee
Inventory storage fees can eat quickly into your profit if you have slow selling inventory or too much inventory at their warehouses. Amazon does not want you to use their warehouse as stock rooms. Their fulfillment centers must keep turning over inventory.
Inventory removal is a good way to mitigate (or outright avoid) long term storage fees if you think that your products will not sell after 6 months. It simply means taking your inventory out of the Amazon warehouse and shipping it to your own storage facility or your house.
Do this by creating a removal order. Click manage inventory then click the checkbox of the items you wish to be returned. Click the dropdown menu and choose “create removal order”. From there, type in the relevant data, follow the instructions and submit.
FBA Label Service Fee
If you request Amazon to label your products with the ASIN/FNSKU barcodes, Amazon will charge a per labeling fee. The fee per label is $0.20 but check the page for updates in case this fee is increased.
FBA Liquidation Fee
This service is no longer available.
Amazon has gotten rid of the option to allow sellers to liquidate their old (6+months) inventory via 3rd party liquidators.
The only options left are to dispose it or have it sent back to your address.
FBA Long-Term Storage Fees
When your inventory sits in Amazon’s warehouse for 12+ months, it incurs long term storage fees.
Amazon does not want you to use their warehouses like a storage unit. Their fulfillment centers are designed to keep inventory flowing. Anything that is stale inventory is considered wasted space and revenue.
On the 15th of each month, Fulfillment by Amazon (FBA) conducts an inventory cleanup. On these dates, inventory that has been in US fulfillment centers for more than 365 days incurs a long-term storage fee (LTSF) of $6.90 per cubic foot or a $0.15 per-unit long-term storage fee, whichever is greater.
FBA Multi-Channel Fulfillment Weight Handling
Multi-Channel Fulfillment (MCF) is when you sell your product on a different marketplace like your website, and then you send the order information for Amazon to fulfill.
Depending on the weight of the order, the fees will differ.
Previously, Amazon used to separate the fulfillment fees to pick/pack, shipping, weight and so on.
Now it is all rolled into one fee item “FBA Fulfillment Fees”.
FBA Prep Service Fees
FBA Prep Service Fees (Bubble Wrap)
FBA Prep Service Fees (Labeling)
FBA Prep Service Fees-Adult-Bagging (black or opaque)
FBA Unplanned Prep Service Fees
Includes Prep Fee refund (PREPFEE_REFUND)
Sellers may need Amazon to handle preparation of the products. It could include bubble wrapping fragile objects, fixing barcode labels or adding extra labels like warning stickers, and repackaging adult products so that it is not visible.
FBA Returns Processing
FBA Returns Processing Fee-Order Handling
FBA Returns Processing Fee-Pick & Pack
FBA Returns Processing Fee-Weight Handling
Additional fees when products are returned by the seller.
FBA Taping Fee
This is part of the FBA Prep section.
Products with this requirement need additional taping beyond what might normally be used to seal a box or poly bag or secure bubble wrap around an item.
Extra taping may be required if the item:
Might fall out of its packaging if the container is not taped shut
Might leak if the lid is not taped in place
Needs tape to be fully sealed within the container
FBA Transportation Fee
An older name for Inbound Transportation Charge.
This is no longer used but is the amount you pay to ship your items to Amazon via their shipping label service.
FBA Weight Based Fee
This fee is no longer used as it is rolled up into “FBA Fulfillment Fees”.
This was how it was done previously. There are size tiers for different products. Once you’ve determined which size tier your product falls in then you have to pay a flat rate for that product based on shipping weight.
As with the inventory sizes, this is also measured in standard and oversize but the two classifications are also broken down to a few more tiers. You can see the complete chart here, but here’s a quick summary.
Standard products – small standard, large standard
Oversize products – small, medium, large, special oversize
FBA Localization Fee
No information is available from Amazon on the description of this fee.
Our guess is that this is fee is added when Amazon is hired to change the listing language to the local language.
If you live in USA and want to sell in Japan, Amazon handles the listings and localization of the listing. This looks to be the fee related having it translated and adapted to the Japan market.
Your inventory is now measured based on your Inventory Performance Index (IPI). If you have inventory that exceeds the allowed limit based on your IPI, you will pay overage fees.
You could be in the green in terms of storage limits, but if your sell-through drops and you don’t keep track of your performance, your IPI will drop and that will further accelerate your overage fees.
Get Paid Faster Fee
This one is a processing fee for sellers that wish to “get paid faster” from invoiced orders by business buyers. This post sums it up.
We are also launching the ability for you to “Get Paid Faster” for invoiced orders. With this feature, your payment for Pay by Invoice orders will be credited to the available balance of your Selling on Amazon account immediately after shipment for a processing charge of 1.5% of the invoiced order amount. To take advantage of this option, change your invoiced order payment settings to get paid faster for all your future invoiced orders.
With this feature, your payment for Pay by Invoice orders will be credited to the available balance of your Selling on Amazon account immediately after shipment for a processing charge of 1.5% of the invoiced order amount.
This is not worth doing unless you are desperate for cash and can’t wait 30 days to collect the payment from the business buyer.
Gift Wrap Commission
This is related to when you collect the gift wrap fee from the customer if you have it enabled it on your account.
If you are FBA, Amazon will collect this charge and present it as your revenue. This is your revenue but since Amazon is the party that does the gift wrapping service, they will get a chargeback from you as described in the next section.
Gift Wrap Charge-Back Fee
A shopper selects the gift wrap option at checkout. The shopper pays you for the gift wrap, but since Amazon is the one that gift wraps it, they then do a charge-back to you and this balances it out.
Let’s say Peter buys a $50 glove for Christmas and chooses gift wrap for an extra $5. He pays $55 at checkout and $55 goes into your sales balance.
Amazon will then do the gift wrap and then charge you $5 for the gift wrap.
This way, you end up with $50 for your product.
Gift wrap is optional and not mandatory for FBA sellers.
When you issue a full refund for a Books, Music, Video, and DVD (BMVD) product, Amazon will refund all of the original order-related fees.
When you issue a partial refund for a BMVD product, Amazon retains the variable closing fee and credits you a proportional amount of the referral fee originally charged for the order, based on the percentage of the item price you refunded to the buyer.
For non-media items:
When you issue a full refund for a non-BMVD product, Amazon retains 20% of the original order-related-fees, up to a maximum of $5, for each line item in the refund. This amount is retained as a refund administration fee. We will credit you the amount of the order-related fees originally charged for the item you refunded, minus the refund administration fee.
When you issue a partial refund for a non-BMVD product, Amazon retains 20% of the original order-related fees, up to a maximum of $5, for each line item in the refund. Amazon credits you a proportional amount of the referral fee originally charged for the order, based on the percentage of the item price you refunded to the buyer.
If you sell non-media items you lose 20% of the FBA fees for the work they did in shipping it to the customer and processing the returns.
This 20% is called the refund administration fee.
Review Enrollment Fee
Positive reviews are important for the product you’re selling on Amazon.
Having a new product reviewed is a significant leg up for sellers. That’s why Amazon opened up the Amazon Early Reviewer Program.
From seller central go to Advertising > Early reviewer program.
On this page you can submit individual SKUs or use the csv uploader if you want to enroll a list of SKUs.
First thing is to determine if you’re SKU/s are eligible for the early review program.
Here’s how to check.
Product price should be more than $9.00
Only choose the parent SKU since child SKUs will be included in the review program automatically.
Your SKU should have less than 5 reviews on Amazon at the time of enrollment
A Lightning Deal is a promotion offered in a limited quantity for a short period of time.
You can also call it a flash sale, but it is a great way for FBA sellers to have their products posted on the Amazon Todays’s Deals Page.
If you run a lightning deal, you pay $150 for the promotion of your product being featured for a 6 hour period.
Cancellation before the sale period will not require sellers to pay, but sellers will pay in full if they cancel while the sale is still in progress.
A typical fee is at $150 but fees are also affected by the country you’re running the deal on and the week your deal will run on. So if you run the deal in a high traffic country like the USA and you run it during the holidays then you’ll have to pay a higher price.
The week of Black friday and cyber monday costs $300 to host a lightning deal because of such high demand. There is no guarantee you will have a 6 hour window.
Here’s how to locate the deal fees. In your Amazon seller central dashboard, click on reports, payments, then transaction view.
In this page, you will find “service fees” in the dropdown.
Now if you want to run a lightning deal all you have to do within seller central is click advertising>deals
This will bring you to the deals page where you can create a new deal or check on whatever current and past deals you’ve created.
This is the taxable amount of the lightning deal fee. If the standard Amazon seller fee is $150 and the tax is 10%, then $15 is on the transaction as going towards taxes.
Since your amount of $150 is final, Amazon receives $135 and Amazon will pay $15 in tax that it collected from your payment.
Shipping Charge-Back Fee
This is the same concept as the Gift Wrap Charge-Back fee.
People who are not prime members will pay for shipping. At checkout, if they pay $5 in shipping, this $5 goes into your account.
But since Amazon is the one shipping the product, they will take it out of your account with a charge-back to balance out the transaction.
Shipping HB Fee
Also known as Shipping Holdback Fee.
There’s no shipping holdback fee if you do FBA and Amazon is the one shipping your items. But to keep prices down for customers and prevent sellers taking advantage of Amazon, Amazon implemented the shipping holdback fee.
In the past third-party sellers would list the item for $1 and then charge $29 in shipping in order to avoid paying the referral fee. That’s why this was implemented. A small fee amount is added based on the item if you do 100% discounts because it’s the same concept.
Amazon wants to collect fees for their services, regardless of whether you make money or not. You are using their platform and service and they want to be paid for what they do.
Tax Calculation Services Fees
Taxes should be factored in in any business, but if you don’t want to bother with calculations, Amazon will do it for you. Seller central help defines this as:
If you use the tax calculation services, you will pay us (Amazon) 2.9% of all sales and use taxes and other transaction-based charges we calculate. We will retain these fees in the event of any refund on related transactions.
Amazon “charges” that the sellers pay
All the items until now were related to Amazon Seller Fees you pay. Fees and charges are different. Fees are for services that Amazon provides and you want to use.
Amount given to the buyer to compensate for shipping the item back to Amazon
If the buyer is not a Prime member and they required to ship the product back in order to get a refund, Amazon will reimburse the buyer and it will come out of your account.
Charge that Amazon charges the buyer when returning a product
Includes Compensation for return shipping when a buyer receives the wrong item and requests a free replacement
This is a ledger item with the amount given to the buyer to compensate for shipping the item back.
Let’s say a buyer wants to a return a TV because the wrong item was sent.
Amazon will add the shipping balance to the buyer. The buyer will then use the balance to purchase the return label.
Ultimately, it is a wash for the buyer as they are using the money that Amazon gave them.
Cash on Delivery
COD charge for an order
COD charge for an order item
Cash on delivery is rarely used or accepted.
Listed as COMPENSATED_CLAWBACK
A “clawback” is a reversal. Also called a reversal reimbursement which is applied to reimbursed payments that Amazon pay sellers, but then Amazon takes it back.
Take this example.
We are third party sellers and I monitor damaged or lost inventory which Amazon will reimburse. But sometimes Amazon finds missing inventory and will reverse the reimbursement.
Customer Return Wrong Item Reimbursement
Listed as CRETURN_WRONG_ITEM
Buyers are able to return items and then Amazon stores it in their warehouse to restock or resell. This one is a reimbursement given by Amazon if the buyer returns the wrong product and the buyer has been refunded.
For example, if a buyer returns a 2 pack of underwear, but you sell it as a 12 pack set, this will be similar to reimbursement when the buyer doesn’t return the item past 45 days.
You will then receive a reimbursement of the difference.
Custer Service Error Items Reimbursement
Listed as CS_ERROR_ITEMS
Sometimes, you will see a $50 refund that Amazon turned into a $150 refund to the customer. This happens a few times and this is an intentional ploy by Amazon customer service to show goodwill to the customer.
Amazon will reimburse you for the difference. Amazon customer service has the power to use your funds to give to the customer as “goodwill” and anything above that is part of this customer service error item.
It’s important to track your finance line items closely to request reimbursement.
FBA debt happens more frequently than you think.
When a FBA seller fails to sell anything and they can’t pay the storage fees, the seller has a balance due. If the card on file is not working, it becomes debt and Amazon will seek to get payment on this debt.
Amazon will take this from your account, rather than you having to mail a check or pay via credit card.
Export duty that is charged when Amazon ships an item to an international destination
A general rule is that, unless you’re MCF, sellers don’t pay extra FBA seller fees if they use FBA export to ship internationally.
Buyers pay for international shipping and costs related to export.
There are a couple of things you need to know about FBA export.
You can exclude countries to sell/export to in your Amazon seller account settings
Buyers can return products if it is eligible under Amazon’s existing FBA return policy
This option is no longer offered by Amazon. Previously sellers had the option of liquidating old and unsold inventory at liquidation prices. 5-10c on the dollar.
This liquidation service is discontinued.
Fee collected for certain payment methods
No longer used by Amazon.
Free Replacement of Refunded Items Reimbursement
Listed as FREE_REPLACEMENT_REFUND_ITEMS
Ever return an item and Amazon shows you the option to receive a refund or a replacement?
Amazon will replace the item for your buyer and the buyer has to return the original purchase. In other words, it’s a switch.
If the buyer does not return the original product, Amazon will reimburse you for the product that was not received.
Here’s what Amazon support has to say about it.
Hello from Fulfillment by Amazon, Getting a replacement for an FBA item just got easier for customers. As of September 5, 2018, a customer returning your item can ask to have a replacement sent to them free of charge – and there will be no cost to you.
For you, this means less time focusing on payments and refunds because the sale of the original item is unaffected. For customers, this means more convenient FBA returns, consistent with Amazon returns as a whole.
How it works To get a replacement item, a customer starts a return through the Online Returns Center or Customer Service.
If a customer requests a replacement, Amazon ships one from your inventory and asks the customer to send the original item to one of our returns centers. If they don’t send it back, or if the original item is returned damaged, Amazon will reimburse you according to the FBA customer returns policy.
Other things to know Only FBA items in new condition qualify for replacement.
Only Amazon can offer a replacement item, and only if the item is in your inventory.
You won’t be charged fees or receive payment for replacement orders. Your fees and payment on the original order will stay the same.
For more information on your replacement orders, go to your Replacements report.
Thank you for selling on Amazon. Sincerely, The Fulfillment by Amazon team
Generic Bad Debt Deduction
This is a rare transactional item. Bad Debt Deduction is when a buyer purchases your products but does not pay.
Since all Amazon shoppers need a credit card on file, this rarely comes up.
For more info on bad debt deduction, refer to the IRS page.
Gift Wrap Charge
This is the opposite of Gift Wrap Charge-Back Fee, where the customer pays you initially for gift wrapping.
Amazon will collect from you the amount received via the charge-back fee to balance the account.
GoodWill (Amount given to a buyer as a gesture of)
For reasons that Amazon will determine, they will offer a sort of payment to the customer as goodwill.
For example, if Amazon gets a call from an angry customer demanding a replacement AND something extra be done, they could give a $10 credit in addition.
This amount is deducted from your account. Amazon will usually provide this goodwill amount from their own account, but also from the seller’s account.
Inbound Carrier Damage
Listed as INBOUND_CARRIER_DAMAGE
When your shipments are on an Amazon partnered logistics company and your inbound shipment is damaged during transit, you will get a reimbursement.
It is not a one to one reimbursement. You must provide your BOL and other proof of documentation such as insurance to get the proper amount.
Even then, it could still be a battle.
Incorrect Fees Items
Listed as INCORRECT_FEES_ITEMS
FBA is not 100% accurate. Many times you are over/under charged.
In the event where you find that your product is wrongly classified into a higher tier and you have been paying more in fees that you should have, Amazon will reimburse you.
Note that until you manually do the work and find the errors, Amazon does not care and will not take any initiative.
There are two types of these- fees items and non-itemized.
Fees items mean there was an incorrect charge for a specific product.
Non-itemized is for non-specific or a service that’s not related to any product or SKU.
Not a common transaction. If you load goods to products before payment, it would be categorized into the 3 points above.
Lost Or Damaged Reimbursement
If your products are lost or damaged, you will receive a reimbursement if the product has not been found within 30 days.
Amazon determines how much you get back as a reimbursement. It is never the selling price. Amazon will deduct FBA fees and other charges and reimburse the difference.
Low Value Goods
These all fall in the Low Value Goods family of charges and reimbursements.
If If you sell cheap products, the revenue generated is listed under “principal”. “Shipping” is the amount the buyer pays.
For countries like Australia and New Zealand, GST is 15% and will be added on top of the total price, or shipping.
This transaction item will show you the total tax that you have collected. If you do not factor this into your prices, you will end up losing a lot of money as you will be owing money for each low value good that you sell.
Marketplace Facilitator Tax
Amazon is the marketplace facilitator.
As the marketplace facilitator, Amazon will now be responsible to calculate, collect, remit, and refund state sales tax on sales sold by third party sellers for transactions destined to states where Marketplace Facilitator and/or Marketplace collection legislation is enacted.
These tax items are from Amazon withholding taxes from the sale to pay the due taxes to the states.
Taxes come from the sales amount (principal), whether you charge a restocking fee and if you charge tax on shipping.
Amazon then remits the amounts to the states you are registered in.
Missing From Inbound
Listed as MISSING_FROM_INBOUND
Includes Missing From Inbound Clawback (MISSING_FROM_INBOUND_CLAWBACK)
Many times, Amazon will lose your shipment during inbound. Whether it is on the way to a fulfillment center, or during transfer between FC’s.
For units that go missing, you can request to have it investigated and then reimbursed.
You can see the shipments in seller central when you click on Inventory>Manage FBA Shipments. From here you will see the shipping Queue.
Once on this page, choose the radio button “closed” and you will filter out shipments that are not closed. Look at the number shipped and received.
You can reconcile discrepancies when you ship more than what Amazon received, and Amazon closes it. Even if Amazon closes the shipment, you can still file a manual reconcile.
Click the track shipment button to bring you to the reconcile page.
You need to upload documentation like proof of purchase before you can submit it for investigation.
Missing from inbound clawback is the opposite of missing from inbound reimbursement.
When inventory is misplaced during inbound by Amazon you’ll get a reimbursement for the lost items.
Amazon will claw or take that fee back if they find the inventory they lost.
This is the same as for FBA but it applies to multi channel fulfillment (MCF) where you use Amazon’s logistics system to fulfill orders from other channels like your website.
You will be reimbursed for damaged and lost goods.
Payment Retraction Items
Listed as PAYMENT_RETRACTION_ITEMS
There is not enough information on this transaction type.
Our guess is that it is related to a reversal of a payment received by the customer. A refund or A-Z claim is processed and comes out of your account.
Product Ads Payment Principal
Product Ads Payment Principal Charge
Product Ads Payment Principal Refund
Product Ads Payment Tax Charge
Product Ads Payment Tax Refund
As a seller, you can pay for PPC advertising with your credit card or from your balance.
Principal Ads Payment Charge is the amount you will pay Amazon from your account if you choose to pay them with your balance.
The refund is for any discrepancies that needs to be reimbursed to you.
The transaction items that has “Tax” is the taxable amount withheld.
Includes Promotional discount for an order item
Sellers can choose to offer promos and discounts to buyers as a way to entice people to buy.
This can be in the form of coupons where you offer a fixed price discount or a percentage discount.
Let’s say you have a $10 product and offer a $1 discount. You sell 100 units.
The promo rebate of $100 will be charged to your account.
There are other promo rebates such as free shipping or free super saver shipping to entice shoppers to sign up for Prime membership. Amazon will reimburse you for these types of promos.
Removal Order Damaged
Listed as REMOVAL_ORDER_DAMAGED
As the name suggests, this is a reimbursement when Amazon damages your items when you request a removal order.
Make sure you have evidence of photos and videos to submit once you receive your items from Amazon. Amazon will never be proactive about it so it is the responsibility of the seller to request reimbursements for damaged items.
Removal Order Lost
Listed as REMOVAL_ORDER_LOST
If you request a removal order and Amazon loses the item during the process, you will be reimbursed.
However, this is only possible if you count to verify that the amount you requested in the removal order does not match the received amount.
Amazon does not ship all the units in one box. If you request 1,000 units, it will likely come to you in 50 separate boxes as it comes from each fulfillment center that stored the product.
You must wait until you get the “removal order complete” notification via email. Then count the total received and request reimbursement if there is a discrepancy.
This is a general catch-all reversal line item if something does not fit into a specific category.
This is a reimbursement item of the reversals.
SAFE-T claim amount for the item
SAFE-T Reimbursement Charge (listed as SAFETReimbursementCharge)
File a reimbursement (SAFE-T) claim
The Seller Assurance for e-Commerce Transactions (SAFE-T) process allows you to file a claim for reimbursement if you want to appeal Amazon’s decision to issue a refund to a customer. At Amazon’s sole discretion, you may be issued a reimbursement in cases where Amazon determines that you were not at fault.
Selling Price (Principal)
Amazon uses the term “principal” to mean the selling price of the item.
If you sell $20 hot dogs, the principal is $20.
The common term used is sales price, but Amazon uses principal in their terminology.
Includes Shipping charges for a COD order
Also known as Shipping Income
For buyers who pay shipping, the amount is entered as a shipping charge. Buyers who do not have a prime subscription or existing prime members who pay extra for 1-day shipping pay an extra amount at checkout.
The amount charged for shipping is added to your income as a shipping income.
Not enough information is available for this transaction.
Taxes Collected and Withheld
Tax amount deducted for promotional rebates
Tax collected by the seller on a COD Item Charge
Tax collected by the seller on a COD Order Charge
Tax collected by the seller on a COD Shipping Charge
Tax collected by the seller on a Gift wrap charge
Tax collected by the seller on a Shipping Charge
Tax withheld by Amazon on other miscellaneous charges
Tax withheld by Amazon on the Gift-wrap charge
Tax withheld by Amazon on the Principal
Tax withheld by Amazon on the Shipping Charge
Tax Collected at Source for Central Goods and Services Tax
Tax Collected at Source for Integrated Goods and Services Tax
Tax Collected at Source for State Goods and Services Tax
Tax Collected at Source for Union Territories Goods and Services Tax
All the above items are part of the tax collected by the seller.
This is not a charge or a fee.
It is simply the amount of tax that was collected on your behalf by the marketplace facilitator or by you when you sell via FBM. Your tax settings are adjusted based on what you enter into your product listings page.
The most common tax rate setting on a product is A_GEN_TAX.
This code will classify all your products at the general tax rate for your nexus.
With the new laws set into place after South Dakota v. Wayfair, business without a physical presence in a state with more than 200 transactions or $100,000 in-state sales collect and remit sales taxes on transactions in the state.
Most of this work is now handled by Amazon as it is not possible for small sellers using the Amazon platform to register a business in all 50 states and then submit quarterly or annual tax reports to the states.
The tax is collected for each of the items mentioned above by the marketplace facilitator and they remit the taxes for you.
This is simply a transaction line item showing you how much tax was collected on the sale or service and how much it will be remitted.
When a tax is withheld, it means that the amount has been withheld and not remitted for some reason.
Listed as WAREHOUSE_DAMAGE
Amazon will reimburse any warehouse damaged items automatically. You don’t need to issue or file a removal fee in most cases.
Amazon will most likely sell the items at a lower price or dispose of it.
If you find that an item is damaged at the warehouse, you can request an investigation for a reimbursement. When the reimbursement is done manually, it falls into the exception category.
Listed as WAREHOUSE_LOST
The new Amazon policy is Amazon will pay less reimbursement for damaged/lost goods in Amazon warehouse. If you have products that have been lost in their warehouse then Amazon will be the sole arbiter of how much they’re willing to reimburse the seller.
They do have a criteria as basis for the reimbursement. What we know is that one of them is average market price. Other than that Amazon will decide.
As mentioned above, Amazon is not above damaging inventory in their own warehouse or during delivery. I’m not giving Amazon a pass here, but this might be one of the most difficult problems to solve in an operation this huge.
Amazon does make mistakes (many considering how many packages fly around their warehouses) and lose inventory often.
If you know that you have missing inventory past 30 days then you can check the Amazon FBA reports page. If you have no idea, it’s still a good idea to visit that page and click on Inventory Health Report.
Following this page will help you get to the links to help pages and lead you to the reconcile page where you can file a reimbursement request to Amazon.
Free Spreadsheet of Charges and Fee
Want to see how all of these fees and charges come together to build an Amazon profit and loss spreadsheet?
If you are looking to track your Amazon Best Sellers Rank (BSR) or sales rank via Google Sheets, follow this tutorial.
This method is to track your own products that you sell and hold in your inventory.
This method does NOT work for tracking competitor products or for research. Only for products in your seller central account.
Load your Best Seller Rank now
If you want to follow along and start pulling your best sellers rank data for your products inside Google Sheets, read the getting started guide to start the right way and to get familiar with the setup and installation.
Once the addon is installed and you’ve entered your correct credentials then you can move on to preparing your spreadsheet.
The methods described in this article assumes you have:
If you are not familiar with what Amazon’s sales rank or BSR is, it is the rank of the product for the category.
You can see that this Amazon product ranking is 315 in the grocery and gourmet food category.
The grocery and gourmet food category is considered the “top” category because it is at the highest level.
This same product is ranked 5th under candy mints.
Candy mints is the “child” category as it is the detailed category and at the deepest position.
A single product is ranked for each category, but the one people are referring to when they talk about BSR is the rank of the topmost broad category.
I won’t get into the details fo what affects your Amazon ranking because there are many factors involved. But a good chunk of it depends on your recent sales, historical sales, and conversion rates in comparison to other products in the category.
I want Gorilla ROI to display the rank in the child category for only the US market
“r_cat” means I want to see the rank + category
The child category for this ASIN is “brushes” and the product is ranked 293 for “brushes”.
If I change the variable from “child” to “top”, it looks like this.
The product’s top level category is health and beauty with a sales rank of 22,634.
Here’s another example where you can use ranges to pull BSR in bulk. Even if you have 1000 SKUs, you can use this method.
=GORILLA_RANKING(A5:A15, "US", "child","r_full")
SKUs are entered into A5:A15.
Pulling rank for US marketplace
Pull the child category
Display using the full category tree
Notice that there is a SKU/ASIN that does not have a rank. It can mean a few things like it’s new, Amazon ranking algorithm has not picked it up yet or has been deleted from your account and is no longer supported.
How to get historical BSR for FBA
Another feature that we have is to pull a daily list of historical BSR (Best Sellers Rank) over any time period for a single or range of SKUs.
This method only works for a single marketplace at a time. So if you are trying to pull BSR for all EU marketplaces, it will not work. You have to define each marketplace at a time.
The result is an automatic table of the sales rank over the last 7 days for each of the SKUs.
With this one line, you can generate a table of BSR values in seconds
All that with convenient autogenerated headings, plus categories and exact dates and ranking numbers.
Using Gorilla ROI, you are given so much flexibility and freedom to get the data you want and use it any way you need.
Download a free BSR rank tracking spreadsheet
Now that you see the power and flexibility of using Gorilla ROI ranking and rankhist functions here’s a free Amazon rank tracking template you can download or copy straight to your Google sheets account.
The formulas and functions have been entered for you and after you’ve installed the Gorilla addon and activate it.
Our functions page is a living document. The number of functions and examples continue to grow to make it easy for you to quick import data related to your products in convenient ways.
Not an accounting or bookkeeping software
Unfortunately, there is no easy way of doing your taxes or bookkeeping. Manual reconciling is the best solution as a customer may return an item after 2 weeks, Amazon may reimburse lost packages, you mave have to request additional reimbursements.
Because there are so many different situations, automating the process will leave numbers lying in the cracks.
We provide detailed information like fees, charges, but our data does not go back into previous periods after the data has been synced. We only pull data on a going forward basis.
It can pull up-to-date data from the transaction reports, but it’s not meant to replace your accounting software or bookkeeping in any way.
Data points not offered by Amazon
If Amazon offers the data point, then we have it.
However, Amazon does not provide every data you see in seller central. A lot of the information in the detailed business reports are not included.
buy box %
These are just some of the data points that Amazon does not provide to their software providers like Gorilla ROI.
Fulfilled by Merchant
FBM data is not available as this data is controlled by the seller and not Amazon.
Because of the limited data you get for FBM products, we have made the decision to not provide it.
Gorilla ROI doesn’t support direct connection with vendor central. Only seller central is supported.
FC Transfer Data
FC transfer is not part of transfer. There is no API support nor is it listed in the documentation and there is still no word on FC processing being implemented from Amazon.
Gorilla ROI supports many functions in the Amazon API
Gorilla ROI does one thing best, pulling updated and accurate date from Amazon, but the integration with Google Sheets makes it versatile. It can accommodate power users and new users at the same time.
You don’t need to be a coder or a spreadsheet expert. All you need is some basic computer knowledge in tandem with your Amazon FBA knowledge. Let Gorilla ROI pull the data for you so you and your team can do the rest.
Free chrome addons or paid extensions require you to feed them data manually.
The software will clean up and arrange the data.
Next comes the biggest difference between software tools.
Any tool that offers research functionality like inventory lab or paid web app tools will make your data searchable and viewable. It’s open for anyone paying for access to find and analyze. This is called “one to many” access.
Software like Gorilla ROI and accounting tools (think Quickbooks) do not share your data with anyone. It is siloed to your account. Meaning we provide 1-1 connection access only. No one outside of you can see or find your data. Our service is not dependent on being fed data from other users for the rest of the user base to see and use.
If you sell yoyo’s, another seller will not be able to check your sales data on yoyo’s. Each seller can only access their own data. Everyone is walled off from each other.
Knowing this important if you are worried about other sellers finding your product.
When to use scouting software
The best time to use Amazon scouting software is to perform research on a product or to find a category or idea.
Think of it as a filter.
Scouting tools help you when you are at the top of the funnel with thousands of different products and categories to choose from.
It helps you narrow the list down.
The lower you get in the funnel, the less you need scouting software.
I won’t get into the details of how to use the tool because there are so many tutorials out there.
When not to use Amazon scouting software
I’ve used Jungle Scout before but canceled and ultimately chose AMZ Scout as my chrome extension.
With the majority of Amazon sellers using Jungle Scout, every time the tool is run on a particular product, the data gets entered into the Jungle scout servers.
You guessed it.
The more people there are using it, the more likely people will find it.
With AMZ Scout, it’s lesser to some extent.
The key is once you have identified your niche and product, stop using the scouting software. There is no need to continually feed the latest data into a database for tens of thousands of other people to find.
One day when AMZ Scout made an update to their tool called “saturation”, it really opened my eyes to the data they are seeing.
This is for a random skin routine product I came across. Looks like 4 other people found the exact same product and brand.
Here’s a look at bbq gloves. One of the most copied and private labeled products on Amazon.
Other tools have the same thing, but AMZ Scout now shows you how many other people are searching for it.
I assume the numbers are calculated based on a monthly tally or something. 39 people in the last 30 days looking for bbq gloves. Not a product I want to be in.
For this very reason, once you know your product, it is better to try and keep it under wraps by not using scouting tools.
You have the experience and judgement to figure out how much something sells based on the BSR.
The best way to use scouting software
Using these tools to keep tabs on your competitor is a good strategy.
If you are searching in such a way that will expose your product, then it’s not good.
The better way is to use the research tool on your competitors Amazon storefront.
We are the only software that allows you to take full control of your data.
Rather than locking down what you can and can’t do, you get the flexibility to use your data how you want it. Get direct and flexible access to your Amazon data without having to know code.
Gorilla ROI is a Google Sheets Add-on that allows you to connect and import data directly from your Amazon Seller Central account into Google Sheets.
Do things like bulk convert your ASIN’s to SKU’s or FNSKU, breakdown the fees and charges per sku, pull historical inventory level for projections, load the number of units sold by month, week, last year, last month and more.
Here’s a demo that I did where you can see it in action and how it works.
Full transcript and timeline is available at https://orangeklik.com/demo-gorilla-roi/
FBA spreadsheets are available for new users.
Free Amazon templates are also available. No sign ups, no emails. Just copy to your account and away you go.
With the new addition of Gorilla Agency and the new functions ChargeTotal, ChargeType, FeeTotal and FeeType, new templates are available.
Log in to your account at app.gorillaroi.com to copy them over to your account to start.
It doesn’t end there.
For PRO Spreadsheet buyers, we are adding business and operational documents that should get you excited. We’ve uploaded a bilingual NNN agreement as well as another document we get all of our suppliers to sign.
It has saved our necks on many occasion.
If you try to create your own NNN agreement and then get it reviewed and translated by a Chinese lawyer, it will be north of $1,000. But we are throwing in this document as part of the PRO package to sweeten the deal.