# China Supplier Quote Comparison Worksheet (VAT Adjusted)

> Source: https://netray.co/tools/china-supplier-quote-comparison-vat-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compare quotes from Chinese suppliers on a like-for-like ex-VAT basis, including MOQ value, tooling and lead time.

## Category

supply-chain

## Region

China

## Industry

Manufacturing

## Audience

- Buyer
- Sourcing manager
- Procurement analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** CNY 

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### City

**Key:** city

**Type:** text

#### Quoted terms

**Key:** incoterm

**Type:** select

**Options:**

- EXW
- FCA
- FOB
- CIF
- DDP

#### Quoted unit price (incl. VAT)

**Key:** price_incl

**Type:** number

**Format:** currency

#### VAT rate (%)

**Key:** vat

**Type:** number

#### Unit price ex-VAT

**Key:** price_ex

**Type:** number

**Expr:** price_incl / (1 + vat / 100)

**Format:** currency

#### MOQ

**Key:** moq

**Type:** number

**Format:** integer

#### MOQ order value ex-VAT

**Key:** moq_value

**Type:** number

**Expr:** price_ex * moq

**Format:** currency

#### Tooling charge

**Key:** tooling

**Type:** number

**Format:** currency

#### First order cost

**Key:** first_order

**Type:** number

**Expr:** price_ex * moq + tooling

**Format:** currency

#### Lead time (days)

**Key:** lead

**Type:** number

**Format:** integer

**Rows:**

**Supplier:** Dongguan Precision Parts

**City:** Dongguan

**Incoterm:** EXW

**Price incl:** 14.35

**Vat:** 13

**Moq:** 2000

**Tooling:** 18000

**Lead:** 35

**Supplier:** Ningbo Metal Works

**City:** Ningbo

**Incoterm:** FOB

**Price incl:** 13.9

**Vat:** 13

**Moq:** 5000

**Tooling:** 12000

**Lead:** 40

**Supplier:** Suzhou Machining Co

**City:** Suzhou

**Incoterm:** EXW

**Price incl:** 15.2

**Vat:** 13

**Moq:** 1000

**Tooling:** 22000

**Lead:** 28

**Supplier:** Wenzhou Small Shop

**City:** Wenzhou

**Incoterm:** EXW

**Price incl:** 12.8

**Vat:** 3

**Moq:** 3000

**Tooling:** 9000

**Lead:** 45

**Supplier:** Tianjin Fabrication

**City:** Tianjin

**Incoterm:** FCA

**Price incl:** 14.1

**Vat:** 13

**Moq:** 2500

**Tooling:** 15000

**Lead:** 38

**Totals:**

#### Sum of first order cost

**Key:** first_order

**Agg:** sum

**Format:** currency

#### Lowest ex-VAT unit price

**Key:** price_ex

**Agg:** min

**Format:** currency

#### Shortest lead time

**Key:** lead

**Agg:** min

**Format:** integer

**Summary:**

#### Average ex-VAT unit price

**Key:** avg_price

**Expr:** avg_price_ex

**Format:** currency

#### Spread between highest and lowest

**Key:** spread

**Expr:** (max_price_ex - min_price_ex) / min_price_ex * 100

**Format:** percent

**Notes:** Compare quotes on the same Incoterm before ranking. Mainland general taxpayers usually quote at 13 percent VAT for goods, while small-scale taxpayers may quote around 3 percent, so a lower sticker price can hide a lack of deductible input VAT for the buyer. Export buyers should confirm whether the quote includes VAT and whether the exporter can claim the refund.

## Content

**Intro:** Quotes from Chinese suppliers arrive in different formats: some include 13 percent VAT, some do not, and Incoterms, tooling and MOQ differ. This worksheet normalizes them so a buyer can compare real cost.

**Sections:**

#### How to use it

**Body:** Add one row per supplier. Enter the quoted unit price, the VAT rate included in that price, the MOQ, any tooling charge and the lead time. The sheet removes VAT to show an ex-VAT unit price, then calculates the MOQ order value and the first order cost, which is price times MOQ plus tooling. If a quote is already ex-VAT, set the VAT rate to zero. Add rows with the button, delete those you do not need, and export the final table to Excel for your RFQ file.

#### Why VAT-adjusted comparison matters

**Body:** In China, general VAT taxpayers charge 13 percent on most manufactured goods, while small-scale taxpayers use a simplified rate that has often been 3 percent. Quoted prices may or may not include these. Comparing a VAT-inclusive quote to an ex-VAT quote overstates the cost gap by more than 10 percent. For export business, domestic VAT is generally neutralized by the refund or exemption system, so the economic base is the ex-VAT price.

**Bullets:**

- Ex-VAT price = quoted price / (1 + VAT rate)
- First order cost = ex-VAT price x MOQ + tooling
- Always compare on one Incoterm
- Ask for the special fapiao if input VAT matters

#### Reading the result and common mistakes

**Body:** The lowest unit price is rarely the cheapest first order, because tooling and MOQ push cost up. A supplier with a slightly higher price and low MOQ can win for pilot runs. Mistakes include comparing EXW to FOB, forgetting freight and duty after the comparison, ignoring payment terms, treating a tooling charge as free when the supplier keeps the mold, and not recording the quote date. Use the lead time column to flag suppliers that cannot meet the schedule.

**Cta:** If quotes and approved vendors live in your ERP, Netray can help turn this comparison into a repeatable sourcing report. We can build it privately on your own side.

**Faq:**

#### What VAT rate should I enter?

**Answer:** Use the rate shown on the quote or the supplier's taxpayer status. Many goods are at 13 percent for general taxpayers, and small-scale taxpayers may charge a reduced simplified rate. Ask the supplier to state it.

#### Why does the sheet include tooling in the first order?

**Answer:** Tooling is often paid upfront and affects cash and break-even volume. Including it in the first order cost prevents a cheap unit price from hiding a large tooling charge.

#### Can I add extra columns?

**Answer:** The worksheet has fixed columns, but you can export to Excel and add freight, duty, payment terms and quality scores. Keep the VAT-adjusted base so later changes remain comparable.

#### Should I compare different Incoterms?

**Answer:** Only after adding the cost to bring them to the same point. EXW excludes export clearance and freight, while DDP includes almost everything. Convert before ranking.

## Search terms

supplier quote comparison excel, china supplier comparison template, bid comparison worksheet, ex vat price china quote, moq tooling first order cost, rfq comparison spreadsheet, china sourcing quote analysis

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json