Please, note that the expected format is a comma-separated file .csv, which can be created from the current Excel sheet. However, in case of multiple sheets, you will have to create a separate .csv file from each sheet.

Column Description Entry Number XXX-NNNNNNN-N Entry Date MM/DD/YYYY Version Integer, representing entry version number 7501 Line ABI Line Sequence number Record Number Invoice Seq Invoice Sequence number Invoice Line Line Sequence number within Invoice Tariff Seq Tariff Sequence number within Line Nafta Recon NAFTA Reconciliation Indicator Nafta Date Date of NAFTA Reconciliation Other Recon Other Reconciliation Issue Indicator Other Recon Date Date of Other Reconciliation Invoice num Invoice Number Invoice Date MM/DD/YYYY Manufacturer ID Manufacturer MID Supplier Supplier MID Destination US State Abbreviation PO num Purchase Order Number Part Product Number Description Product Description Country of Origin ISO Country code Country of Export ISO Country code Quantity Units Invoice Value Currency ISO Currency code Conversion Rate Entered Value USD Additions Positive MMV Amount Deductions NDC Amount HTS Tariff Number, with or without '.', i.e. 8888888888 or 8888.88.8888 SPI 1 Customs SPI like A, B, K, JO CA, MX, ... or empty SPI 2 Customs SPI 2 like F, G, H, M, X, V or empty Census Qty 1 Tariff Quantity 1 Unit 1 Customs HTS units of measure Census Qty 2 Tariff Quantity 2 Unit 2 Customs HTS units of measure Census Qty 3 Tariff Quantity 3 Unit 3 Customs HTS units of measure Specific Rate Specific Duty Rate Ad Valorem Rate Ad Valorem Duty Rate Other Rate Other Duty Rate Duty Code HTS Duty Code Duty Duty Amount Tax Tax Amount MPF MPF Amount HMF HMF Amount Beef Fee Pork Fee Honey Fee Cotton Fee Pecan Fee Other Agency Fee Sugar Fee Potato Fee Lime Fee Mushroom Fee Watermelon Fee Sheep Fee Blueberry Fee Avocado Fee Mango Fee Sorghum Fee Ref Qlf 1 Reference Qualifier Ref 1 Reference Number Ref Qlf 2 Reference Qualifier Ref 2 Reference Number Ref Qlf 3 Reference Qualifier Ref 3 Reference Number Date Qlf 1 Date 1 Date Qlf 2 Date 2 Date Qlf 3 Date 3 Version Reason Reason for the version EI Ref Release Year Entry Type Customs Entry Type Code like 01, 02, 06, ... Entry Port Customs Domestic Port Code like 4601, 1001, ... Summary Date Export Date Import Date Duty Date MPF Date HMF Date Bond Surety Customs Surety Code Entry Source IRS num YYDDPP-NNNNN, NN-NNNNNNNXX, NNN-NN-NNNN or -CCCCCCCCCCC Mode of Trans Customs MOT Code like 10, 11, 40, 41, ... Total Duty Total Tax Total MPF Total HMF Total Other Total Due Import Client Consignee Consignee IRS Number Desc of Goods Description of Goods Batch num Batch Date Batch Time Entry Count Record Count Recon Reason Nafta Ready Other Recon Ready Upd By Last Updated By Upd Date Last Updated On