Thrift Store 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…
About this template
Thrift Store 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 28 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.
Quick profit check — Thrift Store Profit Tracker
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 Thrift Store Profit Tracker track?
The Thrift Store 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; 2243 units sold in 28 logged sales; total revenue 25,490; cost of goods 7,249; gross profit 18,241; gross margin 71.6 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.