Antique 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
Antique 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 14 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 — Antique 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 Antique Store Profit Tracker track?
The Antique 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; 125 units sold in 14 logged sales; total revenue 14,760; cost of goods 6,813; gross profit 7,947; gross margin 53.8 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.