“We recovered $1.2 million in tariff refunds in one quarter using the Tariff Refund Suite, without hiring outside consultants.” Sam -Director of Trade Compliance, Fortune 500 Manufacturer

How Do I Recover Section 301, Section 232 and Duty Drawback Refunds?

The Tariff Refund Suite™ gives you a single system to identify, document, file, track, and recover ALL eligible (Section 301, Section 232, CBP protest, CAPE, duty drawback, and exclusion) money from one centralized execution refund system.

Complete Tariff Refund Suite | End-to-End CAPE, Protest, Drawback and Exclusion Recovery System | TRS 197 Tariff Refund Suite™
CBP has paid out $100 billion of the $166 billion IEEPA refund pool, per its August 5, 2026 court filing. Phase 2 is live. The Tariff Refund Suite™
Career Chronicles |Tariff Operating System

The Tariff Refund Suite™ | End-to-End CAPE, Protest, Drawback and Exclusion Recovery

The complete IEEPA refund execution system for trade-compliance teams. CAPE Submission Prep (Phase 1 live, Phase 2 live now). CBP Form 19 protest templates. Section 232 exclusion workflows. Duty Drawback estimators. Section 122 tracker. One unified workbook with the Executive Interactive Command Center and repeatable tasks gets replaced with auto-gnerated filing documents. Replaces $15,000-$35,000 in Big 4 consulting.

Complete Tariff Refund Suite product image showing the end-to-end CAPE preparation system with Excel workbook, Word templates, PowerPoint executive deck, and PDF SOPs covering Section 301, 232, 122, Drawback, and IEEPA refund recovery
CAPE Refund Intelligence Quick Reference

US Tariff Refund Status Mid-2026

CAPE Phase 1
Live Since April 20
Covers unliquidated entries and entries within ~80 days of liquidation. $100B+ already refunded on 17.6M+ entries.
CAPE Phase 2
Live Now
Adds entries beyond 80 days, FTZ entries (incl. Type 06), drawback-linked entries, and reconciliation-flagged entries.
IEEPA Refund Pool
$166B+
Supreme Court struck down IEEPA tariffs Feb 20, 2026. 330,000+ importers eligible.
Filing Pathways
4 Routes
CAPE (IEEPA), CBP Protest Form 19, Duty Drawback, or Post-Summary Correction. Suite auto-routes each entry.

What is the Complete Tariff Refund Suite?

The Complete Tariff Refund Suite (TRS-197) is a $197 one-time multi-authority tariff refund system. It screens every CBP entry for Section 301, 232, 122, IEEPA, and drawback eligibility, routes each one to CAPE, a Form 19 protest, drawback, or a PSC, calculates the refund, and generates the filing document.

It is one connected Excel workbook plus a CBP-ready template library, an Executive SOP deck, and the Executive Interactive Command Center. Built by a 20-year procurement and tariff risk strategist, refined across $150M+ in real import spend, and updated free for life. Current version 2.6, released August 2026.

★ ★ ★ ★ ★

“We recovered $1.2 million in tariff refunds in one quarter using the Tariff Refund Tools, without hiring outside consultants.”

— VP of Trade Compliance, Fortune 500 Manufacturer

What’s Included in the Complete Tariff Refund Suite

A single connected workbook plus a full library of CBP-ready templates, executive briefing decks, and SOPs. Everything formatted to actual CBP filing specifications.

Tariff Refund Suite TRS-197 From Tracker to Filing-Ready graphic: a laptop showing the Executive Interactive Command Center and Refund Recovery Dashboard with total entries, duty at risk and recovery rate, above a three-step flow of Import Your Data, Track Filing Deadlines, and Auto-Generate, leading to the PSC Filing Packet, Prefilled Templates, CBP Form 19, and Refund Workflow deliverables

One Unified Workbook. Twelve Recovery Tools.

  • Recover Section 301, 232, 122, IEEPA, and Drawback refunds in one system
  • CAPE Submission Prep tab (Phase 1 ready today, Phase 2 live now)
  • Automate your entire filing process no consultant required
  • Track refund status by entry number, supplier, and refund type
  • Visualize refund exposure across products, suppliers, and countries
  • Align procurement, compliance, and finance in under 1 hour
  • CBP protest-ready with plug-and-play SOPs and templates
  • Executive Interactive Command Center™ import the workbook, get a live dashboard, generate filing documents in one click
  • Works in Excel, Google Sheets, and LibreOffice no plugins required

All tools downloadable as Excel, Word, PowerPoint, and PDF. No subscription. No guesswork.

🔒 Download to Unlock Tariff Refunds Now

What data do I need before I can start a tariff refund claim?

Five fields per entry, all of which you already hold: CBP entry number, entry date, HTS code as filed, country of origin, and duty paid. Every one appears on your CBP Form 7501, your ACE Entry Summary report, or your broker’s statement. Paste those columns into the Data Input tab and the workbook does the rest.

You do not research or estimate anything. For a refund filing the HTS code is evidence, not a guess CBP matches your protest against the code as filed. Once the code and country are in, the workbook fills current rate, estimated duty at today’s rates, region, applicable authority, and the routing decision automatically.

A Look at the Core Working Tabs

Real screenshots from the live Tariff Refund Suite™ workbook every tab connected, color-coded, and filter-ready. Data enters once on the Data Input tab and flows across the suite automatically. CAPE Phase 1 and Phase 2 are both live.

