Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. 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

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")

Syntax Description

GORILLA_FEETOTAL() – Get financials breakdown of all fees related to sale of product 1
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.

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 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("This Year","default",,, "shipment")

Returns all shipment related fees for this year to day, default marketplace and for all charges. 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 charges 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",,"all", "shipment")
=GORILLA_FEETOTAL("SELLER384k3", "2019Q2", "US","B038434K3", "ALL", "refund")
=GORILLA_FEETOTAL("SELLER384k3", "Last 30 Days", "ALL",, "ALL", "servicefee")
=GORILLA_FEETOTAL("SELLER384k3", "last year", "US",,,"other")
=GORILLA_FEETOTAL("SELLER37432", "2019Q1", "US", "B00YD545CC", ,"SHIPMENT")
=GORILLA_FEETOTAL("SELLER37432", "2019-05", "US", "B00YD545CC", "COMMISSION")

GORILLA_FEETOTAL Attributes

Period Attribute:

TodayThis monthLast 12 Months
YesterdayThis quarterLast 7 Days Week Ago
Same day last weekThis yearLast 7 Days Year Ago
Same day last monthThis Year-to-Last-MonthLast 30 Days Month Ago
Same day last yearLast WeekLast 30 Days Year Ago
Last 7 DaysLast MonthLast Week Year Ago
Last 14 DaysLast QuarterLast Month Year Ago
Last 30 DaysLast YearYYYY-MM (change format to text)
This weekLast 60 DaysYYYYQ1… YYYYQ4
MaxYYYY

FeeType Attribute:
To get the names of all chargetype in the spreadsheet, enter =gorilla_feetype()

 

Amazon Imaging feeFBA Returns Processing Fee-Pick & Pack
Cash on Delivery ChargebackFBA Returns Processing Fee-Weight Handling
Closing FeesFBA Taping Fee
CommissionFBA transportation fee
Coupon clip feeFBA Unplanned Prep Service Fees
Coupon redemption feeFBA Weight Based Fee
Cross-Border Fulfillment FeeFresh Inbound Transportation Fee
Easy Ship FeeGet Paid Faster Fee
EPSO Chargeback feeGift Wrap Charge-Back Fee
EPSO Cross-Border feeGift Wrap Commission
EPSO Payment Authorization feeGlobal Inbound Transportation Fee
EPSO Payment Settle feeHigh-volume listing fee
FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation ChargeMonthly subscription fee
FBA Fee for cash on deliveryPer-item fees for Individual Sellers
FBA Fulfillment FeesPurchase of Rented Books
FBA Fulfillment FeesReferral Fees
FBA Inbound Shipment Carton Level Info FeeRefund Administration Fee
FBA Inbound Transportation Program FeeRental Book Service Fee
FBA Inventory DisposalsRental Extensions
FBA Inventory Placement Service FeesReview Enrollment Fee
FBA Inventory RemovalsShipping Charge-Back Fee
FBA Inventory Storage FeeShipping HB Fee
FBA Label Service FeeSSO Fulfillment Fee
FBA Long-Term Storage FeesTax Calculation Services Fees
FBA Multi-Channel Fulfillment Weight HandlingUnit Fulfillment Fee
FBA Per Order Fulfillment Fee
FBA Prep Service Fees (Bubble Wrap)
FBA Prep Service Fees (Labeling)
FBA Prep Service Fees-Adult-Bagging (black or opaque)
FBA Returns Processing Fee-Order Handling

Event Attribute:

Shipment
Refund
GuaranteeClaim
Chargeback
CouponPayment
Adjustment
ServiceFee
Other

 

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?