CSV upload & manual entry
You can upload ACE entry summary CSVs via drag-and-drop or enter up to 20 entries manually. The parser recognizes standard ACE column names (Entry Number, Entry Date, Import Date, Country of Origin, HTS Code, Duty Paid, etc.) and common variants used by brokers like Flexport, e-Customs, and CustomsCity. If you export directly from the ACE Secure Data Portal, the format is usually compatible.
Deterministic + AI fallback parsing
We first try deterministic column mapping: matching your headers to our known column names (case-insensitive, with minor variations). If fewer than 7 of 10 required columns match, or if the entry number column is missing, or if we parse zero entries from a non-empty file, we fall back to AI-assisted extraction. The AI attempts to infer structure from raw CSV text, which helps with broker exports that use non-standard headers or layouts.
IEEPA duty identification
IEEPA tariffs are all in Chapter 99 of the HTS (9903.01.xx and 9903.02.xx). We maintain a versioned registry of these codes with their rates, Executive Order authority, effective date ranges, and country-of-origin applicability. Each line in your entry is checked against this registry: the HTS code must match, the country of origin must be in the code's "applies to" list (or "*" for all countries), and the import date must fall within the code's effective window. Only matching lines are counted as refundable.
Refund estimate & interest
For entries that have explicit IEEPA Chapter 99 line items with duty amounts, we sum those amounts as the refundable total. We also estimate interest under 19 U.S.C. § 1505(c), which governs overpayment interest on customs duties. The interest calculation uses the federal overpayment rate and the expected refund timeline (PSC vs. Protest), so your estimate includes both principal and accrued interest.
Refund pathways (PSC, Protest, CIT)
The tool assigns one pathway per entry. PSC (Post-Summary Correction) applies to unliquidated entries — you can file a PSC in ACE to correct the entry before liquidation. Protest applies to liquidated entries: you have 180 days from the liquidation date to file CBP Form 19; this window is absolute and cannot be extended. CIT (Court of International Trade) is the only option once the protest window has closed. UNCLEAR is used for suspended liquidation or ambiguous cases.
PSC & Protest deadline computation
PSC deadline: The earlier of (a) entry date + 300 calendar days, or (b) estimated liquidation date − 15 days. Per 19 C.F.R. § 173.4a, you must file the PSC before liquidation. If your entry is unliquidated and you don't have a liquidation date, we estimate it as import date + 314 days, rounded to the next Friday (CBP standard practice per 19 C.F.R. § 159.11).
Protest deadline: Liquidation date + 180 calendar days. Per 19 U.S.C. § 1514(c)(3), this is absolute — no extensions, no equitable tolling. Missing it bars the protest remedy.
Urgency classification
Each deadline gets a color-coded urgency level: Safe (>90 days left), Watch (30–90 days), Urgent (10–30 days), Critical (<10 days — file immediately), and Expired (deadline passed, CIT only). The calendar and entry table use these to help you prioritize which entries to file first.
Results dashboard, iCal & CSV export
The dashboard has three tabs: Summary (total refund, pathway breakdown, top entries), By Entry (full sortable/filterable table), and Deadline Calendar (monthly grid with urgency dots). You can export deadlines to .ics (Google Calendar, Apple Calendar, Outlook) with reminder alarms, and export the full computed dataset as CSV.