Google Sheets Functions

  2. Home
  4. Docs
  6. Google Sheets Functions
  8. GORILLA_FEETOTAL() – Get financials breakdown of all fees related to sale of product

GORILLA_FEETOTAL() – Get financials breakdown of all fees related to sale of product

THIS FUNCTION IS NOW REPLACED WITH FINANCES()

Sample Usage

=GORILLA_FEETOTAL(“This Month”) or =GORILLA_FEETOTAL(“2019-04”)
=GORILLA_FEETOTAL(“This Year”,“Default”, “shipment”)
=GORILLA_FEETOTAL(“2019Q2”,“US”,“B038434K3”, “refund”)
=GORILLA_FEETOTAL(“Last 30 Days”,“US”,“servicefee”)
=GORILLA_FEETOTAL(“last year”,“US”,“other”)

Sample Spreadsheet

PREVIEW LINK: PREVIEW LINK HERE DOWNLOAD LINK: SPREADSHEET LINK HERE

Syntax Description

Description:

Get the financials breakdown of all fees related to the sale of a product. Supports getting the total account numbers or narrowing 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(period, [marketplace], [sku], [fee], [event])

For Gorilla Agency, the formulas will start with the seller ID:

GORILLA_FEETOTAL(sellerID, period, [marketplace], [sku], [fee], [event])

Examples:

=GORILLA_FEETOTAL(“This Month”) or =GORILLA_FEETOTAL(“2019-04”)

Simplest formula allowed to return all sales and fees for the selected period. This will return an unsorted list of all the categories. For a more organized list, see the following examples**.**

=GORILLA_FEETOTAL(“This Year”,“default”, “shipment”)

Returns all shipment related fees for this year to day, default marketplace and for all fees. No sku has been specified and so it will pull for total SKU’s.

=GORILLA_FEETOTAL(“2019Q2”,“US”,“B038434K3”, “refund”)

Returns all refund related fees for Q2 of 2019, in the US marketplace, for ASIN B038434K3.

=GORILLA_FEETOTAL(“Last 30 Days”,“US”,“servicefee”)

Returns all adjustment related fees for the last 30 days across US marketplace. Sku’s have been left out which will default to all sku’s.

=GORILLA_FEETOTAL(“last year”,“US”,“other”)

Returns all other fee that are not grouped under shipment, refund, adjustment. Returns values for Q1 of 2019 for German marketplace.

=GORILLA_FEETOTAL(“2019Q1”, “US”, “B00YD545CC”, ,“SHIPMENT”)
=GORILLA_FEETOTAL(“2019-05”, “US”, “B00YD545CC”, “COMMISSION”)

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

for Gorilla Agency, the syntax is

=GORILLA_FEETOTAL(“SELLER384k3”, “2019-04”,“all”,)
=GORILLA_FEETOTAL(“SELLER384k3”, “This Year”,“default”, “shipment”)
=GORILLA_FEETOTAL(“SELLER384k3”, “2019Q2”, “US”,“B038434K3”, , “refund”)
=GORILLA_FEETOTAL(“SELLER384k3”, “Last 30 Days”, , , , “servicefee”)
=GORILLA_FEETOTAL(“SELLER384k3”, “last year”, “US”,“other”)
=GORILLA_FEETOTAL(“SELLER37432”, “2019Q1”, “US”, “B00YD545CC”, ,“SHIPMENT”)
=GORILLA_FEETOTAL(“SELLER37432”, “2019-05”, “US”, “B00YD545CC”, “COMMISSION”)

How can we help?