XLSX · Excel · Marketplace

Allegro profitability calculator: work out the profit on every listing

Work out the profit per unit after commission, Smart, delivery, advertising and tax. Excel without macros, ready in 10 minutes.

Who it is for: Manufacturers and brands that sell on Allegro or plan to start.

XLSX · Excel

What is in the file

XLSXAllegro profitability calculator

The calculator works out the profit on each product after commission (with thresholds and the cap), the Smart surcharge, advertising and tax. It shows the advertising break-even point for every listing. You see which listings earn money and which make a loss.

Parameters
VAT, form of taxation (CIT 9%/19%, flat-rate PIT, tax scale, lump-sum tax), target ROAS, Allegro Ads budget, CPC, conversion, promotion fees, Smart surcharge table.
Allegro price list
46 category groups with the commission, the threshold amount, the rate above the threshold and the commission cap. Rates are editable and dated.
Products
A list of up to 50 products with purchase, transport and packing costs.
Calculator
Commission with thresholds and the cap, effective commission rate, Smart surcharge by basket value, profit and margin before and after advertising, profit after tax, break-even ROAS, a variant for a promoted listing, and a rating with a hint on what to do.
The “units per transaction” field
For products bought several at a time (decking boards, tiles, lamps in a set). Without this field the calculator understates the basket value from advertising.
Allegro Ads
Budget split by product, clicks, transactions, the ROAS achieved, profit after advertising, the maximum CPC and the minimum conversion at break-even.
What next
How to read the result and how to hand us the file for a review.