Skip to content

Sales tracker

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

Sales tracker template, first page

Fill it in and preview

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 nerixA 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 All free Excel and spreadsheet templates

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 targetoptional

    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. 1A spreadsheet to record sales and watch them against a target. Log each sale with its date, customer, product, salesp...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 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

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.