US flag Official website of the Department of Homeland Security

ACE Reports Information Notice

U.S. Customs and Border Protection (CBP) has enhanced ACE Reports to support the transition of Automated Commercial System (ACS) core trade processing capabilities to the Automated Commercial Environment (ACE). As detailed in this Information Notice, the reports capabilities will follow each of the releases for Deployment G to include:

Deployment G, Release 4

A new Reconciliation universe, Liquidation universe, and a Harmonized Tariff Schedule (HTS) universe are scheduled for deployment on March 17, 2018. This deployment will be approximately three weeks after the February 24, 2018 delivery of reconciliation, liquidation, and drawback (core and TFTEA) functionality with Deployment G, Release 4. Please see the table below for a list of the new standard reports available in ACE Reports on March 17, 2018.

The Reconciliation Statement Deployment plan can be found in the Reconciliation Information Notice.

Reconciliation and Liquidation Standard Reports

Number

Name

Description

Objects

ES-503

Reconciliation Entry Summaries

This report provides standard information regarding standard header level reconciliation entry summaries.

Reconciliation Entry Summary Number, Number of Associated Entry Summaries, Reconciliation Accounting Method, Reconciliation Issue Type, Reconciliation ES Control Team Number, Reconciliation ES Importer Name, Reconciliation ES Importer Number, Reconciliation ES Create Date, Reconciliation ES Late Filing Status Code, Reconciliation ES Late Filing Status, Reconciliation ES Liquidation Date, Protest/Petition Filed Indicator, Reconciliation ES Port of Entry Code, Reconciliation ES Entry Date, Reconciliation Issue Type Code

ES-504

Associated Entry Summaries

This report provides standard header level information for all associated type 01, 02, 06 entry summaries that have been reconciled through a reconciliation entry summary (type 09).

Reconciliation Entry Summary Number, Flagged/Associated ES Entry Summary Number, Flagged/Associated ES Entry Summary Date, Flagged/Associated ES Importation Date, Flagged/Associated ES Entry Type Code, Flagged/Associated Entry Filing Port, Associated ES Affected Line Quantity, Associated ES Total Line Quantity, Manual Review Status, Flagged/Associated Entry Line Indicator, Flagged/Associated Entry Duty, Flagged/Associated Entry MPF, Flagged/Associated Entry HMF, Flagged/Associated Entry Other Fees, Flagged/Associated Entry Total Taxes, Flagged/Associated Grand Total, Flagged/Associated Entry Interest

ES-505

Reconciliation Entry Summary Amounts

This report provides the various amounts, broken down by each class code on a reconciliation entry summary.

Reconciliation Entry Summary Number, Prior Disclosure Indicator, CBP Amount Override Indicator, Reconciliation ES Collection Status, Reconciliation ES Original Duty Amount, Reconciliation ES Original Fee Amount, Reconciliation ES Original HMF Amount, Reconciliation ES Original MPF Amount, Reconciliation ES Original Tax Amount, Reconciliation ES Original Interest Amount, Reconciliation ES Original Grand Total Amount, Reconciliation ES Reconciled Duty Amount, Reconciliation ES Reconciled Fee Amount, Reconciliation ES Reconciled HMF Amount, Reconciliation ES Reconciled MPF Amount, Reconciliation ES Reconciled Tax Amount, Reconciliation ES Reconciled Interest Amount, Reconciliation ES Reconciled Grand Total Amount, Reconciliation ES Change Recon Duty Amount, Reconciliation ES Change Recon Fee Amount, Reconciliation ES Change Recon HMF Amount, Reconciliation ES Change Recon MPF Amount, Reconciliation ES Change Recon Tax Amount, Reconciliation ES Change Recon Interest Amount, Reconciliation ES Change Recon Grand Total Amount, Reconciliation ES Paid Change Recon Duty Amount, Reconciliation ES Paid Change Recon Fee Amount, Reconciliation ES Paid Change Recon HMF Amount, Reconciliation ES Paid Change Recon MPF Amount, Reconciliation ES Paid Change Recon Tax Amount, Reconciliation ES Paid Change Recon Interest Amount, Reconciliation ES Paid Change Recon Grand Total Amount

ES-506

Reconciliation Line Item Transmitted Data

This report provides transmitted line level information regarding type 09 reconciliation entry summaries.

