Syntha Lab RU

Landed cost calculation

One row per batch SKU: quantity, FOB price, rate, freight, insurance, duty, broker and other costs. The output is customs value, duty and full unit cost.

Layouts for documents 14 columns 2 example rows

Download CSV ↓

What the template is for

Calculating the unit price in stock before setting the retail price.

What one row is
one row = a SKU in a batch

Columns

ColumnCodeTypeRequiredValidation rule
Style SKUarticleTextyesa value from the product reference
Heading (customs code, 4 digits)hsTextyesconfirm the classification with the declarant
Quantity, unitsqtyIntegeryesan integer not below 1
FOB price per unit (in currency)fobNumberyesa number not below 0
CurrencycurList valueyesan ISO 4217 currency code
Rate to the roublefxNumberyesa number not below 0
Freight for the batch, RUBfreightNumberyesa number not below 0
Insurance for the batch, RUBinsNumberyesa number not below 0
Duty rate, %dutyNumberyesfrom 0 to 100
Broker and fees, RUBbrokerNumberyesa number not below 0
Other costs, RUBotherNumberyesa number not below 0
Customs value, RUBcvNumberyescalculated: quantity × FOB × rate + freight + insurance
Duty, RUBdutyAmtNumberyescalculated: customs value × rate ÷ 100
Full unit cost, RUBlandedNumberyescalculated: (customs value + duty + broker + other) ÷ quantity; recoverable import VAT is not included

Example rows

Style SKUHeading (customs code, 4 digits)Quantity, unitsFOB price per unit (in currency)CurrencyRate to the roubleFreight for the batch, RUBInsurance for the batch, RUBDuty rate, %Broker and fees, RUBOther costs, RUBCustoms value, RUBDuty, RUBFull unit cost, RUB
A100620260028.5CNY12.6310,0009,2001254,00018,000534,66064,1591,118.03
B200640340022USD91.5280,0007,8001041,00015,0001,093,000109,3003,145.75

The example data is illustrative: an exercise, replace it with your own.

Note

Duty rates, the customs value base and the treatment of fees depend on the goods, the country of origin and the rules in force: check them with a broker. Take the rate on the date set in the accounting policy. The example data is illustrative: an exercise, not a norm or an industry benchmark.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →