Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales

Sample Usage

=GORILLA_CHARGETYPE()
=GORILLA_CHARGETYPE("US", , "column", "yes")

Syntax Description

GORILLA_CHARGETYPE() – Returns list of line item names for all “charges” to Amazon account when related to sales 1

Description:

Returns a list of the line item names for all “charges” to your Amazon account when it is related to sales. Names include charges related to both income and expense.

Syntax:

GORILLA_CHARGETYPE([marketplace], [filter], [direction], [full_list])

for Gorilla Agency, the syntax is

GORILLA_CHARGETYPE(sellerID, [marketplace], [filter], [direction], [full_list])

SKU

SKU or ASIN of the product. Can be an array of strings like {“SKU12345″,”ASIN12345”} or a string.

MARKETPLACE

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

FILTER

OPTIONAL – enter a string to filter for a particular list of charges.

DIRECTION

OPTIONAL – Default is “column” if nothing is entered. It will return the list in a column. Use “row” to get the result in a horizontal row.

FULL_LIST

OPTIONAL – Default is “no” so that it only displays the charges associated with your account. To see the FULL list of charges that Amazon takes, enter “yes”. This will list transactions that are also not part of your account.

List of Charge types by Amazon

For the latest list, enter =GORILLA_CHARGETYPE(, , , “yes”).

For an explanation of each item, read the Amazon seller fees article.

Amount given to the buyer to compensate for shipping the item back to Amazon
CanceledButPickedUpReimbursement
Charge that Amazon charges the buyer when returning a product
COD charge for an order
COD charge for an order item
COD refund
COD revenue
COMPENSATED_CLAWBACK
Compensation for return shipping when a buyer receives the wrong item and requests a free replacement
CRETURN_WRONG_ITEM
CS_ERROR_ITEMS
DebtPayment
DebtPaymentLevel2Failure
Export duty that is charged when Amazon ships an item to an international destination
FBA Liquidation
Fee collected for certain payment methods
FeeAdjustment
FREE_REPLACEMENT_REFUND_ITEMS
Generic bad debt deduction
Gift wrap charge
GiftWrap
GiftWrapTax
GoodWill (Amount given to a buyer as a gesture of)
INBOUND_CARRIER_DAMAGE
INCORRECT_FEES_ITEMS
Loan Advance
Loan Payment
LoanRefund
LostOrDamagedReimbursement
LowValueGoods-Other
LowValueGoods-Principal
LowValueGoods-Shipping
LowValueGoodsTax-Other
LowValueGoodsTax-Principal
LowValueGoodsTax-Shipping
MarketplaceFacilitatorTax-Other
MarketplaceFacilitatorTax-Principal
MarketplaceFacilitatorTax-RestockingFee
MarketplaceFacilitatorTax-Shipping
MarketplaceFacilitatorVAT-Principal
MarketplaceFacilitatorVAT-Shipping
MISSING_FROM_INBOUND
MISSING_FROM_INBOUND_CLAWBACK
MULTICHANNEL_ORDER_DAMAGED
MULTICHANNEL_ORDER_LOST
PAYMENT_RETRACTION_ITEMS
PointsAdjusted
PREPFEE_REFUND
Product Ads Payment Principal Charge
Product Ads Payment Principal Refund
Product Ads Payment Tax Charge
Product Ads Payment Tax Refund
Promo Rebate
Promotional discount for an order item
ReimbursementClawback
REMOVAL_ORDER_DAMAGED
REMOVAL_ORDER_LOST
REVERSAL_REIMBURSEMENT
SAFE-T claim amount for the item
SAFETReimbursementCharge
Selling price (Principal)
Shipping charge
Shipping charges for a COD order
SI_CRETURN_MERCHANT_REIMBURSEMENT
Tax amount deducted for promotional rebates
Tax Collected at Source for Central Goods and Services Tax
Tax Collected at Source for Integrated Goods and Services Tax
Tax Collected at Source for State Goods and Services Tax
Tax Collected at Source for Union Territories Goods and Services Tax
Tax collected by the seller
Tax collected by the seller on a COD Item Charge
Tax collected by the seller on a COD Order Charge
Tax collected by the seller on a COD Shipping Charge
Tax collected by the seller on a Gift wrap charge
Tax collected by the seller on a Shipping Charge
Tax withheld by Amazon on other miscellaneous charges
Tax withheld by Amazon on the Gift-wrap charge
Tax withheld by Amazon on the Principal
Tax withheld by Amazon on the Shipping Charge
Value of Amazon Points deducted from the refund if the buyer does not have enough Amazon Points
WAREHOUSE_DAMAGE
WAREHOUSE_DAMAGE_EXCEPTION
WAREHOUSE_LOST
WAREHOUSE_LOST_MANUAL

Examples:

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.

=GORILLA_CHARGETYPE()

If no attributes are entered, it will list all the line items categorized as charges related to the Amazon account.

=GORILLA_CHARGETYPE("US", "refund", "Column", "No")

Lists all charge types for the US marketplace, searching for any charges that start with “refund”, displayed in a column and only displaying the charges associated with the Amazon account. If “YES” is used, it will return all Amazon chargetype names.

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

=GORILLA_CHARGETYPE("SELLER349d3")
=GORILLA_CHARGETYPE("SELLER349d3", "US", "Marketplace", "Column", "No")

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?