Tariff Refund Suite™ workbook Data Input tab
Data Input
Tariff Refund Suite™ workbook Eligibility Checklist tab
Eligibility Checklist
Tariff Refund Suite™ workbook Filing Path Decision Model tab
Filing Path Decision Model
Tariff Refund Suite™ workbook Refund Scenario Forecaster tab
Refund Scenario Forecaster
Tariff Refund Suite™ workbook Filing Pack Generator tab
Filing Pack Generator
Tariff Refund Suite™ workbook CAPE Submission Prep tab
CAPE Submission Prep
Tariff Refund Suite™ workbook Section 301 Tracker tab
Section 301 Tracker
Tariff Refund Suite™ workbook Section 232 Tracker tab
Section 232 Tracker
Tariff Refund Suite™ workbook Section 122 Tracker tab
Section 122 Tracker
Tariff Refund Suite™ workbook Other Remedy Tracker tab
Other Remedy Tracker
Tariff Refund Suite™ workbook KPI Dashboard tab
KPI Dashboard
Tariff Refund Suite™ workbook ROI Calculator tab
ROI Calculator
Tariff Refund Suite™ workbook Dashboard tab
Dashboard
Tariff Refund Suite™ workbook Tariff Rates tab
Tariff Rates
Tariff Refund Suite™ TRS-197 live examples worked sample entries showing real refund calculations and filing outcomes across the workbook
Live Worked Examples
Live screenshot of the Tariff Refund Suite TRS-197 workbook showing the four tracker tabs along the bottom of the Excel window: Section 301 Tracker, Section 232 Tracker, Section 122 Tracker, and Other Remedy Tracker
The four tracker tabs the Command Center reads: Section 301, Section 232, Section 122, and Other Remedy. One row per CBP entry, because that is how CBP pays refunds.

How do I turn a tariff tracker spreadsheet into a live recovery dashboard?

Open the Executive Interactive Command Center HTML file, import your workbook, and the dashboard builds itself. It reads your Section 301, 232, 122, and Other Remedy tracker tabs and returns duty at risk, estimated refund, recovery rate, entry counts, filing status, and per-program recovery totals in seconds. No pivot tables, no server, no upload.

The distinction that matters: this is not a static export of your spreadsheet. The Command Center recalculates from your actual rows every time you import, so the executive view and the working file can never drift apart. Upload once, connect your mapping, and the spreadsheet becomes the command layer.

From Working Spreadsheet to Real-Time Visibility graphic showing the Tariff Refund Suite Section 301, 232, 122, and Other Remedy tracker workbook tabs on the left transforming via a large arrow into the Executive Interactive Command Center dashboard and Refund Recovery Entries table on the right, with the caption Upload once, connect your mapping, command your tariff recovery metrics live
Upload once. Connect your mapping. Command your tariff recovery metrics live. The same four tracker tabs, rendered as an executive command center.
Side by side comparison graphic: the left panel shows the working KPI Dashboard spreadsheet tab with total duty at risk, estimated refund, recovery rate, entry counts, filing status, urgency alerts and program-level charts; the right panel shows the Executive Interactive Command Center visibility layer with automated executive recommendations, total entries requiring action, overdue and filing status indicators, duty at risk, estimated recovery, recovery rate, and program-by-program recovery totals
Left: the working KPI Dashboard tab duty at risk, estimated refund, recovery rate, entry counts, filing status, urgency alerts, program charts. Right: the executive visibility layer automated recommendations, entries requiring action, overdue indicators, and program-by-program recovery totals.
Procurement and compliance team reviewing tariff refund recovery briefing materials, illustrating the unified Suite workflow that aligns finance, procurement, and trade compliance teams under one structured refund process

Stop Leaving Tariff Refunds on the Table

Get every eligible dollar back, fast, with the Tariff Refund Suite. Unclaimed tariff refunds usually come from three things: missed windows, fragmented entry data, and unclear ownership between compliance and finance.

The Complete Tariff Refund Suite gives you a single system to run refunds with control. Identify, file, and recover every refund you deserve without hiring expensive consultants or risking compliance errors. Purpose-built for real operators managing real trade exposure.

Just Download Now

Visual showing common reasons most tariff refund tools fail: generic templates that do not align with CBP procedures, scattered information across systems, missed deadlines, and consultant fees of $5,000 or more per claim

Why Most Tariff Refund Tools Fail

  • Generic templates do not align with CBP procedures
  • Teams miss deadlines due to scattered information
  • Consultants delay filings and charge $5,000+ per claim
  • Most tools have no CAPE prep making them obsolete on day one
  • No single source of truth info spread across spreadsheets, ERP, and accounting

Information across multiple spreadsheets, ERP systems, and accounting software causes confusion and data errors that delay refunds. The Suite fixes this with one workbook, one data flow, one audit trail.

What is CBP’s CAPE portal and how do I submit a refund to it?

CAPE (Consolidated Administration and Processing of Entries) is CBP’s official IEEPA refund portal, live inside the ACE Secure Data Portal since April 20, 2026. You submit a CSV of entry numbers. CAPE processes and pays by ACH in 60 to 90 days with statutory interest. Phase 2 opened June 29, 2026.

What CAPE does not do: identify which of your entries are eligible, calculate what they are worth, screen Phase 1 versus Phase 2, or tell you when a refund actually paid. It is a submission endpoint, not an analysis tool. CBP’s August 5, 2026 court filing shows more than $100 billion already paid out across 17.6 million-plus entries.

CBP’s CAPE Portal Handles One Step. The Suite Handles Everything Else.

CAPE is CBP’s official IEEPA refund mechanism. It accepts a CSV of entry numbers and processes the refund. It does not identify eligible entries, calculate amounts, screen Phase 1 eligibility, route Phase 2 candidates, or track recovery. That is exactly what the Suite was built to do.

CAPE Phase 1 Live Now

Launched April 20, 2026 in the ACE Secure Data Portal. Covers unliquidated entries and entries within about 80 days of liquidation roughly two-thirds of IEEPA-dutied entries. Refunds paid by ACH within 60 to 90 days, with statutory interest. Per CBP’s August 5, 2026 court filing, more than $100 billion has been paid out across 17.6 million-plus entries.

Primary IEEPA Path

CAPE Phase 2 Live Since June 29, 2026

Covers entries Phase 1 left out: entries liquidated more than ~80 days ago, foreign-trade-zone (FTZ) entries including Type 06 withdrawals, drawback-linked entries, and entries flagged for reconciliation. The Suite’s Eligibility Checklist flags Phase 2 candidates so you can prepare and submit now that the portal is open.

