info@careerchronicles.org

Tariff Auto-Fill Tool

(TAF-097)

Your Image

Stop bouncing between 4,000-page government PDFs. This HTSUS 2026 Master Rate Workbook consolidates the entire Harmonized Tariff Schedule into a single, filterable Excel engine with pre-built VLOOKUP automation, Section 301/232/122 overlays, and a 50-country trade program reference.

Enter your 8-digit HTS codes in the yellow input cells. Duty rates, descriptions, compliance flags, and Section 122 status populate instantly. Copy-paste directly into your ERP, landed cost models, or financial forecasts.

Built by a procurement professional with 20+ years of global sourcing experience. Every rate traces back to the official USITC Harmonized Tariff Schedule - the same source customs brokers use.

HS Code Lookup and Tariff Rate Auto-Fill for Excel

Download Now
TAF-097 - Tariff Auto-Fill Tool | Checkout Landing Page | Career Chronicles
Career Chronicles - Tariff Operating System

HS Code Lookup

3,327 verified tariff lines from the official USITC 2026 HTS Rev 4. Enter your HS code, get your rate instantly. One workbook. Nine tabs. Zero guesswork.

3,327 Verified Rate Lines
9 Workbook Tabs
2,000+ VLOOKUP Formulas
50 Countries Mapped
$97 One-Time Purchase. No subscription. Instant download.
Why This Workbook

Built for the Way Supply Chain Teams Actually Work

🔍

Instant Auto-Fill Engine

Enter your 8-digit HTS code and get the duty rate, description, special programs, and all overlay flags in one click. 200 lookup rows with pre-built VLOOKUP formulas.

📊

3,327 Verified Rate Lines

Every 8-digit HTS code sourced directly from the USITC 2026 HTS Rev 4. Pre-formatted as text to prevent leading-zero corruption on Chapters 01-09.

🌐

Section 122 Overlay

Post-SCOTUS Section 122 tracking: every HTS code flagged as EXEMPT (241 codes), EXEMPT Aircraft Only (187 codes), or 10% APPLIES (2,899 codes).

🛠

Section 301 & 232 Overlays

Dedicated tabs for China tariffs (16 categories, 25%-100%) and Steel/Aluminum/Auto tariffs (50% rates with UK exception). Stacking logic included.

🌎

50-Country Quick Reference

FTA status, GSP eligibility, Section 301/232 exposure, reciprocal tariff rates, and trade risk levels for every major U.S. trading partner.

🔌

Plug-and-Play Integration

Designed to feed directly into every Career Chronicles tool. Integration Guide tab maps column-by-column connections to SKB-027, TIAS-199, SCS-849, and more.

What You Get

HTSUS 2026 Master Rate Workbook - 9 Tabs

  • Tab 1: Icon Key
    Standardized status indicator reference for every emoji and icon used across the workbook. Three sections: Core Status, Trade Program & Overlay, Action & Workflow.
  • Tab 2: Instructions & Update Log
    Data sourcing documentation, version history, revision tracking, and legal disclaimers. Read-only reference.
  • Tab 3: Integration Guide
    Step-by-step column mapping to every Career Chronicles product. Shows exactly which fields feed into SKB-027, TIAS-199, SCS-849, TDM-1299, and more.
  • Tab 4: Auto-Fill Lookup
    200 input rows with 2,000+ VLOOKUP formulas. Enter your HTS code in the yellow cell - duty rate, description, overlays, and Section 122 status populate instantly.
  • Tab 5: Country Quick Reference
    50 countries with FTA status, GSP eligibility, Section 301/232 exposure, reciprocal tariff rates, and trade risk indicators.
  • Tab 6: Master Rate Table
    The core database - 3,327 verified 8-digit HTS tariff lines with General Rate, Special Programs, Column 2, Section 301/232 flags, and Section 122 status.
  • Tab 7: Section 122 Overlay
    Post-SCOTUS emergency tariff tracking. Every HTS code classified as EXEMPT, EXEMPT (Aircraft Only), or 10% APPLIES per White House Proclamation Annexes.
  • Tab 8: Section 232 Overlay
    Steel, aluminum, automobiles, timber, and derivative products at 50% rates with UK exception. Updated to reflect June 2025 increases.
  • Tab 9: Section 301 Overlay
    16 China-specific product categories with 2024-2026 tariff rates. EVs (100%), syringes (100%), solar cells (50%), semiconductors (50%), batteries (25%), and more.
