In this article:

Free Sales Tracker for Google Sheets (2024 Update)

May 8, 2024

Free Google Sheets Sales Tracker Template

Feel free to make a copy of this sales tracker and customize it as you see fit. To do this, go to File > Make a copy.

free google sheets sales tracker template

How to Make a Simple Sales Tracker in Google Sheets

Follow the steps below to make a simple sales tracker in Google Sheets.

Step 1: Set Up Columns for Your Data

Your sales tracker will need columns. Each column will hold a specific kind of information. Here's a simple setup to start with:

A1: "Date"

B1: "Invoice Number"

C1: "Customer Name"

D1: "Product Sold"

E1: "Quantity"

F1: "Unit Price"

G1: "Total Sales" (This column will be calculated automatically based on Quantity and Unit Price)

sales tracker google sheets

Step 2: Enter Your Sales Data

In Row 2, start entering your data corresponding to the columns. For example, under Date, enter the date of the sale, and under Customer Name, type in the name of the customer.

Step 3: Calculate the Total Sale

Click on the first cell under the Total Sales column (should be G2 if you followed the steps above).

Type in = to start a formula, followed by the cell number for Quantity Sold (for example, E2), an asterisk * for multiplication, and the cell number for Sale Price (for example, F2). It should look like this: =E2*F2.

Press Enter. The total sale for that entry will be calculated.

google sheets sales template

To apply this formula to other rows, click on the cell (G2) and drag the small dot at the bottom right corner down to fill other cells in the Total Sale column.

google sheets sales tracker template
google sheets sales tracker template free

Step 4: Make Your Data Look Nice

Highlight the row with your column titles (Row 1). Click on the B icon in the toolbar to make the text bold. This helps differentiate your column titles from the data.

sales tracking spreadsheet google sheets

Click on the borders icon to add borders to your cells. Feel free to customize your spreadsheet even further as you like. 

free sales tracker in google sheets

For the Unit Price and Total Sales columns, you can format the data as currency. Simply highlight both columns and go to Format > Number > Currency

track sales in google sheets

Below is what the formatted data looks like:

free sales tracker template on google sheets

Step 5: Keep Your Sales Tracker Updated

Remember to regularly add new sales data to keep your tracker up to date. This will help you monitor your sales over time.

We hope that this article has helped you and given you a better understanding of how to make and use our sales tracker in Google Sheets. If you enjoyed this article, you might also like our articles on how to use the Google Sheets REPT function and how to make a simple travel itinerary in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->