FINANCES() is the upgraded version of FEETOTAL().
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_FEETOTAL("TOY STORE", "This Month")
=GORILLA_FEETOTAL("TOY STORE", "This Month", , "shipment”)
=GORILLA_FEETOTAL("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 all fees related to the sale of a product. Supports getting the total account numbers or narrowing them down by SKU.
IMPORTANT: This is NOT an accounting tool.
Amazon reports via the API are inconsistent and subject to change on a regular basis. 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_FEETOTAL(sellerID, period, [marketplace], [sku], [fee], [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_FEETOTAL("TOY STORE", "This Month")
This will return all the fees for this month.
=GORILLA_FEETOTAL("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_FEETOTAL("TOY STORE", "Last Week", "US", "B038434K3", "refund")
Returns all refund-related fees for Last Week, in the US marketplace, for ASIN B038434K3.