Tariff Stacking Coverage

Three Overlay Programs. One Workbook.

Section 301 (China)

16 product categories with rates from 25% to 100%. Covers EVs, solar cells, semiconductors, batteries, syringes, PPE, gloves, tungsten, polysilicon, and ship-to-shore cranes. Includes 2024-2026 strategic increases.

25% - 100%

Section 232 (National Security)

Steel, aluminum, automobiles, auto parts, and timber at 50% rates. UK exception at 25%. Includes June 2025 increases and March 2025 revocation of all country exclusions.

25% - 50%

Section 122 (Post-SCOTUS)

10% ad valorem temporary import duty effective Feb 24, 2026. Sunset July 24, 2026. 241 codes EXEMPT, 187 Aircraft Only, 2,899 codes at 10%. Replaced IEEPA tariffs after the Feb 20 SCOTUS ruling.

10% Surcharge

A single HTS code can carry a general duty rate plus Section 301 plus Section 232 plus Section 122 - all at once. Example: Steel structural tubing from China (HTS 7308.90.95) = 0% general + 25% Section 301 + 50% Section 232 + 10% Section 122 = 85% total landed cost impact.

Built For

Who Uses the Tariff Auto-Fill Tool

  • ◆ Procurement Directors managing import exposure
  • ◆ Supply Chain Leaders modeling sourcing alternatives
  • ◆ Import Compliance Managers verifying HS classifications
  • ◆ CFOs and FP&A teams modeling margin impact
  • ◆ Trade Consultants advising importer clients
  • ◆ Business Owners importing directly into the US

Tariff Auto-Fill Tool - TAF-097

HTSUS 2026 Master Rate Workbook (v4.1)

$97
One-time purchase - instant download
  • ✓ 3,327 verified HTS rate lines (USITC 2026 Rev 4)
  • ✓ Auto-Fill Lookup with 200 input rows & 2,000+ VLOOKUPs
  • ✓ Section 301 China overlay (16 categories, 25%-100%)
  • ✓ Section 232 overlay (steel/aluminum/auto at 50%)
  • ✓ Section 122 post-SCOTUS overlay (10% surcharge tracking)
  • ✓ 50-country FTA & trade program quick reference
  • ✓ Integration Guide for all Career Chronicles products
  • ✓ Works in Excel, Google Sheets & LibreOffice
Immediate download. No subscription. No API keys required.

All rights reserved.

This tool is designed for tariff modeling and exposure analysis. Always verify final duty rates through hts.usitc.gov or a licensed customs broker before filing.

Your Image
Your Image
Your Image

Get Pre-Filled Tariff Rates & HS Codes | No More Guesswork

Stop digging through government databases. Get your tariff rates pre-loaded and ready to go.

Secure checkout – instant access

For sourcing, compliance, and global trade professionals who want it done right.

Pre-filled HS Codes by product category

Verified tariff % by country

Excel-ready format — no manual entry

Works with all Career Chronicles tools

BONUS: Region lookup + policy source log

Your Image

“This saved me hours of cross-checking HS codes. Worth every penny.”

— Director of Sourcing, Industrial Supplier
Secure checkout
$97 instant access

“Can I use this in any Excel template?”

Yes! It’s plug-and-play.

“What countries are included?”

Over 50 of the most common trade partners.

“Is this updated?”

Answer Body

Contact Information

Billing Information

Payment Methods

Apple Pay selected.

Another step will appear to securely submit your payment information.

Google Pay selected.

Another step will appear to securely submit your payment information.

Executive (Fast Track) Briefing Kit

Executive Tariff Briefing Kit – Boardroom-Ready in Minutes

Build a complete, data-backed tariff briefing with calculations, visuals, and executive messaging – without starting from scratch.

Benefits:

✓     Executive Tariff Briefing Calculator – 8-tab Excel workbook with 175 auto-calculating formulas for tariff impact and scenario modeling

✓      Inventory Optimization Framework – 19-tab procurement system with 270 formulas covering ROI, working capital, and supplier risk

