UTILIZING ACE REPORTS JULY 19, 2017 Presented by: Beth Pride, - - PowerPoint PPT Presentation

▶
utilizing ace reports
SMART_READER_LITE
LIVE PREVIEW

UTILIZING ACE REPORTS JULY 19, 2017 Presented by: Beth Pride, - - PowerPoint PPT Presentation

Nov 27, 2022 277 likes •797 views

UNDERSTANDING & UTILIZING ACE REPORTS JULY 19, 2017 Presented by: Beth Pride, President, BPE Global Julie Gibbs, Director, BPE Global Presented for NCBFAA Educational Institute Innovative | Efficient | Effective Todays Speakers Julie

slide-1
SLIDE 1

Innovative | Efficient | Effective

UNDERSTANDING & UTILIZING ACE REPORTS

JULY 19, 2017

Presented by: Beth Pride, President, BPE Global Julie Gibbs, Director, BPE Global Presented for NCBFAA Educational Institute

slide-2
SLIDE 2

Innovative | Efficient | Effective

2

Today’s Speakers

Julie Gibbs, Director BPE Global Beth Pride, President BPE Global

slide-3
SLIDE 3

Innovative | Efficient | Effective

Agenda

  • ACE reporting and system configuration
  • Types of ACE reports
  • Running and modifying ACE reports
  • Scheduling regular reports
  • Analyzing ACE reports to quickly identify errors
  • Protest data
  • Using ACE data for business decisions
  • Questions and answers

3

slide-4
SLIDE 4

Innovative | Efficient | Effective

ACE Reports

  • The Automated Commercial Environment (ACE) is the

primary system through which the trade community reports imports and exports and the government determines admissibility.

  • ACE Reports can provide Brokers, Carriers, Exporters

and Importers with invaluable information. Running regular ACE reports will allow you to:

  • Identify compliance issues
  • Calculate metrics and statistics per port, per EIN, IOR, etc.
  • Identify business trends
  • Manage recordkeeping

4

slide-5
SLIDE 5

Innovative | Efficient | Effective

ACE Secure Data Portal

  • Applying for an ACE Portal Account

1.

Identify sub-account type (Importer, Protest Filer, Exporter…)

2.

Designate account owner

3.

Apply for correct access:

  • Protest filer
  • Exporter
  • All others

5

slide-6
SLIDE 6

Innovative | Efficient | Effective

Overview of ACE Export Reports

  • What’s the process to access reports?
  • Company vetted by Census
  • Request EIN Reports Authorization
  • Certification of Authority (COA) – exportreports@census.gov
  • Additional Verification
  • Who can access ACE Export Reports?
  • Filers
  • Authorized Agents and Freight Forwarders
  • USPPIs
  • 6
slide-7
SLIDE 7

Innovative | Efficient | Effective

ACE Basics

  • Proper System Configuration
  • Internet Explorer
  • Java Runtime (JRE)
  • ACE Portal Account Types
  • Top Account
  • Sub-Account
  • ACE Portal User Types
  • Account Owner
  • Proxy Account Owner
  • Account User

7

slide-8
SLIDE 8

Innovative | Efficient | Effective

ACE Report Resources

  • CBP.gov has significant resources regarding reports
  • User Guide
  • Data Dictionary
  • Video Walkthroughs

8

slide-9
SLIDE 9

Innovative | Efficient | Effective

Types of ACE Reports

  • Import
  • Transactional reports
  • Cargo Release / Exam reports
  • Entry Summary reports
  • Liquidation reports
  • Periodic Monthly Statement reports
  • CBP Requests (CF28, CF29, CF4647)
  • CBP Curtesy Notices of Action
  • CBP Reject Report
  • Export
  • EEI declaration reports
  • USPPI vs Filer reports
  • Protest activity

9

slide-10
SLIDE 10

Innovative | Efficient | Effective

Recommended Reports

  • Importer reports
  • ESM-7001 Entry Summary Census Warning and Override
  • ESM-7008 Entry Summary Line Detail Report
  • AM-100 Courtesy Notice of Liquidation
  • Exporter Reports
  • AES-202 USPPI Transactions
  • AES-201 Filer Transactions
  • Broker Reports
  • ESM-7025 CBP Form 28, 29, 2647 Status Report
  • ESM-7024 ACE Reject Report
slide-11
SLIDE 11

Innovative | Efficient | Effective

ACE Portal Walkthrough

  • Home tab

11

slide-12
SLIDE 12

