Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Enter what one order costs you
Type your average order value, product cost, the shipping and packing you pay, your card fee (Shopify Basic in the US is 2.9% + 30¢ for online standard cards) and the share of orders that are returned and refunded. Use your own store's return rate if you have it.
Let returns count
A returned order is refunded, but you still paid to ship it, and Shopify Payments doesn't return the card fee. The workbook weights kept and returned orders by your return rate to find what an average order really leaves you before ads.
Set the profit you want
Choose a profit per order after ads, as a percentage of order value. The workbook returns break-even ROAS (the line to cut below) and target ROAS (the line to scale above), plus the most you can pay per order for each.
Check every product and today's ROAS
Type the ROAS your ads report now for an instant verdict in dollars per order. Then fill the Products sheet: each product gets its own break-even and target ROAS, because one store-wide number hides the products that lose money.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Product or bundle | Price | Product cost |
|---|---|---|
| Linen shirt | 60.00 | 18.00 |
| Linen trousers | 85.00 | 27.00 |
| Two-shirt bundle | 110.00 | 36.00 |
| Gift box | 45.00 | 14.00 |
| Socks 3-pack | 24.00 | 6.00 |
| Your product |
Worked review example
Fictional worked example: a $60 order with $18 product cost breaks even at 1.43 on product cost alone. After $8 shipping and a $2.04 card fee it's 1.88. With 19.3% of orders refunded, an average order leaves $23.85 and break-even ROAS is 2.52.
Keeping 15% of the order ($9) leaves $14.85 for ads, so the target ROAS is 4.04. At the 2.0 ROAS the store's ads report, each order loses $6.15.
What this template does and does not establish
The workbook uses the order value the ad platform reports and assumes returned items are refunded in full and restocked; add unsellable items to the extra cost per return. It excludes overhead, taxes collected for the government and repeat purchases, and takes platform ROAS at face value, which can over- or under-count the sales ads caused. Example rows are fictional, not benchmarks.
Primary references
- Shopify: pricing and online card rates
- Shopify Help Center: refunds and Shopify Payments fees
- NRF and Happy Returns: 2025 retail returns estimate