Reconciliation Entry Summary Number, Identifying Line (Original/Reconciled) Ordinal Number, Original/Reconciled Line Indicator, Identifying Line (Original/Reconciled) HTS Numbers, Identifying Line (Original/Reconciled) COO Name, Identifying Line (Original/Reconciled) SPI Code, Identifying Line (Original/Reconciled) Value, Identifying Line (Original/Reconciled) Duty, Identifying Line (Original/Reconciled) MPF, Identifying Line (Original/Reconciled) HMF, Identifying Line (Original/Reconciled) Grand Total Amount

ES-507

Reconciliation Line Item HTS Details

This report provides transmitted line level HTS information regarding reconciliation entry summaries.

Reconciliation Entry Summary Number, Identifying Line (Original/Reconciled) Ordinal Number, Original/Reconciled Line Tariff Indicator, Identifying Line Tariff (Original/Reconciled) HTS Number, Identifying Line Tariff (Original/Reconciled) Value Amount, Identifying Line Tariff (Original/Reconciled) Duty Amount

ES-701

Courtesy Notice of Liquidation

This report provides a list entry summaries that have liquidated.

Entry Summary Number, Entry Date, Entry Type Code, Entry Type Long Description, Filer Code, Filer Name, Importer Number, Importer Name, Liquidation Date, Liquidation Record Status Code, Liquidation Duty Determination Code, Courtesy Notice Processed Date, Port of Entry Code, Control Team CEE, Team Number, Total Estimated Amount, Total Paid Amount, Total Ascertained Amount, Total Bill Amount, Total Refund Amount, Total Interest Amount, Additional Surety Notice Date, Surety Code, Surety Name

ES-702

Official Notice of Extension, Suspension and Liquidation

This report provides a list of entry summaries that have been extended, suspended or scheduled for liquidation.

Posted Date, Liquidation Date, Voided Date, Event Type, Basis, Action, Entry Number, Port of Entry, Entry Date, Entry Type, Team

 

Locations of Reconciliation and Liquidation Reports  

 

Universe

Workspace

Sub-Tab

Report Name

Reconciliation

Entry Summary

Reconciliation

ES-503 Reconciliation Entry Summaries

Reconciliation

Entry Summary

Reconciliation

ES-504 Associated Entry Summaries

Reconciliation

Entry Summary

Reconciliation

ES-505 Reconciliation Entry Summary Amounts

Reconciliation

Entry Summary

Reconciliation

ES-506 Reconciliation Line Item Transmitted Data

Reconciliation

Entry Summary

Reconciliation

ES-507 Reconciliation Line Item HTS Details

Liquidation

Entry Summary

Liquidation

ES-701 Courtesy Notice of Liquidation

Liquidation Bulletin

Entry Summary

Liquidation

ES-702 Official Notice of Extension, Suspension, and Liquidation

Authorized Data Extracts and Legacy Data Universes

The Authorized Data Extracts Reports will be retired on April 14, 2018, at which point all reports capabilities will reside in ACE Reports.

More information about ACE Reports can be found by visiting the ACE Training and Reference Guides. The ACE Reports Data Dictionary will also be updated with information concerning the new ACE data universes and reports. For more questions on ACE Reports, please contact the ACE Account Service Desk at 1-866-530-4172 or ACE.Support@cbp.dhs.gov.

Additional ACE Reports Capabilities Available as of January 13, 2018

CBP has deployed ACE Statement reports with the Statements universe, which replaces the Accounts Revenue universe. The new ACE Statements reports are available under the Statements tab found in the applicable trade account workspace. In addition, two existing “quickview” reports for brokers and importers (AR-007) will remain available in ACE.

CBP has also deployed a new AD/CVD universe that is available in parallel with the current AD/CVD universe. The trade community has the opportunity to gain an understanding of the new universe and to become comfortable using these enhancements. The new universe enhancements involve technical upgrades, and the addition of a number of renamed data objects. For your reference, please see the ACE Reports AD/CVD Universe Object Mapping table at the bottom of this notice which identifies the renamed data objects in the new AD/CVD universe in comparison to the current AD/CVD universe.

This new universe is available to brokers and importers. Users should select either the Broker or Importer workspace in ACE Reports, navigate to Entry Summary, and click on the tab labeled “AD/CVD NEW.” This tab will be renamed “AD/CVD,” and will replace the current tab labeled “AD/CVD.”

If you have created and saved any ad-hoc reports for the current universe, please recreate them for use in this new universe.

Deployment G, Release 3A & 3B

Deployment G, Release 3B (January 6, 2018)

