Kolumn

02 / 20 · Purchasing and stock

Landed cost calculator

What a product really costs once it is in your warehouse.

SEK 149

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Work out what each item in a shipment really costs once it is in your warehouse: goods value, freight, insurance, duty, fees and inland freight. Freight and fees are allocated by goods value. Import VAT is shown separately because VAT-registered businesses can normally reclaim it.

What you get

Sheets
Calculator
Each file also has an instructions sheet and a lists sheet.
Formulas
209
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Enter the shipment details at the top: exchange rate, total freight, insurance, fees and inland freight.
  2. Add one row per item with quantity, unit price in the supplier's currency and duty rate.
  3. Look up the duty rate in the EU tariff (TARIC) or your own country's tariff using the commodity code. Always check the current rate.
  4. The Landed cost/unit column is what you should calculate margin on (excl. VAT).