Sales tracker
A spreadsheet to record sales and watch them against a target. Log each sale with its date, customer, product, salesperson, quantity and unit price. The sheet works out the amount of every sale, then the Summary sheet shows total sales, the number of sales, the average and biggest sale, sales for each month against your monthly target and the share of the yearly target reached, with a chart. Download it as Excel, OpenDocument, PDF or CSV.
Sales
Sales tracker
Add one row for every sale. The amount of each sale and the Summary sheet follow.
Business Riverside Bike Shop
Year 2027
Monthly sales target 12,000.00
| Date | Customer | Product or service | Salesperson | Quantity | Unit price | Amount |
|---|---|---|---|---|---|---|
| 2027-01-05 | Hollis Cycles | City bike, model C2 | Anya | 3 | 540.00 | 1,620.00 |
| 2027-01-12 | Neil Fraser | Annual service plan | Tariq | 1 | 120.00 | 120.00 |
| 2027-01-20 | Greenway School | Helmets, box of 20 | Anya | 2 | 310.00 | 620.00 |
| 2027-02-03 | Chiara Rossi | Electric bike, model E5 | Tariq | 1 | 2,490.00 | 2,490.00 |
| 2027-02-17 | Hollis Cycles | City bike, model C2 | Anya | 4 | 540.00 | 2,160.00 |
| 2027-03-08 | Omar Nasser | Repair and parts | Tariq | 1 | 185.00 | 185.00 |
Summary
Summary
Total sales 7,195.00
Number of sales 6
Average sale 1,199.17
Biggest sale 2,490.00
Target for the year 144,000.00
Share of the yearly target 5.0%
| Month | Sales | Target | Share of target |
|---|---|---|---|
| 2027-01-01 | 2,360.00 | 12,000.00 | 20% |
| 2027-02-01 | 4,650.00 | 12,000.00 | 39% |
| 2027-03-01 | 185.00 | 12,000.00 | 2% |
| 2027-04-01 | 0.00 | 12,000.00 | 0% |
| 2027-05-01 | 0.00 | 12,000.00 | 0% |
| 2027-06-01 | 0.00 | 12,000.00 | 0% |
| 2027-07-01 | 0.00 | 12,000.00 | 0% |
| 2027-08-01 | 0.00 | 12,000.00 | 0% |
| 2027-09-01 | 0.00 | 12,000.00 | 0% |
| 2027-10-01 | 0.00 | 12,000.00 | 0% |
| 2027-11-01 | 0.00 | 12,000.00 | 0% |
| 2027-12-01 | 0.00 | 12,000.00 | 0% |
| Year | 7,195.00 | 144,000.00 | 5% |