Stable

How to Reconcile ACE Duty Reports With Broker Records

Reis Renneker

Written by Reis Renneker

A practical framework for reconciling ACE duty data, broker records, CF 7501 totals, MPF, ADD/CVD, payments, and refunds.

How to Reconcile ACE Duty Reports With Broker Records

When an ACE duty report differs from cash paid to CBP by millions of dollars, the problem is rarely solved by adding another column. Reliable reconciliation requires matching entry summaries, payment statements, broker records, fees, refunds, and reporting dates at the entry level before reviewing aggregated monthly totals.

Why ACE Duty Totals May Not Match Cash Paid

An ACE duty report can represent a different population and accounting period from the amount recorded in an importer’s general ledger. Entry date, entry summary date, statement date, payment date, and liquidation activity each answer a different question. Comparing totals built on different dates can create significant timing differences, particularly for high-volume importers using periodic monthly statements.

Separate Duty Liability From Cash Movement

The total declared on CBP Form 7501 reflects the entry summary obligation at filing. It does not necessarily establish when the amount was withdrawn, who funded the payment, whether the entry was later corrected, or whether CBP issued a refund.

A complete reconciliation should distinguish among:

  • Duties and fees declared on the filed entry summary
  • Amounts appearing on daily or periodic statements
  • Payments withdrawn directly from the importer
  • Amounts advanced by a customs broker and billed as pass-through charges
  • Post-summary corrections and other entry adjustments
  • Liquidation changes, refunds, and supplemental bills
  • Rejected, canceled, or replaced entry summaries

Commercial invoices are not sufficient evidence of the total duties paid. They support classification, valuation, origin, and transaction details, but they do not show every CBP assessment, payment event, or subsequent adjustment.

A discrepancy can also result from differences in importer of record numbers, filer codes, ports, entry types, or broker populations. An ACE query that omits one importer suffix or filters on the wrong filer can exclude a substantial block of activity. Before investigating individual tariff lines, the compliance team should confirm that both datasets cover the same entities, entries, dates, and transaction statuses.

Building a Complete Customs Duty Reconciliation

A dependable customs duty reconciliation begins with entry-level records rather than monthly totals. The importer should request a complete transaction package from each customs broker and independently compare it with ACE data and internal accounting records.

Request the Right Records From Every Broker

Customs brokers can generally provide reports showing duties and charges transmitted or paid on an importer’s behalf. The requested package should include:

  • Copies or electronic data from all filed CBP Form 7501 entry summaries
  • Daily statements and periodic monthly statements
  • Entry-level duty, tax, and fee extracts
  • Broker invoices and disbursement detail
  • Payment dates and payer identification
  • Post-summary corrections, cancellations, and replacements
  • Refunds, supplemental bills, and other adjustments known to the broker

The request should specify the importer of record numbers, date basis, entry types, ports, and filer codes. It should also state whether the report must include ordinary customs duty, merchandise processing fee, harbor maintenance fee, antidumping duty, countervailing duty, and Chapter 99 duties.

Create an Entry-Level Control Table

Each dataset should be normalized into a control table keyed by entry number. Useful fields include entry date, summary date, statement date, payment date, importer number, filer code, port, entered value, regular duty, Chapter 99 duty, MPF, HMF, ADD/CVD, total amount, payer, and adjustment status.

The ACE Portal importer sub-account also includes a Financial Transactions tab that consolidates certain payment and refund functions. Importers can use that information with entry summary header and tariff-line reports to validate broker-provided data rather than relying exclusively on broker invoices.

ACE fields and layouts continue to evolve. For example, the Foreign Importer of Record enhancement planned for production on January 5, 2027 adds importer-related indicators to entry summary records. Compliance teams should regression-test saved ACE reports whenever field definitions, filters, or portal functionality change.

Handling MPF and Other Line-Level Reporting Issues

Merchandise processing fee reporting is a common source of apparent duplication. ACE can display itemized MPF at the tariff-line level, including situations where a product has both a Chapter 1-97 classification and an associated Chapter 99 line. That presentation does not mean CBP assessed a separate full MPF for every displayed tariff line.

Reconcile MPF to the Entry Total

MPF is generally calculated at 0.3464 percent of entered value and is subject to a minimum and maximum per formal entry. For fiscal year 2027, effective October 1, 2026, the minimum is $34.58 and the maximum is $670.86. The controlling reconciliation amount should be the entry-level MPF total shown on the filed entry summary and applicable statement, not an unreviewed sum of every MPF value displayed in a line report.

Removing apparent duplicate MPF amounts may be appropriate when ACE repeats an allocated or informational value across related lines. However, compliance teams should not delete values solely because two rows look similar. The rows should first be matched by entry number, item number, tariff sequence, entered value, and Chapter 99 relationship.

Parts-of-sets reporting can create a similar problem. In some extracts, value appears on a header line and again on component lines. Summing both populations can double entered value and distort duty or fee analytics. Those records should be identified through line-type fields and tested against the corresponding Form 7501.

