Softwarekompass

Softwarekompass compares software for the German market: prices, marketplace fees and tax rules (e.g. the margin scheme under § 25a of the German VAT Act) refer to Germany.

Excel template: multichannel sales overview

Which channel really makes money? Record orders from Amazon, eBay, Kaufland, OTTO and your shop – the template shows revenue, fees and contribution margin per channel and month.

Download for free (.xlsx)No registration · Excel, LibreOffice and Google Sheets · As of 27 Oct 2026

What's in the template

Sheet

Sales

Date, channel (drop-down list), order number, item, quantity, gross revenue, VAT rate, cost of goods, fees, shipping – month, net revenue and contribution margin are calculated.

Sheet

Analysis

Orders, net revenue, fees, contribution margin, CM ratio and revenue share per channel, filterable by month, with bar chart.

In three steps

  1. Enter orders or paste marketplace exports
  2. Optionally choose a month in the analysis
  3. Compare channels by contribution margin

You fill in the yellow fields; the template calculates the grey ones. You can overwrite the example rows.

Frequently asked questions

Can I paste exports from Amazon or eBay?

Yes, if you put the columns in the order of the template. It's easier with multichannel software that merges all orders automatically.