Book an appointment

E-Commerce Accounting Calculators

Financial Tools for UK Ecommerce Businesses

Calculate revenue, profit, ROAS and more

Generating PDF…

↺

Reset All Values?

This will clear all your inputs across every tab and restore the default example values. This cannot be undone.

Revenue Forecast
Estimated monthly traffic to your store
%
% of visitors who make a purchase (UK avg: 1.5–3.5%)
£
Average amount spent per order
%
% extra revenue from returning customers

Revenue Breakdown

Monthly Orders250
Initial Revenue£18,750
Repeat Revenue Uplift£3,750
Total Monthly Revenue£22,500
Cost Structure
£
Cost of goods sold per item
£
Average fulfilment cost per order
%
Shopify, Stripe, Amazon, payment gateway etc.
£
Google, Meta, TikTok, etc.
£
Salaries, software, rent, utilities

Cost Breakdown

COGS (variable)£7,000
Shipping (variable)£1,250
Platform & Payment Fees£788
Ad Spend (fixed)£2,000
Overhead (fixed)£1,200
Total Costs£12,238
Financial Summary
Total Revenue
£22,500
Monthly gross
Gross Profit
£14,250
After COGS & shipping
Net Profit (pre-tax)
£10,262
After all costs
Corporation Tax (UK)
£1,950
25% rate
Net Profit (after tax)
£8,312
Your take-home

Margin Analysis

Gross Margin % 63.3%
Revenue after COGS & shipping ÷ Total Revenue
Net Profit Margin % 36.9%
Net profit after all costs & tax ÷ Revenue
ROAS 11.3x
Revenue ÷ Ad Spend
POAS 5.1x
Gross Profit ÷ Ad Spend

Revenue Waterfall

Cost breakdown as % of revenue£22,500
COGS
Ship
Fees
Ads
OH
Tax
Profit
COGS
Shipping
Platform Fees
Ad Spend
Overhead
Corp. Tax
Net Profit
ROAS by Channel

Enter your ad spend and attributed revenue for each channel. ROAS = Revenue ÷ Ad Spend.

Channel Ad Spend (£) Revenue (£) ROAS
TOTAL £0 £0
Summary Metrics
Overall ROAS
—
Revenue per £1 spent
Total Ad Spend
£0
Total Revenue
£0
Gross Profit (Rev – Spend)
£0
Before COGS
Cost per £1 Revenue —
ROAS Benchmark Guide
Below 1.0x Spending more than you earn — review urgently
1.0x – 2.0x Breaking even or marginal return
2.0x – 4.0x Positive return — typical for most e-commerce
4.0x – 8.0x Strong performance
8.0x + Exceptional — check attribution is correct
POAS Inputs
£
£
£
£
Fulfilment, payment fees, returns etc.
Core Calculations
POAS
—
Profit per £1 ad spend
ROAS
—
Revenue per £1 ad spend
Gross Profit
£0
Gross Margin %
0%
Profit After Ad Spend
£0
Profit After Ads %
0%
POAS by Channel (Optional)

Optionally enter ad spend and gross profit per channel to identify which channels are truly profitable.

Channel Ad Spend (£) Gross Profit (£) POAS
TOTAL £0 £0
Target POAS Calculator
%
What gross margin % are you targeting?
Minimum POAS to be profitable
0.67x
POAS must exceed this for ads to be profitable
Max Ad Spend Ratio
40%
Max Ad Spend (£)
£0
POAS Benchmark Guide
Below 0.0x Ad spend exceeds gross profit — loss-making
0.0x – 0.5x GP covers spend but very slim margin
0.5x – 1.0x Positive but tight — monitor closely
1.0x – 2.0x Healthy return — ad spend well covered
2.0x + Strong performance
Base Inputs
£
£

Base Metrics

Gross Margin per Unit (£)£30.00
Gross Margin % (base)60.0%
Monthly Gross Profit (no discount)£15,000
Key Takeaway

Each row shows the gross profit impact and whether a discount is likely to be profitable.

Discount Scenarios

The Volume Uplift % rows are editable — adjust to match your realistic expectations. All other cells calculate automatically.

Metric No Discount 5% 10% 15% 20% 25%
Discount % 0%5%10% 15%20%25%
Volume Uplift % (editable) — % % % % %
Discounted Price (£) ——— ———
GP per Unit (£) ——— ———
GM % on Discounted Price ——— ———
Units Sold ——— ———
Total Revenue (£) ——— ———
Total Gross Profit (£) ——— ———
GP vs No Discount (£) ——— ———
Break-Even Volume Analysis

How many units do you need to sell at each discount level to maintain the same gross profit as selling at full price?

Metric No Discount5%10%15%20%25%
Units Needed to Match Base GP ——— ———
Extra Units Required ——— ———
Required Volume Uplift % to Break Even ——— ———
Book an appointment

Wait! Before You Go…

Don’t miss out on your FREE consultation with one of our experienced directors.

Benefit from personalised advice and tailored solutions for your e-commerce business. Our directors are here to help you navigate the complexities of e-commerce accounting and VAT/GST compliance, alongside Virtual Finance Director (VFD) services to provide comprehensive financial guidance tailored to your e-commerce business.

Book your consultation now