Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product

GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product

THIS FUNCTION IS NOW REPLACED WITH FINANCES()

Sample Usage

=GORILLA_CHARGETOTAL(“This Month”)

or

=GORILLA_CHARGETOTAL(“2019-04”)
=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”, “shipment”)

or

=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”)
=GORILLA_CHARGETOTAL(“This Year”,“default”, , , “shipment”)
=GORILLA_CHARGETOTAL(“2019Q2”,“US”,“B038434K3”, , “refund”)
=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, , , “ADJUSTMENT”)
=GORILLA_CHARGETOTAL(“2109Q1”,“DE”, , , “OTHER”)

Empty variables are accepted if you want to skip over the optional ones.

=GORILLA_CHARGETOTAL(“2019Q1”, “US”, “B00YD545CC”, “All”)
=GORILLA_CHARGETOTAL(“2019-05”, “US”, “B00YD545CC”, “All”)

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.

Sample Spreadsheet

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

Syntax Description

GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product 1

Description:

Get the financials breakdown of the sales and charges related to the sale of a product. Supports getting the total account financials 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_CHARGETOTAL(period, [marketplace], [sku], [chargeType], [event])

for Gorilla Agency, the syntax is

GORILLA_CHARGETOTAL(sellerID, period, [marketplace], [sku], [chargeType], [event])

Examples:

=GORILLA_CHARGETOTAL(“This Month”) or =GORILLA_CHARGETOTAL(“2019-04”)
=GORILLA_CHARGETOTAL(“SELLER37432”, “2019Q1”, “US”, “B00YD545CC”, “All”)
=GORILLA_CHARGETOTAL(“SELLER37432”, “2019-05”, “US”, “B00YD545CC”, “All”)

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

=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”, “shipment”)

or

=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”)

Will return the total ShippingTax related charges. sales and charges for the last 30 days. For the full list of periods, and the different types of charges you can narrow it down to, see the table after the examples.

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

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

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

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

=GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, , , “ADJUSTMENT”)

Returns all adjustment related charges for the last 30 days across ALL marketplaces. Sku’s have been left out which will default to all sku’s

=GORILLA_CHARGETOTAL(“2109Q1”,“DE”, , , “OTHER”)

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

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

=GORILLA_CHARGETOTAL(“SELLER384k3”, “This Month”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “2019-04”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,“ALL”,“ShippingTax”, “shipment”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,“ALL”,“ShippingTax”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “2019Q2”,“US”,“B038434K3”, “refund”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “Last 30 Days”,“ALL”, “ADJUSTMENT”)
=GORILLA_CHARGETOTAL(“SELLER384k3”, “2109Q1”,“DE”, “OTHER”)
=GORILLA_CHARGETOTAL(“SELLER37432”, “2019Q1”, “US”, “B00YD545CC”, “All”)
=GORILLA_CHARGETOTAL(“SELLER37432”, “2019-05”, “US”, “B00YD545CC”, “All”)

GORILLA_CHARGETOTAL Attributes

Period Attribute:

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

Event Attribute:

  • Shipment
  • CouponPayment
  • Refund
  • Adjustment
  • GuaranteeClaim
  • Other
  • Chargeback

ChargeType Attribute:

To get the names of all charge types in the spreadsheet, enter

=GORILLA_CHARGETYPE()

or for Agency,

=GORILLA_CHARGETYPE(“SELLERID”)

See GORILLA_CHARGETYPE().

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?