Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SALESTAX() – Get total sales and taxes collected by Amazon or owed by the seller

GORILLA_SALESTAX() – Get total sales and taxes collected by Amazon or owed by the seller

Sample Usage

=GORILLA_SALESTAX(“CUSTOM”, “UK”, “CITY”, “2020-01-01”, “2020-01-15”, “FALSE”)

Syntax description

gorilla sales tax

Get total sales and taxes collected by Amazon Marketplace Facilitator owed by the seller. Only the period attribute is required. Other attributes are optional.

GORILLA_SALESTAX(period, [marketplace], [grouping], [start_date], [end_date], [header])

for Gorilla AGENCY, the syntax is

GORILLA_SALESTAX(sellerID, period, [marketplace], [grouping], [start_date], [end_date], [header])

Predefined period to get sales or custom to specify dates. See full list of predefined periods below.  

OPTIONAL – Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER. 

OPTIONAL – The grouping level for results. Select to group the totals by city or by state. Default is total by City.

OPTIONAL – Starting date to get sales from when period is custom.

OPTIONAL – Ending date to get sales from when period is custom.

OPTIONAL – Include a header line in the results.
Possible values: TRUE/FALSE. Default: TRUE


Use ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.


The easiest way to use this function. Define the period to get the total sales and taxes collected by city and state.


Loads the sales and the taxes collected for the period “this month” in the UK marketplace and the results are totaled by state.

=GORILLA_SALESTAX(“CUSTOM”, “UK”, “CITY”, “2020-01-01”, “2020-01-15”, “FALSE”)

Get sales tax data over a custom period. The results are based on the UK marketplace with results totaled by city between Jan 1, 2020 and Jan 15, 2020.

The “FALSE” attribute means the header of the table is not generated.

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

=GORILLA_SALESTAX(“SELLER382”, “CUSTOM”, “UK”, “CITY”, “2020-01-01”, “2020-01-15”, “FALSE”)


Period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (change format to text)


What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?