Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_PROFITLOSS() – Get detailed financials to build profit loss statement for the account or by SKU/ASIN

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

Sample Usage

=GORILLA_PROFITLOSS("2020")
=GORILLA_PROFITLOSS("THIS YEAR", "US")
=GORILLA_PROFITLOSS(A2,B2,"MYSKU")
=GORILLA_PROFITLOSS("THIS YEAR", "US", , "Income-Other")
=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

Syntax description

orilla profitloss function

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

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

GORILLA_PROFITLOSS(period, [marketplace], [sku], [category], [details])

for Gorilla AGENCY, the syntax is

GORILLA_PROFITLOSS(sellerID, period, [marketplace], [sku], [category], [details])

period

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

marketplace

OPTIONAL – Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.

sku

SKU or ASIN of the product. Only accepts ONE SKU or ASIN input. Does not work with multiple SKUs or ranges like other formulas.

category

OPTIONAL – specify the line item to get the total value for that single category

  • Sales
  • Discounts/Promotions
  • Amazon Reimbursements
  • Shipping Income
  • Income-Other
  • Amazon Lending
  • COGS
  • Amazon Fees
  • AdvertisingTax

 details

OPTIONAL – defaults to “no”:

  • Yes = Will list all the transactions associated with the category
  • No = Will only show the total value of the category

Examples:

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google blocking your account for 24 hrs due to overloading their resources.  

=GORILLA_PROFITLOSS(“2020”)

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

  • Sales – $xxx
  • Discounts/Promotions – $xxx
  • Amazon Reimbursements – $xxx
  • Shipping Income – $xxx
  • Income-Other – $xxx
  • Amazon Lending – $xxx
  • COGS – $xxx
  • Amazon Fees – $xxx
  • AdvertisingTax – $xxx
=GORILLA_PROFITLOSS("THIS YEAR", "US")

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

=GORILLA_PROFITLOSS(A2,B2,"MYSKU")

Using cells A1 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.

=GORILLA_PROFITLOSS("THIS YEAR", "US", , "Income-Other")

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

=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"Amazon 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 “Amazon Fees”.

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

2020Q1, 2019Q4 etc

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

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_PROFITLOSS(sellerID, "2020")
=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US")
=GORILLA_PROFITLOSS(sellerID, A2,B2,"MYSKU")
=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US", , "Income-Other")
=GORILLA_PROFITLOSS(sellerID, "LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

GORILLA_PROFITLOSS Attributes
period Attributes:

  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This week
  • This month
  • This quarter
  • This year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM (change format to text)
  • YYYYQ1… YYYYQ4

category Attributes:

  • Sales
  • Discounts/Promotions
  • Amazon Reimbursements
  • Shipping Income
  • Income-Other
  • Amazon Lending
  • COGS
  • Amazon Fees
  • Advertising
  • Tax

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.

How can we help?