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 |