Innovative | Efficient | Effective

ACE Portal Walkthrough

  • Accounts tab

12

slide-13
SLIDE 13

Innovative | Efficient | Effective

ACE Portal Walkthrough

  • References Tab

13

slide-14
SLIDE 14

Innovative | Efficient | Effective

ACE Portal Walkthrough

  • Tools tab

14

slide-15
SLIDE 15

Innovative | Efficient | Effective

CBP Forms and Alerts

  • Receive new Alerts

15

slide-16
SLIDE 16

Innovative | Efficient | Effective

Respond to CBP Form Request

  • Access past Alerts or Forms

16

slide-17
SLIDE 17

Innovative | Efficient | Effective

ACE Portal Reports – Set Up

  • Confirm Browser settings are accurate
  • Ensure view is set to “Importer”

17

slide-18
SLIDE 18

Innovative | Efficient | Effective

Report Tool

  • Click on the Reports task
  • Click on Launch Tool

18

slide-19
SLIDE 19

Innovative | Efficient | Effective

Run Reports

  • Click on Importer link

19

slide-20
SLIDE 20

Innovative | Efficient | Effective

ACE Reports – Run

  • Click on the Entry Summary Tab
  • Locate desired report and enter date parameters

20 1 2 3

slide-21
SLIDE 21

Innovative | Efficient | Effective

Modifying ACE Reports

  • Multi step process:
  • 1. Run the initial report
  • 2. Modify the data in the Query
  • a. Click on the “Design” button
  • b. Click on the “Data Access” tab
  • c. Click on the “Edit” button
  • d. Pull in the data elements desired
  • 3. Run the Query again
  • 4. Modify the report by dragging your data into the actual ACE report
  • 5. Save the modified report

21

slide-22
SLIDE 22

Innovative | Efficient | Effective

Modify the Data in Query

  • The default reports do not contain all data elements
  • available. Run the default report first.
  • To add / remove data elements from the report, select

Design.

  • Select the Data Access Tab
  • Select Edit under the Data Providers sub tab

22 1 2 3

slide-23
SLIDE 23

Innovative | Efficient | Effective

Select Data & Run Query

23

1. Select “Run Query.”

  • Drag and drop new data elements from the Universe to

the Results Object box.

  • Reorder and remove data elements as needed.
slide-24
SLIDE 24

Innovative | Efficient | Effective

Drag Your Data into the Report

24

  • Drag and drop new data elements. Be careful you insert

between two columns and don’t accidently ‘replace’ a column.

slide-25
SLIDE 25

Innovative | Efficient | Effective

Save Your Modified Report

25

  • You’ll want to download and save your report.
  • Save to your Favorites
slide-26
SLIDE 26

Innovative | Efficient | Effective

Example

  • Modify AES-202 USPPI report
  • Add Fields:
  • Late File Indicator
  • Related Company Indicator
  • Export Control Classification Number (ECCN)
  • License Type Code (e.g. C33, C50)
  • Origin of goods D/F Indicator

26

slide-27
SLIDE 27

Innovative | Efficient | Effective

Example

  • Run and modify ESM-7008 report
  • Add Fields:
  • HMF
  • MPF
  • User Fees
  • ADD/CVD
  • FCC Information
  • Census Warnings

27

slide-28
SLIDE 28

Innovative | Efficient | Effective

Example, cont

  • ESM-7025 CBP Form 28, 29, 4647
  • ACE entries are in the default report
  • Need to modify to include ACS filed entries
  • Remove the ‘ACE’ Entry Summary Source Code filter
  • Run and edit the report
  • Need to enter due date range and notice date range

28

slide-29
SLIDE 29

Innovative | Efficient | Effective

Example, cont

  • Delete “ACE” in the Query Filter by clicking on the X

29

slide-30
SLIDE 30

Innovative | Efficient | Effective

Save to Favorites

  • Click on the ‘diskette’ icon to Save As
  • Click on the Favorites Folder Bar (Public is Default)
  • Edit File name if necessary

30 1 2 3

slide-31
SLIDE 31

Innovative | Efficient | Effective

Schedule Reports

  • Define favorite report types and schedule to run

automatically

  • Schedule by right clicking on report and complete

parameters with desired frequency.

31

slide-32
SLIDE 32

Innovative | Efficient | Effective

Schedule for Distribution

  • Highlight the report in My Favorites
  • Select “More Actions”
  • Select “Schedule”

32

slide-33
SLIDE 33

