External Payments
Settings > Accounts Payable > 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 |