Boutique Clothing Store Profit Tracker Excel for your products — product lines and sales, cost of goods, and a monthly P and L dashboard. Know what every unit actually earns — and whether the month actually made money.…
About this template
Boutique Clothing Store Profit Tracker Excel for your products — product lines and sales, cost of goods, and a monthly P and L dashboard. Know what every unit actually earns — and whether the month actually made money. Built for boutique clothing stores and small fashion retailers who need to know, products by products and units by units, what cost of goods really costs — without accounting software. If the best-selling tee in the shop earns a dollar a unit, this workbook shows it before the next buy goes out.
$49
Excel & Google Sheets template — instant download on Etsy
Products & Sales — product, category, units sold, price per unit, cost per unit, margin per unit, add-on revenue, and total revenue, for 12 product lines.
Sales Log — date, product, sale or task, units, price per unit, amount, cost of goods, and billable flag, for 16 rows in October 2026 (12 product lines, 3 styling and gift services, 1 damaged return written off).
Expenses — item, category, unit, quantity per month, cost per unit, monthly cost, and notes, for 12 expense items.
Monthly P and L — revenue, cost of goods, rent, utilities, staff, 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, product lines, units, billable vs non-billable units, capacity used, average revenue per unit, cost of goods, gross profit and margin, expenses, net profit and margin, 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 — Boutique Clothing 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 Boutique Clothing Store Profit Tracker track?
The Boutique Clothing Store Profit Tracker tracks Products & Sales; Sales Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 products; 1050 units; base revenue 52,005; add-on revenue 330; total revenue 52,335.
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.
This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.
VickeryFinance — “Know your numbers — without the accounting software.”
Gear that pairs with this tracker
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you. We only list gear genuinely used in this trade.