Sale!
toolsforfba_fba_fee_check

Amazon FBA Product Fee Checker

$24.99 $14.99

Description

The Amazon FBA Product Fee Checker makes it easy to see what FBA orders may have been charged fees incorrectly by Amazon. This can happen when the product’s size, weight or product category changes. Many times sellers are unaware they are being charged higher fees, and losing out on more potential revenue!  The fee checker will also check all of your current inventory for abnormal weights and dimensions, and compare older Fee Preview reports with current ones.

Features:

  • Quickly and easily identify which orders have abnormal fees
  • Flag items that have abnormal weights and dimensions
  • See changes with Fee Preview reports
  • Total of fees that you can recover
  • Easily import Amazon sales and Fee Preview data
  • Works with Excel 2007+ (including Mac)

 

Note: The FBA Product Fee Checker is better suited for sellers with more consistent inventory that sell multiple items over time. If you sell many items, but only a few individual items, and never that same item again, the spreadsheet will not work to its full potential. Likewise, if you sell a lot of only a handful of items, you probably already know when fees change, and the spreadsheet will not benefit you.

Additional information

Release Log

6/15/16 – v1.0 – Initial release

5/11/17 – v1.1
– Fixed error with importing data on SalesData and FeePreview Old
– Fixed data imports for Excel for Mac
– Optimized several things in VBA code to make calculations faster
– Decreased overall size of spreadsheet since columns in Sales Data that are not used are now excluded
– Changed FeePreview2 to FeePreviewOld
– Added "Remove Data" buttons to each data sheet
– Added highlighting to FeePreview Compare to easily see what has changed between the two FeePreviews

Reviews

There are no reviews yet.

Be the first to review “Amazon FBA Product Fee Checker”

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

FAQs

Amazon FBA Product Fee Checker

On the SalesData sheet the Referral % field calculates the referral percentage from column R, selling fees / column M, product sales. The FP Ref % is the referral percentage calculated from the FeePreview data. This is simply a reference to see if the referral percentages are different between the two. This will only happen when the item was moved to a product group where the referral fees are different. Keep in mind that the percentage can be higher than the product group referral percentage when there is a minimum referral fee (usually $1). Ref. Dif? will say “Yes” when the difference between the two if greater than 5%.  This result is not reported on the Order Summary report.

To calculate what belongs on Fee Check Summary, we take the standard deviation of all length + girth and weights fields for all items. These calculations are displayed on the far right of FeePreview. Any items that have greater than 3 times (3z) the standard deviation of both of these goes into the Fee Check Summary.

These items should be physically measured and weighed to check the accuracy of what Amazon has listed. Take a picture or two to prove to Amazon seller support if, in fact, your measurements or weight are different.

Recoverable Fees are calculated based on the total difference between FBA fees and FeePreview when Problem = Yes.  This could actually be considerably more if you were charged incorrect fees, but the item was not in the FeePreview data to verify the fees against our Threshold calculations.

Problem = Yes: FBA fees were more than both the Threshold and FeePreview. There was definitely something different with orders marked yes, and they should be investivated.

Problem = Maybe: FBA fees for this order were more than the Threshold OR FeePreview. This may be because of an incorrect fee, and we didn’t have a whole lot of data to go on, or because of a FBA fee change. There isn’t necessarily an issue, but you should check to be sure.

Problem = Decreased: FBA fees were less than what is listed in FeePreview. This is probably because the fees were recently adjusted for that item due to a weight or dimension change. That means the fees could currently be incorrect and this tool did not pick up on it because it thinks those fees are normal.  Orders with a quantity more than 1 are filtered. Regardless, you should investigate why the FBA fees are less.

This is the “adjusted FBA fees”. Column S ‘fba fees’ contains shipping and gift wrap totals. These are subtracted from the adjusted fba fee. Multi-channel fulfillment orders are also excluded since the fees are not consistent with regular fba fees. These orders have an Order-ID beginning with ‘S’. We account for orders that received a promotional discount as well. In other words if you gave out a coupon code, that amount is subtracted from the fee total.

Also, we’ve tried to take into account orders with multiple quantities. The adjusted fee divides by the quantity as to make the fee per item rather by order. Any change in fees will have to be greater than the calculated threshold to trigger an issue regardless of how many items are in an order.

The threshold figure you see on the Order Summary and Sales Summary is calculated by taking the average of all FBA fees for an item + the standard deviation of those fees. If there the standard deviation on the Sales Summary sheet is $0.00 for an item, that means the fees were always the same in the sales data (they didn’t deviate). You can see a summary of the averages and standard deviations for each item on the Sales Summary sheet.

This report is to compare older Fee Preview reports to the newer one in FeePreview. The results of the differences are outlined in FeePreview Compare. Simply download and load an older report as you did in the steps for FeePreview.

The FBA fees from FeePreview2 are used if, and only if, FBA fees cannot be found in FeePreview for the particular sku.  If the item is not found in either report you will see the error “Not in FP/FP2

For SalesData:

  1. Go to Reports > Payments > Date Range Reports (tab) > Generate a report. or click here
  2. Under “Select report type” select Transaction
  3. Select Custom for the reporting range and choose the dates that you would like to analyze, then click Generate
  4. After the report is generated, download it to a known folder on your computer
  5. Open the SalesData sheet and click “Import/Update Sales Data” on the top left. Select the report you just downloaded and click OK

The SalesData sheet will handle a MAX of 10,000 records. If Excel is crashing, try reducing the amount of sales you are importing. Please be patient.

For FeePreview:

  1. Go to Reports > Fulfillment > Payments > Fee Preview. or click here
  2. Click Request Download to get the latest data. Download the report to a known folder on your computer when it is complete.
  3. Go to the FeePreview sheet and click “Import/Update Fee Preview” on the top left. Select the report you just downloaded and click OK

The lite version of the Reimbursement Checker, Inventory Value Calculator, and Tax Summary spreadsheets will work with LibreOffice or OpenOffice, with the exception that you’ll have to manually paste in the reports that are downloaded from Amazon.

Unfortunately, the macros and pivot tables that are used in all other spreadsheets will not run properly in LibreOffice, OpenOffice, or Google Sheets.

You may also like…

  • toolsforfba_amazon_reimb1

    Amazon FBA Refund & Lost Inventory Reimbursement Checker

    Sale! $14.99$49.99
    Select options
  • toolsforfba_amazon_fba_dashboard

    The Ultimate Amazon FBA Sales Spreadsheet v2

    Sale! $149.99 $99.99
    Add to cart
  • toolsforfba_inventory_value

    Amazon FBA Inventory Value Calculator

    $0.00
    Add to cart
  • toolsforfba_amazon_fba_tax_summary

    Amazon FBA Tax Summary by State & Quarter

    Sale! $9.99 $4.99
    Add to cart