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.

Tariff Refund Suite™ For Importers, Trade Compliance, Procurement, Operations Leaders, Supply Chain, and Finance Leaders
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.

Not sure yet? Try the live Command Center walkthrough before you buy →
US Tariff Refund Status Mid-2026
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.
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.
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.
















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.



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.

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 PathCAPE 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 NowWhich 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.

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 PathCBP 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 LiquidationDuty 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 WindowPost-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 OnlyHow 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.
| Pathway | Deadline | Clock starts | Authority |
|---|---|---|---|
| CBP Protest (Form 19) | 180 days | Date of liquidation | 19 U.S.C. §1514 / 19 CFR Part 174 |
| Post-Summary Correction | Up to 15 days before liquidation | Date of entry summary filing | 19 CFR 141.101 / ACE PSC policy |
| Duty Drawback | 5 years | Date of import | 19 U.S.C. §1313 / TFTEA |
| CAPE (IEEPA) | Phase 1 and Phase 2 both open | Portal opened April 20, 2026 · Phase 2 June 29, 2026 | CBP CSMS guidance, ACE Secure Data Portal |
| Section 301 exclusion refund | Per-exclusion retroactivity date | Federal Register exclusion notice | USTR exclusion notices / Section 301 of the Trade Act of 1974 |
| Section 122 | PSC before liquidation · protest 180 days after | Entry dates Feb 24 – Jul 24, 2026 | Section 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.
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.
| Program | Scale of covered trade | Rate | Refund route in the Suite |
|---|---|---|---|
| Section 301 List 1 | ~$34 billion | 25% | Exclusion refund → Form 19 protest / PSC |
| Section 301 List 2 | ~$16 billion | 25% | Exclusion refund → Form 19 protest / PSC |
| Section 301 List 3 | ~$200 billion | 25% | Exclusion refund → Form 19 protest / PSC |
| Section 301 List 4A | ~$120 billion | 7.5% | Exclusion refund → Form 19 protest / PSC |
| Section 232 steel and aluminum | Derivative lists expanded repeatedly since 2018 | Varies by product and country | Exclusion refund + TRQ / quota tracking |
| IEEPA (struck down Feb 20, 2026) | $166B+ refund pool · 330,000+ eligible importers | Varies | CAPE Phase 1 and Phase 2 |
| Section 122 (Feb 24 – Jul 24, 2026) | Global, 150-day statutory cap reached | 10% | 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.

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.

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 →


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

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

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

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: 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

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.





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.
Figures from the live Command Center demo dataset, July 29, 2026. Your numbers come from your own entries.





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.


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

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
- ✓ 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
Immediate download. No subscription. No API keys required. Every future update included.
Frequently Asked Questions
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.”
“These tools cut our tariff risk by 30% and saved two weeks of manual analysis.”
“Our broker was not tracking exclusion renewals. The Suite flagged three product categories that qualified for refunds we did not know about.”
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.
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.
Tariff Impact Automation Suite
Dynamic dashboards, supplier risk alerts, automated scenario snapshots. See your full tariff exposure once you have recovered the dollars.
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-TimeInstant download · no subscription · every future update free, forever
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™ 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 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™ $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™ $27 Plug-and-play calculators, checklists, and action plans, with 60+ live formulas and auto-calculating dashboards. View Checkout →
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™ $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™ $199 Excel dashboards, supplier-risk alerts, and scenario planners for tariff cost tracking and sourcing decisions. View Checkout →
Tariff Scenario Strategy Kit™ $449 Premium scenario modeling with scoring, automation, and an integrated duty-drawback calculator. View Checkout →
Strategic Command Suite™ $849 Scenario planning, boardroom briefing, and supply-chain tools for advanced tariff strategy and communication. View Checkout →
Tariff Defense Masterplan™ $1,299 Enterprise dashboards, strategy, automation, and executive deliverables for tariff risk, compliance, and crisis management. View Checkout → Tariff Refund Suite™ | Tools
All tools are downloadable as Excel, Word, and PDF.
No subscription. No guesswork. Just compliant, complete results.

Frequently Asked Questions
Find answers to commonly asked questions about our products and services.
Flagship Product: Tarriff Defense Masterplan™
Key Benefits: Tariff Supply Chain Resilience withReliable updates, scenario planning, executive visuals, and proactive compliance all essential for cost control.

Why you need the Tarriff Defense Masterplan and How to Fix Risk
Tired of scrambling every time tariffs change with disconnected spreadsheets, outdated consultant PDFs, and endless meetings.
The Awnser is Simple The Tariff Defense Masterplan this is how it Delivers:
Free weekly briefing
Know the tariff shift before it hits your bottom line.
Join procurement and supply chain leaders getting the Procurement and Tariff Intelligence Newsletter™ — concise, executive-ready briefings on tariffs, trade risk, and sourcing strategy from The Procurement Perspective™.
Free. Unsubscribe anytime. Delivered securely via Substack.