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 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
- Net sale and margin calculated on every line.
- Automatic catalog price or special price.
- Seller targets and achievement percentage.
- Documents, average ticket and receivables.
- Reports by month, category, seller and channel with charts.
- Alerts for sales below cost and low margins.
- Includes demo, PDF manual and quick start. No macros.
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 | — | ✓ |
| Capacity | 60 products / 400 sales lines | 1,000 products / 5,000 sales lines |
| PDF manual and quick start | — | ✓ |
| Minor updates within the same major version | — | ✓ |
What you get
- CHANGELOG.txt
- LICENSE.txt
- Quick_Start_EN.pdf
- README.txt
- Sales_Tracker_Demo_EN.xlsx
- Sales_Tracker_EN.xlsx
- User_Manual_EN.pdf
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
- First release: catalog with price and cost, sales log, margin, seller targets, channels, receivables, dashboard and reports.