OP-005 · Version 1.0.0

Sales Tracker: Excel sales and margin tracker

Sales log with margin, seller targets, channels and receivables in Excel, no macros.

Sales Tracker dashboard with sales, margin, targets, alerts and charts from the demo data
Real screenshot of the dashboard with the demo data.

Sales Tracker is an Excel workbook to log your business's sales and know how much you sell, how much you earn and how much you are owed, without installing software.

Keep a catalog with price and cost and log each sale. The workbook calculates each line's net sale and margin, counts documents, measures each seller's target achievement and adds up what is pending collection.

The dashboard shows the period's indicators and the reports break them down by month, category, seller and channel.

Features

Who it is for

Shops, distributors, entrepreneurs and small sales teams that want to know their sales and margins without a sales system.

What it does not include

It does not issue receipts or invoices, track inventory or manage customers like a CRM. It uses the current catalog cost.

Editions

FREE (demo)PRO
Workbook with sample data✓✓
Empty template for your business—✓
Capacity60 products / 400 sales lines1,000 products / 5,000 sales lines
PDF manual and quick start—✓
Minor updates within the same major version—✓

What you get

Requirements

Excel 2016 or later, Microsoft 365 or LibreOffice Calc 7.6+. Windows, macOS or Linux.

Questions about this product

Does it issue receipts or invoices?

No. It logs sales for analysis; tax documents are issued in your usual system.

How many products and sales does it hold?

The PRO edition holds 1,000 products and 5,000 sales lines per workbook. The demo holds 60 products and 400 lines.

How is margin calculated?

Net sale minus quantity times the catalog unit cost.

Does it track inventory?

No. For inventory there is Inventory Pro.

Version history

1.0.0 · 2026-11-16