Marketplace Seller Fees & Net Profit Calculator in Google Sheets

Photo by Gorilla ROI Data Connector on Unsplash

Why sellers need a structured profit model

Listing prices on Amazon, eBay, Etsy, Walmart, or any other marketplace without accounting for every fee layer is one of the most common reasons sellers underestimate costs and overestimate margins. A selling price of £35 can easily leave you with less than £7 after the platform takes its referral fee, a fulfilment centre charges for picking and packing, you run a sponsored-product campaign, the courier charges for shipping, and a percentage of orders are returned. This guide builds a complete, formula-driven model and then publishes it as a live web calculator using GSheetPress.

What this model covers: selling price, platform referral commission, fulfilment fee (fixed per-unit charge), advertising cost per unit, outbound shipping cost, a return-rate allowance, and product cost (cost of goods sold). Every other cost category — VAT, customs duties, storage fees, subscription fees, currency conversion, and income tax — is excluded deliberately. Note all fee percentages used in the worked example and adapt them to your actual marketplace rate card before relying on results. Marketplace fee schedules change; always verify current rates against the official documentation for your platform, for example the Amazon Selling on Amazon fee schedule.

Key terms explained

• Referral fee (platform commission): A percentage of the selling price that the marketplace keeps for providing the sales channel. Rates typically range from 6% to 45% depending on category.
• Fulfilment fee: A fixed or weight-based charge per unit for picking, packing, and dispatching an order, whether handled by the marketplace (FBA, eBay fulfilment) or a third-party logistics provider.
• Advertising cost per unit (ACoS-derived): Your total ad spend divided by the number of units sold. For this model you enter the estimated cost you wish to attribute per unit sold.
• Gross profit: Selling price minus product cost only — it does not include fees or other selling costs.
• Net profit: What remains after every modelled cost is subtracted from the selling price.
• Net margin: Net profit expressed as a percentage of the selling price, showing how many pence or cents of every pound or dollar of revenue you actually keep.
• Return-rate allowance: The average percentage of units that are returned by customers, multiplied by the cost you bear per return, expressed here as a per-unit cost.
• Markup vs margin: Markup is profit divided by cost; margin is profit divided by revenue. This model uses margin throughout.
• G-column runtime values: In a GSheetPress Calculator, column G stores the values submitted by the user through the web form. Your result formulas must reference G cells, not E cells.
• E-column defaults: Column E stores the default values shown in the web form before a user changes them. They are not live calculation inputs.

Prerequisites

• A Google account with access to Google Sheets.
• GSheetPress installed and your account matched. Open a sheet, go to Extensions → GS2Web SaaS, sign in with the same email you used at GSheetPress, and confirm the Calculator entitlement is active under your plan. If you are unsure which plan includes Calculator, check the pricing page.
• A dedicated sample workbook created solely for this calculator — do not use a sheet that contains real business data, because the sharing step later makes the spreadsheet editable by anyone with the link.

Step 1 — Set up the sample workbook

1. Create a new Google Sheet and name it something like Marketplace Fee Calculator – Sample.
2. Rename the default tab FeeModel. You will build the helper and result formulas here after the Calculator tool generates the input rows.
3. Do not type any content into the sheet yet. The GSheetPress Calculator tool generates the column headers automatically.

Step 2 — Create the calculator in GSheetPress

1. With the FeeModel tab active, go to Extensions → GS2Web SaaS → Calculator → New Calculator.
2. In the dialog, enter the name: Marketplace Profit Calculator.
3. Set the number of inputs to 7. Do not count the button — only the data-entry rows.
4. When asked about graphs, choose No for this model.
5. Click Create. The tool writes headers into A1:H1 and inserts placeholder rows for inputs 1–7 (rows 2–8), the button in row 9, a merged separator in row 10, result headings in row 11, and leaves rows 12 onward for your result formulas.

Understanding the generated layout

Row 1 contains eight generated column headers: Labels, Input Type, Required, Data, Default, ToolTips, Inputs, Rules. These map to columns A through H. Column G (Inputs) is where the web form writes submitted values at runtime. Column E (Default) holds the pre-filled values shown in the form before a user interacts. Column F may be spelled ToopTips in older templates — either spelling works identically.

Step 3 — Configure each input row

Fill in the following cells exactly as shown. Cells listed as blank should be left empty.

Row 2 — Selling price

• A2 — Label: Selling Price (£)
• B2 — Input Type: Number
• C2 — Required: Tick the checkbox (set to TRUE)
• D2 — Data: Leave blank
• E2 — Default: 35
• F2 — ToolTips: The price the buyer pays, excluding postage charged to the buyer.
• H2 — Rules: Leave blank

Row 3 — Referral fee percentage

