overview of periodic monthly statements doc.pdfstatement process the periodic monthly statement...

PMS-Periodic Daily Statement Status Report

PMS-1

Copyright © 2005 TradePoint Systems LLC

Overview of Periodic Monthly Statements

Overview In June, 2004, CBP introduced the capability for brokers to pay statements for some importers on a monthly basis. These monthly payments must be made no later than the 15th of each month for entries that are entered or released during the previous month.

Periodic Monthly Statement Process

The periodic monthly statement process includes the following steps:

1. Process entry summaries for Periodic Daily Statement.

2. Receive, process and print the preliminary Periodic Daily Statement.

3. As needed, remove entries before the final Periodic Daily Statement.

4. Authorize the Periodic Daily Statement.

5. Receive the final Periodic Daily Statement.

6. As needed, remove entries before the preliminary Periodic Monthly Statement.

7. Receive, process and print the preliminary Periodic Monthly Statement. Re-queue statement, as needed.

8. As needed, remove entries from the Daily Statement before the final Periodic Monthly Statement.

9. Receive, process and print the final Periodic Monthly Statement.

Periodic Monthly Statement – Terminology

• Daily Statement – The statements that are currently received, payment types 2, 3, and 5.

• Preliminary Periodic Daily Statement – Received daily by the broker, includes entries using payment types 6, 7, or 8 for that particular payment due date. It is received in addition to the regular Daily Statement (for payment types 2, 3, and 5).

• Final Periodic Daily Statement – The final version of the Preliminary Periodic Daily Statement, received after the Preliminary Periodic Daily Statement is authorized.

• Preliminary Periodic Monthly Statement – Received by the broker once per month, on the 11th of the month (at the latest). The transmission file includes a list of Periodic Daily Statements for the previous month, with their duty & fee amounts and totals, and the Periodic Monthly Statement, with its duty & fee amounts and totals.

• Final Periodic Daily Statement – Received by the broker once per month, the day after CBP processes the ACH debit for the Periodic Monthly Statement. They process the ACH debit on the 15th of the month, or earlier if the 15th is a weekend or a holiday.

• NOTE on the format of the periodic monthly statement: The format will be DDCYPMMXXX, where

� DD = District � CY = Calendar Year � P = Periodic


PMS-2


� MM = Month of Statement � XXX = Sequence number (alphanumeric)

• Periodic Monthly Statements payment types: 6, 7, & 8.

� 6 = indicates periodic monthly statement payments are batched by broker/filer code. (Comparable to the daily statement payment type 2).

� 7 = indicates periodic monthly statement payments are batched by importer of record’s IRS number. (Comparable to the daily statement payment type 3).

� 8 = indicates periodic monthly statement payments are batched by a combined importer of record’s IRS number (e.g., multiple importers with the same first ten digits are combined; the last two digit suffix is ignored). (Comparable to the daily statement payment type 5).

Alliance System Modifications

• Company Control File Maintenance – Three new fields have been added to the Auxiliary Parameters 3 screen: PMS Final Work Days, PMS Statement Delete Password, and Resend PMS Census Reject.

• Customer Maintenance –Two new fields have been added to the Import Information screen: Prelim Monthly Date and Switch Pay Type.

• Control ID records: The following new control ID’s have been added to the ABI Control ID file:

Input

� MO – Request to reroute the periodic monthly statement.

� PN – Periodic Daily Statement ACH Debit Authorization/Entry Summary Presentation.

Output

� MQ – Periodic monthly statement.

� MS – Periodic monthly statement.

� PZ – Periodic Daily Statement ACH Debit Authorization/Entry Summary.

• A/P File – New element added:

o Periodic Daily Statement No has been added to the A/P file. This number will always remain the Periodic Daily Statement number even after the Monthly Statement number has been returned by CBP and updated as the Statement No in A/P file. All A/P reports will now print the periodic monthly statement number once the preliminary periodic monthly statement has been received from ABI. The periodic daily statement number will not print.

• A/P Inquiry by Statement – Usage change:

o The Statement Number changes once the Monthly Statement has been received. The number is the Daily Statement number until the monthly statement is received. At that time it changes to the Monthly Statement number. When doing an A/P Inquiry by Statement (Option 8), you must enter the monthly statement number once the preliminary periodic monthly statement has been received.


PMS-3