As of January 6, 2018, CBP delivered ACE Deployment G, Release 3B. As a result of this deployment, ACE is now the system of record for all statements with the exception of Reconciliation statements.

CBP will deliver Statements for Reconciliations as part of ACE Deployment G, Release 4 on February 24, 2018.  The Reconciliation Statements Deployment plan may be found in the Reconciliations Information Notice.

Additional ACE Reports Capabilities Available as of December 16, 2017
An ad-hoc universe for the new MID application to query manufacturers and other information captured in the new ACE MID application is now available.

Deployment G, Release 3A (December 9, 2017)

The new ACE Statement Reports REV-101, REV-102, REV-103, and REV-104 were made available in ACE on December 9, 2017.

Locations of Statement Reports

Universe

Workspace

Sub-tab

Report Name

Statements

Broker/Importer

Statements

REV-101 Monthly Statement Overview

Statements

Broker/Importer

Statements

REV-102 Daily Statement Overview

Statements

Broker/Importer

Statements

REV-103 Daily Statement Entry Summaries

Statements

Broker/Importer

Statements

REV-104 Daily Statement Entry Summary Amounts

Statements

Broker/Importer

Statements

REV-105 Regular Daily Statement Entry Summaries

Statements

Broker/Importer

Statements

AR-007 Periodic Statement Quickview – Brk/Imp

Legacy ACE Report Replacements in ACE Reports - The table below displays a list of current legacy reports and their replacement ACE reports.

Legacy Report

Replacement ACE Report

AM-001 Entry Summary Lines by HTS Number Report

ES-003 Entry Summary Line Tariff Details

AM-003 Entry Summary Lines by Filer Code Report

ES-003 Entry Summary Line Tariff Details

AM-007 Entry Summary Lines by Mfr Code Report

ES-003 Entry Summary Line Tariff Details

AM-008 Entry Summary Line Detail Report

ES-003 Entry Summary Line Tariff Details

AM-009 Summary of Mfr Code by Value Report

ES-006 Entry Summary Dimensions by Value

AM-010 Summary of HTS Nbrs by Value Report

ES-006 Entry Summary Dimensions by Value

AM-015 Summary of IR Nbrs by Value Report

ES-006 Entry Summary Dimensions by Value

AM-019 Summary of Filer Codes by Value Report

ES-006 Entry Summary Dimensions by Value

AM-064 Entry Summary Line by Entry Nbr Report

ES-002 Entry Summary Line Details

AM-068 Entry Summary Report

ES-001 Entry Summary Header Details

AM-100 Courtesy Notice of Liquidation

ES-701 Courtesy Notice of Liquidation

ESM-7001 Entry Summary Census Warning Report

Ad-Hoc Report Functionality Using ES Universe

ESM-7008 Entry Summary Line Detail Report

ES-003 Entry Summary Line Tariff Details

ESM-7024 ACE Reject Report

ES-004 Rejected and Cancelled Entry Summaries

ESM-7025 CBP Form 28, 29, 4647 Status Report

TBD

ESM-7068 Entry Summary Report

ES-001 Entry Summary Header Details

Deployment G, Release 2

On September 16, 2017, CBP successfully deployed Deployment G, Release 2, followed by corresponding ACE Reports capabilities on October 7th.

A new Entry Summary (ES) universe and several new ACE standard reports were deployed to consolidate data found in the legacy Account Management and ESM-10002 Entry Summary universes. The new universe which consists of a set of standard reports will now provide users the ability to query a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

While the new Entry Summary universe that was released on October 7th, ultimately replaced the existing universes containing entry summary data, certain functionality will be unavailable until the final release of Deployment G on February 24, 2018.

Please review the table below for a list of the new Entry Summary (ES) universe standardized reports available in ACE Reports as of October 7, 2017.

Entry Summary Standard Reports

Number

Name

Description

Default Data Objects

ES-001

Entry Summary Header Details

This report provides standard information captured at the entry summary header level. It is meant to serve as a replacement for the legacy AM-068 and ESM-7068 reports, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Port of Entry Code, Port of Entry Name, Entry Date, Entry Summary Date, Entry Summary Create Date, Surety Code, Importer Number, Importer Name, Control Team Number, Control Team CEE, Bond Type Code, Bond Number, Liquidation Status, Mode of Transportation Code, Mode of Transportation, Total Goods Value Amount, Number of Entry Summary Lines

ES-002

Entry Summary Line Details

