GORILLA_FINANCES() – Get sales, charges and fees for any period using payments report data
Download sample FINANCES spreadsheet with formulas ready to go.
Sample Usage
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_FINANCES("TOY STORE", "Custom", "Selling price (Principal)", "shipment", "US", "SKU12345", "2021-01-01", "2021-03-16")=GORILLA_FINANCES("TOY STORE", "Last Year", A1:A13)=GORILLA_FINANCES("TOY STORE", A1:A5, A2:A12, "adjustment", "US")Syntax Description
Description:
Get inventory movement status of a product such as how many is in stock, transfer or inbound.
Syntax:
GORILLA_FINANCES(Seller ID, period, type, [event], [marketplace], [sku], [start_date], [end_date])
Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.
period – REQUIRED
Predefined period to get sales. See full list of predefined periods below.
Can be one value or an array of values. If the period array is vertical (on the left as a column), then the “type” parameter must be a horizontal array or string (as a header up the top).
type – REQUIRED
List of Charges/Fees to get the values for. Data is grouped by fee/charge type. Can be a string or an array. Has to be valid fee names (See function GORILLA_FEETYPE() and GORILLA_CHARGETYPE() to get a list of them). If type array is vertical, period has to be horizontal or a string.
event – OPTIONAL
Filter finance results for a specific event type.
Valid event values are:
Shipment
Refund
GuaranteeClaim
Chargeback
CouponPayment
Adjustment
Other
marketplace – OPTIONAL
Marketplace filter. Use All for all marketplaces and Default for the seller default. Other valid values are country codes US, IT, etc.
sku – OPTIONAL
SKU or ASIN of the product. Only one SKU or ASIN is supported. This function does NOT support arrays for SKU or ASIN input.
start_date – OPTIONAL
Starting date to get data when period attribute is “custom”.
end_date – OPTIONAL
Ending date to get data when period attribute is “custom”.
Examples:
🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.
=GORILLA_FINANCES("TOY STORE", "Custom", "Selling price (Principal)", "shipment", "US", "SKU12345", "2021-01-01", "2021-03-16")The full formula in action.
Gets the “Selling Price (Principal)” from the “shipment” event in the US market, for SKU1234 between 2021-01-01 and 2021-03-16.
=GORILLA_FINANCES("TOY STORE", "Last Year", A1:A13)where A1:A13 is
Selling price (Principal)
Selling price (Principal non-FBA)
Shipping charge
Gift wrap charge
Tax collected by the seller
Tax collected by the seller on a Shipping Charge
Tax collected by the seller on a Gift wrap charge
Seller & Amazon Promos
Tax withheld by Amazon on the Principal
Tax withheld by Amazon on the Shipping Charge
Tax withheld by Amazon on other miscellaneous charges
LowValueGoodsTax-Principal
LowValueGoodsTax-Shipping
Displays the consolidated numbers for the transaction “type” listed above for “last year”.
=GORILLA_FINANCES("TOY STORE", A1:A5, A2:A12, "adjustment", "US")where A1:A5 is
2021-01
2021-02
2021-03
2021-04
2021-05
where A1:A12 is
WAREHOUSE_DAMAGE
WAREHOUSE_LOST
REVERSAL_REIMBURSEMENT
MISSING_FROM_INBOUND
CS_ERROR_ITEMS
FREE_REPLACEMENT_REFUND_ITEMS
COMPENSATED_CLAWBACK
WAREHOUSE_LOST_MANUAL
MISSING_FROM_INBOUND_CLAWBACK
INCORRECT_FEES_ITEMS
WAREHOUSE_DAMAGE_EXCEPTION
MULTICHANNEL_ORDER_LOST
This formula will pull data for the 5 monthly time periods as well as the adjustment transactions for the US market.
Period Attributes:
Today | This month | Last 3 Months |
Yesterday | This quarter | Last 12 Months |
Same day last week | This year | Last 7 Days Week Ago |
Same day last month | This Year-to-Last-Month | Last 7 Days Year Ago |
Same day last year | Last Week | Last 30 Days Month Ago |
Last 7 Days | Last Month | Last 30 Days Year Ago |
Last 14 Days | Last Quarter | Last Week Year Ago |
Last 30 Days | Last Year | Last Month Year Ago |
Last 90 Days | Last 60 Days | YYYY-MM (change format to text) |
This week | YYYY | YYYYQ1… YYYYQ4 |
Custom |