ResourcesFree Resource

Costs & Prices Spreadsheet for E-commerce

Calculate the real price of each product considering VAT, marketplace commissions and your target margin — so you don't sell at a loss.

What's included

What does the spreadsheet include?

Sales and revenue log

Register sales by channel and apply 19% VAT automatically to calculate your real net revenue.

Fixed and variable expense control

Register rent, salaries, platforms and logistics. The impact on your margin is calculated automatically.

Selling-price calculator

Enter cost and target margin. The spreadsheet calculates the minimum price considering all commissions.

Who it's for

Who is this spreadsheet for?

If you identify with any of these situations, you need it.

01

You set prices by looking at the competition

You're not sure if your price covers all your real costs or if you're selling at a negative margin.

→ This spreadsheet helps with this
02

At month's end you find you earned less than expected

Sales went up but the cash doesn't reflect what you expected. Something doesn't add up.

→ This spreadsheet helps with this
03

You don't know exactly how much it costs to sell on Mercado Libre or Shopify

Commissions and shipping eat your margin and you never calculate them before setting the price.

→ This spreadsheet helps with this
Let's talk

Prefer we do it for you?

Leave us your details and we'll show you how Amplifica automates the fulfillment, inventory and dispatches of your e-commerce.

  • Reply within 24 business hours
  • No commitment or contracts
  • A specialist reviews your operation