The complete CAPE Edition refund operating system. Identify overpayments, determine the correct filing path, organize documentation, and prepare executive-ready recovery materials — across every major tariff program.
TRS-197 is a complete 11-module refund operating system for Section 301, Section 232, Section 122, IEEPA/CAPE, USTR exclusions, and duty drawback workflows — built around a single 20-tab Excel workbook with connected trackers, dashboards, filing logic, CAPE prep, ROI analysis, and deadline monitoring.
Enter your entries once. The system flags eligibility, calculates deadlines and estimated refunds, routes each entry to the correct filing path, and assembles an audit-ready filing package — plus executive briefing decks for leadership approval.
Capture potential refunds across all major tariff categories — 301, 232, 122, IEEPA/CAPE, USTR exclusions, and duty drawback — in one system.
Built-in deadlines, eligibility checks, and filing safeguards so refund windows are tracked and preserved, not missed.
Step-by-step workflows, protest and cover-letter templates, and proof-of-documentation checklists for clean, defensible filings.
KPI dashboards, ROI analysis, and a Refund Scenario Forecaster for what-if modeling and smarter recovery decisions.
Organized, defensible, and designed for internal and external review — with executive recovery briefing decks included.
Use the CAPE Submission Prep tab for eligible IEEPA entries and file in as little as 60–90 days for ACH refunds.
v2.6 CAPE Edition — Complete Refund Recovery System
Immediate download. No subscription. Works in Excel, Google Sheets & LibreOffice.
Important: This toolkit supports internal review, filing preparation, and executive communication. It does not determine legal eligibility, guarantee refund outcomes, or replace review by a licensed customs broker, customs attorney, or qualified trade advisor.
If you paid U.S. import tariffs in the last few years, some of that money is likely recoverable. These are the questions that decide whether you leave it with CBP or bring it back.
If you imported goods into the U.S. and paid Section 301 (China), Section 232 (steel/aluminum), Section 122, IEEPA, or antidumping/countervailing duties, you very likely have refundable entries. Whether you can recover depends on which tariff you paid and whether the entry is still open (unliquidated) or already finalized (liquidated).
TRS-197 screens every SKU you enter across all four pathways at once and tells you exactly which refund applies, so you are not guessing.
It scales with your import volume and which tariffs you paid, but the numbers are material. IEEPA tariffs alone have driven more than $23 billion in approved CAPE refunds. In the Suite's worked example, a single China battery SKU shows $68,750 in refundable duty and a $58,437 estimated refund at an 85% success rate.
The Refund Scenario Forecaster pulls your units, unit cost, and tariff rate straight from your data and calculates your refundable duty and estimated refund before you commit a minute to filing.
Section 301 covers Chinese-origin goods; Section 232 covers steel and aluminum; IEEPA tariffs were the emergency-powers tariffs the Supreme Court struck down in February 2026; duty drawback applies when you later export or destroy imported goods. Most importers have a mix. The Eligibility Checklist reads your entries and labels each one automatically.
Usually not. Once an entry liquidates, you have exactly 180 days to file a CBP Protest (Form 19) -- your last window to recover overpaid duties on a finalized entry. Separately, duty drawback claims run up to 5 years from import.
TRS-197 calculates your liquidation date and every downstream deadline for each entry, so a window never lapses without you seeing it coming.
A Post-Summary Correction (PSC) is filed before liquidation to fix the duty on an open entry -- up to 300 days from entry, or 15 days before liquidation, whichever comes first. A Protest (Form 19) is filed after liquidation, within 180 days. The Filing Path Decision Model tells you which route each entry is on.
Because the deadlines do not wait for the courts. CBP has asserted it cannot refund finally liquidated entries without an importer-specific court judgment, and the government has appealed the universal refund order. If your entries are CAPE-eligible now, waiting risks lost time -- if they are already finally liquidated, your protest and litigation windows close on their own schedule.
CAPE (Consolidated Administration and Processing of Entries) is CBP's official IEEPA refund portal inside the ACE Secure Data Portal. You upload a CSV of eligible entry numbers and CBP issues ACH refunds, generally within 60-90 days.
CAPE is the mailbox, not the letter -- it does not tell you which entries qualify or calculate your refund. TRS-197 builds the CAPE-ready CSV and routes non-IEEPA entries to Protest, Drawback, or PSC.
CAPE handles one step of a multi-step process, and only for IEEPA. It will not identify your eligible entries, compute your refundable duty, manage your deadlines, generate your Form 19 or broker emails, or give leadership a recovery report. The portal is where you submit; the Suite is how you know what to submit.
Customs brokers typically charge $5,000 to $15,000 per refund cycle, often a percentage of what they recover. TRS-197 is a one-time $197 purchase that gives your team the same workflow, templates, and decision logic in a workbook you own. Most teams file their first refund within 60 minutes, and the Suite formats outputs for broker handoff if you want to use both.
No. You type raw import data into one tab -- SKU, supplier, country, units, unit cost, HS code, import date. Everything else, including tariff rates, eligibility, deadlines, and refund estimates, calculates itself. The workbook is locked so you can only type in the input cells and cannot break a formula.
If those entries carried Section 301, 232, or IEEPA duties, even a handful can represent thousands of dollars. At $197 one-time, the Suite pays for itself on the first small refund, and you keep it, updates included, for every future entry.
You get the 20-tab Master Workbook with auto-calculated eligibility and refunds, CAPE Submission Prep, 30+ Word filing templates, 15+ PDF SOPs and checklists, and Executive Recovery Briefing decks. It's a one-time $197 purchase, and every future update is free, forever.
The same refund, three ways to get it:
| Do It Alone | Customs Broker | TRS-197 | |
|---|---|---|---|
| Cost | Your time | $5K-$15K / cycle | $197 one-time |
| Finds eligible entries | Manual research | Yes | Automatic screening |
| Calculates refund | Spreadsheet math | Yes | Built-in forecaster |
| Tracks deadlines | On you | Yes | Auto-calculated |
| Filing templates | Build from scratch | Broker's | 30+ included |
| You own the workflow | Yes | No | Yes, forever |
TAF-097 is the data backbone for TRS-197. Paste 3,327 verified HTSUS 2026 rate lines into the Tariff Rates tab and every HS Code lookup across your new workbook — Data Input, all 4 Section Trackers, the Refund Scenario Forecaster — auto-fills Tariff Rate and Product Category instantly. Zero formula changes required.