FINANCES() is the upgraded version of CHARGETOTAL().
Sample Usage
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=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 supports getting the total account financials or narrowing them down by SKU.
IMPORTANT: This is NOT an accounting tool.
Amazon reports via the API are inconsistent and subject to change regularly. Use this to identify areas of your business and spot anything that needs attention. It can help with tax returns but should NOT be used solely for tax and financial statements.
A bookkeeper is required to match your numbers to the nearest cent.
Syntax:
GORILLA_CHARGETOTAL(sellerID, period, [marketplace], [sku], [chargeType], [event])
Examples:
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_CHARGETOTAL("TOY STORE", "This Month")
This will return all the charges for this month.
=GORILLA_CHARGETOTAL("TOY STORE", "This Year", , "shipment”)
Returns all shipment-related fees for this year to today, default marketplace, and for all fees. No sku has been specified so it will pull the total of all SKUs.
=GORILLA_CHARGETOTAL("TOY STORE", "THIS YEAR", "US", "B038434K3", "refund")
Returns all refund-related charges for this year, in the US marketplace, for ASIN B038434K3.