How To Calculate Gross Revenue

Last Updated on August 16, 2023 by Jake Sheridan

In this tutorial, you will learn how to calculate gross revenue in Google Sheets.

How To Calculate Gross Revenue in Google Sheets

Gross revenue is an important metric for any business. It is the total amount of money a company brings in from sales before any other costs or expenses have been deducted.

Gross revenue is typically regarded as a helpfulindicator of a business’s financial health and can be used to compare the performance of a company over different periods of time.

We can find the total gross revenue by multiplying the Total Sales Volume by the Sales Price Per Unit. For example, if a company sells 100 units of a product at a price of $25, the gross revenue from the product is 100 * $25 = $2500.

Do note, however, that high sales revenue does not always equate to profit margins. Various factors, such as the cost of goods sold and sales returns, are omitted from this value.

In this guide, we will show you how to calculate gross revenue in a Google Sheets spreadsheet.

How To Find The Gross Revenue of Your Business in Google Sheets

Here’s how to find the gross revenue of your business in Google Sheets.

Step 1

First, we’ll need to indicate the total sales volume of all items in the given time period. We will also need the sales price per unit of each item sold.

In our simple example above, we will calculate the gross revenue after selling three different items. Our table includes the sales volume in units as well as the price each unit was sold. The sales volume data captures all orders made in a single month.

Step 2

We can find the sales revenue of a single item by multiplying the item’s sales volume by the unit price.

Step 3

We’ll use Google Sheets’ AutoFill feature to find the sales revenue for each of the items in our table.

Step 4

Lastly, we’ll use the SUM function to find the total of all sales revenue values to get the Gross Revenue of our business for that specific month.


This guide should be everything you need to calculate the gross revenue in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.