Print on Demand Profit Calculator Spreadsheet, POD Pricing for Etsy Sellers, Fees, Sale Discount Test, Break Even, Google Sheets Excel

See what you really keep on every print-on-demand sale, and how deep your next Etsy sale can go before an order loses money.

The base product and print, your provider's shipping, tax on your cost, the occasional reprint or refund, your design and mockup cost, Etsy Ads, and every Etsy fee on the price plus shipping: on a $29.99 tee it adds up fast. This calculator puts it all in one place and gives you a break-even price, a suggested listing price for the margin you want, and the deepest sale discount you can run.

HOW IT WORKS
- Settings: check the Etsy fee rates for your bank country, the share of your sales from Offsite Ads, your target margin, a reprint / refund allowance and your Etsy Ads spend per sale. Once.
- Calculator: what your provider charges per order (base product incl. print, extra print locations, shipping to your customer, tax on your cost), your design cost and the sales you expect from the design.
- Type your listing price, a sale discount if you run one, and the shipping you charge (0 = free shipping).
- Read profit, margin, break-even price, suggested listing price and the deepest sale discount before you lose money.
- Price Test: six listing prices and six sale discounts side by side.
- Product List: up to 50 products with profit, margin, suggested price, deepest sale and status (OK / Below target / Losing money).

FEATURES
- Provider cost incl. extra print locations, shipping and tax on your cost
- Reprint / refund allowance %
- Design and mockup cost spread over the sales you expect
- Etsy Ads spend per sale and Offsite Ads share in the fee
- Optional currency conversion fee
- Break-even price and suggested listing price for your target margin, rounded to .99
- Deepest sale discount before a loss, and before you drop below your target margin
- Sales per month for your monthly profit goal
- Dashboard: averages, best products by profit per sale, what needs attention, chart

WHAT YOU GET
+ Print-on-Demand-Profit-Calculator.xlsx (Dashboard, Calculator, Product List, Price Test, Settings, Start Here)
+ How-to-open PDF (Google Sheets and Excel)

HOW TO OPEN IT IN GOOGLE SHEETS
1. Download the files from You > Purchases and reviews.
2. Upload the .xlsx file to Google Drive and open it.
3. Choose File > Save as Google Sheets.
It also opens directly in Excel 2016 or newer. No macros.

GOOD TO KNOW
- Digital download, no physical item. Nothing will be shipped.
- Works with any print-on-demand provider: you type in your provider's own prices. It does not connect to a provider or to Etsy.
- Works in any currency: amounts are plain numbers.
- Etsy fee rates (listing $0.20, transaction 6.5%, payment processing by bank country, optional Offsite Ads 15% / 12%, regulatory fee) are editable settings, so you can update them if Etsy changes its fees.
- Sales tax and VAT collected by Etsy are left out. Sell only designs you made or have a commercial license for, and follow Etsy's rules for items made with a production partner.
- Comes with sample data, clearly marked SAMPLE, so you can see how it works. Sample provider prices are made up and are not benchmarks.
- Not affiliated with or endorsed by Etsy, Inc. or any print-on-demand provider. Not tax, legal or financial advice.

Designed by seller. This spreadsheet was created with the help of AI tools, built and tested by hand (formulas recalculated and checked with sample data and with empty inputs).

Questions or a problem with the file? Message us on Etsy and we will help.