• Shipment Header – New elements added:

o Periodic Daily Statement No has been added to the Shipment Header Auxiliary file. This number will always remain the Periodic Daily Statement number even after the Monthly Statement number has been returned by CBP and updated as the Statement No in of Shipment Header.

• Tracing Date – New date added:

o Tracing Date #99312, Projected Preliminary Periodic Monthly Statement Date, has been added.

• Tracing Reports – All Tracing reports that print the statement number will now print the periodic monthly statement number once it has been received from ABI, rather than the periodic daily statement number.

• E/S Queue Update screen – New elements added:

o Statement Branch Designation has been moved from the ABI Options screen to the E/S Queue Update screen.

• 7501 form printing – A new literal will now print in Box 2 of the 7501 for payment types 6, 7, and 8. Instead of printing ABI/A, the following literal will now print: ABI/P.

• Validations – A new validation has been added.

Included in the PMS section

• Periodic Monthly Statements Step by Step Processing Procedures

• PMS Set Up

o Company Control File Maintenance

o Customer Maintenance

o Entry Type Maintenance

• PMS in Shipment Processing

• PMS in Shipment Tracing

• PMS Validations

• PMS in Accounts Payable

o Check Scheduling by Vendor/Date

o A/P Inquiry by Statement Number

• PMS Inquiries and Reports

o ABI Statement Inquiry

o Statement Delete/Update

o ACH Payment Authorization Selection by Date

o Periodic Daily Statement Status Report

o Reroute Request Statement Query

o Reroute PMS Report


PMS-4


Step-by-Step Periodic Monthly Statement Process

Procedure The following table describes the periodic monthly statement process.

Step Action Comment

1 Process entry summaries for Periodic Daily Statement.

• The new payment types (6, 7, & 8) indicate that an entry should be placed on a Periodic Monthly Statement.

• You may set the new payment types as default values in Customer Maintenance.

• The payment month will default. This tells CBP which Periodic Monthly Statement the entry should be placed on.

• The new payment types cannot be used for entry type 8 (NAFTA Duty Deferral) or 9 (Reconciliation).

• The new payment types cannot be used if there is a Census error on a file or if there are taxes associated with any tariff number used on a file.

2 Receive, process and print the Preliminary Periodic Daily Statement.

You will receive QR results for Preliminary Periodic Daily Statements and Final Periodic Daily Statements, in addition to Preliminary and Final Daily Statements.

The QR records for each are the same. A payment type indicator of 6, 7, or 8 on the B record for the transaction indicates that the statement is a Preliminary or Final Periodic Daily Statement.

Note: The check date for batch payments in the A/P file will be set based on how the PMS flags in the Company Control File are set (e.g., if the ACH debit should be done on the 15th working day of the month or on the 15th calendar day of the month).

3 As needed, remove entries before the final Periodic Daily Statement, using the Statement Delete/Update program.

For further information on how to remove entries using the Statement Delete/Update program, see the Statement Delete/Update section of the documentation.


PMS-5


Step Action Comment

4 Authorize the Periodic Daily Statement. This can be done using the ACH Payment Authorization program or the ACH Payment Authorization Selection program.

Preliminary Periodic Daily statements do have to be authorized on a daily basis. However, the associated duty payable records do not need to be relieved in AP, because CBP is not processing the ACH debit to take the money from the bank at the time the Preliminary Periodic Daily statement is authorized. That will not be done until after the Preliminary Periodic Monthly statement is processed by CBP (done once a month). In order to accommodate the need to authorize Periodic Daily Statements separately from relieving the duty payable records, the following changes have been made:

1. You will not be allowed to use the Check Scheduling by Vendor/Date program to schedule payment and do the authorization for Periodic Daily statements.

2. The ACH Payment Authorization program has been modified so that it can create the authorization for Preliminary Periodic Daily statements in addition to the authorization for regular Daily statements.

3. The Check Scheduling by Vendor/ Date program has been modified so that when it is used to schedule the payment for the Periodic Monthly statement, no QN Authorization records are created and sent to ABI.

5 Receive the Final Periodic Daily Statement. You will receive QR results for the Final Periodic Daily Statements, in addition to the Final Daily Statements.

Note: The check date for batch payments in the A/P file will be set based on how the PMS flags in the Company Control File are set (e.g., if the ACH debit should be done on the 15th working day of the month or on the 15th calendar day of the month).

