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", "RELEASED")=GORILLA_FINANCES("TOY STORE", "Last Year", A1:A13)=GORILLA_FINANCES("TOY STORE", A1:A5, A2:A12, "Adjustment-Sales", "US")
Syntax Description
Description:
Retrieve the sales, charges, and fees.
Syntax:
GORILLA_FINANCES(Seller ID, period, type, [event], [marketplace], [sku], [start_date], [end_date], [status])
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).
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 |
|
|
type – REQUIRED:
List of Fees/Charges to return. Data is grouped by fee/charge type. Can be a string or an array. Has to be valid fee/charge names (See function GORILLA_FEETYPE and GORILLA_CHARGETYPE to get a list of valid fees/charges until 2025, and GORILLA_FINANCESTYPE for 2026 onward). If the type array is vertical, the period has to be horizontal or a string.
event – OPTIONAL:
Filter finance results for a specific event type. Default is set to retrieve the sum of all values.
Valid event values are:
Shipment
Refund
GuaranteeClaim
Chargeback
CouponPayment
Adjustment
ServiceFee
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”.
status – OPTIONAL:
Filter by transaction status. Default is set to ALL. Valid inputs: 'ALL', 'RELEASED', 'DEFERRED'.
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", "ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Base", "shipment", "US", "SKU12345", "2026-01-01", "2026-03-16", "Released")The full formula in action.
Retrieves the ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Base amount from shipment events for SKU SKU12345 in the US market, for transactions dated from 2026-01-01 through 2026-03-16, with a transaction status of Released.
=GORILLA_FINANCES("TOY STORE", "Last Year", A1:A71)where A1:A13 is
Adjustment-Expenses
Adjustment-Expenses-ReserveDebit-ReserveDebit
Adjustment-Sales
Adjustment-Sales-ReserveCredit
DebtRecovery-DebtPayment
FBAInventoryReimbursement-Expenses
FBAInventoryReimbursement-Expenses-FBAReversedReimbursement-COMPENSATED_CLAWBACK
FBAInventoryReimbursement-Expenses-FBAReversedReimbursement-MISSING_FROM_INBOUND_CLAWBACK
FBAInventoryReimbursement-Sales
FBAInventoryReimbursement-Sales-FBAInventoryReimbursement
MiscellaneousLedgerAdjustment-Expenses
MiscellaneousLedgerAdjustment-Sales-Other
ProductAdsPayment-Expenses-AdvertisingFee
ProductAdsPayment-Sales
Refund-AmazonFees-Commission-Base
Refund-AmazonFees-RefundCommission-Base
Refund-AmazonFees-ShippingChargeback-Base
Refund-Other-RestockingDeductionPrincipal
Refund-ProductCharges-OurPricePrincipal
Refund-PromoRebates-OurPriceDiscount
Refund-PromoRebates-ShippingDiscount
Refund-Shipping-ShippingPrincipal
Refund-Tax-MarketplaceFacilitatorTax-Principal
Refund-Tax-MarketplaceFacilitatorTax-Shipping
Refund-Tax-OurPriceTax
Refund-Tax-ShippingTax
RemovalShipment-Expenses-AmazonFees-LiquidationProcessingFee
RemovalShipment-Expenses-AmazonFees-LiquidationReferralFee
RemovalShipment-Sales-RecommerceLiquidation
Retrocharge-Retrocharge-BaseTax
Retrocharge-Retrocharge-ShippingTax
Retrocharge-Tax-MarketplaceFacilitatorTax-Principal
Retrocharge-Tax-MarketplaceFacilitatorTax-Shipping
ServiceFee-AmazonFees-CouponParticipationFeeRollup-CouponParticipationFee-Base
ServiceFee-AmazonFees-CouponPerformanceFeeRollup-CouponPerformanceFee-Base
ServiceFee-AmazonFees-DealParticipationFeeRollup-DealParticipationFee-Base
ServiceFee-AmazonFees-DealPerformanceFeeRollup-DealPerformanceFee-Base
ServiceFee-AmazonFees-FBADisposalFee-Base
ServiceFee-AmazonFees-FBAInboundConvenienceFee-Base
ServiceFee-AmazonFees-FBAInboundTransportationFee-Base
ServiceFee-AmazonFees-FBAInternationalInboundFreightFee-Base
ServiceFee-AmazonFees-FBAInternationalInboundFreightTaxAndDuty-Base
ServiceFee-AmazonFees-FBALongTermStorageFee-Base
ServiceFee-AmazonFees-FBAStorageFee-Base
ServiceFee-AmazonFees-Subscription-Base
ServiceFee-AmazonFees-Subscription-Tax
ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Base
ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Promo
ServiceFee-FBAFees-AmazonUpstreamStorageTransportationFee-Base
ServiceFee-FBAFees-AmazonUpstreamStorageTransportationFee-Promo
ServiceFee-FBAFees-AWDStorageFees-STARStorageFee-Base
ServiceFee-FBAFees-AWDStorageFees-STARStorageFee-Promo
ServiceFee-FBAFees-FBADisposalFee-Base
ServiceFee-FBAFees-InboundConvenienceCharge-FBAInboundConvenienceFee-Base
ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationFee-Base
ServiceFee-FBAFees-LongTermStorageFee-FBALongTermStorageFee-Base
ServiceFee-FBAFees-StorageBillingFee-FBAStorageFee-Base
Shipment-AmazonFees-Commission-Base
Shipment-AmazonFees-FBAPerUnitFulfillmentFee-Base
Shipment-AmazonFees-FBAPerUnitFulfillmentFee-Promo
Shipment-AmazonFees-ShippingChargeback-Base
Shipment-ProductCharges-OurPricePrincipal
Shipment-PromoRebates-OurPriceDiscount
Shipment-PromoRebates-ShippingDiscount
Shipment-Shipping-ShippingPrincipal
Shipment-Tax-MarketplaceFacilitatorTax-Principal
Shipment-Tax-MarketplaceFacilitatorTax-Shipping
Shipment-Tax-MarketplaceFacilitatorVAT-Principal
Shipment-Tax-MarketplaceFacilitatorVAT-Shipping
Shipment-Tax-OurPriceTax
Shipment-Tax-ShippingTax
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
2026-01
2026-02
2026-03
2026-04
2026-05
where A1:A12 is
ServiceFee-AmazonFees-CouponParticipationFeeRollup-CouponParticipationFee-Base
ServiceFee-AmazonFees-CouponPerformanceFeeRollup-CouponPerformanceFee-Base
ServiceFee-AmazonFees-DealParticipationFeeRollup-DealParticipationFee-Base
ServiceFee-AmazonFees-DealPerformanceFeeRollup-DealPerformanceFee-Base
ServiceFee-AmazonFees-FBADisposalFee-Base
ServiceFee-AmazonFees-FBAInboundConvenienceFee-Base
ServiceFee-AmazonFees-FBAInboundTransportationFee-Base
ServiceFee-AmazonFees-FBAInternationalInboundFreightFee-Base
ServiceFee-AmazonFees-FBAInternationalInboundFreightTaxAndDuty-Base
ServiceFee-AmazonFees-FBALongTermStorageFee-Base
ServiceFee-AmazonFees-FBAStorageFee-Base
ServiceFee-AmazonFees-Subscription-Base
This formula will pull data for the 5 monthly time periods as well as the adjustment transactions for the US market.
Sample Output Screenshot:
