Profit & VAT Dashboard for Ecommerce Sellers: Know Your Real Margin on Every Channel

Why most webshop owners don't know their real margin

Most sellers look at their bank account, see money flowing in, and feel good about business. Revenue is growing. The feeling is positive. But what they don't see is the full picture of costs behind every transaction. A sale of €29.99 on Bol.com looks attractive — until you add up the commission (€3.00), shipping costs (€4.50), packaging (€0.60), average return cost (€1.20 per order), and VAT remittance (€5.21 at 21%). What remains can barely cover the purchase price.

The problem isn't negligence — it's complexity. Bol.com shows commissions in the partner portal, but shipping costs are in a separate system. Ad spend lives in Bol.com Adverteren. Return statistics are somewhere else entirely. And then you have Amazon, Shopify, and WooCommerce each with their own reporting structure. Manually consolidating all this data in a spreadsheet takes hours per week and introduces errors at every step.

Studies of small e-commerce businesses show that more than 60% of webshop owners cannot state their net margin without first sitting down to calculate it. This is a dangerous position: you cannot grow strategically if you don't know which products and channels are genuinely making money and which are consuming it.

The answer is not more spreadsheets — it's an automated dashboard that brings all costs together in real time and shows the true net margin per product and per channel.

Profit margin explained: gross vs. net

There are two margin formulas every ecommerce seller must understand: gross margin and net margin. Both matter, but net margin is the only measure that tells you whether your business is truly profitable.

Gross margin calculation: (selling price excl. VAT − product cost) ÷ selling price excl. VAT × 100%.
Say you sell a product for €29.99 incl. 21% VAT. Excl. VAT that is €24.79. Your purchase price is €8.00. Gross margin = (€24.79 − €8.00) ÷ €24.79 × 100% = 67.7%. This looks excellent — but it's an illusion.

Net margin calculation for the same product on Bol.com:
• Selling price excl. VAT: €24.79
• Minus product cost: −€8.00
• Minus Bol.com commission (10%): −€2.48
• Minus shipping costs: −€4.50
• Minus packaging: −€0.60
• Minus return costs (avg. €1.20/order at 8% return rate): −€0.10
• Net profit: €9.11 = net margin of 36.7%

That's nearly half of what the gross margin suggested. And this is still without advertising costs. Add a campaign costing €1.50 per unit sold and the net margin drops to 30.7%. This is the margin you must use as the foundation for every business decision — not the gross margin.

Hidden costs of marketplace selling

Marketplace platforms are powerful sales channels, but they come with a layer of costs that sellers frequently underestimate or miss entirely. Understanding these costs is the first step toward accurate margin calculation.

Bol.com commission structure:
Bol.com's commission varies by category. Books and toys typically sit around 5-8%, while electronics and tools can reach 12-17%. On top of this, LVB (Logistiek via Bol) adds fulfilment fees calculated per order and per product weight and volume. For a product weighing 1 kg, LVB can easily add €3.50-€5.00 in handling costs per order. Add the return handling charge — Bol.com does not reimburse sellers for return shipping — and the per-order cost profile changes dramatically.

Amazon FBA cost structure:
Amazon operates a two-layer cost system: referral fees (similar to Bol.com commission, 6-17% by category) plus FBA fees (fulfilment by Amazon). FBA fees cover picking & packing, shipping, and storage. For a standard-size product (500g), monthly storage costs are approximately €0.75/m³/month in low season but €2.26/m³/month in Q4 (October–December). Slow-moving products are doubly penalised: low revenue and higher storage costs accumulating month after month.

Return costs: the underestimated margin thief
A 10% return rate sounds low, but at 500 orders per month that's 50 returns. If each return costs €3.00 in handling (inspection, repackaging, or write-off), that's €150 per month straight off the margin. Yet many sellers process return costs as a general overhead block rather than attributing them to individual SKUs. A proper dashboard links return costs to individual products and shows the real margin impact per SKU.

Ad spend and ROAS
Paid advertising on Bol.com (Sponsored Products) and Amazon (PPC) is essential for visibility for many sellers. But when ROAS is too low, advertising consumes margin instead of creating it. A ROAS of 3 at a 25% net margin is approximately breakeven for ad spend. Below 2.5, advertising is costing you money. This is only visible when you track advertising costs per product and link them to your margin calculation.

VAT is not profit: understanding your cash flow

This is perhaps the single most common financial mistake among new webshop owners: treating VAT as revenue or profit. When a customer pays €36.29 for a product (€29.99 + 21% VAT = €36.29), the full amount lands in your bank account. But €6.30 of that amount is not yours — it is VAT you are temporarily holding on behalf of the tax authority, and you must remit it every quarter.

Suppose you sell 500 products per month at €36.29 incl. VAT. Your total bank receipts are €18,145 per month. If you use that figure as your revenue for cash flow planning, you will hit a serious problem: €3,150 of that amount goes to the tax authority every quarter. Sellers who don't keep VAT separate face an unpleasant surprise at VAT filing time — sometimes when the cash is already gone.

OSS and VAT per EU country
If you sell to consumers in other EU countries via Shopify or Amazon and your annual cross-border revenue exceeds €10,000, you are required to remit VAT under the One Stop Shop (OSS) system in the destination country. Germany's standard VAT rate is 19%, Luxembourg's is 17%, Denmark's is 25%. If your dashboard does not track this by destination country, you cannot know how much VAT you owe per country each quarter.

A good profit dashboard separates VAT strictly from revenue. It shows your revenue excluding VAT, automatically calculates the VAT owed per EU country, and generates a report you can use directly for your OSS quarterly filing. This is not just a convenience — it prevents penalties and retroactive corrections that can be costly.

Which KPIs should you track?

A profit dashboard is only as valuable as the KPIs it monitors. These are the six metrics every marketplace seller should review weekly:

1. Net margin % per SKU
The absolute baseline measurement. When net margin drops below 15%, action is required: renegotiate purchase price, raise the selling price, or remove the product from the assortment. The precise threshold varies by sector, but below 10% is unsustainable for most businesses once overhead is factored in.

2. Return rate per product
A 25% return rate in clothing is sector-average; a 10% return rate in electronics is already a red flag. High return rates indicate product description problems, quality issues, or the wrong target audience. Know your return rate per SKU, not just as a blended average.

3. Commission costs per channel
Compare total commission and fulfilment costs for the same product on Bol.com vs. Amazon vs. your own webshop. The platform with the lower net commission is not always the obvious one — fulfilment and storage fees change the calculation.

4. Average Order Value (AOV) per channel
A higher AOV spreads fixed costs (shipping, packaging) across more revenue, improving margin. Monitor whether upselling and bundling are improving AOV on each platform.

5. ROAS per campaign
Link ad spend to revenue per campaign. A ROAS below your threshold (which depends on your specific margin profile) should trigger campaign adjustment or suspension.

6. Inventory carrying cost per day
Products sitting on shelves (especially in Amazon FBA warehouses) accumulate storage costs. Calculate how much a slow-moving SKU costs you per day and decide when to adjust pricing or liquidate stock.

From spreadsheet to real-time dashboard

Most sellers start with an Excel or Google Sheets spreadsheet. They manually import export files from Bol.com, Amazon, and other platforms, paste data together, and use formulas to try to build an overview. This approach works until you manage two or three channels and more than 50 SKUs. After that it becomes unmanageable: data is already outdated by the time you finish the update, formula errors creep in, and you spend hours on administration that should be spent on growing your business.

What a real-time dashboard does differently:
• Automatic data import: API connections to Bol.com, Amazon, Shopify, and WooCommerce import orders, commissions, returns, and advertising costs directly — no manual exports.
• Calculation in real time: The moment an order arrives, the dashboard immediately calculates the net margin based on the configured purchase price and platform costs.
• Channel comparison: See directly on which platform the same product delivers the highest net margin. Sometimes a lower selling price on one channel paired with lower commission results in better net profit.

Consider a product you sell on both Bol.com and your own Shopify store. On Bol.com you sell it for €34.99 with a 10% commission (€3.50) and LVB fees of €4.00. On Shopify you sell it for €32.99, no commission, with own shipping of €3.95. The dashboard calculates automatically: Bol.com net = €34.99 − €8.00 purchase − €3.50 commission − €4.00 LVB = €19.49 (55.7% margin); Shopify net = €32.99 − €8.00 − €3.95 shipping = €21.04 (63.8% margin). In this case Shopify delivers more profit per unit despite the lower selling price.

These insights are invaluable for assortment and channel decisions — but they are only available when your data is automatically consolidated and updated in real time.

Automated profit & VAT insights with Winkel Factuur

Winkel Factuur provides an integrated profit & VAT dashboard built specifically for multichannel marketplace sellers. The system connects with Bol.com, Amazon, Shopify, and WooCommerce and automatically imports all order data, commissions, return costs, and advertising spend.

What the dashboard does for you:
• Margin per product: Enter your purchase price per SKU once and the dashboard continuously calculates net margin per product per channel — including all platform costs.
• VAT aggregation per EU country: The system automatically tracks revenue by EU country, calculates VAT due per quarter, and generates an OSS report ready for filing.
• Channel comparison: Compare profitability of the same product across platforms and optimise your channel mix based on actual net margin.
• Return analysis per SKU: See which products have the highest return costs and how they affect overall margin.
• Automated invoice processing: VAT invoices for marketplace commissions are automatically processed so your input VAT is correctly tracked.

The result: instead of spending hours each week maintaining spreadsheets, you open your dashboard and instantly see which products are profitable, which channels deliver the best returns, and exactly how much VAT you need to remit this quarter. No surprises at filing time.

Winkel Factuur offers a 14-day free trial with no credit card required. Plans start from €9 per month. Connect your first platform in under 5 minutes and immediately see which products are genuinely profitable.