Live Now

Which tariff refund pathway applies to my entry: CAPE, protest, drawback, or PSC?

Four variables decide it: the tariff authority you paid under, country of origin, whether the entry has liquidated, and whether the goods were later exported or destroyed. IEEPA goes to CAPE. Liquidated Section 301 and 232 exclusions go to a Form 19 protest. Unliquidated errors go to a PSC. Exported goods go to drawback.

Most importers get this wrong in one direction: they assume a single pathway covers everything. It does not. A single container can produce an IEEPA CAPE submission, a Section 301 protest, and a drawback claim from the same entry line. The Filing Path Decision Model applies all four tests to every row so nothing gets filed down the wrong channel or missed entirely.

Decision tree infographic from the Tariff Refund Suite TRS-197 showing which refund applies to a CBP entry, branching by tariff authority, country of origin, liquidation status, and export or destruction, and routing to CAPE, CBP Form 19 protest, duty drawback, or Post-Summary Correction
Which refund applies? The Suite’s decision tree, reproduced from the workbook. Every branch maps to a live filing channel with its own statutory deadline.

Recovery Pathways: How the Suite Routes Your Claim

The Filing Path Decision Model evaluates each entry’s product category, country of origin, liquidation status, and tariff type, then routes it to the correct channel. You do not determine the path manually the model does it for you.

CAPE Portal (IEEPA Phase 1 + Phase 2)

CBP’s official IEEPA refund portal in the ACE Secure Data Portal. Phase 1 covers unliquidated entries and entries within ~80 days of liquidation. Phase 2 (now live) covers FTZ, drawback, reconciliation, and post-80-day entries.

Primary IEEPA Path

CBP Protest (Form 19)

File within 180 days of liquidation under 19 U.S.C. §1514 to challenge duty rates, classification, valuation, or post-SCOTUS IEEPA overpayments. Covers Section 301 exclusion refunds, Section 232 rate disputes, and misclassification corrections. Filed under 19 CFR Part 174.

180 Days From Liquidation

Duty Drawback

Recover up to 99% of duties paid on imported goods subsequently exported or destroyed, under 19 U.S.C. §1313. Claims run 5 years from the date of import. Manufacturing, unused merchandise, and rejected merchandise drawback programs all supported.

99% Recovery · 5-Year Window

Post-Summary Correction (PSC)

Correct classification or valuation errors on unliquidated ACE entries before CBP audit triggers enforcement. Must be filed no later than 15 days before the scheduled liquidation date. Reduces penalty exposure and preserves compliance standing.

Pre-Liquidation Only

How long do I have to file a tariff refund claim?

Each pathway runs its own clock. Protests: 180 days from liquidation. PSCs: before liquidation, no later than 15 days prior. Drawback: 5 years from import. CAPE: open now for eligible IEEPA entries. Entries generally liquidate 314 days after entry, which is the date every other deadline hangs off.

That 314-day mark is why refunds get lost. Liquidation is not announced to you; it posts to the ACE Entry Summary and the protest window opens and closes silently around it. Miss it and the entry is legally final. Every deadline below is tracked per entry number inside the Suite.

Tariff refund filing deadlines by pathway
PathwayDeadlineClock startsAuthority
CBP Protest (Form 19)180 daysDate of liquidation19 U.S.C. §1514 / 19 CFR Part 174
Post-Summary CorrectionUp to 15 days before liquidationDate of entry summary filing19 CFR 141.101 / ACE PSC policy
Duty Drawback5 yearsDate of import19 U.S.C. §1313 / TFTEA
CAPE (IEEPA)Phase 1 and Phase 2 both openPortal opened April 20, 2026 · Phase 2 June 29, 2026CBP CSMS guidance, ACE Secure Data Portal
Section 301 exclusion refundPer-exclusion retroactivity dateFederal Register exclusion noticeUSTR exclusion notices / Section 301 of the Trade Act of 1974
Section 122PSC before liquidation · protest 180 days afterEntry dates Feb 24 – Jul 24, 2026Section 122, Trade Act of 1974 (150-day statutory cap)

Deadlines reflect general CBP practice as of August 5, 2026. Always verify against current CSMS bulletins for your specific entries. For day-by-day tracking of new tariff actions, exclusions, and CBP guidance as they post, see the Tariff Intelligence Briefing.

Section 122 Expired, Refund Clocks Running

After IEEPA tariffs were struck down, the administration imposed a new 10% global tariff under Section 122 of the Trade Act of 1974, effective February 24, 2026. It expired July 24, 2026 at its 150-day statutory cap no new Section 122 duties are being collected. The Court of International Trade had already ruled it unlawful on May 7, 2026; that ruling is on appeal at the Federal Circuit, and CBP collected throughout under a stay.

What to do now: your refund windows are still open. Post-Summary Corrections remain available before liquidation and protests for 180 days after each entry liquidates and if the appeal upholds the CIT’s ruling, every dollar paid February 24 to July 24, 2026 may become the next CAPE-style refund opportunity. Importers with organized records will be first in line. The Suite includes a dedicated Section 122 Tracker. Track this appeal and every other tariff development as it happens in the Tariff Intelligence Briefing.

How much can I recover in tariff refunds?

It scales with your entry volume and the authorities you paid under. Section 301 List 3 alone covers roughly $200 billion in annual Chinese-origin trade at 25%; List 4A covers roughly $120 billion. Drawback returns up to 99% of duties on exported or destroyed goods. One Fortune 500 manufacturer recovered $1.2 million in a single quarter.

The honest version: nobody can quote you a number without your entry data, and anyone who does is selling. What the Suite gives you is the calculation, per entry, before you spend a dollar on outside help. In the representative Command Center dataset, $694,243 in duty at risk across 30 entries produced a 61.9% projected recovery rate.

