# USMCA BOM Regional Value Content Worksheet

> Source: https://netray.co/tools/usmca-bom-regional-value-content-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List BOM components, flag non-originating materials and see the estimated regional value content before you certify origin.

## Category

compliance-legal

## Region

North America

## Industry

Nearshoring Manufacturing

## Audience

- Trade compliance specialist
- Cost accountant
- Supply chain manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Component

**Key:** comp

**Type:** text

#### HTS or fraccion (6 digit)

**Key:** hts

**Type:** text

#### Source country

**Key:** source

**Type:** select

**Options:**

- US
- MX
- CA
- CN
- DE
- JP
- KR
- Other

#### Value per unit

**Key:** value

**Type:** number

**Format:** currency

**Help:** Value of the material as used in the good, on the basis your rule requires.

#### Non-originating (1 yes, 0 no)

**Key:** nonorig

**Type:** number

**Help:** Enter 1 if the material does not qualify as originating, otherwise 0.

#### Non-originating value

**Key:** vnm

**Type:** number

**Expr:** value * nonorig

**Format:** currency

#### Tariff shift met

**Key:** shift

**Type:** select

**Options:**

- Yes
- No
- Not applicable

**Rows:**

**Comp:** Machined housing

**Hts:** 7616.99

**Source:** MX

**Value:** 18.5

**Nonorig:** 0

**Shift:** Not applicable

**Comp:** Control board assembly

**Hts:** 8537.10

**Source:** CN

**Value:** 42

**Nonorig:** 1

**Shift:** No

**Comp:** Wire harness

**Hts:** 8544.42

**Source:** US

**Value:** 9.8

**Nonorig:** 0

**Shift:** Not applicable

**Comp:** Fasteners kit

**Hts:** 7318.15

**Source:** KR

**Value:** 2.1

**Nonorig:** 1

**Shift:** Yes

**Comp:** Gasket set

**Hts:** 4016.93

**Source:** CA

**Value:** 3.4

**Nonorig:** 0

**Shift:** Not applicable

**Totals:**

#### Total material value

**Key:** value

**Agg:** sum

**Format:** currency

#### Total non-originating value

**Key:** vnm

**Agg:** sum

**Format:** currency

**Summary:**

#### Estimated RVC on material value basis

**Key:** rvc

**Expr:** (sum_value - sum_vnm) / sum_value * 100

**Format:** percent

**Primary:** true

#### Non-originating share of material value

**Key:** margin_net

**Expr:** sum_vnm / sum_value * 100

**Format:** percent

**Notes:** Screening tool only. USMCA product-specific rules may use tariff shift, regional value content by transaction value or net cost, de minimis, or a combination, and RVC thresholds vary by good. This sheet uses material value as entered and is not a certification. Confirm the rule and calculation with a trade specialist.

## Content

**Intro:** To claim USMCA preference, a good must meet its product-specific rule of origin. Where the rule uses regional value content, you need a bill of materials with each component's origin and value. This worksheet puts those facts in one table and shows the resulting percentage.

**Sections:**

#### How to use it

**Body:** Export the single-level or indented BOM from your ERP, then list each purchased component with its tariff code, source country and value. Flag materials that are not originating. The sheet subtracts the non-originating value from the total and shows the estimated regional value content. Use the tariff shift column to record the result of the change in tariff classification test where your rule uses it.

**Bullets:**

- Use the BOM at the level your product-specific rule applies to
- Check originating status of purchased components with supplier declarations
- Keep values on a consistent basis for every line
- Keep the completed sheet with your certification records

#### The method behind it

**Body:** The general idea of regional value content is that a share of the value must come from the free trade area. Under transaction value the formula is the transaction value minus the value of non-originating materials, divided by transaction value. The net cost method uses net cost instead and has its own exclusions. The required percentage depends on the good and the method, so you must read the rule for your heading.

#### Reading the result

**Body:** If the percentage clearly exceeds the threshold from your rule, document the analysis and retain it. If it is close, check each non-originating line for a cheaper originating alternative, since one control board sourced from Mexico or the US can shift the number. Also check whether other tests, such as tariff shift, offer a simpler route.

#### Common mistakes

**Body:** Using the selling price where the rule needs a specific valuation, treating a supplier's country of shipment as country of origin, and forgetting intermediate materials that are themselves non-originating. Also common is relying on a stale analysis after a supplier or BOM change, so re-run it whenever the BOM revision changes.

**Cta:** Netray can help pull BOM revisions, supplier origin declarations and costs from your ERP so origin analysis is refreshed when parts change.

**Faq:**

#### Does this certify USMCA origin?

**Answer:** No. It is a screening worksheet. Origin depends on the specific rule for the tariff heading, the valuation method and documentation from suppliers. The certifying party remains responsible, so confirm with a qualified trade professional.

#### Which regional value content method should I use?

**Answer:** Where the rule gives a choice, the method that yields a pass with the least effort and best data is usually used. Transaction value and net cost need different inputs, so check which values your costing system can support.

#### What records should I keep?

**Answer:** Keep the BOM, supplier declarations, the calculation, the rule applied and the certification for the period required by the rules. Your trade advisor can confirm the retention period for your situation.

#### Can a Chinese component still allow qualification?

**Answer:** Sometimes. A non-originating material can be allowed if the product meets a tariff shift, the RVC threshold, or a de minimis allowance. It depends on the rule for your product, so test each scenario.

## Search terms

usmca regional value content worksheet, usmca rvc calculation excel, usmca bom origin analysis, non-originating materials worksheet, usmca qualification worksheet, net cost method rvc, usmca tariff shift analysis template, usmca origin determination template

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