6 As needed, remove entries before the Preliminary Monthly Statement.

Re-queue statement, as needed.

For further information on how to remove entries see the Statement Delete/Update program section of the documentation.


PMS-6


Step Action Comment

7 Receive, process and print the Preliminary Periodic Monthly Statement.

Re-queue statement, as needed.

You will receive Preliminary Periodic Monthly statements from CBP on or about the day of the month set up in the Prelm Monthly Date field (on the Import Information screen of Customer Maintenance) for entries processed the previous month. The Preliminary Monthly statement transaction lists all the Periodic Daily statements that are to be included on the Periodic Monthly statement, and the dollar amounts associated with them. You will print the Detail Periodic Monthly Statement Report and the Preliminary Periodic Monthly Statement Report using the data received in the Preliminary Periodic Monthly statement transaction.

8 Receive, process and print the final Periodic Monthly Statement.

You will receive Final Periodic Monthly statements from CBP on either the 15th calendar day or 15th work day of the month for entries processed the previous month. It is a final listing of all the Periodic Daily statements included on the Periodic Monthly statement and the dollar amounts associated with them. You will print the Final Periodic Monthly Statement Report and the Periodic Monthly Statement – Entry Summaries Deleted Report using the data received in the Final Periodic Monthly statement transaction.

You can request a reroute of Preliminary or Final Periodic Monthly statements by using the Reroute Request Statement/ ACH query program.


PMS-7


Overview of PMS Set Up

Overview The following maintenances must be set up for PMS before processing PMS statements.

• Company Control File Maintenance

• Customer Maintenance

• Entry Type Maintenance


PMS-8


Company Control File Maintenance

Overview Three new fields were added to the Company Control File Maintenance for PMS.

Auxiliary Control Parameters Screen 3:

PMS Fields � 17 PMS Final Work Days -- This field indicates whether the date when the ACH debit for the Periodic Monthly Statement will be done by CBP is the 15th calendar day of the month (blank or N) or the 15th working day of the month (Y).

Currently, the ACH debit is being done by CBP on the 15th calendar day of the month. However, legislation has been proposed that will modify this so that the ACH debit will be done on the 15th working day of the month.

If you are notified by CBP via ABI Administrative Message that the legislation has been passed which modifies this so that the ACH debit will be done by CBP on the 15th working day of the month, you should change this field to Y. Otherwise, it should be left blank.

� 18 PMS Stmt Del Passwrd – This field is used to store the password used by the Statement Delete/Update program when you are going to delete an entry off a statement making it a late payment.

• 19 Resend PMS Census Reject – This field lets the system know whether or not


PMS-9


entries sent with payment type 6, 7, or 8 that are rejected with census errors should be switched to a non-monthly statement type and resent automatically.

Note: When deciding whether or not to use this automatic resend feature, you should keep in mind that using it could result in a higher number of rejects. If the existence of a census error was not the only reason for the reject, the entry will be rejected again when it is resent with a non-monthly statement type.


PMS-10


Customer Maintenance

Overview Two PMS fields have been added to the Import Information screen of Customer Maintenance.

Customer Import Information Screen:

New Fields • 39 Prelim Monthly Date -- This field indicates the date that you will be receiving the preliminary periodic monthly statement for this importer. It will not allow values of greater than 11 or less than 2. The Shipment Header screen and the Statement Delete/Update programs will use this field to warn the user that a payment due date is greater than the PPMS date. The user will not be allowed to update the screen with a payment due date that would make the entry too late to be included on the designated month’s PPMS. Note: It is important that the importer let you know if they have changed this date in their profile with CBP. You must store the date in this field so that the Alliance programs can accommodate entries that might calculate a payment due date after this date.

� 40 Switch Pay Type – This field should be set to Y if you want to have the Release Date Update process and the EDI Update program automatically switch the payment type from a periodic statement to a non-periodic statement when the payment due date would end up being too late to be included on the designated month’s PPMS. If this field is set to N or blank, the payment due date will be backed up to a date that is one working day prior to the day you will receive the PPMS so that it can be included on the designated month’s PPMS.


PMS-11


Entry Type Code Maintenance

Overview In Entry Type Code Maintenance, the following field was added for PMS:

o Valid for PMS – There are two entry types that are NOT valid for Monthly Statements: 8 & 9.

