Sheet template
Sales tracker spreadsheet
This sales tracker spreadsheet records each sale on its own row: the date, the product, how many, the price and the customer. Each sale's total works itself out, and a summary beside it adds up the sales and units for every product, with a chart.
- Free
- Private
- Works offline
What’s inside
- Columns for date, product, quantity, price, total and customer, with room for 49 sales.
- Product picked from a dropdown, so each product is always spelled the same way.
- A summary of sales and units for each product, and a total row.
- A column chart of sales by product, in your own currency.
Tips for using it
- Replace Product A, B and C with what you sell, in Data, Data validation, and in the summary.
- Start a new tab each month, and keep the daily sales note for cash in hand at closing.
- Share it with your staff in a team, and protect the price column so only you can change it.
How to start
- Select Use this templateMemlow opens in your browser with a new sheet made from it, in Memlow Sheets. There is nothing to install.
- Fill it inType over the samples. Formulas, colours and charts update as you go, and everything is saved on your device, offline too.
- Make it yoursAdd rows, columns or tabs, change a formula, or share the sheet in a notebook. In the Android app, the same template is in Sheets, under Start a new sheet.
Questions
How does the sales tracker add up each product?
The summary uses SUMIF to add the totals and quantities of every row with that product.
Can my staff add sales from their phones?
Yes. Share the sheet in a notebook or a team; each change shows up for everyone within about a second, encrypted end to end.
Is this a point-of-sale system?
No. It's a sheet you fill in. It doesn't print receipts or connect to a card machine.
Start with a sheet, keep it private.
Memlow Sheets is free, with no AI. Your sheets stay on your device, or in your own Google Drive, encrypted.
