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 syntax is
GORILLA_FEETOTAL(sellerID, period, [marketplace], [sku], [fee], [event])
=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.
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.
Returns all other fee that are not grouped under shipment, refund, adjustment. Returns values for Q1 of 2019 for German marketplace.
for Gorilla Agency.the syntax is
=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”)
|Today||This month||Last 12 Months|
|Yesterday||This quarter||Last 7 Days Week Ago|
|Same day last week||This year||Last 7 Days Year Ago|
|Same day last month||This Year-to-Last-Month||Last 30 Days Month Ago|
|Same day last year||Last Week||Last 30 Days Year Ago|
|Last 7 Days||Last Month||Last Week Year Ago|
|Last 14 Days||Last Quarter||Last Month Year Ago|
|Last 30 Days||Last Year||YYYY-MM (change format to text)|
|This week||Last 60 Days||YYYYQ1… YYYYQ4|
To get the names of all chargetype in the spreadsheet, enter =gorilla_feetype()
|Amazon Imaging fee||FBA Returns Processing Fee-Pick & Pack|
|Cash on Delivery Chargeback||FBA Returns Processing Fee-Weight Handling|
|Closing Fees||FBA Taping Fee|
|Commission||FBA transportation fee|
|Coupon clip fee||FBA Unplanned Prep Service Fees|
|Coupon redemption fee||FBA Weight Based Fee|
|Cross-Border Fulfillment Fee||Fresh Inbound Transportation Fee|
|Easy Ship Fee||Get Paid Faster Fee|
|EPSO Chargeback fee||Gift Wrap Charge-Back Fee|
|EPSO Cross-Border fee||Gift Wrap Commission|
|EPSO Payment Authorization fee||Global Inbound Transportation Fee|
|EPSO Payment Settle fee||High-volume listing fee|
|FBA Amazon-Partnered Carrier Shipment Fee/Inbound Transportation Charge||Monthly subscription fee|
|FBA Fee for cash on delivery||Per-item fees for Individual Sellers|
|FBA Fulfillment Fees||Purchase of Rented Books|
|FBA Fulfillment Fees||Referral Fees|
|FBA Inbound Shipment Carton Level Info Fee||Refund Administration Fee|
|FBA Inbound Transportation Program Fee||Rental Book Service Fee|
|FBA Inventory Disposals||Rental Extensions|
|FBA Inventory Placement Service Fees||Review Enrollment Fee|
|FBA Inventory Removals||Shipping Charge-Back Fee|
|FBA Inventory Storage Fee||Shipping HB Fee|
|FBA Label Service Fee||SSO Fulfillment Fee|
|FBA Long-Term Storage Fees||Tax Calculation Services Fees|
|FBA Multi-Channel Fulfillment Weight Handling||Unit 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|
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.