Entry Type Code Maintenance screen 2:

08 Valid for PMS A Y or blank in this field indicates that this type of entry can be put on a Periodic Monthly Statement.


PMS-12


Shipment Processing – Shipment Header

Overview Fields on the Shipment Header screen of Shipment Processing have been added and modified to accommodate the Periodic Monthly Statements.

Shipment Header screen:

PMS Fields • 34 PayType -- This field has been modified to accept payment types 6, 7, and 8 If you enter payment type 6, 7, or 8, a Y defaults in the ACH field and the cursor goes directly to the Preliminary Statement Date field. After the date is defaulted or input, the statement month defaults into the Statement Month field. If a release date is entered, the field defaults to the release date month plus 1. If no release date is entered, the field defaults to the Payment Due Date month plus 1.

Note that the use of payment types 6, 7, and 8 is restricted by CBP in the following ways:

o Not allowed on entry types 8 and 9. A validation error will be generated on entry types that use payment type 6, 7, or 8 and are entry type 8 or 9.

o Not allowed on entries that include tax. After calculations are performed, the Entry Summary Queue Update screen will check for tax, and if it has been


PMS-13


calculated on an entry that is entry type 6, 7, or 8, a screen error will be generated.

o Not allowed on entries that are rejected with Census errors. A validation warning will be generated when an entry with a Census error from a previous transmission is sent to ABI again. If you have not addressed the Census error, you should change the entry to a non-monthly payment type.

You have the option of having the system automatically change the payment type to a non-monthly payment type (6 changes to 2; 7 changes to 3, and 8 changes to 5) when Entry Summary results are processed and a Census error is received. (See Company Control File Maintenance for more information about this option.)

o Not allowed on entries whose Account Of Customer is not part of CTPAT (Customs Trade Partnership Against Terrorism). You will not be allowed to input a payment type 6, 7, or 8 if the CTPAT flag in Customer Maintenance (Import Info screen) is not set to Y.


PMS-14


E/S ABI Queue Update Screen

Overview The Statement Branch Designation field has been moved from the ABI Options pop-up screen and added to the E/S ABI Queue Update screen. It still defaults the branch designation from User Class. In order to access the field, however, you must enter the field number, 08, into the ACTION field.

E/S ABI Queue Update screen:

Branch Designation • The cursor will not stop at this field when you are accessing the screen. In order to get to the field, you must enter the field number, 08, in the ACTION field. The branch designation is a special ABI setup by CBP to differentiate separate broker's offices located in the same district port.


PMS-15


Summary of New Tracing Dates

Overview Two tracing dates are related to PMS processing:

1. Date #99310 -- Preliminary Periodic Monthly Statement Receive date. A record for this receive date will be created in Shipment Dates when the ABI Update program processes Preliminary Periodic Daily Statements Results (MS).

2. Date #99311 – Final Periodic Monthly Statement Paid date. A record for this paid date will be created in Shipment Dates when the ABI Update program processes Preliminary Periodic Daily Statements Results (MS).


PMS-16


Shipment Tracing screens

Overview The Shipment Tracing screens have been modified to reflect the changes that have been made to the Shipment Processing screens to accommodate the Periodic Monthly Statements.

Tracing Entry Summary Header screen:

PMS fields Note on the Entry Summary Header screen the additions of the following fields:

o Periodic Statement Month,

o Single Payment Indicator,

o Periodic Daily Statement number, and

o Periodic Monthly Statement number fields.


PMS-17


Summary of PMS Validations

Overview The following validations are related to Periodic Monthly Processing:

1. Validation #240 -- On files using payment type 6, 7, or 8, if the Valid for PMS field in Entry Type Maintenance is set to N for the file’s entry type, the following validation error will result: “Payment type 6, 7, 8 invalid for entry type”.

2. Validation #241 – On files using payment type 6, 7, or 8, if the Census Warning field on Shipment Header is set to Y, the following warning will result: “File has Census warning, check payment type”.

3. Validation #242 – If the payment due date on the Shipment Header screen is not at least one day prior to the PPMS date, the program will generate the following fatal validation error: “Payment due date is later than prelim monthly statement date.”

4. Screen check -- A new screen check has been added to the Entry Summary Queue Update screen. If an entry that calculates tax uses payment type 6, 7, or 8, the following error message will display: “*E* Payment type 6, 7, 8 not valid on entry with Tax.” If you get this error you will not be allowed to transmit the entry to ABI.