Scale of the major US tariff programs generating refund exposure
ProgramScale of covered tradeRateRefund route in the Suite
Section 301 List 1~$34 billion25%Exclusion refund → Form 19 protest / PSC
Section 301 List 2~$16 billion25%Exclusion refund → Form 19 protest / PSC
Section 301 List 3~$200 billion25%Exclusion refund → Form 19 protest / PSC
Section 301 List 4A~$120 billion7.5%Exclusion refund → Form 19 protest / PSC
Section 232 steel and aluminumDerivative lists expanded repeatedly since 2018Varies by product and countryExclusion refund + TRQ / quota tracking
IEEPA (struck down Feb 20, 2026)$166B+ refund pool · 330,000+ eligible importersVariesCAPE Phase 1 and Phase 2
Section 122 (Feb 24 – Jul 24, 2026)Global, 150-day statutory cap reached10%PSC before liquidation · protest after

List values reflect the annualized import trade each Section 301 list was drawn against at imposition. Your recoverable amount depends on your own entries, exclusion eligibility, and liquidation status.

Twelve Tools, One Connected System

📊

CAPE Submission Prep Tab

Pre-filing checklist, six-step CAPE filing walkthrough, and Phase 1 / Phase 2 eligibility reference table.

🔍

Refund Eligibility Screener

Flags every entry against Section 301, 232, 122, IEEPA, and exclusion programs. Auto-routes to the right pathway.

📅

Filing Status Dashboard

Multi-entry tracking with deadlines, refund stage, ACH disbursement reconciliation, and one-page leadership summary.

📝

CBP Protest Templates (Form 19)

Pre-filled protest letters, internal memos, broker communications, and the IEEPA + Section 301 legal authority citations.

🧮

Section 232 Refund Tools

Steel and aluminum SOPs, HTS exclusion mapping, Quota Used (TRQ) field, and revocation timeline tracker.

💰

Duty Drawback Estimator

Match export records to import entries. Auto-calculate up to 99% drawback. Export filing templates for re-exported and destroyed inventory.

Section 122 Tracker

Organized record-keeping for every Section 122 duty paid, ready for the next refund wave when the courts decide.

📋

Filing Path Decision Model

Enter product category and country of origin the model routes each entry to CAPE, Protest, Drawback, or PSC automatically.

📂

Executive SOP Slide Deck

Pre-built PowerPoint slides for stakeholder briefings, refund authorization, and procurement / finance alignment.

Grid of procurement, trade compliance, and supply chain professionals including VP of Supply Chain, Director of Procurement, Finance Controller, and Customs Broker who all benefit from the Complete Tariff Refund Suite

Who Should Use the Complete Tariff Refund Suite

For heads of compliance, supply chain, and procurement and the teams who actually file the claims:

  • Trade Compliance Managers tracking exclusion and protest eligibility
  • Customs Brokers preparing CAPE filings, protests, and drawback claims
  • Finance Controllers recovering overpaid duties to restore margin
  • Procurement Directors auditing historical import costs
  • CFOs and FPand A teams quantifying recovery impact for board reporting
  • Supply Chain Leaders coordinating refund efforts across business units

If you import goods subject to Section 301, Section 232, Section 122, or paid IEEPA duties before the February 2026 SCOTUS ruling, this Suite was built for you.

A team of five professionals in formal business attire sits around a glossy conference table during a strategy meeting. The leader in the center speaks with a confident expression. Behind them, large presentation boards display bar graphs, pie charts, and tariff-related data visuals. A dark banner headline above reads: Recover Overpaid Tariffs Without Consultants For Procurement, Trade Compliance, and Ops Teams

Buy Once. Update Forever.

The tariff landscape is moving weekly. So the Suite moves with it. Every update is pushed to every customer automatically no upgrade fees, no new SKU, no subscription. Customers who bought in February have received five major updates at no extra cost: the parallel-path repositioning (Feb), the seven-phase workflow rebuild (Mar), the v2.4 CAPE alignment release (Apr), the full v2.4 documentation propagation (May), and the v2.4.1 Phase 2 awareness update (May 23). The v2.5 Phase 2 release landed June 29 when the CAPE Phase 2 portal opened, and v2.6 added the Executive Interactive Command Center both already included, like every update before them. That is six major releases in six months, at no additional cost, on a product that cost $197 once.

🔒 Why You Can Trust This Suite

  • Not theory every component is plug-and-play ready
  • Created by Ramie Virk, a 20+ year procurement and tariff risk strategist
  • Built on actual CBP filing procedures and USTR.gov rulings
  • Refined through real-world use across $150M+ in import spend
  • Every update traces back to official CBP CSMS bulletins
  • Customer-validated: $1.2M recovered by one Fortune 500 manufacturer in a single quarter

What is the Executive Interactive Command Center and how does it work?

It is a single self-contained HTML file, included free with TRS-197. Open it in any browser, import your workbook, and it calculates KPIs instantly, assigns every entry a recommended filing action and deadline, and generates filing-ready documents with one click. Everything runs locally. Nothing is transmitted.

Six stages, start to finish: upload the workbook, get the dashboard automatically, review the recovery entries, generate the filing documents, fill your company profile once, and keep every byte on your own machine. New in v2.6 and included at no extra cost, like every update before it. A one-click Presentation Mode turns the dashboard into a five-slide, board-ready deck. See the full Command Center page → Or try the live interactive walkthrough →

From Updated Tracker to Recovery: The Six-Stage Command Center Workflow

The complete path from an Excel workbook sitting on your desktop to a filing-ready CBP document, in six connected stages. No exporting, no conversion, no upload to anyone’s server. Want to walk through every stage yourself, live, before you buy? See the full interactive walkthrough →

Six-stage workflow graphic for the Tariff Refund Suite Executive Interactive Command Center: upload workbook, automatic dashboard generation, review recovery entries, generate filing documents, company profile, and secure browser processing, shown as a connected grid of six screenshots
The complete workflow at a glance upload, dashboard, review, generate, profile, secure. Each stage is broken out below.
Executive Interactive Command Center Import Your Data screen for the Tariff Refund Suite TRS-197, showing the import panel where the user selects their Excel workbook directly from their computer
1 Live screenshot

