Print on Demand Seller Profit Tracker Excel — designs & pricing, sales log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for Print on…
About this template
Print on Demand Seller Profit Tracker Excel — designs & pricing, sales log, expenses, and a monthly P and L dashboard. Know what every line actually pays — and whether the month actually made money. Built for Print on demand sellers on Etsy, Shopify, and marketplace stores who know their sales total but not which designs survive the base product and print cost.
$39
Excel & Google Sheets template — instant download on Etsy
Designs & Pricing — Every design: gross sales, orders, revenue per order, add-on revenue from upsells, total revenue, and direct base product and print cost charged by the provider. Change a price and the per-order rate and totals update.
Sales Log — Every design line: date, design, entry, orders, rate pulled from sheet 1 by formula, amount, and whether it was billable. Add-on rows are priced per entry, and free promo orders are logged as non-billable.
Expenses — every overhead cost by category (Ads, Software, Design, Platform, Supplies, Fees, Other), with quantity, cost per unit, and a monthly cost for each.
Monthly P and L — revenue, direct cost, ads, software, design, platform, supplies, fees, other and other expenses by month, Jan-Dec, with net profit and margin. Revenue is a formula from the Sales Log; direct cost is a formula from sheet 1.
Dashboard — total revenue, designs, units, billable vs non-billable units, units vs target, average revenue, direct cost, expenses, net profit and margin, best and weakest lines, revenue by line, costs by category, and units by line.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Print on Demand Seller 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 Print on Demand Seller Profit Tracker track?
The Print on Demand Seller Profit Tracker tracks Designs & Pricing; Sales Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 lines; gross revenue 15,830; add-on revenue 305; total revenue 16,135; direct cost 10,920.
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.