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.
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
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Style SKU | article | Text | yes | a value from the product reference |
| Heading (customs code, 4 digits) | hs | Text | yes | confirm the classification with the declarant |
| Quantity, units | qty | Integer | yes | an integer not below 1 |
| FOB price per unit (in currency) | fob | Number | yes | a number not below 0 |
| Currency | cur | List value | yes | an ISO 4217 currency code |
| Rate to the rouble | fx | Number | yes | a number not below 0 |
| Freight for the batch, RUB | freight | Number | yes | a number not below 0 |
| Insurance for the batch, RUB | ins | Number | yes | a number not below 0 |
| Duty rate, % | duty | Number | yes | from 0 to 100 |
| Broker and fees, RUB | broker | Number | yes | a number not below 0 |
| Other costs, RUB | other | Number | yes | a number not below 0 |
| Customs value, RUB | cv | Number | yes | calculated: quantity × FOB × rate + freight + insurance |
| Duty, RUB | dutyAmt | Number | yes | calculated: customs value × rate ÷ 100 |
| Full unit cost, RUB | landed | Number | yes | calculated: (customs value + duty + broker + other) ÷ quantity; recoverable import VAT is not included |
Example rows
| Style SKU | Heading (customs code, 4 digits) | Quantity, units | FOB price per unit (in currency) | Currency | Rate to the rouble | Freight for the batch, RUB | Insurance for the batch, RUB | Duty rate, % | Broker and fees, RUB | Other costs, RUB | Customs value, RUB | Duty, RUB | Full unit cost, RUB |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A100 | 6202 | 600 | 28.5 | CNY | 12.6 | 310,000 | 9,200 | 12 | 54,000 | 18,000 | 534,660 | 64,159 | 1,118.03 |
| B200 | 6403 | 400 | 22 | USD | 91.5 | 280,000 | 7,800 | 10 | 41,000 | 15,000 | 1,093,000 | 109,300 | 3,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
- Landed cost of an imported item
- Landed cost by style: spreading the shipment
- Price, markup and margin
- Exchange rate and duty scenario: what happens to margin
- Import from the EAEU or from a third country: duty, VAT and the full cost
- Customs value and Incoterms
- Export to the EAEU: zero VAT, refund and the price of waiting
- A payment to a foreign supplier: full cost, timing and exchange-rate risk
Documents that need this data
- Price list and costing (landed cost)
- Foreign trade and customs: HS code, customs value, duty, import VAT, landed cost, currency control
- Sourcing from factories: CMT, FOB, OEM/ODM, full cost and lead times
- The swatch and trim card and the materials order: the composition of the card, consumption, losses and shrinkage, packing and the minimum lot, the order date, approval and the table template
- Denim: fabric consumption with shrinkage, washing and finishing, the garment price by stage
- Duties, anti-dumping, preferences and origin: what makes up the import price
- Operating in the EAEU for a brand and a retailer: country, form of presence, tax, payments, marking, first 90 days
- Factory countries: China, Turkey, Uzbekistan, Kyrgyzstan, Belarus, Russia: lead time, MOQ, cost, risks, documents
- Price and landed cost for the CIS: recalculating the price for a country, VAT, logistics, currency risk
- Entering the markets of Armenia and Kyrgyzstan: form of presence, contract, tax, marking, certification, payments, warehouse, support
- Entering the market of Belarus: form of presence, contract, tax, marking, certification, payments, warehouse, support
- Entering the market of Kazakhstan: form of presence, contract, tax, marking, certification, payments, warehouse, support