ACE Export Field Guide (Entry Summary + Account Revenue)

Informational only — not legal advice.

Is this enough?

People often say “I have an ACE export,” but ACE can mean different report universes (and some “ACE exports” are really broker spreadsheets).

Use this table to decide what you need next:

RefundArrow note: ACE exports are often better than PDFs for bulk analysis. But we still work well with Form 7501 PDFs (including continuation sheets) — and we can start from customs invoices/packets if that’s what you have.

What to ask for

If you’re requesting data from a broker/forwarder (or from the IOR), the goal is a joinable entry list and the line-level duty detail that’s equivalent to a 7501 packet.

Request #1 — Entry Summary export (line-level)

Ask for an export that includes line detail for each entry (often described as “Entry Summary,” “Entry Detail,” or “Tariff line detail”).

Minimum columns to ask for:

• Entry number
• Entry date
• Port code
• Importer number (and importer name if available)
• HTS (10-digit) per line
• Chapter 99 / “special tariff” code per line (or any HTS values in Chapter 99)
• Duty amount per line (or at least duty assessed per line)

Helpful extras (don’t require, but ask if available):

• Entry type
• Country of origin
• Line number
• Entered value / quantity
• Consignee number/name

Request #2 — Account Revenue export (liquidation/payment)

If you need liquidation status/date (often you do for deadlines), ask for an Account Revenue export (sometimes described as “Revenue,” “Statements,” or “Payments”).

Minimum columns to ask for:

• Entry number
• Liquidation status and/or liquidation date (if present)
• Statement identifiers (if present)
• Amounts paid/refunded and dates (as available)

Request #3 — If you don’t have entry numbers yet (Cargo Release or an “entry number list”)

If you only have tracking/AWB/BOLs (or customs invoices with no entry numbers), ask for either:

• a Cargo Release export that ties shipments to entry numbers, or
• a simple “entry number list” for the time window tied to your shipments/reference numbers.

How to tell what you got

You don’t need to be an ACE expert — you just need to confirm the export contains the fields that unlock analysis.

1) Does it include line-level tariff detail?

Good signs (Entry Summary style data):

• columns like HTS, HTS number, tariff, Chapter 99, special tariff
• line identifiers (line number)
• duty amounts at the line level

If you don’t see HTS/Chapter 99 + duty amounts: it’s likely not enough for tariff-program analysis on its own.

2) Does it include liquidation/payment fields?

Good signs (Account Revenue style data):

• liquidation date / liquidation status
• statement/payment fields (monthly statement identifiers, amounts, dates)

If your export has great tariff lines but no liquidation fields, that’s normal — you may need the second export.

3) Spreadsheet hygiene: don’t let Excel destroy entry numbers

Entry numbers and related identifiers often have leading zeros. Keep the raw CSV or ensure “Entry Number” is treated as text (avoid scientific notation).

4) IEEPA vs Section 122 (quick triage)

For refund review, scope matters:

• IEEPA duties: entries in the window Feb 4, 2025 → Feb 24, 2026 (12:00 a.m. ET).
• Section 122 is a separate surcharge starting Feb 24, 2026 (12:01 a.m. ET) and appears under 9903.03.01 (with exemptions 9903.03.02–9903.03.11) — don’t count it as IEEPA.

If you see other 9903.* Chapter 99 headings in the IEEPA window, treat that as a “needs mapping” signal and prioritize getting the full line-level export or 7501s.

One important ACE detail: the ordinary Chapter 1-97 tariff number can appear with more than one Chapter 99 overlay on the same line. CBP’s reporting order puts Section 301 Chapter 99 headings before Section 232 / 201 duty headings, then quota headings, with the base commodity classification still carrying the entered value. So a “second tariff number” is not always the whole story.

If you can’t get ACE exports

Ask for either of these “good enough” substitutes:

1. Form 7501 PDFs (including continuation sheets, if any), or
2. a broker “entry detail” export that includes entry number + HTS/Chapter 99 + duty amounts.

If you only need liquidation status and you have entry numbers, CBP’s public liquidation bulletin can sometimes help (recent postings are retained online for a limited window).

What to do once you have the exports

• Confirm the Importer of Record (IOR) per entry (don’t guess from invoices).
• Extract HTS + Chapter 99 lines + duty amounts (line-level is best).
• Treat liquidation status/date as a separate field you may need to source from revenue/statement data.
• Upload what you have.