Create New Report
To begin creating a report, click on the
Create Report
button.
The
Create Report
pop-up window will appear.
The modal displays the required and optional data.
Download Template
You can download a spreadsheet template to start.
- ClickDownload spreadsheet template to get started.

- The file is downloaded to your local drive. Click on the file to open it. The spreadsheet is opened in Excel.
- Insert your data.
- When you finish inserting all the required data, save the file.
Required and Optional Data
The pop-up displays the required and optional data as described below.
Optional data | Description |
|---|---|
Product Number | Unique product identifier. |
Product Description | Unique product description associated with each product number. |
Product Group | Collection of departments, classes, subclasses, or items that are grouped together for streamlined reporting. |
HS Number | Classification code used by customs authorities to identify products and determine duty rate. |
Origin Country | 2-letter code for the country manufacturing the good. |
Export Country | 2-letter code for the country shipping products; assumed to be the FTA country of origin for the purposes of this report. |
Import Country | 2-letter code for the country receiving products. |
Import Volume | Sales volume; number of goods or units. |
Import Customs Value Per Unit | Value used to calculate customs duties for imported goods. |
Optional data | Description |
|---|---|
Currency | System of money such as USD, EUR, and JPY. |
Import Amount | Calculated by multiplying import volume and import customs value per unit. |
Business Unit | Division or major functional area of the company that represents a specific line of business. |
Select FTA Product Records
You can select a start and end date in which the qualified records in that period will be used in the report.
important
The
Select FTA Product Records
option is only displayed it you are integrated with FTA Management.
Forecast Savings
Select a current or future date to calculate the savings based on that specific date.

Upload Excel File
- From your local drive, you can either drag and drop the file or use theBrowse for Filebutton.

- If you clickedBrowse for file, select your file and clickOpen.
- The upload process starts. You can see its progress on the progress bar. Processing may take a while depending on the file size.

- When upload is completed, clickCreate Report.
You will see a notification when the report is processed.

After creating a new report, the grid will refresh and display an entry with the newly created report.
important
The system also sends an email notifying you that the report is ready.
