← All prebuilt solutions
Planning & Finance

Online Seller Profit Calculator

Know what you really make on Amazon, eBay, Etsy, Shopify and TikTok Shop – SKU by SKU, channel by channel

£20
Buy nowAsk a question

Secure checkout. Your download link is sent as soon as payment clears.

Online Seller Profit Calculator

Overview

Selling online looks simple until you add up the deductions: selling fees that vary by category, payment processing, per-order and listing fees, FBA fulfilment and storage, postage and packaging, refunds and returns, advertising, subscriptions – and, if you're not VAT registered, the 20% VAT charged on top of most platform fees, which you can't reclaim. This workbook does the sums for every SKU on every channel and for every order you've taken, so you can see which products and channels really make money, set prices that hit your target margin, keep an eye on the VAT registration threshold and HMRC's platform-reporting rules, and see how much cash the marketplaces are holding for you.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Marketplace Fees

Fees and terms for each channel, selling fee % by category, size tiers, FBA uplift and storage rates. What you do: check and update regularly.

Marketplace Fees
Products

Step 2

Products

Your SKUs with costs, size tier, VAT rate and price per channel. What you do: one row per SKU.

Step 3

Orders

Every order, with the profit, payout and payout date worked out for each. What you do: paste your order reports.

Orders
Ads & Monthly Costs

Step 4

Ads & Monthly Costs

Ad spend, ad-attributed sales and monthly fees per channel; total monthly costs including subscriptions and VAT. What you do: monthly figures.

Who it is for

Made for people like you

  • Example – text
  • Amazon sellers (FBA or self-fulfilled) – True profit after referral fees, FBA fees, storage, VAT on fees, ads and returns – and a break-even price per SKU.
  • eBay, Etsy and TikTok Shop sellers – Fees by category, listing and payment fees, return rates and ad costs channel by channel.
  • Shopify / own-website sellers – A fair comparison with the marketplaces once payment fees, postage and ads are counted.
  • Multi-channel sellers – One monthly P&L across every channel, best and worst SKUs, cash timing and a VAT threshold watch.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Enter your business name, the first day of the 12 months you're analysing, whether you're VAT registered, the tax year, your target and minimum margins and the VAT warning level.
  2. Marketplace Fees – Check every channel's fees against your own statements and the platforms' current fee pages: selling fee %, other % fees, payment processing, fixed fees, subscription, VAT on fees, fee refunds on returns, return handling, payout delay and the calculator allowances. Then the category rates, size-tier fees and storage rates.
  3. Products – One row per SKU: name, fee category, size tier, weight, cubic feet, VAT rate, unit cost, inbound shipping, packaging, months held at FBA and your price on each channel.
  4. Profit Calculator – Pick a SKU to see its profit on every channel, then try test prices.
  5. Orders – Paste your orders from each platform's order or transaction report: date, order ID, channel, SKU, quantity, item price, shipping charged, your actual postage, refund and return outcome.
  6. Ads & Monthly Costs – Each month, enter ad spend, ad-attributed sales and storage or other monthly fees for each channel.
  7. VAT & HMRC – Enter your turnover for the 11 months before the year starts so the rolling 12-month total is complete.
  8. Review – Start with the Dashboard, then Monthly P&L, SKU Performance, Product Margins and Returns & Ads.

Key features

  • Editable fee tables for up to 8 channels: selling fees by category, payment processing, fixed and listing fees, FBA fulfilment by size tier, storage, subscriptions and payout delays.
  • Up to 300 SKUs with costs and a price per channel, and an Orders log for 6,000 orders – profit worked out on every single order.
  • Profit calculator for any SKU on every channel: net margin, return on stock, break-even price and the price you need for your target margin.
  • Monthly P&L by channel, best and worst SKUs, returns impact, ACOS and TACOS, VAT threshold watch, HMRC platform-reporting check and cash timing.

What’s included

  • Dashboard – Profit, margin, VAT and cash at a glance
  • Settings – VAT position, targets, HMRC thresholds
  • Marketplace Fees – Fees, fulfilment and payout terms
  • Products – SKUs, costs and prices per channel
  • Orders – Every order and its profit
  • Ads & Monthly Costs – Ads, ad sales, storage, subscriptions
  • Profit Calculator – One SKU on every channel
  • Product Margins – Every SKU on every channel
  • Monthly P&L – Profit and loss by month and channel
  • SKU Performance – Best and worst sellers
  • Returns & Ads – Return rates, ACOS and TACOS
  • VAT & HMRC – VAT threshold and platform reporting
  • Cash Timing – When marketplace money reaches you
  • Tax Rates – VAT rate and threshold
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Trial Balance to Accounts Mapper

Trial Balance to Accounts Mapper

Turning a trial balance into statutory accounts means mapping every account to the right heading, posting year-end adjustments, and then building a profit and loss account, balance sheet and notes in the format the Companies Act requires – for this year and last year.

£20
View details →
Staff Appraisal & Performance Tracker

Staff Appraisal & Performance Tracker

Good appraisals are fair, consistent and joined up: objectives agreed at the start of the year, regular 1-to-1s, honest ratings against a clear competency framework, a calibration meeting so one manager's…

£20
View details →
Practice Timesheet & WIP

Practice Timesheet & WIP

An accountancy practice sells time, but most of its fees are fixed.

£20
View details →

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Custom spreadsheetsTalk to us

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions
AccountsTax compliance and planningBookkeeping and VATPayroll and CISCloud accounting softwareBusiness growth and planning

Get In Touch

We're open Monday to Friday, 9am – 5pm. Call our Plymouth office on 01752 42 72 82 or send us a message below, whether it's about consultancy, spreadsheets or our document templates.

Services
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Quick Links

Business ConsultancyCustom SpreadsheetsPrebuilt Spreadsheet SolutionsBusiness Document TemplatesAbout UsTestimonialsInsightsFAQsContactAccountancy – AML Accountancy Solutions

Company information

Offices
Plymouth
First Floor, Unit D2, 4 Neptune Park, Plymouth, PL4 0SJ
Phone Number
01752 42 72 82
Email
info@amlconsultancysolutions.co.uk
Opening hours
Monday to Friday: 9:00 am to 5:00 pm

Legal

Privacy PolicyCookies PolicyDisclaimer PolicyTerms and ConditionsComplaints ProcedureAccessibility Statement

AML CONSULTANCY SOLUTIONS LTD
Registered Address: First Floor, Unit D2, 4 Neptune Park, Plymouth, United Kingdom, PL4 0SJ. Company Number: 12747461