# Sales Tracker Spreadsheet Template, Free

Source: https://nerix.ai/templates/sales-tracker-sheet

Log every sale and see monthly sales against your target and the year total.

Before you send it

The tracker adds up what you enter, so a missing sale is a missing amount. It counts the sale date, not the date money arrives, and it does not handle tax, discounts or returns.

## Fill it in and preview

You are signed in. Fill it in your workspace and it is kept as a document you can send, share and have signed. [Open in your workspace](https://app.nerix.ai/documents/templates/sales-tracker-sheet)

### 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%** |

[Open this spreadsheet in nerix](https://app.nerix.ai/documents/templates/sales-tracker-sheet) A preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Sales and marketing

## What this template is for

A sales tracker spreadsheet: log each sale with customer, product and price, and see monthly sales against your target, the average sale and the year total.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. [See all Sales and marketing templates](https://nerix.ai/templates/sales-marketing) [All free Excel and spreadsheet templates](https://nerix.ai/templates/spreadsheets)

Sales and marketing

## What you fill in

The form asks for 4 details. The document fills itself in as you type.

- ### Business For example: Riverside Bike Shop
- ### Year For example: 2027
- ### Monthly sales target optional Leave empty for no target. For example: 12000
- ### Sales One row for each sale.

Sales and marketing

## What is inside

The parts of this document, in order.

- 1 A spreadsheet to record sales and watch them against a target. Log each sale with its date, customer, product, salesp...

Templates

## How it works

- 01 ### Open Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.
- 02 ### Change Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.
- 03 ### Download Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

### Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

[Adapt it with nerix](https://nerix.ai/try?template=sales-tracker-sheet)

### Was this template helpful?

Sales and marketing

## Questions people ask

### What details does this template ask for?

The form asks for 4 details, starting with Business, Year, Sales. 1 more are optional.

### Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

### Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

### What should I check before I use this template?

The tracker adds up what you enter, so a missing sale is a missing amount. It counts the sale date, not the date money arrives, and it does not handle tax, discounts or returns.

### Are these marketing templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

### Do I need a customer's permission for a case study?

Yes. Get the customer's written approval of the text, the quotes and any logo before you publish. The case study template has a field for it.

### Can nerix improve the wording?

Yes. Open the template in the nerix chat and ask for a shorter, warmer or more formal version, then check every fact before you publish.

Templates

## More in Sales and marketing

- [New Bakery and cake order form Take custom cake and bakery orders with size, flavour, message and date. Sales and marketing Form](https://nerix.ai/templates/bakery-order-form)
- [Brand guidelines summary Put your brand rules on one page: voice, logo, colours, fonts, images and what not to do. Sales and marketing](https://nerix.ai/templates/brand-guidelines-summary)
- [Campaign performance report Report how a marketing campaign did against its goals, what it cost and what to do next. Sales and marketing](https://nerix.ai/templates/campaign-performance-report)
- [New Cancellation request form Let customers cancel a booking, plan or membership in one clear step. Sales and marketing Form](https://nerix.ai/templates/cancellation-form)
- [New Catering order form Take catering orders with guest count, menu, dietary needs and delivery. Sales and marketing Form](https://nerix.ai/templates/catering-order-form)
- [New Company presentation Introduce your company in nine slides with speaker notes, ready to download as PowerPoint or PDF. Sales and marketing Presentation](https://nerix.ai/templates/company-presentation)

[See all Sales and marketing templates](https://nerix.ai/templates/sales-marketing)

Templates

## More kinds of documents

Every category has its own page, so you can see all of its templates at once.

## Use it in nerix

### Use it in nerix

- [Templates](https://nerix.ai/product/templates)
- [Long documents](https://nerix.ai/product/long-documents)

### Learn more

- [How to Make a Document From a Template](https://nerix.ai/help/make-a-document-from-a-template)
- [Sales and marketing](https://nerix.ai/templates/sales-marketing)