• A3 — Label: Platform Referral Fee (%)
• B3 — Input Type: Number
• C3 — Required: Tick the checkbox
• D3 — Data: Leave blank
• E3 — Default: 15
• F3 — ToolTips: Enter the percentage your marketplace charges, e.g. 15 for 15%. Verify this against your platform fee schedule.
• H3 — Rules: Leave blank

Row 4 — Fulfilment fee

• A4 — Label: Fulfilment Fee (£)
• B4 — Input Type: Number
• C4 — Required: Tick the checkbox
• D4 — Data: Leave blank
• E4 — Default: 3.50
• F4 — ToolTips: Fixed per-unit cost for picking, packing and dispatch (e.g. FBA fee or 3PL charge).
• H4 — Rules: Leave blank

Row 5 — Advertising cost per unit

• A5 — Label: Ad Spend per Unit (£)
• B5 — Input Type: Number
• C5 — Required: Tick the checkbox
• D5 — Data: Leave blank
• E5 — Default: 1.50
• F5 — ToolTips: Total ad spend divided by units sold, or your target cost per unit sold.
• H5 — Rules: Leave blank

Row 6 — Outbound shipping cost

• A6 — Label: Shipping Cost (£)
• B6 — Input Type: Number
• C6 — Required: Tick the checkbox
• D6 — Data: Leave blank
• E6 — Default: 2.80
• F6 — ToolTips: Your cost to ship one unit to the buyer. Enter 0 if fulfilment fee above already covers this.
• H6 — Rules: Leave blank

Row 7 — Return-rate allowance

• A7 — Label: Return Cost Allowance (£)
• B7 — Input Type: Number
• C7 — Required: Tick the checkbox
• D7 — Data: Leave blank
• E7 — Default: 0.53
• F7 — ToolTips: Estimated per-unit cost of returns (return rate × net cost per return). E.g. 5% return rate × £10.60 net cost = £0.53.
• H7 — Rules: Leave blank

Row 8 — Product cost

• A8 — Label: Product Cost / COGS (£)
• B8 — Input Type: Number
• C8 — Required: Tick the checkbox
• D8 — Data: Leave blank
• E8 — Default: 8.00
• F8 — ToolTips: Your unit cost to source or manufacture the item, including packaging.
• H8 — Rules: Leave blank

Row 9 — The generated button (do not delete)

Row 9 is created automatically. Confirm it contains:

• A9: Calculate (the button label shown on the form)
• B9: Button
• D9: main
• E9: Reset (this is the reset-button label, not a data default — do not change it)

Step 4 — Test defaults before publishing

Before adding result formulas you need values in column G so you can verify the formulas return correct numbers. Column G is overwritten by live web submissions, so never store result formulas there. To populate G with the defaults from E:

1. Select cells E2:E8.
2. Copy (Ctrl+C or Cmd+C).
3. Click cell G2.
4. Go to Edit → Paste special → Values only. This pastes numbers without formulas, avoiding circular references.

G2 should now show 35, G3 shows 15, G4 shows 3.50, G5 shows 1.50, G6 shows 2.80, G7 shows 0.53, and G8 shows 8.00.

Step 5 — Add result labels and formulas

Row 10 is the merged separator. Row 11 holds result column headings. Your result data starts at row 12. Click each cell listed below, type or paste the value shown, and press Enter.

Result labels in column A (rows 12–19)

Result formulas in column B (rows 12–19)

Click cell B12, type the formula beginning with =, and press Enter. Repeat for each row.

B12 =ROUND(G2*(G3/100),2)

This calculates the referral fee: selling price multiplied by the referral rate expressed as a decimal.

B13 =ROUND(B12+G4+G5+G6+G7+G8,2)

This sums the referral fee, fulfilment fee, ad spend, shipping, return allowance, and product cost to give total costs.

B14 =ROUND(G2-B13,2)

Net profit is selling price minus total costs.

B15 =IF(G2=0,"N/A",ROUND((B14/G2)*100,2))

Net margin as a percentage of selling price. The IF guard prevents a division-by-zero error if selling price is left at zero.

B16 =ROUND(G2-G8,2)

Gross profit is selling price minus product cost only.

B17 =IF(G2=0,"N/A",ROUND((B16/G2)*100,2))

Gross margin as a percentage of selling price.

B18 =IF((1-(G3/100))=0,"N/A",ROUND((G4+G5+G6+G7+G8)/(1-(G3/100)),2))

Break-even selling price: the minimum price at which net profit equals zero after paying the referral percentage and all fixed per-unit costs. The referral fee is a percentage of revenue, so you solve for revenue algebraically: Revenue = Fixed costs / (1 − referral rate). The IF guard handles the edge case where referral rate is entered as 100.

B19 =IF(G8=0,"N/A",ROUND((B14/G8)*100,2))