Upload the Workbook

Import your Excel workbook directly into the Command Center. This is the entire setup step.

  • Import the Excel workbook directly no exporting
  • No copy and paste, no CSV conversion, no reformatting
  • Local browser processing from the moment the file is selected
Executive Interactive Command Center dashboard immediately after importing workbook data, showing automatically calculated KPI cards for recovery totals, filing counts, estimated refunds, and program summaries
2 Live screenshot

Automatic Dashboard Generation

The moment the import completes, the executive dashboard exists. You do not build it.

  • KPIs calculated instantly on import
  • Executive dashboard updates automatically
  • Recovery totals, filing counts, estimated refunds, and program summaries appear immediately
Annotated screenshot of the Recovery Refund Entries table in the Tariff Refund Suite Executive Interactive Command Center, with callouts showing the recommended filing action, deadline column, and one-click Generate document button for each qualifying customs entry
3 Live screenshot

Review Recovery Entries

Every imported entry is analyzed and returned with a decision attached, not just a number.

  • Every entry analyzed against all four pathways
  • Recommended filing action displayed per entry
  • One-click document generation on each qualifying record
Mockup illustration of a filing-ready document generated by the Tariff Refund Suite Executive Interactive Command Center, representing the automatic creation of CBP protest and refund filing paperwork from a selected entry
4 Illustrative mockup

Generate Filing Documents

Click Generate on a qualifying entry and the filing document is built from that entry’s data.

  • Live, filing-ready documents created automatically
  • Eliminates manual document preparation
  • Entry-level figures carry through, so the paperwork reconciles against CBP’s own records
Company Profile screen in the Tariff Refund Suite Executive Interactive Command Center, headlined Fill Once, Auto-Generate Documents, where company information is entered a single time and populates every generated filing document
5 Live demo · July 29, 2026

Company Profile: Fill Once

Your company details are entered exactly one time and then stop being your problem.

  • Enter company information once
  • Details auto-populate every generated filing document
  • Importer of record number, address, contact, and ACH enrollment status carry through
Mockup illustration of secure browser processing in the Tariff Refund Suite Executive Interactive Command Center, representing that workbook data stays on the user's computer and no file contents are transmitted to any server
6 Illustrative mockup

Secure Browser Processing

The reason compliance teams can actually use this without a security review.

  • Data remains on your own computer
  • No workbook contents are transmitted anywhere
  • Real-time calculations occur locally it keeps working offline

How do I import my workbook into the Command Center?

Three clicks. Open the Command Center, click Import Data, and select your workbook file. The upload modal lists every tracker it expects Section 301, 232, 122, Other Remedy and confirms each one as it loads. There is no field mapping to configure and no template to match.

Step by step annotated screenshot with arrows showing the Import Data modal in the Tariff Refund Suite TRS-197 Executive Interactive Command Center and where to click to begin the workbook upload
Step 1 · Open Import DataLaunch the import modal from the Command Center toolbar. Arrows mark each click target.
Screenshot of the Executive Interactive Command Center Import Data step that opens the operating system file picker box to select the Excel workbook for upload
Step 2 · Select your fileThe file picker opens. Choose your TRS-197 workbook straight from your own drive.
Annotated screenshot of the Import Your Data screen in the Tariff Refund Suite Executive Interactive Command Center with each loaded tracker workbook circled in green and labeled with what to do next
Step 3 · Confirm each trackerEvery loaded workbook is circled and confirmed. Green means the tracker is in and mapped.
Screenshot of the Executive Interactive Command Center Import Data panel listing each field with its uploaded workbook, showing Section 301, Section 232, Section 122 and Other Remedy trackers loaded and ready to import
The Import Data panel lists every field and the workbook loaded against it so you can see exactly what the dashboard is about to read before you commit.
Pop-up dialog in the Executive Interactive Command Center explaining what to upload to CBP's ACE portal for the auto-generated CAPE CSV export, dated July 23 2026
The CAPE CSV hand-off: the Command Center tells you exactly which file goes into the ACE Secure Data Portal, so the export is not a guess.

What does the tariff refund executive dashboard actually show?

Six executive KPIs on one screen: total entries, total duty at risk, estimated refund, projected recovery rate, entries requiring filing action, and overdue or at-risk deadlines plus program-by-program recovery totals and an automated executive recommendation telling you what to do next.

In the representative dataset shown below: 30 total entries, $694,243 in duty at risk, a 61.9% projected recovery rate, and 30 entries currently requiring filing action. Those are the four numbers a CFO asks for, generated from the same workbook your compliance team already maintains.

30Total entries
$694,243Duty at risk
61.9%Projected recovery rate
30Entries requiring action

Figures from the live Command Center demo dataset, July 29, 2026. Your numbers come from your own entries.

Full page screenshot of the Tariff Refund Suite Executive Interactive Command Center dashboard from the July 29 2026 live demo, showing KPI cards, executive recommendation, program recovery charts, and the recovery entries table
The full Command Center dashboard, top to bottom live demo, July 29, 2026.
Top half of the Executive Interactive Command Center dashboard showing all KPI cards in one place, including duty at risk, estimated refund, recovery rate, and entries requiring action
Every KPI card in one place no scrolling to assemble the picture.
Full top half of the Tariff Refund Suite Executive Interactive Command Center dashboard including the automated executive recommendation banner and summary metrics
The automated executive recommendation sits above the metrics, not buried under them.
Close-up of the Executive Interactive Command Center KPI dashboard cards only, from the July 29 2026 live demo
KPI cards in detail. Board-ready as rendered this is what Presentation Mode projects.
Live screenshot of the KPI Dashboard tab inside the Tariff Refund Suite TRS-197 Excel workbook, August 2026, showing duty at risk, estimated refund, recovery rate, entry counts and program level charts
The workbook’s own KPI Dashboard tab. Same source data, in Excel August 2026.

