GORILLA_STORAGEFEES() – Get your Amazon storage fees report

Sample Usage =GORILLA_STORAGEFEES(“TOY STORE”, “2022-08”, A1:A260) =GORILLA_STORAGEFEES(“TOY STORE”, “Last 90 Days”,”B00H9D0D4G”) =GORILLA_STORAGEFEES(“TOY STORE”, “last month”, A1:A1000, “oversize”, “US”) Syntax Description Description: Get monthly storage fees report and details by ASIN. Syntax: GORILLA_STORAGEFEES(Seller ID, period, asin, [product_size_tier], [fc_location], [dangerous_goods_storage_type], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account….

GORILLA_FINANCES() – Get sales, charges and fees for any period using payments report data

Download sample FINANCES spreadsheet with formulas ready to go. Sample Usage =GORILLA_FINANCES(“TOY STORE”, “Custom”, “Selling price (Principal)”, “shipment”, “US”, “SKU12345”, “2021-01-01”, “2021-03-16”) =GORILLA_FINANCES(“TOY STORE”, “Last Year”, A1:A13) =GORILLA_FINANCES(“TOY STORE”, A1:A5, A2:A12, “adjustment”, “US”) Syntax Description Description: Get inventory movement status of a product such as how many is in stock, transfer or inbound. Syntax: GORILLA_FINANCES(Seller…

GORILLA_FEESESTIMATE() – Get estimated fees for product

Sample Usage =GORILLA_FEESESTIMATE(“TOY STORE”, D2) =GORILLA_FEESESTIMATE(“TOY STORE”, A2:C10) =GORILLA_FEESESTIMATE(“TOY STORE”, “738-JDUY-32F”, “default”, “fullwithheader”) Syntax Description Description: Get the estimated fees associated with the product. (Not the actual settlement product fees and charges to your accounts). Syntax: GORILLA_FEESESTIMATE(Seller ID, sku, [marketplace], [returnStyle], [fulfillment]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_FEETYPE() – Return list of line item names associated as fees to Amazon account

Sample Usage =GORILLA_FEETYPE(“TOY STORE”) =GORILLA_FEETYPE(“TOY STORE”, “US”, “GIFT” , “Column”, “No”, “Shipment”) Syntax Description Description: Return a list of the line item names associated as fees with to the Amazon account. All variables are optional. Syntax: GORILLA_FEETYPE(Seller ID, [marketplace], [filter_fee], [direction], [full_list], [event]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in…