Markup on cost: net profit as a percentage of product cost. Useful for pricing decisions. The IF guard prevents division by zero if product cost is zero.

Step 6 — Worked example and result check

Using the default values pasted into column G (selling price £35, referral fee 15%, fulfilment fee £3.50, ad spend £1.50, shipping £2.80, return allowance £0.53, product cost £8.00), your formulas should return:

Alternative scenario: If you increase the referral fee to 20% (e.g. a jewellery category on some platforms) and keep all other inputs the same, the referral fee rises to £7.00, total costs become £23.33, and net profit falls to £11.67 — a net margin of 33.34%. Break-even price rises to £20.29. This illustrates how sensitive profitability is to the referral rate.

Adapting the model to different marketplaces

The percentage inputs are intentionally generic. When you switch marketplace, update G3 (and E3 as the default) to reflect that platform's referral rate for your category. Common adjustments:

• Amazon: Referral fees vary from 6% (personal computers) to 45% (Amazon Device Accessories). Verify in Seller Central.
• eBay: Final value fees differ for managed payments sellers and vary by category, typically 11.9%–15% plus a fixed per-order charge.
• Etsy: Transaction fee is 6.5% of the selling price plus listing and payment processing fees; fold the fixed listing cost into product cost or fulfilment fee.
• Walmart Marketplace: Referral fees range from 6% to 20% by category.

If a marketplace charges a flat per-order fee in addition to a percentage (as eBay does), add that flat amount to either the fulfilment fee input or create an eighth input row by running the New Calculator flow again with input count 8 and re-entering the configuration.

For more advanced formula techniques that help you structure multi-scenario pricing models, see the GSheetPress Calculator documentation.

Frequently asked questions

Why does my break-even price look higher than expected?

The break-even formula divides all fixed per-unit costs by one minus the referral rate. This is correct because the referral fee is taken from every pound of revenue, so you need more revenue than costs alone to cover it. For example, if fixed costs are £16.33 and the referral rate is 15%, the break-even price is £16.33 / 0.85 = £19.21, not £16.33 + 15%. If you entered the referral fee as a decimal (e.g. 0.15 instead of 15), the formula treats it as 0.15%, producing an almost-identical break-even to your cost total. Always enter percentages as whole numbers (15 means 15%).

Can I add VAT or sales tax to this model?

VAT and sales tax are excluded from this model because the tax treatment depends on your registration status, the buyer's jurisdiction, and whether the marketplace is an appointed tax collector. Adding a tax row without correctly modelling those conditions would produce misleading results. Build a separate VAT model or consult an accountant, then layer the net-of-tax selling price into this calculator as your starting input.

My net profit shows a negative number — what should I check?

A negative net profit means total modelled costs exceed the selling price. Check each input in order: (1) confirm the selling price is the amount received before fees, not the listing price including buyer-paid postage; (2) confirm the referral fee is entered as a whole-number percentage, not a decimal; (3) check that shipping cost is not double-counted if your fulfilment fee already includes dispatch; (4) verify the return-cost allowance is a reasonable per-unit estimate rather than your total monthly returns cost. If the number is still negative after checking all inputs, the listing is genuinely unprofitable at the current price.

Troubleshooting

If you need help configuring result display columns or linking your calculator to a data table, the GSheetPress Table documentation explains how to combine calculator outputs with tabular data on the same page.

Publish and test your web calculator

Important — sharing requirement: GSheetPress must be able to read and write to your spreadsheet. You must share the workbook so that anyone with the link can edit it. This means any person who obtains the spreadsheet URL can modify the sheet directly. For this reason you must use only the dedicated sample workbook you created for this calculator, never a sheet containing real business records or sensitive data.

1. In Google Sheets, click Share (top right).
2. Under General access, change the setting to Anyone with the link.
3. Set the role to Editor.
4. Click Done.

Now publish the calculator:

1. Make sure the FeeModel tab is the active (selected) tab.
2. Go to Extensions → GS2Web SaaS → Calculator → Publish Calculator.
3. Wait for the confirmation message that the calculator has been published.
4. The tool opens or updates a sheet called Calculator Link (or similar). Find the row whose Sheet Name column matches FeeModel.
5. Open the URL in column C (Link), not column B (Edit Link). If the links look stale, click Get Links to refresh the sheet.
6. In the public calculator, enter the worked-example defaults: selling price 35, referral fee 15, fulfilment fee 3.50, ad spend 1.50, shipping 2.80, return allowance 0.53, product cost 8.00. Click Calculate.
7. Confirm the results match the expected values in the table above: net profit £13.42, net margin 38.34%, break-even price £18.62.
8. Optionally copy the Iframe code from column D and paste it into an HTML block on your website. See the GSheetPress embed documentation for iframe sizing options.
9. If you republish the same calculator in future, it retains the same public link — you do not need to update any embeds.