Innovative | Efficient | Effective

Schedule

33

  • Select “Reoccurrence”
  • Select the timeframe
slide-34
SLIDE 34

Innovative | Efficient | Effective

Schedule

  • Select the Format for the report.

34

slide-35
SLIDE 35

Innovative | Efficient | Effective

Schedule

  • Select “Destination” to create the distribution list
  • Select “Email” from the dropdown
  • Enter in the From, To, CC, Subject and Message.
  • Click on “Schedule” button

35

slide-36
SLIDE 36

Innovative | Efficient | Effective

Import – Identifying errors

  • Classification – look for strange HTS numbers
  • 9801/9802 – look for unauthorized usage
  • Valuation
  • Divide total entered value by quantity
  • Unreasonably high/low values
  • Country of Origin and Export – look for strange

countries

  • MID – look for unknown shippers
  • SPI Codes – look for unauthorized usage
slide-37
SLIDE 37

Innovative | Efficient | Effective

Export – Identifying errors

  • Classification –unusual ECCNs
  • Missing or incorrect license exceptions/

authorizations

  • Late filings
  • Incorrect mode of transportation compared to

Port of Export

  • Activity to restricted and embargoed countries
  • Licensed transactions- license value, number,

parties

  • Incorrect Related/unrelated parties
  • Domestic vs. Foreign
slide-38
SLIDE 38

Innovative | Efficient | Effective

EXAMPLES

How to identify errors

slide-39
SLIDE 39

Innovative | Efficient | Effective

Import AM-008

  • What is suspicious about this data?
slide-40
SLIDE 40

Innovative | Efficient | Effective

Import ESM-7008

  • What is suspicious about this data?
slide-41
SLIDE 41

Innovative | Efficient | Effective

Export AES-202

  • What is suspicious about this data?

41

slide-42
SLIDE 42

Innovative | Efficient | Effective

Export AES-202

  • What is suspicious about this data?
slide-43
SLIDE 43

Innovative | Efficient | Effective

Protests

  • Historical protest

data has been migrated to ACE

43

Protest Status Count of Protest Number APPROVED CLASSIFICATION 126 LIQUIDATION/RELIQUIDATION 2 OTHER 398 VALUATION 293 (blank) 9222 APPROVED Total 10041 DENIED AD/CVD 51 CLASSIFICATION 99 OTHER 17 (blank) 37440 DENIED Total 37607 DENIED IN PART CLASSIFICATION 6 OTHER 1 (blank) 10166 DENIED IN PART Total 10173 OPEN AD/CVD 1 CLASSIFICATION 123 LIQUIDATION/RELIQUIDATION 10 OTHER 261 (blank) 97 OPEN Total 492

slide-44
SLIDE 44

Innovative | Efficient | Effective

Metrics

  • Your metrics will:
  • Show your department’s value
  • Communicate on your behalf
  • Provide you with a fact-based compass
  • Connect you to your stakeholders

44

slide-45
SLIDE 45

Innovative | Efficient | Effective

Metrics - What To Measure

  • Import/export

filings/year

  • Returns
  • Personal

shipments

  • Requests for

information

  • OGAs
  • Screenings
  • Licenses
  • Classifications
  • Assists
  • Deemed exports
slide-46
SLIDE 46

Innovative | Efficient | Effective

Make Your Own Infographic

46

slide-47
SLIDE 47

Innovative | Efficient | Effective

Record Retention

  • Run ACE export and import reports monthly
  • Reconcile every record against ACE report
  • Actively solicit missing records
  • Conduct random review of ACE data for anomalies

47

slide-48
SLIDE 48

Innovative | Efficient | Effective

Executive Communications

slide-49
SLIDE 49

Innovative | Efficient | Effective

C-TPAT

  • ACE data is an excellent starting point for C-TPAT risk

analysis

  • Mapping cargo/data flow and control and identifying business

partners

  • Threat assessment – origin analysis
  • Vulnerability assessment
  • Risk-based by value/volume

49

slide-50
SLIDE 50

Innovative | Efficient | Effective

Key Takeaways

  • ACE is free!
  • Data is available
  • Reports will be changing with the next release of ACE
  • Value of the data is what you make of it
slide-51
SLIDE 51

Innovative | Efficient | Effective

QUESTIONS & COMMENTS?

Beth Pride, President Julie Gibbs, Director BPE Global BPE Global Beth@bpeglobal.com Julie@bpeglobal.com 415-845-8967 415-595-8543