Why Tariff Comparison Spreadsheets Need Dates and Decision Records

What changed: Removed guarantees of live cell recalculation and unsupported cost statistics; clarified dated Calculator runs, Parts Library selections and Radar alerts.

The short answer

A tariff comparison spreadsheet becomes unreliable when a rate loses its date or source, an applicable duty is omitted, or an assumption changes without a saved record. The spreadsheet can remain useful if those controls are built into the process. Replacing it with software does not automatically solve the problem: verify the inputs, entry date, duty coverage and retained history in either workflow. The aim is a comparison procurement can explain and reproduce, not a promise that a grid never goes stale.

Next step:Price the full duty stack for one SKU

In this post
  1. Five failure modes to check
  2. What the GingerLite tools actually do
  3. Keep the workbook if it remains useful
  4. Frequently Asked Questions
  5. References

Five failure modes to check

Failure Control
Undated rate Record entry date, effective period and official source
Partial duty stack Check applicable Chapter 99 notes and exceptions
Inconsistent assumptions Align code, origin, value, freight and quantity
Version sprawl Assign an approved version and owner
Overwritten decision Save the prior inputs, result and reason

USITC's HTS provides the product and Chapter 99 provisions [1]. A change in duties can require an update even when the product code itself is unchanged. The 2026 Section 122 surcharge is a dated historical example: it covered entries from February 24 through July 23, 2026 [2]. A cell carrying that rate into a later scenario needs review.

What the GingerLite tools actually do

Tariff Calculator calculates U.S. duty layers, MPF and HMF for the entry date you enter. Parts Library compares candidate-code and source-country landed costs and records committed selections with their date and numbers. It accepts up to 100 rows per Excel or CSV upload. Do not describe every saved matrix cell as automatically recalculating forever.

Use a tariff comparison matrix to hold products on the rows and candidate origins on the columns.

Compliance Radar checks new U.S. notices against your own codes and sends email alerts. Someone still reviews the affected assumptions and decisions. FTA qualification and customs valuation need separate evidence; a highlighted low-cost option does not establish either.

Keep the workbook if it remains useful

Export a review sample, compare identical assumptions and investigate differences before replacing the process. Use Classification Researcher where the code is uncertain. Keep decision and import records under the applicable retention rules [3].

For company-wide catalog rechecks and connections to existing systems, GingerOS is built for your process and the data you have, including spreadsheets. Prototype Week is the step before a quote.

The original International Trade Insights discussion remains background reading; use the official tariff provisions for a specific entry.

Frequently Asked Questions

Is every spreadsheet inherently inaccurate?

No. Dates, official sources, complete assumptions and version controls can make it useful.

Does changing software guarantee current rates?

No. Verify which date and duty layers the result uses.

Does every Parts Library cell recalculate automatically?

Do not assume that. It compares candidate costs and retains committed selections.

What does Tariff Calculator use as its date?

The entry date you enter. Its U.S. duty layers include MPF and HMF.

What triggers a Radar email?

New U.S. notices matched to your own HTS codes.

How many rows can I upload?

Up to 100 rows per Parts Library Excel or CSV upload.

Can the lowest-cost cell prove an FTA claim?

No. Qualification requires separate manufacturing and origin evidence.

Can GingerOS start from spreadsheets?

Yes. GingerControl can organize the data and fit a company-wide workflow to it.

References

  1. USITC, Harmonized Tariff Schedule
    Source: USITC, Harmonized Tariff Schedule
    Checked: 2026-10-12
  2. Proclamation 11012, temporary Section 122 surcharge
    Source: Proclamation 11012, temporary Section 122 surcharge
    Checked: 2026-10-12
  3. 19 CFR 163.4
    Source: 19 CFR 163.4
    Checked: 2026-10-12
Your next step

Not sure what the next tariff change costs you?

Hand this to GingerOS.

Price the full duty stack for one SKU Get an impact report for your SKU list

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
Customs compliance manager with 42 years of experience (ex Subaru of America, Merck, and Motorola).

More in Tariffs & Duties

Our Risk-Free Promise

Full refund.

If you’re not satisfied before MVP acceptance, get a full refund of your deposit.

Click Me!

See if you qualify