This report provides standard information captured at the entry summary line level. It is meant to serve as a replacement for the legacy AM-064 report, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Entry Summary Line Number, Review Team Number, Country of Origin Code, Country of Export Code, Manufacturer ID, Manufacturer Name, Foreign Exporter ID, Foreign Exporter Name, Line SPI Code, Line SPI, Reconciliation (FTA) Status, Reconciliation (Other) Status, Line Goods Value Amount, Line Duty Amount, Line MPF Amount

ES-003

Entry Summary Line Tariff Details

This report provides standard information captured at the entry summary line tariff level. It is meant to serve as a replacement for the legacy AM-001, AM-003, AM-007, AM-008, and ESM-7068 reports, as well as to provide additional enhancements allowing users to report on a more robust set of data elements that have been normalized for both ACS and ACE sourced entry summaries.

Entry Summary Number, Entry Type Code, Importer Number, Port of Entry Code, Entry Date, Entry Summary Date, Entry Summary Create Date, Entry Summary Line Number, Review Team Number, Country of Origin Code, Country of Export Code, Manufacturer ID, Foreign Exporter ID, Line SPI Code, Standard Visa Number, Textile Category Code, Textile Category, Tariff Ordinal Number, HTS Number - Full, Line Tariff Quantity (1), Line Tariff UOM (1) Code, Line Tariff Quantity (2), Line Tariff UOM (2) Code, Line Tariff Quantity (3), Line Tariff UOM (3) Code, Line Tariff Duty Amount, Line Tariff Goods Value Amount

ES-004

Rejected and Canceled Entry Summaries

This report provides a list of all canceled and rejected entry summaries based on the parameters input by the user running the report. It is intended to replace the legacy ESM-7024 report.

Entry Summary Number, Entry Type Code, Port of Entry Code, Control Team Number, Control Team CEE, Importer Number, Importer Name, Control Status, Entry Summary Cancellation Date, Entry Summary Rejection Date, Entry Summary Status

ES-005

Late Filed Entry Summaries

This report provides a list of all late filed entry summaries based on the parameters input by the user running the report. This report does not provide a list of entries filed in ACE Cargo Release that have been released and are still pending a follow-up 7501 entry summary filing, but rather the entry summaries that were eventually filed but designated as late.

Entry Summary Number, Entry Type Code, Port of Entry Code, Control Team Number, Release Date, Entry Summary Date, Control Team CEE, Importer Number, Importer Name, Control Status, Late Filing Status Code, Late Filing Status, Entry Summary Status

ES-006

Entry Summary Dimensions by Value

This report provides an aggregate summary of the number of entry summaries, number of entry summary lines, total value, and total duty broken out by manufacturer, importer, filer, and HTS Number. These breakouts are on 4 separate tabs in the same report: Summary by Manufacturer, Summary by Importer, Summary by Filer, and Summary by HTS Number. It is intended to replace the legacy AM-009, AM-010, AM-015, and AM-019 reports.

Summary by Manufacturer: Manufacturer ID, Manufacturer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by Importer: Importer Number, Importer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by Filer: Filer Code, Filer Name, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount

Summary by HTS Number: HTS Number - Full, HTS Short Description, Number of Entry Summary Lines, Number of Entry Summaries, Line Tariff Duty Amount, Line Tariff Goods Value Amount,

 


ACE Reports AD/CVD Universe Object Mapping

CURRENT ADCVD OBJECTS

NEW ADCVD OBJECTS

Object

Object

Total ADD Amount

Antidumping Goods Value Amount

Total CVD Amount

Countervailing Goods Value Amount

Total Line Value

Line Goods Value Amount

Calendar Entry Year Month

Entry Date - Year Month (Calendar)

Consignee Name

Ultimate Consignee Name

Consignee Number

Ultimate Consignee Number

DOC File Location ID

Document File Location ID

Entry Multiple Case Indicator

Multiple Case Indicator

Entry Multiple Case (Different Lines) Indicator

Multiple Case (Different Lines) Indicator

Entry Number

Entry Summary Number

Entry Version Create Date

Entry Summary Create Date

Fiscal Entry Year

Entry Date - Year (Fiscal)

Liquidation Date

Liquidation/Closure Date

Version Number

Entry Summary Version Number

BRASS Filer Code

Filer BRASS Account ID

Broker Alias Name

Filer Alias Name

Broker DBA Name

Filer DBA Name

Broker Division Name

Filer Division Name

Broker DUNS Number

Filer DUNS ID Number

Broker Organizational Structure

