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.
Follow the steps below to make a simple sales tracker in Google Sheets.
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)
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.
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.
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.
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.
Click on the borders icon to add borders to your cells. Feel free to customize your spreadsheet even further as you like.
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.
Below is what the formatted data looks like:
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.
