FBA ALLSTARS

How to Get $1000+ from Amazon Reimbursements BS – ALL72

03.07.2016 - By Matt WardPlay

Download our free app to listen on your phone

Download on the App StoreGet it on Google Play

Get thousands back that Amazon stole from you, without telling you. Make your money back now! Amazon refunds and reimbursement for tons of quick cash. Tune In.

How to Earn More Money

* How to get back like $1000 from Amazon

* When Amazon is supposed to refund you money…and they don’t

* Why Amazon is ripping off sellers

* Set them up as sheets in a single Google spreadsheet

* Where my 400 lost products disappeared too

Here is the information, copy/pasted from a genius Reddit guy:

1.Criteria for reimbursement:

* Order was not returned to FBA within 45 days

* You have not already been reimbursed by Amazon

* Only open cases with 5-10 order ID’s max

* Do not send seller support a giant list of order ID’s

2.Download reports

* “RefundMasterList” Reports > Payments > Transaction View > Filter view by: Refund Reports (download gets truncated after 600 transactions, make sure to download multiple times using various date ranges)

* “ReturnsToFBA” Reports > Fulfillment > Customer Concessions > Returns

* “Reimbursements” Reports > Fulfillment > Reimbursements

* “AllOrders” Reports > Payments > Date Range Report

3.Create tabs and headers

* See pic here

4.Copy and paste Column B from “RefundMasterList” into Column B of “AutoOutput”. Highlight column, Data > Remove Duplicates.

5.Enter formulas

* A2 =INDEX(RefundMasterList!$A:$A, MATCH(AutoOutput!B2, RefundMasterList!$B:$B, 0))

* C2 =IF(ISERROR(MATCH(B2, ReturnsToFBA!$B:$B, 0)), “No”, “Yes”)

* D2 =IF(ISERROR(MATCH(B2, Reimbursements!$D:$D, 0)), “No”, “Yes”)

* E2 =INDEX(AllOrders!$I:$I, MATCH(AutoOutput!B2, AllOrders!$D:$D, 0))

* F2 =IF((TODAY()-A2)>45,”Yes”,”No”)

* G2 =SUMIFS(RefundMasterList!$G:$G, RefundMasterList!$B:$B, AutoOutput!B2, RefundMasterList!$E:$E, “Product charges”)

* H2 =IF(C2=”Yes”, “No”, IF(D2=”Yes”, “No”, IF(E2=”Seller”, “No”, IF(F2=”No”, “No”, “Yes”))))

6.FAQ/tips

* DO NOT SORT DATA after completing. It will mess up all the formulas. First copy all the information, right click, Paste Options, Values (V). Then you can sort the data as you please

* Why is the date column just a bunch of numbers? Highlight the column, right click it, format cells as: date

* Some orders aren’t reimbursable even though the file says it is reimbursable? Generally this worksheet finds 100% of potentially reimbursable transactions, but some false positives may be included. Check manually if the order ID is valid for reimbursement prior to opening a case with seller support

* Column F is returning a #N/A value: Here is how to fix: If the date in column A is less than 45 days ago, enter “No” in column F. If column A is more than 45 days ago, enter “Yes” is column F

* How do I put the formulas in the rest of the spreadsheet? On the cell containing the formula, double click the bottom right box in the cell, the formula will auto-fill the rest of the sheet.

Want more? Subscribe TODAY and Leave a Review!

Get thousands back that Amazon stole from you, without telling you. Make your money back now! Amazon refunds and reimbursement for tons of quick cash. Tune In.

How to Earn More Money

* <a href="https://www.reddit.com/r/FulfillmentByAmazon/comments/400oty/retur...

More episodes from FBA ALLSTARS