External Payments Import


External Payments


Setup > Imports > External Payments Import

External payments can be imported to SGA for the purpose of check clearing. The payment can be import files from systems like payroll. 

 Name: The name that will be displayed as the name of the import.

General

Connector type: See import connections for help with setting up a connection to a file to import.

Connection string: See import connections for help with setting up a connection to a file to import.

Reference columns by: See import connections.

Use schema: In certain situations, the import setup may require a way to name the individual items being imported and/or the type of information (text, decimal, etc.) contained in each column.

Command text: When the Connection string is defined, the Commend text will be defaulted to select all items from the external file. The Command text can be modified when there are situations that require the information from the file to be manipulated in some way in order to obtain certain results. An example of this would be when multiple columns from the external file need to be combined into one item to be used as a transaction comment. Another example would be if the information from the external file needs to be sorted or subtotaled in order to create a batch with fewer, or more meaningful, transactions. For additional information on this feature, please contact SGA support.

Setup

Checkbook: Enter the checkbook to be associated with the payments. 

Columns

From Column: Add lines for each external column you wish to import.  "From Column" is the column name or number on the external file; see “Reference columns by” above. 

To Column: Click on the drop down arrow to select the SGA item that matches what is listed in the From Column. The available columns are:

Column Name

Required

Comments

Payment

No

This identifies check number of the payment. If no check number is specified, a unique number consisting of the batch and auto-assigned sequence will be generated.

Employee ID

No

If the payment is associated with an employee, the employee ID can be specified for informational purposes only. The ID will display in the Vendor column of the Check reconciliation.

Payment Type

No

CC = Computer Check, CM = Manual Check, CU = Unused Check, EC = Computer EFT, EM = Manual EFT

Amount

Yes

Amount of the payment

Account

No

If specified, the account listed will be used to determine the checkbook to assign the payments to. A single file can contain payments for multiple checkbooks based on the GL Account. If no account is specified, the payments will be assigned to the checkbook selected on the Setup tab.

Status

No

If none specified then the checks will be marked as outstanding. Valid codes are O = Outstanding, C = Cleared, V = Void, R = Reversal

Date

No

Date of the Payment. If none specified the date of the import is used.

Source

No

The Source Code for the payment. If specified, this can be used for sorting or selecting the payments in the bank reconciliation process.

Clear Date

No

If the payment has already been cleared, enter the date

Employee Name

No

Name associated to the payment