Profit loss formula to build your P&L statement
The new ProfitLoss() formula function is available for you to use.
Here’s the page for a deeper understanding and guide on how to use this Profit Loss formula.
As always, we update documentation consistently and in multiple locations to make it easy to find.
- Official page of all the functions we support
- Google Docs version
- Website documentation for easier navigation
- On any Google sheet > menu > addons > Gorilla > 2.See Supported Functions and examples
Spreadsheet formula to get profit loss data
We’ve added another free template for you to create a profit and loss statement spreadsheet, but it’s not as automated as I wanted it to be.
Thus the GORILLA_PROFITLOSS() is born.
This simple example will automatically load a consolidated table like the following:
Rather than looking up all the individual transactions and compiling it yourself, it is done automatically so that you can pull up this data by simply changing the time period you want to look up.
=GORILLA_PROFITLOSS("THIS YEAR") =GORILLA_PROFITLOSS("2020-01") =GORILLA_PROFITLOSS("2019Q4") =GORILLA_PROFITLOSS("THIS MONTH") and more
You can see how easy your life becomes when you can verify your profit and loss on the fly.
Try doing this manually – It is a nightmare.
More Profit Loss Examples
You can also build a profit and loss statement per SKU.
=GORILLA_PROFITLOSS("THIS YEAR", "US", "SKUNAME721")
When you define a SKU, the profit loss table will not include Amazon Reimbursements, Income-Other and Amazon lending.
This is because certain transactions are NOT applicable to a sku. The transaction is matched to your seller account, not SKU.
Think about storage costs. If you look at your transaction data, storage costs are always associated with your seller account.
Amazon does not charge you per SKU. It is a single dollar amount each month.
You can also see the details of what is rolled up into each of the categories.
- Amazon Reimbursements
- Shipping Income
- Amazon Lending
- Amazon Fees
To look up a category, use the expanded formula like:
=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"AMAZON FEES", "YES")
By entering “AMAZON FEES” and “YES” at the end, it will list all the Amazon seller fees one by one and how much was transacted for each item.
=GORILLA_PROFITLOSS("THIS YEAR", "US", ,"COGS", "YES")
Same thing here where I can drill down on what is rolled up into “COGS” by looking it up in the formula.
There you have it.
To see other functions and examples, visit the functions page for all the features we support.
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.