What Is a Tariff Comparison Matrix, and Why Replace Spreadsheets?
What changed: The Parts Library is described as it runs today: the FTA Compare Drawer and the FTA world map are switched off, the Valuation Sanity Check is not a product feature and uploads take up to 100 rows, so FTA preferences and declared values are checked separately; Section 122 is no longer listed among current rates; USMCA use updated to 80.2% (July 2026).
A tariff comparison matrix is a grid that places your products on one axis and your candidate sourcing countries on the other, then fills every cell with the full landed duty cost for that product-country pair. It lets a sourcing team read duty exposure across an entire product line at once, instead of one lookup at a time.
Why does a tariff comparison matrix replace spreadsheets?
A spreadsheet holds one product per tab and goes stale the moment a tariff rate changes. A tariff comparison matrix recalculates every cell against live Section 301 (the forced-labor duties included) and Section 232 rates, so the whole grid stays current.
TL;DR
A tariff comparison matrix is an N×M grid: N products as rows, M sourcing countries as columns, with the complete landed duty cost in every cell. It answers one question that spreadsheets cannot, which country is cheapest for each SKU right now, given a tariff stack that changed three times in 2026 alone. GingerControl builds this as a live tool called Parts Library: upload thousands of SKUs, see row-best and global-best cells highlighted green, and click any cell to expand the full duty stack. Unlike a spreadsheet, every rate is current and every selection is logged for audit.
Review tariff comparison spreadsheet errors before extending an origin comparison beyond the codes and duty layers the sheet can reliably maintain.
Why the spreadsheet model breaks
For years, sourcing teams modeled duty cost in Excel. One tab per product. Columns for each country. A hard-coded duty rate typed in by hand. That model worked when tariff rates moved once a year.
It does not work now. In 2026, a U.S. importer paid a flat 10% Section 122 surcharge on most entries from February 24 to July 23, on top of any Section 301 duty but not on Section 232 duties (Proclamation 11012), and since July 24 a forced-labor Section 301 of 10% or 12.5% applies to goods of 60 economies instead. Steel and aluminum carry 50% under Section 232. Most Chinese goods carry 25% under Section 301, with electric vehicles at 100%. Those numbers change by executive action, not by calendar.
When a rate moves, a spreadsheet does not. It keeps showing the old number until someone remembers to retype it across every tab. That gap between the rate in the cell and the rate at the port is where money leaks.
| Question | Spreadsheet | Tariff comparison matrix |
|---|---|---|
| Rates update automatically | No | Yes |
| All products visible at once | No | Yes |
| Full duty stack per cell | No | Yes |
| Cheapest country highlighted | No | Yes |
| Selection logged for audit | No | Yes |
| Handles thousands of SKUs | No | Yes |
Bottom line: A spreadsheet is a snapshot that decays. A tariff comparison matrix is a live view that recalculates every product-country cell against current Section 301, Section 232 and other Chapter 99 rates, which is why sourcing teams managing more than a handful of SKUs move off spreadsheets.
How an N×M tariff matrix is structured
The structure is simple, which is the point. Products run down the rows. Sourcing countries run across the columns. Every cell holds the landed duty cost for that one combination.
The value of the layout is comparison density. A buyer looking at a single row sees, in one glance, what the same product costs to land from China, Vietnam, Mexico, and India. A buyer scanning a single column sees which products are cheapest to source from one country. The whole grid answers a sourcing question that no single lookup can.
Model India versus China import duty per SKU instead of applying one country-wide savings percentage.
In GingerControl's Parts Library, the N×M tariff matrix highlights two things automatically:
- Row-best cells turn green to mark the cheapest country for each individual product.
- Global-best cells mark the lowest landed cost across the entire grid.
That visual layer matters. A sourcing manager does not have to compute anything. The matrix tool surfaces the answer and the manager validates it.
GingerControl is AI global trade compliance infrastructure that helps importers, exporters, and customs brokers classify products, engineer optimal tariff positions, calculate duties, and track policy changes. The Parts Library is the part of that infrastructure built specifically for product-line sourcing decisions.
What lives inside a single cell
A landed cost comparison tool is only as honest as the number in the cell. A flat MFN rate is not honest, because almost no real entry pays only the MFN rate in 2026.
Click any cell in the Parts Library matrix and the full duty stack expands:
- MFN base duty - the column 1 rate from the Harmonized Tariff Schedule.
- Section 301 - the China-specific surcharge, 25% on most goods.
- Section 232 - national security tariffs on steel, aluminum, copper, autos, and more.
- Section 122 - the 10% surcharge on entries from February 24 to July 23, 2026, never on top of Section 232; since July 24 the forced-labor Section 301 of 10% or 12.5% takes its place.
- Chapter 99 - special program and additional-duty provisions.
- MPF - the Merchandise Processing Fee.
- HMF - the Harbor Maintenance Fee.
A worked example shows why the stack matters. Chinese steel rebar under HTS 7213.10.00 has a Free MFN rate, but the HTSUS adds 25% under Section 301 (heading 9903.91.01) and 50% under Section 232, a combined 75% before any antidumping or countervailing duty; Section 122 never stacked on the Section 232 duty, and the forced-labor Section 301 exempts Section 232 articles (9903.05.90). A spreadsheet cell showing "Free" is not slightly wrong. It misses 75 points of duty.
A tariff comparison matrix earns trust only when every cell shows the assembled stack, not a single headline rate. A buyer who sees Free and a buyer who sees 75% will source from different continents.
That sentence is the core insight. The matrix is not a prettier spreadsheet. It is a different instrument, because it computes the number a spreadsheet hides.
How a matrix turns into a sourcing decision
A tariff comparison matrix is sourcing decision software, not a reporting tool. The output is meant to change a purchase order.
Three things inside the Parts Library connect the matrix to a decision, and two checks stay with you:
- Cheapest cells highlighted. Each row's lowest landed cost and the overall lowest are highlighted, so the best source country per product is visible at a glance.
- Selection History. Each pick is saved with its date and the numbers behind it; 19 CFR 163.4 asks importers to keep records for five years.
- Bulk upload. Upload an Excel or CSV file of up to 100 rows at a time.
- FTA preferences, checked separately. Duty cost is not just the stack. If a product qualifies for a free trade agreement preference, the rate can drop to near zero; the share of U.S. imports from Mexico and Canada claiming a USMCA exemption was 80.2% in July 2026, according to Penn Wharton Budget Model analysis. The Parts Library does not compare FTA preferences today, so check each preference and its rules of origin before you count on it.
- Declared value, checked separately. CBP has shifted from trade facilitation to trade enforcement and is expanding AI-powered supply-chain mapping to find undervaluation, per OFW Law's 2026 trade enforcement analysis. Compare declared values against USITC DataWeb average unit values yourself; the matrix does not run that check.
When a sourcing team commits to a cell, the Parts Library writes that selection to a timestamped Selection History: the HTS candidate, the country, the configuration, and the full tariff calculation. That record matters because 19 CFR 163.4 requires importers to retain classification and entry records for 5 years from the date of entry, per the Legal Information Institute's text of the regulation. When a CF 28 inquiry arrives eighteen months later asking why a country was chosen, the answer is already documented.
If the underlying classification is uncertain, that work belongs upstream. GingerControl's HTS Classification Researcher follows the same reasoning process a licensed customs broker uses, GRI analysis, Section and Chapter Note review, and CROSS ruling research, and produces audit-ready documentation that supports the decision. It does not provide legal advice or replace licensed customs expertise. Products the Classifier finishes carry a Pending Tariff Badge that surfaces them directly into the Parts Library matrix.
Frequently asked questions
What is the difference between a tariff comparison matrix and a tariff calculator?
A tariff calculator answers one product-country question at a time. A tariff comparison matrix answers an entire product line against an entire set of countries in one grid. GingerControl offers both: the Tariff Calculator for single lookups and the Parts Library N×M matrix for sourcing teams who need to read duty exposure across a product line, in uploads of up to 100 rows at a time.
How does a tariff matrix tool keep rates current?
A spreadsheet holds rates that someone typed in manually, so they go stale the moment USTR or the White House acts. GingerControl's Parts Library recalculates every cell against the live tariff stack, MFN base, Section 301 (the forced-labor duties included), Section 232 and Chapter 99, so a sourcing manager never reads a number that was correct last quarter but wrong today.
Can a landed cost comparison tool handle a full product catalog?
In batches. GingerControl's Parts Library takes Excel or CSV uploads of up to 100 rows at a time, then renders every product as a row in the N×M tariff matrix with row-best and global-best cells highlighted. For a 4,000-SKU catalog in one run, batch work is a GingerOS feature.
Does a tariff comparison matrix account for free trade agreements?
It should, because an FTA preference can move a duty rate from double digits to near zero. The Parts Library does not compare FTA preferences today, so check each preference and its rules of origin separately rather than assuming it applies.
How does a tariff matrix help during a CBP audit?
Every committed selection in GingerControl's Parts Library writes to a timestamped Selection History capturing the HTS candidate, country, configuration, and full tariff calculation. Because 19 CFR 163.4 requires importers to retain records for 5 years, a Compliance Manager facing a CF 28 inquiry can produce a defensible record of why each sourcing decision was made.
Who on a sourcing team uses a tariff comparison matrix?
Supply Chain Managers, Sourcing Teams, Product Line PMs, Compliance Managers, and CFO and Finance leaders all read the same grid for different reasons. GingerControl's Parts Library gives each persona one shared N×M tariff matrix, so a CFO's landed cost number and a sourcing manager's country choice come from the same live calculation.
See your product line as one grid
If your team still models duty cost one spreadsheet tab at a time, you are reading rates that may already be wrong, and you cannot see your cheapest sourcing country at a glance. A tariff comparison matrix solves both problems by computing the full landed duty stack for every product-country pair in one live grid. GingerControl's Parts Library builds that grid as an N×M tariff matrix with green-highlighted best cells and a dated Selection History. Explore the Parts Library.
Compare U.S. import duty rates by country with the same HTS line and entry date, rather than comparing country headlines.
GingerControl is not just a tool. We also work with importers and trade compliance teams on process consulting, digital transformation strategy, and end-to-end custom system development. Talk to our team.
References
- Proclamation 11012 (91 FR 9339) and the Harmonized Tariff Schedule of the United States, Revision 21
Data cited: 10% Section 122 surcharge on entries from February 24 to July 23, 2026, not in addition to Section 232 duties (clause 4); HTS 7213.10.00 Free MFN rate and 25% under heading 9903.91.01 (U.S. note 31(b) to Chapter 99)
Source: Federal Register 2026-03824; HTSUS
Published: February 25, 2026 (proclamation); HTSUS Revision 21, October 9, 2026 - Penn Wharton Budget Model - Effective Tariff Rates and Revenues
Data cited: 80.2% of imports from Mexico and Canada claiming a USMCA exemption in July 2026
Source: Effective Tariff Rates and Revenues, Updated September 9, 2026
Published: September 9, 2026 - OFW Law - 2026 Trade Enforcement Analysis
Data cited: CBP shift from trade facilitation to enforcement, AI-powered supply-chain mapping to detect undervaluation
Source: 2026 Trade Enforcement: Why Import Compliance Is Now a Board-Level Risk
Published: February 2026 - Legal Information Institute - 19 CFR 163.4 Record Retention Period
Data cited: 5-year record retention requirement from date of entry
Source: 19 CFR 163.4 Record retention period
Published: current regulation
Shortlisting AI for trade compliance?
Hand this to GingerOS.
Pick a 30-minute slot on the next page with Chen Cui, our CEO. Bring one notice or one SKU list (an ERP export, a spreadsheet or an email will do) and see what GingerOS does with it.
Reviewed by Michael Weick, LCB / CCS