How does the Suite generate CBP filing documents from my entries?

Each row in the Recovery Entries table carries an estimated refund, filing status, remaining deadline window, and recommended action. Review the recommendation, confirm the deadline, click Generate, and the filing document is built from that entry’s own data PSC tracker, prefilled templates, CBP Form 19, and the refund workflow.

This is the step that normally costs $5,000 or more per claim at a consultancy: taking a qualified entry and turning it into paperwork CBP will accept. Because the document is built from the entry number and duty figures already in your workbook, the filing reconciles against CBP’s records which is what keeps a protest from being kicked back.

Annotated screenshot of the Tariff Refund Suite Executive Interactive Command Center showing the executive dashboard with 30 total entries, $694,243 in duty at risk, a 61.9 percent projected recovery rate, and 30 entries requiring filing action, with an enlarged overlay of the refund entries table showing estimated refund, filing status, remaining deadline, recommended recovery action, and the Generate document button, plus four icons for PSC Filing Tracker, Prefilled Templates, CBP Form 19, and Refund Workflow
Review the recommended action. Confirm the deadline. Click Generate. Each entry connects to an estimated refund, filing status, remaining deadline window, recommended recovery action, and a document-generation button backed by the PSC Filing Tracker, prefilled templates, CBP Form 19, and the refund workflow.
Auto-Generate from your Command Center graphic showing the journey from imported tracker data to filing-ready documents, listing the PSC filing tracker, prefilled templates, CBP Form 19, and refund workflow components

From Tracker to Filing-Ready

The Command Center’s Auto-Generate capability closes the last gap in refund recovery: the distance between knowing an entry qualifies and having a document CBP will accept.

  • PSC Filing Tracker every Post-Summary Correction logged against its liquidation date
  • Prefilled templates populated from your company profile and entry data
  • CBP Form 19 protest paperwork built per qualifying entry
  • Refund workflow status tracked from generation through ACH disbursement

Get the Suite $197 One-Time

Screenshot of filling out the company profile in the Tariff Refund Suite Executive Interactive Command Center with the ACH Enrollment Status drop-down open
Company profile setup, including the ACH Enrollment Status field. CBP pays CAPE refunds by ACH if your enrollment is not current, the refund is approved and then sits. The Suite tracks it as part of the profile, not as an afterthought.

Can I file tariff refunds without a customs broker or consultant?

Yes. An importer of record can file its own protests, PSCs, and CAPE submissions directly. Big 4 and specialist customs firms charge $15,000 to $35,000 per recovery engagement, or $5,000 and up per claim, often plus a contingency percentage. The work they sell is screening, calculation, document prep, and tracking.

That is precisely the work the Suite systematizes for a one-time $197. What still warrants licensed counsel or a broker: complex classification disputes, binding ruling requests, prior disclosure with penalty exposure, and anything already under CBP audit. The Suite is built to make the routine 90% self-service so your outside spend goes only to the genuinely hard 10%.

How is the Complete Tariff Refund Suite different from a free template pack?

A template pack gives you blank forms. The Suite gives you a connected system: data enters once and flows across 12 tools eligibility screening, automatic pathway routing, refund calculation, deadline tracking by entry number, CAPE-ready CSV export, ACH reconciliation, and one-click document generation.

Templates cannot tell you which entries qualify, what they are worth, or when the window closes. That is the entire job. A blank Form 19 is free from CBP; knowing which of your 400 entries belongs on one, and that 31 of them liquidate inside 45 days, is what actually recovers money.

Complete Tariff Refund Suite TRS 197 | Tariff Refund Suite™

End-to-End CAPE, Protest, Drawback and Exclusion Recovery

$197
One-time purchase · instant download · every update free, forever
  • CAPE Submission Prep (Phase 1 live, Phase 2 live now)
  • Refund Eligibility Screener (Section 301, 232, 122, IEEPA)
  • Filing Status Dashboard with ACH reconciliation
  • CBP Form 19 Protest templates and SOPs
  • Section 232 exclusion tracker with TRQ field
  • Duty Drawback Estimator (up to 99% recovery)
  • Section 122 record-keeping for the next refund wave
  • Filing Path Decision Model (auto-routes every entry)
  • Executive SOP slide deck and compliance checklists
  • Executive Interactive Command Center™ (new in v2.6) live dashboard, one-click document generation, 1-click board presentation
  • Works in Excel, Google Sheets, and LibreOffice
Get Instant Access $197 One-Time

Immediate download. No subscription. No API keys required. Every future update included.

Frequently Asked Questions

What is CBP’s CAPE portal and how does the Suite work with it?

CAPE (Consolidated Administration and Processing of Entries) is CBP’s official IEEPA refund portal, launched April 20, 2026 inside the ACE Secure Data Portal. CAPE accepts a CSV of entry numbers but does not identify eligible entries, calculate refunds, screen Phase 1 eligibility, or track recovery. The Suite handles everything before and after CAPE: identifies your IEEPA-eligible entries, flags which qualify for CAPE Phase 1 right now, prepares the CAPE-ready CSV, and tracks every refund through completion. CBP’s August 5, 2026 court filing shows more than $100 billion already paid out across 17.6 million-plus entries.

When does CAPE Phase 2 open and what does it cover?

CAPE Phase 2 has been live since June 29, 2026. Phase 2 covers entries CAPE Phase 1 left out: entries liquidated more than about 80 days ago, foreign-trade-zone (FTZ) entries including Type 06 withdrawals, drawback-linked entries, and entries flagged for reconciliation. The Suite’s Eligibility Checklist sorts every entry into Phase 1 now, Phase 2 (now live), or alternative pathway automatically. The v2.5 Phase 2 release shipped the moment the portal opened on June 29 already included in your purchase.

How is this different from filing through CAPE myself?

