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_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

Sample Usage =GORILLA_CHARGETYPE(“TOY STORE”) =GORILLA_CHARGETYPE(“TOY STORE”, “US”, “TAX”, “Column”, “No”, “Shipment”) Syntax Description Description: Returns a list of the line item names for all “charges” to your Amazon account when it is related to sales. Names include charges related to both income and expense. Syntax: GORILLA_CHARGETYPE(Seller ID, [marketplace], [filter], [direction], [full_list], [event]) Seller ID –…

GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product

THIS FUNCTION IS NOW REPLACED WITH FINANCES() Sample Usage =GORILLA_CHARGETOTAL(“This Month”) or =GORILLA_CHARGETOTAL(“2019-04”) =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”, “shipment”) or =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”) =GORILLA_CHARGETOTAL(“This Year”,“default”, , , “shipment”) =GORILLA_CHARGETOTAL(“2019Q2”,“US”,“B038434K3”, , “refund”) =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, , , “ADJUSTMENT”) =GORILLA_CHARGETOTAL(“2109Q1”,“DE”, , , “OTHER”) Empty variables are accepted if you want to skip over the optional ones. =GORILLA_CHARGETOTAL(“2019Q1”,…