google sheets

Profit calculator, essential formulas, and a ready-to-use finance tracker template for ecommerce stores.

# profit calculator

Enter your numbers — see margin, break-even, and pricing targets instantly.

selling price ($)

cost of goods (COGS, $)

shipping cost ($)

platform fee (%)

monthly fixed costs ($)

results

gross profit —

net profit (after fees) —

profit margin —

platform fee amount —

break-even units / month —

price for 30% margin —

price for 40% margin —

# essential formulas

8 Google Sheets formulas every ecommerce store owner should have in their tracker.

profit margin % pricing

=(sell_price - cogs - shipping - platform_fee) / sell_price * 100

Gross margin as a percentage of selling price. Target 30–50% for sustainable ecommerce.

COGS as % of revenue cost analysis

=SUMIF(orders[status],"shipped",orders[cogs]) / SUMIF(orders[status],"shipped",orders[revenue]) * 100

What percentage of your revenue goes to product cost. Keep below 40% for healthy margins.

customer lifetime value (LTV) growth

=average_order_value * purchase_frequency * customer_lifespan_years

How much a customer is worth over time. Use this to justify higher ad spend per acquisition.

average order value (AOV) performance

=SUMIF(orders[month],A2,orders[revenue]) / COUNTIF(orders[month],A2)

Total revenue divided by number of orders in a period. Track monthly to spot trends.

return on ad spend (ROAS) ads

=ad_revenue / ad_spend

Revenue generated per dollar spent on ads. A ROAS of 3–4× is the common target for ecommerce.

inventory turnover rate inventory

=COGS_annual / ((opening_stock + closing_stock) / 2)

How many times you sell through inventory in a year. Higher = less capital tied up in stock.

refund rate % quality

=COUNTIF(orders[status],"refunded") / COUNTA(orders[order_id]) * 100

Percentage of orders refunded. Under 3% is typical for physical goods; above 5% is a signal to investigate.

cash flow projection finance

=opening_balance + projected_revenue - projected_cogs - projected_expenses

Simple month-by-month cash flow. Chain this across 12 rows with prior month closing as opening balance.

# sample data

A pre-filled CSV with 3 months of sample ecommerce data — orders, revenue, COGS, platform fees, and ad spend. Import into Google Sheets to see the formulas in action.

↓

sample-data.csv 3 months of sample ecommerce data — revenue, COGS, fees, ad spend

// etsy ecommerce profit & finance tracker Pre-built Google Sheets tracker with all 8 formulas, charts, monthly dashboard, and 3 months of sample data.

$15 buy on etsy →