Free editable template

ROAS target calculator: break-even ROAS after fees, shipping and returns

Replace the 1 ÷ margin shortcut with a ROAS target that counts every cost of an order. The workbook mirrors the online calculator, gives a verdict on the ROAS your ads report today, works out break-even and target ROAS for up to 20 products, and charts how the target rises with your return rate.

By GaaS editorial · Sources checked · 6 worksheet rows

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 bundlePriceProduct cost
Linen shirt60.0018.00
Linen trousers85.0027.00
Two-shirt bundle110.0036.00
Gift box45.0014.00
Socks 3-pack24.006.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

Continue the work