CAPE is a submission portal. It accepts entry numbers and processes the refund. It does not do the analysis. Without preparation, importers submit entries that get rejected, miss eligible entries entirely, and have no way to track which refunds have actually paid out. The Suite is the preparation and management layer: eligibility screening, refund calculation, CAPE-ready export, exclusion tracking, protest preparation for entries CAPE does not cover, and a Filing Status Dashboard.

What is happening with Section 122 and does the Suite cover it?

The 10% Section 122 tariff, imposed February 24, 2026 under the Trade Act of 1974 after the Supreme Court struck down IEEPA tariffs, expired July 24, 2026 at its 150-day statutory cap no new Section 122 duties are being collected. Expiration does not cut off refunds: Post-Summary Corrections remain available before liquidation and protests for 180 days after each entry liquidates. The Court of International Trade ruled Section 122 unlawful on May 7, 2026; the Federal Circuit stayed that ruling while the appeal proceeds, so duties collected during the stay may become refundable if the ruling stands. The Suite includes a Section 122 Tracker so every February 24 to July 24 entry is documented and audit-ready.

Do I need to know my HTS codes to use the Tariff Refund Suite™?

No. For refund filings, the HTS code is evidence, not an estimate CBP matches your protest or PSC against the code as filed on your CBP Form 7501. So the workbook asks you to copy codes from the same documents your Duty Paid figures come from: your 7501, your ACE Entry Summary report, or your broker’s statement. It is one paste operation, not a memory test. Once the code and country are in, the workbook auto-fills today’s rate, the estimated duty at current rates, and the region the comparison baseline that makes your refund gap visible. Need to research codes for future sourcing decisions? That is what the Tariff Auto-Fill Tool™ (TAF-097) is built for.

Why does the workbook track one row per CBP entry instead of one row per product?

Because that is how CBP pays refunds. Duty is assessed per entry (CBP Form 7501), and every refund vehicle CAPE, Post-Summary Correction, protest, drawback is keyed to entry numbers, not product SKUs. One product can appear across many entries at different rates. Tracking at the entry level means the numbers on your generated filing documents reconcile against CBP’s own records which is exactly what keeps a protest from being kicked back.

What types of refunds does the Suite cover?

IEEPA refunds through CBP’s CAPE portal (Phase 1 and Phase 2), Section 301 China tariff exclusion refunds, Section 232 steel and aluminum exclusion refunds, Duty Drawback claims (up to 99% recovery on exported or destroyed goods), CBP protest filings under Form 19, Post-Summary Corrections (PSC) for unliquidated entries, USTR exclusion renewal filings, and Section 122 record-keeping for the next refund wave.

Do I get future updates if I buy now?

Yes. The Suite is a one-time $197 purchase that includes every future update automatically. No subscription, no upgrade fees, no new SKU when the product changes. Customers who bought in February have received five major updates at no additional cost. The v2.5 Phase 2 release shipped on June 29 and is already included.

Do I need advanced Excel skills to use the Suite?

No. The workbook uses locked logic for the calculations and editable inputs for your data, so you cannot accidentally break a formula. You enter your entries in the Data Input tab and the rest of the workbook updates automatically. Most teams complete their first refund filing within 60 minutes of opening the Suite. Works in Excel, Google Sheets, and LibreOffice no plugins required.

Who should buy the Complete Tariff Refund Suite?

Trade compliance managers running multi-authority refund programs, customs brokers preparing protest filings and drawback claims for clients, finance controllers recovering overpaid duties to restore margin, procurement directors auditing historical import costs, and CFOs or FPand A teams quantifying recovery impact for board reporting.

How long do I have to file a tariff refund claim?

Each pathway runs its own clock. A CBP protest must be filed within 180 days of liquidation under 19 U.S.C. §1514. A Post-Summary Correction must be filed before liquidation and no later than 15 days before the scheduled liquidation date. Duty drawback claims run 5 years from the date of import under 19 U.S.C. §1313. Section 301 exclusion refunds are tied to the retroactivity date in the specific Federal Register exclusion notice. Entries generally liquidate 314 days after entry which is why a missed liquidation date is the single most common reason a refund is lost.

Which refund pathway applies to my entry CAPE, protest, drawback, or PSC?

It depends on four variables: which tariff authority you paid under, the country of origin, whether the entry has liquidated, and whether the goods were later exported or destroyed. IEEPA duties route to CAPE. Section 301 and 232 exclusion refunds on liquidated entries route to a CBP Form 19 protest. Unliquidated entries with a classification or valuation error route to a PSC. Goods exported or destroyed within 5 years route to drawback. The Filing Path Decision Model applies those four tests to every row automatically.

What is the Executive Interactive Command Center™ and how does it work?

It is a single self-contained HTML file included free with the Suite. You open it in any browser and import your TRS-197 workbook directly. It reads the Section 301, 232, 122, and Other Remedy tracker tabs, calculates KPIs instantly, assigns each entry a recommended filing action and deadline window, and generates filing-ready documents with one click. All processing happens locally in your browser no workbook contents are transmitted, there is no account, and it runs offline. A one-click Presentation Mode converts the dashboard into a five-slide board-ready deck.

How much can I actually recover in tariff refunds?

Recovery depends on your entry volume and which authorities you paid under, but the scale is set by the underlying programs. Section 301 List 3 alone covers roughly $200 billion in annual Chinese-origin trade at 25%, and List 4A covers roughly $120 billion at 7.5%. In a representative 30-entry Command Center dataset, $694,243 in duty at risk produced a 61.9% projected recovery rate. Drawback recovers up to 99% of duties paid on goods later exported or destroyed. One Fortune 500 manufacturer recovered $1.2 million in a single quarter using these tools.

What data do I need before I can start a refund claim?

Five fields per entry, all of which appear on documents you already hold: the CBP entry number, the entry date, the HTS code as filed, the country of origin, and the duty paid. Every one comes off your CBP Form 7501, your ACE Entry Summary report, or your broker’s statement. You do not need to research or estimate anything. Paste those five columns into the Data Input tab and the workbook fills in current rates, the estimated duty gap, the applicable authority, and the routing decision.

