# China Customs HS Code Classification Worksheet > Source: https://netray.co/tools/china-customs-hs-code-classification-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Record the HS code, description and declared value of each imported part and estimate duty and import VAT per line. ## Category supply-chain ## Region China ## Industry Manufacturing ## Audience - Import and export coordinator - Customs broker liaison - Buyer - Trade compliance ## Tool **Kind:** worksheet **Mode:** editable **Currency:** CNY **Columns:** #### Part number **Key:** part **Type:** text #### Description and function **Key:** desc **Type:** text #### HS code (6 digit) **Key:** hs6 **Type:** text #### China 10-digit code **Key:** hs10 **Type:** text **Help:** Fill after your broker confirms the national subheading. #### CIF value **Key:** cif **Type:** number **Format:** currency #### Duty rate **Key:** mfn **Type:** number **Unit:** % **Help:** Check the current rate for your code and origin. #### VAT rate **Key:** vat **Type:** number **Unit:** % #### Import duty **Key:** duty **Type:** number **Expr:** cif * mfn / 100 **Format:** currency #### Import VAT **Key:** vat_amt **Type:** number **Expr:** (cif + duty) * vat / 100 **Format:** currency #### Total taxes **Key:** taxes **Type:** number **Expr:** duty + vat_amt **Format:** currency #### Status **Key:** status **Type:** select **Options:** - Draft - Broker review - Confirmed - Ruling requested **Rows:** **Part:** SCR-M4-20 **Desc:** Steel screw M4 x 20, threaded fastener **Hs6:** 7318.15 **Cif:** 12000 **Mfn:** 8 **Vat:** 13 **Status:** Draft **Part:** SW-ROCK-02 **Desc:** Rocker switch for 250V equipment **Hs6:** 8536.50 **Cif:** 38000 **Mfn:** 8 **Vat:** 13 **Status:** Broker review **Part:** CBL-HRN-14 **Desc:** Wire harness with connectors, 24V **Hs6:** 8544.42 **Cif:** 86000 **Mfn:** 8 **Vat:** 13 **Status:** Draft **Part:** IC-MCU-32 **Desc:** 32-bit microcontroller, packaged **Hs6:** 8542.31 **Cif:** 240000 **Mfn:** 0 **Vat:** 13 **Status:** Confirmed **Part:** GR-SPUR-48 **Desc:** Steel spur gear, machined **Hs6:** 8483.40 **Cif:** 54000 **Mfn:** 8 **Vat:** 13 **Status:** Draft **Totals:** #### Total CIF value **Key:** cif **Agg:** sum **Format:** currency #### Total import duty **Key:** duty **Agg:** sum **Format:** currency #### Total import VAT **Key:** vat_amt **Agg:** sum **Format:** currency #### Total taxes payable **Key:** taxes **Agg:** sum **Format:** currency **Summary:** #### Effective tax rate on CIF **Key:** tax_rate **Expr:** if(gt(sum_cif,0), sum_taxes / sum_cif * 100, 0) **Format:** percent **Primary:** true #### Lines **Key:** lines **Expr:** count **Format:** integer **Notes:** The example HS 6-digit codes are standard international subheadings for the described goods, but the duty rates shown are illustrative only. Chinese import duty depends on the 8 to 10 digit national code, origin, any trade agreement and current tariff notices. Confirm every line with your customs broker or a written classification ruling. ## Content **Intro:** Misclassified goods can mean the wrong duty, delayed clearance or penalties. This worksheet gives import coordinators and buyers a single place to keep each part's HS code, declared value, and the resulting duty and VAT estimate in China. **Sections:** #### How to use the worksheet **Body:** Add one row per distinct part or family. Enter a clear description of what the item is and what it does, the 6-digit HS code you believe applies, and the CIF value. Enter the duty and VAT rates after checking them for the code and origin. The sheet calculates duty on CIF and import VAT on CIF plus duty. When your broker confirms the national 10-digit code, add it and change the status. Export the sheet to Excel to send to the broker. #### The calculation behind it **Body:** For imports into China, customs duty is generally calculated as the dutiable value (CIF) multiplied by the duty rate. Import VAT is then charged on the sum of the dutiable value, duty and any consumption tax, at the applicable VAT rate, which is 13% for most goods. Consumption tax applies to a limited list of goods and is not included here. Preferential origin rates, anti-dumping duties or additional tariffs would change the result and should be checked separately. **Bullets:** - Duty = CIF value x duty rate - Import VAT = (CIF value + duty) x VAT rate - Total taxes = duty + import VAT #### Classification principles **Body:** The HS system classifies by what a product is, how it is made and what it does, following General Rules of Interpretation. The first six digits are common worldwide. National extensions add detail and carry the rate. Customs also asks for declaration elements such as brand, model, material and use, so descriptions should contain these facts. Keep supplier datasheets and photos with the worksheet as support in case of query. #### Common mistakes and ERP notes **Body:** Frequent errors are using the supplier's code without checking it, describing parts too vaguely, applying the same code to different variants and forgetting to update codes after annual tariff changes. In an ERP, store the HS code on the item or the item-plant record, use a versioned table for rates, and block shipment documents when the code is blank. SAP GTS, Oracle GTM and Infor tools can hold this, and a simple custom field is the minimum. **Cta:** If HS codes and duty rates are maintained in separate spreadsheets from your item master, Netray can help sync them into your ERP with version history and review by trade compliance. **Faq:** #### Which HS code do I use for China, 6 or 10 digits? **Answer:** The first six digits follow the international Harmonized System. China adds further digits for national subheadings, typically eight, and uses ten digits for customs declarations. The duty rate and regulatory conditions attach to the national code, so you need the full code for a declaration. #### How do I confirm the correct classification? **Answer:** Ask your customs broker, check the official tariff schedule, or apply for an advance classification ruling from customs for stable, high-volume parts. Keep datasheets, drawings and test reports. Do not rely on the supplier's code alone. #### Is VAT calculated on CIF or CIF plus duty? **Answer:** Import VAT is generally calculated on the dutiable value plus customs duty (and consumption tax where it applies), so duty is included in the VAT base. This worksheet follows that method. Check specific cases with your broker. #### Can I use this for exports from China? **Answer:** You can use it to record the HS code and value, but the duty and VAT columns are for imports. For exports, the relevant calculation is the export VAT refund or exemption, which depends on the product's refund rate and the supplier's fapiao amount. ## Search terms china hs code worksheet, china customs classification template, hs code list excel china, china import duty vat calculation excel, hs code classification worksheet, china customs declaration elements, china import tariff worksheet, hs code mapping for erp --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json