PMS-18


Check Scheduling by Vendor/Date

Overview The Check Scheduling by Vendor/Date program has been modified so that you cannot use it to schedule payment and do the authorization for Periodic Daily statements. Also, if it is used to schedule the payment for the Periodic Monthly Statement, no QN Authorization records are created and sent to ABI.

Check Scheduling by Vendor/Date screen:

Field Modifications ACH Statement Number -- The ACH Periodic Statement number must be a valid statement number. If you enter a statement number that is flagged as a payment type 6, 7, or 8, and the Daily or Monthly flag is set to D, you will get an error message (“Periodic Daily Statements cannot be scheduled/authorized using this program”).


PMS-19


A/P Inquiry (by Statement Number)

Overview The Statement Number changes once the Monthly Statement has been received. The statement number displayed is the Daily Statement number until the monthly statement is received. At that time it changes to the Monthly Statement number. When doing an A/P Inquiry by Statement (Option 8), you must enter the monthly statement number once the preliminary periodic monthly statement has been received.

A/P Inquiry screen:

Statement • The statement number requested is the Daily Statement number until the monthly statement is received. At that time it changes to the Monthly Statement number.


PMS-20


Statements Inquiry program

Overview PMS fields in Statements Inquiry are as follows:

• Payment Type – This field was modified to allow new payment types of 6, 7, and 8.

• Periodic Daily/Monthly – This new field accepts (D)aily or (M)onthly or (if this is not a periodic statement).

• Monthly Statement – This new field indicates on what periodic monthly statement number a periodic daily statement is included.

Statements screen:

PMS Fields • 06 Payment Type – This field will accept the following payment types: 2, 3, 5, 6, 7, & 8.

• 13 Periodic Daily/Monthly – This field has been modified to accept D for Daily, M for Monthly for a periodic statement, or if this is not a periodic statement.

• 14 Monthly Statement – This field indicates the monthly statement number that a Periodic Daily Statement is included on. However, if the statement entered in field 01 is a Periodic Monthly Statement or a non-periodic Daily Statement, then this field will be blank.


PMS-21



PMS-22


Statement Delete/Update program

Overview • Fields added or modified:

o File Number – This new field allows you to be able to find the statement by file number. Input is optional – you can skip the field and enter the filer code/entry number if you would like.

o Payment Type – This field now accepts payment types 6, 7, and 8.

o Payment Month – The cursor will only stop at the Payment Month field if the Payment Type is 6, 7, or 8. This field identifies the payment month for payment types 6, 7, and 8.


PMS-23


Statement Delete/Update

Overview The Statement Delete/Update program lets you change the status of an entry.

The program can be accessed from the ABI Queries menu.

How to Use this Program Use the Statement Delete/Update Query to change the status of an entry summary as it appears on the Daily Statement. The Statement Delete/Update program provides you with the following capabilities:

• Change the method of payment for an entry from a single payment to a batch statement payment, either to a Periodic Daily Statement (types 2, 3, or 5) or to a Periodic Monthly Statement (types 6, 7, or 8).