Can I file tariff refunds without a customs broker or consultant?

Yes. An importer of record can file its own protests, Post-Summary Corrections, and CAPE submissions directly. Big 4 and specialist customs firms typically charge $15,000 to $35,000 for a refund recovery engagement, or $5,000 and up per individual claim, often plus a contingency percentage of what they recover. The work they do is eligibility screening, refund calculation, document preparation, and status tracking exactly what the Suite systematizes for a one-time $197. Complex classification disputes, binding ruling requests, and anything already under CBP audit still warrant licensed counsel or a broker.

How is this different from a free template pack?

A template pack gives you blank forms. The Suite gives you a connected system. Data enters once on the Data Input tab and flows across 12 tools: eligibility screening against Section 301, 232, 122 and IEEPA, automatic pathway routing, refund calculation, deadline tracking by entry number, CAPE-ready CSV export, a Filing Status Dashboard with ACH reconciliation, and the Executive Interactive Command Center that generates the actual filing documents. Templates cannot tell you which entries qualify, what they are worth, or when the window closes.

Real Recovery. Real Dollars.

★ ★ ★ ★ ★

“We recovered $1.2 million in tariff refunds in one quarter using the Tariff Refund Tools, without hiring outside consultants.”

— VP of Trade Compliance, Fortune 500 Manufacturer

★ ★ ★ ★ ★

“These tools cut our tariff risk by 30% and saved two weeks of manual analysis.”

— Supply Chain Director, GlobalTech

★ ★ ★ ★ ★

“Our broker was not tracking exclusion renewals. The Suite flagged three product categories that qualified for refunds we did not know about.”

— VP Supply Chain, SMB Importer

The Suite Is the Recovery Layer. Here Is the Full Ecosystem.

The Tariff Refund Suite handles recovery. The rest of the ecosystem handles identification, modeling, strategy, and governance.

Data Backbone

Tariff Auto-Fill Tool

3,327 verified HTS rate lines with auto-fill VLOOKUP, Section 301/232/122 overlays, and 50-country trade program reference. Feeds clean tariff data into every other tool.

Tier 2b Visibility

Tariff Impact Automation Suite

Dynamic dashboards, supplier risk alerts, automated scenario snapshots. See your full tariff exposure once you have recovered the dollars.

Tier 4 Enterprise OS

Tariff Defense Masterplan

Full Tariff Operating System with ERP integration (SAP / Oracle / NetSuite / D365). Replaces $50K-$150K Big 4 consulting.

CAPE Refunds Are Paying Out Right Now.

CAPE Phase 1 and Phase 2 are both open. More than $100 billion has already been paid out across 17.6 million-plus entries. Meanwhile the 180-day protest window is closing on older entries, and Section 122 expired July 24 with its refund clocks now running. A pending government appeal has also frozen refunds on finally liquidated entries, roughly $11.4 billion, so knowing each entry’s liquidation status now decides whether that money comes back or stays with CBP.

The v2.6 release, including the Executive Interactive Command Center, is already in your download. One time, $197, every future update included.

Start Recovering Duties $197 One-Time

Instant download · no subscription · every future update free, forever

© 2026 Career Chronicles. All rights reserved.

Created by Ramie Virk · careerchronicles.org · support@careerchronicles.org

This tool is designed for tariff recovery modeling and refund eligibility analysis. It is not a legal advisory platform. Tariff and refund rules change rapidly always verify filing requirements through CBP CSMS bulletins, hts.usitc.gov, or a licensed customs broker before submitting any claims.

Career Chronicles tariff tools

Choose the support your team needs

Start with a free resource or select a complete toolkit. Every card opens the product checkout page.

90-Day Tariff Risk Calendar dashboard preview 90-Day Tariff Risk Calendar™ Free Track critical tariff deadlines, comment periods, refund windows, and team actions in a practical 90-day dashboard. Get Free Access → US Tariff Rate Lookup by HS code and country US Tariff Rate Lookup Free Look up current US tariff rates by HS code and country, with a free companion tariff-rate export. Get Free Access → Tariff Auto-Fill Tool product cover Tariff Auto-Fill Tool™ $97 Auto-populate HS codes, duty rates, and landed-cost estimates across your product catalog, including Section 301 and 232 overlays. View Checkout → Tariff Playbook Suite product cover Tariff Playbook Suite™ $27 Plug-and-play calculators, checklists, and action plans, with 60+ live formulas and auto-calculating dashboards. View Checkout → Fast Track Executive Briefing Kit product cover Fast Track Executive Briefing Kit™ $19 Executive-ready templates, calculator, and slide deck to communicate tariff impact to leadership fast. View Checkout → Tariff Refund Suite product cover Tariff Refund Suite™ $197 Templates, trackers, and step-by-step guides to file CBP protests and claim tariff refunds and duty drawback. View Checkout → Tariff Impact Automation Suite product cover Tariff Impact Automation Suite™ $199 Excel dashboards, supplier-risk alerts, and scenario planners for tariff cost tracking and sourcing decisions. View Checkout → Tariff Scenario Strategy Kit product cover Tariff Scenario Strategy Kit™ $449 Premium scenario modeling with scoring, automation, and an integrated duty-drawback calculator. View Checkout → Strategic Command Suite product cover Strategic Command Suite™ $849 Scenario planning, boardroom briefing, and supply-chain tools for advanced tariff strategy and communication. View Checkout → Tariff Defense Masterplan product cover Tariff Defense Masterplan™ $1,299 Enterprise dashboards, strategy, automation, and executive deliverables for tariff risk, compliance, and crisis management. View Checkout →

Frequently Asked Questions

Find answers to commonly asked questions about our products and services.

Trusted by Procurement Leaders

“These tools cut our tariff risk by 30% and saved 2 weeks of manual analysis.”

A frustrated business executive looking at financial reports with tariff-related concerns in a dark ofice with a spotlight lamp

— Supply Chain Director, GlobalTech

Flagship Product: Tarriff Defense Masterplan

Scroll to Top