# EU Customs Value and Import Duty Line Worksheet > Source: https://netray.co/tools/eu-customs-value-line-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet that builds customs value, duty and import VAT for each shipment line and totals them for a declaration or landed cost check. ## Category regional ## Region European Union ## Industry Manufacturing ## Audience - Customs specialist - Buyer - Logistics manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** EUR **Columns:** #### Item **Key:** item **Type:** text #### HS / CN code **Key:** hs **Type:** text #### Origin **Key:** origin **Type:** text #### Incoterm **Key:** incoterm **Type:** select **Options:** - EXW - FCA - FOB - CIF - CIP - DAP - DDP #### Goods value **Key:** goods **Type:** number **Format:** currency #### Freight to EU border **Key:** freight **Type:** number **Format:** currency #### Insurance to EU border **Key:** insurance **Type:** number **Format:** currency #### Duty rate (%) **Key:** duty_rate **Type:** number **Format:** number #### VAT rate (%) **Key:** vat_rate **Type:** number **Format:** number #### Customs value **Key:** cv **Type:** number **Expr:** goods + freight + insurance **Format:** currency #### Duty **Key:** duty **Type:** number **Expr:** cv * duty_rate / 100 **Format:** currency #### Import VAT **Key:** vat **Type:** number **Expr:** (cv + duty) * vat_rate / 100 **Format:** currency **Rows:** **Item:** CNC spindle motor **Hs:** 8501 52 **Origin:** CN **Incoterm:** FOB **Goods:** 18500 **Freight:** 920 **Insurance:** 75 **Duty rate:** 2.7 **Vat rate:** 19 **Item:** Steel fasteners M8 **Hs:** 7318 15 **Origin:** IN **Incoterm:** CIF **Goods:** 6400 **Freight:** 0 **Insurance:** 0 **Duty rate:** 3.7 **Vat rate:** 19 **Item:** Aluminium extrusions **Hs:** 7604 21 **Origin:** AE **Incoterm:** FCA **Goods:** 22000 **Freight:** 1350 **Insurance:** 110 **Duty rate:** 7.5 **Vat rate:** 19 **Item:** PCB assemblies **Hs:** 8537 10 **Origin:** VN **Incoterm:** FOB **Goods:** 31200 **Freight:** 1480 **Insurance:** 160 **Duty rate:** 2.1 **Vat rate:** 19 **Item:** Hydraulic hose **Hs:** 4009 22 **Origin:** TR **Incoterm:** EXW **Goods:** 5200 **Freight:** 640 **Insurance:** 40 **Duty rate:** 0 **Vat rate:** 19 **Totals:** #### Total goods value **Key:** goods **Agg:** sum **Format:** currency #### Total customs value **Key:** cv **Agg:** sum **Format:** currency #### Total duty **Key:** duty **Agg:** sum **Format:** currency #### Total import VAT **Key:** vat **Agg:** sum **Format:** currency **Summary:** #### Duty as percent of customs value **Key:** duty_pct **Expr:** if(gt(sum_cv, 0), sum_duty / sum_cv * 100, 0) **Format:** percent **Primary:** true #### Total due at the border **Key:** border **Expr:** sum_duty + sum_vat **Format:** currency **Primary:** true #### Customs value uplift over goods value **Key:** uplift **Expr:** if(gt(sum_goods, 0), (sum_cv - sum_goods) / sum_goods * 100, 0) **Format:** percent **Notes:** Example rates are illustrative. Look up the CN code and applicable third country duty in the EU TARIC database, and use the VAT rate of the member state of import. Where the Incoterm already includes freight and insurance to the border (CIF, CIP, DAP, DDP), leave those columns at zero to avoid double counting. ## Content **Intro:** EU customs value is the transaction value of the goods plus transport and insurance costs up to the point where they enter the EU. This worksheet applies that to each shipment line, adds duty and import VAT, and totals the border payment so buyers and customs specialists can check a broker's quote. **Sections:** #### How to use the worksheet **Body:** Enter one row per item or tariff line. Add the invoice value, then freight and insurance up to the EU border, leaving those columns at zero when your Incoterm already includes them. Type the duty rate for the CN code and the VAT rate of the member state of import. The customs value, duty and VAT columns calculate automatically, and the totals update. Export to Excel or CSV to attach to your purchase file. **Bullets:** - One row per tariff line or commodity code - Use the transaction value from the invoice - Freight and insurance only to the EU border - Duty rate from TARIC, VAT from the importing member state #### The valuation rules **Body:** The Union Customs Code sets the transaction value as the primary method. Adjustments add items such as commissions, packing, royalties tied to the sale, and assists like tooling supplied free to the seller. Transport and insurance to the EU border are added, while charges after arrival and duties themselves are excluded. Import VAT is based on the customs value plus duty and other charges up to the first destination. #### Reading the totals **Body:** The uplift line shows how far freight and insurance push customs value above the invoice, which is a quick sanity check for broker invoices. The duty percentage shows the blended duty burden across the lines. Compare the border total with the broker's debit note and investigate any gap, because classification and valuation errors are the most common causes of overpayment. #### Common mistakes **Body:** Frequent errors are adding freight twice with CIF terms, leaving out royalties or assists, using the supplier country instead of the origin for preferential rates, and applying VAT to goods value only. Keep supporting documents such as the invoice, transport bill and origin proof with the worksheet. **Cta:** Netray can generate customs value lines from purchase orders and receipts in your ERP so the worksheet is filled by data, not typing. Ask for a review. **Faq:** #### What is included in EU customs value? **Answer:** The transaction value, plus transport and insurance costs to the point of entry into the EU, plus adjustments such as royalties tied to the sale, commissions, packing and assists. Duty and costs after arrival are excluded. #### Should I add freight if the Incoterm is CIF? **Answer:** No. CIF already includes freight and insurance to the destination port, so the invoice value is close to the customs value. Leave the freight and insurance columns at zero to avoid counting them twice. #### Where do I find the duty rate? **Answer:** In the EU TARIC database, by CN code and country of origin. Preferential or zero rates may apply under trade agreements if you hold valid proof of origin. #### Can I export this to Excel? **Answer:** Yes. Every worksheet exports to Excel and CSV, and the calculated columns are included, so you can attach it to a shipment file or send it to your broker. ## Search terms eu customs value worksheet, customs valuation excel template, eu import duty calculation excel, customs value cif eu border, import vat per line worksheet, customs declaration line calculator, eu duty and vat spreadsheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json