# Mexico Pedimento Import Line Duty Worksheet

> Source: https://netray.co/tools/mexico-pedimento-import-line-duty-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Plan import lines for a Mexican pedimento with fraccion, origin, value, IGI and IVA estimates, then export the table to Excel.

## Category

regional

## Region

Mexico

## Industry

Nearshoring Manufacturing

## Audience

- Customs coordinator
- Logistics manager
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Fraccion arancelaria

**Key:** fraccion

**Type:** text

**Help:** Eight digit tariff fraction from the Mexican TIGIE, confirmed with your customs broker.

#### Origin

**Key:** origin

**Type:** select

**Options:**

- US
- CN
- DE
- JP
- KR
- TW
- Other

#### Qty

**Key:** qty

**Type:** number

#### Unit customs value

**Key:** unit_value

**Type:** number

**Format:** currency

#### Line value

**Key:** value

**Type:** number

**Expr:** qty * unit_value

**Format:** currency

#### IGI rate

**Key:** igi_pct

**Type:** number

**Unit:** %

**Help:** General import duty rate. Enter 0 where a trade agreement or program applies and is documented.

#### IGI estimate

**Key:** igi

**Type:** number

**Expr:** value * igi_pct / 100

**Format:** currency

#### IVA 16% estimate

**Key:** iva

**Type:** number

**Expr:** (value + igi) * 0.16

**Format:** currency

#### Duty plus tax

**Key:** landed

**Type:** number

**Expr:** igi + iva

**Format:** currency

**Rows:**

**Part:** BRK-1001

**Fraccion:** 73181599

**Origin:** US

**Qty:** 5000

**Unit value:** 0.42

**Igi pct:** 0

**Part:** CTL-2210

**Fraccion:** 85371099

**Origin:** CN

**Qty:** 120

**Unit value:** 86.5

**Igi pct:** 10

**Part:** HSG-0045

**Fraccion:** 76169999

**Origin:** DE

**Qty:** 800

**Unit value:** 12.2

**Igi pct:** 10

**Part:** CBL-7781

**Fraccion:** 85444999

**Origin:** KR

**Qty:** 2400

**Unit value:** 3.15

**Igi pct:** 5

**Totals:**

#### Total customs value

**Key:** value

**Agg:** sum

**Format:** currency

#### Total IGI

**Key:** igi

**Agg:** sum

**Format:** currency

#### Total IVA

**Key:** iva

**Agg:** sum

**Format:** currency

#### Total duty and tax

**Key:** landed

**Agg:** sum

**Format:** currency

**Summary:**

#### Duty and tax as share of value

**Key:** burden

**Expr:** sum_landed / sum_value * 100

**Format:** percent

**Primary:** true

#### Import lines

**Key:** lines

**Expr:** count

**Format:** integer

**Notes:** Planning estimate only. The real pedimento also carries DTA, prevalidation and other fees, and IVA can be creditable. Rates, fractions and program treatment (IMMEX, PROSEC, USMCA) must be confirmed by your licensed customs broker.

## Content

**Intro:** Before a shipment crosses into Mexico, the logistics team and the customs broker need one agreed list of lines, tariff fractions, origins and values. This worksheet is that list, with duty and IVA estimates so the controller can budget cash for the entry.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per invoice line or per tariff fraction. Enter the quantity, the unit customs value and the IGI rate your broker quoted for the fraccion arancelaria. The sheet multiplies value by rate for IGI, then adds IVA at 16 percent on value plus IGI. Export to Excel and send it to the broker as a pre-alert so they can compare it with their own classification work.

**Bullets:**

- One row per fraccion, not per carton
- Use the invoice currency converted at the rate the broker will apply
- Set IGI to 0 only when a documented program or treaty applies
- Keep the origin column accurate because it drives preferential treatment

#### The method behind the numbers

**Body:** Mexican import taxes build up in a fixed order. The customs value is the base, the IGI (impuesto general de importacion) is a percentage of that base, and IVA is calculated on the customs value plus IGI plus certain fees. Under an IMMEX program, temporary imports of inputs can defer or credit IVA through a certification, so the cash effect differs from a definitive import. This sheet shows the definitive-import case, which is the conservative budget figure.

#### Reading the result

**Body:** The duty and tax share shows how much of the shipment value you must fund at entry. A line from a country without a trade agreement can sit well above a US-origin line even for the same part type. If the share looks high, review whether the part qualifies for a sector program or whether a US-origin supplier is a realistic alternative.

#### Common mistakes

**Body:** Teams often use the commercial invoice price when the customs value must include freight and insurance to the border under the valuation rules, or forget that the same part from two origins needs separate lines. Another common error is copying a fraccion from last year's pedimento without checking whether the TIGIE changed. Also avoid mixing units of measure between the invoice and the tariff fraction.

**Cta:** If your ERP already holds parts, origins and values, Netray can generate this pre-alert directly from purchase orders so the broker receives clean data each time.

**Faq:**

#### Does this replace my customs broker?

**Answer:** No. A licensed Mexican customs broker (agente aduanal) classifies goods, files the pedimento and takes legal responsibility. This worksheet only organizes the data and gives a budget estimate you can compare with the broker's quote.

#### Why is IVA calculated on value plus IGI?

**Answer:** The IVA base on imports includes the customs value and the duties paid, plus certain fees. This sheet uses value plus IGI as a simple approximation. Your broker's final figure may also include DTA and other items in the base.

#### Can I use it for IMMEX temporary imports?

**Answer:** You can list the lines, but the tax treatment differs. Under IMMEX, inputs imported temporarily may be IVA-certified or subject to a credit mechanism. Use the sheet to see the definitive-import exposure and discuss the program treatment with your advisor.

#### How do I send it to my broker?

**Answer:** Use the Excel or CSV export and attach it to your pre-alert email with the commercial invoice and packing list. Brokers usually prefer one row per tariff fraction with origin and value on the same line.

## Search terms

pedimento worksheet, mexico import duty calculator excel, fraccion arancelaria worksheet, IGI IVA import calculation mexico, mexico customs entry template, pedimento de importacion lines, mexico import cost sheet, customs broker pre-alert template

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