• Delete an entry from a statement that has not been paid yet (change the payment type from 2, 3, 5, 6, 7, or 8 to 1.

• Moving an entry from one statement to another, in a two-step process.

1. Remove the entry from the current statement.

2. The next day, add it to the new statement.

Note on removing an entry from a Periodic Monthly Statement: You must remove it from the Periodic Daily Statement that it is on. If the Final Periodic Daily Statement has already been generated, the


PMS-24


entry can still be removed, but it must now become a single pay item (payment type 1), and cannot be added to any other statement. If 10 working days have elapsed since the release date, the entry will also be considered a late payment. If a password has been set up in Company Control Maintenance (Auxiliary Control Parameters Screen 3), you will be prompted to enter a password in order to continue.

Note on adding an entry to a Periodic Monthly Statement: Because a Periodic Monthly Statement consists of a list of Periodic Daily Statements, in order to add an entry to a Periodic Monthly Statement, you must add the entry to a Periodic Daily Statement that has not yet been ACH authorized and that will be included on that Periodic Monthly Statement.

• Moving an entry in one step: In order to move to move an entry to a different Periodic Monthly Statement in one step, go to the Payment Type field and enter a new Payment Type. Then, change the Payment Date to the date you want. The screen will not allow a date to be entered that has already passed and it will not allow a date to be changed if the Preliminary Periodic Daily Statement has already been generated for the file. You cannot move an entry if the Preliminary Periodic Daily Statement has been received.

• Change the payment due date (Date #42) to a different date before a Preliminary Statement has been transmitted to the client. After entering the entry number, you must change the Payment Type and then enter a new payment due date. [The program will check to be sure that the new payment due date is more than 10 days from the release date].

Special Warning 1. You may not delete an entry from Statement Processing until the Entry Summary has been accepted.

2. You may not remove an entry from a Statement that is due to be paid on the current date.

Procedure To request that an entry be removed from a statement, follow the steps below.

Step Action Results

1 Press ENTER to accept the priority of 4.

2 Either enter the File Number or enter your broker file code and the entry number in the Filer Code and Entry Number fields.

• Do not insert a hyphen preceding the check digit.

Example: If your entry number is XB2-1010923-6, enter it as “10109236”.

This is the entry you would like to have removed from the Statement.

If the program finds the entry, the cursor will drop to the ACTION field.


PMS-25


Step Action Results

3 At the ACTION field, enter 06 to go to field 06, then do the following:

To change the Payment Type, enter a new Payment Type code.

To change the Payment Date, press ENTER to skip the Payment Type field and at the Payment Date field, type in the new payment date.

To change the Payment Month, skip to the Payment Month field and type in the new payment month.

You can change the status of an entry summary in one of five (5) ways:

1. Remove the entry summary from statement status by changing the payment type to "1".

2. Change the payment type from a broker statement (type "2" or “6”) to an importer statement (type "3", "5", “7” or “8”), and vice versa.

3. Change the date US CBP expects payment (i.e., the payment date). The new payment date can be before or after the original date, however, it must be no earlier than tomorrow.

4. Change a non-statement entry to a statement entry by sending a payment due date and payment type of "2", "3", "5", “6”, “7”, or “8”.

5. Take an entry off a preliminary statement and put it on a future statement.

To change the payment due date, enter a date that is less than 10 working days from the release date.


PMS-26


ACH Payment Authorization Selection by Date

Overview This is a new program that allows you to authorize many statements at once, regardless of whether they are Daily or Periodic Daily Statements. The difference between this program and the ACH Payment Authorization program is that in the ACH Payment Authorization program, you must enter the statement number and you can only do one statement at a time. The Authorization Selection by Date program will find all the statements for a given Statement Print Date and allows you to select all the statements you want to authorize from that group.

ACH Payment Authorization Selection screen:

Procedure To authorize a group of statements, fill out the screen as described in the table below. Note that if there are more than 15 statements and all the lines on the screen are filled, you must enter U to update the screen and move on to the next screen of statements. An advertisement will display at the bottom of the screen indicating how many statements were found for the date you entered.

Note: If an S displays in the column between the SEL and Statement columns, it indicates that the statement has already been selected and sent, but that no results have been returned from Customs. When the results have been accepted, the S will change to a Y and the item will no longer display for selection.


PMS-27


Field Name Data Entry Description

01 Statement Print Date

Enter the statement print date. Only daily statements that have not already been authorized will display on the screen.

02 Branch Code Enter the branch code or you can skip the field if you do not want to limit the statements to a particular branch.

03 Priority Press enter to accept the default value of 4.

Sel Enter Y to select (authorize) the statement for payment. Leave the field blank or enter N to skip the statement and prevent selection of the statement.

Statement Not data entry allowed. The statement number will display in this column.

Note: If there are more than 15 statements that meet the criteria and display on the screen, a note will display to let you know that more statements exist for this date. You can press ENTER to see more statements.

Tp No data entry allowed. The following type codes will display in this column:

D = Daily Statement

PD = Periodic Daily Statement

Customer No data entry allowed. This is the customer associated with the statement. If the field is blank, the broker is the customer.

Payer Unit No No data entry allowed. This is the payer unit number for the statement.

Pay Typ No data entry allowed. This is the payment type for the statement (e.g., 2, 3, 5, 6, 7, or 8).

Filer No data entry allowed. The filer code will display in this column.

Amount No data entry allowed. The duty amount to be paid will display in this column.

ACTION Enter SEL to cause the cursor to go to the Sel field for the first statement on the screen.

When you are done selecting statements, type U (update the screen) to create the authorization transactions.

You must update the screen in order to trigger the program to create the authorization transactions for the statements selected on the screen.

If there are more than 15 statements to update, first update the screen, then the program will re-display with the additional statements.


PMS-28


Periodic Daily Statement Status Report

Periodic Daily Statement Status Report

Overview The Periodic Daily Statement Status Report indicates whether ACH periodic daily statement authorization was accepted for payment. Related error messages will print, if applicable. If the record identifies a data as accepted, it means that the payment authorization record for the preliminary daily statement has been accepted for payment.

If a record does not indicate an accepted date, it means that the payment authorization record was not accepted for payment. If not accepted, error message(s) will be provided showing the reason(s) for non-acceptance.

Procedure To print the Periodic Daily Statement Status Report, answer the fields, as follows:


Update Periodic Monthly Statement

(Y/N)

Enter Y if you would like to update the periodic monthly statement with the authorized preliminary periodic daily statement data.

This field gives you the option of having the program update the periodic monthly statement with the authorized preliminary periodic daily statement data.


PMS-29



Enter N if you would like to just print the listing.

Listing (Y/N) Enter Y to print the report. If you enter N the records will be processed, but no report will print.

For Reprints Enter Y

Press ENTER or enter N to skip the reprinting function. Enter Y only if you would like to reprint the report.

You have the option of reprinting records that have already been printed/faxed.

As of Date If you are reprinting a statement, you must enter an “as of” date.

The As of Date and As of Time allow you to limit the amount of data that will print on the report.

As of Time If you are reprinting a report, you must enter an “as of” time.


Periodic Monthly Statements (PMS)

PMS-30


Sample Periodic Daily Statement Status Report:

Company 1, Division 1-------------* Periodic Daily Statement Report ABPZRLST-DO-07/06/04 Page: 1Date: 07/06/2004 Time: 11:20

Statement Payment Payment DateStatement # Filer Filer Amount Accepted Message # Message----------- --------- ------- ------------- -------- --------- ------------------------03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED03939393939 XB2 500.00 05/13/04 Q11 PAYMENT ACCEPTED

PMS-Reroute Periodic Monthly Statements

PMS-31


Reroute Request Statement/ACH Transaction Query

Reroute Request Statement/ACH Transaction Query

Overview The Alliance ABI System provides you with the capability to request the reroute of Daily and Periodic Monthly Statements and ACH Payment transactions. Through this facility, you can request that Customs reroute Daily and Periodic Monthly Statements and ACH authorizations electronically, avoiding the need to call your Client Rep.

[This feature is in accordance with Customs Admin # 01-0423.]

Note: Once a Daily or Periodic Monthly Statement or ACH Payment Authorization has been successfully rerouted, the date and time will be updated to Shipment Notes.

You will use this Reroute Request Statement/ACH Trans Query screen to create the query for Customs indicating which Daily or Periodic Monthly Statement(s) or ACH Payment Transactions you want to request rerouting. The Query program can be accessed from the ABI Queries menu.

Procedure To complete the Reroute Request Statement/ACH Trans Query screen, fill out the fields, as described below.


PMS-32



01 Priority Ipress ENTER for 4 or enter a priority number (between 1 and 4).

This field defines the priority for the query request.

02 Periodic Monthly Statement (Y/N)

Enter Y if you are rerouting a Periodic Monthly Statement.

Press ENTER or type N if this is not a Periodic Monthly Statement.

This field indicates whether or not this is for a Periodic Monthly Statement.

03 (P)relim/ (F)inal/ (A)CH Payment

Enter P if this is a Preliminary Monthly Statement.

Enter F if this is a Final Monthly Statement.

Enter A if his is an ACH Payment.

This field indicates whether the transaction being requested is a Preliminary statement, a Final statement, or an ACH payment authorization. If you answered Y to the Periodic Monthly Statement question, this field will only accept P or F.

04 Statement Number

Enter the statement number being requested.

If you do not know the statement number, enter ? (question mark) to access the Statement Search screen. Press ENTER to skip the field.

If the Statement is older than 14 days, a message will display on the screen:

* E * Statement older than 14 days

If a ? (question mark) is entered, the Statement Search screen will display.

05 (A)ll Documents Press ENTER to leave the field blank.

Enter A if you want to receive all documents for all ports in the receiver district port.

If you enter A, the Processing District Port field will be skipped. If you press ENTER to skip the (A)ll Documents field, the cursor will stop at the Processing District Port field.

Processing District Port

Note: The cursor will only stop at the Processing District Port field, if you skipped the (A)ll Documents field above.

Enter a valid district port code or leave the field blank.

Note: This field is for the Processing District Port, not the Port of Entry.

06 Transmission Date

This is a required field. If you entered a statement number, the transmission date will default.

If you did not enter a statement number, you may press ENTER to accept the default transmission date of the system date or you may enter a transmission date.

Note: If you enter a date and the date is more than 14 days in the past, an error message will display:

* E * Transmission date cannot be more than 14 days in the past.

If a statement number was entered the program will check the statement status of the statement to determine what date to default. If the statement status is (P)reliminary or blank, the default date will be the payment due date. If the statement status is (F)inal, the default date will be the date the statement was received.


PMS-33



07 Customer Note: The Customer field will be skipped if this is an ACH transaction.

If no statement number was entered above, you may enter a Customer code that is set up for importer statements or leave this field blank.

If you do not know the customer code, type ? (question mark) to access the Customer Search screen to look up the Customer code.

If you enter a Customer code whose account is not set up for importer statements, the program will display the following message:

Customer not set up for importer statements.

The program will display the IRS number of the customer code entered.

08 Branch Designation

Note: The Branch Designation field will be skipped if this is an ACH transaction.

If a statement number was entered above, press ENTER to accept the default ABI Branch Designation.

The branch designation is a special ABI setup by Customs to differentiate separate broker's offices located in the same district port.

ACTION In the ACTION field, update and save the screen.

When the query file is built, if a statement number was entered that exists, the Preliminary Rerouted Date or the Final Rerouted Date field of ABI Statements will be updated.


PMS-34


Statement Search Screen:

Overview You will use this Statement Search screen to do a search for a particular statement. To access this Search screen, type ? (question mark) in the Statement No field.

Procedure To do a search of the Statements on file, fill out the fields on the screen as indicated below.


Search Type Enter C or H. Enter C to search for a code or string. Enter H to view the help text for the Customer field on the previous screen.

You have access to the search function (C) or the field-level help text (H).

Statement No If you entered C, the cursor will stop at the Statement No field first. You can enter a statement number or press ENTER to skip the field.

You have the option of searching for a specific statement number.

Customer If you entered C and skipped Statement number, you can enter a customer code or press ENTER to skip the field.

You have the option of searching for a specific customer code.

IRS No If you entered C and skipped the Statement No and Customer code fields, you can enter an IRS number or press ENTER to skip the field.

You have the option of searching for a specific IRS number.


PMS-35



Port If you entered C and skipped the Statement No, Customer code, and IRS No fields, you can enter a port code or press ENTER to skip the field.

You have the option of search for a specific Port. If you pressed ENTER through all the fields, the search will begin with the first statement in the file.


PMS-36


Reroute Periodic Monthly Statements

Reroute Periodic Monthly Statements

Overview You will use this Reroute Periodic Monthly Statements Report screen to request to print a listing of rerouted Periodic Monthly Statements.

Procedure To complete the Reroute Periodic Monthly Statements Report screen, fill in the fields as follows.


Listing (Y/N) Enter Y to print the report. If you enter N the records will be processed, but no report will print.

For Reprints Enter Y

Press ENTER or enter N to skip the reprinting function. Enter Y only if you would like to reprint the report.

You have the option of reprinting records that have already been printed/faxed.

As of Date If you are reprinting a statement, you must enter an “as of” date.

The As of Date and As of Time allow you to limit the amount of data that will print on the


PMS-37



report.

As of Time If you are reprinting a report, you must enter an “as of” time.


Reroute Request Statement/ACH Trans

PMS-38


Reroute Periodic Monthly Statement Status Report:

Non-border Tradepoint Systems LLC ABI Report Status List ABMSTLST-D0-05/14/04 Page: 1

Date: 06/14/2004 Time: 10:16

Record Type Error Code Message Tot Reroutes

----------- ---------- ------- ------------

QX MS1 Trans Dt of Stmt Beyond 14 Days 1