Vape & Smoke Shop Profit Tracker Excel for your products — products and pricing, a daily sales log, stock and inventory with low-stock flags, and a monthly P and L dashboard. Know what every product actually earns, what…
About this template
Vape & Smoke Shop Profit Tracker Excel for your products — products and pricing, a daily sales log, stock and inventory with low-stock flags, and a monthly P and L dashboard. Know what every product actually earns, what is actually in stock — and whether the month actually made money.
$39
Excel & Google Sheets template — instant download on Etsy
Products and Pricing — product, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit, for 12 products.
Daily Sales Log — date, product, quantity, unit price, unit cost, amount, cost of goods, and channel, for 27 sales in October 2026. Unit price and unit cost are pulled from sheet 1 by formula.
Stock and Inventory — opening stock, stock received, units sold by formula, shrinkage and write-offs, closing stock, reorder point, stock value, and a low-stock status flag by formula, for 12 products.
Monthly P and L — revenue, cost of goods, rent, staff, utilities, marketing, insurance, supplies and other expenses by month, Jan-Dec, with net profit and margin. Revenue and cost of goods are formulas from the Sales Log.
Dashboard — total revenue, units, transactions, average sale, cost of goods, gross profit and margin, expenses, net profit and margin, stock value, low-stock and out-of-stock counts, shrinkage cost, dead stock value, best and weakest products, revenue by product, costs by category, and units by product.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Vape & Smoke Shop Profit Tracker track?
The Vape & Smoke Shop Profit Tracker tracks Products and Pricing; Daily Sales Log; Stock and Inventory; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 products; 2240 units sold in 27 logged sales; total revenue 33,410; cost of goods 15,735; gross profit 17,675; gross margin 52.9 percent
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.