Use a Controlled Investigation Process

A practical investigation should follow these steps:

  1. Select entries from large discrepancy months and multiple brokers.
  2. Compare each Form 7501 with the ACE header and tariff-line reports.
  3. Reconcile the entry summary total to the applicable statement.
  4. Match the statement payment to the importer’s bank or broker invoice.
  5. Separate timing differences from genuine missing transactions.
  6. Categorize differences by duty, fee, ADD/CVD, refund, adjustment, or data duplication.

Once recurring causes are identified, the same rules can be applied across the full population without relying on unsupported manual deletions.

Recent Developments
  • On November 10, 2026, CBP issued updated ACE CATAIRs (including Entry Summary Create/Update V112) and error dictionaries for the Foreign Importer of Record enhancement.* CERT environment deployment occurred November 12, 2026, with production planned for January 5, 2027. New fields such as U.S. Importer of Record Indicator were added to entry summary records. This may affect how ACE reports display IOR, broker, and related duty/fee data.
  • CBP introduced a new Financial Transactions tab in the ACE Portal importer sub-account on October 29, 2026.* It consolidates ACH refund authorization and related payment functions, with automatic data retrieval. Importers can use this (along with existing ACE Reports such as ES-001 header details and ES-003 line tariff details) to independently track duties, fees, payments, and refunds paid to CBP, without relying solely on broker invoices or commercial invoice copies.
  • ACE Reports support itemized MPF and HMF at the tariff line level (a capability available since 2014 enhancements).* This explains why reports often show MPF amounts on each HTS line (for example, Chapter 85 and Chapter 99 on the same item). MPF is actually assessed once per entry at 0.3464% of entered value, subject to the FY2027 per-entry minimum of $34.58 and maximum of $670.86 (effective October 1, 2026). Removing duplicate line-level MPF amounts can prevent over-counting when summing, but totals should always be reconciled against the actual CF 7501 entry summary (or header-level data) rather than line sums alone. ADD/CVD and other fees should be included similarly.
  • Importers can request full duty and charge reports from brokers via copies of filed CF 7501s, daily/periodic statements, or ACE data extracts.* Brokers typically advance payments as a pass-through. For large discrepancies, pull random entries in ACE, compare the 7501 (using entry summary date) to the ACE report and broker records, and verify all fees. No relevant practitioner discussions on X were identified in the past 30 days. CBP also posted an updated ACE development/deployment schedule around November 19, 2026, and planned ACE maintenance for November 21-22, 2026.
1 2

Frequently Asked Questions

Can an Importer Obtain a Complete Duty Report From Its Customs Broker?

Yes. A broker can generally provide filed entry summary data, statement information, duty and fee detail, and records of amounts advanced to CBP. The importer should define the requested date range, importer numbers, filer codes, entry types, and charge categories to avoid receiving an incomplete extract.

Should MPF Be Summed From Every Tariff-Line Record?

Not without validation. ACE may itemize or repeat MPF-related information across associated tariff lines. The calculated line data should be reconciled to the entry-level MPF on Form 7501 and the payment statement. Blindly summing line values can overstate the fee, while deleting rows without testing can understate it.

Which Date Should Be Used for Monthly Duty Reporting?

The correct date depends on the reporting objective. Entry date measures import activity, entry summary date measures filing activity, and payment or statement date aligns more closely with cash movement. A financial reconciliation generally uses payment timing, while a compliance analysis may use entry or summary timing.

Why Are Commercial Invoices Insufficient for Duty Reconciliation?

Commercial invoices describe the imported transaction, but they do not capture all CBP assessments and financial events. MPF, HMF, ADD/CVD, Chapter 99 duties, corrections, refunds, and supplemental bills may not be fully represented. The filed Form 7501 and payment records are necessary to establish the customs obligation and cash settlement.

What Is the Best First Step When the Difference Is Very Large?

The importer should test a controlled sample of entries from the affected period. Each entry should be traced from the commercial documentation to Form 7501, ACE data, the CBP statement, broker billing, and the bank record. This usually reveals whether the primary issue is scope, timing, duplication, omitted fees, or missing entries.

How Stable Software Can Help

Strengthening Entry Review and Refund Recovery

Customs brokers and importer compliance teams that need a more disciplined approach to filed customs data can explore Stable Software’s entry audit platform. Structured entry review can help organizations focus their investigation on classification, valuation, fee, and reporting differences instead of relying on aggregate monthly comparisons.

When reconciliation also identifies duties that may qualify for drawback, Stable Software makes DrawbackAI for U.S. customs brokers. Brokers can white-label the software for importer clients and file claims under their own filer codes. DrawbackAI is offered through a flat software license, and Stable Software never takes a percentage of the refund. Brokers can evaluate where entry auditing and duty recovery fit within a broader client service strategy.

Resources

TypeResource
SourcePrimary source

✉️

Sign up for our newsletter

A monthly post on trade, tariffs, and customs, delivered straight to your inbox.