Know which designs actually make money after base costs and platform fees. This print on demand sales tracker brings every order into one Google Sheets page: a Total Revenue card, four charts and a 16-column order register that works out revenue, net profit, profit margin, profit per unit and a best-seller rank for you. The Print-on-Demand Sales Tracker in Google Sheets is built for T-shirt, mug, poster, sticker and home-decor sellers who list on several marketplaces or their own store and want a clear, editable record without another monthly subscription.
Key Features of Print-on-Demand Sales Tracker in Google Sheets
- Total Revenue card: the headline figure (a $9.0K demonstration total) updates as you add or edit orders.
- Four charts linked to the data: Orders by Product Type, Orders by Status, Revenue by Product and Revenue vs Net Profit.
- 16-column order register: Order ID, Product / Design, Product Type, Sales Platform, Order Date, Units Sold, Sale Price, Revenue, Base Cost / Unit, Platform Fee, Net Profit, Profit Margin, Status, Best-Seller Rank, Profit / Unit and Notes.
- Automatic calculations: Order ID, Revenue (Units × Sale Price), Net Profit (revenue minus production cost minus the platform fee), Profit Margin, Best-Seller Rank and Profit / Unit are formulas.
- Loss warning: a net loss is flagged in red so an unprofitable design stands out.
- Order status workflow: Processing, Shipped, Delivered, Refunded, On Hold and Cancelled.
- Editable dropdowns: Product Type, Sales Platform and Status pull from the List tab, so a new marketplace or product type appears in the dropdown as soon as you add it.
- Instructions tab: a How to Use page explains data entry, formula columns, dropdowns, charts and currency changes.
How the Print on Demand Sales Tracker Works
The top band summarises the order register below it. Orders by Product Type shows the mix of T-shirts, hoodies, mugs, posters, canvas prints, tote bags, phone cases, stickers, wall art, throw pillows and tumblers in the sample. Orders by Status counts orders that are delivered, shipped, processing, refunded or on hold. Revenue by Product ranks individual designs by revenue, and Revenue vs Net Profit places each design’s gross sales beside what was left after base cost and platform fee.
The charts read the data columns directly with the built-in aggregation in Google Sheets, so new orders are included automatically. There are no hidden helper tables to maintain.
The tracker page with 15 sample orders, four charts and the formula-driven order register
What Each Order Row Tells You
You enter eight fields for each order: Product / Design, Product Type, Sales Platform, Order Date, Units Sold, Sale Price, Base Cost / Unit and Platform Fee (as a percentage, for example 9.5%). The sheet does the rest. In the first sample row, 42 units at $24.99 produce $1,049.58 in revenue; after a $9.50 base cost per unit and a 9.5% fee, the row shows about $551 net profit, a 52% margin and $13.12 profit per unit. The Profit Margin column is colour-shaded, which makes slim-margin designs easy to spot, and the Notes column keeps reminders such as “raise price?” next to the numbers.
Google Sheets Tracker vs Excel vs Seller Software
| Consideration | This tracker | Excel workbook | Seller analytics platform |
|---|---|---|---|
| Cost | One-time template purchase | Template plus Excel access | Usually a recurring plan |
| Access | Browser-based Google Sheets | Microsoft Excel | Vendor-hosted account |
| Collaboration | Native Google Drive sharing | Depends on Microsoft setup | Seat and plan dependent |
| Profit per order | Built-in formulas you can inspect | Depends on workbook | Varies by tool |
| Automatic order import | Not included (manual entry or paste) | Not normally included | Often available |
This is a transparent spreadsheet, not accounting or store-integration software. It has no API connection to any marketplace or print provider; the platform names in the sample are editable labels only and imply no affiliation. It does not calculate taxes, shipping or payouts.
Who This Template Is For
It suits independent designers, small print-on-demand brands, side-hustle sellers and agencies that manage a handful of storefronts. It is most useful when the question is not just “what sold?” but “which designs, product types and platforms leave a healthy margin after the base cost and fee?”
How to Use the Tracker
- Open the PDF in your download and use its link to make your own editable Google Sheets copy.
- Replace the 15 sample orders with your own orders.
- Fill Product / Design, Product Type, Sales Platform, Order Date, Units Sold, Sale Price, Base Cost / Unit and Platform Fee.
- Update Status as orders move from Processing to Shipped to Delivered, or to Refunded, On Hold or Cancelled.
- Add your own marketplaces and product types on the List tab.
- Change the currency with Google Sheets number formatting if you do not sell in dollars.
- Control who can see your sales with the Google Drive file sharing settings.
Real-World Use Cases
A T-shirt designer on several marketplaces
Sara logs every order with its platform fee and sees that one popular tee earns less per unit than a lower-volume hoodie, so she reviews its price.
A sticker and mug shop
James sells high volumes of small items. Profit / Unit and Profit Margin show that his sticker packs sell well but leave a small profit on each unit.
A small brand reviewing refunds
A two-person studio uses the Status column and Notes to record a refunded batch and an order on hold, and checks the Orders by Status chart each week.
Frequently Asked Questions
Does it connect to my store or print provider?
No. There is no API connection. Orders are entered or pasted manually.
Can I add more marketplaces or product types?
Yes. Add them on the List tab and they appear in the dropdowns automatically.
Are the charts updated automatically?
Yes. All four charts read the order register directly, so new rows are included.
Can I change the currency?
Yes. Select the money columns and change the number format to your currency.
Does it include shipping or tax calculations?
No. Net Profit is revenue minus base cost and the platform fee percentage only.
Can my team edit it?
Yes, subject to the Google Drive permissions you assign.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels.
Explore Related Templates
Pair this tracker with the Etsy Seller Analytics Dashboard in Google Sheets, the Seller Analytics Dashboard, the Drop Shipping Dashboard or the Side Hustle Income Tracker. Browse the full Google Sheets tracker collection for more focused workflows.
Read the full walkthrough on our blog: Print-on-Demand Sales Tracker in Google Sheets guide.
See revenue, profit and your best sellers in one sheet. Buy once, make your Drive copy and replace the sample orders with your own.
Reviews
There are no reviews yet.