Filer Organizational Structure

Broker Organizational Structure Code

Filer Organizational Structure Code

Broker Taxpayer ID Number

Filer Tax ID Number

Broker Taxpayer ID Code

Filer Taxpayer ID Code

License Issue Date

Filer - License Issue Date

License Number

Filer - License Number

License Status

Filer - License Status

Broker Mailing Address Line 1

Filer Mailing Address Line 1

Broker Mailing Address Line 2

Filer Mailing Address Line 2

Broker Mailing Address Line 3

Filer Mailing Address Line 3

Broker Mailing Building Number

Filer Mailing Building Number

Broker Mailing City

Filer Mailing City

Broker Mailing Country Code

Filer Mailing Country Code

Broker Mailing Floor Number

Filer Mailing Floor Number

Broker Mailing House Number

Filer Mailing House Number

Broker Mailing PO Box Number

Filer Mailing PO Box Number

Broker Mailing State

Filer Mailing State/Province

Broker Mailing State Code

Filer Mailing State/Province Code

Broker Mailing Suite/Apartment Number

Filer Mailing Suite/Apartment Number

Broker Mailing Zip Code

Filer Mailing Zip Code

Broker Physical Address Line 1

Filer Physical Address Line 1

Broker Physical Address Line 2

Filer Physical Address Line 2

Broker Physical Address Line 3

Filer Physical Address Line 3

Broker Physical Building Number

Filer Physical Building Number

Broker Physical City

Filer Physical City

Broker Physical Country Code

Filer Physical Country Code

Broker Physical Floor Number

Filer Physical Floor Number

Broker Physical House Number

Filer Physical House Number

Broker Physical PO Box Number

Filer Physical PO Box Number

Broker Physical State

Filer Physical State/Province

Broker Physical State Code

Filer Physical State Code/Province

Broker Physical Suite/Apartment Number

Filer Physical Suite/Apartment Number

Broker Physical Zip Code

Filer Physical Zip Code

Debit Voucher Indicator

Collection Debit Voucher Indicator

Payment Type (Pay Basis from ACS)

Payment Type

Payment Type Code (Pay Basis from ACS)

Payment Type Code

Periodic Statement Month Number

Periodic Statement Month Number

Statement Client Branch Identifier

Statement Client Branch ID

AD Bond or Cash Claimed

Antidumping Bond/Cash Claimed

AD Bond or Cash Claimed Code

Antidumping Bond/Cash Claimed Code

AD Non-Reimbursement Blanket Statement Number

Antidumping Non-Reimbursement Declaration ID

AD Value

Antidumping Goods Value Amount

CV Bond or Cash Claimed

Countervailing Bond/Cash Claimed

CV Bond or Cash Claimed Code

Countervailing Bond/Cash Claimed Code

CV Non-Reimbursement Blanket Statement Number

Countervailing Non-Reimbursement Declaration ID

CV Value

Countervailing Goods Value Amount

CVD Paid Amount

Total Paid CVD Amount

Entry Line AD Case Number

Antidumping Case Number

Entry Line AD Indicator

Antidumping Indicator

Entry Line ADD Ad-Valorem Rate

Antidumping Ad-Valorem Rate

Entry Line Country of Export Code

Country of Export Code

Entry Line Country of Export Code and Name

Country of Export Code and Name

Entry Line Country of Export Name

Country of Export Name

Entry Line Country of Origin Code

Country of Origin Code

Entry Line Country of Origin Code and Name

Country of Origin Code and Name

Entry Line Country of Origin Name

Country of Origin Name

Export Date

Exportation Date

Line Number

Entry Summary Line Number

Manufacturer Code

Manufacturer ID

SPI

Line SPI

SPI Code

Line SPI Code

UOM

Line Tariff UOM (1)

UOM Code

Line Tariff UOM (1) Code

UOM Quantity

Line Tariff Quantity (1)

FAST ID Number

FAST Account ID Number

Importer Mailing State

Importer Mailing State/Province

Importer Mailing State Code

Importer Mailing State/Province Code

ASI Indicator

Surety ASI Indicator

NAIC Number

Surety Treasury Circular NAIC Number

Reinsurance Amount

Surety Reinsurance Limit Amount

Surety DUNS Number

Surety DUNS ID Number

Surety Name

Surety Name

Surety Taxpayer ID Number

Surety Tax ID Number

Surety Taxpayer ID Type Code

Surety Tax Type Code

Last published: 
March 26, 2018