IMPORTANT

Avoid using commas, double quotation marks, carriage returns, line feeds, dollar signs and other special characters when entering values in the spreadsheet. Once all values are entered, save the file as a “CSV (comma delimited).”

Column

Column Value

Description

CSV Format Identifier

Add only one .CSV Format Identifier line per import file

A

“MSS001”

Cell “A1” reserved for format identifier. “MSS001” format is the only identifier currently supported.

Header Record

Add only one Header Record line per import file

A

{blank}

Rows containing anything other than a letter “D” or “H” will be ignored by the import process. Use these lines to enter comments as needed.

A

“H”

Enter a single, uppercase letter “H” to signify the beginning of lone Header Record.

B

System Data Type

Enter the name of the data type that corresponds to this batch record (up to 64 characters). The value entered here need to match a Name value for a data type of “Statement” within the XML System Data Type Map section in XML System Setup for the appropriate Interface.

C

Agent ID

Enter the providing agent identification number as defined within Agent Setup as the Agent ID (up to 10 characters).

NOTE: Either the Agent or Branch ID must be specified.

D

Branch ID

Enter the identifier of the branch processing this payment as defined as the Branch ID field in Branch Setup (up to 5 characters).

NOTE: Either the Agent or Branch ID must be specified.

E

Deposit Date

Enter the date that the batch was deposited (in MM/DD/CCYY format).

F

Batch Amount

Enter the positive dollar amount of this batch.  This is the total of all payments specified for all Detail Records associated to this batch.

G

Batch Description

Enter the identification description of this batch record (up to 128 characters). The description is the primary identifier within Payment Management, therefore it is important that you can readily discern one batch from another.

H

Auto Apply

This flag instructs MoversSuite to turn on auto applying for this import. When this flag is set, Auto Apply Options are enabled and accessible through the Statement Import Summary.

To turn Auto Apply on, enter a “Y” in this column. Clear this field to turn off Auto Apply.

NOTE: Default auto apply options are set for each user through Import Auto Apply Options.

Detail Record

One or more Detail Records can be included in a single file

A

{blank}

Rows with nothing set for column “A” are ignored when the record is imported. Use these lines to enter comments as needed.

A

“D”

Enter a single, uppercase letter “D” to signify the beginning of each Detail Record line.

B

Payment Date

Enter the payment date for this record (in MM/DD/CCYY format).  The Payment Date needs to match the Deposit Date.

C

Order Number/GBL Number

Enter the MoversSuite Order Number or the GBL Number (set within the Military/Government tab) associated to the transaction (up to 23 characters for an Order Number and up to 16 characters for a GBL Number).

This value is needed to identify the correct MoversSuite record to update. If data is not set within this column, then the application attempts to locate the record based on the Invoice Number (see description below).

D

Description/Shipper

Enter the transaction description for this record or the name of the shipper (up to 128 characters for transaction description or 26 characters for a shipper name).

For a Cash Receipt import file, enter the name of the payor.

The value of this field is only referenced in the cases where the import process is unable to determine the data based on the Order Number/GBL Number.

E

Service Code

Enter the code needed to identify how to process the settlement transaction in MoversSuite (up to 10 characters).

If this Service Code matches a record defined within Service Code Setup, then MoversSuite attempts to auto-apply the item when imported. Otherwise the Service Code is informational only (not tied to an Item Code).

F

Payment Type

The Payment Type entered here is used to identify the transaction type and must match a record defined within Statement Payment Code Setup. See Generic Import Setup for more information (up to 26 characters).

G

Payment Amount

Enter the dollar amount of this deposit transaction.  The total amount for all detail payment amounts must add up to the Batch Amount specified in the Header Record.

For a Cash Receipt import file, the Payment Amount must be a positive dollar amount.

H

Driver Number

Enter the identification number for the driver associated to this payment record, typically a chargeback or manual statement (up to 15 characters).

This value is set for drivers in MoversSuite through the Driver Number field (Dispatch tab) in Personnel Setup.

I

Customer Number

This is the identification for the customer associated to the item, if available (up to 15 characters). Set this column to assist in auto applying the imported record.

Refer to Import Auto Apply Options for more information.

NOTE: Customer is set for an order through Billing Information and Billing Information (Revenue Entry).

J

Invoice Number

Set this column to the MoversSuite Invoice Number, if available (up to 20 characters). Supplying the invoice assists in auto applying the imported record. Refer to Import Auto Apply Options for more information.

If the Order Number/GBL Number is not set, then the application requires the Invoice Number to identify the MoversSuite record.

NOTE: View invoices of an order through the Summary tab.