Skip to main content

GORILLA_PROFITLOSS() – Get detailed financials to build a profit and loss statement for the account or by SKU/ASIN

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_PROFITLOSS("TOY STORE", "2026")
=GORILLA_PROFITLOSS("TOY STORE", "THIS YEAR", "US")
=GORILLA_PROFITLOSS("TOY STORE", A2,B2,"MYSKU")
=GORILLA_PROFITLOSS("TOY STORE", "THIS YEAR", "US", , "FBA product sales")
=GORILLA_PROFITLOSS("TOY STORE", "LAST 30 DAYS", "FR", ,"FBA selling fees", "YES")

Syntax description

Description:

Gets the financial data to build a profit and loss statement for your Amazon FBA account or by SKU/ASIN.

Automatically generates a prebuilt table, or pull detailed profit and expense line items to build your own statements.

Syntax:

GORILLA_PROFITLOSS(Seller ID, period, [marketplace], [sku], [category], [details], [start_date], [end_date], [transactionStatus)

Seller ID – REQUIRED:
Enter the seller ID or nickname you entered in your Gorilla account.

period – REQUIRED:
Predefined periods and any custom date frames to get the rank history. See full list of predefined periods below.

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

marketplace – OPTIONAL:
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc.

sku – OPTIONAL:
SKU or ASIN to filter the results. Only empty (for seller’s total) or 1 SKU or ASIN can be provided when details is set to “YES” or “NO”.

A range (vertical or horizontal array) can be used when details are ‘totals_only’ to generate a matrix of data.

category – OPTIONAL:
Specify the line item to get the total value for a single category. Can be a range of values like A1:A100. Default is set to retrieve all categories/data points.

'STORAGE FEES' for individual ASIN or SKU uses estimated storage fees with a 1 month delay.

List of Categories

  • FBA product sales (non-FBA)

  • FBA product sale refunds (non-FBA)

  • FBA product sales

  • FBA product sale refunds

  • FBA inventory credit

  • FBA liquidation proceeds

  • FBA liquidation proceeds adjustments

  • Shipping credits

  • Shipping credit refunds

  • Gift wrap credit

  • Gift wrap credit refunds

  • Promotional rebates

  • Promotional rebate refunds

  • A-to-z Guarantee claims

  • Chargebacks

  • Amazon Shipping Reimbursement Adjustments

  • SAFE-T reimbursement

  • Other Income

  • Seller fulfilled selling fees

  • FBA selling fees

  • Selling fee refunds

  • FBA transaction fees

  • FBA transaction fee refunds

  • Other transaction fees

  • Other transaction fee refunds

  • FBA inventory and inbound services fees

  • Shipping label purchases

  • Shipping label refunds

  • Carrier shipping label adjustments

  • Service fees

  • Refund administration fees

  • Adjustments

  • Cost of Advertising

  • Refund for Advertiser

  • Liquidations fees

  • Receivables Deductions

  • Amazon Shipping Charge Adjustments

  • Other Expenses

  • Taxes and regulatory fee collected

  • Taxes and regulatory fee refunded

  • Amazon Obligated Tax and Regulatory Fee Withheld

  • Other Taxes

  • DebtRecovery

details – OPTIONAL:
Return a detailed breakdown of each category. Default is set to 'NO'.

  • NO = Will only show the total value of the category

  • YES = will return a detailed breakdown

  • TOTALS_ONLY = will display the totals only

start_date – OPTIONAL:

Starting date to get profit/losses from when the 'Period' is set to 'CUSTOM'.

end_date – OPTIONAL:

Ending date to get profit/losses from when the 'Period' is set to 'CUSTOM'.

transactionStatus:

ilter results by transaction status (2026 and later data only). The default value is ALL.
Valid Inputs are: 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_PROFITLOSS("TOY STORE", "2020")

Will automatically generate a condensed and summarized profit and loss table in the form of:

=GORILLA_PROFITLOSS("TOY STORE", "THIS YEAR", "US")

Will generate a table like the example above for the US marketplace profit and loss only.

=GORILLA_PROFITLOSS("TOY STORE", A2, B2, "MYSKU")

Using cells A2 and B2 to point to the period and the marketplace. Creates the P&L based on the SKU “mysku”. When a SKU is entered, not all transactions are available like storage costs as it is applied to your account and not the SKU level.

=GORILLA_PROFITLOSS("TOY STORE", "THIS YEAR", "US", , "Service fees")

Returns the total value only for the line item “Service fees”. You can specify a category to get single values rather than generate the full table each time.

=GORILLA_PROFITLOSS("TOY STORE", "LAST 30 DAYS", "FR", ,"FBA selling fees", "YES")

List all the transactions that make up the category you specify. In this example, it will list all the expenses that are rolled up inside “FBA selling fees”.

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period, for example 2020Q1, 2019Q4 etc

To get monthly data, use the format YYYY-MM as the preset period for example2020-04, 2021-07 etc

Did this answer your question?