✓     Executive Presentation Deck – 8 ready-to-use slides for leadership, finance, and board-level discussions

✓     8 Stakeholder Email Templates – structured messaging for CEO, finance, operations, and internal teams

✓     Visual Summary (1-page PDF) 

✓     10-Minute Prep Guide – step-by-step walkthrough to prepare and deliver your briefing fast

What It Solves

Consulting Equivalent Value - $7.5K-$15K (verified value by a 3rd party before becoming an AI-enabled decision system)

“I need to explain tariff impact to leadership, but I don’t have time to build the analysis, slides, and messaging from scratch.”

This kit gives you a complete system to calculate tariff exposure, model financial impact, and present clear recommendations.

AI-Ready by Design

This system is structured to work with modern AI tools.

Use your outputs with ChatGPT, Copilot, or internal AI systems to:

  • Generate executive summaries
  • Stress-test scenarios
  • Draft stakeholder communications.
  • Expand Analysis   

Built by Ramie Virk - a procurement leader with 20+ years managing global supply chain risk for Fortune 500 organizations. Every Career Chronicles tool is built from real-world experience, not theory.

Recommended:

[[1900 | currency]] [[79900 | currency]]

Tariff Playbook Suite™

Tariff Playbook Suite™ – a full Tariff Response System

Two powerful tools bundled into one 17-tab workbook: analyze tariff exposure, prioritize your response, track supplier risk, and brief leadership - all for less than a business lunch

Benefits:

•       17-Tab Unified Workbook: Data Input, Tariff Rates, Tariff Insights dashboard, Response Plan, Checkbox Summary Planner, Role Based Response Checklist, Supplier Outreach Tracker, Supplier Dashboard, Vendor Supplier Risk, Vendor Dashboard, ERP Import Guide, and more -- all in one file.

•       Tariff Insights Dashboard: 10 auto-calculating KPIs, 30-row product summary, regional breakdown across 7 regions, supplier exposure analysis, and 3 embedded charts ready to copy-paste into your leadership deck.

•       Response Plan Engine: auto-populates action items from your Data Input tab with owner assignment, deadline tracking, and status columns. No blank-page planning.

•       Supplier Risk Tracking: Outreach Tracker with contact status, Vendor Supplier Risk scoring, and a Vendor Dashboard that visualizes risk tier distribution across your supply base.

•       Executive Briefing Deck: 8-slide branded PowerPoint template with chart paste areas, KPI cards, and data tables mapped directly to the workbook. Copy from Excel, paste into slides.

•       Role Based Response Checklist: pre-built action items assigned by role -- Procurement, Finance, Compliance, Legal, Executive -- so every stakeholder knows exactly what to do.

•       Stakeholder Email Templates: pre-written alert emails for suppliers, leadership, and cross-functional teams. Edit and send -- no drafting from scratch.

•       ERP Integration Guide: step-by-step column mapping for importing tariff data into SAP, Oracle, NetSuite, and other enterprise systems.

•       Plug-and-Play with TAF-097: every formula references the same tblInput structure used across the Career Chronicles ecosystem. Add verified HTSUS rates and the entire workbook lights up.

What It Solves

Consulting Equivalent Value - $5K-$10K (verified value by a 3rd party)

“I need to explain tariff impact to leadership, but I don’t have time to build the analysis, slides, and messaging from scratch.”

Built by Ramie Virk - a procurement leader with 20+ years managing global supply chain risk for Fortune 500 organizations. Every Career Chronicles tool is built from real-world experience, not theory.

Recommended:

[[2700 | currency]] [[79900 | currency]]
[[invoiceItem.description]]
[[subscriptionsByProductId[invoiceItem.product_id].plan_description]]
REMOVE
[[invoiceItem.quantity]] x [[invoiceItem.unit_price | currency]]
Subtotal:
[[checkoutContext.order.invoice.subtotal | currency]]
Tax:
[[checkoutContext.order.invoice.tax | currency]]
Shipping:
[[checkoutContext.order.invoice.shipping | currency]]
Discounts:
-[[checkoutContext.order.invoice.discount | currency]]
Total:
[[checkoutContext.order.invoice.total | currency]]