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

FINANCES() is the upgraded version of CHARGETOTAL(). Sample Usage =GORILLA_CHARGETOTAL(“TOY STORE”, “This Month”) =GORILLA_CHARGETOTAL(“TOY STORE”, “This Month”, , “shipment”) =GORILLA_CHARGETOTAL(“TOY STORE”, “This Month”, “US”, “B038434K3”, “refund”) Sample Spreadsheet PREVIEW LINK: PREVIEW LINK HERE DOWNLOAD LINK: SPREADSHEET LINK HERE Syntax Description Description: Get the financial breakdown of sales and charges related to a product’s sale. It…