CBP Entry Summary (7501)
34 fields. Open one to check or change where its value comes from.
3 fields still need a source
Entry header7
Filer code / entry number*Reviewer enters it: The reviewer enters it at review
Entry type*Look up in a table: Importer Registry, matched on Importer of record
Summary date*Calculate: TODAY()
Surety number*Look up in a table: Importer Registry, matched on Importer of record
Bond type*Look up in a table: Importer Registry, matched on Importer of record
Port code*From documents: Arrival notice › Port of discharge, then 1 more
Entry date*From documents: Arrival notice › Arrival date
Transport11
Importing carrier*From documents: Bill of lading › Vessel and voyage, then 1 more
Mode of transport*Calculate: IF(Bill of lading › Vessel and voyage <> "", "11", "40")
Country of origin*From documents: Packing list › Made in, then 2 more
Import date*From documents: Arrival notice › Arrival date, then 1 more
B/L or AWB number*From documents: Bill of lading › B/L number, then 1 more
Manufacturer ID*Calculate: COUNTRYCODE(Country of origin) & UPPER(LEFT(WORD(Commercial invoice › Manufacturer, 1), 3) & LEFT(WORD(Commercial invoice › Manufacturer, 2), 3)) & LEFT(INDEX(NUMBERS(Commercial invoice › Manufacturer), 1), 4) & UPPER(LEFT(WORD(Commercial invoice › Manufacturer, -1), 3))
Exporting country*From documents: Bill of lading › Port of loading, then 1 more
Export date*From documents: Bill of lading › Shipped on board, then 1 more
Foreign port of lading*Needs a source: Choose where it comes from
U.S. port of unlading*From documents: Arrival notice › Port of discharge, then 1 more
Location of goodsNeeds a source: Choose where it comes from
Parties5
Consignee numberCalculate: IF(Ultimate consignee = Importer of record, Importer number, "")
Importer number*Look up in a table: Importer Registry, matched on Importer of record
Reference numberNeeds a source: Choose where it comes from
Ultimate consignee*From documents: Bill of lading › Notify party, then 1 more
Importer of record*From documents: Bill of lading › Notify party, then 1 more
Line items7
Description of merchandise*From documents: Commercial invoice › Description, then 1 more
HTSUS number*From documents: Commercial invoice › HTS code
Gross weight*From documents: Packing list › Gross weight, then 1 more
Net quantity in HTSUS units*From documents: Packing list › Quantity, then 1 more
Entered value*From documents: Commercial invoice › Amount
HTSUS rate*Look up in a table: HTS Reference, matched on HTSUS number
Duty*Calculate: ROUND(Line items › Entered value * Line items › HTSUS rate, 2)
Totals4
Total entered value*Calculate: SUM(Line items › Entered value)
Duty*Calculate: SUM(Line items › Duty)
Other fees*Calculate: ROUND(MIN(MAX(Total entered value * 0.3464%, 32.71), 634.62) + Total entered value * 0.125%, 2)
Total*Calculate: Duty + Other fees