Template 1: The Basic Tracker
The Basic Tracker is a single-sheet workbook with 12 essential columns.
It includes Date, Supplier, Product, SKU, Quantity, Unit Cost, Shipping, Total Cost, Target Price, Estimated Profit, Actual Sale Price, and Final Profit.
There are no complex formulas beyond simple multiplication and subtraction.
The layout is clean, prints on one page, and fits comfortably on a laptop screen.
This template is perfect if you are just starting out, processing fewer than 50 orders per month, and want a no-frills system that just works.
The header row is frozen, the date column auto-formats, and the profit column uses conditional coloring so you instantly see which orders are worth pursuing.