Calculate Break-Even ROAS with Refunds, Fees and Overhead
A worked break-even ROAS example that reconciles retained sales, product costs, payment fees and overhead. Calculate an ad-spend ceiling and target-profit ratio.
Use this guide with
3 ToolsWebPro tools
Open the free tool(s) below and follow the steps in this guide.
Revenue per ad dollar is not the same as profit
ROAS divides attributed revenue by advertising spend. A high ratio can still leave little contribution after product, shipping, payment and other costs. Start with a consistent reporting period and tax basis. The Break-Even ROAS Calculator reconciles the sales you retain with the costs of those same sales; it does not connect to an advertising account or make live bid changes.
Google's target ROAS explanation defines the relationship between conversion value and advertising cost. For example, 500% corresponds to five units of conversion value per unit of spend. Our calculation uses retained sales after the adjustments you enter, which may differ from the conversion value recorded by a platform.
Open the tool:
Reconcile sales and costs on one basis
Begin with ad-attributed sales excluding sales tax or VAT. Deduct refunds and discounts only when they are not already removed. If your sales export is already net of returns, entering the same refund again would understate retained sales. Do not use all store sales as the numerator while entering only one campaign's ad cost.
Use actual net product costs, fulfillment, return handling, payment fees and other variable costs. A refund does not tell the calculator whether the product came back in a saleable condition or whether the processor returned its fee. Record those outcomes in the cost inputs. Allocate only an appropriate share of fixed overhead to this sales group, and keep a note of the basis outside the calculator.
Calculate the spending ceiling before the ratio
Retained sales minus non-ad costs and allocated overhead is the amount available before advertising. Holding those sales and costs fixed, that amount is the break-even ad-spend ceiling. Divide retained sales by a positive ceiling to obtain the break-even ROAS. Equivalently, take one divided by the fully costed pre-ad margin as a decimal.
The SBA's break-even explanation describes contribution as revenue less the associated variable costs and relates it to covering fixed costs. Our ad-spend ceiling is a fixed-sales planning application of that arithmetic. It does not assume that sales will remain fixed if you actually change a campaign budget.
Follow a refunds-and-fees example
Suppose attributed sales are $10,000 and refunds not already deducted are $1,000. Retained sales are $9,000. Enter $3,500 product costs, $700 shipping and return handling, $300 payment fees and $500 other variable costs. Add $500 allocated overhead. This leaves $3,500 before advertising.
At $2,000 ad spend, retained ROAS is 4.5× and modeled profit after ads is $1,500. The break-even ROAS at these sales is $9,000 ÷ $3,500, or about 2.57×. A target profit of 10% of retained sales reserves $900, leaving a $2,600 advertising ceiling. The implied target ratio is about 3.46×.
| Measure | Example |
|---|---|
| Retained sales | $9,000 |
| Variable costs | $5,000 |
| Allocated overhead | $500 |
| Break-even ad ceiling | $3,500 |
| Actual ROAS / profit after ads | 4.5× / $1,500 |
| 10% target profit | $900 |
| Target-profit ad ceiling / ROAS | $2,600 / 3.46× |
Interpret impossible targets and missing ratios
If non-ad costs already consume retained sales, there is no positive ad budget in this scenario. The tool displays that condition instead of an infinite break-even ROAS. A target profit margin can also leave no positive advertising budget even when break-even itself is possible. Changing an ad-platform ratio cannot repair the underlying cost arithmetic.
Zero ad spend leaves actual ROAS undefined; zero orders leaves cost per order unavailable. Neither should be shown as a favorable zero. When an order count is supplied, the result is advertising cost per order, not new-customer acquisition cost. Repeat customers and multiple orders are not identified, and lifetime value is not modeled.
Use the comparison as a worksheet
Keep one cost scenario, then compare a changed refund amount, overhead allocation or profit target. The spend-sensitivity table holds retained sales and all non-ad costs unchanged. It shows what the arithmetic would be at three spend amounts, not what the campaign will deliver. A practical forecast would need a defensible relationship between spend, attributed sales and incremental sales.
Export the inputs with the results so a teammate can check the sales basis, period and allocation. Method reviewed 17 October 2026. The tool is a planning worksheet, not a bidding recommendation or proof of advertising incrementality. If your accounting export mixes comma decimals or separators, the CSV format fixer can prepare selected columns before your review.
Frequently asked questions
Is a 4× ROAS always profitable?
No. Revenue is not profit. Refunds, product and fulfillment costs, payment fees, allocated overhead and ad costs can consume that revenue. The same reported ROAS can produce different results in different businesses.
Can this calculation set a Google Ads bid target?
It gives a cost-based planning ratio at the entered sales and costs. It does not model platform attribution, conversion delays, incremental sales or how revenue changes with the budget, so it is not a bidding recommendation.
Reconcile your ROAS with actual costs
Use one consistent period, compare a profit target and export the calculation.
Muhammad Saqlain
Web Developer & ToolsWebPro FounderDevelops and tests ToolsWebPro's browser tools and documents their formulas, assumptions and reproducible examples.
Read full author bio & credentials →Related ToolsWebPro tools
Open the free tool(s) for this guide — no signup required.
- Break-Even ROAS CalculatorCalculate break-even ROAS after refunds, product costs, fees and allocated overhead. Check your target profit, ad-spend ceiling and cost per order. No upload.
- CSV Delimiter Converter & Format FixerChange a CSV separator and review number or date changes column by column before downloading the result.
- Software ROI CalculatorBuild a software business case with setup costs, subscriptions and an adoption ramp. Separate recovered staff capacity from cash savings; compare and export scenarios.
More from ToolsWebPro