| Title: | RECONCILIATION SPREADSHEET |
|---|---|
| Date: | 1999-07-09 |
| To: | abi |
| Links: | previous, next |
TO : ALL ABI BROKERS.
FROM : DON LUTHER
SUBJECT : RECONCILIATION SPREADSHEET
DATE : 07/08/1999
RECONCILIATION SPREADSHEET SPECIFICATIONS
UNDER THE ACS RECONCILIATION PROTOTYPE, THE RECONCILIATION (TY
09) ENTRY INCLUDES THREE COMPONENTS. THE HEADER AND ASSOCIATI
FILE, WHICH ARE TRANSMITTED VIA ABI, AND THE SUMMARIZED LINE IT
DATA SPREADSHEET, PROVIDED TO CUSTOMS ON DISKETTES.
THIS MESSAGE IS TO CLARIFY THE PURPOSE AND FORM OF T
SPREADSHEET, AND TO PROVIDE TECHNICAL SPECIFICATIONS A
REQUIREMENTS.
THE SPREADSHEET IS THE PART OF THE RECONCILIATION WHERE IMPORTE
REPORT THE CHANGES TO VALUE AND OTHER RECONCILABLE ASPECTS
THEIR BUSINESS. THESE CHANGES ARE REPORTED AT THE "MACRO" LEVE
THAT IS, WITOUT REFERENCE TO WHICH ENTRIES ARE AFFECTED BY T
CHANGES. FOR EXAMPLE, AN IMPORTER COULD REPORT A VALUE CHAN
FOR ALL IMPORTS OF A GIVEN PRODUCT DURING A TIME PERIOD, ON O
LINE OF THE SPREADSHEET. THE ORIGINAL AND RECONCILED VALUE
DUTIES, AND FEES SHOWN ON THAT LINE WOULD BE TOTALS FOR ALL T
IMPORTS OF THAT PRODUCT.
THE SPREADSHEET IS THE SAME FOR BOTH AGGREGATE AND ENTRY-BY-ENT
RECONCILIATIONS. THE SPREADSHEET DOES NOT CONTAIN ENTRY NUMBER
ENTRY NUMBERS ARE ONLY SHOWN ON THE ASSOCIATION FILE.
TWO SEPARATE COPIES OF THE SPREADSHEET ARE REQUIRED, V
DISKETTES. ONE COPY WILL BE KEPT BY CUSTOMS, ONE FORWARDED
THE BUREAU OF CENSUS, AS THE DATA WILL BE USED TO UPDATE U.
TRADE STATISTICS.
TO ENSURE COMPATIBILITY BETWEEN PRODUCERS AND USERS OF THE DAT
AND TO ENSURE CENSUS' ABILITY TO PROPERLY EXTRACT THE DAT
CUSTOMS IS PRESCRIBING THE FOLLOWING FORMAT THAT MUST BE USED F
ALL RECONCILIATION SPREADSHEETS SUBMITTED WITH RECONCILIATIO
FILED AFTER 7/15/99.
FORMAT: ASCII TEXT, COMMA DELIMITED FIELDS, TEXT DELIMITED BY
QUOTES. THIS FORMAT IS SUPPORTED BY ALL MAJOR
COMMERCIAL SPREADSHEET PROGRAMS, AND BY MOST MINI-
AND MAINFRAME COMPUTER APPLICATIONS AS WELL.
FIELDS: THE FOLLOWING FIELDS SHALL MAKE UP THE SPREADSHEET,
IN THE FORMAT AND ORDER SPECIFIED.
FIELD DEFINITION FORMAT
RECON LINE SEQUENTIAL NUMBER, WITH TEXT, 5 CHAR. MAX
"A" AND "B" FOR LINKED
LINES (9802 & CLASSIF.)
1 CAL. YEAR CALENDAR YEAR OF RELEASE NUMERIC, 4-DIGIT YEA
OF MERCHANDISE
REASON ISSUE BEING RECONCILED TEXT, 12 CHAR. MAX
(FREE TEXT)
PORT PORT CODE WHERE IMPORTS TEXT, 3 CHAR. MAX
CAME IN. (2-DIGIT LEVEL
OR "ALL" IF ALL PORTS.)
THIS FIELD REQUIRED ONLY
FOR LINES INVOLVING 9802
RATIO CHANGES OR CHANGES
IN CLASSIFICATION.
ORIGIN COUNTRY OF ORIGIN OF MDSE TEXT, 2-CHAR. CODE
ORIG. SPI SPECIAL PROGRAM INDICATOR TEXT, 2-CHAR. MAX.
APPLIED TO MERCHANDISE
ON UNDERLYING ENTRIES
(E.G. 'A' FOR GSP, 'MX'
FOR MEXICO-NAFTA, ETC.
REC. SPI RECONCILED SPECIAL PROGRAM TEXT, 2-CHAR. MAX.
INDICATOR. (SHOULD ONLY
BE DIFFERENT FROM ORIG.
SPI IN CASE OF NAFTA
RECONCILIATION.
HTS HARMONIZED TARIFF CLASS'N TEXT, 10-DIGITS, WIT
OF MERCHANDISE. LEADING ZERO FOR HTS
IN CHAPTERS 1-9
ORIG. QTY TOTAL QUANTITY OF MDSE TEXT, 8 CHARACTER MA
FROM ORIG. ENTRY LINES
NO UNITS OF MEASURE,
QUANTITY REQUIRED ONLY
FOR RECONCILIATIONS OF
CLASSIFICATION.
REC. QTY. TOTAL QUANTITY OF MDSE TEXT, 8 CHARACTER MA
RECONCILED ON SPREAD-
SHEET LINE. (ALSO
REQUIRED ONLY FOR CLASS'N
RECONCILIATIONS.
1 ORIG. VALUE TOTAL VALUE OF GOODS FOR NUMERIC, 12-DIGIT,
SPREADSHEET LINE, FROM NO DECIMAL PLACES
ORIGINAL ENTRIES.
RECON. VALUE TOTAL RECONCILED VALUE NUMERIC, 12-DIGIT,
FOR GOODS FOR SPREADSHEET NO DECIMAL PLACES
LINE.
ADD'L VALUE DIFFERENCE BETWEEN NUMERIC, 12-DIGIT,
RECON. VALUE AND ORIG. NO DECIMAL PLACES
VALUE. NEGATIVE VALUE SHOWN
WITH MINUS SIGN
ORIG. DUTY ORIGINAL DUTY RATE TEXT, 8 CHAR. MAX.
DUTY RATE APPLICABLE
TO MDSE ON ORIGINAL
ENTRIES.
REC. DUTY RECONCILED DUTY RATE TEXT, 8 CHAR. MAX.
(SHOULD BE SAME AS DUTY RATE APPLICAB
ORIG. DUTY EXCEPT FOR TO MDSE ON SPREADSHE
LINES BEING RECONCILED
FOR NAFTA ELIGIBILITY.
DUTY CHANGE AMOUNT OF DUTY CHANGE NUMERIC, 14-DIGIT
FOR SPREADSHEET LINE. 2 DECIMAL PLACES
(REC. VALUE X REC.RATE) AMOUNTS DUE IMPORTER
MINUS (ORIG VALUE X (REFUNDS) SHOWN WI
ORIG. RATE). MINUS SIGN.
HMT CHANGE AMOUNT OF HARBOR MAINT. NUMERIC, 14-DIGIT
FEE CHANGE FOR SPREAD- 2 DECIMAL PLACES
SHEET LINE. NEGATIVE AMOUNTS SHO
WITH MINUS SIGN.
MPF CHANGE AMOUNT OF MERCHANDISE NUMERIC, 14-DIGIT
PROCESSING FEE CHANGE 2 DECIMAL PLACES
FOR SPREADSHEET LINE. (NEGATIVES WITH MINU
OTHER ITEMS ARE CONDITIONAL, BASED ON THE PRESENCE OF OTHER TAX
AND FEES. IN EACH CASE, THE FORMAT IS THE SAME AS THE FORMA
FOR HMT AND MPF: THE AMOUNT OF MONEY INVOLVED PER TAX OR FEE,
NUMERIC 14-DIGIT, 2 DECIMAL PLACES, WITH NEGATIVE NUMBE
REPRESENTED WITH "MINUS" SIGN. FIELDS OF THIS TYPE INCLUDE B
ARE NOT LIMITED TO: INTERNAL REVENUE TAX, COTTON FEE, PORK FE
ETC. AS WITH ALL SUCH CHANGES, THEY ARE TO BE APPLI
1 SPECIFICALLY TO HTS NUMBERS VIA INDIVIDUAL SPREADSHEET LINES.
OPTIONAL COMMENT FIELDS MAY BE ADDED AT THE IMPORTER'S DISCRETI
BUT ONLY AT THE FAR RIGHT OF THE SPREADSHEET, AFTER ALL ELEMENT
LISTED ABOVE.
QUESTIONS REGARDING THIS MESSAGE MAY BE DIRECTED TO DON LUTHER,
CUSTOMS HEADQUARTERS RECONCILIATION TEAM, AT (202) 927-0915,
VIAE-MAIL AT DON.P.LUTHER@CUSTOMS.TREAS.GOV.